# Test making DBI parameters bad

# $Id: bad_param-1.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 => 10;

# ------ 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

# ------ set up return values for DBI fetch*() methods
$md	= Test::MockDBI::get_instance();
isa_ok($md, q{Test::MockDBI}, q{Expect a Test::MockDBI reference});

# Set 1st param bad (In mode --dbitest=2)

warning_like{
  like($md->bad_param(2, 1, "jimbo"), qr/^\d+$/, q{Expect a positive integer (bad_param))});
} qr/called bad_param in an deprecated way/, "Legacy warning displayed";

warning_like{
  like($md->set_retval_scalar(2, "SOmE 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("SOmE SQL ?"),
isa_ok($select, q{DBI::st}, q{Expect a DBI::st reference});

# Bind, execute and fetch
is($select->bind_param(1, "jimbo"), undef, q{Expect undef (bind_param))});
cmp_ok($select->execute(), 'eq', '0E0', q{Expect 0E0 (execute -1))});
is($select->finish(), 1, q{Expect 1 (finish) });

__END__