use strict;
use warnings;
use Test::More;
use lib qw( t/lib );
use DBICTest;
use DBICTest::Constants qw/ ARTIST CD TRACK /;
BEGIN {
eval "use DBD::SQLite";
plan $@
? ( skip_all => 'needs DBD::SQLite for testing' )
: ( tests => 6 );
}
my $schema = DBICTest->init_schema;
## master
my @m_artist = $schema->resultset('Artist')->search({},{order_by => 'artistid ASC'})->get_column('name')->all;
is(@m_artist,ARTIST,'master artist "get_column"');
my @m_cd = $schema->resultset('CD')->search({},{order_by => 'cdid ASC'})->get_column('title')->all;
is(@m_cd,CD,'master cd "get_columb"');
my @m_track = $schema->resultset('Track')->search({},{order_by => 'trackid ASC'})->get_column('title')->all;
is(@m_track,TRACK,'master track "get_column"');
## slave
my @s_artist = $schema->resultset('Artist::Slave')->search({},{order_by => 'artistid ASC'})->get_column('name')->all;
is(@s_artist,ARTIST,'slave artist "get_column"');
my @s_cd = $schema->resultset('CD::Slave')->search({},{order_by => 'cdid ASC'})->get_column('title')->all;
is(@s_cd,CD,'slave cd "get_column"');
my @s_track = $schema->resultset('Track::Slave')->search({},{order_by => 'trackid ASC'})->get_column('title')->all;
is(@s_track,TRACK,'slave track "get_column"');