Maybe compiler from sqlalchemy can help me? from sqlalchemy.sql import compiler from sqlalchemy.sql.expression import text t = text(st) c = compiler.SQLCompiler(db.engine.dialect, t)
and now I don't know how pass the params dict to compiler. Thanks. On Fri, Oct 21, 2011 at 6:40 PM, Michael Bayer <mike...@zzzcomputing.com>wrote: > > On Oct 21, 2011, at 10:30 AM, lestat wrote: > > > > > If I do > > result = st % params > > don't do that (where "that" is, using the "%" operator). Use bound > parameters. Your DBAPI (I'm assuming psycopg2 here) will then format the > value correctly. > > > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@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. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@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.