[web2py] Re: view SQL query

2010-09-04 Thread Francisco Costa
for ubuntu machines try this: http://www.howtogeek.com/howto/database/monitor-all-sql-queries-in-mysql/ mdipierro wrote: You cannot see all of them, You can see the last one print db._lastdb perhaps now that we have app logging capabilities we should add teh ability to log all queries.

[web2py] Re: view SQL query

2010-09-01 Thread Francisco Costa
I really need to see the SQL that this generate last_updates = db((db.event_social.created_onsession.verificado)(db.event_social.event_id==this_event)).select(db.event_social.ALL,orderby=~db.event_social.created_on) On Sep 1, 12:24 pm, Francisco Costa m...@franciscocosta.com wrote: How can I

[web2py] Re: view SQL query

2010-09-01 Thread mdipierro
You cannot see all of them, You can see the last one print db._lastdb perhaps now that we have app logging capabilities we should add teh ability to log all queries. On Sep 1, 6:24 am, Francisco Costa m...@franciscocosta.com wrote: How can I see the SQL queries made after loading a page?

[web2py] Re: view SQL query

2010-09-01 Thread Francisco Costa
Yes, that would be very nice! On Sep 1, 2:40 pm, mdipierro mdipie...@cs.depaul.edu wrote: You cannot see all of them, You can see the last one print db._lastdb perhaps now that we have app logging capabilities we should add teh ability to log all queries. On Sep 1, 6:24 am, Francisco

[web2py] Re: view SQL query

2010-09-01 Thread Pai
+1 On Sep 1, 8:40 am, mdipierro mdipie...@cs.depaul.edu wrote: You cannot see all of them, You can see the last one print db._lastdb perhaps now that we have app logging capabilities we should add teh ability to log all queries. On Sep 1, 6:24 am, Francisco Costa m...@franciscocosta.com