##// END OF EJS Templates
goto-switcher: optimized performance and query capabilities....
goto-switcher: optimized performance and query capabilities. - Previous implementation had on significant bug. The use of LIMIT 20 was limiting results BEFORE auth checks. In case of large ammount of similarly named repositories user didn't had access too, the result goto search was empty. This was becuase first 20 items fetched didn't pass permission checks and final auth list was empty. To fix this we now use proper filtering for auth using SQL. It means we first check user allowed repositories, and add this as a filter so end result from database is already to only the accessible repositories.

File last commit:

r2000:9e69eb38 default
r2038:2bdf9d4d default
Show More
__init__.py
154 lines | 4.8 KiB | text/x-python | PythonLexer
# -*- coding: utf-8 -*-
# Copyright (C) 2010-2017 RhodeCode GmbH
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License, version 3
# (only), as published by the Free Software Foundation.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
# This program is dual-licensed. If you wish to learn more about the
# RhodeCode Enterprise Edition, including its added features, Support services,
# and proprietary license terms, please see https://rhodecode.com/licenses/
"""
The application's model objects
:example:
.. code-block:: python
from paste.deploy import appconfig
from pylons import config
from sqlalchemy import engine_from_config
from rhodecode.config.environment import load_environment
conf = appconfig('config:development.ini', relative_to = './../../')
load_environment(conf.global_conf, conf.local_conf)
engine = engine_from_config(config, 'sqlalchemy.')
init_model(engine)
# RUN YOUR CODE HERE
"""
import logging
from rhodecode.model import meta, db
from rhodecode.lib.utils2 import obfuscate_url_pw, get_encryption_key
log = logging.getLogger(__name__)
def init_model(engine, encryption_key=None):
"""
Initializes db session, bind the engine with the metadata,
Call this before using any of the tables or classes in the model,
preferably once in application start
:param engine: engine to bind to
"""
engine_str = obfuscate_url_pw(str(engine.url))
log.info("initializing db for %s", engine_str)
meta.Base.metadata.bind = engine
db.ENCRYPTION_KEY = encryption_key
def init_model_encryption(migration_models):
from pylons import config
migration_models.ENCRYPTION_KEY = get_encryption_key(config)
db.ENCRYPTION_KEY = get_encryption_key(config)
class BaseModel(object):
"""
Base Model for all RhodeCode models, it adds sql alchemy session
into instance of model
:param sa: If passed it reuses this session instead of creating a new one
"""
cls = None # override in child class
def __init__(self, sa=None):
if sa is not None:
self.sa = sa
else:
self.sa = meta.Session()
def _get_instance(self, cls, instance, callback=None):
"""
Gets instance of given cls using some simple lookup mechanism.
:param cls: classes to fetch
:param instance: int or Instance
:param callback: callback to call if all lookups failed
"""
if isinstance(instance, cls):
return instance
elif isinstance(instance, (int, long)):
if isinstance(cls, tuple):
# if we pass multi instances we pick first to .get()
cls = cls[0]
return cls.get(instance)
else:
if instance:
if callback is None:
raise Exception(
'given object must be int, long or Instance of %s '
'got %s, no callback provided' % (cls, type(instance))
)
else:
return callback(instance)
def _get_user(self, user):
"""
Helper method to get user by ID, or username fallback
:param user: UserID, username, or User instance
"""
return self._get_instance(
db.User, user, callback=db.User.get_by_username)
def _get_user_group(self, user_group):
"""
Helper method to get user by ID, or username fallback
:param user_group: UserGroupID, user_group_name, or UserGroup instance
"""
return self._get_instance(
db.UserGroup, user_group, callback=db.UserGroup.get_by_group_name)
def _get_repo(self, repository):
"""
Helper method to get repository by ID, or repository name
:param repository: RepoID, repository name or Repository Instance
"""
return self._get_instance(
db.Repository, repository, callback=db.Repository.get_by_repo_name)
def _get_perm(self, permission):
"""
Helper method to get permission by ID, or permission name
:param permission: PermissionID, permission_name or Permission instance
"""
return self._get_instance(
db.Permission, permission, callback=db.Permission.get_by_key)
@classmethod
def get_all(cls):
"""
Returns all instances of what is defined in `cls` class variable
"""
return cls.cls.getAll()