tools/anonym/cron.sendAnonXml.sh

#!/bin/sh
DBHOST=localhost
DBPORT=5432
EXPORTHOST=85.22.68.219
EXPORTUSER=anonupload
SSHKEY=/home/waskaservice/keys/auswertung
DATADIR=/home/waskaservice
UPLOADDIR=incoming

# Get a list of all db
DBLIST=`sudo -u postgres /usr/local/bin/getDbList.sh`
# For each db export cases as anonymized xml
DATE=`date +"%Y-%m-%d"`
for DB in ${DBLIST}
do
    EXPORTFILE=${DATADIR}/${DB}_${DATE}.xml
    sudo -u postgres /usr/local/bin/xmlexport.py ${DB} "${DBHOST}" "${DBPORT}" > $EXPORTFILE
    if [ "$?" -eq "0" ]; then
            gzip -f -9 ${EXPORTFILE}
            chmod 660 ${EXPORTFILE}.gz
            scp -qp -i ${SSHKEY} \
                -o "StrictHostKeyChecking=no" \
                -o "UserKnownHostsFile=/dev/null" \
                ${EXPORTFILE}.gz ${EXPORTUSER}@${EXPORTHOST}:${UPLOADDIR}
    fi
    rm -f ${EXPORTFILE} ${EXPORTFILE}.gz
done
1	#!/bin/sh
2	DBHOST=localhost
3	DBPORT=5432
4	EXPORTHOST=85.22.68.219
5	EXPORTUSER=anonupload
6	SSHKEY=/home/waskaservice/keys/auswertung
7	DATADIR=/home/waskaservice
8	UPLOADDIR=incoming
9
10	# Get a list of all db
11	DBLIST=`sudo -u postgres /usr/local/bin/getDbList.sh`
12	# For each db export cases as anonymized xml
13	DATE=`date +"%Y-%m-%d"`
14	for DB in ${DBLIST}
15	do
16	EXPORTFILE=${DATADIR}/${DB}_${DATE}.xml
17	sudo -u postgres /usr/local/bin/xmlexport.py ${DB} "${DBHOST}" "${DBPORT}" > $EXPORTFILE
18	if [ "$?" -eq "0" ]; then
19	gzip -f -9 ${EXPORTFILE}
20	chmod 660 ${EXPORTFILE}.gz
21	scp -qp -i ${SSHKEY} \
22	-o "StrictHostKeyChecking=no" \
23	-o "UserKnownHostsFile=/dev/null" \
24	${EXPORTFILE}.gz ${EXPORTUSER}@${EXPORTHOST}:${UPLOADDIR}
25	fi
26	rm -f ${EXPORTFILE} ${EXPORTFILE}.gz
27	done