#!/bin/sh
#Use ./runETL times DWDatabase DWUsername DWPassword RDFModel
for((i=1;i<=$1;i++))
do
clear
echo "Running the ETL for the $i th time."
python dw20load.py -d $2 -u $3 -p $4 -r eiaordf$i -m $5
done
echo "Finished running the ETL"
#Next lines are commented out because they are easy to run manually.
#echo "Filling the DW"
#psql -f FillEIAODW_R10.sql $2 $3
#echo "Finished filling the DW"
#echo "Creating the materialised views"
#psql -f FillMaterializedViews.sql $2 $3
#echo "Finished running the materialised views"