Mercurial > kallithea
view rhodecode/lib/timerproxy.py @ 1360:1f47adeb67c2 beta
Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy.
TimerProxy is now longer valid profilling method for sqlalchemy
author | Marcin Kuzminski <marcin@python-works.com> |
---|---|
date | Sat, 04 Jun 2011 20:34:30 +0200 |
parents | c1516b35f91d |
children | bf263968da47 |
line wrap: on
line source
from sqlalchemy.interfaces import ConnectionProxy import time import logging log = logging.getLogger('timerproxy') BLACK, RED, GREEN, YELLOW, BLUE, MAGENTA, CYAN, WHITE = xrange(30, 38) def color_sql(sql): COLOR_SEQ = "\033[1;%dm" COLOR_SQL = YELLOW normal = '\x1b[0m' return ''.join([COLOR_SEQ % COLOR_SQL, sql, normal]) class TimerProxy(ConnectionProxy): def __init__(self): super(TimerProxy, self).__init__() def cursor_execute(self, execute, cursor, statement, parameters, context, executemany): now = time.time() try: log.info(color_sql(">>>>> STARTING QUERY >>>>>")) return execute(cursor, statement, parameters, context) finally: total = time.time() - now log.info(color_sql("<<<<< TOTAL TIME: %f <<<<<" % total))