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?

  • one
    PRAGMA foreign_keys; ? - PetSerAl
  • No, it did not add. I do not understand how and where - Roman
  • @PetSerAl, does not PRAGMA foreign_keys play a role when adding / changing? - Fat-Zer
  • @ Fat-Zer or @PetSerAl plz PRAGMA foreign_keys how to use PRAGMA foreign_keys , at least I will try. Nowhere I found how to specify this with nodejs - Roman
  • Everything, PRAGMA helped, thanks - Roman

0