Mercurial > kallithea

comparison pylons_app/model/db.py @ 226:c6526b7531e9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.
author Marcin Kuzminski <marcin@python-works.com>
date Wed, 26 May 2010 23:55:20 +0200
parents b2c38dee135a
children 37a832dc4a82
comparison
equal deleted inserted replaced
225:710e7a75bb6b 226:c6526b7531e9
1 import sqlalchemy
2 from pylons_app.model.meta import Base 1 from pylons_app.model.meta import Base
3 from sqlalchemy import ForeignKey, Column
4 from sqlalchemy.orm import relation, backref 2 from sqlalchemy.orm import relation, backref
5 3 from sqlalchemy import *
6 if sqlalchemy.__version__ == '0.6.0':
7 from sqlalchemy.dialects.sqlite import *
8 else:
9 from sqlalchemy.databases.sqlite import SLBoolean as BOOLEAN, \
10 SLInteger as INTEGER, SLText as TEXT, SLDateTime as DATETIME
11 4
12 class Users(Base): 5 class Users(Base):
13 __tablename__ = 'users' 6 __tablename__ = 'users'
14 __table_args__ = {'useexisting':True} 7 __table_args__ = {'useexisting':True}
15 user_id = Column("user_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1) 8 user_id = Column("user_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
16 username = Column("username", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 9 username = Column("username", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
17 password = Column("password", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 10 password = Column("password", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
18 active = Column("active", BOOLEAN(), nullable=True, unique=None, default=None) 11 active = Column("active", BOOLEAN(), nullable=True, unique=None, default=None)
19 admin = Column("admin", BOOLEAN(), nullable=True, unique=None, default=None) 12 admin = Column("admin", BOOLEAN(), nullable=True, unique=None, default=None)
20 action_log = relation('UserLogs') 13 name = Column("name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
14 lastname = Column("lastname", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
15 email = Column("email", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
16 last_login = Column("last_login", DATETIME(timezone=False), nullable=True, unique=None, default=None)
17
18 user_log = relation('UserLogs')
21 19
22 class UserLogs(Base): 20 class UserLogs(Base):
23 __tablename__ = 'user_logs' 21 __tablename__ = 'user_logs'
24 __table_args__ = {'useexisting':True} 22 __table_args__ = {'useexisting':True}
25 id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1) 23 user_log_id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
26 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None) 24 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None)
27 repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 25 repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
28 action = Column("action", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 26 action = Column("action", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
29 action_date = Column("action_date", DATETIME(timezone=False), nullable=True, unique=None, default=None) 27 action_date = Column("action_date", DATETIME(timezone=False), nullable=True, unique=None, default=None)
28
30 user = relation('Users') 29 user = relation('Users')
30
31
32 class Permissions(Base):
33 __tablename__ = 'permissions'
34 __table_args__ = {'useexisting':True}
35 permission_id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
36 permission_name = Column("permission_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)