Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | 54x 54x 784x 784x 784x 791x 791x 784x 405x 405x 405x 405x 405x 21x 405x 784x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 403x 784x 405x 405x 2x 2x 403x 403x 403x 405x 784x 54x | 'use strict';
module.exports = ({ external: { fs, modulesDirectory, path }, }) => {
const SCHEMA_VERSION = '39';
const schema = fs.readFileSync(path.join(modulesDirectory, 'spec/schema.sql'), 'utf8');
function tableExists(database, name) {
return database.prepare('SELECT 1 FROM sqlite_schema WHERE type = \'table\' AND name = ?').pluck().get(name) !== undefined;
}
function storedSchemaVersion(database) {
const table = tableExists(database, 'database_metadata')
? 'database_metadata'
: (tableExists(database, 'metadata') ? 'metadata' : null);
if (!table)
return undefined;
return database.prepare(`SELECT value FROM ${table} WHERE key = 'schema_version'`).pluck().get();
}
function recreateDatabase(database) {
const foreignKeys = database.pragma('foreign_keys', { simple: true });
database.pragma('foreign_keys = OFF');
try {
database.transaction(() => {
database.exec(`
DROP TABLE IF EXISTS posting_tags;
DROP TABLE IF EXISTS ingestion_warnings;
DROP TABLE IF EXISTS transaction_tags;
DROP TABLE IF EXISTS tags;
DROP TABLE IF EXISTS resolved_posting_amounts;
DROP TABLE IF EXISTS comments;
DROP TABLE IF EXISTS notes;
DROP TABLE IF EXISTS transaction_notes;
DROP TABLE IF EXISTS file_comments;
DROP TABLE IF EXISTS postings;
DROP TABLE IF EXISTS prices;
DROP TABLE IF EXISTS valuation_prices;
DROP TABLE IF EXISTS account_declarations;
DROP TABLE IF EXISTS tag_declarations;
DROP TABLE IF EXISTS commodity_properties;
DROP TABLE IF EXISTS commodity_declarations;
DROP TABLE IF EXISTS transactions;
DROP TABLE IF EXISTS journal_entries;
DROP TABLE IF EXISTS source_files;
DROP TABLE IF EXISTS database_metadata;
DROP TABLE IF EXISTS metadata;
DROP TABLE IF EXISTS sek_prices;
`);
database.exec(schema);
})();
}
finally {
database.pragma(`foreign_keys = ${foreignKeys ? 'ON' : 'OFF'}`);
}
}
function migrateDatabase(database) {
const existingVersion = storedSchemaVersion(database);
if (existingVersion === SCHEMA_VERSION) {
database.exec(schema);
}
else {
recreateDatabase(database);
}
}
return { SCHEMA_VERSION, migrateDatabase };
};
|