diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-04-13 15:44:05 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-04-13 15:44:05 +0100 |
| commit | cc2d1ddf2444e33196443eba3df7961b6dd5917e (patch) | |
| tree | 52974451df5ec664ee0f002f7a61baf2954c5464 | |
| parent | 6ffd98ba3689418f4c47efa666c018f3e443fba5 (diff) | |
| download | build-coordinator-cc2d1ddf2444e33196443eba3df7961b6dd5917e.tar build-coordinator-cc2d1ddf2444e33196443eba3df7961b6dd5917e.tar.gz | |
Add the build_results table
| -rw-r--r-- | sqitch/pg/deploy/build_results.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/build_results.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/build_results.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/sqlite/deploy/build_results.sql | 12 | ||||
| -rw-r--r-- | sqitch/sqlite/revert/build_results.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/verify/build_results.sql | 7 |
7 files changed, 48 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/build_results.sql b/sqitch/pg/deploy/build_results.sql new file mode 100644 index 0000000..2cd44ce --- /dev/null +++ b/sqitch/pg/deploy/build_results.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_results to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_results.sql b/sqitch/pg/revert/build_results.sql new file mode 100644 index 0000000..e0ca698 --- /dev/null +++ b/sqitch/pg/revert/build_results.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_results from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/build_results.sql b/sqitch/pg/verify/build_results.sql new file mode 100644 index 0000000..5a7d850 --- /dev/null +++ b/sqitch/pg/verify/build_results.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_results on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 698e54f..21a3134 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -6,3 +6,4 @@ initial_derivation_tables 2020-04-04T09:48:34Z Christopher Baines <mail@cbaines. create_builds 2020-04-06T18:50:48Z Christopher Baines <mail@cbaines.net> # Create builds initial_agent_tables 2020-04-09T20:03:53Z Christopher Baines <mail@cbaines.net> # Create initial tables for agent related state build_allocation_tables 2020-04-10T19:26:36Z Christopher Baines <mail@cbaines.net> # Create initial tables for allocating builds +build_results 2020-04-12T19:59:27Z Christopher Baines <mail@cbaines.net> # Create table for storing build results diff --git a/sqitch/sqlite/deploy/build_results.sql b/sqitch/sqlite/deploy/build_results.sql new file mode 100644 index 0000000..abf0085 --- /dev/null +++ b/sqitch/sqlite/deploy/build_results.sql @@ -0,0 +1,12 @@ +-- Deploy guix-build-coordinator:build_results to sqlite + +BEGIN; + +CREATE TABLE build_results ( + build_id TEXT PRIMARY KEY NOT NULL REFERENCES builds (uuid), + agent_id TEXT NOT NULL REFERENCES agents (id), + result TEXT NOT NULL, + failure_reason +); + +COMMIT; diff --git a/sqitch/sqlite/revert/build_results.sql b/sqitch/sqlite/revert/build_results.sql new file mode 100644 index 0000000..42174e4 --- /dev/null +++ b/sqitch/sqlite/revert/build_results.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_results from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/build_results.sql b/sqitch/sqlite/verify/build_results.sql new file mode 100644 index 0000000..6bb2941 --- /dev/null +++ b/sqitch/sqlite/verify/build_results.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_results on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |