# Test::MockDBI fetchall_arrayref() with many-element array returned
# (For our purposes, 2 eq many.)

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

plan tests => 4;


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


# ------ set up return values for DBI fetch*() methods
$dbh = DBI->connect("", "", "");
$md->set_retval_scalar(2, "FETCH", [ [ "go deep", 476 ], [ 1066, "Yellow Pages" ] ]);

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

# test matching sql
$dbh->prepare("FETCHALL_ARRAYREF");  
$retval = $dbh->fetchall_arrayref();
ok(defined($retval), q{Expect defined for non-matching sql});
isa_ok($retval, q{ARRAY}, q{Expect array ref});
is_deeply(
  $retval,
  [ [ "go deep", 476 ], [ 1066, "Yellow Pages" ] ],
  q{Expect array ref with 2 array ref elements}
);

$dbh->finish();

__END__

=pod

=cut