From 10bad53ad57e92dbc3c6207c251f0af1148e8ffc Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Mon, 9 Oct 2023 21:29:58 +0100 Subject: Support polling git repositories for new branches/revisions This is mostly a workaround for the occasional problems with the guix-commits mailing list, as it can break and then the data service doesn't learn about new revisions until the problem is fixed. I think it's still a generally good feature though, and allows deploying the data service without it consuming emails to learn about new revisions, and is a step towards integrating some kind of way of notifying the data service to poll. --- sqitch/deploy/git_repositories_poll_interval.sql | 8 ++++++++ sqitch/revert/git_repositories_poll_interval.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/verify/git_repositories_poll_interval.sql | 7 +++++++ 4 files changed, 23 insertions(+) create mode 100644 sqitch/deploy/git_repositories_poll_interval.sql create mode 100644 sqitch/revert/git_repositories_poll_interval.sql create mode 100644 sqitch/verify/git_repositories_poll_interval.sql (limited to 'sqitch') diff --git a/sqitch/deploy/git_repositories_poll_interval.sql b/sqitch/deploy/git_repositories_poll_interval.sql new file mode 100644 index 0000000..a75cac6 --- /dev/null +++ b/sqitch/deploy/git_repositories_poll_interval.sql @@ -0,0 +1,8 @@ +-- Deploy guix-data-service:git_repositories_poll_interval to pg + +BEGIN; + +ALTER TABLE git_repositories + ADD COLUMN poll_interval INTEGER DEFAULT NULL; + +COMMIT; diff --git a/sqitch/revert/git_repositories_poll_interval.sql b/sqitch/revert/git_repositories_poll_interval.sql new file mode 100644 index 0000000..fcb875d --- /dev/null +++ b/sqitch/revert/git_repositories_poll_interval.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:git_repositories_poll_interval from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index a3f8952..a4f14e8 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -96,3 +96,4 @@ blocked_builds_blocked_builds_blocked_derivation_output_details_set_id_2 2023-03 guix_revision_package_derivation_distribution_counts 2023-03-08T16:53:44Z Chris # Add guix_revision_package_derivation_distribution_counts table cascade_nar_foreign_keys 2023-08-01T09:42:33Z Chris # Make it easier to delete nars entries nar_indexes 2023-08-01T11:37:35Z Chris # Add nar related indexes +git_repositories_poll_interval 2023-10-08T20:36:09Z Chris # Add git_repositories.poll_interval diff --git a/sqitch/verify/git_repositories_poll_interval.sql b/sqitch/verify/git_repositories_poll_interval.sql new file mode 100644 index 0000000..a2efd06 --- /dev/null +++ b/sqitch/verify/git_repositories_poll_interval.sql @@ -0,0 +1,7 @@ +-- Verify guix-data-service:git_repositories_poll_interval on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; -- cgit v1.2.3