X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F66relationship.t;h=f81ae948458695f1980e1997304039cb2fcf0584;hb=9c0df5f32b68e23c670c89ce6cdbff60b4bd0ed0;hp=73925d4ef6ec341219b2d52aaf851d076962e62b;hpb=21c45f7bbd6b55a7f83e27ae845efdd1a32fa1c7;p=dbsrgits%2FDBIx-Class.git diff --git a/t/66relationship.t b/t/66relationship.t index 73925d4..f81ae94 100644 --- a/t/66relationship.t +++ b/t/66relationship.t @@ -7,7 +7,7 @@ use DBICTest; my $schema = DBICTest->init_schema(); -plan tests => 56; +plan tests => 63; # has_a test my $cd = $schema->resultset("CD")->find(4); @@ -66,6 +66,13 @@ $track->set_from_related( cd => undef ); ok( !defined($track->cd), 'set_from_related with undef ok'); +TODO: { + local $TODO = 'accessing $object->rel and set_from_related'; + my $track = $schema->resultset("Track")->new( {} ); + $track->cd; + $track->set_from_related( cd => $cd ); + ok ($track->cd, 'set_from_related ok after using the accessor' ); +}; # update_from_related, the same as set_from_related, but it calls update afterwards $track = $schema->resultset("Track")->create( { @@ -90,6 +97,7 @@ $cd = $artist->find_or_create_related( 'cds', { year => 2006, } ); is( $cd->title, 'Greatest Hits', 'find_or_create_related new record ok' ); + @cds = $artist->search_related('cds'); is( ($artist->search_related('cds'))[4]->title, 'Greatest Hits', 'find_or_create_related new record search ok' ); @@ -109,6 +117,17 @@ $cd = $artist->find_or_new_related( 'cds', { is( $cd->title, 'Greatest Hits 2: Louder Than Ever', 'find_or_new_related new record ok' ); ok( ! $cd->in_storage, 'find_or_new_related on a new record: not in_storage' ); +# print STDERR Data::Dumper::Dumper($cd->get_columns); +# $cd->result_source->schema->storage->debug(1); +$cd->artist(undef); +my $newartist = $cd->find_or_new_related( 'artist', { + name => 'Random Boy Band Two', + artistid => 200, +} ); +# $cd->result_source->schema->storage->debug(0); +is($newartist->name, 'Random Boy Band Two', 'find_or_new_related new artist record with id'); +is($newartist->id, 200, 'find_or_new_related new artist id set'); + SKIP: { skip "relationship checking needs fixing", 1; # try to add a bogus relationship using the wrong cols @@ -191,6 +210,13 @@ is( $twokey->fourkeys->count, 0, 'twokey has no fourkeys' ); is( $twokey->fourkeys_to_twokeys->count, 0, 'twokey has no links to fourkey' ); +my $undef_artist_cd = $schema->resultset("CD")->new_result({ 'title' => 'badgers', 'year' => 2007 }); +is($undef_artist_cd->has_column_loaded('artist'), '', 'FK not loaded'); +is($undef_artist_cd->search_related('artist')->count, 3, 'open search on undef FK'); + +my $def_artist_cd = $schema->resultset("CD")->new_result({ 'title' => 'badgers', 'year' => 2007, artist => undef }); +is($def_artist_cd->has_column_loaded('artist'), 1, 'FK loaded'); +is($def_artist_cd->search_related('artist')->count, 0, 'closed search on null FK'); # test undirected many-to-many relationship (e.g. "related artists") my $undir_maps = $schema->resultset("Artist")->find(1)->artist_undirected_maps;