aboutsummaryrefslogtreecommitdiff
path: root/sqitch/pg
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-11-06 19:27:16 +0000
committerChristopher Baines <mail@cbaines.net>2020-11-06 19:27:16 +0000
commit9b44218b3e5f8168aec5a8eef467f0cb9a5b8473 (patch)
tree68f51f1f431101584d77bae1746d152720f80b18 /sqitch/pg
parentf787df32634323d627e5f0f14f96aa3ac58aad21 (diff)
downloadbuild-coordinator-9b44218b3e5f8168aec5a8eef467f0cb9a5b8473.tar
build-coordinator-9b44218b3e5f8168aec5a8eef467f0cb9a5b8473.tar.gz
Add an unbuilt_outputs table
One of the slow things in the derivation ordered allocator is working out what outputs are unbuilt, as this requires looking at all the derivation outputs (of which there are lots), and checking if any build exists which has succeeded.
Diffstat (limited to 'sqitch/pg')
-rw-r--r--sqitch/pg/deploy/add_unbuilt_outputs_table.sql7
-rw-r--r--sqitch/pg/revert/add_unbuilt_outputs_table.sql7
-rw-r--r--sqitch/pg/verify/add_unbuilt_outputs_table.sql7
3 files changed, 21 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/add_unbuilt_outputs_table.sql b/sqitch/pg/deploy/add_unbuilt_outputs_table.sql
new file mode 100644
index 0000000..430f775
--- /dev/null
+++ b/sqitch/pg/deploy/add_unbuilt_outputs_table.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:add_unbuilt_outputs_table to pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/revert/add_unbuilt_outputs_table.sql b/sqitch/pg/revert/add_unbuilt_outputs_table.sql
new file mode 100644
index 0000000..2c1bd78
--- /dev/null
+++ b/sqitch/pg/revert/add_unbuilt_outputs_table.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_unbuilt_outputs_table from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/verify/add_unbuilt_outputs_table.sql b/sqitch/pg/verify/add_unbuilt_outputs_table.sql
new file mode 100644
index 0000000..1cefc9a
--- /dev/null
+++ b/sqitch/pg/verify/add_unbuilt_outputs_table.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_unbuilt_outputs_table on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;