From 15a02b247436ba71c4f64a8ac8d79b32cc8883f1 Mon Sep 17 00:00:00 2001 From: Jason Kölker Date: Mon, 23 May 2011 13:06:55 -0500 Subject: make the migration run with tests --- nova/db/sqlalchemy/migrate_repo/versions/015_multi_nic.py | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/nova/db/sqlalchemy/migrate_repo/versions/015_multi_nic.py b/nova/db/sqlalchemy/migrate_repo/versions/015_multi_nic.py index b07576df3..fffcda29f 100644 --- a/nova/db/sqlalchemy/migrate_repo/versions/015_multi_nic.py +++ b/nova/db/sqlalchemy/migrate_repo/versions/015_multi_nic.py @@ -45,6 +45,16 @@ mac_addresses = Table('mac_addresses', meta, nullable=False), ) +# Don't autoload this table since sqlite will have issues when +# adding the column +fixed_ips = Table('fixed_ips', meta, + Column('id', Integer(), primary_key=True), + Column('address', String(255)), + Column('network_id', Integer(), ForeignKey('networks.id'), + nullable=True), + Column('instance_id', Integer(), ForeignKey('instances.id'), + nullable=True), + ) # bridge_interface column to add to networks table interface = Column('bridge_interface', @@ -66,7 +76,6 @@ def upgrade(migrate_engine): # grab tables and (column for dropping later) instances = Table('instances', meta, autoload=True) - fixed_ips = Table('fixed_ips', meta, autoload=True) networks = Table('networks', meta, autoload=True) c = instances.columns['mac_address'] -- cgit