Move migrations to database

1 files changed, 23 insertions, 0 deletions

diff --git a/src/database/migration/postgres/1776178642011-Int8PrimaryKeysTemplates.ts b/src/database/migration/postgres/1776178642011-Int8PrimaryKeysTemplates.ts
new file mode 100644

index 00000000..b2e1b56f
--- /dev/null
+++ b/src/database/migration/postgres/1776178642011-Int8PrimaryKeysTemplates.ts
@@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner } from "typeorm";
+
+export class Int8PrimaryKeysTemplates1776178642011 implements MigrationInterface {
+    name = "Int8PrimaryKeysTemplates1776178642011";
+
+    public async up(queryRunner: QueryRunner): Promise<void> {
+        await this.convertPks(queryRunner, "int8");
+    }
+
+    public async down(queryRunner: QueryRunner): Promise<void> {
+        await this.convertPks(queryRunner, "varchar");
+    }
+
+    private async convertPks(queryRunner: QueryRunner, to: string) {
+        // templates
+        // -> guilds
+        await queryRunner.query(`ALTER TABLE guilds DROP CONSTRAINT "FK_e2a2f873a64a5cf62526de42325";`); //template_id
+        await queryRunner.query(`ALTER TABLE guilds ALTER COLUMN template_id TYPE ${to} USING template_id::${to}`);
+        // and finally, cleanup
+        await queryRunner.query(`ALTER TABLE templates ALTER COLUMN id TYPE ${to} USING id::${to};`);
+        await queryRunner.query(`ALTER TABLE public.guilds ADD CONSTRAINT "FK_e2a2f873a64a5cf62526de42325" FOREIGN KEY (template_id) REFERENCES templates(id);`);
+    }
+}