Comment 2 for bug 1021023

SQLite3 does not enforce FK constraints by default, even if they have been successfully compiled into the library. An explicit PRAGMA is required at run time.

One solution is to implement the pattern described here: http://stackoverflow.com/a/7831210
A good location for this code is nova/tests/__init__.py