populate table check.

Change-Id: If82979923ba5c0193beeb1896ea5b4777dec735d

1 files changed, 15 insertions, 1 deletions

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,