From 11e355321db20b70c76c35b6e8fc36dbb9d97fc6 Mon Sep 17 00:00:00 2001 From: vincent van beek Date: Wed, 15 Apr 2026 16:19:02 +0200 Subject: add a job report to the scenario overview with details and time data (#406) * add a job report to the scenario overview with details and time data * create Report data class --- .../src/main/resources/db/migration/V1__add_job_report_column.sql | 2 ++ .../src/main/resources/db/migration/V2__add_job_started_at.sql | 2 ++ 2 files changed, 4 insertions(+) create mode 100644 opendc-web/opendc-web-server/src/main/resources/db/migration/V1__add_job_report_column.sql create mode 100644 opendc-web/opendc-web-server/src/main/resources/db/migration/V2__add_job_started_at.sql (limited to 'opendc-web/opendc-web-server/src/main/resources/db') diff --git a/opendc-web/opendc-web-server/src/main/resources/db/migration/V1__add_job_report_column.sql b/opendc-web/opendc-web-server/src/main/resources/db/migration/V1__add_job_report_column.sql new file mode 100644 index 00000000..108b0c07 --- /dev/null +++ b/opendc-web/opendc-web-server/src/main/resources/db/migration/V1__add_job_report_column.sql @@ -0,0 +1,2 @@ +-- Add report column to job table to store simulation warnings and errors +ALTER TABLE job ADD COLUMN IF NOT EXISTS report jsonb; diff --git a/opendc-web/opendc-web-server/src/main/resources/db/migration/V2__add_job_started_at.sql b/opendc-web/opendc-web-server/src/main/resources/db/migration/V2__add_job_started_at.sql new file mode 100644 index 00000000..9df4601a --- /dev/null +++ b/opendc-web/opendc-web-server/src/main/resources/db/migration/V2__add_job_started_at.sql @@ -0,0 +1,2 @@ +-- Add startedAt timestamp to track when job execution begins +ALTER TABLE job ADD COLUMN IF NOT EXISTS started_at TIMESTAMP; -- cgit v1.2.3