Python - How to use Sqlite3 database (Constraints - Foreign Key to have Referential Integrity)-Part6

preview_player
Показать описание
Python - How to use Sqlite3 database (Constraints - Foreign Key to have Referential Integrity) -Part5
This part covers -
1. Create parent table
2. Use FOREIGN KEY to create child table to establish relationship between parent & child tables
3. How to enable Foreign Key effect in SQLITE3 with PRAGMA foreign_keys = 1
4. Verification of data correctly being stored in child table
5. Verification of IntegirtyError to have FOREIGN KEY constraint failed with not present data in parent table

Рекомендации по теме
Комментарии
Автор

3:35 that is is exactly the line I was looking for. Thanks!)

GreenGotty
Автор

That was helpful, thank you! Just a suggestion for future coding videos it would be very nice if you could upload the code somewhere.

Jaenu