comparison pylons_app/model/db.py @ 414:27f801e03489

fixed escaping for new webhelpers and added perm2user constraint
author Marcin Kuzminski <marcin@python-works.com>
date Thu, 19 Aug 2010 23:42:40 +0200
parents f5c1eec9f376
children 3ed2d46a2ca7
comparison
equal deleted inserted replaced
413:0ebec9b88d13 414:27f801e03489
88 permission = relation('Permission') 88 permission = relation('Permission')
89 repository = relation('Repository') 89 repository = relation('Repository')
90 90
91 class UserToPerm(Base): 91 class UserToPerm(Base):
92 __tablename__ = 'user_to_perm' 92 __tablename__ = 'user_to_perm'
93 __table_args__ = {'useexisting':True} 93 __table_args__ = (UniqueConstraint('user_id', 'permission_id'), {'useexisting':True})
94 user_to_perm_id = Column("user_to_perm_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=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) 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) 96 permission_id = Column("permission_id", INTEGER(), ForeignKey(u'permissions.permission_id'), nullable=False, unique=None, default=None)
97 97
98 user = relation('User') 98 user = relation('User')