Re: [sqlalchemy] Always Render Binds Inline

2015-01-14 Thread Jonathan Vanasco
On Tuesday, January 13, 2015 at 8:12:49 PM UTC-5, Michael Bayer wrote: If you really want to disable bound parameters there’s a flag “literal_binds” that’s on Compiler, but it isn’t going to work for things like dates unless you implement renderers for them. IIRC, `literal_binds`

Re: [sqlalchemy] Always Render Binds Inline

2015-01-14 Thread Michael Bayer
the last resort is that you build some kind of stored procedure of your own which does this, from a datatable of some kind; essentially build yourself a sequence. Lycovian mfwil...@gmail.com wrote: Yep, terrible, there is not function to return this value similar to MySQL and as Teradata

[sqlalchemy] Always Render Binds Inline

2015-01-13 Thread Lycovian
The Teradata ODBC driver is capable of returning the lastrowid inserted on an identity column if the appropriate ODBC.INI setting is enabled. Unfortunately, for some reason, this functionality only works if the query doesn't have bind parameters. Sigh. It not what I want to do but is it

Re: [sqlalchemy] Always Render Binds Inline

2015-01-13 Thread Michael Bayer
that’s kind of awful, and I think you might want to look into getting at “lastrowid” manually, there is usually a function you can execute like “scope_identity()” that can give it to you, usually as a second SELECT. these are easy to integrate into dialects. If you really want to disable