Files
@ b18f89d6d17f
Branch filter:
Location: kallithea/pylons_app/model/db.py - annotation
b18f89d6d17f
2.9 KiB
text/x-python
Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system.
b2c38dee135a 3ada2f409c1c c6526b7531e9 3ada2f409c1c a0116e944da1 3ada2f409c1c 3ada2f409c1c b2c38dee135a b2c38dee135a b2c38dee135a b2c38dee135a b2c38dee135a c6526b7531e9 c6526b7531e9 c6526b7531e9 c6526b7531e9 c6526b7531e9 a0116e944da1 37a832dc4a82 37a832dc4a82 37a832dc4a82 1b6d7662d6e2 a0116e944da1 3ada2f409c1c 3ada2f409c1c a0116e944da1 b2c38dee135a b2c38dee135a b2c38dee135a b2c38dee135a c6526b7531e9 a0116e944da1 c6526b7531e9 a0116e944da1 a0116e944da1 a0116e944da1 c6526b7531e9 a0116e944da1 c6526b7531e9 c6526b7531e9 c6526b7531e9 c6526b7531e9 b18f89d6d17f b18f89d6d17f 37a832dc4a82 37a832dc4a82 | from pylons_app.model.meta import Base
from sqlalchemy.orm import relation, backref
from sqlalchemy import *
class User(Base):
__tablename__ = 'users'
__table_args__ = {'useexisting':True}
user_id = Column("user_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
username = Column("username", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
password = Column("password", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
active = Column("active", BOOLEAN(), nullable=True, unique=None, default=None)
admin = Column("admin", BOOLEAN(), nullable=True, unique=None, default=None)
name = Column("name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
lastname = Column("lastname", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
email = Column("email", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
last_login = Column("last_login", DATETIME(timezone=False), nullable=True, unique=None, default=None)
user_log = relation('UserLog')
def __repr__(self):
return "<User('%s:%s')>" % (self.user_id, self.username)
class UserLog(Base):
__tablename__ = 'user_logs'
__table_args__ = {'useexisting':True}
user_log_id = Column("user_log_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None)
repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
action = Column("action", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
action_date = Column("action_date", DATETIME(timezone=False), nullable=True, unique=None, default=None)
user = relation('User')
class Repository(Base):
__tablename__ = 'repositories'
repo_id = Column("repo_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
class Permission(Base):
__tablename__ = 'permissions'
__table_args__ = {'useexisting':True}
permission_id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
permission_name = Column("permission_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
permission_longname = Column("permission_longname", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
def __repr__(self):
return "<Permission('%s:%s')>" % (self.permission_id, self.permission_name)
|