import-cash-other-returns.sh

# Set up directories and variable values
# Set up directory locations
psql=/cygdrive/c/Program\ Files/PostgreSQL/9.5/bin/psql.exe
copycatsDirWin="D:/Cloud\ Storages/GitHub/copycats-analysis/"

# Set up usernames and passwords (not recommended to change)
username=copycat
dbname=copycats
password=default-password-for-copycats
database=copycats

# default username and databse (username was provided during installation
# process; database is the one that already exist)
postgresUser=postgres
postgresDb=postgres

zipDir="/cygdrive/c/Program Files/7-zip/"
export PATH=$PATH:"$zipDir"


# Call SQL
"$psql" -U $username -d $database -f  "./sql/import-cash.sql"
"$psql" -U $username -d $database -f  "./sql/import-global-index.sql"
"$psql" -U $username -d $database -f  "./sql/import-factors.sql"
"$psql" -U $username -d $database -f  "./sql/import-bonds.sql"