rhodecode-enterprise-ce Files · rhodecode/lib/dbmigrate/migrate/versioning/script/sql.py

caches: use individual namespaces per user to prevent beaker caching problems....

caches: use individual namespaces per user to prevent beaker caching problems. - especially for mysql in case large number of data in caches there could be critical errors storing cache, and thus preventing users from authentication. This is caused by the fact that we used single namespace for ALL users. It means it grew as number of users grew reaching mysql single column limit. This changes the behaviour and now we use namespace per-user it means that each user-id will have it's own cache namespace fragmenting maximum column data to a single user cache. Which we should never reach.

marcink - - Load All Authors

File last commit:

r1:854a839a default


                r2572:5b07455a

default

Download file

             sql.py
        
                    49 lines
            
             | 1.7 KiB
            
                | text/x-python
            
             |
                PythonLexer
            
             / rhodecode / lib / dbmigrate / migrate / versioning / script / sql.py
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      #!/usr/bin/env python

      # -*- coding: utf-8 -*-

      import logging

      import shutil

      from rhodecode.lib.dbmigrate.migrate.versioning.script import base

      from rhodecode.lib.dbmigrate.migrate.versioning.template import Template

      log = logging.getLogger(__name__)

      class SqlScript(base.BaseScript):

          """A file containing plain SQL statements."""

          @classmethod

          def create(cls, path, **opts):

              """Create an empty migration script at specified path

              :returns: :class:`SqlScript instance <migrate.versioning.script.sql.SqlScript>`"""

              cls.require_notfound(path)

              src = Template(opts.pop('templates_path', None)).get_sql_script(theme=opts.pop('templates_theme', None))

              shutil.copy(src, path)

              return cls(path)

          # TODO: why is step parameter even here?

          def run(self, engine, step=None, executemany=True):

              """Runs SQL script through raw dbapi execute call"""

              text = self.source()

              # Don't rely on SA's autocommit here

              # (SA uses .startswith to check if a commit is needed. What if script

              # starts with a comment?)

              conn = engine.connect()

              try:

                  trans = conn.begin()

                  try:

                      # HACK: SQLite doesn't allow multiple statements through

                      # its execute() method, but it provides executescript() instead

                      dbapi = conn.engine.raw_connection()

                      if executemany and getattr(dbapi, 'executescript', None):

                          dbapi.executescript(text)

                      else:

                          conn.execute(text)

                      trans.commit()

                  except:

                      trans.rollback()

                      raise

              finally:

                  conn.close()

	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

				#!/usr/bin/env python
				# -- coding: utf-8 --
				import logging
				import shutil

				from rhodecode.lib.dbmigrate.migrate.versioning.script import base
				from rhodecode.lib.dbmigrate.migrate.versioning.template import Template


				log = logging.getLogger(__name__)

				class SqlScript(base.BaseScript):
				"""A file containing plain SQL statements."""

				@classmethod
				def create(cls, path, **opts):
				"""Create an empty migration script at specified path

				:returns: :class:`SqlScript instance <migrate.versioning.script.sql.SqlScript>`"""
				cls.require_notfound(path)

				src = Template(opts.pop('templates_path', None)).get_sql_script(theme=opts.pop('templates_theme', None))
				shutil.copy(src, path)
				return cls(path)

				# TODO: why is step parameter even here?
				def run(self, engine, step=None, executemany=True):
				"""Runs SQL script through raw dbapi execute call"""
				text = self.source()
				# Don't rely on SA's autocommit here
				# (SA uses .startswith to check if a commit is needed. What if script
				# starts with a comment?)
				conn = engine.connect()
				try:
				trans = conn.begin()
				try:
				# HACK: SQLite doesn't allow multiple statements through
				# its execute() method, but it provides executescript() instead
				dbapi = conn.engine.raw_connection()
				if executemany and getattr(dbapi, 'executescript', None):
				dbapi.executescript(text)
				else:
				conn.execute(text)
				trans.commit()
				except:
				trans.rollback()
				raise
				finally:
				conn.close()