From a4196ff553cc85a455f2e05a3abecee64ca8b9d2 Mon Sep 17 00:00:00 2001 From: Dan Prince Date: Wed, 28 Nov 2012 14:39:34 -0500 Subject: 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 --- .../db/sqlalchemy/migrate_repo/versions/144_add_node_to_migrations.py | 4 ++-- 1 file 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) -- cgit