it occurs upon execution. Ultimately the cursor.execute() method described here: http://www.python.org/dev/peps/pep-0249/
within SQLAlchemy, the general idea is here: http://www.sqlalchemy.org/docs/core/tutorial.html#using-text so, you'd add your params as second arguments to text(). But you'll never see the date actually rendered in the SQL string unless you look at your Postgresql server logs. On Oct 21, 2011, at 10:47 AM, Alex K wrote: > 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. -- 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.
