summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDan Prince <dprince@redhat.com>2012-11-28 14:39:34 -0500
committerDan Prince <dprince@redhat.com>2012-11-28 14:39:34 -0500
commita4196ff553cc85a455f2e05a3abecee64ca8b9d2 (patch)
treeb8e4a787a2591e883d879654c2bc4cbe9628a01f
parent7d035cd1ee232a4ca8ea758e158891086cbe57d3 (diff)
downloadnova-a4196ff553cc85a455f2e05a3abecee64ca8b9d2.tar.gz
nova-a4196ff553cc85a455f2e05a3abecee64ca8b9d2.tar.xz
nova-a4196ff553cc85a455f2e05a3abecee64ca8b9d2.zip
Update migration so it supports PostgreSQL.
Updates the 'deleted' columns so that they are treated as Booleans instead of integers. This makes it so that 144_add_node_to_migrations.py works on both MySQL and PostgreSQL. Fixes LP Bug #1084208. Change-Id: Ibff1c45117e47126a255b2a1df5e915c881cb5c1
-rw-r--r--nova/db/sqlalchemy/migrate_repo/versions/144_add_node_to_migrations.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/nova/db/sqlalchemy/migrate_repo/versions/144_add_node_to_migrations.py b/nova/db/sqlalchemy/migrate_repo/versions/144_add_node_to_migrations.py
index 323add89c..97b0f7bb0 100644
--- a/nova/db/sqlalchemy/migrate_repo/versions/144_add_node_to_migrations.py
+++ b/nova/db/sqlalchemy/migrate_repo/versions/144_add_node_to_migrations.py
@@ -77,8 +77,8 @@ def _map_nodes(meta):
q = select([services.c.host, c_nodes.c.hypervisor_hostname],
- whereclause=and_(c_nodes.c.deleted == 0,
- services.c.deleted == 0),
+ whereclause=and_(c_nodes.c.deleted == False,
+ services.c.deleted == False),
from_obj=c_nodes.join(services,
c_nodes.c.service_id == services.c.id)