From c01cef9340a3d55884fe38b60b209dbad5f97ea6 Mon Sep 17 00:00:00 2001 From: Hengqing Hu Date: Thu, 8 Mar 2012 16:45:51 +0800 Subject: Use sqlalchemy reflection in migration 080 Change-Id: If2a0e59461d108d59c6e9907d3db053ba2b44f57 --- .../080_add_hypervisor_hostname_to_compute_nodes.py | 17 +++++++---------- 1 file changed, 7 insertions(+), 10 deletions(-) (limited to 'nova') diff --git a/nova/db/sqlalchemy/migrate_repo/versions/080_add_hypervisor_hostname_to_compute_nodes.py b/nova/db/sqlalchemy/migrate_repo/versions/080_add_hypervisor_hostname_to_compute_nodes.py index c53297fab..28a3ce48f 100644 --- a/nova/db/sqlalchemy/migrate_repo/versions/080_add_hypervisor_hostname_to_compute_nodes.py +++ b/nova/db/sqlalchemy/migrate_repo/versions/080_add_hypervisor_hostname_to_compute_nodes.py @@ -12,22 +12,19 @@ # See the License for the specific language governing permissions and # limitations under the License. -from sqlalchemy import * - - -meta = MetaData() - -compute_nodes = Table("compute_nodes", meta, Column("id", Integer(), - primary_key=True, nullable=False)) - -hypervisor_hostname = Column("hypervisor_hostname", String(255)) +from sqlalchemy import Column, MetaData, String, Table def upgrade(migrate_engine): + meta = MetaData() meta.bind = migrate_engine + compute_nodes = Table("compute_nodes", meta, autoload=True) + hypervisor_hostname = Column("hypervisor_hostname", String(255)) compute_nodes.create_column(hypervisor_hostname) def downgrade(migrate_engine): + meta = MetaData() meta.bind = migrate_engine - compute_nodes.drop_column(hypervisor_hostname) + compute_nodes = Table("compute_nodes", meta, autoload=True) + compute_nodes.drop_column('hypervisor_hostname') -- cgit