aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2021-11-03 18:33:07 -0700
committerBryan Newbold <bnewbold@archive.org>2021-11-03 18:33:07 -0700
commit848556a64d13955c2978bad352f2e2cd9edb62d0 (patch)
tree38542674c86521abc542058a79ea6a15287497bc
parent4109cd96a95e321c2e420e453da5f2779a5f873b (diff)
downloadsandcrawler-848556a64d13955c2978bad352f2e2cd9edb62d0.tar.gz
sandcrawler-848556a64d13955c2978bad352f2e2cd9edb62d0.zip
SPN reingest: 6 hour minimum, 6 month max
-rw-r--r--sql/dump_reingest_spn.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dump_reingest_spn.sql b/sql/dump_reingest_spn.sql
index a8ed72f..6ef08c1 100644
--- a/sql/dump_reingest_spn.sql
+++ b/sql/dump_reingest_spn.sql
@@ -4,8 +4,8 @@ COPY (
LEFT JOIN ingest_file_result ON ingest_file_result.base_url = ingest_request.base_url
WHERE ingest_request.ingest_type = 'pdf'
AND ingest_file_result.hit = false
- AND ingest_request.created < NOW() - '2 hour'::INTERVAL
- AND ingest_request.created > NOW() - '31 day'::INTERVAL
+ AND ingest_request.created < NOW() - '6 hour'::INTERVAL
+ AND ingest_request.created > NOW() - '180 day'::INTERVAL
AND ingest_request.ingest_request_source = 'savepapernow-web'
AND (
ingest_file_result.status like 'spn2-%'