forked from openstate/amsterdam-subsidies
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathupdate.sh.example
More file actions
executable file
·32 lines (25 loc) · 1.02 KB
/
update.sh.example
File metadata and controls
executable file
·32 lines (25 loc) · 1.02 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
#!/bin/sh
cd /opt/ro
rm -f message.txt
touch message.txt
GITHUB_PERSONAL_TOKEN=<YOUR_TOKEN>
git pull https://${GITHUB_PERSONAL_TOKEN}@github.com/openstate/ro-pp-subsidies.git master
ODS_LINK=`./get-link.py`
wget -q -O tmp-subsidies.ods "$ODS_LINK"
libreoffice --convert-to csv tmp-subsidies.ods
#csvformat -d ';' -D ',' -e iso-8859-1 tmp-subsidies.csv >tmp-subsidies2.csv
#csvcut -c 1-12 tmp-subsidies2.csv >tmp-subsidies3.csv
sed '1s/^\xEF\xBB\xBF//;${/^$/d;}' tmp-subsidies.csv >"subsidies.csv"
#csv-diff subsidies-old.csv subsidies.csv --key=DOSSIERNUMMER >>message.txt
SUBS_DIFF=$(diff subsidies.csv subsidies-old.csv)
if [ "$SUBS_DIFF" != "" ]
then
echo "Subsidies bijgewerkt." >message.txt
fi
cp -f subsidies.csv subsidies-old.csv
git add subsidies.csv
git config --global user.email "developers@openstate.eu"
git config --global user.name "Open State developers"
git commit -F message.txt && \
git push -q https://${GITHUB_PERSONAL_TOKEN}@github.com/openstate/ro-pp-subsidies.git master \
|| true