From d96add30a02dc6f5cee313f37b31c5525dbd5a3d Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sat, 22 Jun 2019 01:13:36 +0200 Subject: Record the output from loading new revisions to the database So that it can easily be shown through the web interface. There's two tables being used. One which temporarily stores the output as it's output while the job is running, and other which stores the whole log once the job has finished. --- sqitch/deploy/load_new_guix_revision_job_logs.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sqitch/deploy/load_new_guix_revision_job_logs.sql (limited to 'sqitch/deploy') diff --git a/sqitch/deploy/load_new_guix_revision_job_logs.sql b/sqitch/deploy/load_new_guix_revision_job_logs.sql new file mode 100644 index 0000000..9eb804e --- /dev/null +++ b/sqitch/deploy/load_new_guix_revision_job_logs.sql @@ -0,0 +1,16 @@ +-- Deploy guix-data-service:load_new_guix_revision_job_logs to pg + +BEGIN; + +CREATE TABLE load_new_guix_revision_job_log_parts ( + id integer NOT NULL, + job_id integer NOT NULL, + contents text NOT NULL +); + +CREATE TABLE load_new_guix_revision_job_logs ( + job_id integer PRIMARY KEY REFERENCES load_new_guix_revision_jobs (id), + contents text NOT NULL +); + +COMMIT; -- cgit v1.2.3