Skip to content

Instantly share code, notes, and snippets.

@ansrivas

ansrivas/include_this.py

Created October 26, 2018 15:41
Show Gist options
  • Save ansrivas/2b225054adb822c847703023ef670ae5 to your computer and use it in GitHub Desktop.
Save ansrivas/2b225054adb822c847703023ef670ae5 to your computer and use it in GitHub Desktop.
Download ZIP
Sqlite foreign keys on with sqlalchemy
Raw
include_this.py
from sqlalchemy import event
from sqlalchemy.engine import Engine
@event.listens_for(Engine, "connect")
def set_sqlite_pragma(dbapi_connection, connection_record):
cursor = dbapi_connection.cursor()
cursor.execute("PRAGMA foreign_keys=ON")
cursor.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment