diff options
| author | Christopher Baines <mail@cbaines.net> | 2021-04-08 20:34:11 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2021-04-08 20:34:11 +0100 |
| commit | 44d00065cfbd0f24d2fac631608a5aeaace648a7 (patch) | |
| tree | e4e95a3705e1d2b0a5cecb400aa4b7d3b9025fb7 | |
| parent | d7674caa4f7c5e8faa8db347a49b7fd1bb264e9f (diff) | |
| download | build-coordinator-44d00065cfbd0f24d2fac631608a5aeaace648a7.tar build-coordinator-44d00065cfbd0f24d2fac631608a5aeaace648a7.tar.gz | |
Fix the foreign key constraint on setup_failure_missing_inputs
It was broken in a previous migration.
7 files changed, 50 insertions, 0 deletions
diff --git a/sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql b/sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..47b89bb --- /dev/null +++ b/sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:fix_setup_failure_missing_inputs to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/fix_setup_failure_missing_inputs.sql b/sqitch/pg/revert/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..d5f7003 --- /dev/null +++ b/sqitch/pg/revert/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:fix_setup_failure_missing_inputs from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/fix_setup_failure_missing_inputs.sql b/sqitch/pg/verify/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..3f5263a --- /dev/null +++ b/sqitch/pg/verify/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:fix_setup_failure_missing_inputs on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index af81ea8..f9e28fd 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -31,3 +31,4 @@ add_dynamic_auth_tokens 2021-02-28T15:21:24Z Christopher Baines <mail@cbaines.ne use_numeric_primary_keys 2021-03-28T09:55:40Z Christopher Baines <mail@cbaines.net> # Use numeric primary keys fix_allocated_builds 2021-03-30T08:19:18Z Christopher Baines <mail@cbaines.net> # Fix allocated_builds fix_allocated_builds_attempt_2 2021-03-30T08:27:18Z Christopher Baines <mail@cbaines.net> # Fix allocated_builds +fix_setup_failure_missing_inputs 2021-04-08T19:31:49Z Christopher Baines <mail@cbaines.net> # Fix setup_failure_missing_inputs diff --git a/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql b/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..4997bde --- /dev/null +++ b/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,14 @@ +-- Deploy guix-build-coordinator:fix_setup_failure_missing_inputs to sqlite + +BEGIN; + +DELETE FROM setup_failures WHERE failure_reason = 'setup_failure'; + +DROP TABLE setup_failure_missing_inputs; + +CREATE TABLE setup_failure_missing_inputs ( + setup_failure_id INTEGER NOT NULL REFERENCES setup_failures (id), + missing_input_store_path TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql b/sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..7470b2e --- /dev/null +++ b/sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:fix_setup_failure_missing_inputs from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql b/sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..b05aeea --- /dev/null +++ b/sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:fix_setup_failure_missing_inputs on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |