Mercurial > kallithea

comparison rhodecode/model/db.py @ 959:fff21c9b075c beta

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
#56 fixed found bugs, implemented adding of new group + forms+validators fixed db schema naming
author Marcin Kuzminski <marcin@python-works.com>
date Wed, 26 Jan 2011 17:34:37 +0100
parents 7d1483f3170b
children 72f008ed9b18
comparison
equal deleted inserted replaced
958:7d1483f3170b 959:fff21c9b075c
156 156
157 class UsersGroup(Base, BaseModel): 157 class UsersGroup(Base, BaseModel):
158 __tablename__ = 'users_groups' 158 __tablename__ = 'users_groups'
159 __table_args__ = {'useexisting':True} 159 __table_args__ = {'useexisting':True}
160 160
161 user_group_id = Column("users_groups_id", Integer(), nullable=False, unique=True, default=None, primary_key=True) 161 users_group_id = Column("users_group_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
162 user_group_name = Column("user_group_name", String(length=None, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None) 162 users_group_name = Column("users_group_name", String(length=None, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
163 163 users_group_active = Column("users_group_active", Boolean(), nullable=True, unique=None, default=None)
164 164
165 members = relation('UsersGroupMember') 165 members = relation('UsersGroupMember')
166
167 166
168 class UsersGroupMember(Base, BaseModel): 167 class UsersGroupMember(Base, BaseModel):
169 __tablename__ = 'users_groups_members' 168 __tablename__ = 'users_groups_members'
170 __table_args__ = {'useexisting':True} 169 __table_args__ = {'useexisting':True}
171 170
172 user_groups_members_id = Column("user_groups_members_id", Integer(), nullable=False, unique=True, default=None, primary_key=True) 171 users_group_member_id = Column("users_group_member_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
173 user_group_id = Column("user_group_id", Integer(), ForeignKey('users_groups.users_groups_id'), nullable=False, unique=None, default=None) 172 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
174 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None) 173 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
175 174
176 user = relation('User') 175 user = relation('User')
177 users_group = relation('UsersGroup') 176 users_group = relation('UsersGroup')
178 177
255 254
256 class UsersGroupToPerm(Base, BaseModel): 255 class UsersGroupToPerm(Base, BaseModel):
257 __tablename__ = 'users_group_to_perm' 256 __tablename__ = 'users_group_to_perm'
258 __table_args__ = (UniqueConstraint('users_group_id', 'permission_id'), {'useexisting':True}) 257 __table_args__ = (UniqueConstraint('users_group_id', 'permission_id'), {'useexisting':True})
259 users_group_to_perm_id = Column("users_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True) 258 users_group_to_perm_id = Column("users_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
260 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_groups_id'), nullable=False, unique=None, default=None) 259 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
261 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None) 260 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
262 261
263 users_group = relation('UsersGroup') 262 users_group = relation('UsersGroup')
264 permission = relation('Permission') 263 permission = relation('Permission')
265 264