diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-05-24 17:02:53 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-05-24 17:02:53 +0100 |
| commit | b6754c8a4c1135a803fa72fbf4208d46c301b105 (patch) | |
| tree | bf057704a4e0f6a121800ff936bc98ec967f1122 /sqitch | |
| parent | f11421824dd22d4d5ad49ebc190e654ab62517ff (diff) | |
| download | data-service-b6754c8a4c1135a803fa72fbf4208d46c301b105.tar data-service-b6754c8a4c1135a803fa72fbf4208d46c301b105.tar.gz | |
Add a lookup_builds field to the build_servers table
This is to allow for build servers where only the substitutes should be
queried, and it shouldn't be assumed that they're running Cuirass.
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/deploy/build_servers_lookup_builds.sql | 7 | ||||
| -rw-r--r-- | sqitch/revert/build_servers_lookup_builds.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/verify/build_servers_lookup_builds.sql | 7 |
4 files changed, 22 insertions, 0 deletions
diff --git a/sqitch/deploy/build_servers_lookup_builds.sql b/sqitch/deploy/build_servers_lookup_builds.sql new file mode 100644 index 0000000..dc16602 --- /dev/null +++ b/sqitch/deploy/build_servers_lookup_builds.sql @@ -0,0 +1,7 @@ +-- Deploy guix-data-service:build_servers_lookup_builds to pg + +BEGIN; + +ALTER TABLE build_servers ADD COLUMN lookup_builds boolean NOT NULL DEFAULT TRUE; + +COMMIT; diff --git a/sqitch/revert/build_servers_lookup_builds.sql b/sqitch/revert/build_servers_lookup_builds.sql new file mode 100644 index 0000000..62f55a1 --- /dev/null +++ b/sqitch/revert/build_servers_lookup_builds.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:build_servers_lookup_builds from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index ab6ce17..6e73371 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -57,3 +57,4 @@ drop_package_versions_by_guix_revision_range 2020-03-24T20:40:38Z Christopher Ba create_narinfo_fetch_records_index 2020-03-25T19:07:28Z Christopher Baines <mail@cbaines.net> # Create an index on narinfo_fetch_records load_new_guix_revision_jobs_make_commits_unique 2020-03-27T21:38:42Z Christopher Baines <mail@cbaines.net> # Make load_new_guix_revision_jobs commits unique remove_odd_package_derivations 2020-04-24T20:36:06Z Christopher Baines <mail@cbaines.net> # Remove odd package derivations +build_servers_lookup_builds 2020-05-24T15:18:09Z Christopher Baines <mail@cbaines.net> # Add build_servers.lookup_builds diff --git a/sqitch/verify/build_servers_lookup_builds.sql b/sqitch/verify/build_servers_lookup_builds.sql new file mode 100644 index 0000000..7db4be7 --- /dev/null +++ b/sqitch/verify/build_servers_lookup_builds.sql @@ -0,0 +1,7 @@ +-- Verify guix-data-service:build_servers_lookup_builds on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |