comparison rhodecode/model/db.py @ 1435:a62af7d509ee beta

fixes #228 - added detection of assigned groups to prevent errors on sqlite
author Marcin Kuzminski <marcin@python-works.com>
date Tue, 19 Jul 2011 17:10:34 +0200
parents e5467730682b
children 88d13c1c6a55
comparison
equal deleted inserted replaced
1434:d21c14e36fa8 1435:a62af7d509ee
284 users_group_name = Column("users_group_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None) 284 users_group_name = Column("users_group_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
285 users_group_active = Column("users_group_active", Boolean(), nullable=True, unique=None, default=None) 285 users_group_active = Column("users_group_active", Boolean(), nullable=True, unique=None, default=None)
286 286
287 members = relationship('UsersGroupMember', cascade="all, delete, delete-orphan", lazy="joined") 287 members = relationship('UsersGroupMember', cascade="all, delete, delete-orphan", lazy="joined")
288 288
289 def __repr__(self):
290 return '<userGroup(%s)>' % (self.users_group_name)
289 291
290 @classmethod 292 @classmethod
291 def get_by_group_name(cls, group_name, cache=False, case_insensitive=False): 293 def get_by_group_name(cls, group_name, cache=False, case_insensitive=False):
292 if case_insensitive: 294 if case_insensitive:
293 gr = Session.query(cls)\ 295 gr = Session.query(cls)\
675 677
676 users_group = relationship('UsersGroup') 678 users_group = relationship('UsersGroup')
677 permission = relationship('Permission') 679 permission = relationship('Permission')
678 repository = relationship('Repository') 680 repository = relationship('Repository')
679 681
682 def __repr__(self):
683 return '<userGroup:%s => %s >' % (self.users_group, self.repository)
680 684
681 class UsersGroupToPerm(Base, BaseModel): 685 class UsersGroupToPerm(Base, BaseModel):
682 __tablename__ = 'users_group_to_perm' 686 __tablename__ = 'users_group_to_perm'
683 users_group_to_perm_id = Column("users_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True) 687 users_group_to_perm_id = Column("users_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
684 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None) 688 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)