##// END OF EJS Templates
fixed user email for gravatars
fixed user email for gravatars

File last commit:

r399:f5c1eec9 default
r404:a10bdd0b default
Show More
db.py
103 lines | 6.4 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 *
Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups
r265 from vcs.utils.lazy import LazyProperty
Marcin Kuzminski
Added sqlalchemy support...
r49
Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups
r341 class HgAppSettings(Base):
__tablename__ = 'hg_app_settings'
cleared global application settings....
r381 __table_args__ = (UniqueConstraint('app_settings_name'), {'useexisting':True})
Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups
r341 app_settings_id = Column("app_settings_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
cleared global application settings....
r381 app_settings_name = Column("app_settings_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
app_settings_value = Column("app_settings_value", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups
r341
class HgAppUi(Base):
__tablename__ = 'hg_app_ui'
__table_args__ = {'useexisting':True}
ui_id = Column("ui_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
ui_section = Column("ui_section", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
ui_key = Column("ui_key", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
ui_value = Column("ui_value", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
Implemented hooks system,...
r392 ui_active = Column("ui_active", BOOLEAN(), nullable=True, unique=None, default=True)
changed naming convention for db modules.
r234 class User(Base):
Marcin Kuzminski
Added sqlalchemy support...
r49 __tablename__ = 'users'
__table_args__ = {'useexisting':True}
Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups
r265 user_id = Column("user_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
Model update for sqlalchemy 0.6.0
r89 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)
db model fix, added repo instance to cached repos list
r303 admin = Column("admin", BOOLEAN(), nullable=True, unique=None, default=False)
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)
changed naming convention for db modules.
r234 user_log = relation('UserLog')
some beaker cache changes, and added repr to models
r232
Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups
r265 @LazyProperty
def full_contact(self):
return '%s %s <%s>' % (self.name, self.lastname, self.email)
some beaker cache changes, and added repr to models
r232 def __repr__(self):
return "<User('%s:%s')>" % (self.user_id, self.username)
Marcin Kuzminski
Updated database model, with FK and Booleans
r61
changed naming convention for db modules.
r234 class UserLog(Base):
Marcin Kuzminski
Added sqlalchemy support...
r49 __tablename__ = 'user_logs'
__table_args__ = {'useexisting':True}
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296 user_log_id = Column("user_log_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups
r265 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None)
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296 user_ip = Column("user_ip", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), ForeignKey(u'repositories.repo_name'), nullable=False, unique=None, default=None)
Model update for sqlalchemy 0.6.0
r89 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
changed naming convention for db modules.
r234 user = relation('User')
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296
changed naming convention for db modules.
r234 class Repository(Base):
__tablename__ = 'repositories'
fixes issue #16 reimplementation of database repository, for using generic pk instead of repo naming as pk. Which caused to many problems....
r367 __table_args__ = (UniqueConstraint('repo_name'), {'useexisting':True},)
repo_id = Column("repo_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
repo_name = Column("repo_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups
r265 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=False, default=None)
Added lastlogin to user after login, model db update
r242 private = Column("private", BOOLEAN(), nullable=True, unique=None, default=None)
Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups
r265 description = Column("description", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296
Added lastlogin to user after login, model db update
r242 user = relation('User')
rename repo2perm into repo_to_perm...
r399 repo_to_perm = relation('RepoToPerm', cascade='all')
Added lastlogin to user after login, model db update
r242
changed naming convention for db modules.
r234 class Permission(Base):
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.
r226 __tablename__ = 'permissions'
__table_args__ = {'useexisting':True}
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296 permission_id = Column("permission_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.
r226 permission_name = Column("permission_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system.
r239 permission_longname = Column("permission_longname", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
some beaker cache changes, and added repr to models
r232 def __repr__(self):
return "<Permission('%s:%s')>" % (self.permission_id, self.permission_name)
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296
rename repo2perm into repo_to_perm...
r399 class RepoToPerm(Base):
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296 __tablename__ = 'repo_to_perm'
fixes issue #16 reimplementation of database repository, for using generic pk instead of repo naming as pk. Which caused to many problems....
r367 __table_args__ = (UniqueConstraint('user_id', 'repository_id'), {'useexisting':True})
rename repo2perm into repo_to_perm...
r399 repo_to_perm_id = Column("repo_to_perm_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296 user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None)
permission_id = Column("permission_id", INTEGER(), ForeignKey(u'permissions.permission_id'), nullable=False, unique=None, default=None)
fixes issue #16 reimplementation of database repository, for using generic pk instead of repo naming as pk. Which caused to many problems....
r367 repository_id = Column("repository_id", INTEGER(), ForeignKey(u'repositories.repo_id'), nullable=False, unique=None, default=None)
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.
r296
user = relation('User')
permission = relation('Permission')
fixes issue #16 reimplementation of database repository, for using generic pk instead of repo naming as pk. Which caused to many problems....
r367 repository = relation('Repository')
rename repo2perm into repo_to_perm...
r399
class UserToPerm(Base):
__tablename__ = 'user_to_perm'
__table_args__ = {'useexisting':True}
user_to_perm_id = Column("user_to_perm_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None)
permission_id = Column("permission_id", INTEGER(), ForeignKey(u'permissions.permission_id'), nullable=False, unique=None, default=None)
user = relation('User')
permission = relation('Permission')