From c76821f570cfb8702e345859f827b06b28fc9b43 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sun, 27 Dec 2020 09:11:03 +0000 Subject: 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. --- sqitch/sqlite/deploy/add_builds_deferred_until.sql | 7 +++++++ sqitch/sqlite/revert/add_builds_deferred_until.sql | 7 +++++++ sqitch/sqlite/verify/add_builds_deferred_until.sql | 7 +++++++ 3 files changed, 21 insertions(+) create mode 100644 sqitch/sqlite/deploy/add_builds_deferred_until.sql create mode 100644 sqitch/sqlite/revert/add_builds_deferred_until.sql create mode 100644 sqitch/sqlite/verify/add_builds_deferred_until.sql (limited to 'sqitch/sqlite') 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; -- cgit v1.2.3