Ksenia ha scritto:
I am not sure about identity setting, but you can see al application
queries by changing some database parameters in the config file.
For SQLObject, add debug=1 at the end of connection string:
sqlobject.dburi="postgres://@/mydb?debug=1"
For SQLAlchemy:
sqlalchemy.echo = 1
HTH
Ksenia.
I tried using sqlalchemy.echo = 1
and sqlalchemy.echo = 0
and the output is the same all the time ... and the only query that I
see this one...
2007-01-08 17:23:03,539 sqlalchemy.pool.QueuePool.0x..54 INFO Connection
<connection object at 0xb68e87a0; dsn: 'dbname=sf host=localhost
user=myname password=mypass', closed: 0> checked out from pool
2007-01-08 17:23:03,540 sqlalchemy.engine.base.Engine.0x..14 INFO SELECT
visit.visit_key AS visit_visit_key, visit.expiry AS visit_expiry,
visit.created AS visit_created
FROM visit
WHERE visit.visit_key = %(visit_visit_key)s ORDER BY visit.visit_key
2007-01-08 17:23:03,541 sqlalchemy.engine.base.Engine.0x..14 INFO
{'visit_visit_key': }
2007-01-08 17:23:03,543 sqlalchemy.pool.QueuePool.0x..54 INFO Connection
<connection object at 0xb68e87a0; dsn: 'dbname=sf host=localhost
user=myname password=mypass', closed: 0> being returned to pool
2007-01-08 17:23:03,545 sqlalchemy.pool.QueuePool.0x..54 INFO Connection
<connection object at 0xb72e3020; dsn: 'dbname=sf host=localhost
user=myname password=mypass', closed: 0> checked out from pool
2007-01-08 17:23:03,546 sqlalchemy.engine.base.Engine.0x..14 INFO SELECT
visit_identity.visit_key AS visit_identity_visit_key,
visit_identity.user_id AS visit_identity_user_id
FROM visit_identity
WHERE visit_identity.visit_key = %(visit_identity_visit_key)s ORDER BY
visit_identity.visit_key
LIMIT 1
2007-01-08 17:23:03,547 sqlalchemy.engine.base.Engine.0x..14 INFO
{'visit_identity_visit_key': '080a6a16713f251d5dc993decdd185fa73ade75b'}
2007-01-08 17:23:03,549 sqlalchemy.pool.QueuePool.0x..54 INFO
Connection <connection object at 0xb72e3020; dsn: 'dbname=sf
host=localhost user=pp password=pp', closed: 0> being returned to pool
2007-01-08 17:23:03,563 sqlalchemy.orm.unitofwork.UOWTransaction.0x..b4
INFO Task dump: None
2007-01-08 17:23:03,567 sqlalchemy.orm.unitofwork.UOWTransaction.0x..b4
INFO Execute Complete
10.0.0.5 - - "POST /login HTTP/1.1" 403 4236
"http://10.0.0.114:8001/login"; "Mozilla/5.0 (X11; U; Linux i686; it;
rv:1.8.0.7) Gecko/20060921 Ubuntu/dapper-security Firefox/1.5.0.7"
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
