From b6754c8a4c1135a803fa72fbf4208d46c301b105 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sun, 24 May 2020 17:02:53 +0100 Subject: 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. --- sqitch/deploy/build_servers_lookup_builds.sql | 7 +++++++ sqitch/revert/build_servers_lookup_builds.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/verify/build_servers_lookup_builds.sql | 7 +++++++ 4 files changed, 22 insertions(+) create mode 100644 sqitch/deploy/build_servers_lookup_builds.sql create mode 100644 sqitch/revert/build_servers_lookup_builds.sql create mode 100644 sqitch/verify/build_servers_lookup_builds.sql (limited to 'sqitch') 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 # Create an index on narinfo_fetch_records load_new_guix_revision_jobs_make_commits_unique 2020-03-27T21:38:42Z Christopher Baines # Make load_new_guix_revision_jobs commits unique remove_odd_package_derivations 2020-04-24T20:36:06Z Christopher Baines # Remove odd package derivations +build_servers_lookup_builds 2020-05-24T15:18:09Z Christopher Baines # 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; -- cgit v1.2.3