On Mon, May 17, 2010 at 9:32 AM, Michael Bayer <mike...@zzzcomputing.com> wrote: > > On May 17, 2010, at 10:14 AM, Jon Nelson wrote: > >> On Mon, May 17, 2010 at 8:58 AM, Michael Bayer <mike...@zzzcomputing.com> >> wrote: >>> it is here: >>> >>> http://groups.google.com/group/sqlalchemy/browse_thread/thread/7f950b628d7ebee5/4421b272d4c7f91f >>> >>> >>> let me add that to the wiki >> >> The part about the thread that worries me a bit is this: >> >> "(%s)" % ", ".join(repr(elem) for elem in tup) >> >> Is there a way to do this using the same parameter escaping mechanism >> that the rest of SA uses? >> The repr() seems a bit off to me here. >> >> Of course, being able to specify the names of columns would also be >> nifty - while it's nice to rely on "column1", "column2" it's also nice >> to get in your result sets the names that one might prefer. > > > The "escaping" mechanism you speak of is native to the DBAPI, in your case > psycopg2. I don't believe it has a public API.
Exactly. > We have a slightly better escaping mechanism embedded in the compiler for > usage with databases that don't allow binds everywhere in the statement. > But we have avoided having to build our own "escapers" for a very long time > now as it is a contentious area. Hmm. Is there a way to make the VALUES stuff avoid escaping anything and use the existing interpolation (and escaping) mechanism? -- Jon -- 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 at http://groups.google.com/group/sqlalchemy?hl=en.