Catalyst-Controller-DBIC-API
view release on metacpan or search on metacpan
t/rpc/list_prefetch.t view on Meta::CPAN
use strict;
use warnings;
use lib 't/lib';
my $base = 'http://localhost';
use RestTest;
use DBICTest;
use URI;
use Test::More tests => 17;
use Test::WWW::Mechanize::Catalyst 'RestTest';
use HTTP::Request::Common;
use JSON::MaybeXS;
my $json = JSON::MaybeXS->new(utf8 => 1);
my $mech = Test::WWW::Mechanize::Catalyst->new;
ok( my $schema = DBICTest->init_schema(), 'got schema' );
my $artist_list_url = "$base/api/rpc/artist/list";
my $cd_list_url = "$base/api/rpc/cd/list";
foreach my $req_params ( { 'list_prefetch' => '["cds"]' },
{ 'list_prefetch' => 'cds' } )
{
my $uri = URI->new($artist_list_url);
$uri->query_form($req_params);
my $req = GET( $uri, 'Accept' => 'text/x-json' );
$mech->request($req);
cmp_ok( $mech->status, '==', 200,
'search with simple prefetch request okay' );
my $rs =
$schema->resultset('Artist')
->search( undef, { prefetch => ['cds'] } );
$rs->result_class('DBIx::Class::ResultClass::HashRefInflator');
my @rows = $rs->all;
my $expected_response = { list => \@rows, success => 'true' };
my $response = $json->decode( $mech->content );
#use Data::Dumper; warn Dumper($response, $expected_response);
is_deeply( $expected_response, $response,
'correct data returned for search with simple prefetch specified as param'
);
}
foreach my $req_params (
{ 'list_prefetch' => '{"cds":"tracks"}' },
{ 'list_prefetch.cds' => 'tracks' }
)
{
my $uri = URI->new($artist_list_url);
$uri->query_form($req_params);
my $req = GET( $uri, 'Accept' => 'text/x-json' );
$mech->request($req);
cmp_ok( $mech->status, '==', 200,
'search with multi-level prefetch request okay' );
my $rs =
$schema->resultset('Artist')
->search( undef, { prefetch => { 'cds' => 'tracks' } } );
$rs->result_class('DBIx::Class::ResultClass::HashRefInflator');
my @rows = $rs->all;
my $expected_response = { list => \@rows, success => 'true' };
my $response = $json->decode( $mech->content );
#use Data::Dumper; warn Dumper($response, $expected_response);
is_deeply( $expected_response, $response,
'correct data returned for search with multi-level prefetch specified as param'
);
}
foreach my $req_params ( { 'list_prefetch' => '["artist"]' },
{ 'list_prefetch' => 'artist' } )
( run in 0.547 second using v1.01-cache-2.11-cpan-13bb782fe5a )