diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-04-23 18:27:38 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-04-23 19:30:55 +0100 |
| commit | d1020a834a09a76cd5c98fe81ebad2968b193872 (patch) | |
| tree | a6f623c9a8d012f50ecc0d06ccc733a951f2dfd0 /sqitch | |
| parent | 78287e9cc4a8c8f000ccb6e6e5641180274e0e8e (diff) | |
| download | build-coordinator-d1020a834a09a76cd5c98fe81ebad2968b193872.tar build-coordinator-d1020a834a09a76cd5c98fe81ebad2968b193872.tar.gz | |
Send over some metadata from the agent for each output
This will hopefully make it easier to create narinfo files for the outputs. I
think all of this information can be derived from the nar, but I'm not sure
how to do that, so maybe this can eventually be removed.
Diffstat (limited to 'sqitch')
| -rw-r--r-- | sqitch/pg/deploy/output_metadata.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/revert/output_metadata.sql | 7 | ||||
| -rw-r--r-- | sqitch/pg/verify/output_metadata.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqitch.plan | 1 | ||||
| -rw-r--r-- | sqitch/sqlite/deploy/output_metadata.sql | 13 | ||||
| -rw-r--r-- | sqitch/sqlite/revert/output_metadata.sql | 7 | ||||
| -rw-r--r-- | sqitch/sqlite/verify/output_metadata.sql | 7 |
7 files changed, 49 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/output_metadata.sql b/sqitch/pg/deploy/output_metadata.sql new file mode 100644 index 0000000..f730ca6 --- /dev/null +++ b/sqitch/pg/deploy/output_metadata.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:output_metadata to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/output_metadata.sql b/sqitch/pg/revert/output_metadata.sql new file mode 100644 index 0000000..dcff1c5 --- /dev/null +++ b/sqitch/pg/revert/output_metadata.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:output_metadata from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/output_metadata.sql b/sqitch/pg/verify/output_metadata.sql new file mode 100644 index 0000000..f6abae8 --- /dev/null +++ b/sqitch/pg/verify/output_metadata.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:output_metadata on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 487fdf4..1e4414f 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -8,3 +8,4 @@ initial_agent_tables 2020-04-09T20:03:53Z Christopher Baines <mail@cbaines.net> build_allocation_tables 2020-04-10T19:26:36Z Christopher Baines <mail@cbaines.net> # Create initial tables for allocating builds build_results 2020-04-12T19:59:27Z Christopher Baines <mail@cbaines.net> # Create table for storing build results setup_failures 2020-04-13T13:05:29Z Christopher Baines <mail@cbaines.net> # Create table for storing setup_failures +output_metadata 2020-04-23T14:26:15Z Christopher Baines <mail@cbaines.net> # Create table for storing output metadata diff --git a/sqitch/sqlite/deploy/output_metadata.sql b/sqitch/sqlite/deploy/output_metadata.sql new file mode 100644 index 0000000..a7c0124 --- /dev/null +++ b/sqitch/sqlite/deploy/output_metadata.sql @@ -0,0 +1,13 @@ +-- Deploy guix-build-coordinator:output_metadata to sqlite + +BEGIN; + +CREATE TABLE output_metadata ( + build_id TEXT NOT NULL REFERENCES builds (uuid), + derivation_output_id INTEGER NOT NULL REFERENCES derivation_outputs (id), + hash TEXT NOT NULL, + size INTEGER NOT NULL, + store_references TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/revert/output_metadata.sql b/sqitch/sqlite/revert/output_metadata.sql new file mode 100644 index 0000000..bee5fd1 --- /dev/null +++ b/sqitch/sqlite/revert/output_metadata.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:output_metadata from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/output_metadata.sql b/sqitch/sqlite/verify/output_metadata.sql new file mode 100644 index 0000000..e1669ec --- /dev/null +++ b/sqitch/sqlite/verify/output_metadata.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:output_metadata on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |