From f021b52028f5965516671b7f53e7e71543a8ae52 Mon Sep 17 00:00:00 2001 From: Jan Tuomi Date: Wed, 30 Jun 2021 11:33:40 +0300 Subject: Do things --- backend/migrate.ts | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 backend/migrate.ts (limited to 'backend/migrate.ts') 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(); -- cgit v1.3