search

Basketball-Competition-Dashboard / Project

Backend programs
0 stars 0 forks source link

SQLite connection with foreign key constraints on #26

Closed AsherJingkongChen closed 1 day ago

AsherJingkongChen commented 4 days ago

Description

Potential failure. The Python SQLite client had to use connection.execute("PRAGMA foreign_keys = ON") every connection to the database.

Note

https://www.sqlitetutorial.net/sqlite-foreign-key/

https://www.lesinskis.com/enforcing-foreign-key-constraints-with-sqlite.html

AsherJingkongChen commented 4 days ago

I will try to solve it during testing.