import { MigrationInterface, QueryRunner } from 'typeorm'; /** * Adds `gen_random_uuid()::varchar` DEFAULT to every `id` column on Postgres. * * Why this is needed: * The initial schema migration (1770108659848-AddMessageStatus) created the * `id` columns on Postgres as `varchar PRIMARY KEY NOT NULL` without a * DEFAULT. The TypeORM Postgres driver emits `INSERT ... VALUES (DEFAULT, ...)` * for `@PrimaryGeneratedColumn('uuid')` columns and expects the database to * supply the value. Without a column DEFAULT this fails with: * null value in column "id" of relation "" violates not-null constraint * * This migration is a no-op on SQLite (TypeORM generates the UUID in the * driver layer there, so no DB default is needed). * * `gen_random_uuid()` is built into PostgreSQL 13+ — no extension required. */ export class AddUuidDefaultsForPostgres1779235200000 implements MigrationInterface { name = 'AddUuidDefaultsForPostgres1779235200000'; private readonly tables = ['sessions', 'webhooks', 'messages', 'api_keys', 'audit_logs', 'message_batches']; public async up(queryRunner: QueryRunner): Promise { if (queryRunner.connection.options.type !== 'postgres') return; for (const table of this.tables) { const exists = await queryRunner.hasTable(table); if (!exists) continue; await queryRunner.query(`ALTER TABLE "${table}" ALTER COLUMN "id" SET DEFAULT gen_random_uuid()::varchar`); } } public async down(queryRunner: QueryRunner): Promise { if (queryRunner.connection.options.type !== 'postgres') return; for (const table of this.tables) { const exists = await queryRunner.hasTable(table); if (!exists) continue; await queryRunner.query(`ALTER TABLE "${table}" ALTER COLUMN "id" DROP DEFAULT`); } } }