#!/bin/bash
clear

export PGPASSWORD='Your_Flask_Password_Here'

echo "Dumping Full Python-Flask Database..."
pg_dump -U www-data --column-inserts flask | sudo tee ./Full_Rebuild/database.df > /dev/null
pg_dump -U www-data --schema-only    flask | sudo tee ./Full_Rebuild/database_schema.sql > /dev/null
pg_dump -U www-data -a               flask | sudo tee ./Full_Rebuild/database_data.sql > /dev/null

# read -p "Press ENTER to Continue..." x

echo "Dumping Volatile Python-Flask Data (Only)..."
pg_dump -U www-data --exclude-table=diagnosis_dsm5 --exclude-table=diagnosis_icd10 --exclude-table=diagnosis_dsm5_rec_id_seq --exclude-table=diagnosis_icd10_rec_id_seq --exclude-table=volatile_view --column-inserts flask > database.df
pg_dump -U www-data --exclude-table=diagnosis_dsm5 --exclude-table=diagnosis_icd10 --exclude-table=diagnosis_dsm5_rec_id_seq --exclude-table=diagnosis_icd10_rec_id_seq --exclude-table=volatile_view -s flask > database_schema.sql
pg_dump -U www-data --exclude-table=diagnosis_dsm5 --exclude-table=diagnosis_icd10 --exclude-table=diagnosis_dsm5_rec_id_seq --exclude-table=diagnosis_icd10_rec_id_seq --exclude-table=volatile_view -a flask > database_data.sql
unset PGPASSWORD
# read -p "Press ENTER to Continue..." x

echo "Creating Python-Flask Archives..."
sudo tar cvfzX /home/tag/Python/Python-Flask.tgz /opt/flask-app/Install/backup_exclude /opt/flask-app >/dev/null

date >> backup.log 
