'Destroy a test database, prompting the user for confirmation if the
database already exists. Returns the name of the test database created.'

def _destroy_test_db(self, test_database_name, verbosity=1):

    TEST_NAME = self._test_database_name()
    TEST_USER = self._test_database_user()
    TEST_PASSWD = self._test_database_passwd()
    TEST_TBLSPACE = self._test_database_tblspace()
    TEST_TBLSPACE_TMP = self._test_database_tblspace_tmp()
    self.connection.settings_dict['USER'] = self.remember['user']
    self.connection.settings_dict['PASSWORD'] = self.remember['passwd']
    parameters = {'dbname': TEST_NAME, 'user': TEST_USER, 'password': TEST_PASSWD, 'tblspace': TEST_TBLSPACE, 'tblspace_temp': TEST_TBLSPACE_TMP}
    cursor = self.connection.cursor()
    time.sleep(1)
    if self._test_user_create():
        if (verbosity >= 1):
            print 'Destroying    test    user...'
        self._destroy_test_user(cursor, parameters, verbosity)
    if self._test_database_create():
        if (verbosity >= 1):
            print 'Destroying    test    database    tables...'
        self._execute_test_db_destruction(cursor, parameters, verbosity)
    self.connection.close()
