diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2024-11-18 01:18:45 -0500 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-02-16 19:25:04 -0500 |
| commit | e35e92beb9ccdabf5692107966c2cf9c2e91c4dd (patch) | |
| tree | cfb65d4aeb9b8fe53f6573fbf21e485600341528 /packages/backend/migration | |
| parent | add missing constraint names to `SkActivityLog` and `SkActivityContext` (diff) | |
| download | sharkey-e35e92beb9ccdabf5692107966c2cf9c2e91c4dd.tar.gz sharkey-e35e92beb9ccdabf5692107966c2cf9c2e91c4dd.tar.bz2 sharkey-e35e92beb9ccdabf5692107966c2cf9c2e91c4dd.zip | |
log inbound activity duration
Diffstat (limited to 'packages/backend/migration')
| -rw-r--r-- | packages/backend/migration/1731909785724-activity-log-timing.js | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/packages/backend/migration/1731909785724-activity-log-timing.js b/packages/backend/migration/1731909785724-activity-log-timing.js new file mode 100644 index 0000000000..8b72fb8972 --- /dev/null +++ b/packages/backend/migration/1731909785724-activity-log-timing.js @@ -0,0 +1,19 @@ +/* + * SPDX-FileCopyrightText: hazelnoot and other Sharkey contributors + * SPDX-License-Identifier: AGPL-3.0-only + */ + +export class ActivityLogTiming1731909785724 { + name = 'ActivityLogTiming1731909785724' + + async up(queryRunner) { + await queryRunner.query(`ALTER TABLE "activity_log" ADD "duration" double precision NOT NULL DEFAULT '0'`); + await queryRunner.query(`ALTER TABLE "activity_log" ALTER COLUMN "result" DROP NOT NULL`); + } + + async down(queryRunner) { + await queryRunner.query(`UPDATE "activity_log" SET "result" = 'not processed' WHERE "result" IS NULL`); + await queryRunner.query(`ALTER TABLE "activity_log" ALTER COLUMN "result" SET NOT NULL`); + await queryRunner.query(`ALTER TABLE "activity_log" DROP COLUMN "duration"`); + } +} |