Spaces:
Sleeping
Sleeping
Download src/database/migrations/1779235200000-AddUuidDefaultsForPostgres.ts from jinksQspider/openWa: direct link, hf CLI and curl.
- Browser
- Download file 1.84 kB
-
https://huggingface.co/spaces/jinksQspider/openWa/resolve/main/src/database/migrations/1779235200000-AddUuidDefaultsForPostgres.ts
- Command line
-
hf download hf://spaces/jinksQspider/openWa/src/database/migrations/1779235200000-AddUuidDefaultsForPostgres.ts
-
curl -L -o 1779235200000-AddUuidDefaultsForPostgres.ts https://huggingface.co/spaces/jinksQspider/openWa/resolve/main/src/database/migrations/1779235200000-AddUuidDefaultsForPostgres.ts
1.84 kB
| 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 "<table>" 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<void> { | |
| 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<void> { | |
| 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`); | |
| } | |
| } | |
| } | |