# This mini-script deletes all your requests, alerts, albums and plans in db
# You need to have a root user with no password on your DB

SCRIPT_PATH=$0
SCRIPT_PATH=${SCRIPT_PATH%/*}

cd $SCRIPT_PATH/..

MYSQL=`grep "MYSQL = " pyros/settings.py`
MYSQL=${MYSQL##* }
MYSQL=${MYSQL%?}

if [ "$MYSQL" == "True" ]; then
    mysql -u root -e "delete from plan ; delete from album ; delete from sequence ; delete from alert ; delete from request" pyros
else
    sqlite3 db.sqlite3 "delete from plan ; delete from album ; delete from sequence ; delete from alert ; delete from request"
fi