##// END OF EJS Templates
Changed configs, server statics to false, and fixed a simply large bug with cache regions typo
Changed configs, server statics to false, and fixed a simply large bug with cache regions typo

File last commit:

r226:c6526b75 default
r231:a7b08142 default
Show More
db.py
36 lines | 2.3 KiB | text/x-python | PythonLexer
Model update for sqlalchemy 0.6.0
r89 from pylons_app.model.meta import Base
Marcin Kuzminski
Added sqlalchemy support...
r49 from sqlalchemy.orm import relation, backref
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.
r226 from sqlalchemy import *
Marcin Kuzminski
Added sqlalchemy support...
r49
class Users(Base):
__tablename__ = 'users'
__table_args__ = {'useexisting':True}
Model update for sqlalchemy 0.6.0
r89 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)
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.
r226 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('UserLogs')
Marcin Kuzminski
Updated database model, with FK and Booleans
r61
Marcin Kuzminski
Added sqlalchemy support...
r49 class UserLogs(Base):
__tablename__ = 'user_logs'
__table_args__ = {'useexisting':True}
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.
r226 user_log_id = Column("id", INTEGER(), nullable=False, unique=True, default=None, primary_key=1)
Model update for sqlalchemy 0.6.0
r89 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)
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.
r226
Marcin Kuzminski
Updated database model, with FK and Booleans
r61 user = relation('Users')
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.
r226
class Permissions(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)