aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sqitch/deploy/remove_odd_package_derivations.sql23
-rw-r--r--sqitch/revert/remove_odd_package_derivations.sql7
-rw-r--r--sqitch/sqitch.plan1
-rw-r--r--sqitch/verify/remove_odd_package_derivations.sql7
4 files changed, 38 insertions, 0 deletions
diff --git a/sqitch/deploy/remove_odd_package_derivations.sql b/sqitch/deploy/remove_odd_package_derivations.sql
new file mode 100644
index 0000000..6cee32f
--- /dev/null
+++ b/sqitch/deploy/remove_odd_package_derivations.sql
@@ -0,0 +1,23 @@
+-- Deploy guix-data-service:remove_odd_package_derivations to pg
+
+BEGIN;
+
+DELETE FROM guix_revision_package_derivations
+WHERE package_derivation_id IN (
+ SELECT package_derivations.id
+ FROM package_derivations
+ INNER JOIN derivations
+ ON package_derivations.derivation_id = derivations.id
+ WHERE package_derivations.system != derivations.system
+);
+
+DELETE FROM package_derivations
+WHERE id IN (
+ SELECT package_derivations.id
+ FROM package_derivations
+ INNER JOIN derivations
+ ON package_derivations.derivation_id = derivations.id
+ WHERE package_derivations.system != derivations.system
+);
+
+COMMIT;
diff --git a/sqitch/revert/remove_odd_package_derivations.sql b/sqitch/revert/remove_odd_package_derivations.sql
new file mode 100644
index 0000000..f854233
--- /dev/null
+++ b/sqitch/revert/remove_odd_package_derivations.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:remove_odd_package_derivations from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan
index a92062c..ab6ce17 100644
--- a/sqitch/sqitch.plan
+++ b/sqitch/sqitch.plan
@@ -56,3 +56,4 @@ guix_revision_system_test_derivations_add_system 2020-03-19T21:30:33Z Christophe
drop_package_versions_by_guix_revision_range 2020-03-24T20:40:38Z Christopher Baines <mail@cbaines.net> # Drop package_versions_by_guix_revision_range
create_narinfo_fetch_records_index 2020-03-25T19:07:28Z Christopher Baines <mail@cbaines.net> # Create an index on narinfo_fetch_records
load_new_guix_revision_jobs_make_commits_unique 2020-03-27T21:38:42Z Christopher Baines <mail@cbaines.net> # Make load_new_guix_revision_jobs commits unique
+remove_odd_package_derivations 2020-04-24T20:36:06Z Christopher Baines <mail@cbaines.net> # Remove odd package derivations
diff --git a/sqitch/verify/remove_odd_package_derivations.sql b/sqitch/verify/remove_odd_package_derivations.sql
new file mode 100644
index 0000000..d0b0d4b
--- /dev/null
+++ b/sqitch/verify/remove_odd_package_derivations.sql
@@ -0,0 +1,7 @@
+-- Verify guix-data-service:remove_odd_package_derivations on pg
+
+BEGIN;
+
+-- XXX Add verifications here.
+
+ROLLBACK;