diff options
| author | vincent van beek <vincent@vlogic.nl> | 2026-04-15 16:19:02 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2026-04-15 16:19:02 +0200 |
| commit | 11e355321db20b70c76c35b6e8fc36dbb9d97fc6 (patch) | |
| tree | f12b8c8c2b6a642b315f2e4a7e54274bbcdb60be /opendc-web/opendc-web-server/src/main/resources/db | |
| parent | 3e52cd36bed9455105f4a8c3d83ec805c1fb7b70 (diff) | |
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
Diffstat (limited to 'opendc-web/opendc-web-server/src/main/resources/db')
2 files changed, 4 insertions, 0 deletions
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; |