diff options
| author | Christopher Baines <mail@cbaines.net> | 2022-07-07 19:50:19 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2022-07-07 21:04:34 +0100 |
| commit | f5816f1011a102d91c28231bb9d437d44b6160c7 (patch) | |
| tree | ad7440e2e35cbae0c9a66b8780d77cc48578211d /sqitch | |
| parent | 9d498182f8fa7f8602af5b1dc6cc9e12b76ac88d (diff) | |
| download | build-coordinator-f5816f1011a102d91c28231bb9d437d44b6160c7.tar build-coordinator-f5816f1011a102d91c28231bb9d437d44b6160c7.tar.gz | |
Record the details of derivation outputs
I believe this will be useful when linking builds to other services, like the
Guix Data Service, since this information might be useful when joining up the
derivation being built to other derivations through the details of the outputs
produced.
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/pg/deploy/derivation_output_details.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/derivation_output_details.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/derivation_output_details.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/sqlite/deploy/derivation_output_details.sql | 12 | ||||
| -rw-r--r-- | sqitch/sqlite/revert/derivation_output_details.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/verify/derivation_output_details.sql | 7 |
7 files changed, 48 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/derivation_output_details.sql b/sqitch/pg/deploy/derivation_output_details.sql new file mode 100644 index 0000000..51ff376 --- /dev/null +++ b/sqitch/pg/deploy/derivation_output_details.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:derivation_output_details to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/derivation_output_details.sql b/sqitch/pg/revert/derivation_output_details.sql new file mode 100644 index 0000000..2052bce --- /dev/null +++ b/sqitch/pg/revert/derivation_output_details.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:derivation_output_details from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/derivation_output_details.sql b/sqitch/pg/verify/derivation_output_details.sql new file mode 100644 index 0000000..8a8c9c9 --- /dev/null +++ b/sqitch/pg/verify/derivation_output_details.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:derivation_output_details on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 333d7b2..8415341 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -38,3 +38,4 @@ create_unprocessed_builds_with_derived_priorities 2021-10-22T14:52:18Z Christoph add_agents_active 2021-11-12T14:00:52Z Christopher Baines <mail@cbaines.net> # Add agents.active output_metadata_index 2021-11-18T00:18:12Z Christopher Baines <mail@cbaines.net> # Add index on output_metadata recreate_unprocessed_builds_with_derived_priorities 2021-12-22T11:09:54Z Christopher Baines <mail@cbaines.net> # Recreate unprocessed_builds_with_derived_priorities +derivation_output_details 2022-07-07T18:12:27Z Chris <chris@felis> # Add derivation_output_details diff --git a/sqitch/sqlite/deploy/derivation_output_details.sql b/sqitch/sqlite/deploy/derivation_output_details.sql new file mode 100644 index 0000000..65d5423 --- /dev/null +++ b/sqitch/sqlite/deploy/derivation_output_details.sql @@ -0,0 +1,12 @@ +-- Deploy guix-build-coordinator:derivation_output_details to sqlite + +BEGIN; + +CREATE TABLE derivation_output_details ( + derivation_output_id INTEGER PRIMARY KEY ASC, + hash_algorithm TEXT, + hash TEXT, + recursive BOOLEAN NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/revert/derivation_output_details.sql b/sqitch/sqlite/revert/derivation_output_details.sql new file mode 100644 index 0000000..3718ce8 --- /dev/null +++ b/sqitch/sqlite/revert/derivation_output_details.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:derivation_output_details from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/derivation_output_details.sql b/sqitch/sqlite/verify/derivation_output_details.sql new file mode 100644 index 0000000..ca9cff8 --- /dev/null +++ b/sqitch/sqlite/verify/derivation_output_details.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:derivation_output_details on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |