source: lliurex-analytics-server/trunk/fuentes/debian/postrm @ 3366

#!/bin/sh
# postrm script
#
# see: dh_installdeb(1)

#set -e 

# summary of how this script can be called:
#        * <postrm> `remove'
#        * <postrm> `purge'
#        * <old-postrm> `upgrade' <new-version>
#        * <new-postrm> `failed-upgrade' <old-version>
#        * <new-postrm> `abort-install'
#        * <new-postrm> `abort-install' <old-version>
#        * <new-postrm> `abort-upgrade' <old-version>
#        * <disappearer's-postrm> `disappear' <overwriter>
#          <overwriter-version>
# for details, see http://www.debian.org/doc/debian-policy/ or
# the debian-policy package

do_dialog(){
    input=$(dialog      \
    --title "$1"        \
    --inputbox "$2"     0 0     \
    3>&1 1>&2 2>&3 3>&-)
    clear
}
ask_question(){
    dialog --yesno "$1" 0 0
    if [ $? -eq 0 ]; then
        input=yes
    else
        input=no
    fi
    clear
}

case "$1" in
    remove|upgrade|failed-upgrade|abort-install|abort-upgrade|disappear)
    ;;
    purge)
        mysql_cmd="mysql -s -u root"
        RET=$(echo "show databases;" |${mysql_cmd} 2>/dev/null)
        if [ -z "${RET}" ]; then
            ask_question 'Mysql root password?'
            rootpass=${input}
            mysql_cmd="mysql -s -uroot -p${input}"
            RET=$(echo "show databases;" |${mysql_cmd} 2>/dev/null)
            if [ -z "${RET}" ]; then
                echo "Error removing database"
                exit 0
            fi
        fi
        echo "Removing database.."
        USER=$(echo "select user from mysql.db where db like 'analytics';"| ${mysql_cmd} 2>/dev/null)
        if [ -z "${USER}" ]; then
            echo "Error removing database"
            exit 0
        fi
        echo "drop database analytics;" | ${mysql_cmd} 2>/dev/null
        echo "drop user ${USER};"| ${mysql_cmd} 2>/dev/null
        echo "flush privileges;"| ${mysql_cmd} 2>/dev/null
        echo "Database analytics & user ${USER} removed from mysql"
        exit 0
    ;;

    *)
        echo "postrm called with unknown argument \`$1'" >&2
        exit 1
    ;;
esac

# dh_installdeb will replace this with shell code automatically
# generated by other debhelper scripts.

#DEBHELPER#

exit 0