dbclean.sh

# !/bin/sh

#This cleans all the tables used by all cb and nightly builds (super sledge)

SETUP=FALSE
ARG1=$1

if [ "$ARG1" = "setup" ]
then 
    SETUP=true
fi

unset initSchema
initSchema() {
    echo "Removing db schema for ${DB_NAME}..."
    echo "DROP DATABASE IF EXISTS ${DB_NAME};" > sql.sql
    echo "Creating db schema for ${DB_NAME}..."
    echo "CREATE DATABASE IF NOT EXISTS ${DB_NAME};" >> sql.sql
    echo "Creating user rights for user ${DB_USER} on db ${DB_NAME}..."
    echo "GRANT ALL PRIVILEGES ON ${DB_NAME}.* to '${DB_USER}'@'localhost' IDENTIFIED BY '${DB_PWD}' WITH GRANT OPTION;" >> sql.sql
    echo "GRANT ALL PRIVILEGES ON ${DB_NAME}.* to '${DB_USER}'@'%' IDENTIFIED BY '${DB_PWD}' WITH GRANT OPTION;" >> sql.sql
    mysql -uroot -p < sql.sql
    rm sql.sql
    echo "init  complete."
}

unset cleanSchema
cleanSchema() {
    echo "Cleaning the db schema for ${DB_NAME}..."
    echo "drop schema ${DB_NAME};" > sql.sql
    echo "create schema ${DB_NAME};" >> sql.sql
    mysql -u${DB_USER} -p${DB_PWD} < sql.sql
    rm sql.sql
    echo "done."
}

loginfound=false
processed=""
for dbLoginFile in `ls | grep db-` ; do
    loginfound=true
    DB_USER=`cat $dbLoginFile | cut -d'*' -f1`
    DB_PWD=`cat $dbLoginFile | cut -d'*' -f2`
    DB_URL=`cat $dbLoginFile | cut -d'*' -f3`
    DB_NAME=`cat $dbLoginFile | cut -d'*' -f4`

    result=`echo ${processed} | grep ~${DB_URL}~`
    if [ "$result" = "" ]
    then
        echo "-------------------------------------"
        echo "Processing login from $dbLoginFile..."
        if [ "$SETUP" = "true" ]
        then
            initSchema
        else
            cleanSchema
        fi
        processed="${processed}~${DB_URL}~ "
    fi
done
echo "-------------------------------------"

if [ "$loginfound" = "false" ]
then
    echo "No db Login info available!"
fi