[sqlalchemy] Re: Database Reflection - Forcing column names to be lowercase?

2011-01-12 Thread Harkirat
way to *map* the columns with custom names though.  If you're mapping, you'd use a function to generate a new properties dictionary like the one athttp://www.sqlalchemy.org/docs/orm/mapper_config.html#attribute-names On Jan 11, 2011, at 3:47 PM, Harkirat wrote: Hi

[sqlalchemy] Generating Raw SQL statements with parameters included

2011-01-11 Thread Harkirat
Hi All, DELETE FROM appname WHERE appname.appid = ? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to

[sqlalchemy] Generating Raw SQL statements with parameters included

2011-01-11 Thread Harkirat
Hi All, DELETE FROM appname WHERE appname.appid = ? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to

[sqlalchemy] Generating Raw SQL statements with parameters included

2011-01-11 Thread Harkirat
! Harkirat -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group

[sqlalchemy] Re: Generating Raw SQL statements with parameters included

2011-01-11 Thread Harkirat
which has a level of disclaimer I think will be OK, which you can see athttp://www.sqlalchemy.org/trac/wiki/UsageRecipes/BindsAsStrings. On Jan 11, 2011, at 10:14 AM, Harkirat wrote: Hi All,     When I run this delete_stmt = appname.delete(appname.c.appid==1) print delete_stmt

[sqlalchemy] Database Reflection - Forcing column names to be lowercase?

2011-01-11 Thread Harkirat
Hi, Is there any way that anyone knows of to force the column names to be lowercase when reflecting the schema from the database for e.g. appname = Table('appname', metadata, autoload=True) Other posts suggested overriding the database schema with your own but I would rather use SQLAlchemy's

[sqlalchemy] Re: Generating Raw SQL statements with parameters included

2011-01-11 Thread Harkirat
config so my logs shows every sa query and results two times. 11-01-2011 19:12, Harkirat yazmış: Thank you! I understand the security concerns. I only need this for testing purposes and production will be all bind-parameter driven. On Jan 11, 11:15 am, Michael Bayermike