From 54e14814080d9a706ff6f15694b3b54918200169 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@archive.org>
Date: Mon, 3 Oct 2022 10:16:26 -0700
Subject: reingests: update scripts and SQL

---
 sql/dump_reingest_spn.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'sql/dump_reingest_spn.sql')

diff --git a/sql/dump_reingest_spn.sql b/sql/dump_reingest_spn.sql
index 65a8796..a83125c 100644
--- a/sql/dump_reingest_spn.sql
+++ b/sql/dump_reingest_spn.sql
@@ -8,7 +8,9 @@ COPY (
         AND ingest_file_result.ingest_type = ingest_request.ingest_type
     WHERE
         (ingest_request.ingest_type = 'pdf'
-            OR ingest_request.ingest_type = 'html')
+            OR ingest_request.ingest_type = 'html'
+            OR ingest_request.ingest_type = 'xml'
+            OR ingest_request.ingest_type = 'component')
         AND ingest_file_result.hit = false
         AND ingest_request.created < NOW() - '6 hour'::INTERVAL
         AND ingest_request.created > NOW() - '180 day'::INTERVAL
-- 
cgit v1.2.3

