sqlite3 to node js
I have 3 tables:
db.run(`CREATE TABLE IF NOT EXISTS user ( id integer PRIMARY KEY AUTOINCREMENT, firstName varchar(30), lastName varchar(50), email varchar(150), phone varchar(12), address varchar(255), photo varchar(255), hash varchar(255), token varchar(255) )`); db.run(`CREATE TABLE IF NOT EXISTS advert ( id integer PRIMARY KEY AUTOINCREMENT, idUser integer, title varchar(255), date datetime, price double, category varchar(50), description text(2000), mainImage varchar(255), FOREIGN KEY (idUser) REFERENCES user(id) ON DELETE CASCADE )`); db.run(`CREATE TABLE IF NOT EXISTS favorites ( id integer PRIMARY KEY AUTOINCREMENT, idUser integer, idAdvert integer, FOREIGN KEY (idUser) REFERENCES user(id) ON DELETE CASCADE, FOREIGN KEY (idAdvert) REFERENCES advert(id) ON DELETE CASCADE )`); When deleting a user:
db.run(` DELETE FROM user WHERE id = ? `, [id], function(error) { ... }); The user is deleted, but the child tables are not deleted. If I do the same thing in sqlitebrowser, then everything works. Why is that?
PRAGMA foreign_keys;? - PetSerAlPRAGMA foreign_keysplay a role when adding / changing? - Fat-ZerPRAGMA foreign_keyshow to usePRAGMA foreign_keys, at least I will try. Nowhere I found how to specify this with nodejs - RomanPRAGMAhelped, thanks - Roman