comparison rhodecode/lib/dbmigrate/versions/006_version_1_4_0.py @ 3148:b31984972e95 beta

Migration upgrades cache for lightweight dashboard Fixed some migration issues
author Marcin Kuzminski <marcin@python-works.com>
date Sat, 05 Jan 2013 02:20:35 +0100
parents acc05c33cc0c
children fa6ba6727475
comparison
equal deleted inserted replaced
3147:8182ebed2922 3148:b31984972e95
10 from rhodecode.lib.dbmigrate.migrate import * 10 from rhodecode.lib.dbmigrate.migrate import *
11 from rhodecode.lib.dbmigrate.migrate.changeset import * 11 from rhodecode.lib.dbmigrate.migrate.changeset import *
12 12
13 from rhodecode.model.meta import Base 13 from rhodecode.model.meta import Base
14 from rhodecode.model import meta 14 from rhodecode.model import meta
15 from rhodecode.lib.dbmigrate.versions import _reset_base
15 16
16 log = logging.getLogger(__name__) 17 log = logging.getLogger(__name__)
17 18
18 19
19 def upgrade(migrate_engine): 20 def upgrade(migrate_engine):
47 #========================================================================== 48 #==========================================================================
48 from rhodecode.lib.dbmigrate.schema.db_1_4_0 import ChangesetStatus 49 from rhodecode.lib.dbmigrate.schema.db_1_4_0 import ChangesetStatus
49 tbl = ChangesetStatus.__table__ 50 tbl = ChangesetStatus.__table__
50 tbl.create() 51 tbl.create()
51 52
52 ## RESET COMPLETLY THE metadata for sqlalchemy to use the 1_3_0 Base 53 _reset_base(migrate_engine)
53 Base = declarative_base()
54 Base.metadata.clear()
55 Base.metadata = MetaData()
56 Base.metadata.bind = migrate_engine
57 meta.Base = Base
58 54
59 #========================================================================== 55 #==========================================================================
60 # USERS TABLE 56 # USERS TABLE
61 #========================================================================== 57 #==========================================================================
62 from rhodecode.lib.dbmigrate.schema.db_1_3_0 import User 58 from rhodecode.lib.dbmigrate.schema.db_1_3_0 import User
171 # add FK to pull_request 167 # add FK to pull_request
172 pull_request_id = Column("pull_request_id", Integer(), 168 pull_request_id = Column("pull_request_id", Integer(),
173 ForeignKey('pull_requests.pull_request_id'), 169 ForeignKey('pull_requests.pull_request_id'),
174 nullable=True) 170 nullable=True)
175 pull_request_id.create(table=tbl) 171 pull_request_id.create(table=tbl)
176 ## RESET COMPLETLY THE metadata for sqlalchemy back after using 1_3_0 172 _reset_base(migrate_engine)
177 Base = declarative_base()
178 Base.metadata.clear()
179 Base.metadata = MetaData()
180 Base.metadata.bind = migrate_engine
181 meta.Base = Base
182 173
183 174
184 def downgrade(migrate_engine): 175 def downgrade(migrate_engine):
185 meta = MetaData() 176 meta = MetaData()
186 meta.bind = migrate_engine 177 meta.bind = migrate_engine