Re: [sqlalchemy] SQLite: How can I turn on ON DELETE CASCADE from within sqlalchemy?

Hi Mike. Thanks for your reply. That's great news! Just want to clarify on which level such constraints will be placed? sqlalchemy or the underlying database? So now if I want to use passive delete, which relies solely on the underlying SQLite database's constraints not the sqlalchemy's, I

[sqlalchemy] SQLite: How can I turn on ON DELETE CASCADE from within sqlalchemy?

I know you can set this constraint if you are directly dealing with sqlite3, but how can I achieve this database level setting from within sqlalchemy? The documentation reads: Note that these clauses are not supported on SQLite, and require InnoDB tables when used with MySQL. They may also

Re: [sqlalchemy] SQLite: How can I turn on ON DELETE CASCADE from within sqlalchemy?

On 8/6/15 5:56 PM, Jinghui Niu wrote: Hi Mike. Thanks for your reply. That's great news! Just want to clarify on which level such constraints will be placed? sqlalchemy or the underlying database? So now if I want to use passive delete, which relies solely on the underlying SQLite

Re: [sqlalchemy] SQLite: How can I turn on ON DELETE CASCADE from within sqlalchemy?

On 8/6/15 5:31 PM, Jinghui Niu wrote: I know you can set this constraint if you are directly dealing with sqlite3, but how can I achieve this database level setting from within sqlalchemy? The documentation reads: Note that these clauses are not supported on SQLite, and require