From 984c0d8c80f72ffbb183ed39ce256b70d464682b Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sun, 17 Jan 2021 16:01:30 +0000 Subject: Add tags for agents This will allow doing things like restricting builds by matching up there tags to the tags of the agents. --- sqitch/pg/deploy/add_agent_tags.sql | 7 +++++++ sqitch/pg/revert/add_agent_tags.sql | 7 +++++++ sqitch/pg/verify/add_agent_tags.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/sqlite/deploy/add_agent_tags.sql | 11 +++++++++++ sqitch/sqlite/revert/add_agent_tags.sql | 7 +++++++ sqitch/sqlite/verify/add_agent_tags.sql | 7 +++++++ 7 files changed, 47 insertions(+) create mode 100644 sqitch/pg/deploy/add_agent_tags.sql create mode 100644 sqitch/pg/revert/add_agent_tags.sql create mode 100644 sqitch/pg/verify/add_agent_tags.sql create mode 100644 sqitch/sqlite/deploy/add_agent_tags.sql create mode 100644 sqitch/sqlite/revert/add_agent_tags.sql create mode 100644 sqitch/sqlite/verify/add_agent_tags.sql (limited to 'sqitch') diff --git a/sqitch/pg/deploy/add_agent_tags.sql b/sqitch/pg/deploy/add_agent_tags.sql new file mode 100644 index 0000000..ad061a3 --- /dev/null +++ b/sqitch/pg/deploy/add_agent_tags.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:add_agent_tags to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/add_agent_tags.sql b/sqitch/pg/revert/add_agent_tags.sql new file mode 100644 index 0000000..1d6e34c --- /dev/null +++ b/sqitch/pg/revert/add_agent_tags.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:add_agent_tags from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/add_agent_tags.sql b/sqitch/pg/verify/add_agent_tags.sql new file mode 100644 index 0000000..b374187 --- /dev/null +++ b/sqitch/pg/verify/add_agent_tags.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:add_agent_tags on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 2240cc1..513609c 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -25,3 +25,4 @@ add_unbuilt_outputs_table 2020-11-06T18:58:08Z Christopher Baines # Add builds.canceled add_build_tags_build_id_idx 2020-12-21T13:20:54Z Christopher Baines # Add an index on build_tags.build_id add_builds_deferred_until 2020-12-26T19:26:32Z Christopher Baines # Add builds.deferred_until +add_agent_tags 2021-01-17T11:13:23Z Christopher Baines # Add tags for agents diff --git a/sqitch/sqlite/deploy/add_agent_tags.sql b/sqitch/sqlite/deploy/add_agent_tags.sql new file mode 100644 index 0000000..d1efbe1 --- /dev/null +++ b/sqitch/sqlite/deploy/add_agent_tags.sql @@ -0,0 +1,11 @@ +-- Deploy guix-build-coordinator:add_agent_tags to sqlite + +BEGIN; + +CREATE TABLE agent_tags ( + agent_id TEXT NOT NULL REFERENCES agents (id), + tag_id INTEGER NOT NULL REFERENCES tags (id), + PRIMARY KEY (agent_id, tag_id) +); + +COMMIT; diff --git a/sqitch/sqlite/revert/add_agent_tags.sql b/sqitch/sqlite/revert/add_agent_tags.sql new file mode 100644 index 0000000..f9891f6 --- /dev/null +++ b/sqitch/sqlite/revert/add_agent_tags.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:add_agent_tags from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/add_agent_tags.sql b/sqitch/sqlite/verify/add_agent_tags.sql new file mode 100644 index 0000000..27bd13a --- /dev/null +++ b/sqitch/sqlite/verify/add_agent_tags.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:add_agent_tags on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; -- cgit v1.2.3