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

set -e

get_config()
{
	db_get mtop/mysql_server
	mysql_server="$RET"
	db_get mtop/mysql_port
	mysql_port="$RET"
	db_get mtop/root
	root_mysql="$RET"
	db_get mtop/password
	root_passwd="$RET"
}

remove_user()
{
	${mysqlcmd} -e "
	CONNECT mysql;
	delete from user where user=\"mysqltop\";
	delete from db where user=\"mysqltop\";
	flush privileges;
	"
}

# 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' <r>overwrit>r> <new-version>
# for details, see http://www.debian.org/doc/debian-policy/ or
# the debian-policy package


case "$1" in
       purge|remove)

	if [ -f /usr/share/debconf/confmodule ] && [ -f /usr/bin/mysql ]; then
		. /usr/share/debconf/confmodule
		db_version 2.0

		get_config
		password=`dd if=/dev/random bs=512 count=1 2> /dev/null| md5sum`
		if [ "$root_passwd" != 'none' ]; then
			mysqlpwd="-p${root_passwd}"
		fi
		mysqlcmd="mysql -h ${mysql_server} -P ${mysql_port} -u${root_mysql} ${mysqlpwd}"
		if ${mysqlcmd} -B -e 'select user from user' mysql | grep -q "^mysqltop$"
		then
			remove_user;
		fi
	fi
      
       
       ;;
       upgrade|failed-upgrade|abort-install|abort-upgrade|disappear)


        ;;

    *)
        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.

# Automatically added by dh_installdebconf
if [ "$1" = purge ] && [ -e /usr/share/debconf/confmodule ]; then
	. /usr/share/debconf/confmodule
	db_purge
fi
# End automatically added section


exit 0