kallithea: rhodecode/model/db.py annotate

annotate rhodecode/model/db.py @ 1515:da8f1d1b22de

merge stable with beta

author	Marcin Kuzminski <marcin@python-works.com>
date	Fri, 07 Oct 2011 02:53:29 +0200
parents	bf263968da47 87ec80c280bb
children	752b0a7b7679

rev	line source
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	1 # -- coding: utf-8 --
a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	2 """
832 634596f81cfd new improved models with helper functions for easier data fetching Marcin Kuzminski <marcin@python-works.com> parents: 810 diff changeset	3 rhodecode.model.db
634596f81cfd new improved models with helper functions for easier data fetching Marcin Kuzminski <marcin@python-works.com> parents: 810 diff changeset	4 ~~~~~~~~~~~~~~~~~~
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1199 diff changeset	5
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	6 Database Models for RhodeCode
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1199 diff changeset	7
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	8 :created_on: Apr 08, 2010
a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	9 :author: marcink
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1199 diff changeset	10 :copyright: (C) 2009-2011 Marcin Kuzminski <marcin@python-works.com>
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	11 :license: GPLv3, see COPYING for more details.
a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	12 """
1206 a671db5bdd58 fixed license issue #149 Marcin Kuzminski <marcin@python-works.com> parents: 1203 diff changeset	13 # This program is free software: you can redistribute it and/or modify
a671db5bdd58 fixed license issue #149 Marcin Kuzminski <marcin@python-works.com> parents: 1203 diff changeset	14 # it under the terms of the GNU General Public License as published by
a671db5bdd58 fixed license issue #149 Marcin Kuzminski <marcin@python-works.com> parents: 1203 diff changeset	15 # the Free Software Foundation, either version 3 of the License, or
a671db5bdd58 fixed license issue #149 Marcin Kuzminski <marcin@python-works.com> parents: 1203 diff changeset	16 # (at your option) any later version.
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1199 diff changeset	17 #
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	18 # This program is distributed in the hope that it will be useful,
a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	19 # but WITHOUT ANY WARRANTY; without even the implied warranty of
a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	20 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	21 # GNU General Public License for more details.
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1199 diff changeset	22 #
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	23 # You should have received a copy of the GNU General Public License
1206 a671db5bdd58 fixed license issue #149 Marcin Kuzminski <marcin@python-works.com> parents: 1203 diff changeset	24 # along with this program. If not, see <http://www.gnu.org/licenses/>.
1199 268fa0b6b2ef Added os.sep in models for better win support Marcin Kuzminski <marcin@python-works.com> parents: 1193 diff changeset	25
268fa0b6b2ef Added os.sep in models for better win support Marcin Kuzminski <marcin@python-works.com> parents: 1193 diff changeset	26 import os
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	27 import logging
a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	28 import datetime
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	29 import traceback
994 7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	30 from datetime import date
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	31
658 4ecb2ffcc110 fixed imports Marcin Kuzminski <marcin@python-works.com> parents: 657 diff changeset	32 from sqlalchemy import *
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	33 from sqlalchemy.exc import DatabaseError
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	34 from sqlalchemy.orm import relationship, backref, joinedload, class_mapper
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	35 from sqlalchemy.orm.interfaces import MapperExtension
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	36
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	37 from beaker.cache import cache_region, region_invalidate
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	38
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	39 from vcs import get_backend
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	40 from vcs.utils.helpers import get_scm
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	41 from vcs.exceptions import VCSError
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	42 from vcs.utils.lazy import LazyProperty
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	43
1514 87ec80c280bb fixed issues with python2.5 Marcin Kuzminski <marcin@python-works.com> parents: 1508 diff changeset	44 from rhodecode.lib import str2bool, safe_str, get_changeset_safe, \
87ec80c280bb fixed issues with python2.5 Marcin Kuzminski <marcin@python-works.com> parents: 1508 diff changeset	45 generate_api_key
1436 88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	46 from rhodecode.lib.exceptions import UsersGroupsAssignedException
1514 87ec80c280bb fixed issues with python2.5 Marcin Kuzminski <marcin@python-works.com> parents: 1508 diff changeset	47 from rhodecode.lib.compat import json
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	48
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	49 from rhodecode.model.meta import Base, Session
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	50 from rhodecode.model.caching_query import FromCache
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	51
442 d66a7fa7689b moved loged in user propagation out of forms, Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	52 log = logging.getLogger(__name__)
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	53
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	54 #==============================================================================
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	55 # BASE CLASSES
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	56 #==============================================================================
70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	57
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	58 class ModelSerializer(json.JSONEncoder):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	59 """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	60 Simple Serializer for JSON,
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	61
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	62 usage::
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	63
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	64 to make object customized for serialization implement a __json__
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	65 method that will return a dict for serialization into json
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	66
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	67 example::
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	68
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	69 class Task(object):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	70
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	71 def __init__(self, name, value):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	72 self.name = name
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	73 self.value = value
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	74
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	75 def __json__(self):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	76 return dict(name=self.name,
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	77 value=self.value)
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	78
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	79 """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	80
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	81 def default(self, obj):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	82
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	83 if hasattr(obj, '__json__'):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	84 return obj.__json__()
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	85 else:
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	86 return json.JSONEncoder.default(self, obj)
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	87
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	88 class BaseModel(object):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	89 """Base Model for all classess
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	90
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	91 """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	92
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	93 @classmethod
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	94 def _get_keys(cls):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	95 """return column names for this model """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	96 return class_mapper(cls).c.keys()
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	97
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	98 def get_dict(self):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	99 """return dict with keys and values corresponding
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	100 to this model data """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	101
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	102 d = {}
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	103 for k in self._get_keys():
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	104 d[k] = getattr(self, k)
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	105 return d
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	106
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	107 def get_appstruct(self):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	108 """return list with keys and values tupples corresponding
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	109 to this model data """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	110
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	111 l = []
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	112 for k in self._get_keys():
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	113 l.append((k, getattr(self, k),))
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	114 return l
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	115
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	116 def populate_obj(self, populate_dict):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	117 """populate model with data from given populate_dict"""
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	118
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	119 for k in self._get_keys():
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	120 if k in populate_dict:
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	121 setattr(self, k, populate_dict[k])
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	122
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	123 @classmethod
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	124 def query(cls):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	125 return Session.query(cls)
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	126
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	127 @classmethod
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	128 def get(cls, id_):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	129 return Session.query(cls).get(id_)
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	130
1460 b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	131 @classmethod
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	132 def delete(cls, id_):
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	133 obj = Session.query(cls).get(id_)
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	134 Session.delete(obj)
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	135 Session.commit()
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	136
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	137
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	138 class RhodeCodeSettings(Base, BaseModel):
548 b75b77ef649d renamed hg_app to rhodecode Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	139 __tablename__ = 'rhodecode_settings'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	140 __table_args__ = (UniqueConstraint('app_settings_name'), {'extend_existing':True})
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	141 app_settings_id = Column("app_settings_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	142 app_settings_name = Column("app_settings_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	143 app_settings_value = Column("app_settings_value", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 328 diff changeset	144
907 2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	145 def __init__(self, k='', v=''):
704 26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	146 self.app_settings_name = k
26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	147 self.app_settings_value = v
26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	148
26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	149 def __repr__(self):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	150 return "<%s('%s:%s')>" % (self.__class__.__name__,
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	151 self.app_settings_name, self.app_settings_value)
704 26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	152
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	153
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	154 @classmethod
1292 c0335c1dee36 added some fixes to LDAP form re-submition, new simples ldap-settings getter. Marcin Kuzminski <marcin@python-works.com> parents: 1279 diff changeset	155 def get_by_name(cls, ldap_key):
c0335c1dee36 added some fixes to LDAP form re-submition, new simples ldap-settings getter. Marcin Kuzminski <marcin@python-works.com> parents: 1279 diff changeset	156 return Session.query(cls)\
c0335c1dee36 added some fixes to LDAP form re-submition, new simples ldap-settings getter. Marcin Kuzminski <marcin@python-works.com> parents: 1279 diff changeset	157 .filter(cls.app_settings_name == ldap_key).scalar()
c0335c1dee36 added some fixes to LDAP form re-submition, new simples ldap-settings getter. Marcin Kuzminski <marcin@python-works.com> parents: 1279 diff changeset	158
c0335c1dee36 added some fixes to LDAP form re-submition, new simples ldap-settings getter. Marcin Kuzminski <marcin@python-works.com> parents: 1279 diff changeset	159 @classmethod
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	160 def get_app_settings(cls, cache=False):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	161
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	162 ret = Session.query(cls)
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	163
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	164 if cache:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	165 ret = ret.options(FromCache("sql_cache_short", "get_hg_settings"))
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	166
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	167 if not ret:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	168 raise Exception('Could not get application settings !')
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	169 settings = {}
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	170 for each in ret:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	171 settings['rhodecode_' + each.app_settings_name] = \
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	172 each.app_settings_value
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	173
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	174 return settings
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	175
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	176 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	177 def get_ldap_settings(cls, cache=False):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	178 ret = Session.query(cls)\
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	179 .filter(cls.app_settings_name.startswith('ldap_'))\
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	180 .all()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	181 fd = {}
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	182 for row in ret:
1292 c0335c1dee36 added some fixes to LDAP form re-submition, new simples ldap-settings getter. Marcin Kuzminski <marcin@python-works.com> parents: 1279 diff changeset	183 fd.update({row.app_settings_name:row.app_settings_value})
1381 a1ab3e9c7e82 fixes #204, ldap active checkbox, credits goes to Matt Little. Marcin Kuzminski <marcin@python-works.com> parents: 1376 diff changeset	184
a1ab3e9c7e82 fixes #204, ldap active checkbox, credits goes to Matt Little. Marcin Kuzminski <marcin@python-works.com> parents: 1376 diff changeset	185 fd.update({'ldap_active':str2bool(fd.get('ldap_active'))})
a1ab3e9c7e82 fixes #204, ldap active checkbox, credits goes to Matt Little. Marcin Kuzminski <marcin@python-works.com> parents: 1376 diff changeset	186
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	187 return fd
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	188
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	189
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	190 class RhodeCodeUi(Base, BaseModel):
548 b75b77ef649d renamed hg_app to rhodecode Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	191 __tablename__ = 'rhodecode_ui'
1460 b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	192 __table_args__ = (UniqueConstraint('ui_key'), {'extend_existing':True})
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	193
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	194 HOOK_UPDATE = 'changegroup.update'
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	195 HOOK_REPO_SIZE = 'changegroup.repo_size'
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	196 HOOK_PUSH = 'pretxnchangegroup.push_logger'
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	197 HOOK_PULL = 'preoutgoing.pull_logger'
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	198
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	199 ui_id = Column("ui_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	200 ui_section = Column("ui_section", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	201 ui_key = Column("ui_key", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	202 ui_value = Column("ui_value", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	203 ui_active = Column("ui_active", Boolean(), nullable=True, unique=None, default=True)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	204
05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	205
1345 3bce31f026b8 #47 implemented Adding of new repo_groups+forms+validators. Fixed sorting of repo groups by main names in multiple locations. Removed some unneeded calls to self.sa for exchange to .query() methods. Marcin Kuzminski <marcin@python-works.com> parents: 1343 diff changeset	206 @classmethod
3bce31f026b8 #47 implemented Adding of new repo_groups+forms+validators. Fixed sorting of repo groups by main names in multiple locations. Removed some unneeded calls to self.sa for exchange to .query() methods. Marcin Kuzminski <marcin@python-works.com> parents: 1343 diff changeset	207 def get_by_key(cls, key):
3bce31f026b8 #47 implemented Adding of new repo_groups+forms+validators. Fixed sorting of repo groups by main names in multiple locations. Removed some unneeded calls to self.sa for exchange to .query() methods. Marcin Kuzminski <marcin@python-works.com> parents: 1343 diff changeset	208 return Session.query(cls).filter(cls.ui_key == key)
3bce31f026b8 #47 implemented Adding of new repo_groups+forms+validators. Fixed sorting of repo groups by main names in multiple locations. Removed some unneeded calls to self.sa for exchange to .query() methods. Marcin Kuzminski <marcin@python-works.com> parents: 1343 diff changeset	209
3bce31f026b8 #47 implemented Adding of new repo_groups+forms+validators. Fixed sorting of repo groups by main names in multiple locations. Removed some unneeded calls to self.sa for exchange to .query() methods. Marcin Kuzminski <marcin@python-works.com> parents: 1343 diff changeset	210
1460 b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	211 @classmethod
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	212 def get_builtin_hooks(cls):
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	213 q = cls.query()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	214 q = q.filter(cls.ui_key.in_([cls.HOOK_UPDATE,
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	215 cls.HOOK_REPO_SIZE,
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	216 cls.HOOK_PUSH, cls.HOOK_PULL]))
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	217 return q.all()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	218
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	219 @classmethod
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	220 def get_custom_hooks(cls):
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	221 q = cls.query()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	222 q = q.filter(~cls.ui_key.in_([cls.HOOK_UPDATE,
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	223 cls.HOOK_REPO_SIZE,
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	224 cls.HOOK_PUSH, cls.HOOK_PULL]))
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	225 q = q.filter(cls.ui_section == 'hooks')
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	226 return q.all()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	227
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	228 @classmethod
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	229 def create_or_update_hook(cls, key, val):
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	230 new_ui = cls.get_by_key(key).scalar() or cls()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	231 new_ui.ui_section = 'hooks'
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	232 new_ui.ui_active = True
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	233 new_ui.ui_key = key
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	234 new_ui.ui_value = val
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	235
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	236 Session.add(new_ui)
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	237 Session.commit()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	238
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	239
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	240 class User(Base, BaseModel):
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	241 __tablename__ = 'users'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	242 __table_args__ = (UniqueConstraint('username'), UniqueConstraint('email'), {'extend_existing':True})
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	243 user_id = Column("user_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	244 username = Column("username", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	245 password = Column("password", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	246 active = Column("active", Boolean(), nullable=True, unique=None, default=None)
92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	247 admin = Column("admin", Boolean(), nullable=True, unique=None, default=False)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	248 name = Column("name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	249 lastname = Column("lastname", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	250 email = Column("email", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	251 last_login = Column("last_login", DateTime(timezone=False), nullable=True, unique=None, default=None)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	252 ldap_dn = Column("ldap_dn", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	253 api_key = Column("api_key", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	254
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	255 user_log = relationship('UserLog', cascade='all')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	256 user_perms = relationship('UserToPerm', primaryjoin="User.user_id==UserToPerm.user_id", cascade='all')
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	257
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	258 repositories = relationship('Repository')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	259 user_followers = relationship('UserFollowing', primaryjoin='UserFollowing.follows_user_id==User.user_id', cascade='all')
1325 89ff3e30470f fixes #188 - relationship delete of repo_to_perm entry on user removal Marcin Kuzminski <marcin@python-works.com> parents: 1323 diff changeset	260 repo_to_perm = relationship('RepoToPerm', primaryjoin='RepoToPerm.user_id==User.user_id', cascade='all')
713 1bb0fcdec895 fixed #72 show warning on removal when user still is owner of existing repositories Marcin Kuzminski <marcin@python-works.com> parents: 708 diff changeset	261
1039 51b70569c330 extended admin rescan to show what repositories was added and what removed Marcin Kuzminski <marcin@python-works.com> parents: 1034 diff changeset	262 group_member = relationship('UsersGroupMember', cascade='all')
1065 5d676b6ab71c Moved BaseModel into base class for declarative base. Added some handy methods into Marcin Kuzminski <marcin@python-works.com> parents: 1039 diff changeset	263
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	264 @property
265 0e5455fda8fd Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 242 diff changeset	265 def full_contact(self):
0e5455fda8fd Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 242 diff changeset	266 return '%s %s <%s>' % (self.name, self.lastname, self.email)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	267
895 62c04c5cc971 Added some more details into user edit permissions view Marcin Kuzminski <marcin@python-works.com> parents: 880 diff changeset	268 @property
1088 fee472613dfa made simple global rss and atom feed Marcin Kuzminski <marcin@python-works.com> parents: 1081 diff changeset	269 def short_contact(self):
fee472613dfa made simple global rss and atom feed Marcin Kuzminski <marcin@python-works.com> parents: 1081 diff changeset	270 return '%s %s' % (self.name, self.lastname)
fee472613dfa made simple global rss and atom feed Marcin Kuzminski <marcin@python-works.com> parents: 1081 diff changeset	271
fee472613dfa made simple global rss and atom feed Marcin Kuzminski <marcin@python-works.com> parents: 1081 diff changeset	272 @property
895 62c04c5cc971 Added some more details into user edit permissions view Marcin Kuzminski <marcin@python-works.com> parents: 880 diff changeset	273 def is_admin(self):
62c04c5cc971 Added some more details into user edit permissions view Marcin Kuzminski <marcin@python-works.com> parents: 880 diff changeset	274 return self.admin
62c04c5cc971 Added some more details into user edit permissions view Marcin Kuzminski <marcin@python-works.com> parents: 880 diff changeset	275
232 37a832dc4a82 some beaker cache changes, and added repr to models Marcin Kuzminski <marcin@python-works.com> parents: 226 diff changeset	276 def __repr__(self):
1400 0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	277 try:
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	278 return "<%s('id:%s:%s')>" % (self.__class__.__name__,
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	279 self.user_id, self.username)
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	280 except:
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	281 return self.__class__.__name__
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	282
1065 5d676b6ab71c Moved BaseModel into base class for declarative base. Added some handy methods into Marcin Kuzminski <marcin@python-works.com> parents: 1039 diff changeset	283 @classmethod
1400 0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	284 def by_username(cls, username, case_insensitive=False):
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	285 if case_insensitive:
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	286 return Session.query(cls).filter(cls.username.like(username)).one()
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	287 else:
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	288 return Session.query(cls).filter(cls.username == username).one()
1065 5d676b6ab71c Moved BaseModel into base class for declarative base. Added some handy methods into Marcin Kuzminski <marcin@python-works.com> parents: 1039 diff changeset	289
1417 5875955def39 fixes #223 improve password reset form Marcin Kuzminski <marcin@python-works.com> parents: 1401 diff changeset	290 @classmethod
5875955def39 fixes #223 improve password reset form Marcin Kuzminski <marcin@python-works.com> parents: 1401 diff changeset	291 def get_by_api_key(cls, api_key):
5875955def39 fixes #223 improve password reset form Marcin Kuzminski <marcin@python-works.com> parents: 1401 diff changeset	292 return Session.query(cls).filter(cls.api_key == api_key).one()
5875955def39 fixes #223 improve password reset form Marcin Kuzminski <marcin@python-works.com> parents: 1401 diff changeset	293
5875955def39 fixes #223 improve password reset form Marcin Kuzminski <marcin@python-works.com> parents: 1401 diff changeset	294
442 d66a7fa7689b moved loged in user propagation out of forms, Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	295 def update_lastlogin(self):
d66a7fa7689b moved loged in user propagation out of forms, Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	296 """Update user lastlogin"""
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	297
1400 0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	298 self.last_login = datetime.datetime.now()
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	299 Session.add(self)
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	300 Session.commit()
0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	301 log.debug('updated user %s lastlogin', self.username)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	302
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	303 @classmethod
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	304 def create(cls, form_data):
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	305 from rhodecode.lib.auth import get_crypt_password
1514 87ec80c280bb fixed issues with python2.5 Marcin Kuzminski <marcin@python-works.com> parents: 1508 diff changeset	306
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	307 try:
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	308 new_user = cls()
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	309 for k, v in form_data.items():
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	310 if k == 'password':
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	311 v = get_crypt_password(v)
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	312 setattr(new_user, k, v)
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	313
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	314 new_user.api_key = generate_api_key(form_data['username'])
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	315 Session.add(new_user)
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	316 Session.commit()
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	317 return new_user
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	318 except:
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	319 log.error(traceback.format_exc())
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	320 Session.rollback()
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	321 raise
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	322
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	323 class UserLog(Base, BaseModel):
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	324 __tablename__ = 'user_logs'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	325 __table_args__ = {'extend_existing':True}
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	326 user_log_id = Column("user_log_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	327 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	328 repository_id = Column("repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=False, unique=None, default=None)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	329 repository_name = Column("repository_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	330 user_ip = Column("user_ip", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	331 action = Column("action", UnicodeText(length=1200000, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	332 action_date = Column("action_date", DateTime(timezone=False), nullable=True, unique=None, default=None)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	333
994 7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	334 @property
7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	335 def action_as_day(self):
7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	336 return date(*self.action_date.timetuple()[:3])
7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	337
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	338 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	339 repository = relationship('Repository')
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	340
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	341
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	342 class UsersGroup(Base, BaseModel):
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	343 __tablename__ = 'users_groups'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	344 __table_args__ = {'extend_existing':True}
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	345
959 fff21c9b075c #56 fixed found bugs, implemented adding of new group + forms+validators Marcin Kuzminski <marcin@python-works.com> parents: 958 diff changeset	346 users_group_id = Column("users_group_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	347 users_group_name = Column("users_group_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
959 fff21c9b075c #56 fixed found bugs, implemented adding of new group + forms+validators Marcin Kuzminski <marcin@python-works.com> parents: 958 diff changeset	348 users_group_active = Column("users_group_active", Boolean(), nullable=True, unique=None, default=None)
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	349
974 f6658c70eeeb #56 fixed relationship query behavior to speed up fetching, and Marcin Kuzminski <marcin@python-works.com> parents: 972 diff changeset	350 members = relationship('UsersGroupMember', cascade="all, delete, delete-orphan", lazy="joined")
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	351
1435 a62af7d509ee fixes #228 - added detection of assigned groups to prevent errors on sqlite Marcin Kuzminski <marcin@python-works.com> parents: 1428 diff changeset	352 def __repr__(self):
a62af7d509ee fixes #228 - added detection of assigned groups to prevent errors on sqlite Marcin Kuzminski <marcin@python-works.com> parents: 1428 diff changeset	353 return '<userGroup(%s)>' % (self.users_group_name)
1271 aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	354
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	355 @classmethod
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	356 def get_by_group_name(cls, group_name, cache=False, case_insensitive=False):
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	357 if case_insensitive:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	358 gr = Session.query(cls)\
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	359 .filter(cls.users_group_name.ilike(group_name))
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	360 else:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	361 gr = Session.query(UsersGroup)\
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	362 .filter(UsersGroup.users_group_name == group_name)
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	363 if cache:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	364 gr = gr.options(FromCache("sql_cache_short",
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	365 "get_user_%s" % group_name))
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	366 return gr.scalar()
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	367
1436 88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	368
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	369 @classmethod
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	370 def get(cls, users_group_id, cache=False):
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	371 users_group = Session.query(cls)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	372 if cache:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	373 users_group = users_group.options(FromCache("sql_cache_short",
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	374 "get_users_group_%s" % users_group_id))
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	375 return users_group.get(users_group_id)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	376
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	377 @classmethod
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	378 def create(cls, form_data):
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	379 try:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	380 new_users_group = cls()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	381 for k, v in form_data.items():
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	382 setattr(new_users_group, k, v)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	383
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	384 Session.add(new_users_group)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	385 Session.commit()
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	386 return new_users_group
1436 88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	387 except:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	388 log.error(traceback.format_exc())
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	389 Session.rollback()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	390 raise
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	391
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	392 @classmethod
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	393 def update(cls, users_group_id, form_data):
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	394
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	395 try:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	396 users_group = cls.get(users_group_id, cache=False)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	397
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	398 for k, v in form_data.items():
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	399 if k == 'users_group_members':
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	400 users_group.members = []
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	401 Session.flush()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	402 members_list = []
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	403 if v:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	404 for u_id in set(v):
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	405 members_list.append(UsersGroupMember(
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	406 users_group_id,
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	407 u_id))
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	408 setattr(users_group, 'members', members_list)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	409 setattr(users_group, k, v)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	410
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	411 Session.add(users_group)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	412 Session.commit()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	413 except:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	414 log.error(traceback.format_exc())
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	415 Session.rollback()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	416 raise
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	417
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	418 @classmethod
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	419 def delete(cls, users_group_id):
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	420 try:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	421
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	422 # check if this group is not assigned to repo
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	423 assigned_groups = UsersGroupRepoToPerm.query()\
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	424 .filter(UsersGroupRepoToPerm.users_group_id ==
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	425 users_group_id).all()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	426
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	427 if assigned_groups:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	428 raise UsersGroupsAssignedException('Group assigned to %s' %
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	429 assigned_groups)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	430
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	431 users_group = cls.get(users_group_id, cache=False)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	432 Session.delete(users_group)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	433 Session.commit()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	434 except:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	435 log.error(traceback.format_exc())
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	436 Session.rollback()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	437 raise
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	438
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	439
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	440 class UsersGroupMember(Base, BaseModel):
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	441 __tablename__ = 'users_groups_members'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	442 __table_args__ = {'extend_existing':True}
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	443
959 fff21c9b075c #56 fixed found bugs, implemented adding of new group + forms+validators Marcin Kuzminski <marcin@python-works.com> parents: 958 diff changeset	444 users_group_member_id = Column("users_group_member_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
fff21c9b075c #56 fixed found bugs, implemented adding of new group + forms+validators Marcin Kuzminski <marcin@python-works.com> parents: 958 diff changeset	445 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	446 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	447
974 f6658c70eeeb #56 fixed relationship query behavior to speed up fetching, and Marcin Kuzminski <marcin@python-works.com> parents: 972 diff changeset	448 user = relationship('User', lazy='joined')
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	449 users_group = relationship('UsersGroup')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	450
1023 e7478ac19f9f updated db migrations to schema 3 Marcin Kuzminski <marcin@python-works.com> parents: 1015 diff changeset	451 def __init__(self, gr_id='', u_id=''):
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	452 self.users_group_id = gr_id
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	453 self.user_id = u_id
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	454
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	455 class Repository(Base, BaseModel):
234 a0116e944da1 changed naming convention for db modules. Marcin Kuzminski <marcin@python-works.com> parents: 232 diff changeset	456 __tablename__ = 'repositories'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	457 __table_args__ = (UniqueConstraint('repo_name'), {'extend_existing':True},)
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	458
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	459 repo_id = Column("repo_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	460 repo_name = Column("repo_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	461 clone_uri = Column("clone_uri", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=False, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	462 repo_type = Column("repo_type", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=False, default='hg')
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	463 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=False, default=None)
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	464 private = Column("private", Boolean(), nullable=True, unique=None, default=None)
810 bd57d1cb9dc3 fixes #62, added option to disable statistics for each repository Marcin Kuzminski <marcin@python-works.com> parents: 780 diff changeset	465 enable_statistics = Column("statistics", Boolean(), nullable=True, unique=None, default=True)
962 72f008ed9b18 implemented #84 downloads can be enabled/disabled per each repository from now. Marcin Kuzminski <marcin@python-works.com> parents: 959 diff changeset	466 enable_downloads = Column("downloads", Boolean(), nullable=True, unique=None, default=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	467 description = Column("description", String(length=10000, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
1301 7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	468 created_on = Column('created_on', DateTime(timezone=False), nullable=True, unique=None, default=datetime.datetime.now)
7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	469
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	470 fork_id = Column("fork_id", Integer(), ForeignKey('repositories.repo_id'), nullable=True, unique=False, default=None)
014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	471 group_id = Column("group_id", Integer(), ForeignKey('groups.group_id'), nullable=True, unique=False, default=None)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	472
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	473
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	474 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	475 fork = relationship('Repository', remote_side=repo_id)
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	476 group = relationship('Group')
1033 e2ebbb27df4e fixed problem with caching Marcin Kuzminski <marcin@python-works.com> parents: 1023 diff changeset	477 repo_to_perm = relationship('RepoToPerm', cascade='all', order_by='RepoToPerm.repo_to_perm_id')
1271 aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	478 users_group_to_perm = relationship('UsersGroupRepoToPerm', cascade='all')
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	479 stats = relationship('Statistics', cascade='all', uselist=False)
667 56a8434a88cc fixes #51 deleting a repo didn't delete it's dependent db entries. Marcin Kuzminski <marcin@python-works.com> parents: 658 diff changeset	480
1034 9e59b16d1b48 updated config files, and changed model repo_followers to followers Marcin Kuzminski <marcin@python-works.com> parents: 1033 diff changeset	481 followers = relationship('UserFollowing', primaryjoin='UserFollowing.follows_repo_id==Repository.repo_id', cascade='all')
734 49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	482
976 de535f8b1e8b Fixed links for repository, it's optional now to pass a link without a summary Marcin Kuzminski <marcin@python-works.com> parents: 975 diff changeset	483 logs = relationship('UserLog', cascade='all')
970 1a5c41e4bb02 fixees for #106 relation issues on databases different than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	484
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 414 diff changeset	485 def __repr__(self):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	486 return "<%s('%s:%s')>" % (self.__class__.__name__,
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	487 self.repo_id, self.repo_name)
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	488
1065 5d676b6ab71c Moved BaseModel into base class for declarative base. Added some handy methods into Marcin Kuzminski <marcin@python-works.com> parents: 1039 diff changeset	489 @classmethod
5d676b6ab71c Moved BaseModel into base class for declarative base. Added some handy methods into Marcin Kuzminski <marcin@python-works.com> parents: 1039 diff changeset	490 def by_repo_name(cls, repo_name):
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	491 q = Session.query(cls).filter(cls.repo_name == repo_name)
1065 5d676b6ab71c Moved BaseModel into base class for declarative base. Added some handy methods into Marcin Kuzminski <marcin@python-works.com> parents: 1039 diff changeset	492
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	493 q = q.options(joinedload(Repository.fork))\
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	494 .options(joinedload(Repository.user))\
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	495 .options(joinedload(Repository.group))\
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	496
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	497 return q.one()
1301 7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	498
7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	499 @classmethod
7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	500 def get_repo_forks(cls, repo_id):
7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	501 return Session.query(cls).filter(Repository.fork_id == repo_id)
7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	502
1508 4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	503 @classmethod
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	504 def base_path(cls):
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	505 """
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	506 Returns base path when all repos are stored
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	507
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	508 :param cls:
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	509 """
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	510 q = Session.query(RhodeCodeUi).filter(RhodeCodeUi.ui_key == '/')
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	511 q.options(FromCache("sql_cache_short", "repository_repo_path"))
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	512 return q.one().ui_value
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	513
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	514 @property
1155 37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	515 def just_name(self):
1199 268fa0b6b2ef Added os.sep in models for better win support Marcin Kuzminski <marcin@python-works.com> parents: 1193 diff changeset	516 return self.repo_name.split(os.sep)[-1]
1155 37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	517
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	518 @property
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	519 def groups_with_parents(self):
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	520 groups = []
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	521 if self.group is None:
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	522 return groups
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	523
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	524 cur_gr = self.group
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	525 groups.insert(0, cur_gr)
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	526 while 1:
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	527 gr = getattr(cur_gr, 'parent_group', None)
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	528 cur_gr = cur_gr.parent_group
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	529 if gr is None:
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	530 break
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	531 groups.insert(0, gr)
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	532
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	533 return groups
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	534
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	535 @property
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	536 def groups_and_repo(self):
1155 37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	537 return self.groups_with_parents, self.just_name
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	538
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	539 @LazyProperty
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	540 def repo_path(self):
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	541 """
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	542 Returns base full path for that repository means where it actually
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	543 exists on a filesystem
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	544 """
1368 04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	545 q = Session.query(RhodeCodeUi).filter(RhodeCodeUi.ui_key == '/')
04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	546 q.options(FromCache("sql_cache_short", "repository_repo_path"))
04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	547 return q.one().ui_value
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	548
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	549 @property
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	550 def repo_full_path(self):
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	551 p = [self.repo_path]
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	552 # we need to split the name by / since this is how we store the
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	553 # names in the database, but that eventually needs to be converted
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	554 # into a valid system path
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	555 p += self.repo_name.split('/')
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	556 return os.path.join(*p)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	557
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	558 @property
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	559 def _ui(self):
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	560 """
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	561 Creates an db based ui object for this repository
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	562 """
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	563 from mercurial import ui
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	564 from mercurial import config
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	565 baseui = ui.ui()
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	566
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	567 #clean the baseui object
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	568 baseui._ocfg = config.config()
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	569 baseui._ucfg = config.config()
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	570 baseui._tcfg = config.config()
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	571
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	572
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	573 ret = Session.query(RhodeCodeUi)\
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	574 .options(FromCache("sql_cache_short", "repository_repo_ui")).all()
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	575
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	576 hg_ui = ret
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	577 for ui_ in hg_ui:
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	578 if ui_.ui_active:
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	579 log.debug('settings ui from db[%s]%s:%s', ui_.ui_section,
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	580 ui_.ui_key, ui_.ui_value)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	581 baseui.setconfig(ui_.ui_section, ui_.ui_key, ui_.ui_value)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	582
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	583 return baseui
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	584
1508 4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	585 @classmethod
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	586 def is_valid(cls, repo_name):
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	587 """
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	588 returns True if given repo name is a valid filesystem repository
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	589
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	590 @param cls:
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	591 @param repo_name:
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	592 """
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	593 from rhodecode.lib.utils import is_valid_repo
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	594
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	595 return is_valid_repo(repo_name, cls.base_path())
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	596
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	597
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	598 #==========================================================================
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	599 # SCM PROPERTIES
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	600 #==========================================================================
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	601
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	602 def get_changeset(self, rev):
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	603 return get_changeset_safe(self.scm_instance, rev)
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	604
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	605 @property
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	606 def tip(self):
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	607 return self.get_changeset('tip')
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	608
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	609 @property
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	610 def author(self):
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	611 return self.tip.author
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	612
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	613 @property
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	614 def last_change(self):
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	615 return self.scm_instance.last_change
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	616
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	617 #==========================================================================
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	618 # SCM CACHE INSTANCE
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	619 #==========================================================================
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	620
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	621 @property
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	622 def invalidate(self):
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	623 """
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	624 Returns Invalidation object if this repo should be invalidated
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	625 None otherwise. `cache_active = False` means that this cache
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	626 state is not valid and needs to be invalidated
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	627 """
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	628 return Session.query(CacheInvalidation)\
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	629 .filter(CacheInvalidation.cache_key == self.repo_name)\
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	630 .filter(CacheInvalidation.cache_active == False)\
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	631 .scalar()
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	632
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	633 def set_invalidate(self):
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	634 """
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	635 set a cache for invalidation for this instance
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	636 """
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	637 inv = Session.query(CacheInvalidation)\
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	638 .filter(CacheInvalidation.cache_key == self.repo_name)\
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	639 .scalar()
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	640
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	641 if inv is None:
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	642 inv = CacheInvalidation(self.repo_name)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	643 inv.cache_active = True
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	644 Session.add(inv)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	645 Session.commit()
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	646
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	647 @LazyProperty
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	648 def scm_instance(self):
1400 0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	649 return self.__get_instance()
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	650
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	651 @property
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	652 def scm_instance_cached(self):
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	653 @cache_region('long_term')
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	654 def _c(repo_name):
1400 0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	655 return self.__get_instance()
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	656
1428 e5467730682b fixed some issues with cache invalidation, and simplified invalidation codes Marcin Kuzminski <marcin@python-works.com> parents: 1427 diff changeset	657 # TODO: remove this trick when beaker 1.6 is released
e5467730682b fixed some issues with cache invalidation, and simplified invalidation codes Marcin Kuzminski <marcin@python-works.com> parents: 1427 diff changeset	658 # and have fixed this issue with not supporting unicode keys
e5467730682b fixed some issues with cache invalidation, and simplified invalidation codes Marcin Kuzminski <marcin@python-works.com> parents: 1427 diff changeset	659 rn = safe_str(self.repo_name)
e5467730682b fixed some issues with cache invalidation, and simplified invalidation codes Marcin Kuzminski <marcin@python-works.com> parents: 1427 diff changeset	660
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	661 inv = self.invalidate
1427 ba697e2f71ff fixed a bug in cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 1417 diff changeset	662 if inv is not None:
1428 e5467730682b fixed some issues with cache invalidation, and simplified invalidation codes Marcin Kuzminski <marcin@python-works.com> parents: 1427 diff changeset	663 region_invalidate(_c, None, rn)
e5467730682b fixed some issues with cache invalidation, and simplified invalidation codes Marcin Kuzminski <marcin@python-works.com> parents: 1427 diff changeset	664 # update our cache
1427 ba697e2f71ff fixed a bug in cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 1417 diff changeset	665 inv.cache_active = True
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	666 Session.add(inv)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	667 Session.commit()
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	668
1401 b7563ad4e7ee Unicode fixes, added safe_str method for global str() operations +better test sandboxing Marcin Kuzminski <marcin@python-works.com> parents: 1400 diff changeset	669 return _c(rn)
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	670
1400 0d7b56b97953 Simplified last_login call on user, and changed login to use User model directly Marcin Kuzminski <marcin@python-works.com> parents: 1388 diff changeset	671 def __get_instance(self):
1368 04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	672
04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	673 repo_full_path = self.repo_full_path
04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	674
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	675 try:
1368 04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	676 alias = get_scm(repo_full_path)[0]
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	677 log.debug('Creating instance of %s repository', alias)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	678 backend = get_backend(alias)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	679 except VCSError:
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	680 log.error(traceback.format_exc())
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	681 log.error('Perhaps this repository is in db and not in '
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	682 'filesystem run rescan repositories with '
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	683 '"destroy old data " option from admin panel')
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	684 return
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	685
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	686 if alias == 'hg':
1401 b7563ad4e7ee Unicode fixes, added safe_str method for global str() operations +better test sandboxing Marcin Kuzminski <marcin@python-works.com> parents: 1400 diff changeset	687
b7563ad4e7ee Unicode fixes, added safe_str method for global str() operations +better test sandboxing Marcin Kuzminski <marcin@python-works.com> parents: 1400 diff changeset	688 repo = backend(safe_str(repo_full_path), create=False,
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	689 baseui=self._ui)
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	690 #skip hidden web repository
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	691 if repo._get_hidden():
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	692 return
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	693 else:
1368 04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	694 repo = backend(repo_full_path, create=False)
1366 9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	695
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	696 return repo
9c0f5d558789 fixes #200, rewrote the whole caching mechanism to get rid of such problems. Now cached instances are attached Marcin Kuzminski <marcin@python-works.com> parents: 1360 diff changeset	697
1065 5d676b6ab71c Moved BaseModel into base class for declarative base. Added some handy methods into Marcin Kuzminski <marcin@python-works.com> parents: 1039 diff changeset	698
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	699 class Group(Base, BaseModel):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	700 __tablename__ = 'groups'
1349 526120c77a38 #47 added editing of groups, and moving them between. Added check constraint for groups Marcin Kuzminski <marcin@python-works.com> parents: 1346 diff changeset	701 __table_args__ = (UniqueConstraint('group_name', 'group_parent_id'),
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	702 CheckConstraint('group_id != group_parent_id'), {'extend_existing':True},)
1343 a04fe5986109 #47 implemented basic gui for browsing repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1325 diff changeset	703 __mapper_args__ = {'order_by':'group_name'}
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	704
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	705 group_id = Column("group_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	706 group_name = Column("group_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	707 group_parent_id = Column("group_parent_id", Integer(), ForeignKey('groups.group_id'), nullable=True, unique=None, default=None)
1343 a04fe5986109 #47 implemented basic gui for browsing repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1325 diff changeset	708 group_description = Column("group_description", String(length=10000, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	709
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	710 parent_group = relationship('Group', remote_side=group_id)
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	711
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	712
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	713 def __init__(self, group_name='', parent_group=None):
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	714 self.group_name = group_name
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	715 self.parent_group = parent_group
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	716
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	717 def __repr__(self):
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	718 return "<%s('%s:%s')>" % (self.__class__.__name__, self.group_id,
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	719 self.group_name)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	720
1346 cf78d302d441 #47 implemented deleting of empty groups. Fixed problem with full paths on nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1345 diff changeset	721 @classmethod
cf78d302d441 #47 implemented deleting of empty groups. Fixed problem with full paths on nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1345 diff changeset	722 def url_sep(cls):
cf78d302d441 #47 implemented deleting of empty groups. Fixed problem with full paths on nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1345 diff changeset	723 return '/'
cf78d302d441 #47 implemented deleting of empty groups. Fixed problem with full paths on nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1345 diff changeset	724
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	725 @property
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	726 def parents(self):
1385 7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	727 parents_recursion_limit = 5
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	728 groups = []
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	729 if self.parent_group is None:
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	730 return groups
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	731 cur_gr = self.parent_group
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	732 groups.insert(0, cur_gr)
1349 526120c77a38 #47 added editing of groups, and moving them between. Added check constraint for groups Marcin Kuzminski <marcin@python-works.com> parents: 1346 diff changeset	733 cnt = 0
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	734 while 1:
1349 526120c77a38 #47 added editing of groups, and moving them between. Added check constraint for groups Marcin Kuzminski <marcin@python-works.com> parents: 1346 diff changeset	735 cnt += 1
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	736 gr = getattr(cur_gr, 'parent_group', None)
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	737 cur_gr = cur_gr.parent_group
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	738 if gr is None:
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	739 break
1385 7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	740 if cnt == parents_recursion_limit:
1349 526120c77a38 #47 added editing of groups, and moving them between. Added check constraint for groups Marcin Kuzminski <marcin@python-works.com> parents: 1346 diff changeset	741 # this will prevent accidental infinit loops
526120c77a38 #47 added editing of groups, and moving them between. Added check constraint for groups Marcin Kuzminski <marcin@python-works.com> parents: 1346 diff changeset	742 log.error('group nested more than %s' %
1385 7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	743 parents_recursion_limit)
1349 526120c77a38 #47 added editing of groups, and moving them between. Added check constraint for groups Marcin Kuzminski <marcin@python-works.com> parents: 1346 diff changeset	744 break
526120c77a38 #47 added editing of groups, and moving them between. Added check constraint for groups Marcin Kuzminski <marcin@python-works.com> parents: 1346 diff changeset	745
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	746 groups.insert(0, gr)
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	747 return groups
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	748
1385 7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	749 @property
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	750 def children(self):
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	751 return Session.query(Group).filter(Group.parent_group == self)
1323 a7a772ea7b95 fixed saving settings on repositories inside groups, also fixes #187 Marcin Kuzminski <marcin@python-works.com> parents: 1301 diff changeset	752
a7a772ea7b95 fixed saving settings on repositories inside groups, also fixes #187 Marcin Kuzminski <marcin@python-works.com> parents: 1301 diff changeset	753 @property
a7a772ea7b95 fixed saving settings on repositories inside groups, also fixes #187 Marcin Kuzminski <marcin@python-works.com> parents: 1301 diff changeset	754 def full_path(self):
1346 cf78d302d441 #47 implemented deleting of empty groups. Fixed problem with full paths on nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1345 diff changeset	755 return Group.url_sep().join([g.group_name for g in self.parents] +
1323 a7a772ea7b95 fixed saving settings on repositories inside groups, also fixes #187 Marcin Kuzminski <marcin@python-works.com> parents: 1301 diff changeset	756 [self.group_name])
a7a772ea7b95 fixed saving settings on repositories inside groups, also fixes #187 Marcin Kuzminski <marcin@python-works.com> parents: 1301 diff changeset	757
1193 523382549c45 Added repo group page showing what reposiories are inside a group Marcin Kuzminski <marcin@python-works.com> parents: 1159 diff changeset	758 @property
523382549c45 Added repo group page showing what reposiories are inside a group Marcin Kuzminski <marcin@python-works.com> parents: 1159 diff changeset	759 def repositories(self):
1343 a04fe5986109 #47 implemented basic gui for browsing repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1325 diff changeset	760 return Session.query(Repository).filter(Repository.group == self)
1193 523382549c45 Added repo group page showing what reposiories are inside a group Marcin Kuzminski <marcin@python-works.com> parents: 1159 diff changeset	761
1385 7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	762 @property
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	763 def repositories_recursive_count(self):
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	764 cnt = self.repositories.count()
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	765
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	766 def children_count(group):
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	767 cnt = 0
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	768 for child in group.children:
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	769 cnt += child.repositories.count()
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	770 cnt += children_count(child)
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	771 return cnt
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	772
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	773 return cnt + children_count(self)
7e221629a3e5 #209 Added recursive count on repositories to calculate all repos within all nested groups Marcin Kuzminski <marcin@python-works.com> parents: 1381 diff changeset	774
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	775 class Permission(Base, BaseModel):
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 89 diff changeset	776 __tablename__ = 'permissions'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	777 __table_args__ = {'extend_existing':True}
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	778 permission_id = Column("permission_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	779 permission_name = Column("permission_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	780 permission_longname = Column("permission_longname", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	781
232 37a832dc4a82 some beaker cache changes, and added repr to models Marcin Kuzminski <marcin@python-works.com> parents: 226 diff changeset	782 def __repr__(self):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	783 return "<%s('%s:%s')>" % (self.__class__.__name__,
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	784 self.permission_id, self.permission_name)
296 29370bb76fa6 first permissions commit: added permission managment on repository edit. Changed db rmissions, validators. Marcin Kuzminski <marcin@python-works.com> parents: 265 diff changeset	785
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	786 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	787 def get_by_key(cls, key):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	788 return Session.query(cls).filter(cls.permission_name == key).scalar()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	789
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	790 class RepoToPerm(Base, BaseModel):
296 29370bb76fa6 first permissions commit: added permission managment on repository edit. Changed db rmissions, validators. Marcin Kuzminski <marcin@python-works.com> parents: 265 diff changeset	791 __tablename__ = 'repo_to_perm'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	792 __table_args__ = (UniqueConstraint('user_id', 'repository_id'), {'extend_existing':True})
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	793 repo_to_perm_id = Column("repo_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	794 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	795 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	796 repository_id = Column("repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=False, unique=None, default=None)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	797
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	798 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	799 permission = relationship('Permission')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	800 repository = relationship('Repository')
399 f5c1eec9f376 rename repo2perm into repo_to_perm Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	801
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	802 class UserToPerm(Base, BaseModel):
399 f5c1eec9f376 rename repo2perm into repo_to_perm Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	803 __tablename__ = 'user_to_perm'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	804 __table_args__ = (UniqueConstraint('user_id', 'permission_id'), {'extend_existing':True})
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	805 user_to_perm_id = Column("user_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	806 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	807 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	808
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	809 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	810 permission = relationship('Permission')
399 f5c1eec9f376 rename repo2perm into repo_to_perm Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	811
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	812 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	813 def has_perm(cls, user_id, perm):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	814 if not isinstance(perm, Permission):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	815 raise Exception('perm needs to be an instance of Permission class')
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	816
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	817 return Session.query(cls).filter(cls.user_id == user_id)\
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	818 .filter(cls.permission == perm).scalar() is not None
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	819
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	820 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	821 def grant_perm(cls, user_id, perm):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	822 if not isinstance(perm, Permission):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	823 raise Exception('perm needs to be an instance of Permission class')
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	824
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	825 new = cls()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	826 new.user_id = user_id
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	827 new.permission = perm
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	828 try:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	829 Session.add(new)
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	830 Session.commit()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	831 except:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	832 Session.rollback()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	833
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	834
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	835 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	836 def revoke_perm(cls, user_id, perm):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	837 if not isinstance(perm, Permission):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	838 raise Exception('perm needs to be an instance of Permission class')
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	839
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	840 try:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	841 Session.query(cls).filter(cls.user_id == user_id)\
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	842 .filter(cls.permission == perm).delete()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	843 Session.commit()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	844 except:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	845 Session.rollback()
1014 6fdc3ff65fce #56 added assignments of users groups into repository Marcin Kuzminski <marcin@python-works.com> parents: 1000 diff changeset	846
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	847 class UsersGroupRepoToPerm(Base, BaseModel):
1271 aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	848 __tablename__ = 'users_group_repo_to_perm'
1376 3fbc09ad1faf fixes issues #202, bad db constraint made impossible to attach same group more than one time. Marcin Kuzminski <marcin@python-works.com> parents: 1369 diff changeset	849 __table_args__ = (UniqueConstraint('repository_id', 'users_group_id', 'permission_id'), {'extend_existing':True})
958 7d1483f3170b added user group to perm table Marcin Kuzminski <marcin@python-works.com> parents: 956 diff changeset	850 users_group_to_perm_id = Column("users_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
959 fff21c9b075c #56 fixed found bugs, implemented adding of new group + forms+validators Marcin Kuzminski <marcin@python-works.com> parents: 958 diff changeset	851 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
958 7d1483f3170b added user group to perm table Marcin Kuzminski <marcin@python-works.com> parents: 956 diff changeset	852 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
1014 6fdc3ff65fce #56 added assignments of users groups into repository Marcin Kuzminski <marcin@python-works.com> parents: 1000 diff changeset	853 repository_id = Column("repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=False, unique=None, default=None)
958 7d1483f3170b added user group to perm table Marcin Kuzminski <marcin@python-works.com> parents: 956 diff changeset	854
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	855 users_group = relationship('UsersGroup')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	856 permission = relationship('Permission')
1014 6fdc3ff65fce #56 added assignments of users groups into repository Marcin Kuzminski <marcin@python-works.com> parents: 1000 diff changeset	857 repository = relationship('Repository')
958 7d1483f3170b added user group to perm table Marcin Kuzminski <marcin@python-works.com> parents: 956 diff changeset	858
1435 a62af7d509ee fixes #228 - added detection of assigned groups to prevent errors on sqlite Marcin Kuzminski <marcin@python-works.com> parents: 1428 diff changeset	859 def __repr__(self):
a62af7d509ee fixes #228 - added detection of assigned groups to prevent errors on sqlite Marcin Kuzminski <marcin@python-works.com> parents: 1428 diff changeset	860 return '<userGroup:%s => %s >' % (self.users_group, self.repository)
1271 aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	861
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	862 class UsersGroupToPerm(Base, BaseModel):
1271 aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	863 __tablename__ = 'users_group_to_perm'
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	864 users_group_to_perm_id = Column("users_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	865 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	866 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	867
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	868 users_group = relationship('UsersGroup')
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	869 permission = relationship('Permission')
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	870
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	871
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	872 @classmethod
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	873 def has_perm(cls, users_group_id, perm):
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	874 if not isinstance(perm, Permission):
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	875 raise Exception('perm needs to be an instance of Permission class')
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	876
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	877 return Session.query(cls).filter(cls.users_group_id ==
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	878 users_group_id)\
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	879 .filter(cls.permission == perm)\
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	880 .scalar() is not None
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	881
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	882 @classmethod
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	883 def grant_perm(cls, users_group_id, perm):
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	884 if not isinstance(perm, Permission):
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	885 raise Exception('perm needs to be an instance of Permission class')
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	886
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	887 new = cls()
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	888 new.users_group_id = users_group_id
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	889 new.permission = perm
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	890 try:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	891 Session.add(new)
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	892 Session.commit()
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	893 except:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	894 Session.rollback()
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	895
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	896
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	897 @classmethod
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	898 def revoke_perm(cls, users_group_id, perm):
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	899 if not isinstance(perm, Permission):
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	900 raise Exception('perm needs to be an instance of Permission class')
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	901
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	902 try:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	903 Session.query(cls).filter(cls.users_group_id == users_group_id)\
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	904 .filter(cls.permission == perm).delete()
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	905 Session.commit()
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	906 except:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	907 Session.rollback()
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	908
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	909
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	910 class GroupToPerm(Base, BaseModel):
879 b19341623d48 added group to perm mapping table Marcin Kuzminski <marcin@python-works.com> parents: 878 diff changeset	911 __tablename__ = 'group_to_perm'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	912 __table_args__ = (UniqueConstraint('group_id', 'permission_id'), {'extend_existing':True})
879 b19341623d48 added group to perm mapping table Marcin Kuzminski <marcin@python-works.com> parents: 878 diff changeset	913
b19341623d48 added group to perm mapping table Marcin Kuzminski <marcin@python-works.com> parents: 878 diff changeset	914 group_to_perm_id = Column("group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	915 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	916 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	917 group_id = Column("group_id", Integer(), ForeignKey('groups.group_id'), nullable=False, unique=None, default=None)
879 b19341623d48 added group to perm mapping table Marcin Kuzminski <marcin@python-works.com> parents: 878 diff changeset	918
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	919 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	920 permission = relationship('Permission')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	921 group = relationship('Group')
879 b19341623d48 added group to perm mapping table Marcin Kuzminski <marcin@python-works.com> parents: 878 diff changeset	922
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	923 class Statistics(Base, BaseModel):
493 2256c78afe53 implemented basic autoupdating statistics fetched from database Marcin Kuzminski <marcin@python-works.com> parents: 473 diff changeset	924 __tablename__ = 'statistics'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	925 __table_args__ = (UniqueConstraint('repository_id'), {'extend_existing':True})
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	926 stat_id = Column("stat_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	927 repository_id = Column("repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=False, unique=True, default=None)
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	928 stat_on_revision = Column("stat_on_revision", Integer(), nullable=False)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	929 commit_activity = Column("commit_activity", LargeBinary(1000000), nullable=False)#JSON data
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	930 commit_activity_combined = Column("commit_activity_combined", LargeBinary(), nullable=False)#JSON data
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	931 languages = Column("languages", LargeBinary(1000000), nullable=False)#JSON data
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	932
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	933 repository = relationship('Repository', single_parent=True)
399 f5c1eec9f376 rename repo2perm into repo_to_perm Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	934
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	935 class UserFollowing(Base, BaseModel):
734 49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	936 __tablename__ = 'user_followings'
49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	937 __table_args__ = (UniqueConstraint('user_id', 'follows_repository_id'),
49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	938 UniqueConstraint('user_id', 'follows_user_id')
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	939 , {'extend_existing':True})
734 49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	940
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	941 user_following_id = Column("user_following_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	942 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	943 follows_repo_id = Column("follows_repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=True, unique=None, default=None)
014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	944 follows_user_id = Column("follows_user_id", Integer(), ForeignKey('users.user_id'), nullable=True, unique=None, default=None)
1279 cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	945 follows_from = Column('follows_from', DateTime(timezone=False), nullable=True, unique=None, default=datetime.datetime.now)
734 49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	946
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	947 user = relationship('User', primaryjoin='User.user_id==UserFollowing.user_id')
734 49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	948
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	949 follows_user = relationship('User', primaryjoin='User.user_id==UserFollowing.follows_user_id')
1000 229437211bef Optimized queries on journal, and added quick stop following action button in journal Marcin Kuzminski <marcin@python-works.com> parents: 994 diff changeset	950 follows_repository = relationship('Repository', order_by='Repository.repo_name')
734 49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	951
1279 cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	952
cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	953 @classmethod
cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	954 def get_repo_followers(cls, repo_id):
cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	955 return Session.query(cls).filter(cls.follows_repo_id == repo_id)
cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	956
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	957 class CacheInvalidation(Base, BaseModel):
670 e7c670cc03cb Adde table for cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 667 diff changeset	958 __tablename__ = 'cache_invalidation'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	959 __table_args__ = (UniqueConstraint('cache_key'), {'extend_existing':True})
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	960 cache_id = Column("cache_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	961 cache_key = Column("cache_key", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	962 cache_args = Column("cache_args", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	963 cache_active = Column("cache_active", Boolean(), nullable=True, unique=None, default=False)
670 e7c670cc03cb Adde table for cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 667 diff changeset	964
e7c670cc03cb Adde table for cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 667 diff changeset	965
692 cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	966 def __init__(self, cache_key, cache_args=''):
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	967 self.cache_key = cache_key
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	968 self.cache_args = cache_args
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	969 self.cache_active = False
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	970
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	971 def __repr__(self):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	972 return "<%s('%s:%s')>" % (self.__class__.__name__,
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	973 self.cache_id, self.cache_key)
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	974
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	975 class DbMigrateVersion(Base, BaseModel):
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	976 __tablename__ = 'db_migrate_version'
1360 1f47adeb67c2 Bumped sqlalchemy version to 0.7, replaced timerproxy with new event system for sqlalchemy. Marcin Kuzminski <marcin@python-works.com> parents: 1349 diff changeset	977 __table_args__ = {'extend_existing':True}
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	978 repository_id = Column('repository_id', String(250), primary_key=True)
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	979 repository_path = Column('repository_path', Text)
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	980 version = Column('version', Integer)

Mercurial > kallithea

annotate rhodecode/model/db.py @ 1515:da8f1d1b22de