From cc2d1ddf2444e33196443eba3df7961b6dd5917e Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Mon, 13 Apr 2020 15:44:05 +0100 Subject: Add the build_results table --- sqitch/pg/deploy/build_results.sql | 7 +++++++ sqitch/pg/revert/build_results.sql | 7 +++++++ sqitch/pg/verify/build_results.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/sqlite/deploy/build_results.sql | 12 ++++++++++++ sqitch/sqlite/revert/build_results.sql | 7 +++++++ sqitch/sqlite/verify/build_results.sql | 7 +++++++ 7 files changed, 48 insertions(+) create mode 100644 sqitch/pg/deploy/build_results.sql create mode 100644 sqitch/pg/revert/build_results.sql create mode 100644 sqitch/pg/verify/build_results.sql create mode 100644 sqitch/sqlite/deploy/build_results.sql create mode 100644 sqitch/sqlite/revert/build_results.sql create mode 100644 sqitch/sqlite/verify/build_results.sql 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 # Create builds initial_agent_tables 2020-04-09T20:03:53Z Christopher Baines # Create initial tables for agent related state build_allocation_tables 2020-04-10T19:26:36Z Christopher Baines # Create initial tables for allocating builds +build_results 2020-04-12T19:59:27Z Christopher Baines # 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; -- cgit v1.2.3