Merge "Add db test that checks that shadow tables are up-to-date"

1 files changed, 11 insertions, 0 deletions

diff --git a/nova/tests/test_db_api.py b/nova/tests/test_db_api.py
index f54addced..3cb0254e1 100644
--- a/nova/tests/test_db_api.py
+++ b/nova/tests/test_db_api.py
@@ -28,6 +28,7 @@ import mox
 from oslo.config import cfg
 from sqlalchemy.dialects import sqlite
 from sqlalchemy.exc import IntegrityError
+from sqlalchemy import MetaData
 from sqlalchemy.sql.expression import select
 
 from nova import context
@@ -4351,6 +4352,16 @@ class ArchiveTestCase(test.TestCase):
                 del_statement = table.delete(table.c.domain.in_(self.uuidstrs))
                 self.conn.execute(del_statement)
 
+    def test_shadow_tables(self):
+        metadata = MetaData(bind=self.engine)
+        metadata.reflect()
+        for table_name in metadata.tables:
+            if table_name.startswith("shadow_"):
+                self.assertIn(table_name[7:], metadata.tables)
+                continue
+            self.assertTrue(db_utils.check_shadow_table(self.engine,
+                                                        table_name))
+
     def test_archive_deleted_rows(self):
         # Add 6 rows to table
         for uuidstr in self.uuidstrs: