#!/bin/bash

if test -f "ruc0.txt"; then
rm ruc0.txt
rm ruc0.zip
rm ruc0.sql
fi

if test -f "ruc1.txt"; then
rm ruc1.txt
rm ruc1.zip
rm ruc1.sql
fi

if test -f "ruc2.txt"; then
rm ruc2.txt
rm ruc2.zip
rm ruc2.sql
fi

if test -f "ruc3.txt"; then
rm ruc3.txt
rm ruc3.zip
rm ruc3.sql
fi

if test -f "ruc4.txt"; then
rm ruc4.txt
rm ruc4.zip
rm ruc4.sql
fi

if test -f "ruc5.txt"; then
rm ruc5.txt
rm ruc5.zip
rm ruc5.sql
fi

if test -f "ruc6.txt"; then
rm ruc6.txt
rm ruc6.zip
rm ruc6.sql
fi

if test -f "ruc7.txt"; then
rm ruc7.txt
rm ruc7.zip
rm ruc7.sql
fi

if test -f "ruc8.txt"; then
rm ruc8.txt
rm ruc8.zip
rm ruc8.sql
fi

if test -f "ruc9.txt"; then
rm ruc9.txt
rm ruc9.zip
rm ruc9.sql
fi

echo "Iniciando proceso..."
echo "Descargando archivos..."

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc0.zip
unzip ruc0.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc1.zip
unzip ruc1.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc2.zip
unzip ruc2.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc3.zip
unzip ruc3.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc4.zip
unzip ruc4.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc5.zip
unzip ruc5.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc6.zip
unzip ruc6.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc7.zip
unzip ruc7.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc8.zip
unzip ruc8.zip

wget http://www.set.gov.py/rest/contents/download/collaboration/sites/PARAGUAY-SET/documents/informes-periodicos/ruc/ruc9.zip
unzip ruc9.zip


echo "Limpiando tabla RUC"
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal -e "truncate table ruc"

echo "Iniciando proceso, generando archivos SQL"
awk -f txtTOcvs.awk ruc0.txt >> ruc0.sql 
awk -f txtTOcvs.awk ruc1.txt >> ruc1.sql 
awk -f txtTOcvs.awk ruc2.txt >> ruc2.sql 
awk -f txtTOcvs.awk ruc3.txt >> ruc3.sql 
awk -f txtTOcvs.awk ruc4.txt >> ruc4.sql 
awk -f txtTOcvs.awk ruc5.txt >> ruc5.sql 
awk -f txtTOcvs.awk ruc6.txt >> ruc6.sql 
awk -f txtTOcvs.awk ruc7.txt >> ruc7.sql 
awk -f txtTOcvs.awk ruc8.txt >> ruc8.sql 
awk -f txtTOcvs.awk ruc9.txt >> ruc9.sql 

echo "Importando a archivos SQL a la tabla RUC"
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc0.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc1.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc2.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc3.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc4.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc5.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc6.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc7.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc8.sql
mysql --user=paraguay_root --password=dejameentrarplis123 paraguay_portal < ruc9.sql