From 1f6daef0180bc737a2883203f6d513e5b81712ed Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Tue, 7 May 2024 00:34:26 +0200
Subject: [node] improved sql migrations code

---
 nodejs/database/db.ts | 8 ++------
 1 file changed, 2 insertions(+), 6 deletions(-)

(limited to 'nodejs/database')

diff --git a/nodejs/database/db.ts b/nodejs/database/db.ts
index 115d6a3..2fba09b 100644
--- a/nodejs/database/db.ts
+++ b/nodejs/database/db.ts
@@ -2,12 +2,6 @@ import fs from 'fs';
 import path from 'path';
 import Database from 'better-sqlite3';
 
-let allMigrations: Array<string> = [];
-fs.readdir('./database/', function(err, files) {
-	if (err) throw err;
-	allMigrations = files.filter(e => e.match(/\.sql$/)).map(e => path.join('./database', e));
-});
-
 export type DbData = {data: string};
 
 export const db = new Database(
@@ -18,6 +12,8 @@ db.pragma('foreign_keys = ON');
 db.pragma('journal_mode = WAL');
 
 function init(): void {
+	const filenames = fs.readdirSync('./database/');
+	const allMigrations = filenames.filter(e => e.match(/\.sql$/)).map(e => path.join('./database', e));
 	db.transaction(function migrate() {
 		let version;
 		try {
-- 
cgit v1.2.3