###
### some global variables etc
###
dbc_go(){
	local need_admin_pw dumpfile nowtime rmscript rmsql purgescript purgesql tsubstfile

	. /usr/share/dbconfig-common/dpkg/common
	_dbc_debug "(prerm) dbc_go() $@"

	dbc_config $@

	###
	### get all the settings we need
	###
	dbc_read_package_config
	# and re-run config for db-specific settings
	dbc_set_dbtype_defaults $dbc_dbtype

	if echo "$dbc_authenticated_dbtypes" | grep -q "$dbc_dbtype"; then
		need_admin_pw="yup"
	else
		need_admin_pw=""
	fi 

	if [ "$dbc_command" = "remove" ] && [ ! "$dbc_frontend" ]; then
		###
		### if they didn't want our help installing,  we should assume
		### they don't want our help removing either
		###
		if [ "$dbc_install" != "true" ]; then return 0; fi

		###
		### ask the admin if we should help with removal
		###
		if [ "$dbc_remove" ]; then 
			db_set $dbc_package/dbconfig-remove "$dbc_remove"
		fi
		db_fset $dbc_package/dbconfig-remove seen false
		db_input high $dbc_package/dbconfig-remove || true
		db_go || true
		db_get $dbc_package/dbconfig-remove && dbc_remove="$RET"

		if [ "$dbc_remove" != "true" ]; then
			return 0;
		fi

		###
		###	package removal hooks
		###
		rmscript=/usr/share/dbconfig-common/scripts/$dbc_package/remove/$dbc_dbtype
		rmsql=/usr/share/dbconfig-common/data/$dbc_package/remove/$dbc_dbtype
		# run the script if it exists
		if [ -f "$rmscript" ]; then
			dbc_logpart "running maintainer removal script hook... "
			if ! sh -c "$rmscript \"$@\""; then
				dbc_error="$rmscript existed with non-zero status"
				dbc_remove_error "running maintainer removal hook"
			fi
			dbc_logline "done"
		fi
		# run the sql if it exists
		if [ -f "$rmsql" ]; then
			dbc_logpart "running maintainer removal sql hook... "
			if [ ! "$dbc_sql_substitutions" ]; then
				$dbc_sqlfile_cmd $rmsql || dbc_remove_error "running maintainer removal sql hook"
			else
				tsubstfile=`dbc_mktemp`
				/usr/sbin/dbconfig-generate-include -f template -o template_infile=$rmsql $dbc_packageconfig > $tsubstfile
				$dbc_sqlfile_cmd $tsubstfile || dbc_remove_error "running maintainer removal sql hook"
				rm -f $tsubstfile
			fi
			dbc_logline "done"
		fi

		###
		### ask the admin if the database should be purged
		###
		db_fset $dbc_package/purge seen false
		db_input high $dbc_package/purge || true
		db_go || true
		db_get $dbc_package/purge
		dbc_purge="$RET"

		if [ "$dbc_dbtype" = "pgsql" ] && \
		   [ "$dbc_authmethod_admin" = "ident" ]; 
		then
			need_admin_pw=""
		fi

		if [ "$dbc_purge" = "true" ]; then
			# get the admin user password
			if [ "$need_admin_pw" ]; then
				dbc_get_admin_pass
			fi

			# dump the database into a temporary file
			nowtime=`date +%Y-%m-%d-%H.%M`
			if [ ! `dirname /var/tmp/$dbc_package` = /var/tmp ]; then
				mkdir -p `dirname /var/tmp/$dbc_package`
			fi
			dumpfile=`mktemp /var/tmp/$dbc_package.$dbc_dbname.$nowtime.$dbc_dbtype.XXXXXX`
			if [ ! -f $dumpfile ]; then
				dbc_remove_error "creating temporary file for database dump"
			fi
			dbc_logline "dbconfig-common: dumping $dbc_dbtype database $dbc_dbname to $dumpfile"
			$dbc_dump_cmd $dumpfile || dbc_remove_error "dumping database"
			dbc_logline "dbconfig-common: dropping $dbc_dbtype database $dbc_dbname"
			$dbc_dropdb_cmd || dbc_remove_error "dropping database"
			[ "$dbc_tried_again" ] && return 0

			dbc_logline "dbconfig-common: revoking privileges for user $dbc_dbuser on $dbc_dbname"
			$dbc_dropuser_cmd
		fi
	fi
}