diff options
author | Christopher Baines <mail@cbaines.net> | 2023-04-23 20:52:39 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2023-04-23 21:23:21 +0100 |
commit | 28d0ca2690bfb01f6dea0e79cc4d28fdfa23b4b0 (patch) | |
tree | 1966ec09cd6d252b2ff669cd7213a38bef59d0e7 /sqitch | |
parent | cf1900eb26700e36a0a78e0b8b4415d58519df15 (diff) | |
download | build-coordinator-28d0ca2690bfb01f6dea0e79cc4d28fdfa23b4b0.tar build-coordinator-28d0ca2690bfb01f6dea0e79cc4d28fdfa23b4b0.tar.gz |
Use an in memory table for the build_allocation_plan
Since this doesn't need to be persisted and changes often.
Diffstat (limited to 'sqitch')
-rw-r--r-- | sqitch/pg/deploy/remove_build_allocation_plan.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/remove_build_allocation_plan.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/remove_build_allocation_plan.sql | 7 | ||||
-rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
-rw-r--r-- | sqitch/sqlite/deploy/remove_build_allocation_plan.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/revert/remove_build_allocation_plan.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/remove_build_allocation_plan.sql | 7 |
7 files changed, 43 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/remove_build_allocation_plan.sql b/sqitch/pg/deploy/remove_build_allocation_plan.sql new file mode 100644 index 0000000..e622503 --- /dev/null +++ b/sqitch/pg/deploy/remove_build_allocation_plan.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:remove_build_allocation_plan to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/remove_build_allocation_plan.sql b/sqitch/pg/revert/remove_build_allocation_plan.sql new file mode 100644 index 0000000..a0bb43d --- /dev/null +++ b/sqitch/pg/revert/remove_build_allocation_plan.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:remove_build_allocation_plan from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/remove_build_allocation_plan.sql b/sqitch/pg/verify/remove_build_allocation_plan.sql new file mode 100644 index 0000000..45b47b0 --- /dev/null +++ b/sqitch/pg/verify/remove_build_allocation_plan.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:remove_build_allocation_plan on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 1591710..8c7d459 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -43,3 +43,4 @@ build_counts 2022-10-28T09:36:25Z Chris <chris@felis> # Add builds_counts build_results_counts 2022-10-28T09:36:35Z Chris <chris@felis> # Add build_results_counts replace_agent_status 2023-03-22T14:17:35Z Chris <chris@felis> # Replace agent_status agent_status_add_processor_count 2023-03-24T09:28:47Z Chris <chris@felis> # Add agent_status.processor_count +remove_build_allocation_plan 2023-04-23T19:50:23Z Chris <chris@felis> # Remove build_allocation_plan diff --git a/sqitch/sqlite/deploy/remove_build_allocation_plan.sql b/sqitch/sqlite/deploy/remove_build_allocation_plan.sql new file mode 100644 index 0000000..8bdc7c7 --- /dev/null +++ b/sqitch/sqlite/deploy/remove_build_allocation_plan.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:remove_build_allocation_plan to sqlite + +BEGIN; + +DROP TABLE build_allocation_plan; + +COMMIT; diff --git a/sqitch/sqlite/revert/remove_build_allocation_plan.sql b/sqitch/sqlite/revert/remove_build_allocation_plan.sql new file mode 100644 index 0000000..46a102e --- /dev/null +++ b/sqitch/sqlite/revert/remove_build_allocation_plan.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:remove_build_allocation_plan from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/remove_build_allocation_plan.sql b/sqitch/sqlite/verify/remove_build_allocation_plan.sql new file mode 100644 index 0000000..7158794 --- /dev/null +++ b/sqitch/sqlite/verify/remove_build_allocation_plan.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:remove_build_allocation_plan on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |