openstack
/
nova
Code Issues Proposed changes

Merge "Do not test foreign keys with SQLite version < 3.7" into stable/grizzly

This commit is contained in:
Jenkins 2013-05-09 16:37:36 +00:00 committed by Gerrit Code Review
parent 7bf3e8d3e2 e49e38cbd9
commit be94dd25bf
1 changed files with 9 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

9
nova/tests/test_db_api.py
View File

@ -2619,6 +2619,15 @@ class ArchiveTestCase(test.TestCase):
# SQLite doesn't enforce foreign key constraints without a pragma.
dialect = self.engine.url.get_dialect()
if dialect == sqlite.dialect:
# We're seeing issues with foreign key support in SQLite 3.6.20
# SQLAlchemy doesn't support it at all with < SQLite 3.6.19
# It works fine in SQLite 3.7.
# So return early to skip this test if running SQLite < 3.7
import sqlite3
tup = sqlite3.sqlite_version_info
if tup[0] < 3 or (tup[0] == 3 and tup[1] < 7):
self.skipTest(
'sqlite version too old for reliable SQLA foreign_keys')
self.conn.execute("PRAGMA foreign_keys = ON")
insert_statement = self.console_pools.insert().values(deleted=1)
result = self.conn.execute(insert_statement)