# Test::MockDBI fetch*() with many-element array returned from coderef
# (for our purposes, 2 == many)

# $Id: coderef-array-many.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 File::Spec::Functions;
use lib catdir qw ( blib lib );    # use local module
use Test::MockDBI;     # module we are testing

plan tests => 3;

# ------ define variables
my $dbh    = "";                            # mock DBI database handle
my $md     = Test::MockDBI::get_instance();
my @retval = ();                            # return value from fetchrow_array()

# ------ set up return values for DBI fetch*() methods
$dbh = DBI->connect("", "", "");

warning_like{
  $md->set_retval_array(2, "FETCHROW_ARRAY", sub { return (1054, 1066); });
} qr/set_retval_array is deprecated/, "Legacy warning displayed";


# test non-matching sql
my $sth = $dbh->prepare("other SQL");
$sth->execute();
ok(!defined($sth->fetchrow_array()), q{Expect undef for non-matching sql});
$sth->finish();

# test matching sql
$sth = $dbh->prepare("FETCHROW_ARRAY");
$sth->execute();
@retval = $sth->fetchrow_array();
is_deeply(\@retval, [ 1054, 1066 ], q{Expect array with element 1054, 1066});
$sth->finish();


__END__

=pod

=cut