print executed query

[someone]

On 4 Mai, 07:01, Fred C <f... at 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.