upstream/kallithea Files · pylons_app/model/db.py

Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups

marcink - - Load All Authors

File last commit:

r341:1ef52a70 default


                r341:1ef52a70

default

Download file

             db.py
        
                    86 lines
            
             | 5.6 KiB
            
                | text/x-python
            
             |
                PythonLexer
            
             / pylons_app / model / db.py
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        marcink
    
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

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
      from sqlalchemy import *

        marcink
    
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
            
        marcink
    
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'

          __table_args__ = {'useexisting':True}

          app_settings_id = Column("app_settings_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

          app_title = Column("app_title", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

          app_auth_realm = Column("auth_realm", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

      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)

        marcink
    
changed naming convention for db modules.

              r234
            
      class User(Base): 

        Marcin Kuzminski
    
Added sqlalchemy support...

              r49
            
          __tablename__ = 'users'

          __table_args__ = {'useexisting':True}

        marcink
    
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)

        marcink
    
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)

        marcink
    
db model fix, added repo instance to cached repos list

              r303
            
          admin = Column("admin", BOOLEAN(), nullable=True, unique=None, default=False)

        marcink
    
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)

        marcink
    
changed naming convention for db modules.

              r234
            
          user_log = relation('UserLog')

        marcink
    
some beaker cache changes, and added repr to models

              r232
            
        marcink
    
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)

        marcink
    
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
            
        marcink
    
changed naming convention for db modules.

              r234
            
      class UserLog(Base): 

        Marcin Kuzminski
    
Added sqlalchemy support...

              r49
            
          __tablename__ = 'user_logs'

          __table_args__ = {'useexisting':True}

        marcink
    
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)

        marcink
    
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)

        marcink
    
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)

        marcink
    
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)

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
        marcink
    
changed naming convention for db modules.

              r234
            
          user = relation('User')

        marcink
    
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.

              r296
            
        marcink
    
changed naming convention for db modules.

              r234
            
      class Repository(Base):

          __tablename__ = 'repositories'

        marcink
    
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.

              r296
            
          __table_args__ = {'useexisting':True}

        marcink
    
Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups

              r265
            
          repo_name = Column("repo_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None, primary_key=True)

          user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=False, default=None)

        marcink
    
Added lastlogin to user after login, model db update

              r242
            
          private = Column("private", BOOLEAN(), nullable=True, unique=None, default=None)

        marcink
    
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)

        marcink
    
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.

              r296
            
        marcink
    
Added lastlogin to user after login, model db update

              r242
            
          user = relation('User')

        marcink
    
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.

              r296
            
          repo2perm = relation('Repo2Perm', cascade='all')

        marcink
    
Added lastlogin to user after login, model db update

              r242
            
        marcink
    
changed naming convention for db modules.

              r234
            
      class Permission(Base):

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
          __tablename__ = 'permissions'

          __table_args__ = {'useexisting':True}

        marcink
    
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)

        marcink
    
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)

        marcink
    
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)

        marcink
    
some beaker cache changes, and added repr to models

              r232
            
          def __repr__(self):

              return "<Permission('%s:%s')>" % (self.permission_id, self.permission_name)

        marcink
    
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.

              r296
            
      class Repo2Perm(Base):

          __tablename__ = 'repo_to_perm'

        marcink
    
Repository managment permissions, fixed found bugs updated js, added extra checks for doubled users and non active ones

              r328
            
          __table_args__ = (UniqueConstraint('user_id', 'repository'), {'useexisting':True})

        marcink
    
first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.

              r296
            
          repo2perm_id = Column("repo2perm_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)

          repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), ForeignKey(u'repositories.repo_name'), nullable=False, unique=None, default=None) 

          user = relation('User')

          permission = relation('Permission')

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

marcink 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
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	from sqlalchemy import *
marcink 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
marcink 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'
		__table_args__ = {'useexisting':True}
		app_settings_id = Column("app_settings_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)
		app_title = Column("app_title", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
		app_auth_realm = Column("auth_realm", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

		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)

marcink changed naming convention for db modules.	r234	class User(Base):
Marcin Kuzminski Added sqlalchemy support...	r49	__tablename__ = 'users'
		__table_args__ = {'useexisting':True}
marcink 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)
marcink 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)
marcink db model fix, added repo instance to cached repos list	r303	admin = Column("admin", BOOLEAN(), nullable=True, unique=None, default=False)
marcink 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)

marcink changed naming convention for db modules.	r234	user_log = relation('UserLog')
marcink some beaker cache changes, and added repr to models	r232
marcink 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)

marcink 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
marcink changed naming convention for db modules.	r234	class UserLog(Base):
Marcin Kuzminski Added sqlalchemy support...	r49	__tablename__ = 'user_logs'
		__table_args__ = {'useexisting':True}
marcink 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)
marcink 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)
marcink 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)
marcink 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)
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226
marcink changed naming convention for db modules.	r234	user = relation('User')
marcink first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.	r296
marcink changed naming convention for db modules.	r234	class Repository(Base):
		__tablename__ = 'repositories'
marcink first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.	r296	__table_args__ = {'useexisting':True}
marcink Implemented basic repository managment. Implemented repo2db mappings, model, helpers updates and code cleanups	r265	repo_name = Column("repo_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None, primary_key=True)
		user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=False, default=None)
marcink Added lastlogin to user after login, model db update	r242	private = Column("private", BOOLEAN(), nullable=True, unique=None, default=None)
marcink 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)
marcink first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.	r296
marcink Added lastlogin to user after login, model db update	r242	user = relation('User')
marcink first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.	r296	repo2perm = relation('Repo2Perm', cascade='all')
marcink Added lastlogin to user after login, model db update	r242
marcink changed naming convention for db modules.	r234	class Permission(Base):
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	__tablename__ = 'permissions'
		__table_args__ = {'useexisting':True}
marcink 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)
marcink 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)
marcink 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)

marcink some beaker cache changes, and added repr to models	r232	def __repr__(self):
		return "<Permission('%s:%s')>" % (self.permission_id, self.permission_name)
marcink first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.	r296
		class Repo2Perm(Base):
		__tablename__ = 'repo_to_perm'
marcink Repository managment permissions, fixed found bugs updated js, added extra checks for doubled users and non active ones	r328	__table_args__ = (UniqueConstraint('user_id', 'repository'), {'useexisting':True})
marcink first permissions commit: added permission managment on repository edit. Changed db rmissions, validators.	r296	repo2perm_id = Column("repo2perm_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)
		repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), ForeignKey(u'repositories.repo_name'), nullable=False, unique=None, default=None)

		user = relation('User')
		permission = relation('Permission')