X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fmulti_create%2Fin_memory.t;h=cbd5309cac13caf10c4b2a976596f4060a3a68a9;hb=0f72fb470be604ed2ab11a7d172b2657c3410385;hp=e5c888b26c50977ff1fabef7d62d3a15c43374a6;hpb=c3bc66c837f3afaf86f00ae31d62e46476453baa;p=dbsrgits%2FDBIx-Class.git diff --git a/t/multi_create/in_memory.t b/t/multi_create/in_memory.t index e5c888b..cbd5309 100644 --- a/t/multi_create/in_memory.t +++ b/t/multi_create/in_memory.t @@ -6,8 +6,6 @@ use Test::Exception; use lib qw(t/lib); use DBICTest; -plan tests => 12; - my $schema = DBICTest->init_schema(); # Test various new() invocations - this is all about backcompat, making @@ -46,6 +44,99 @@ my $schema = DBICTest->init_schema(); } { + my $new_cd = $schema->resultset('CD')->new ({ 'title' => 'Leave Loudly While Singing Off Key', 'year' => 1982}); + my $new_artist = $schema->resultset("Artist")->new ({ 'name' => 'Depeche Mode 2: Insertion Boogaloo' }); + $new_cd->artist ($new_artist); + + eval { + $new_cd->insert; + }; + is ($@, '', 'CD insertion survives by inserting artist'); + ok($new_cd->in_storage, 'new_related_cd inserted'); + ok($new_artist->in_storage, 'artist inserted'); + + my $retrieved_cd = $schema->resultset('CD')->find ({ 'title' => 'Leave Loudly While Singing Off Key'}); + ok ($retrieved_cd, 'CD found in db'); + is ($retrieved_cd->artist->name, 'Depeche Mode 2: Insertion Boogaloo', 'Correct artist attached to cd'); +} + +# test both sides of a 1:(1|0) +{ + for my $reldir ('might_have', 'belongs_to') { + my $artist = $schema->resultset('Artist')->next; + + my $new_track = $schema->resultset('Track')->new ({ + title => "$reldir: First track of latest cd", + cd => { + title => "$reldir: Latest cd", + year => 2666, + artist => $artist, + }, + }); + + my $new_single = $schema->resultset('CD')->new ({ + artist => $artist, + title => "$reldir: Awesome first single", + year => 2666, + }); + + if ($reldir eq 'might_have') { + $new_track->cd_single ($new_single); + $new_track->insert; + } + else { + $new_single->single_track ($new_track); + $new_single->insert; + } + + ok ($new_single->in_storage, "$reldir single inserted"); + ok ($new_track->in_storage, "$reldir track inserted"); + + my $new_cds = $artist->search_related ('cds', + { year => '2666' }, + { prefetch => 'tracks', order_by => 'cdid' } + ); + + is_deeply ( + [$new_cds->search ({}, { result_class => 'DBIx::Class::ResultClass::HashRefInflator'})->all ], + [ + { + artist => 1, + cdid => 9, + genreid => undef, + single_track => undef, + title => "$reldir: Latest cd", + tracks => [ + { + cd => 9, + last_updated_at => undef, + last_updated_on => undef, + position => 1, + small_dt => undef, + title => "$reldir: First track of latest cd", + trackid => 19 + } + ], + year => 2666 + }, + { + artist => 1, + cdid => 10, + genreid => undef, + single_track => 19, + title => "$reldir: Awesome first single", + tracks => [], + year => 2666 + }, + ], + 'Expected rows created in database', + ); + + $new_cds->delete_all; + } +} + +{ my $new_cd = $schema->resultset("CD")->new_result({}); my $new_related_artist = $new_cd->new_related('artist', { 'name' => 'Marillion',}); lives_ok ( @@ -61,3 +152,5 @@ my $schema = DBICTest->init_schema(); ok($new_related_artist->in_storage, 'related artist inserted'); ok($new_cd->in_storage, 'cd inserted'); } + +done_testing;