X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Frun%2F01core.tl;h=0bc257aee0ca2cbc26a29fc9294c7016b65d7400;hb=182fee362308526aa3f6161e8d79d566e7df520e;hp=ce41f1687712e08eb98a5145b7c3c21188c062e3;hpb=8c49f6295f3c7e07ba4bda6379f3c9f065501d7a;p=dbsrgits%2FDBIx-Class.git diff --git a/t/run/01core.tl b/t/run/01core.tl index ce41f16..0bc257a 100644 --- a/t/run/01core.tl +++ b/t/run/01core.tl @@ -1,7 +1,7 @@ sub run_tests { my $schema = shift; -plan tests => 34; +plan tests => 43; my @art = $schema->resultset("Artist")->search({ }, { order_by => 'name DESC'}); @@ -71,7 +71,7 @@ $new_again = $schema->resultset("Artist")->find(4); is($new_again->name, 'Man With A Spoon', 'Retrieved correctly'); -is($new_again->ID, 'DBICTest::Artist|artistid=4', 'unique object id generated correctly'); +is($new_again->ID, 'DBICTest::Artist|artist|artistid=4', 'unique object id generated correctly'); is($schema->resultset("Artist")->count, 4, 'count ok'); @@ -91,28 +91,33 @@ is($cd->year, 2005, 'set_columns ok'); $cd->discard_changes; -# check whether ResultSource->ordered_columns returns columns in order originally supplied -my @cd = $schema->source("CD")->ordered_columns; +# check whether ResultSource->columns returns columns in order originally supplied +my @cd = $schema->source("CD")->columns; -is_deeply( \@cd, [qw/cdid artist title year/], 'ordered_columns'); +is_deeply( \@cd, [qw/cdid artist title year/], 'column order'); -$cd = $schema->resultset("CD")->search({ title => 'Spoonful of bees' }, { cols => ['title'] })->next; +$cd = $schema->resultset("CD")->search({ title => 'Spoonful of bees' }, { columns => ['title'] })->next; is($cd->title, 'Spoonful of bees', 'subset of columns returned correctly'); -# insert_or_update +$cd = $schema->resultset("CD")->search(undef, { include_columns => [ 'artist.name' ], join => [ 'artist' ] })->find(1); + +is($cd->title, 'Spoonful of bees', 'Correct CD returned with include'); +is($cd->get_column('name'), 'Caterwauler McCrae', 'Additional column returned'); + +# update_or_insert $new = $schema->resultset("Track")->new( { trackid => 100, cd => 1, position => 1, title => 'Insert or Update', } ); -$new->insert_or_update; -ok($new->in_storage, 'insert_or_update insert ok'); +$new->update_or_insert; +ok($new->in_storage, 'update_or_insert insert ok'); # test in update mode -$new->position(5); -$new->insert_or_update; -is( $schema->resultset("Track")->find(100)->position, 5, 'insert_or_update update ok'); +$new->pos(5); +$new->update_or_insert; +is( $schema->resultset("Track")->find(100)->pos, 5, 'update_or_insert update ok'); eval { $schema->class("Track")->load_components('DoesNotExist'); }; @@ -139,6 +144,29 @@ my $rel_rs = $tag_rs->search_related('cd'); cmp_ok($rel_rs->count, '==', 5, 'Related search ok'); cmp_ok($or_rs->next->cdid, '==', $rel_rs->next->cdid, 'Related object ok'); +$or_rs->reset; +$rel_rs->reset; + +my $tag = $schema->resultset('Tag')->search( + [ { 'me.tag' => 'Blue' } ], { cols=>[qw/tagid/] } )->next; + +cmp_ok($tag->has_column_loaded('tagid'), '==', 1, 'Has tagid loaded'); +cmp_ok($tag->has_column_loaded('tag'), '==', 0, 'Has not tag loaded'); + +ok($schema->storage(), 'Storage available'); + +#test cascade_delete thru many_many relations +my $art_del = $schema->resultset("Artist")->find({ artistid => 1 }); +$art_del->delete; +cmp_ok( $schema->resultset("CD")->search({artist => 1}), '==', 0, 'Cascading through has_many top level.'); +cmp_ok( $schema->resultset("CD_to_Producer")->search({cd => 1}), '==', 0, 'Cascading through has_many children.'); + +$schema->source("Artist")->{_columns}{'artistid'} = {}; + +my $typeinfo = $schema->source("Artist")->column_info('artistid'); +is($typeinfo->{data_type}, 'INTEGER', 'column_info ok'); +$schema->source("Artist")->column_info('artistid'); +ok($schema->source("Artist")->{_columns_info_loaded} == 1, 'Columns info flag set'); }