From eabab2e2a44b715c914182544e57899323234f86 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
Date: Thu, 30 Jul 2020 18:16:52 -0700
Subject: WIP: sorted release ident dumps

---
 extra/sql_dumps/dump_idents.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'extra/sql_dumps/dump_idents.sql')

diff --git a/extra/sql_dumps/dump_idents.sql b/extra/sql_dumps/dump_idents.sql
index e8126347..d9777ea1 100644
--- a/extra/sql_dumps/dump_idents.sql
+++ b/extra/sql_dumps/dump_idents.sql
@@ -10,5 +10,21 @@ COPY (SELECT id, rev_id, redirect_id FROM webcapture_ident   WHERE is_live=true)
 COPY (SELECT id, rev_id, redirect_id FROM release_ident      WHERE is_live=true) TO '/tmp/fatcat_ident_releases.tsv'            WITH NULL '';
 COPY (SELECT id, rev_id, redirect_id FROM work_ident         WHERE is_live=true) TO '/tmp/fatcat_ident_works.tsv'               WITH NULL '';
 COPY (SELECT id, editgroup_id, timestamp FROM changelog)                         TO '/tmp/fatcat_ident_changelog.tsv'           WITH NULL '';
+COPY (
+  SELECT
+    release_ident.id,
+    release_ident.rev_id,
+    release_ident.redirect_id,
+    release_rev.work_ident_id
+  FROM
+    release_ident
+    LEFT JOIN release_rev ON release_ident.rev_id = release_rev.id
+  WHERE
+    release_ident.is_live=true
+    AND release_ident.redirect_id IS NULL
+    AND release_ident.rev_id IS NOT NULL
+  ORDER BY
+    release_rev.work_ident_id ASC NULLS LAST
+) TO '/tmp/fatcat_ident_releases_by_work.tsv'            WITH NULL '';
 
 ROLLBACK;
-- 
cgit v1.2.3

