db.serialize(() => { db.exec(schema) done() })
const createDb = () => new Promise((resolve, reject) => fs.readFile( path.join(__dirname, "00_schema.sql"), (err, data) => { if (err) return reject(err); db.exec(data.toString(), (err) => { if (err) return reject(err); resolve(); }) }))
db.run('CREATE TABLE IF NOT EXISTS files (id integer primary key, filename text unique, originalname text, size number, created datetime)', function() { db.all("PRAGMA table_info('files')", function(err, rows) { if (rows !== undefined && rows !== null) { var names = rows.map(function(val) { return val.name; }); if (names.indexOf('created') == -1) { // Add creation date if we are at version 0, version 0 shouldn't have it. db.exec('ALTER TABLE files ADD COLUMN created datetime'); } } }); });
db.exec('PRAGMA foreign_keys = ON;', pragmaErr => { if (pragmaErr) return Logger.error('Foreign key enforcement pragma query failed.'); });
db.exec(queries, err => { if (err) { console.log(`An error occurred while running the queries for version ${version.targetVersion}:`);
db.serialize(() => { db.exec(fixtures) done() })