upstream/kallithea Files · rhodecode/lib/timerproxy.py

added warning on sqlite when using migration....

added warning on sqlite when using migration. Sqlite prior to 3.7 series are known to not support some migration changes like table renames. Thus are failing.

marcink - - Load All Authors

File last commit:

r1512:bf263968 default


                r1835:971ce5e2

beta

Download file

             timerproxy.py
        
                    30 lines
            
             | 856 B
            
                | text/x-python
            
             |
                PythonLexer
            
             / rhodecode / lib / timerproxy.py
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        marcink
    
renamed project to rhodecode

              r547
            
      from sqlalchemy.interfaces import ConnectionProxy

      import time

        marcink
    
let timerproxy use logging module

              r1191
            
      import logging

      log = logging.getLogger('timerproxy')

        marcink
    
renamed project to rhodecode

              r547
            
      BLACK, RED, GREEN, YELLOW, BLUE, MAGENTA, CYAN, WHITE = xrange(30, 38)

        marcink
    
pep8ify

              r1307
            
        marcink
    
renamed project to rhodecode

              r547
            
      def color_sql(sql):

          COLOR_SEQ = "\033[1;%dm"

          COLOR_SQL = YELLOW

          normal = '\x1b[0m'

        marcink
    
Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy....

              r1360
            
          return ''.join([COLOR_SEQ % COLOR_SQL, sql, normal])

        marcink
    
renamed project to rhodecode

              r547
            
        marcink
    
pep8ify

              r1307
            
        marcink
    
renamed project to rhodecode

              r547
            
      class TimerProxy(ConnectionProxy):

        marcink
    
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging

              r1186
            
        marcink
    
renamed project to rhodecode

              r547
            
          def __init__(self):

              super(TimerProxy, self).__init__()

        marcink
    
timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging

              r1186
            
          def cursor_execute(self, execute, cursor, statement, parameters,

                             context, executemany):

        marcink
    
renamed project to rhodecode

              r547
            
              now = time.time()

              try:

        marcink
    
let timerproxy use logging module

              r1191
            
                  log.info(color_sql(">>>>> STARTING QUERY >>>>>"))

        marcink
    
renamed project to rhodecode

              r547
            
                  return execute(cursor, statement, parameters, context)

              finally:

                  total = time.time() - now

        marcink
    
let timerproxy use logging module

              r1191
            
                  log.info(color_sql("<<<<< TOTAL TIME: %f <<<<<" % total))

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

marcink renamed project to rhodecode	r547	from sqlalchemy.interfaces import ConnectionProxy
		import time
marcink let timerproxy use logging module	r1191	import logging
		log = logging.getLogger('timerproxy')

marcink renamed project to rhodecode	r547	BLACK, RED, GREEN, YELLOW, BLUE, MAGENTA, CYAN, WHITE = xrange(30, 38)

marcink pep8ify	r1307
marcink renamed project to rhodecode	r547	def color_sql(sql):
		COLOR_SEQ = "\033[1;%dm"
		COLOR_SQL = YELLOW
		normal = '\x1b[0m'
marcink Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy....	r1360	return ''.join([COLOR_SEQ % COLOR_SQL, sql, normal])
marcink renamed project to rhodecode	r547
marcink pep8ify	r1307
marcink renamed project to rhodecode	r547	class TimerProxy(ConnectionProxy):
marcink timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging	r1186
marcink renamed project to rhodecode	r547	def __init__(self):
		super(TimerProxy, self).__init__()
marcink timperproxy will just measure the time of queries, and formatting will be handled by the new sql_formatter of queries from sqlalchemy itself. Updated ini files for new way logging	r1186
		def cursor_execute(self, execute, cursor, statement, parameters,
		context, executemany):

marcink renamed project to rhodecode	r547	now = time.time()
		try:
marcink let timerproxy use logging module	r1191	log.info(color_sql(">>>>> STARTING QUERY >>>>>"))
marcink renamed project to rhodecode	r547	return execute(cursor, statement, parameters, context)
		finally:
		total = time.time() - now
marcink let timerproxy use logging module	r1191	log.info(color_sql("<<<<< TOTAL TIME: %f <<<<<" % total))