Sqlite / SQLAlchemy: how to enforce Foreign Keys?

by

For recent versions (SQLAlchemy ~0.7) the SQLAlchemy homepage says:

PoolListener is deprecated. Please refer to PoolEvents.

Then the example by CarlS becomes:

engine = create_engine(database_url)

def _fk_pragma_on_connect(dbapi_con, con_record):
    dbapi_con.execute('pragma foreign_keys=ON')

from sqlalchemy import event
event.listen(engine, 'connect', _fk_pragma_on_connect)

More Related Contents:

  1. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  2. SqlAlchemy – Filtering by Relationship Attribute
  3. How to discover table properties from SQLAlchemy mapped object
  4. sqlalchemy: create relations but without foreign key constraint in db?
  5. creating a database outside the application context
  6. How to delete a table in SQLAlchemy?
  7. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  8. Can’t change system default SQLite binary
  9. SQLAlchemy: print the actual query
  10. How to retrieve inserted id after inserting row in SQLite using Python?
  11. Query for list of attribute instead of tuples in SQLAlchemy
  12. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  13. How to give column name dynamically from string variable in sql alchemy filter?
  14. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  15. Python sqlite3 and concurrency
  16. Python call sql-server stored procedure with table valued parameter
  17. Generate sql with subquery as a column in select statement using SQLAlchemy
  18. What if I don’t close the database connection in Python SQLite
  19. How can I verify Column data types in the SQLAlchemy ORM?
  20. Complex foreign key constraint in SQLAlchemy
  21. Connection problems with SQLAlchemy and multiple processes
  22. How to upsert pandas DataFrame to Microsoft SQL Server table?
  23. Is this Python code vulnerable to SQL injection? (SQLite3)
  24. SQLAlchemy: engine, connection and session difference
  25. Relations on composite keys using sqlalchemy
  26. Python SQLite3 SQL Injection Vulnerable Code
  27. SQLAlchemy column name with space
  28. Passing SQLite variables in Python
  29. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  30. using sqlalchemy to load csv file into a database

Leave a Comment