function seedDb () { return new Promise((resolve, reject) => { existsSync(dbPath) && unlinkSync(dbPath) const db = new Database(dbPath) db.run('create table todos (id integer, title text, user text)', (err) => { if (err) return reject(err) db.run("insert into todos values (1, 'one', 'Alice'), (2, 'two', 'Alice')", () => { db.close() resolve() }) }) }) }
// Close Database connection db.close((err) => { if (err) console.log(err.message); else console.log('Close the database connection.') });
const getDatabase = () => new Promise((resolve, reject) => { const db = new Database(path.join(__dirname, "../../database/database.sqlite")); resolve(db).then(db.close); })
function seedDb () { return new Promise((resolve, reject) => { existsSync(dbPath) && unlinkSync(dbPath) const db = new Database(dbPath) db.run('create table todos (id integer, title text, user text)', (err) => { if (err) return reject(err) db.run("insert into todos values (1, 'one', 'Alice'), (2, 'two', 'Alice')", () => { db.close() resolve() }) }) }) }