Spaces:
Sleeping
Sleeping
File size: 521 Bytes
2dddd1f | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | const sqlite3 = require('sqlite3');
const path = require('path');
const dbPath = path.resolve(__dirname, 'database.sqlite');
const db = new sqlite3.Database(dbPath, (err) => {
if (err) {
console.error(err);
return;
}
db.run("DELETE FROM wallets WHERE name='Cash' OR name='RMB' OR id > 12", function(err) {
if (err) {
console.error(err);
} else {
console.log(`Deleted ${this.changes} rows from wallets.`);
}
db.close();
});
});
|