summaryrefslogtreecommitdiff
path: root/database/db.js
diff options
context:
space:
mode:
Diffstat (limited to 'database/db.js')
-rw-r--r--database/db.js33
1 files changed, 0 insertions, 33 deletions
diff --git a/database/db.js b/database/db.js
deleted file mode 100644
index 4855233..0000000
--- a/database/db.js
+++ /dev/null
@@ -1,33 +0,0 @@
-import fs from 'fs';
-import Database from 'better-sqlite3';
-
-const allMigrations = [
- 'database/000_init.sql',
- 'database/001_systems.sql',
- 'database/002_ships.sql',
- 'database/003_surveys.sql',
-];
-
-const db = new Database(
- process.env.NODE_ENV === 'test' ? 'test.db' : 'spacetraders.db',
- process.env.NODE_ENV === 'development' ? { verbose: console.log } : null
-);
-db.pragma('foreign_keys = ON');
-db.pragma('journal_mode = WAL');
-
-db.transaction(function migrate() {
- let version;
- try {
- version = db.prepare('SELECT version FROM schema_version').get().version;
- } catch {
- version = 0;
- }
- if (version === allMigrations.length) return;
- while (version < allMigrations.length) {
- db.exec(fs.readFileSync(allMigrations[version], 'utf8'));
- version++;
- }
- db.exec(`DELETE FROM schema_version; INSERT INTO schema_version (version) VALUES (${version});`);
-})();
-
-export default db;