# This mini-script deletes all your alerts, requests, alerts, albums, plans, shs and schedules 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%?}

REQUEST="delete from plan ; delete from album ; delete from sequence ; delete from alert ; delete from request ; delete from schedule_has_sequences ; delete from schedule ; delete from log"

if [ "$MYSQL" == "True" ]; then

    mysql -u root -e "$REQUEST" pyros

else

    sqlite3 db.sqlite3 "$REQUEST"

fi