upstream/kallithea Files · rhodecode/lib/dbmigrate/versions/003_version_1_2_0.py

added dummy revision 6 for db upgrade

marcink - - Load All Authors

File last commit:

r2257:a437a986 default


                r2549:411cd8fb

beta

Download file

             003_version_1_2_0.py
        
                    118 lines
            
             | 4.8 KiB
            
                | text/x-python
            
             |
                PythonLexer
            
             / rhodecode / lib / dbmigrate / versions / 003_version_1_2_0.py
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        marcink
    
updated migration for version 1.2

              r900
            
      import logging

      import datetime

      from sqlalchemy import *

      from sqlalchemy.exc import DatabaseError

      from sqlalchemy.orm import relation, backref, class_mapper

      from sqlalchemy.orm.session import Session

        marcink
    
Fixed dbmigrate issues.

              r907
            
      from rhodecode.lib.dbmigrate.migrate import *

      from rhodecode.lib.dbmigrate.migrate.changeset import *

        marcink
    
updated migration for version 1.2

              r900
            
      from rhodecode.model.meta import Base

      log = logging.getLogger(__name__)

        marcink
    
added migrations from 1.2.X to 1.3

              r2000
            
        marcink
    
updated migration for version 1.2

              r900
            
      def upgrade(migrate_engine):

        marcink
    
source code cleanup: remove trailing white space, normalize file endings

              r1203
            
          """ Upgrade operations go here.

        marcink
    
updated migration for version 1.2

              r900
            
          Don't create your own engine; bind migrate_engine to your metadata

          """

          #==========================================================================

          # Add table `groups``

          #==========================================================================

        marcink
    
fixed migration import error

              r2195
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import Group as Group

        marcink
    
uncommented migrate tables, docfix

              r1026
            
          Group().__table__.create()

        marcink
    
updated migration for version 1.2

              r900
            
          #==========================================================================

          # Add table `group_to_perm`

          #==========================================================================

        marcink
    
freeze of models for future migrations using small schema files snapshoting current model state

              r1631
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UserRepoGroupToPerm

          UserRepoGroupToPerm().__table__.create()

        marcink
    
updated db migrations to schema 3

              r1023
            
          #==========================================================================

          # Add table `users_groups`

          #==========================================================================

        marcink
    
freeze of models for future migrations using small schema files snapshoting current model state

              r1631
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UsersGroup

        marcink
    
uncommented migrate tables, docfix

              r1026
            
          UsersGroup().__table__.create()

        marcink
    
updated db migrations to schema 3

              r1023
            
          #==========================================================================

          # Add table `users_groups_members`

          #==========================================================================

        marcink
    
freeze of models for future migrations using small schema files snapshoting current model state

              r1631
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UsersGroupMember

        marcink
    
updated db migrations to schema 3

              r1023
            
          UsersGroupMember().__table__.create()

          #==========================================================================

        marcink
    
Fixed permissions for users groups, group can have create repo permission now....

              r1271
            
          # Add table `users_group_repo_to_perm`

          #==========================================================================

        marcink
    
freeze of models for future migrations using small schema files snapshoting current model state

              r1631
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UsersGroupRepoToPerm

        marcink
    
Fixed permissions for users groups, group can have create repo permission now....

              r1271
            
          UsersGroupRepoToPerm().__table__.create()

          #==========================================================================

        marcink
    
updated db migrations to schema 3

              r1023
            
          # Add table `users_group_to_perm`

          #==========================================================================

        marcink
    
freeze of models for future migrations using small schema files snapshoting current model state

              r1631
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UsersGroupToPerm

        marcink
    
updated db migrations to schema 3

              r1023
            
          UsersGroupToPerm().__table__.create()

          #==========================================================================

          # Upgrade of `users` table

          #==========================================================================

        marcink
    
freeze of models for future migrations using small schema files snapshoting current model state

              r1631
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import User

        marcink
    
updated db migrations to schema 3

              r1023
            
          #add column

        marcink
    
migration fix for mysql

              r1762
            
          ldap_dn = Column("ldap_dn", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

        marcink
    
updated db migrations to schema 3

              r1023
            
          ldap_dn.create(User().__table__)

        marcink
    
updated migration schema

              r1133
            
          api_key = Column("api_key", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

          api_key.create(User().__table__)

        marcink
    
updated db migrations to schema 3

              r1023
            
          #remove old column

          is_ldap = Column("is_ldap", Boolean(), nullable=False, unique=None, default=False)

          is_ldap.drop(User().__table__)

        marcink
    
updated migration for version 1.2

              r900
            
          #==========================================================================

          # Upgrade of `repositories` table

        marcink
    
source code cleanup: remove trailing white space, normalize file endings

              r1203
            
          #==========================================================================

        marcink
    
freeze of models for future migrations using small schema files snapshoting current model state

              r1631
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import Repository

        marcink
    
updated migration for version 1.2

              r900
            
        marcink
    
migration schema fix

              r1509
            
          #ADD clone_uri column#

          clone_uri = Column("clone_uri", String(length=255, convert_unicode=False,

                                                 assert_unicode=None),

                              nullable=True, unique=False, default=None)

          clone_uri.create(Repository().__table__)

        marcink
    
auto white-space removal

              r1818
            
        marcink
    
updated db migrations to schema 3

              r1023
            
          #ADD downloads column#

          enable_downloads = Column("downloads", Boolean(), nullable=True, unique=None, default=True)

          enable_downloads.create(Repository().__table__)

        marcink
    
update migrations for 1.2

              r1442
            
          #ADD column created_on

          created_on = Column('created_on', DateTime(timezone=False), nullable=True,

                              unique=None, default=datetime.datetime.now)

          created_on.create(Repository().__table__)

        marcink
    
updated migration for version 1.2

              r900
            
          #ADD group_id column#

        marcink
    
Added missing FK to migration

              r908
            
          group_id = Column("group_id", Integer(), ForeignKey('groups.group_id'),

        marcink
    
updated migration for version 1.2

              r900
            
                        nullable=True, unique=False, default=None)

        marcink
    
Added missing FK to migration

              r908
            
          group_id.create(Repository().__table__)

        marcink
    
updated migration for version 1.2

              r900
            
        marcink
    
update migrations for 1.2

              r1442
            
          #==========================================================================

          # Upgrade of `user_followings` table

          #==========================================================================

        marcink
    
freeze of models for future migrations using small schema files snapshoting current model state

              r1631
            
          from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UserFollowing

        marcink
    
migration schema fix

              r1509
            
        marcink
    
auto white-space removal

              r1818
            
          follows_from = Column('follows_from', DateTime(timezone=False),

                                nullable=True, unique=None,

        marcink
    
migration schema fix

              r1509
            
                                default=datetime.datetime.now)

          follows_from.create(UserFollowing().__table__)

        marcink
    
update migrations for 1.2

              r1442
            
        marcink
    
updated migration for version 1.2

              r900
            
          return

      def downgrade(migrate_engine):

          meta = MetaData()

          meta.bind = migrate_engine

	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 updated migration for version 1.2	r900	import logging
		import datetime

		from sqlalchemy import *
		from sqlalchemy.exc import DatabaseError
		from sqlalchemy.orm import relation, backref, class_mapper
		from sqlalchemy.orm.session import Session
marcink Fixed dbmigrate issues.	r907
		from rhodecode.lib.dbmigrate.migrate import *
		from rhodecode.lib.dbmigrate.migrate.changeset import *

marcink updated migration for version 1.2	r900	from rhodecode.model.meta import Base

		log = logging.getLogger(__name__)

marcink added migrations from 1.2.X to 1.3	r2000
marcink updated migration for version 1.2	r900	def upgrade(migrate_engine):
marcink source code cleanup: remove trailing white space, normalize file endings	r1203	""" Upgrade operations go here.
marcink updated migration for version 1.2	r900	Don't create your own engine; bind migrate_engine to your metadata
		"""

		#==========================================================================
		# Add table `groups``
		#==========================================================================
marcink fixed migration import error	r2195	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import Group as Group
marcink uncommented migrate tables, docfix	r1026	Group().__table__.create()
marcink updated migration for version 1.2	r900
		#==========================================================================
		# Add table `group_to_perm`
		#==========================================================================
marcink freeze of models for future migrations using small schema files snapshoting current model state	r1631	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UserRepoGroupToPerm
		UserRepoGroupToPerm().__table__.create()
marcink updated db migrations to schema 3	r1023
		#==========================================================================
		# Add table `users_groups`
		#==========================================================================
marcink freeze of models for future migrations using small schema files snapshoting current model state	r1631	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UsersGroup
marcink uncommented migrate tables, docfix	r1026	UsersGroup().__table__.create()
marcink updated db migrations to schema 3	r1023
		#==========================================================================
		# Add table `users_groups_members`
		#==========================================================================
marcink freeze of models for future migrations using small schema files snapshoting current model state	r1631	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UsersGroupMember
marcink updated db migrations to schema 3	r1023	UsersGroupMember().__table__.create()

		#==========================================================================
marcink Fixed permissions for users groups, group can have create repo permission now....	r1271	# Add table `users_group_repo_to_perm`
		#==========================================================================
marcink freeze of models for future migrations using small schema files snapshoting current model state	r1631	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UsersGroupRepoToPerm
marcink Fixed permissions for users groups, group can have create repo permission now....	r1271	UsersGroupRepoToPerm().__table__.create()

		#==========================================================================
marcink updated db migrations to schema 3	r1023	# Add table `users_group_to_perm`
		#==========================================================================
marcink freeze of models for future migrations using small schema files snapshoting current model state	r1631	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UsersGroupToPerm
marcink updated db migrations to schema 3	r1023	UsersGroupToPerm().__table__.create()

		#==========================================================================
		# Upgrade of `users` table
		#==========================================================================
marcink freeze of models for future migrations using small schema files snapshoting current model state	r1631	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import User
marcink updated db migrations to schema 3	r1023
		#add column
marcink migration fix for mysql	r1762	ldap_dn = Column("ldap_dn", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
marcink updated db migrations to schema 3	r1023	ldap_dn.create(User().__table__)

marcink updated migration schema	r1133	api_key = Column("api_key", String(length=255, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)
		api_key.create(User().__table__)
marcink updated db migrations to schema 3	r1023
		#remove old column
		is_ldap = Column("is_ldap", Boolean(), nullable=False, unique=None, default=False)
		is_ldap.drop(User().__table__)

marcink updated migration for version 1.2	r900	#==========================================================================
		# Upgrade of `repositories` table
marcink source code cleanup: remove trailing white space, normalize file endings	r1203	#==========================================================================
marcink freeze of models for future migrations using small schema files snapshoting current model state	r1631	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import Repository
marcink updated migration for version 1.2	r900
marcink migration schema fix	r1509	#ADD clone_uri column#

		clone_uri = Column("clone_uri", String(length=255, convert_unicode=False,
		assert_unicode=None),
		nullable=True, unique=False, default=None)

		clone_uri.create(Repository().__table__)
marcink auto white-space removal	r1818
marcink updated db migrations to schema 3	r1023	#ADD downloads column#
		enable_downloads = Column("downloads", Boolean(), nullable=True, unique=None, default=True)
		enable_downloads.create(Repository().__table__)

marcink update migrations for 1.2	r1442	#ADD column created_on
		created_on = Column('created_on', DateTime(timezone=False), nullable=True,
		unique=None, default=datetime.datetime.now)
		created_on.create(Repository().__table__)

marcink updated migration for version 1.2	r900	#ADD group_id column#
marcink Added missing FK to migration	r908	group_id = Column("group_id", Integer(), ForeignKey('groups.group_id'),
marcink updated migration for version 1.2	r900	nullable=True, unique=False, default=None)

marcink Added missing FK to migration	r908	group_id.create(Repository().__table__)
marcink updated migration for version 1.2	r900
marcink update migrations for 1.2	r1442	#==========================================================================
		# Upgrade of `user_followings` table
		#==========================================================================

marcink freeze of models for future migrations using small schema files snapshoting current model state	r1631	from rhodecode.lib.dbmigrate.schema.db_1_2_0 import UserFollowing
marcink migration schema fix	r1509
marcink auto white-space removal	r1818	follows_from = Column('follows_from', DateTime(timezone=False),
		nullable=True, unique=None,
marcink migration schema fix	r1509	default=datetime.datetime.now)
		follows_from.create(UserFollowing().__table__)
marcink update migrations for 1.2	r1442
marcink updated migration for version 1.2	r900	return


		def downgrade(migrate_engine):
		meta = MetaData()
		meta.bind = migrate_engine