aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-01-05 12:16:21 +0000
committerChristopher Baines <mail@cbaines.net>2020-01-05 12:16:21 +0000
commit1679c985c4ec3ccaa1d39b0537ad7fe795103782 (patch)
tree74b0f5f3f55c857117a74a7caf7168bc061d74fc
parentc388f3ee1350ed0cee9d31c4f53011449a17f828 (diff)
downloaddata-service-1679c985c4ec3ccaa1d39b0537ad7fe795103782.tar
data-service-1679c985c4ec3ccaa1d39b0537ad7fe795103782.tar.gz
Add a table to configure which build servers build what
-rw-r--r--sqitch/deploy/build_servers_build_config.sql12
-rw-r--r--sqitch/revert/build_servers_build_config.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/verify/build_servers_build_config.sql7
4 files changed, 27 insertions, 0 deletions
diff --git a/sqitch/deploy/build_servers_build_config.sql b/sqitch/deploy/build_servers_build_config.sql
new file mode 100644
index 0000000..3ffbadd
--- /dev/null
+++ b/sqitch/deploy/build_servers_build_config.sql
@@ -0,0 +1,12 @@
+-- Deploy guix-data-service:build_servers_build_config to pg
+
+BEGIN;
+
+CREATE TABLE build_servers_build_config (
+ build_server_id integer REFERENCES build_servers(id),
+ system varchar NOT NULL,
+ target varchar NOT NULL,
+ PRIMARY KEY (build_server_id, system, target)
+);
+
+COMMIT;
diff --git a/sqitch/revert/build_servers_build_config.sql b/sqitch/revert/build_servers_build_config.sql
new file mode 100644
index 0000000..872472a
--- /dev/null
+++ b/sqitch/revert/build_servers_build_config.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:build_servers_build_config from pg
+
+BEGIN;
+
+DROP TABLE build_servers_build_config;
+
+COMMIT;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index 9a23d31..b981cc0 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -41,3 +41,4 @@ builds_add_derivation_output_details_set_id 2019-12-07T18:25:38Z Christopher Bai
derivations_hash_index 2019-12-24T22:54:19Z Christopher Baines <mail@cbaines.net> # Add index on derivations for the hash component of the filename
add_derivation_source_file_nars 2019-12-28T20:37:06Z Christopher Baines <mail@cbaines.net> # Add table for derivation source file nars
derivation_source_files_store_path_hash_index 2019-12-29T17:53:08Z Christopher Baines <mail@cbaines.net> # Add index on the hash part of the derivation source files store path
+build_servers_build_config 2020-01-05T12:06:13Z Christopher Baines <mail@cbaines.net> # Add build_servers_build_config table
diff --git a/sqitch/verify/build_servers_build_config.sql b/sqitch/verify/build_servers_build_config.sql
new file mode 100644
index 0000000..18c901a
--- /dev/null
+++ b/sqitch/verify/build_servers_build_config.sql
@@ -0,0 +1,7 @@
+-- Verify guix-data-service:build_servers_build_config on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;