From 83e60464ad2675f09ddee02f6b166bef22f53f33 Mon Sep 17 00:00:00 2001 From: Rory& Date: Thu, 11 Jun 2026 23:18:02 +0200 Subject: Move migrations to database --- .../1776178642013-Int8PrimaryKeysWebhooks.ts | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 src/database/migration/postgres/1776178642013-Int8PrimaryKeysWebhooks.ts (limited to 'src/database/migration/postgres/1776178642013-Int8PrimaryKeysWebhooks.ts') diff --git a/src/database/migration/postgres/1776178642013-Int8PrimaryKeysWebhooks.ts b/src/database/migration/postgres/1776178642013-Int8PrimaryKeysWebhooks.ts new file mode 100644 index 00000000..a5fdfbdf --- /dev/null +++ b/src/database/migration/postgres/1776178642013-Int8PrimaryKeysWebhooks.ts @@ -0,0 +1,23 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class Int8PrimaryKeysWebhooks1776178642013 implements MigrationInterface { + name = "Int8PrimaryKeysWebhooks1776178642013"; + + public async up(queryRunner: QueryRunner): Promise { + await this.convertPks(queryRunner, "int8"); + } + + public async down(queryRunner: QueryRunner): Promise { + await this.convertPks(queryRunner, "varchar"); + } + + private async convertPks(queryRunner: QueryRunner, to: string) { + // webhooks + // -> messages + await queryRunner.query(`ALTER TABLE messages DROP CONSTRAINT "FK_f83c04bcf1df4e5c0e7a52ed348";`); //webhook_id + await queryRunner.query(`ALTER TABLE messages ALTER COLUMN webhook_id TYPE ${to} USING webhook_id::${to}`); + // and finally, cleanup + await queryRunner.query(`ALTER TABLE webhooks ALTER COLUMN id TYPE ${to} USING id::${to};`); + await queryRunner.query(`ALTER TABLE public.messages ADD CONSTRAINT "FK_f83c04bcf1df4e5c0e7a52ed348" FOREIGN KEY (webhook_id) REFERENCES webhooks(id);`); + } +} -- cgit 1.5.1