/
RADAR Scheduled Exports

RADAR Scheduled Exports

Owned by George Swinnerton
Last updated: Jun 18, 2020 by Tim Whitlock (Deactivated)Version comment

These use the RADAR Exporter (as used by the Nurture Dashboard exporter)


#SQL Queries
#All Consents
00 01 * * fri PGPASSWORD=d8MsHG3IjCoUNxIy /usr/bin/psql -h db.radar.nhs.uk -p 5432 -U radar radar </root/radar-sql/consents.sql > "/var/radar-exports/"`/usr/bin/date +"\%Y-\%m-\%d"`"-all-consents.csv"
14 01 * * fri rm -f /var/radar-exports/*-all-consents.zip
15 01 * * fri /usr/bin/zip "/var/radar-exports/"`/usr/bin/date +"\%Y-\%m-\%d"`"-all-consents.zip" -FIjq "/var/radar-exports/"`/usr/bin/date +"\%Y-\%m-\%d"`"-all-consents.csv"
16 01 * * fri rm -f "/var/radar-exports/"`/usr/bin/date +"\%Y-\%m-\%d"`"-all-consents.csv"
#nurture
03 01 * * fri rm -f /var/radar-exports/*nurture*.zip
06 02 * * fri export RADAR_SETTINGS=/etc/radar-api/settings.py; /srv/radar/current/bin/radar-exporter /root/radar-exports/rdr-486_ckd.ini /var/radar-exports/
26 02 * * fri export RADAR_SETTINGS=/etc/radar-api/settings.py; /srv/radar/current/bin/radar-exporter /root/radar-exports/rdr-486_ins.ini /var/radar-exports/

17 02 * * fri export RADAR_SETTINGS=/etc/radar-api/settings.py; /srv/radar/current/bin/radar-exporter /root/radar-exports/nurtureckd.anon.ini /var/radar-exports/
37 02 * * fri export RADAR_SETTINGS=/etc/radar-api/settings.py; /srv/radar/current/bin/radar-exporter /root/radar-exports/nurtureins.anon.ini /var/radar-exports/

#Comments
#Nurture INS
#Nurtue CKD
18 01 * * fri /root/radar_scripts/create_comments.sh

# ins export
44 02 * * fri export RADAR_SETTINGS=/etc/radar-api/settings.py; rm -f /var/radar-exports/*-ins.zip; /srv/radar/current/bin/radar-exporter /root/radar-exports/ins.ini /var/radar-exports/

#ahus export
30 02 1 * * rm -f /var/radar-exports/*ahus*
33 02 1 * * export RADAR_SETTINGS=/etc/radar-api/settings.py; /srv/radar/current/bin/radar-exporter /root/radar-exports/rdr-448.ini /var/radar-exports/

# rituximab
50 02 * * fri rm -f /var/radar-exports/*export-ritimn*.zip
54 02 * * fri export RADAR_SETTINGS=/etc/radar-api/settings.py; /srv/radar/current/bin/radar-exporter /root/radar-exports/rituximab.ini /var/radar-exports/

# adpkd
13 03 * * fri export RADAR_SETTINGS=/etc/radar-api/settings.py; rm -f /var/radar-exports/*-adpkd.zip; /srv/radar/current/bin/radar-exporter /root/radar-exports/adpkd.ini /var/radar-exports/




Related content