I'm in the need to modify th Visit tables and i want to undestand
their defaults before messing around and I found this weird

I set debug on SQLObject's query string and ran tg-admin shell so I
get this output.

>>> Visit.select()
<SelectResults at -48c422d4>
>>> list(Visit.select())
 1/Select  :  SELECT visit.id, visit.visit_key, visit.created,
visit.expiry FROM visit WHERE 1 = 1
 1/QueryR  :  SELECT visit.id, visit.visit_key, visit.created,
visit.expiry FROM visit WHERE 1 = 1
 1/COMMIT  :  auto
[]
>>> list(VisitIdentity.select())
 1/Select  :  SELECT visit_identity.id, visit_identity.visit_key,
visit_identity.user_id FROM visit_identity WHERE 1 = 1
 1/QueryR  :  SELECT visit_identity.id, visit_identity.visit_key,
visit_identity.user_id FROM visit_identity WHERE 1 = 1
 1/COMMIT  :  auto
[]

I double check that my visit haven't expired so I reload my browser
where the log outputs this.

127.0.0.1 - user1 "GET /static/images/tg_under_the_hood.png HTTP/1.1"
200 4010 "http://localhost:8080/send"; "Mozilla/5.0 (X11; U; Linux
i686; en-US; rv:1.8.0.7) Gecko/20060922 Firefox/1.5.0.7"
 1/Query   :  UPDATE tg_visit SET expiry='2006-10-15 07:25:14' WHERE
((tg_visit.visit_key) = ('3a0767e9ba30e9ed1b9b2d9835eb92739b66a284'))
 1/QueryR  :  UPDATE tg_visit SET expiry='2006-10-15 07:25:14' WHERE
((tg_visit.visit_key) = ('3a0767e9ba30e9ed1b9b2d9835eb92739b66a284'))
 1/COMMIT  :  auto

so why are both tables look empty to the shell?

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to