kallithea: rhodecode/model/db.py annotate

annotate rhodecode/model/db.py @ 1546:c363267bbec7 beta

fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter into model that will provent from this errors on db model level

author	Marcin Kuzminski <marcin@python-works.com>
date	Tue, 11 Oct 2011 21:38:27 +0200
parents	bd604cf75c5a
children	fbc762ae3496

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
1546 c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	34 from sqlalchemy.ext.hybrid import hybrid_property
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	35 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	36 from sqlalchemy.orm.interfaces import MapperExtension
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	37
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	38 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	39
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 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	41 from vcs.utils.helpers import get_scm
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	42 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	43 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	44
1514 87ec80c280bb fixed issues with python2.5 Marcin Kuzminski <marcin@python-works.com> parents: 1508 diff changeset	45 from rhodecode.lib import str2bool, safe_str, get_changeset_safe, \
1546 c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	46 generate_api_key, safe_unicode
1436 88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	47 from rhodecode.lib.exceptions import UsersGroupsAssignedException
1514 87ec80c280bb fixed issues with python2.5 Marcin Kuzminski <marcin@python-works.com> parents: 1508 diff changeset	48 from rhodecode.lib.compat import json
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	49
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	50 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	51 from rhodecode.model.caching_query import FromCache
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	52
1546 c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	53
442 d66a7fa7689b moved loged in user propagation out of forms, Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	54 log = logging.getLogger(__name__)
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	55
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	56 #==============================================================================
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	57 # BASE CLASSES
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	58 #==============================================================================
70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	59
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	60 class ModelSerializer(json.JSONEncoder):
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 Simple Serializer for JSON,
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 usage::
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	65
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	66 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	67 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	68
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	69 example::
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 class Task(object):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	72
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	73 def __init__(self, name, value):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	74 self.name = name
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	75 self.value = value
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	76
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	77 def __json__(self):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	78 return dict(name=self.name,
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	79 value=self.value)
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 """
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 def default(self, obj):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	84
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	85 if hasattr(obj, '__json__'):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	86 return obj.__json__()
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	87 else:
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	88 return json.JSONEncoder.default(self, obj)
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	89
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	90 class BaseModel(object):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	91 """Base Model for all classess
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 """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	94
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	95 @classmethod
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	96 def _get_keys(cls):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	97 """return column names for this model """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	98 return class_mapper(cls).c.keys()
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	99
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	100 def get_dict(self):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	101 """return dict with keys and values corresponding
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	102 to this model data """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	103
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	104 d = {}
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	105 for k in self._get_keys():
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	106 d[k] = getattr(self, k)
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	107 return d
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	108
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	109 def get_appstruct(self):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	110 """return list with keys and values tupples corresponding
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	111 to this model data """
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	112
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	113 l = []
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	114 for k in self._get_keys():
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	115 l.append((k, getattr(self, k),))
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	116 return l
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	117
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	118 def populate_obj(self, populate_dict):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	119 """populate model with data from given populate_dict"""
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	120
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	121 for k in self._get_keys():
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	122 if k in populate_dict:
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	123 setattr(self, k, populate_dict[k])
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	124
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	125 @classmethod
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	126 def query(cls):
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	127 return Session.query(cls)
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	128
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	129 @classmethod
2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	130 def get(cls, id_):
1538 27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	131 if id_:
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	132 return Session.query(cls).get(id_)
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	133
1460 b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	134 @classmethod
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	135 def delete(cls, id_):
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	136 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	137 Session.delete(obj)
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	138 Session.commit()
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	139
1081 70bf0be59653 fixed Session problems in model class functions Marcin Kuzminski <marcin@python-works.com> parents: 1065 diff changeset	140
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	141 class RhodeCodeSettings(Base, BaseModel):
548 b75b77ef649d renamed hg_app to rhodecode Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	142 __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	143 __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	144 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	145 app_settings_name = Column("app_settings_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
1546 c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	146 _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	147
907 2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	148 def __init__(self, k='', v=''):
704 26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	149 self.app_settings_name = k
26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	150 self.app_settings_value = v
26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	151
1546 c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	152
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	153 @hybrid_property
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	154 def app_settings_value(self):
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	155 v = self._app_settings_value
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	156 if v == 'ldap_active':
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	157 v = str2bool(v)
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	158 return v
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	159
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	160 @app_settings_value.setter
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	161 def app_settings_value(self,val):
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	162 """
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	163 Setter that will always make sure we use unicode in app_settings_value
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	164
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	165 :param val:
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	166 """
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	167 self._app_settings_value = safe_unicode(val)
c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	168
704 26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 692 diff changeset	169 def __repr__(self):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	170 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	171 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	172
1266 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 @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	175 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	176 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	177 .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	178
c0335c1dee36 added some fixes to LDAP form re-submition, new simples ldap-settings getter. Marcin Kuzminski <marcin@python-works.com> parents: 1279 diff changeset	179 @classmethod
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	180 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	181
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	182 ret = Session.query(cls)
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	183
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	184 if cache:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	185 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	186
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	187 if not ret:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	188 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	189 settings = {}
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	190 for each in ret:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	191 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	192 each.app_settings_value
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	193
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	194 return settings
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	195
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	196 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	197 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	198 ret = Session.query(cls)\
1546 c363267bbec7 fixes #265 ldap save fails sometimes on converting attributes to booleans, added getter and setter Marcin Kuzminski <marcin@python-works.com> parents: 1539 diff changeset	199 .filter(cls.app_settings_name.startswith('ldap_')).all()
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	200 fd = {}
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	201 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	202 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	203
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	204 return fd
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	205
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	206
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	207 class RhodeCodeUi(Base, BaseModel):
548 b75b77ef649d renamed hg_app to rhodecode Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	208 __tablename__ = 'rhodecode_ui'
1460 b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	209 __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	210
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	211 HOOK_UPDATE = 'changegroup.update'
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	212 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	213 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	214 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	215
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	216 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	217 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	218 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	219 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	220 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	221
05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	222
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	223 @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	224 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	225 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	226
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	227
1460 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 get_builtin_hooks(cls):
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	230 q = cls.query()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	231 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	232 cls.HOOK_REPO_SIZE,
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	233 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	234 return q.all()
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 @classmethod
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	237 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	238 q = cls.query()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	239 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	240 cls.HOOK_REPO_SIZE,
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	241 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	242 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	243 return q.all()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	244
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	245 @classmethod
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	246 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	247 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	248 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	249 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	250 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	251 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	252
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	253 Session.add(new_ui)
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	254 Session.commit()
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	255
b50348816a80 Added more advanced hook management into rhodecode admin settings Marcin Kuzminski <marcin@python-works.com> parents: 1436 diff changeset	256
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	257 class User(Base, BaseModel):
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	258 __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	259 __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	260 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	261 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	262 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	263 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	264 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	265 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	266 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	267 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	268 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	269 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	270 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	271
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	272 user_log = relationship('UserLog', cascade='all')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	273 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	274
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	275 repositories = relationship('Repository')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	276 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	277 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	278
1039 51b70569c330 extended admin rescan to show what repositories was added and what removed Marcin Kuzminski <marcin@python-works.com> parents: 1034 diff changeset	279 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	280
759 a7f50911a945 Models code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 734 diff changeset	281 @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	282 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	283 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	284
895 62c04c5cc971 Added some more details into user edit permissions view Marcin Kuzminski <marcin@python-works.com> parents: 880 diff changeset	285 @property
1088 fee472613dfa made simple global rss and atom feed Marcin Kuzminski <marcin@python-works.com> parents: 1081 diff changeset	286 def short_contact(self):
fee472613dfa made simple global rss and atom feed Marcin Kuzminski <marcin@python-works.com> parents: 1081 diff changeset	287 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	288
fee472613dfa made simple global rss and atom feed Marcin Kuzminski <marcin@python-works.com> parents: 1081 diff changeset	289 @property
895 62c04c5cc971 Added some more details into user edit permissions view Marcin Kuzminski <marcin@python-works.com> parents: 880 diff changeset	290 def is_admin(self):
62c04c5cc971 Added some more details into user edit permissions view Marcin Kuzminski <marcin@python-works.com> parents: 880 diff changeset	291 return self.admin
62c04c5cc971 Added some more details into user edit permissions view Marcin Kuzminski <marcin@python-works.com> parents: 880 diff changeset	292
232 37a832dc4a82 some beaker cache changes, and added repr to models Marcin Kuzminski <marcin@python-works.com> parents: 226 diff changeset	293 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	294 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	295 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	296 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	297 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	298 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	299
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	300 @classmethod
1530 04027bdb876c Refactoring of model get functions Marcin Kuzminski <marcin@python-works.com> parents: 1514 diff changeset	301 def get_by_username(cls, username, case_insensitive=False):
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	302 if case_insensitive:
1539 bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	303 return Session.query(cls).filter(cls.username.ilike(username)).scalar()
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	304 else:
1530 04027bdb876c Refactoring of model get functions Marcin Kuzminski <marcin@python-works.com> parents: 1514 diff changeset	305 return Session.query(cls).filter(cls.username == username).scalar()
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	306
1417 5875955def39 fixes #223 improve password reset form Marcin Kuzminski <marcin@python-works.com> parents: 1401 diff changeset	307 @classmethod
5875955def39 fixes #223 improve password reset form Marcin Kuzminski <marcin@python-works.com> parents: 1401 diff changeset	308 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	309 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	310
442 d66a7fa7689b moved loged in user propagation out of forms, Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	311 def update_lastlogin(self):
d66a7fa7689b moved loged in user propagation out of forms, Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	312 """Update user lastlogin"""
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	313
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	314 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	315 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	316 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	317 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	318
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	319 @classmethod
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	320 def create(cls, form_data):
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	321 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	322
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	323 try:
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	324 new_user = cls()
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	325 for k, v in form_data.items():
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	326 if k == 'password':
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	327 v = get_crypt_password(v)
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	328 setattr(new_user, k, v)
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	329
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	330 new_user.api_key = generate_api_key(form_data['username'])
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	331 Session.add(new_user)
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	332 Session.commit()
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	333 return new_user
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	334 except:
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	335 log.error(traceback.format_exc())
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	336 Session.rollback()
256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	337 raise
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	338
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	339 class UserLog(Base, BaseModel):
49 3ada2f409c1c Added sqlalchemy support Marcin Kuzminski <marcin@python-blog.com> parents: diff changeset	340 __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	341 __table_args__ = {'extend_existing':True}
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	342 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	343 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	344 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	345 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	346 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	347 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	348 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	349
994 7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	350 @property
7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	351 def action_as_day(self):
7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	352 return date(*self.action_date.timetuple()[:3])
7f9d23f6a526 Added grouping by days in journal Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	353
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	354 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	355 repository = relationship('Repository')
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	356
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	357
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	358 class UsersGroup(Base, BaseModel):
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	359 __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	360 __table_args__ = {'extend_existing':True}
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	361
959 fff21c9b075c #56 fixed found bugs, implemented adding of new group + forms+validators Marcin Kuzminski <marcin@python-works.com> parents: 958 diff changeset	362 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	363 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	364 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	365
974 f6658c70eeeb #56 fixed relationship query behavior to speed up fetching, and Marcin Kuzminski <marcin@python-works.com> parents: 972 diff changeset	366 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	367
1435 a62af7d509ee fixes #228 - added detection of assigned groups to prevent errors on sqlite Marcin Kuzminski <marcin@python-works.com> parents: 1428 diff changeset	368 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	369 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	370
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	371 @classmethod
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	372 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	373 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	374 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	375 .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	376 else:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	377 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	378 .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	379 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	380 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	381 "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	382 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	383
1436 88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	384
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	385 @classmethod
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	386 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	387 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	388 if cache:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	389 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	390 "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	391 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	392
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	393 @classmethod
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	394 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	395 try:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	396 new_users_group = cls()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	397 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	398 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	399
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	400 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	401 Session.commit()
1500 256e729a94cd Extended API Marcin Kuzminski <marcin@python-works.com> parents: 1466 diff changeset	402 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	403 except:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	404 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	405 Session.rollback()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	406 raise
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	407
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	408 @classmethod
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	409 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	410
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	411 try:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	412 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	413
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	414 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	415 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	416 users_group.members = []
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	417 Session.flush()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	418 members_list = []
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	419 if v:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	420 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	421 members_list.append(UsersGroupMember(
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	422 users_group_id,
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	423 u_id))
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	424 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	425 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	426
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	427 Session.add(users_group)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	428 Session.commit()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	429 except:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	430 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	431 Session.rollback()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	432 raise
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	433
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	434 @classmethod
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	435 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	436 try:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	437
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	438 # 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	439 assigned_groups = UsersGroupRepoToPerm.query()\
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	440 .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	441 users_group_id).all()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	442
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	443 if assigned_groups:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	444 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	445 assigned_groups)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	446
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	447 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	448 Session.delete(users_group)
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	449 Session.commit()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	450 except:
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	451 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	452 Session.rollback()
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	453 raise
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	454
88d13c1c6a55 removed users_group controller in replace for model methods, Marcin Kuzminski <marcin@python-works.com> parents: 1435 diff changeset	455
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	456 class UsersGroupMember(Base, BaseModel):
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	457 __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	458 __table_args__ = {'extend_existing':True}
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	459
959 fff21c9b075c #56 fixed found bugs, implemented adding of new group + forms+validators Marcin Kuzminski <marcin@python-works.com> parents: 958 diff changeset	460 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	461 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	462 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	463
974 f6658c70eeeb #56 fixed relationship query behavior to speed up fetching, and Marcin Kuzminski <marcin@python-works.com> parents: 972 diff changeset	464 user = relationship('User', lazy='joined')
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	465 users_group = relationship('UsersGroup')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	466
1023 e7478ac19f9f updated db migrations to schema 3 Marcin Kuzminski <marcin@python-works.com> parents: 1015 diff changeset	467 def __init__(self, gr_id='', u_id=''):
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	468 self.users_group_id = gr_id
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	469 self.user_id = u_id
956 83d35d716a02 started working on issue #56 Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	470
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	471 class Repository(Base, BaseModel):
234 a0116e944da1 changed naming convention for db modules. Marcin Kuzminski <marcin@python-works.com> parents: 232 diff changeset	472 __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	473 __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	474
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	475 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	476 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	477 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	478 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	479 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	480 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	481 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	482 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	483 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	484 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	485
880 014071a745da removed unicode from models string params Marcin Kuzminski <marcin@python-works.com> parents: 879 diff changeset	486 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	487 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	488
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	489
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	490 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	491 fork = relationship('Repository', remote_side=repo_id)
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	492 group = relationship('Group')
1033 e2ebbb27df4e fixed problem with caching Marcin Kuzminski <marcin@python-works.com> parents: 1023 diff changeset	493 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	494 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	495 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	496
1034 9e59b16d1b48 updated config files, and changed model repo_followers to followers Marcin Kuzminski <marcin@python-works.com> parents: 1033 diff changeset	497 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	498
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	499 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	500
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 414 diff changeset	501 def __repr__(self):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	502 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	503 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	504
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	505 @classmethod
1530 04027bdb876c Refactoring of model get functions Marcin Kuzminski <marcin@python-works.com> parents: 1514 diff changeset	506 def get_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	507 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	508
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	509 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	510 .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	511 .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	512
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	513 return q.one()
1301 7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	514
7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	515 @classmethod
7e75af301842 Added simple forks page, resolves issue #179 Marcin Kuzminski <marcin@python-works.com> parents: 1292 diff changeset	516 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	517 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	518
1508 4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	519 @classmethod
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	520 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	521 """
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	522 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	523
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	524 :param cls:
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	525 """
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	526 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	527 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	528 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	529
1113 c1eda8ec4a46 added clone_uri,api_key into models. Fixed models for mysql compatibilty Marcin Kuzminski <marcin@python-works.com> parents: 1088 diff changeset	530 @property
1155 37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	531 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	532 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	533
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	534 @property
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	535 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	536 groups = []
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	537 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	538 return groups
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	539
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	540 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	541 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	542 while 1:
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	543 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	544 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	545 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	546 break
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	547 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	548
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	549 return groups
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	550
37a9421f32a0 Added handy methods to Repository model for fetching groups with parents Marcin Kuzminski <marcin@python-works.com> parents: 1113 diff changeset	551 @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	552 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	553 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	554
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	555 @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	556 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	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 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	559 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	560 """
1368 04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	561 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	562 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	563 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	564
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 @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	566 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	567 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	568 # 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	569 # 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	570 # 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	571 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	572 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	573
1539 bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	574 def get_new_name(self, repo_name):
bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	575 """
bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	576 returns new full repository name based on assigned group and new new
bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	577
bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	578 :param group_name:
bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	579 """
bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	580 path_prefix = self.group.full_path_splitted if self.group else []
bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	581 return '/'.join(path_prefix + [repo_name])
bd604cf75c5a fixes #260 Put repo in group, then move group to another group -> repo becomes unavailable Marcin Kuzminski <marcin@python-works.com> parents: 1538 diff changeset	582
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	583 @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	584 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	585 """
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	586 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	587 """
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	588 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	589 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	590 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	591
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	592 #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	593 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	594 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	595 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	596
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	597
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 ret = Session.query(RhodeCodeUi)\
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	599 .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	600
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	601 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	602 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	603 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	604 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	605 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	606 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	607
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	608 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	609
1508 4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	610 @classmethod
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	611 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	612 """
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	613 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	614
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	615 @param cls:
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	616 @param repo_name:
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	617 """
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	618 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	619
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	620 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	621
4aba7be311e8 API added checks for a valid repository on pull command Marcin Kuzminski <marcin@python-works.com> parents: 1500 diff changeset	622
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	623 #==========================================================================
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	624 # SCM PROPERTIES
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	625 #==========================================================================
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	626
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	627 def get_changeset(self, rev):
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	628 return get_changeset_safe(self.scm_instance, rev)
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	629
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	630 @property
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	631 def tip(self):
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	632 return self.get_changeset('tip')
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	633
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	634 @property
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	635 def author(self):
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	636 return self.tip.author
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	637
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	638 @property
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	639 def last_change(self):
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	640 return self.scm_instance.last_change
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	641
ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	642 #==========================================================================
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	643 # 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	644 #==========================================================================
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
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 @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	647 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	648 """
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	649 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	650 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	651 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	652 """
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 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	654 .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	655 .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	656 .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	657
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	658 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	659 """
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	660 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	661 """
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	662 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	663 .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	664 .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	665
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 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	667 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	668 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	669 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	670 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	671
1466 ad5a543a9b2f Code cleanup Marcin Kuzminski <marcin@python-works.com> parents: 1460 diff changeset	672 @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	673 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	674 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	675
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	676 @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	677 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	678 @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	679 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	680 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	681
1428 e5467730682b fixed some issues with cache invalidation, and simplified invalidation codes Marcin Kuzminski <marcin@python-works.com> parents: 1427 diff changeset	682 # 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	683 # 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	684 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	685
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	686 inv = self.invalidate
1427 ba697e2f71ff fixed a bug in cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 1417 diff changeset	687 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	688 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	689 # update our cache
1427 ba697e2f71ff fixed a bug in cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 1417 diff changeset	690 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	691 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	692 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	693
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	694 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	695
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	696 def __get_instance(self):
1368 04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	697
04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	698 repo_full_path = self.repo_full_path
04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	699
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	700 try:
1368 04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	701 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	702 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	703 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	704 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	705 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	706 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	707 '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	708 '"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	709 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	710
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	711 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	712
b7563ad4e7ee Unicode fixes, added safe_str method for global str() operations +better test sandboxing Marcin Kuzminski <marcin@python-works.com> parents: 1400 diff changeset	713 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	714 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	715 #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	716 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	717 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	718 else:
1368 04b43168742d adde short cache for repo_path Marcin Kuzminski <marcin@python-works.com> parents: 1366 diff changeset	719 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	720
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	721 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	722
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	723
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	724 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	725 __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	726 __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	727 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	728 __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	729
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	730 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	731 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	732 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	733 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	734
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	735 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	736
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	737
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	738 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	739 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	740 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	741
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	742 def __repr__(self):
859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	743 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	744 self.group_name)
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	745
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	746 @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	747 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	748 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	749
1538 27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	750 @classmethod
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	751 def get_by_group_name(cls, group_name):
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	752 return cls.query().filter(cls.group_name == group_name).scalar()
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	753
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	754 @property
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	755 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	756 parents_recursion_limit = 5
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	757 groups = []
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	758 if self.parent_group is None:
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	759 return groups
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	760 cur_gr = self.parent_group
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	761 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	762 cnt = 0
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	763 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	764 cnt += 1
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	765 gr = getattr(cur_gr, 'parent_group', None)
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	766 cur_gr = cur_gr.parent_group
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	767 if gr is None:
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	768 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	769 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	770 # 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	771 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	772 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	773 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	774
1159 187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	775 groups.insert(0, gr)
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	776 return groups
187a924ed653 Changes for repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1155 diff changeset	777
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	778 @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	779 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	780 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	781
a7a772ea7b95 fixed saving settings on repositories inside groups, also fixes #187 Marcin Kuzminski <marcin@python-works.com> parents: 1301 diff changeset	782 @property
1538 27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	783 def name(self):
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	784 return self.group_name.split(Group.url_sep())[-1]
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	785
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	786 @property
1323 a7a772ea7b95 fixed saving settings on repositories inside groups, also fixes #187 Marcin Kuzminski <marcin@python-works.com> parents: 1301 diff changeset	787 def full_path(self):
1538 27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	788 return self.group_name
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	789
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	790 @property
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	791 def full_path_splitted(self):
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	792 return self.group_name.split(Group.url_sep())
1323 a7a772ea7b95 fixed saving settings on repositories inside groups, also fixes #187 Marcin Kuzminski <marcin@python-works.com> parents: 1301 diff changeset	793
1193 523382549c45 Added repo group page showing what reposiories are inside a group Marcin Kuzminski <marcin@python-works.com> parents: 1159 diff changeset	794 @property
523382549c45 Added repo group page showing what reposiories are inside a group Marcin Kuzminski <marcin@python-works.com> parents: 1159 diff changeset	795 def repositories(self):
1343 a04fe5986109 #47 implemented basic gui for browsing repo groups Marcin Kuzminski <marcin@python-works.com> parents: 1325 diff changeset	796 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	797
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	798 @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	799 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	800 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	801
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	802 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	803 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	804 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	805 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	806 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	807 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	808
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	809 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	810
1538 27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	811
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	812 def get_new_name(self, group_name):
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	813 """
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	814 returns new full group name based on parent and new name
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	815
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	816 :param group_name:
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	817 """
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	818 path_prefix = self.parent_group.full_path_splitted if self.parent_group else []
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	819 return Group.url_sep().join(path_prefix + [group_name])
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	820
27be8f94c207 implements #226 repo groups available by path Marcin Kuzminski <marcin@python-works.com> parents: 1530 diff changeset	821
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	822 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	823 __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	824 __table_args__ = {'extend_existing':True}
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	825 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	826 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	827 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	828
232 37a832dc4a82 some beaker cache changes, and added repr to models Marcin Kuzminski <marcin@python-works.com> parents: 226 diff changeset	829 def __repr__(self):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	830 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	831 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	832
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	833 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	834 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	835 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	836
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	837 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	838 __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	839 __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	840 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	841 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	842 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	843 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	844
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	845 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	846 permission = relationship('Permission')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	847 repository = relationship('Repository')
399 f5c1eec9f376 rename repo2perm into repo_to_perm Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	848
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	849 class UserToPerm(Base, BaseModel):
399 f5c1eec9f376 rename repo2perm into repo_to_perm Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	850 __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	851 __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	852 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	853 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	854 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	855
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	856 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	857 permission = relationship('Permission')
399 f5c1eec9f376 rename repo2perm into repo_to_perm Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	858
1266 a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	859 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	860 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	861 if not isinstance(perm, Permission):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	862 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	863
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	864 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	865 .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	866
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	867 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	868 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	869 if not isinstance(perm, Permission):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	870 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	871
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	872 new = cls()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	873 new.user_id = user_id
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	874 new.permission = perm
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	875 try:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	876 Session.add(new)
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	877 Session.commit()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	878 except:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	879 Session.rollback()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	880
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	881
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	882 @classmethod
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	883 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	884 if not isinstance(perm, Permission):
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	885 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	886
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	887 try:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	888 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	889 .filter(cls.permission == perm).delete()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	890 Session.commit()
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	891 except:
a1bcfe58a1ab Fixed #161 form saves the create repository permission. Marcin Kuzminski <marcin@python-works.com> parents: 1206 diff changeset	892 Session.rollback()
1014 6fdc3ff65fce #56 added assignments of users groups into repository Marcin Kuzminski <marcin@python-works.com> parents: 1000 diff changeset	893
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	894 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	895 __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	896 __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	897 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	898 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	899 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	900 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	901
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	902 users_group = relationship('UsersGroup')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	903 permission = relationship('Permission')
1014 6fdc3ff65fce #56 added assignments of users groups into repository Marcin Kuzminski <marcin@python-works.com> parents: 1000 diff changeset	904 repository = relationship('Repository')
958 7d1483f3170b added user group to perm table Marcin Kuzminski <marcin@python-works.com> parents: 956 diff changeset	905
1435 a62af7d509ee fixes #228 - added detection of assigned groups to prevent errors on sqlite Marcin Kuzminski <marcin@python-works.com> parents: 1428 diff changeset	906 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	907 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	908
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	909 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	910 __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	911 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	912 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	913 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	914
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	915 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	916 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	917
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	918
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	919 @classmethod
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	920 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	921 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	922 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	923
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	924 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	925 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	926 .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	927 .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	928
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	929 @classmethod
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	930 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	931 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	932 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	933
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	934 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	935 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	936 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	937 try:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	938 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	939 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	940 except:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	941 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	942
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	943
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	944 @classmethod
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	945 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	946 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	947 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	948
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	949 try:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	950 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	951 .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	952 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	953 except:
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	954 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	955
aa7e45ad0cea Fixed permissions for users groups, group can have create repo permission now. Marcin Kuzminski <marcin@python-works.com> parents: 1266 diff changeset	956
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	957 class GroupToPerm(Base, BaseModel):
879 b19341623d48 added group to perm mapping table Marcin Kuzminski <marcin@python-works.com> parents: 878 diff changeset	958 __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	959 __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	960
b19341623d48 added group to perm mapping table Marcin Kuzminski <marcin@python-works.com> parents: 878 diff changeset	961 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	962 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	963 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	964 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	965
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	966 user = relationship('User')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	967 permission = relationship('Permission')
2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	968 group = relationship('Group')
879 b19341623d48 added group to perm mapping table Marcin Kuzminski <marcin@python-works.com> parents: 878 diff changeset	969
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	970 class Statistics(Base, BaseModel):
493 2256c78afe53 implemented basic autoupdating statistics fetched from database Marcin Kuzminski <marcin@python-works.com> parents: 473 diff changeset	971 __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	972 __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	973 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	974 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	975 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	976 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	977 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	978 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	979
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	980 repository = relationship('Repository', single_parent=True)
399 f5c1eec9f376 rename repo2perm into repo_to_perm Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	981
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	982 class UserFollowing(Base, BaseModel):
734 49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	983 __tablename__ = 'user_followings'
49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	984 __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	985 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	986 , {'extend_existing':True})
734 49eb69d78988 implemented user dashboards, and following system. Marcin Kuzminski <marcin@python-works.com> parents: 713 diff changeset	987
780 92fa9c3414d0 fixed models for compatibility with database systems Marcin Kuzminski <marcin@python-works.com> parents: 759 diff changeset	988 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	989 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	990 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	991 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	992 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	993
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	994 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	995
972 2c8fd84935a4 #56 implemented users groups editing, Marcin Kuzminski <marcin@python-works.com> parents: 962 diff changeset	996 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	997 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	998
1279 cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	999
cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	1000 @classmethod
cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	1001 def get_repo_followers(cls, repo_id):
cb216757a62d #179 Added followers page Marcin Kuzminski <marcin@python-works.com> parents: 1271 diff changeset	1002 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	1003
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	1004 class CacheInvalidation(Base, BaseModel):
670 e7c670cc03cb Adde table for cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 667 diff changeset	1005 __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	1006 __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	1007 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	1008 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	1009 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	1010 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	1011
e7c670cc03cb Adde table for cache invalidation Marcin Kuzminski <marcin@python-works.com> parents: 667 diff changeset	1012
692 cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	1013 def __init__(self, cache_key, cache_args=''):
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	1014 self.cache_key = cache_key
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	1015 self.cache_args = cache_args
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	1016 self.cache_active = False
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	1017
cb0d9ce6ac5c #50 on point cache invalidation changes. Marcin Kuzminski <marcin@python-works.com> parents: 670 diff changeset	1018 def __repr__(self):
878 859bc9e7a15d Extended repo2db mapper with group creation via directory structures Marcin Kuzminski <marcin@python-works.com> parents: 836 diff changeset	1019 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	1020 self.cache_id, self.cache_key)
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	1021
1388 2029c17cc6c6 Added basic JsonSerialization into models. Marcin Kuzminski <marcin@python-works.com> parents: 1385 diff changeset	1022 class DbMigrateVersion(Base, BaseModel):
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	1023 __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	1024 __table_args__ = {'extend_existing':True}
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	1025 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	1026 repository_path = Column('repository_path', Text)
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 832 diff changeset	1027 version = Column('version', Integer)

Mercurial > kallithea

annotate rhodecode/model/db.py @ 1546:c363267bbec7 beta