1 files changed, 19 insertions, 0 deletions
diff --git a/backend/migrate.ts b/backend/migrate.ts
new file mode 100644
index 0000000..f02d7e9
--- /dev/null
+++ b/backend/migrate.ts
@@ -0,0 +1,19 @@
+/* eslint-disable @typescript-eslint/no-var-requires */
+import { SlonikMigrator } from "@slonik/migrator";
+import { createPool } from "slonik";
+import dotenv from "dotenv";
+dotenv.config();
+
+import * as config from "./config";
+
+// in an existing slonik project, this would usually be setup in another module
+const slonik = createPool(config.postgresConnectionString); // e.g. 'postgresql://postgres:postgres@localhost:5433/postgres'
+
+const migrator = new SlonikMigrator({
+    migrationsPath: __dirname + "/migrations",
+    migrationTableName: "migration",
+    slonik,
+    logger: console,
+});
+
+migrator.runAsCLI();