aboutsummaryrefslogtreecommitdiff
path: root/sqitch
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-07-18 18:17:20 +0100
committerChristopher Baines <mail@cbaines.net>2020-08-26 18:40:14 +0100
commit15f27e9d4310242e34729b03dd4227a2b2d193a3 (patch)
tree91464e0d2c6a83b7423eb146cca3b585e4c6529b /sqitch
parentcdbcd13773ef525ca463609e21a596cb7922894d (diff)
downloadbuild-coordinator-15f27e9d4310242e34729b03dd4227a2b2d193a3.tar
build-coordinator-15f27e9d4310242e34729b03dd4227a2b2d193a3.tar.gz
Store if the derivation is a fixed output derivation
As this information will come in useful when working out how to handle builds for fixed output derivations. Specifically, I want to make it configurable whether to add builds for fixed output derivations if a build already exists for the output, but the derivation is different. Currently, different fixed output derivations can be ignored but it's not possible to just avoid adding more builds for non fixed output derivations while adding builds when fixed output derivations change. This new information will help enable that.
Diffstat (limited to 'sqitch')
-rw-r--r--sqitch/pg/deploy/add_fixed_output_to_derivations.sql7
-rw-r--r--sqitch/pg/revert/add_fixed_output_to_derivations.sql7
-rw-r--r--sqitch/pg/verify/add_fixed_output_to_derivations.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/sqlite/deploy/add_fixed_output_to_derivations.sql9
-rw-r--r--sqitch/sqlite/revert/add_fixed_output_to_derivations.sql7
-rw-r--r--sqitch/sqlite/verify/add_fixed_output_to_derivations.sql7
7 files changed, 45 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/add_fixed_output_to_derivations.sql b/sqitch/pg/deploy/add_fixed_output_to_derivations.sql
new file mode 100644
index 0000000..b2c6755
--- /dev/null
+++ b/sqitch/pg/deploy/add_fixed_output_to_derivations.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:add_fixed_output_to_derivations to pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/revert/add_fixed_output_to_derivations.sql b/sqitch/pg/revert/add_fixed_output_to_derivations.sql
new file mode 100644
index 0000000..7402822
--- /dev/null
+++ b/sqitch/pg/revert/add_fixed_output_to_derivations.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_fixed_output_to_derivations from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/verify/add_fixed_output_to_derivations.sql b/sqitch/pg/verify/add_fixed_output_to_derivations.sql
new file mode 100644
index 0000000..f6a1eca
--- /dev/null
+++ b/sqitch/pg/verify/add_fixed_output_to_derivations.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_fixed_output_to_derivations on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index a793617..7df0842 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -20,3 +20,4 @@ builds_created_at 2020-06-27T18:30:32Z Christopher Baines <mail@cbaines.net> # A
build_starts 2020-06-27T20:23:38Z Christopher Baines <mail@cbaines.net> # Add build_starts table
add_builds_end_time 2020-06-27T20:58:01Z Christopher Baines <mail@cbaines.net> # Add builds.end_time field
build_allocation_agent_requested_systems 2020-07-02T19:45:02Z Christopher Baines <mail@cbaines.net> # Add new build_allocation_agent_requested_systems table
+add_fixed_output_to_derivations 2020-07-18T14:49:51Z Christopher Baines <mail@cbaines.net> # Add derivations.fixed_output
diff --git a/sqitch/sqlite/deploy/add_fixed_output_to_derivations.sql b/sqitch/sqlite/deploy/add_fixed_output_to_derivations.sql
new file mode 100644
index 0000000..992ee06
--- /dev/null
+++ b/sqitch/sqlite/deploy/add_fixed_output_to_derivations.sql
@@ -0,0 +1,9 @@
+-- Deploy guix-build-coordinator:add_fixed_output_to_derivations to sqlite
+
+BEGIN;
+
+ALTER TABLE derivations
+ ADD COLUMN fixed_output BOOLEAN
+ CHECK (fixed_output IN (0,1));
+
+COMMIT;
diff --git a/sqitch/sqlite/revert/add_fixed_output_to_derivations.sql b/sqitch/sqlite/revert/add_fixed_output_to_derivations.sql
new file mode 100644
index 0000000..4d92fb7
--- /dev/null
+++ b/sqitch/sqlite/revert/add_fixed_output_to_derivations.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_fixed_output_to_derivations from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqlite/verify/add_fixed_output_to_derivations.sql b/sqitch/sqlite/verify/add_fixed_output_to_derivations.sql
new file mode 100644
index 0000000..b4aacf1
--- /dev/null
+++ b/sqitch/sqlite/verify/add_fixed_output_to_derivations.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_fixed_output_to_derivations on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;