#!/bin/bash
. ./.profile
cd /project/inbound_figc
rm -f *.csv
rm -f *.csv_int*

./getftp.sh
./loadpgare.sh csexc17f.csv ana
./loadpgare.sh cseri17f.csv imp
./loadpgare.sh cserc17f.csv cal
./loadpgare.sh csezc17f.csv cla
#./loadpgare.sh cseyc17f.csv

/usr/local/bin/kubectl cp cserc17f.csv_int_utf8_nobom.csv db/postgresql-1-postgresql-0:/etc/cserc17f_2load_utf8_nobom.csv
/usr/local/bin/kubectl cp cseri17f.csv_int_utf8_nobom.csv db/postgresql-1-postgresql-0:/etc/cseri17f_2load_utf8_nobom.csv
/usr/local/bin/kubectl cp csexc17f.csv_int_utf8_nobom.csv db/postgresql-1-postgresql-0:/etc/csexc17f_2load_utf8_nobom.csv
/usr/local/bin/kubectl cp csezc17f.csv_int_utf8_nobom.csv db/postgresql-1-postgresql-0:/etc/csezc17f_2load_utf8_nobom.csv
#k cp csezc17f.csv_int_utf8_nobom.csv db/postgresql-1-postgresql-0:/etc/csezc17f_2load_utf8_nobom.csv

name=$(date '+%Y-%m-%d')
tar -zcvf "$name.tar.gz" *.csv
mv *.gz ./arch

/usr/local/bin/kubectl cp pgareload.sql db/postgresql-1-postgresql-0:/etc/pgareload.sql
/usr/local/bin/kubectl exec -it postgresql-1-postgresql-0   -c postgresql-server -n db -- psql -U postgres  -d pgare -f /etc/pgareload.sql

/usr/local/bin/kubectl cp loadclub.sql db/postgresql-1-postgresql-0:/etc/loadclub.sql
/usr/local/bin/kubectl exec -it postgresql-1-postgresql-0   -c postgresql-server -n db -- psql -U postgres  -d segdigi -f /etc/loadclub.sql

sleep 120

/usr/local/bin/kubectl cp partite_ftp.sql db/postgresql-1-postgresql-0:/etc/partite_ftp.sql
/usr/local/bin/kubectl exec -it postgresql-1-postgresql-0   -c postgresql-server -n db -- psql -U postgres  -d gare -f /etc/partite_ftp.sql

/usr/local/bin/kubectl cp campionati_ftp.sql db/postgresql-1-postgresql-0:/etc/campionati_ftp.sql
kubectl exec -it postgresql-1-postgresql-0   -c postgresql-server -n db -- psql -U postgres  -d gare -f /etc/campionati_ftp.sql

/usr/local/bin/kubectl cp companies_ftp.sql db/postgresql-1-postgresql-0:/etc/companies_ftp.sql
/usr/local/bin/kubectl exec -it postgresql-1-postgresql-0   -c postgresql-server -n db -- psql -U postgres  -d companies -f /etc/companies_ftp.sql