diff options
Diffstat (limited to 'sqitch')
19 files changed, 135 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/allocated_builds_submit_outputs.sql b/sqitch/pg/deploy/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..a2ebe1e --- /dev/null +++ b/sqitch/pg/deploy/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:allocated_builds_submit_outputs to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/deploy/background-jobs-queue.sql b/sqitch/pg/deploy/background-jobs-queue.sql new file mode 100644 index 0000000..63dd8d4 --- /dev/null +++ b/sqitch/pg/deploy/background-jobs-queue.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:background-jobs-queue to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/deploy/builds_replace_unprocessed_index.sql b/sqitch/pg/deploy/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..782cf6b --- /dev/null +++ b/sqitch/pg/deploy/builds_replace_unprocessed_index.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:builds_replace_unprocessed_index to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/allocated_builds_submit_outputs.sql b/sqitch/pg/revert/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..255efb1 --- /dev/null +++ b/sqitch/pg/revert/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:allocated_builds_submit_outputs from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/background-jobs-queue.sql b/sqitch/pg/revert/background-jobs-queue.sql new file mode 100644 index 0000000..46b0761 --- /dev/null +++ b/sqitch/pg/revert/background-jobs-queue.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:background-jobs-queue from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/builds_replace_unprocessed_index.sql b/sqitch/pg/revert/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..4395f90 --- /dev/null +++ b/sqitch/pg/revert/builds_replace_unprocessed_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:builds_replace_unprocessed_index from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/allocated_builds_submit_outputs.sql b/sqitch/pg/verify/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..e95a717 --- /dev/null +++ b/sqitch/pg/verify/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:allocated_builds_submit_outputs on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/pg/verify/background-jobs-queue.sql b/sqitch/pg/verify/background-jobs-queue.sql new file mode 100644 index 0000000..a36097e --- /dev/null +++ b/sqitch/pg/verify/background-jobs-queue.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:background-jobs-queue on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/pg/verify/builds_replace_unprocessed_index.sql b/sqitch/pg/verify/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..050ef75 --- /dev/null +++ b/sqitch/pg/verify/builds_replace_unprocessed_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:builds_replace_unprocessed_index on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index cfb5b9d..f4f538b 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -46,3 +46,6 @@ agent_status_add_processor_count 2023-03-24T09:28:47Z Chris <chris@felis> # Add remove_build_allocation_plan 2023-04-23T19:50:23Z Chris <chris@felis> # Remove build_allocation_plan system_uptime 2023-05-05T18:18:35Z Chris <chris@felis> # Add system uptime build_starts_index 2023-11-24T16:30:13Z Chris <chris@felis> # build_starts index +background-jobs-queue 2025-02-06T10:49:08Z Chris <chris@fang> # Add background_jobs_queue +builds_replace_unprocessed_index 2025-02-19T11:19:42Z Chris <chris@fang> # Replace builds_unprocessed +allocated_builds_submit_outputs 2025-03-02T08:22:48Z Chris <chris@fang> # Add allocated_builds.submit_outputs diff --git a/sqitch/sqlite/deploy/allocated_builds_submit_outputs.sql b/sqitch/sqlite/deploy/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..66d6b45 --- /dev/null +++ b/sqitch/sqlite/deploy/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:allocated_builds_submit_outputs to sqlite + +BEGIN; + +ALTER TABLE allocated_builds ADD COLUMN submit_outputs BOOLEAN DEFAULT NULL; + +COMMIT; diff --git a/sqitch/sqlite/deploy/background-jobs-queue.sql b/sqitch/sqlite/deploy/background-jobs-queue.sql new file mode 100644 index 0000000..1cb35f0 --- /dev/null +++ b/sqitch/sqlite/deploy/background-jobs-queue.sql @@ -0,0 +1,11 @@ +-- Deploy guix-build-coordinator:background-jobs-queue to sqlite + +BEGIN; + +CREATE TABLE background_jobs_queue ( + id INTEGER PRIMARY KEY, + type TEXT NOT NULL, + args TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql b/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..a404f31 --- /dev/null +++ b/sqitch/sqlite/deploy/builds_replace_unprocessed_index.sql @@ -0,0 +1,9 @@ +-- Deploy guix-build-coordinator:builds_replace_unprocessed_index to sqlite + +BEGIN; + +DROP INDEX builds_unprocessed; + +CREATE INDEX builds_live ON builds (id) WHERE processed = 0 AND canceled = 0; + +COMMIT; diff --git a/sqitch/sqlite/revert/allocated_builds_submit_outputs.sql b/sqitch/sqlite/revert/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..240de22 --- /dev/null +++ b/sqitch/sqlite/revert/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:allocated_builds_submit_outputs from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/revert/background-jobs-queue.sql b/sqitch/sqlite/revert/background-jobs-queue.sql new file mode 100644 index 0000000..10ef1ff --- /dev/null +++ b/sqitch/sqlite/revert/background-jobs-queue.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:background-jobs-queue from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/revert/builds_replace_unprocessed_index.sql b/sqitch/sqlite/revert/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..b02dd3c --- /dev/null +++ b/sqitch/sqlite/revert/builds_replace_unprocessed_index.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:builds_replace_unprocessed_index from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/allocated_builds_submit_outputs.sql b/sqitch/sqlite/verify/allocated_builds_submit_outputs.sql new file mode 100644 index 0000000..0b1331e --- /dev/null +++ b/sqitch/sqlite/verify/allocated_builds_submit_outputs.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:allocated_builds_submit_outputs on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqlite/verify/background-jobs-queue.sql b/sqitch/sqlite/verify/background-jobs-queue.sql new file mode 100644 index 0000000..1cf9965 --- /dev/null +++ b/sqitch/sqlite/verify/background-jobs-queue.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:background-jobs-queue on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqlite/verify/builds_replace_unprocessed_index.sql b/sqitch/sqlite/verify/builds_replace_unprocessed_index.sql new file mode 100644 index 0000000..d0dd086 --- /dev/null +++ b/sqitch/sqlite/verify/builds_replace_unprocessed_index.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:builds_replace_unprocessed_index on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |