Mercurial > kallithea

comparison pylons_app/model/db.py @ 234:a0116e944da1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
changed naming convention for db modules.
author Marcin Kuzminski <marcin@python-works.com>
date Thu, 27 May 2010 21:31:30 +0200
parents 37a832dc4a82
children b18f89d6d17f
comparison
equal deleted inserted replaced
233:08e0347351d0 234:a0116e944da1
1 from pylons_app.model.meta import Base 1 from pylons_app.model.meta import Base
2 from sqlalchemy.orm import relation, backref 2 from sqlalchemy.orm import relation, backref
3 from sqlalchemy import * 3 from sqlalchemy import *
4 4
5 class Users(Base): 5 class User(Base):
6 __tablename__ = 'users' 6 __tablename__ = 'users'
7 __table_args__ = {'useexisting':True} 7 __table_args__ = {'useexisting':True}
8 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)
9 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)
10 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)
13 name = Column("name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 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) 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) 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) 16 last_login = Column("last_login", DATETIME(timezone=False), nullable=True, unique=None, default=None)
17 17
18 user_log = relation('UserLogs') 18 user_log = relation('UserLog')
19 19
20 def __repr__(self): 20 def __repr__(self):
21 return "<User('%s:%s')>" % (self.user_id, self.username) 21 return "<User('%s:%s')>" % (self.user_id, self.username)
22 22
23 class UserLogs(Base): 23 class UserLog(Base):
24 __tablename__ = 'user_logs' 24 __tablename__ = 'user_logs'
25 __table_args__ = {'useexisting':True} 25 __table_args__ = {'useexisting':True}
26 user_log_id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1) 26 user_log_id = Column("user_log_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
27 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None) 27 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None)
28 repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 28 repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
29 action = Column("action", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 29 action = Column("action", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
30 action_date = Column("action_date", DATETIME(timezone=False), nullable=True, unique=None, default=None) 30 action_date = Column("action_date", DATETIME(timezone=False), nullable=True, unique=None, default=None)
31 31
32 user = relation('Users') 32 user = relation('User')
33 33
34 class Repository(Base):
35 __tablename__ = 'repositories'
36 repo_id = Column("repo_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
34 37
35 class Permissions(Base): 38 class Permission(Base):
36 __tablename__ = 'permissions' 39 __tablename__ = 'permissions'
37 __table_args__ = {'useexisting':True} 40 __table_args__ = {'useexisting':True}
38 permission_id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1) 41 permission_id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
39 permission_name = Column("permission_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 42 permission_name = Column("permission_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
40 43