diff options
author | Christopher Baines <mail@cbaines.net> | 2021-01-17 16:01:30 +0000 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2021-01-17 16:01:30 +0000 |
commit | 984c0d8c80f72ffbb183ed39ce256b70d464682b (patch) | |
tree | f4e422802f27025239eae9c7fa4815e90086a87c /sqitch/sqlite | |
parent | 87e4827be7c1370915930fb75850fdf89b30fb7b (diff) | |
download | build-coordinator-984c0d8c80f72ffbb183ed39ce256b70d464682b.tar build-coordinator-984c0d8c80f72ffbb183ed39ce256b70d464682b.tar.gz |
Add tags for agents
This will allow doing things like restricting builds by matching up there tags
to the tags of the agents.
Diffstat (limited to 'sqitch/sqlite')
-rw-r--r-- | sqitch/sqlite/deploy/add_agent_tags.sql | 11 | ||||
-rw-r--r-- | sqitch/sqlite/revert/add_agent_tags.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/add_agent_tags.sql | 7 |
3 files changed, 25 insertions, 0 deletions
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; |