diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-06-27 21:33:24 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-07-01 17:43:38 +0100 |
| commit | b5c4e8a4528e2c819176cbe070f6fd8e3e34facd (patch) | |
| tree | 9d026e882411fc79b0736cdc9c97352d64ca7ef1 /sqitch | |
| parent | ab51128ee62b22971ea8b52d550e09d1c38f8ecd (diff) | |
| download | build-coordinator-b5c4e8a4528e2c819176cbe070f6fd8e3e34facd.tar build-coordinator-b5c4e8a4528e2c819176cbe070f6fd8e3e34facd.tar.gz | |
Support storing when builds start
This isn't particularly accurate, what's actually being stored is the current
time when the record is inserted in to the coordinator database, but that
should happen just before the agent starts the build, so hopefully that's good
enough.
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/pg/deploy/build_starts.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/build_starts.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/build_starts.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/sqlite/deploy/build_starts.sql | 12 | ||||
| -rw-r--r-- | sqitch/sqlite/revert/build_starts.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/verify/build_starts.sql | 7 |
7 files changed, 48 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/build_starts.sql b/sqitch/pg/deploy/build_starts.sql new file mode 100644 index 0000000..77c0f85 --- /dev/null +++ b/sqitch/pg/deploy/build_starts.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_starts to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_starts.sql b/sqitch/pg/revert/build_starts.sql new file mode 100644 index 0000000..d71c169 --- /dev/null +++ b/sqitch/pg/revert/build_starts.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_starts from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/build_starts.sql b/sqitch/pg/verify/build_starts.sql new file mode 100644 index 0000000..248f602 --- /dev/null +++ b/sqitch/pg/verify/build_starts.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_starts on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 5623d5b..e0712ce 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -17,3 +17,4 @@ build_results_result_index 2020-05-10T17:27:00Z Christopher Baines <mail@cbaines more_indexes_on_builds_and_derivation_inputs 2020-05-11T08:38:28Z Christopher Baines <mail@cbaines.net> # Add a couple more indexes build_tags 2020-05-31T13:54:41Z Christopher Baines <mail@cbaines.net> # Support tagging builds builds_created_at 2020-06-27T18:30:32Z Christopher Baines <mail@cbaines.net> # Add builds.created_at +build_starts 2020-06-27T20:23:38Z Christopher Baines <mail@cbaines.net> # Add build_starts table diff --git a/sqitch/sqlite/deploy/build_starts.sql b/sqitch/sqlite/deploy/build_starts.sql new file mode 100644 index 0000000..fbf8e8c --- /dev/null +++ b/sqitch/sqlite/deploy/build_starts.sql @@ -0,0 +1,12 @@ +-- Deploy guix-build-coordinator:build_starts to sqlite + +BEGIN; + +CREATE TABLE build_starts ( + id INTEGER PRIMARY KEY ASC, + build_id TEXT NOT NULL REFERENCES builds (uuid), + agent_id TEXT NOT NULL REFERENCES agents (id), + start_time TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/revert/build_starts.sql b/sqitch/sqlite/revert/build_starts.sql new file mode 100644 index 0000000..49d8eea --- /dev/null +++ b/sqitch/sqlite/revert/build_starts.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_starts from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/build_starts.sql b/sqitch/sqlite/verify/build_starts.sql new file mode 100644 index 0000000..e4d9460 --- /dev/null +++ b/sqitch/sqlite/verify/build_starts.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_starts on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |