diff options
| author | Christopher Baines <mail@cbaines.net> | 2021-11-12 14:08:41 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2021-11-12 14:08:41 +0000 |
| commit | f48e07b0e4b8e739848f8a1fc09b6f1dd4a74bca (patch) | |
| tree | a7ccf591b6442b2fb424f448d45c3ae73ffec572 /sqitch | |
| parent | aa6fe55754f7a7c21e4fb454a641d24ab957a0de (diff) | |
| download | build-coordinator-f48e07b0e4b8e739848f8a1fc09b6f1dd4a74bca.tar build-coordinator-f48e07b0e4b8e739848f8a1fc09b6f1dd4a74bca.tar.gz | |
Add an active field to the agents table
To allow making agents inactive to stop allocating builds to them.
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/pg/deploy/add_agents_active.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/add_agents_active.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/add_agents_active.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/sqlite/deploy/add_agents_active.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/revert/add_agents_active.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/verify/add_agents_active.sql | 7 |
7 files changed, 43 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/add_agents_active.sql b/sqitch/pg/deploy/add_agents_active.sql new file mode 100644 index 0000000..66505af --- /dev/null +++ b/sqitch/pg/deploy/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:add_agents_active to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/add_agents_active.sql b/sqitch/pg/revert/add_agents_active.sql new file mode 100644 index 0000000..9c1a86e --- /dev/null +++ b/sqitch/pg/revert/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:add_agents_active from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/add_agents_active.sql b/sqitch/pg/verify/add_agents_active.sql new file mode 100644 index 0000000..fc338da --- /dev/null +++ b/sqitch/pg/verify/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:add_agents_active on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 68e770e..6a2ddcd 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -35,3 +35,4 @@ fix_setup_failure_missing_inputs 2021-04-08T19:31:49Z Christopher Baines <mail@c create_outputs 2021-05-21T13:37:49Z Christopher Baines <mail@cbaines.net> # Create the outputs table create_systems 2021-05-21T17:22:52Z Christopher Baines <mail@cbaines.net> # Create the systems table create_unprocessed_builds_with_derived_priorities 2021-10-22T14:52:18Z Christopher Baines <mail@cbaines.net> # Create unprocessed_builds_with_derived_priorities +add_agents_active 2021-11-12T14:00:52Z Christopher Baines <mail@cbaines.net> # Add agents.active diff --git a/sqitch/sqlite/deploy/add_agents_active.sql b/sqitch/sqlite/deploy/add_agents_active.sql new file mode 100644 index 0000000..989f22c --- /dev/null +++ b/sqitch/sqlite/deploy/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:add_agents_active to sqlite + +BEGIN; + +ALTER TABLE agents ADD COLUMN active NOT NULL DEFAULT 1; + +COMMIT; diff --git a/sqitch/sqlite/revert/add_agents_active.sql b/sqitch/sqlite/revert/add_agents_active.sql new file mode 100644 index 0000000..58b732a --- /dev/null +++ b/sqitch/sqlite/revert/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:add_agents_active from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/add_agents_active.sql b/sqitch/sqlite/verify/add_agents_active.sql new file mode 100644 index 0000000..dab723c --- /dev/null +++ b/sqitch/sqlite/verify/add_agents_active.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:add_agents_active on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |