#!/bin/bash


CONFFILE=/usr/share/nginx/spotipo/instance/config.py
USERNAME=$(grep "SQLALCHEMY" $CONFFILE | sed -r 's/SQLALCHEMY_DATABASE_URI="mysql:\/\/(.+):(.+)@.+\/(.+)"/\1/' )
PASSWORD=$(grep "SQLALCHEMY" $CONFFILE | sed -r 's/SQLALCHEMY_DATABASE_URI="mysql:\/\/(.+):(.+)@.+\/(.+)"/\2/' )
DBNAME=$(grep "SQLALCHEMY" $CONFFILE | sed -r 's/SQLALCHEMY_DATABASE_URI="mysql:\/\/(.+):(.+)@.+\/(.+)"/\3/' )
now=$(date +"%m%d%Y")

mysqldump -u$USERNAME -p$PASSWORD $DBNAME > spotipo_$now.sql


tar -czvf uploads_$now.tar.gz /usr/share/nginx/spotipo/unifispot/static/uploads/
tar -czvf instance_$now.tar.gz /usr/share/nginx/spotipo/instance/