[dbsrgits/DBIx-Class.git] / t / cdbi-t / retrieve_from_sql_with_limit.t

#!/usr/bin/perl -w

use strict;
use Test::More;

BEGIN {
  eval "use DBIx::Class::CDBICompat;";
  plan $@ ? (skip_all => "Class::Trigger and DBIx::ContextualFetch required: $@")
          : (tests=> 3);
}

INIT {
    use lib 't/testlib';
    use Film;
}

for my $title ("Bad Taste", "Braindead", "Forgotten Silver") {
    Film->insert({ Title => $title, Director => 'Peter Jackson' });
}

Film->insert({ Title => "Transformers", Director => "Michael Bay"});

{
    my @films = Film->retrieve_from_sql(qq[director = "Peter Jackson" LIMIT 2]);
    is @films, 2, "retrieve_from_sql with LIMIT";
    is( $_->director, "Peter Jackson" ) for @films;
}
Commit	Line	Data
e60dc79f	1	#!/usr/bin/perl -w
	2
	3	use strict;
	4	use Test::More;
	5
	6	BEGIN {
	7	eval "use DBIx::Class::CDBICompat;";
	8	plan $@ ? (skip_all => "Class::Trigger and DBIx::ContextualFetch required: $@")
	9	: (tests=> 3);
	10	}
	11
	12	INIT {
	13	use lib 't/testlib';
	14	use Film;
	15	}
	16
	17	for my $title ("Bad Taste", "Braindead", "Forgotten Silver") {
	18	Film->insert({ Title => $title, Director => 'Peter Jackson' });
	19	}
	20
	21	Film->insert({ Title => "Transformers", Director => "Michael Bay"});
	22
	23	{
	24	my @films = Film->retrieve_from_sql(qq[director = "Peter Jackson" LIMIT 2]);
	25	is @films, 2, "retrieve_from_sql with LIMIT";
	26	is( $_->director, "Peter Jackson" ) for @films;
	27	}