1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
use strict;
use warnings;
use Test::More ;
use DBI;
$|= 1;
use vars qw($test_user $test_password $test_db $test_dsn);
use lib 't', '.';
require 'lib.pl';
# remove database from DSN
$test_dsn =~ s/^DBI:mysql:([^:;]+)([:;]?)/DBI:mysql:$2/;
my $dbh;
eval {$dbh= DBI->connect($test_dsn, $test_user, $test_password,
{ RaiseError => 1, PrintError => 1, AutoCommit => 0 });};
if ($@) {
diag $@;
plan skip_all => "no database connection";
}
plan tests => 2;
ok defined $dbh, "Connected to database";
eval{ $dbh->do("CREATE DATABASE IF NOT EXISTS $test_db") };
if($@) {
diag "No permission to '$test_db' database on '$test_dsn' for user '$test_user'";
} else {
diag "Database '$test_db' accessible";
}
ok $dbh->disconnect();
|
