From e3bcd36243f49ee37d668dd3adff32f21cb0dc31 Mon Sep 17 00:00:00 2001 From: Joe Gordon Date: Thu, 11 Oct 2012 18:19:04 +0000 Subject: Revert "Tell SQLite to enforce foreign keys." This patch broke the unit tests. (0 tests were being run) This reverts commit 5b4b7e4083b85bd9c10792cf0adb11dc07e92333. Change-Id: I9b34a4f12c2c17c8f03899f9d92752ec84068be8 --- nova/db/sqlalchemy/session.py | 10 ---------- 1 file changed, 10 deletions(-) diff --git a/nova/db/sqlalchemy/session.py b/nova/db/sqlalchemy/session.py index a1257e151..6c349e0c2 100644 --- a/nova/db/sqlalchemy/session.py +++ b/nova/db/sqlalchemy/session.py @@ -67,14 +67,6 @@ def add_regexp_listener(dbapi_con, con_record): dbapi_con.create_function('regexp', 2, regexp) -def enforce_foreign_keys_listener(dbapi_conn, connection_rec): - """Tell SQLite to enforce foreign keys. - - Requires SQLite version >= 3.6.19. - """ - dbapi_conn.execute("PRAGMA foreign_keys = ON") - - def greenthread_yield(dbapi_con, con_record): """ Ensure other greenthreads get a chance to execute by forcing a context @@ -150,8 +142,6 @@ def get_engine(): sqlalchemy.event.listen(_ENGINE, 'connect', synchronous_switch_listener) sqlalchemy.event.listen(_ENGINE, 'connect', add_regexp_listener) - sqlalchemy.event.listen(_ENGINE, 'connect', - enforce_foreign_keys_listener) if (FLAGS.sql_connection_trace and _ENGINE.dialect.dbapi.__name__ == 'MySQLdb'): -- cgit