diff options
author | Christopher Baines <mail@cbaines.net> | 2020-05-31 18:24:18 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-05-31 18:24:18 +0100 |
commit | 2ac09243135c85d54e2ae2740d5c1aabe5c1ef06 (patch) | |
tree | d8a5b9cccbf9f739e454ad146e2dfd538e38c915 /sqitch | |
parent | 4ff7ee1dc340cbb8cd1c49fc98619dd72650c5fe (diff) | |
download | build-coordinator-2ac09243135c85d54e2ae2740d5c1aabe5c1ef06.tar build-coordinator-2ac09243135c85d54e2ae2740d5c1aabe5c1ef06.tar.gz |
Support adding tags to builds
Diffstat (limited to 'sqitch')
-rw-r--r-- | sqitch/pg/deploy/build_tags.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/revert/build_tags.sql | 7 | ||||
-rw-r--r-- | sqitch/pg/verify/build_tags.sql | 7 | ||||
-rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
-rw-r--r-- | sqitch/sqlite/deploy/build_tags.sql | 16 | ||||
-rw-r--r-- | sqitch/sqlite/revert/build_tags.sql | 7 | ||||
-rw-r--r-- | sqitch/sqlite/verify/build_tags.sql | 7 |
7 files changed, 52 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/build_tags.sql b/sqitch/pg/deploy/build_tags.sql new file mode 100644 index 0000000..211b7c5 --- /dev/null +++ b/sqitch/pg/deploy/build_tags.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:build_tags to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/build_tags.sql b/sqitch/pg/revert/build_tags.sql new file mode 100644 index 0000000..938221f --- /dev/null +++ b/sqitch/pg/revert/build_tags.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_tags from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/build_tags.sql b/sqitch/pg/verify/build_tags.sql new file mode 100644 index 0000000..d314341 --- /dev/null +++ b/sqitch/pg/verify/build_tags.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_tags on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 0946279..1aa3b80 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -15,3 +15,4 @@ unprocessed_hook_events 2020-05-08T12:55:28Z Christopher Baines <mail@cbaines.ne derivation_outputs_derivation_name_index 2020-05-10T16:24:05Z Christopher Baines <mail@cbaines.net> # Add an index on derivation_outputs.derivation_name build_results_result_index 2020-05-10T17:27:00Z Christopher Baines <mail@cbaines.net> # Add an index on build_results.result more_indexes_on_builds_and_derivation_inputs 2020-05-11T08:38:28Z Christopher Baines <mail@cbaines.net> # Add a couple more indexes +build_tags 2020-05-31T13:54:41Z Christopher Baines <mail@cbaines.net> # Support tagging builds diff --git a/sqitch/sqlite/deploy/build_tags.sql b/sqitch/sqlite/deploy/build_tags.sql new file mode 100644 index 0000000..7f2c040 --- /dev/null +++ b/sqitch/sqlite/deploy/build_tags.sql @@ -0,0 +1,16 @@ +-- Deploy guix-build-coordinator:build_tags to sqlite + +BEGIN; + +CREATE TABLE tags ( + id INTEGER PRIMARY KEY ASC, + key TEXT NOT NULL, + value TEXT NOT NULL +); + +CREATE TABLE build_tags ( + build_id TEXT NOT NULL REFERENCES builds (uuid), + tag_id INTEGER NOT NULL REFERENCES tags (id) +); + +COMMIT; diff --git a/sqitch/sqlite/revert/build_tags.sql b/sqitch/sqlite/revert/build_tags.sql new file mode 100644 index 0000000..f6bcef8 --- /dev/null +++ b/sqitch/sqlite/revert/build_tags.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:build_tags from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/build_tags.sql b/sqitch/sqlite/verify/build_tags.sql new file mode 100644 index 0000000..5cd681b --- /dev/null +++ b/sqitch/sqlite/verify/build_tags.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:build_tags on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |