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

use DBIx::Class::Optional::Dependencies -skip_all_without => 'cdbicompat';

use strict;
use warnings;

use Test::More;

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
83eef562	1	use DBIx::Class::Optional::Dependencies -skip_all_without => 'cdbicompat';
83eef562	2
e60dc79f	3	use strict;
4a233f30	4	use warnings;
83eef562	5
e60dc79f	6	use Test::More;
e60dc79f	7
a40329c4	8	use lib 't/cdbi/testlib';
a40329c4	9	use Film;
e60dc79f	10
	11	for my $title ("Bad Taste", "Braindead", "Forgotten Silver") {
	12	Film->insert({ Title => $title, Director => 'Peter Jackson' });
	13	}
	14
	15	Film->insert({ Title => "Transformers", Director => "Michael Bay"});
	16
	17	{
	18	my @films = Film->retrieve_from_sql(qq[director = "Peter Jackson" LIMIT 2]);
	19	is @films, 2, "retrieve_from_sql with LIMIT";
	20	is( $_->director, "Peter Jackson" ) for @films;
	21	}
d9bd5195	22
d9bd5195	23	done_testing;