wallets-api / server /delete-wallets.js
z1amez's picture
v.1
2dddd1f
raw
history blame contribute delete
521 Bytes
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();
});
});