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

Started summary page. Added filters to templates. used by n,self.f.filtername prefixed by n to disable other filters. Few other fixes found

Marcin Kuzminski - - Load All Authors

File last commit:

r62:4df4c0ea default


                r74:cdf4fda6

default

Download file

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

        Marcin Kuzminski
    
Added sqlalchemy support...

              r49
            
      from sqlalchemy.ext.declarative import declarative_base

      from sqlalchemy.orm import relation, backref

      from sqlalchemy import ForeignKey, Column, Table, Sequence

      from sqlalchemy.types import *

      from sqlalchemy.databases.sqlite import *

      from pylons_app.model.meta import Base

      class Users(Base): 

          __tablename__ = 'users'

          __table_args__ = {'useexisting':True}

          user_id = Column("user_id", SLInteger(), nullable=False, unique=True, default=None, primary_key=1)

          username = Column("username", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

          password = Column("password", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

        Marcin Kuzminski
    
Updated database model, with FK and Booleans

              r61
            
          active = Column("active", SLBoolean(), nullable=True, unique=None, default=None)

          admin = Column("admin", SLBoolean(), nullable=True, unique=None, default=None)

          action_log = relation('UserLogs')

        Marcin Kuzminski
    
Added sqlalchemy support...

              r49
            
      class UserLogs(Base): 

          __tablename__ = 'user_logs'

          __table_args__ = {'useexisting':True}

          id = Column("id", SLInteger(), nullable=False, unique=True, default=None, primary_key=1)

        Marcin Kuzminski
    
Updated database model, with FK and Booleans

              r61
            
          user_id = Column("user_id", SLInteger(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None)

        Marcin Kuzminski
    
Updated admin to show last 5 actions + updated db model

              r62
            
          repository = Column("repository", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

          action = Column("action", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

          action_date = Column("action_date", SLDateTime(timezone=False), nullable=True, unique=None, default=None)

        Marcin Kuzminski
    
Updated database model, with FK and Booleans

              r61
            
          user = relation('Users')

	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

Marcin Kuzminski Added sqlalchemy support...	r49	from sqlalchemy.ext.declarative import declarative_base
		from sqlalchemy.orm import relation, backref
		from sqlalchemy import ForeignKey, Column, Table, Sequence
		from sqlalchemy.types import *
		from sqlalchemy.databases.sqlite import *
		from pylons_app.model.meta import Base


		class Users(Base):
		__tablename__ = 'users'
		__table_args__ = {'useexisting':True}
		user_id = Column("user_id", SLInteger(), nullable=False, unique=True, default=None, primary_key=1)
		username = Column("username", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
		password = Column("password", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
Marcin Kuzminski Updated database model, with FK and Booleans	r61	active = Column("active", SLBoolean(), nullable=True, unique=None, default=None)
		admin = Column("admin", SLBoolean(), nullable=True, unique=None, default=None)
		action_log = relation('UserLogs')

Marcin Kuzminski Added sqlalchemy support...	r49	class UserLogs(Base):
		__tablename__ = 'user_logs'
		__table_args__ = {'useexisting':True}
		id = Column("id", SLInteger(), nullable=False, unique=True, default=None, primary_key=1)
Marcin Kuzminski Updated database model, with FK and Booleans	r61	user_id = Column("user_id", SLInteger(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None)
Marcin Kuzminski Updated admin to show last 5 actions + updated db model	r62	repository = Column("repository", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
		action = Column("action", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
		action_date = Column("action_date", SLDateTime(timezone=False), nullable=True, unique=None, default=None)
Marcin Kuzminski Updated database model, with FK and Booleans	r61	user = relation('Users')