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

use strict;
use Test::More;

INIT {
    use lib 't/cdbi/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;
}

done_testing;
Commit	Line	Data
e60dc79f	1	use strict;
	2	use Test::More;
	3
e60dc79f	4	INIT {
50891152	5	use lib 't/cdbi/testlib';
e60dc79f	6	use Film;
	7	}
	8
	9	for my $title ("Bad Taste", "Braindead", "Forgotten Silver") {
	10	Film->insert({ Title => $title, Director => 'Peter Jackson' });
	11	}
	12
	13	Film->insert({ Title => "Transformers", Director => "Michael Bay"});
	14
	15	{
	16	my @films = Film->retrieve_from_sql(qq[director = "Peter Jackson" LIMIT 2]);
	17	is @films, 2, "retrieve_from_sql with LIMIT";
	18	is( $_->director, "Peter Jackson" ) for @films;
	19	}
d9bd5195	20
d9bd5195	21	done_testing;