Chapter 2 issue - Relationships between models

[AxelRHD]

I will have exactly the situation to use SQLite in development and a 'real' database in production (first Infobox).

But I can't figure out, where the following code block has to be inserted:

@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()

[mtcdultra]

Hi AxelRHD, I don't know if you already found the solution but for everyone has same problem, I can run the application inserting this code in main.py, below @app.route. Change "@event.listens_for" to "@db.event.listens_for" and include on the top of file "from sqlalchemy.engine import Engine".

Hope that work