From d668eac4a63a9aa98c3efff395faa23cfcea1c1b Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Thu, 21 Mar 2024 17:08:37 +0100
Subject: [node] begin the great typescript rewrite

---
 nodejs/database/db.js | 51 ---------------------------------------------------
 1 file changed, 51 deletions(-)
 delete mode 100644 nodejs/database/db.js

(limited to 'nodejs/database/db.js')

diff --git a/nodejs/database/db.js b/nodejs/database/db.js
deleted file mode 100644
index 4438fec..0000000
--- a/nodejs/database/db.js
+++ /dev/null
@@ -1,51 +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',
-	'database/004_markets.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');
-
-function init() {
-	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 function reset() {
-	const indices = db.prepare(`SELECT name FROM sqlite_master WHERE type = 'index';`).all();
-	const tables = db.prepare(`SELECT name FROM sqlite_master WHERE type = 'table';`).all();
-	const triggers = db.prepare(`SELECT name FROM sqlite_master WHERE type = 'trigger';`).all();
-	const views = db.prepare(`SELECT name FROM sqlite_master WHERE type = 'view';`).all();
-	indices.forEach(elt => db.exec(`DROP INDEX ${elt.name};`));
-	tables.forEach(elt => db.exec(`DROP TABLE ${elt.name};`));
-	triggers.forEach(elt => db.exec(`DROP TRIGGER ${elt.name};`));
-	views.forEach(elt => db.exec(`DROP VIEW ${elt.name};`));
-	db.exec(`VACUUM;`);
-	init();
-}
-
-init();
-
-export default db;
-- 
cgit v1.2.3