Use sqlalchemy reflection in migration 080

Change-Id: If2a0e59461d108d59c6e9907d3db053ba2b44f57

1 files changed, 7 insertions, 10 deletions

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')