From cdd7d65b2d64732e5d2a9c83f4c5be6b087a445d Mon Sep 17 00:00:00 2001 From: Adam Young Date: Fri, 9 Nov 2012 14:12:59 -0500 Subject: populate table check. Change-Id: If82979923ba5c0193beeb1896ea5b4777dec735d --- tests/test_sql_upgrade.py | 16 +++++++++++++++- 1 file changed, 15 insertions(+), 1 deletion(-) diff --git a/tests/test_sql_upgrade.py b/tests/test_sql_upgrade.py index 945c90b3..0fe13a85 100644 --- a/tests/test_sql_upgrade.py +++ b/tests/test_sql_upgrade.py @@ -14,6 +14,9 @@ # License for the specific language governing permissions and limitations # under the License. +import copy +import json + from migrate.versioning import api as versioning_api import sqlalchemy @@ -21,7 +24,7 @@ from keystone.common import sql from keystone import config from keystone import test from keystone.common.sql import migration - +import default_fixtures CONF = config.CONF @@ -69,6 +72,17 @@ class SqlUpgradeTests(test.TestCase): self.assertTableColumns("user_tenant_membership", ["user_id", "tenant_id"]) self.assertTableColumns("metadata", ["user_id", "tenant_id", "data"]) + self.populate_user_table() + + def populate_user_table(self): + for user in default_fixtures.USERS: + extra = copy.deepcopy(user) + extra.pop('id') + extra.pop('name') + self.engine.execute("insert into user values ('%s', '%s', '%s')" + % (user['id'], + user['name'], + json.dumps(extra))) def select_table(self, name): table = sqlalchemy.Table(name, -- cgit