kallithea: pylons_app/lib/timerproxy.py annotate

annotate pylons_app/lib/timerproxy.py @ 90:0c22a870bb79

logging proxy update

author	Marcin Kuzminski <marcin@python-works.com>
date	Mon, 19 Apr 2010 23:03:01 +0200
parents	3ada2f409c1c
children	a5a3bcc5ee89

rev	line source
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	1 from sqlalchemy.interfaces import ConnectionProxy
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	2 import time
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	3 import logging
90 0c22a870bb79 logging proxy update Marcin Kuzminski <marcin@python-works.com> parents: 49 diff changeset	4 log = logging.getLogger('timerproxy')
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	5
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	6 class TimerProxy(ConnectionProxy):
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	7 def cursor_execute(self, execute, cursor, statement, parameters, context, executemany):
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	8 now = time.time()
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	9 try:
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	10 log.info(">>>>> STARTING QUERY >>>>>")
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	11 return execute(cursor, statement, parameters, context)
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	12 finally:
3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	13 total = time.time() - now
90 0c22a870bb79 logging proxy update Marcin Kuzminski <marcin@python-works.com> parents: 49 diff changeset	14 try:
0c22a870bb79 logging proxy update Marcin Kuzminski <marcin@python-works.com> parents: 49 diff changeset	15 log.info("Query: %s" % statement % parameters)
0c22a870bb79 logging proxy update Marcin Kuzminski <marcin@python-works.com> parents: 49 diff changeset	16 except TypeError:
0c22a870bb79 logging proxy update Marcin Kuzminski <marcin@python-works.com> parents: 49 diff changeset	17 log.info("Query: %s %s" % (statement, parameters))
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	18 log.info("<<<<< TOTAL TIME: %f <<<<<" % total)