diff options
| author | Bryan Newbold <bnewbold@archive.org> | 2021-11-03 18:33:07 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@archive.org> | 2021-11-03 18:33:07 -0700 |
| commit | 848556a64d13955c2978bad352f2e2cd9edb62d0 (patch) | |
| tree | 38542674c86521abc542058a79ea6a15287497bc /sql | |
| parent | 4109cd96a95e321c2e420e453da5f2779a5f873b (diff) | |
| download | sandcrawler-848556a64d13955c2978bad352f2e2cd9edb62d0.tar.gz sandcrawler-848556a64d13955c2978bad352f2e2cd9edb62d0.zip | |
SPN reingest: 6 hour minimum, 6 month max
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dump_reingest_spn.sql | 4 |
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-%' |