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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
# Test making DBI parameters bad
# $Id: bad_param-2.t 246 2008-12-04 13:01:22Z aff $
# ------ enable testing mock DBI
BEGIN { push @ARGV, "--dbitest=2"; }
# ------ use/require pragmas
use strict; # better compile-time checking
use warnings; # better run-time checking
use Test::More; # advanced testing
use Test::Warn;
use Data::Dumper;
use File::Spec::Functions;
use lib catdir qw ( blib lib ); # use local module
use Test::MockDBI; # what we are testing
plan tests => 11;
# ------ define variables
my $dbh = undef; # mock DBI database handle
my $md = undef; # Test::MockDBI instance
my @retval = (); # return array from fetchrow_array()
my $select = undef; # DBI SQL SELECT statement handle
$md = Test::MockDBI::get_instance();
isa_ok($md, q{Test::MockDBI}, q{Expect a Test::MockDBI reference});
# Set 2nd param bad (In mode --dbitest=2)
warning_like{
like($md->bad_param(2, 2, "noblesville"), qr/^\d+$/, q{Expect a positive integer (bad_param))});
} qr /bad_param in an deprecated way/, "Legacy warning displayed";
warning_like{
like($md->set_retval_scalar(2, "other SQL", [42]), qr/^\d+$/, q{Expect a positive integer (set_retval_scalar))});
} qr/set_retval_scalar is deprecated/, "Legacy warning displayed";
# Connect and prepare
$dbh = DBI->connect("", "", "");
isa_ok($dbh, q{DBI::db}, q{Expect a DBI::db reference});
$select = $dbh->prepare("other SQL ? ? ");
isa_ok($select, q{DBI::st}, q{Expect a DBI::st reference});
# Bind, execute and fetch
is($select->bind_param(1, "46062"), 1, q{Expect 1 (bind_param 1))});
is($select->bind_param(2, "noblesville"), undef, q{Expect undef (bind_param 2))});
cmp_ok($select->execute(), 'eq', '0E0', q{Expect 0E0 (execute -1))});
is($select->finish(), 1, q{Expect 1 (finish) });
__END__
|
