#! /usr/bin/env perl
#
# Verify that $dbh->tables() returns a list of (quoted) tables.
#
use strict;
use warnings;
use Test::More;
use lib 't','.';
use TestFirebird;
my $T = TestFirebird->new;
my ($dbh, $error_str) = $T->connect_to_database();
if ($error_str) {
BAIL_OUT("Unknown: $error_str!");
}
unless ( $dbh->isa('DBI::db') ) {
plan skip_all => 'Connection to database failed, cannot continue testing';
}
else {
plan tests => 6;
}
ok($dbh, 'Connected to the database');
# ------- TESTS ------------------------------------------------------------- #
#
# Find a possible new table name
#
my $table = find_new_table($dbh);
ok($table, qq{Table is '$table'});
ok($dbh->do(<<__eocreate), "CREATE TABLE $table");
CREATE TABLE $table(
i INTEGER NOT NULL,
vc VARCHAR(64) NOT NULL
)
__eocreate
my %tables = map { uc($_) => 1 } $dbh->tables;
ok(exists $tables{ $dbh->quote_identifier(uc($table)) },
"tables() returned uppercased, quoted $table");
#diag join(' ', sort keys %tables);
ok($dbh->do("DROP TABLE $table"), "DROP TABLE $table");
%tables = map { uc($_) => 1 } $dbh->tables;
#diag join(' ', sort keys %tables);
ok(!exists($tables{ $dbh->quote_identifier(uc($table)) }),
"$table no longer in tables()");
__END__
# vim: set et ts=4: