##// END OF EJS Templates
code garden
marcink -
r1886:50e32940 beta
parent child Browse files
Show More
@@ -147,7 +147,7 b' class BaseModel(object):'
147
147
148 class RhodeCodeSetting(Base, BaseModel):
148 class RhodeCodeSetting(Base, BaseModel):
149 __tablename__ = 'rhodecode_settings'
149 __tablename__ = 'rhodecode_settings'
150 __table_args__ = (UniqueConstraint('app_settings_name'), {'extend_existing':True})
150 __table_args__ = (UniqueConstraint('app_settings_name'), {'extend_existing': True})
151 app_settings_id = Column("app_settings_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
151 app_settings_id = Column("app_settings_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
152 app_settings_name = Column("app_settings_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
152 app_settings_name = Column("app_settings_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
153 _app_settings_value = Column("app_settings_value", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
153 _app_settings_value = Column("app_settings_value", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
@@ -217,7 +217,7 b' class RhodeCodeSetting(Base, BaseModel):'
217
217
218 class RhodeCodeUi(Base, BaseModel):
218 class RhodeCodeUi(Base, BaseModel):
219 __tablename__ = 'rhodecode_ui'
219 __tablename__ = 'rhodecode_ui'
220 __table_args__ = (UniqueConstraint('ui_key'), {'extend_existing':True})
220 __table_args__ = (UniqueConstraint('ui_key'), {'extend_existing': True})
221
221
222 HOOK_UPDATE = 'changegroup.update'
222 HOOK_UPDATE = 'changegroup.update'
223 HOOK_REPO_SIZE = 'changegroup.repo_size'
223 HOOK_REPO_SIZE = 'changegroup.repo_size'
@@ -264,7 +264,7 b' class RhodeCodeUi(Base, BaseModel):'
264
264
265 class User(Base, BaseModel):
265 class User(Base, BaseModel):
266 __tablename__ = 'users'
266 __tablename__ = 'users'
267 __table_args__ = (UniqueConstraint('username'), UniqueConstraint('email'), {'extend_existing':True})
267 __table_args__ = (UniqueConstraint('username'), UniqueConstraint('email'), {'extend_existing': True})
268 user_id = Column("user_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
268 user_id = Column("user_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
269 username = Column("username", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
269 username = Column("username", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
270 password = Column("password", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
270 password = Column("password", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
@@ -362,7 +362,7 b' class User(Base, BaseModel):'
362
362
363 class UserLog(Base, BaseModel):
363 class UserLog(Base, BaseModel):
364 __tablename__ = 'user_logs'
364 __tablename__ = 'user_logs'
365 __table_args__ = {'extend_existing':True}
365 __table_args__ = {'extend_existing': True}
366 user_log_id = Column("user_log_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
366 user_log_id = Column("user_log_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
367 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
367 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
368 repository_id = Column("repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=True)
368 repository_id = Column("repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=True)
@@ -381,7 +381,7 b' class UserLog(Base, BaseModel):'
381
381
382 class UsersGroup(Base, BaseModel):
382 class UsersGroup(Base, BaseModel):
383 __tablename__ = 'users_groups'
383 __tablename__ = 'users_groups'
384 __table_args__ = {'extend_existing':True}
384 __table_args__ = {'extend_existing': True}
385
385
386 users_group_id = Column("users_group_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
386 users_group_id = Column("users_group_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
387 users_group_name = Column("users_group_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
387 users_group_name = Column("users_group_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
@@ -415,7 +415,7 b' class UsersGroup(Base, BaseModel):'
415
415
416 class UsersGroupMember(Base, BaseModel):
416 class UsersGroupMember(Base, BaseModel):
417 __tablename__ = 'users_groups_members'
417 __tablename__ = 'users_groups_members'
418 __table_args__ = {'extend_existing':True}
418 __table_args__ = {'extend_existing': True}
419
419
420 users_group_member_id = Column("users_group_member_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
420 users_group_member_id = Column("users_group_member_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
421 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
421 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
@@ -440,7 +440,7 b' class UsersGroupMember(Base, BaseModel):'
440
440
441 class Repository(Base, BaseModel):
441 class Repository(Base, BaseModel):
442 __tablename__ = 'repositories'
442 __tablename__ = 'repositories'
443 __table_args__ = (UniqueConstraint('repo_name'), {'extend_existing':True},)
443 __table_args__ = (UniqueConstraint('repo_name'), {'extend_existing': True},)
444
444
445 repo_id = Column("repo_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
445 repo_id = Column("repo_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
446 repo_name = Column("repo_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
446 repo_name = Column("repo_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)
@@ -686,7 +686,7 b' class Repository(Base, BaseModel):'
686 class RepoGroup(Base, BaseModel):
686 class RepoGroup(Base, BaseModel):
687 __tablename__ = 'groups'
687 __tablename__ = 'groups'
688 __table_args__ = (UniqueConstraint('group_name', 'group_parent_id'),
688 __table_args__ = (UniqueConstraint('group_name', 'group_parent_id'),
689 CheckConstraint('group_id != group_parent_id'), {'extend_existing':True},)
689 CheckConstraint('group_id != group_parent_id'), {'extend_existing': True},)
690 __mapper_args__ = {'order_by':'group_name'}
690 __mapper_args__ = {'order_by':'group_name'}
691
691
692 group_id = Column("group_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
692 group_id = Column("group_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
@@ -805,7 +805,7 b' class RepoGroup(Base, BaseModel):'
805
805
806 class Permission(Base, BaseModel):
806 class Permission(Base, BaseModel):
807 __tablename__ = 'permissions'
807 __tablename__ = 'permissions'
808 __table_args__ = {'extend_existing':True}
808 __table_args__ = {'extend_existing': True}
809 permission_id = Column("permission_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
809 permission_id = Column("permission_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
810 permission_name = Column("permission_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
810 permission_name = Column("permission_name", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
811 permission_longname = Column("permission_longname", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
811 permission_longname = Column("permission_longname", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
@@ -830,7 +830,7 b' class Permission(Base, BaseModel):'
830
830
831 class UserRepoToPerm(Base, BaseModel):
831 class UserRepoToPerm(Base, BaseModel):
832 __tablename__ = 'repo_to_perm'
832 __tablename__ = 'repo_to_perm'
833 __table_args__ = (UniqueConstraint('user_id', 'repository_id'), {'extend_existing':True})
833 __table_args__ = (UniqueConstraint('user_id', 'repository_id'), {'extend_existing': True})
834 repo_to_perm_id = Column("repo_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
834 repo_to_perm_id = Column("repo_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
835 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
835 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
836 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
836 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
@@ -855,7 +855,7 b' class UserRepoToPerm(Base, BaseModel):'
855
855
856 class UserToPerm(Base, BaseModel):
856 class UserToPerm(Base, BaseModel):
857 __tablename__ = 'user_to_perm'
857 __tablename__ = 'user_to_perm'
858 __table_args__ = (UniqueConstraint('user_id', 'permission_id'), {'extend_existing':True})
858 __table_args__ = (UniqueConstraint('user_id', 'permission_id'), {'extend_existing': True})
859 user_to_perm_id = Column("user_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
859 user_to_perm_id = Column("user_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
860 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
860 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
861 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
861 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
@@ -866,7 +866,7 b' class UserToPerm(Base, BaseModel):'
866
866
867 class UsersGroupRepoToPerm(Base, BaseModel):
867 class UsersGroupRepoToPerm(Base, BaseModel):
868 __tablename__ = 'users_group_repo_to_perm'
868 __tablename__ = 'users_group_repo_to_perm'
869 __table_args__ = (UniqueConstraint('repository_id', 'users_group_id', 'permission_id'), {'extend_existing':True})
869 __table_args__ = (UniqueConstraint('repository_id', 'users_group_id', 'permission_id'), {'extend_existing': True})
870 users_group_to_perm_id = Column("users_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
870 users_group_to_perm_id = Column("users_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
871 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
871 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
872 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
872 permission_id = Column("permission_id", Integer(), ForeignKey('permissions.permission_id'), nullable=False, unique=None, default=None)
@@ -901,7 +901,7 b' class UsersGroupToPerm(Base, BaseModel):'
901
901
902 class UserRepoGroupToPerm(Base, BaseModel):
902 class UserRepoGroupToPerm(Base, BaseModel):
903 __tablename__ = 'group_to_perm'
903 __tablename__ = 'group_to_perm'
904 __table_args__ = (UniqueConstraint('group_id', 'permission_id'), {'extend_existing':True})
904 __table_args__ = (UniqueConstraint('group_id', 'permission_id'), {'extend_existing': True})
905
905
906 group_to_perm_id = Column("group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
906 group_to_perm_id = Column("group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
907 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
907 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
@@ -915,7 +915,7 b' class UserRepoGroupToPerm(Base, BaseMode'
915
915
916 class UsersGroupRepoGroupToPerm(Base, BaseModel):
916 class UsersGroupRepoGroupToPerm(Base, BaseModel):
917 __tablename__ = 'users_group_repo_group_to_perm'
917 __tablename__ = 'users_group_repo_group_to_perm'
918 __table_args__ = (UniqueConstraint('group_id', 'permission_id'), {'extend_existing':True})
918 __table_args__ = (UniqueConstraint('group_id', 'permission_id'), {'extend_existing': True})
919
919
920 users_group_repo_group_to_perm_id = Column("users_group_repo_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
920 users_group_repo_group_to_perm_id = Column("users_group_repo_group_to_perm_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
921 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
921 users_group_id = Column("users_group_id", Integer(), ForeignKey('users_groups.users_group_id'), nullable=False, unique=None, default=None)
@@ -929,7 +929,7 b' class UsersGroupRepoGroupToPerm(Base, Ba'
929
929
930 class Statistics(Base, BaseModel):
930 class Statistics(Base, BaseModel):
931 __tablename__ = 'statistics'
931 __tablename__ = 'statistics'
932 __table_args__ = (UniqueConstraint('repository_id'), {'extend_existing':True})
932 __table_args__ = (UniqueConstraint('repository_id'), {'extend_existing': True})
933 stat_id = Column("stat_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
933 stat_id = Column("stat_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
934 repository_id = Column("repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=False, unique=True, default=None)
934 repository_id = Column("repository_id", Integer(), ForeignKey('repositories.repo_id'), nullable=False, unique=True, default=None)
935 stat_on_revision = Column("stat_on_revision", Integer(), nullable=False)
935 stat_on_revision = Column("stat_on_revision", Integer(), nullable=False)
@@ -944,7 +944,7 b' class UserFollowing(Base, BaseModel):'
944 __tablename__ = 'user_followings'
944 __tablename__ = 'user_followings'
945 __table_args__ = (UniqueConstraint('user_id', 'follows_repository_id'),
945 __table_args__ = (UniqueConstraint('user_id', 'follows_repository_id'),
946 UniqueConstraint('user_id', 'follows_user_id')
946 UniqueConstraint('user_id', 'follows_user_id')
947 , {'extend_existing':True})
947 , {'extend_existing': True})
948
948
949 user_following_id = Column("user_following_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
949 user_following_id = Column("user_following_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
950 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
950 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None)
@@ -965,7 +965,7 b' class UserFollowing(Base, BaseModel):'
965
965
966 class CacheInvalidation(Base, BaseModel):
966 class CacheInvalidation(Base, BaseModel):
967 __tablename__ = 'cache_invalidation'
967 __tablename__ = 'cache_invalidation'
968 __table_args__ = (UniqueConstraint('cache_key'), {'extend_existing':True})
968 __table_args__ = (UniqueConstraint('cache_key'), {'extend_existing': True})
969 cache_id = Column("cache_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
969 cache_id = Column("cache_id", Integer(), nullable=False, unique=True, default=None, primary_key=True)
970 cache_key = Column("cache_key", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
970 cache_key = Column("cache_key", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
971 cache_args = Column("cache_args", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
971 cache_args = Column("cache_args", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
@@ -1035,7 +1035,7 b' class CacheInvalidation(Base, BaseModel)'
1035
1035
1036 class ChangesetComment(Base, BaseModel):
1036 class ChangesetComment(Base, BaseModel):
1037 __tablename__ = 'changeset_comments'
1037 __tablename__ = 'changeset_comments'
1038 __table_args__ = ({'extend_existing':True},)
1038 __table_args__ = ({'extend_existing': True},)
1039 comment_id = Column('comment_id', Integer(), nullable=False, primary_key=True)
1039 comment_id = Column('comment_id', Integer(), nullable=False, primary_key=True)
1040 repo_id = Column('repo_id', Integer(), ForeignKey('repositories.repo_id'), nullable=False)
1040 repo_id = Column('repo_id', Integer(), ForeignKey('repositories.repo_id'), nullable=False)
1041 revision = Column('revision', String(40), nullable=False)
1041 revision = Column('revision', String(40), nullable=False)
@@ -1048,7 +1048,6 b' class ChangesetComment(Base, BaseModel):'
1048 author = relationship('User', lazy='joined')
1048 author = relationship('User', lazy='joined')
1049 repo = relationship('Repository')
1049 repo = relationship('Repository')
1050
1050
1051
1052 @classmethod
1051 @classmethod
1053 def get_users(cls, revision):
1052 def get_users(cls, revision):
1054 """
1053 """
@@ -1061,11 +1060,11 b' class ChangesetComment(Base, BaseModel):'
1061 return Session.query(User)\
1060 return Session.query(User)\
1062 .filter(cls.revision == revision)\
1061 .filter(cls.revision == revision)\
1063 .join(ChangesetComment.author).all()
1062 .join(ChangesetComment.author).all()
1064
1063
1065
1064
1066 class Notification(Base, BaseModel):
1065 class Notification(Base, BaseModel):
1067 __tablename__ = 'notifications'
1066 __tablename__ = 'notifications'
1068 __table_args__ = ({'extend_existing':True})
1067 __table_args__ = ({'extend_existing': True},)
1069
1068
1070 TYPE_CHANGESET_COMMENT = u'cs_comment'
1069 TYPE_CHANGESET_COMMENT = u'cs_comment'
1071 TYPE_MESSAGE = u'message'
1070 TYPE_MESSAGE = u'message'
@@ -1116,7 +1115,7 b' class Notification(Base, BaseModel):'
1116 class UserNotification(Base, BaseModel):
1115 class UserNotification(Base, BaseModel):
1117 __tablename__ = 'user_to_notification'
1116 __tablename__ = 'user_to_notification'
1118 __table_args__ = (UniqueConstraint('user_id', 'notification_id'),
1117 __table_args__ = (UniqueConstraint('user_id', 'notification_id'),
1119 {'extend_existing':True})
1118 {'extend_existing': True})
1120 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), primary_key=True)
1119 user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), primary_key=True)
1121 notification_id = Column("notification_id", Integer(), ForeignKey('notifications.notification_id'), primary_key=True)
1120 notification_id = Column("notification_id", Integer(), ForeignKey('notifications.notification_id'), primary_key=True)
1122 read = Column('read', Boolean, default=False)
1121 read = Column('read', Boolean, default=False)
@@ -1133,7 +1132,7 b' class UserNotification(Base, BaseModel):'
1133
1132
1134 class DbMigrateVersion(Base, BaseModel):
1133 class DbMigrateVersion(Base, BaseModel):
1135 __tablename__ = 'db_migrate_version'
1134 __tablename__ = 'db_migrate_version'
1136 __table_args__ = {'extend_existing':True}
1135 __table_args__ = {'extend_existing': True}
1137 repository_id = Column('repository_id', String(250), primary_key=True)
1136 repository_id = Column('repository_id', String(250), primary_key=True)
1138 repository_path = Column('repository_path', Text)
1137 repository_path = Column('repository_path', Text)
1139 version = Column('version', Integer)
1138 version = Column('version', Integer)
General Comments 0
You need to be logged in to leave comments. Login now