aboutsummaryrefslogtreecommitdiff
path: root/sqitch
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2021-04-08 20:34:11 +0100
committerChristopher Baines <mail@cbaines.net>2021-04-08 20:34:11 +0100
commit44d00065cfbd0f24d2fac631608a5aeaace648a7 (patch)
treee4e95a3705e1d2b0a5cecb400aa4b7d3b9025fb7 /sqitch
parentd7674caa4f7c5e8faa8db347a49b7fd1bb264e9f (diff)
downloadbuild-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.
Diffstat (limited to 'sqitch')
-rw-r--r--sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql7
-rw-r--r--sqitch/pg/revert/fix_setup_failure_missing_inputs.sql7
-rw-r--r--sqitch/pg/verify/fix_setup_failure_missing_inputs.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql14
-rw-r--r--sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql7
-rw-r--r--sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql7
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;