aboutsummaryrefslogtreecommitdiff
path: root/sqitch
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-06-27 13:58:21 +0100
committerChristopher Baines <mail@cbaines.net>2020-06-27 14:05:51 +0100
commitddbe4c2192e2d45ab63971fe78baaf1ddba3ca91 (patch)
treeafe7a7538b4d05ca0b7b878d1b1fffb23d8b9f92 /sqitch
parent1d48885e6a4c245e3a65185f1768b40b5a47e883 (diff)
downloaddata-service-ddbe4c2192e2d45ab63971fe78baaf1ddba3ca91.tar
data-service-ddbe4c2192e2d45ab63971fe78baaf1ddba3ca91.tar.gz
Support storing the id's representing builds in other services
Like Cuirass, or the Guix Data Service. This isn't so necessary with Cuirass, as the derivation/output are unique identifiers, but for the Guix Build Coordinator, one derivation/output can be built many times, with potentially differing results.
Diffstat (limited to 'sqitch')
-rw-r--r--sqitch/deploy/build_add_build_server_build_id.sql7
-rw-r--r--sqitch/revert/build_add_build_server_build_id.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/verify/build_add_build_server_build_id.sql7
4 files changed, 22 insertions, 0 deletions
diff --git a/sqitch/deploy/build_add_build_server_build_id.sql b/sqitch/deploy/build_add_build_server_build_id.sql
new file mode 100644
index 0000000..01a52ff
--- /dev/null
+++ b/sqitch/deploy/build_add_build_server_build_id.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-data-service:build_add_build_server_build_id to pg
+
+BEGIN;
+
+ALTER TABLE builds ADD COLUMN build_server_build_id varchar;
+
+COMMIT;
diff --git a/sqitch/revert/build_add_build_server_build_id.sql b/sqitch/revert/build_add_build_server_build_id.sql
new file mode 100644
index 0000000..c192cab
--- /dev/null
+++ b/sqitch/revert/build_add_build_server_build_id.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:build_add_build_server_build_id from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index c494c55..f3c4272 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -62,3 +62,4 @@ make_nar_urls_file_size_optional 2020-06-03T05:27:29Z Christopher Baines <mail@c
translations_for_lint_checker_descriptions 2020-05-22T19:49:37Z daniela <daniela@linux-ijv5> # Support translations for lint checker descriptions
translations_for_package_synopsis_and_descriptions 2020-06-09T12:42:54Z daniela <daniela@linux-ijv5> # Support translations for package synopsis and descriptions
build_status_nullable_timestamp 2020-06-27T12:34:29Z Christopher Baines <mail@cbaines.net> # Make build_status.timestamp nullable
+build_add_build_server_build_id 2020-06-27T12:48:57Z Christopher Baines <mail@cbaines.net> # Add builds.build_server_build_id
diff --git a/sqitch/verify/build_add_build_server_build_id.sql b/sqitch/verify/build_add_build_server_build_id.sql
new file mode 100644
index 0000000..5743f35
--- /dev/null
+++ b/sqitch/verify/build_add_build_server_build_id.sql
@@ -0,0 +1,7 @@
+-- Verify guix-data-service:build_add_build_server_build_id on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;