[sqlalchemy] How to get literal default column values?

2011-11-04 Thread Roger Hoover
Hi, I'm trying to use the sqlalchemy compiler to generate insert statements that I can feed myself to MySQLdb. With a sqlalchemy table definition, I'm able to get a nice SQL statement using the following. query =

[sqlalchemy] Re: How to get literal default column values?

2011-11-04 Thread Roger Hoover
not in kwargs: kwargs[col] = default.arg On Fri, Nov 4, 2011 at 3:19 PM, Roger Hoover roger.hoo...@gmail.com wrote: Hi, I'm trying to use the sqlalchemy compiler to generate insert statements that I can feed myself to MySQLdb. With a sqlalchemy table definition, I'm able

Re: [sqlalchemy] How to get literal default column values?

2011-11-04 Thread Roger Hoover
On Fri, Nov 4, 2011 at 3:57 PM, Michael Bayer mike...@zzzcomputing.comwrote: On Nov 4, 2011, at 3:19 PM, Roger Hoover wrote: Hi, I'm trying to use the sqlalchemy compiler to generate insert statements that I can feed myself to MySQLdb. With a sqlalchemy table definition, I'm able

Re: [sqlalchemy] Getting float back from select when asdecimal is True (version 0.6.6)

2011-01-17 Thread Roger Hoover
This is my fault. The schema for my unit test DB has this column as DOUBLE, where as my main DB was DECIMAL. Sorry to waste your time. It's working correctly now. On Mon, Jan 17, 2011 at 11:16 AM, Michael Bayer mike...@zzzcomputing.comwrote: Check your version of MySQLdb. MySQLdb returns