Mercurial > kallithea

annotate pylons_app/model/db.py @ 195:7109d15c6813

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
cleared prints leftoovers, and changed current user fetching in login controller
author Marcin Kuzminski <marcin@python-works.com>
date Sat, 22 May 2010 16:07:28 +0200
parents b2c38dee135a
children c6526b7531e9
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
89
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
1 import sqlalchemy
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
2 from pylons_app.model.meta import Base
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
3 from sqlalchemy import ForeignKey, Column
49
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
4 from sqlalchemy.orm import relation, backref
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
5
89
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
6 if sqlalchemy.__version__ == '0.6.0':
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
7 from sqlalchemy.dialects.sqlite import *
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
8 else:
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
9 from sqlalchemy.databases.sqlite import SLBoolean as BOOLEAN, \
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
10 SLInteger as INTEGER, SLText as TEXT, SLDateTime as DATETIME
49
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
11
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
12 class Users(Base):
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
13 __tablename__ = 'users'
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
14 __table_args__ = {'useexisting':True}
89
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
15 user_id = Column("user_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
16 username = Column("username", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
17 password = Column("password", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
18 active = Column("active", BOOLEAN(), nullable=True, unique=None, default=None)
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
19 admin = Column("admin", BOOLEAN(), nullable=True, unique=None, default=None)
61
1b6d7662d6e2 Updated database model, with FK and Booleans
Marcin Kuzminski <marcin@python-blog.com>
parents: 49
diff changeset
20 action_log = relation('UserLogs')
1b6d7662d6e2 Updated database model, with FK and Booleans
Marcin Kuzminski <marcin@python-blog.com>
parents: 49
diff changeset
21
49
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
22 class UserLogs(Base):
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
23 __tablename__ = 'user_logs'
3ada2f409c1c Added sqlalchemy support
Marcin Kuzminski <marcin@python-blog.com>
parents:
diff changeset
24 __table_args__ = {'useexisting':True}
89
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
25 id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
26 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None)
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
27 repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
28 action = Column("action", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
b2c38dee135a Model update for sqlalchemy 0.6.0
Marcin Kuzminski <marcin@python-works.com>
parents: 62
diff changeset
29 action_date = Column("action_date", DATETIME(timezone=False), nullable=True, unique=None, default=None)
61
1b6d7662d6e2 Updated database model, with FK and Booleans
Marcin Kuzminski <marcin@python-blog.com>
parents: 49
diff changeset
30 user = relation('Users')