On Jan 27, 2011, at 8:12 PM, NiL wrote: > Hi all, > > I have an application replying on sqlalchemy that deals with many > recursive methods. We manipulate complex graphs. > > I have tests that validates we get the expected results for each > method. > Still, many optimization might be done to the code. > > What I would like is, in my test environment, evaluate the number of > queries to the database. I'm aware that the debug mode will output > every generated SQL, but I deal with a number of queries in the 100s > range ... > > Is there a way to know how many SQL statement have been executed, from > the python testing code ?
you use a ConnectionProxy for this (will be the "execute" event in 0.7). This example uses a timer, you'd adapt this idea to instead issue a count. You can use threadlocal variables or similar to pull out/reset the count of statements after an execution: http://www.sqlalchemy.org/trac/wiki/UsageRecipes/Profiling > > Regards > NiL > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.