aboutsummaryrefslogtreecommitdiffstats
path: root/sql/reingest_old.sh
blob: 96e5416bdf4f1f242b7dde6540f8ad44f908b73e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
#!/bin/bash

set -e              # fail on error
set -u              # fail if variable not set in substitution
set -o pipefail     # fail if part of a '|' command fails

sudo -u postgres psql sandcrawler < dump_reingest_old.sql

cd ../python
sudo -u sandcrawler pipenv run \
    ./scripts/ingestrequest_row2json.py /srv/sandcrawler/tasks/reingest_old_current.rows.json \
    > /srv/sandcrawler/tasks/reingest_old_current.json

cat /srv/sandcrawler/tasks/reingest_old_current.json \
    | shuf \
    | head -n1000000 \
    | jq . -c \
    | kafkacat -P -b wbgrp-svc350.us.archive.org -t sandcrawler-prod.ingest-file-requests-daily -p -1