Replace datastore-fetch-input-builds-for-unprocessed-builds

It worked under some database conditions, but was very slow under others. Move
more of the logic in to SQL in an attempt to make the allocator faster. This
sort of works, but there were some advantages to the approach before the
approach being replaced in this commit.

3 files changed, 21 insertions, 0 deletions

diff --git a/sqitch/pg/deploy/build_results_result_index.sql b/sqitch/pg/deploy/build_results_result_index.sql
new file mode 100644
index 0000000..aa1030e
--- /dev/null
+++ b/sqitch/pg/deploy/build_results_result_index.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:build_results_result_index to pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/revert/build_results_result_index.sql b/sqitch/pg/revert/build_results_result_index.sql
new file mode 100644
index 0000000..f92fd22
--- /dev/null
+++ b/sqitch/pg/revert/build_results_result_index.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:build_results_result_index from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/pg/verify/build_results_result_index.sql b/sqitch/pg/verify/build_results_result_index.sql
new file mode 100644
index 0000000..1c19fd1
--- /dev/null
+++ b/sqitch/pg/verify/build_results_result_index.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:build_results_result_index on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;