From f5816f1011a102d91c28231bb9d437d44b6160c7 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Thu, 7 Jul 2022 19:50:19 +0100 Subject: 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. --- sqitch/pg/deploy/derivation_output_details.sql | 7 +++++++ sqitch/pg/revert/derivation_output_details.sql | 7 +++++++ sqitch/pg/verify/derivation_output_details.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/sqlite/deploy/derivation_output_details.sql | 12 ++++++++++++ sqitch/sqlite/revert/derivation_output_details.sql | 7 +++++++ sqitch/sqlite/verify/derivation_output_details.sql | 7 +++++++ 7 files changed, 48 insertions(+) create mode 100644 sqitch/pg/deploy/derivation_output_details.sql create mode 100644 sqitch/pg/revert/derivation_output_details.sql create mode 100644 sqitch/pg/verify/derivation_output_details.sql create mode 100644 sqitch/sqlite/deploy/derivation_output_details.sql create mode 100644 sqitch/sqlite/revert/derivation_output_details.sql create mode 100644 sqitch/sqlite/verify/derivation_output_details.sql (limited to 'sqitch') 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 # Add agents.active output_metadata_index 2021-11-18T00:18:12Z Christopher Baines # Add index on output_metadata recreate_unprocessed_builds_with_derived_priorities 2021-12-22T11:09:54Z Christopher Baines # Recreate unprocessed_builds_with_derived_priorities +derivation_output_details 2022-07-07T18:12:27Z Chris # 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; -- cgit v1.2.3