Mercurial > kallithea

comparison pylons_app/model/db.py @ 399:f5c1eec9f376

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
rename repo2perm into repo_to_perm added UserToPerm models for user global permissions
author Marcin Kuzminski <marcin@python-works.com>
date Sun, 08 Aug 2010 01:27:14 +0200
parents b27d32cb3157
children 27f801e03489
comparison
equal deleted inserted replaced
398:8c50b164fb58 399:f5c1eec9f376
62 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=False, default=None) 62 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=False, default=None)
63 private = Column("private", BOOLEAN(), nullable=True, unique=None, default=None) 63 private = Column("private", BOOLEAN(), nullable=True, unique=None, default=None)
64 description = Column("description", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 64 description = Column("description", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
65 65
66 user = relation('User') 66 user = relation('User')
67 repo2perm = relation('Repo2Perm', cascade='all') 67 repo_to_perm = relation('RepoToPerm', cascade='all')
68 68
69 class Permission(Base): 69 class Permission(Base):
70 __tablename__ = 'permissions' 70 __tablename__ = 'permissions'
71 __table_args__ = {'useexisting':True} 71 __table_args__ = {'useexisting':True}
72 permission_id = Column("permission_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True) 72 permission_id = Column("permission_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
74 permission_longname = Column("permission_longname", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 74 permission_longname = Column("permission_longname", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
75 75
76 def __repr__(self): 76 def __repr__(self):
77 return "<Permission('%s:%s')>" % (self.permission_id, self.permission_name) 77 return "<Permission('%s:%s')>" % (self.permission_id, self.permission_name)
78 78
79 class Repo2Perm(Base): 79 class RepoToPerm(Base):
80 __tablename__ = 'repo_to_perm' 80 __tablename__ = 'repo_to_perm'
81 __table_args__ = (UniqueConstraint('user_id', 'repository_id'), {'useexisting':True}) 81 __table_args__ = (UniqueConstraint('user_id', 'repository_id'), {'useexisting':True})
82 repo2perm_id = Column("repo2perm_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True) 82 repo_to_perm_id = Column("repo_to_perm_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
83 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None) 83 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None)
84 permission_id = Column("permission_id", INTEGER(), ForeignKey(u'permissions.permission_id'), nullable=False, unique=None, default=None) 84 permission_id = Column("permission_id", INTEGER(), ForeignKey(u'permissions.permission_id'), nullable=False, unique=None, default=None)
85 repository_id = Column("repository_id", INTEGER(), ForeignKey(u'repositories.repo_id'), nullable=False, unique=None, default=None) 85 repository_id = Column("repository_id", INTEGER(), ForeignKey(u'repositories.repo_id'), nullable=False, unique=None, default=None)
86 86
87 user = relation('User') 87 user = relation('User')
88 permission = relation('Permission') 88 permission = relation('Permission')
89 repository = relation('Repository') 89 repository = relation('Repository')
90
91 class UserToPerm(Base):
92 __tablename__ = 'user_to_perm'
93 __table_args__ = {'useexisting':True}
94 user_to_perm_id = Column("user_to_perm_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
95 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None)
96 permission_id = Column("permission_id", INTEGER(), ForeignKey(u'permissions.permission_id'), nullable=False, unique=None, default=None)
97
98 user = relation('User')
99 permission = relation('Permission')
100
101
102
103