Implement deferring builds

This isn't intended as some time based scheduling, but more as a way to slow
down builds by deferring processing them until some point in the future.

I'm intending to use this to test fixed output derivations. I can look up all
the derivations I want to test, then defer the builds to run spread out across
some period. This feature saves having to submit the builds gradually.

3 files changed, 21 insertions, 0 deletions

diff --git a/sqitch/sqlite/deploy/add_builds_deferred_until.sql b/sqitch/sqlite/deploy/add_builds_deferred_until.sql
new file mode 100644
index 0000000..db57b53
--- /dev/null
+++ b/sqitch/sqlite/deploy/add_builds_deferred_until.sql
@@ -0,0 +1,7 @@
+-- Deploy guix-build-coordinator:add_builds_deferred_until to sqlite
+
+BEGIN;
+
+ALTER TABLE builds ADD COLUMN deferred_until TEXT;
+
+COMMIT;
diff --git a/sqitch/sqlite/revert/add_builds_deferred_until.sql b/sqitch/sqlite/revert/add_builds_deferred_until.sql
new file mode 100644
index 0000000..ef41b03
--- /dev/null
+++ b/sqitch/sqlite/revert/add_builds_deferred_until.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:add_builds_deferred_until from sqlite
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqlite/verify/add_builds_deferred_until.sql b/sqitch/sqlite/verify/add_builds_deferred_until.sql
new file mode 100644
index 0000000..7e367da
--- /dev/null
+++ b/sqitch/sqlite/verify/add_builds_deferred_until.sql
@@ -0,0 +1,7 @@
+-- Verify guix-build-coordinator:add_builds_deferred_until on sqlite
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;