Mercurial > kallithea

comparison rhodecode/lib/dbmigrate/versions/003_version_1_2_0.py @ 908:de560c47dd03 beta

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added missing FK to migration
author Marcin Kuzminski <marcin@python-works.com>
date Sun, 02 Jan 2011 20:52:24 +0100
parents 2f83756f3041
children e7478ac19f9f
comparison
equal deleted inserted replaced
907:2f83756f3041 908:de560c47dd03
3 3
4 from sqlalchemy import * 4 from sqlalchemy import *
5 from sqlalchemy.exc import DatabaseError 5 from sqlalchemy.exc import DatabaseError
6 from sqlalchemy.orm import relation, backref, class_mapper 6 from sqlalchemy.orm import relation, backref, class_mapper
7 from sqlalchemy.orm.session import Session 7 from sqlalchemy.orm.session import Session
8
9 8
10 from rhodecode.lib.dbmigrate.migrate import * 9 from rhodecode.lib.dbmigrate.migrate import *
11 from rhodecode.lib.dbmigrate.migrate.changeset import * 10 from rhodecode.lib.dbmigrate.migrate.changeset import *
12 11
13 from rhodecode.model.meta import Base 12 from rhodecode.model.meta import Base
33 GroupToPerm().__table__.create() 32 GroupToPerm().__table__.create()
34 33
35 #========================================================================== 34 #==========================================================================
36 # Upgrade of `repositories` table 35 # Upgrade of `repositories` table
37 #========================================================================== 36 #==========================================================================
38 tblname = 'repositories' 37 from rhodecode.model.db import Repository
39 tbl = Table(tblname, MetaData(bind=migrate_engine), autoload=True,
40 autoload_with=migrate_engine)
41 38
42 #ADD group_id column# 39 #ADD group_id column#
43 group_id = Column("group_id", Integer(), #ForeignKey('groups.group_id'), 40 group_id = Column("group_id", Integer(), ForeignKey('groups.group_id'),
44 nullable=True, unique=False, default=None) 41 nullable=True, unique=False, default=None)
45 42
46 group_id.create(tbl) 43 group_id.create(Repository().__table__)
47 44
48 # TODO: fix this somehow ?!
49 # cons = ForeignKeyConstraint([tbl.c.group_id], ['groups.group_id'], table=tbl)
50 #
51 # cons.create()
52 return 45 return
53 46
54 47
55 def downgrade(migrate_engine): 48 def downgrade(migrate_engine):
56 meta = MetaData() 49 meta = MetaData()