On 4 Mai, 07:01, Fred C <f...@bsdhost.net> wrote: > On Apr 29, 2010, at 9:49 AM, Philip Semanchuk wrote: > > > > > > > On Apr 29, 2010, at 12:01 PM, someone wrote: > > >> Hello! > > >> Is there a way to print a query for logging purpose as it was or will > >> be sent to database, if I don't escape values of query by myself? > > >> cursor.execute(query, [id, somestring]) > > >> I could print query and values separate, but it would be great, if I > >> could see how query is constructed and can the also copy it and > >> execute in console. > > >> Im using psycopg2, btw > > > If you can fiddle with the Postgres server settings, the server has options > > for logging lots of things, including the queries it executes. > > > Hope this helps > > Philip > > > -- > >http://mail.python.org/mailman/listinfo/python-list > > smime.p7s > 4KAnzeigenHerunterladen
Hello! Thanks for help! I've found much more simpler solution ;) http://initd.org/psycopg/docs/cursor.html query Read-only attribute containing the body of the last query sent to the backend (including bound arguments). None if no query has been executed yet: >>> cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)", (42, 'bar')) >>> cur.query "INSERT INTO test (num, data) VALUES (42, E'bar')" DB API extension The query attribute is a Psycopg extension to the DB API 2.0. -- http://mail.python.org/mailman/listinfo/python-list
