X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fp5-DBIx-Class-ResultSet-RecursiveUpdate;a=blobdiff_plain;f=t%2Flib%2FRunTests.pm;h=f391fc6e390de1d493615383dca94f4320994305;hp=d6086207de8538b8a324011f09edee59bb81445d;hb=527858c3403a2591ac2782137ec0ff99ff563107;hpb=fdf7f6a07c1013e9fac4a076599a47892d7dd331 diff --git a/t/lib/RunTests.pm b/t/lib/RunTests.pm index d608620..f391fc6 100644 --- a/t/lib/RunTests.pm +++ b/t/lib/RunTests.pm @@ -4,12 +4,12 @@ use Exporter 'import'; # gives you Exporter's import() method directly @EXPORT = qw(run_tests); use strict; use Test::More; - +use DBIx::Class::ResultSet::RecursiveUpdate; sub run_tests{ my $schema = shift; - plan tests => 27; + plan tests => 36; my $dvd_rs = $schema->resultset( 'Dvd' ); my $user_rs = $schema->resultset( 'User' ); @@ -18,10 +18,9 @@ sub run_tests{ my $another_owner = $user_rs->next; my $initial_user_count = $user_rs->count; my $initial_dvd_count = $dvd_rs->count; - - # creating new record linked to some old record - my $updates; + + # creating new record linked to some old record $updates = { name => 'Test name 2', viewings => [ { user_id => $owner->id } ], @@ -38,7 +37,7 @@ sub run_tests{ is ( $new_dvd->viewings->count, 1, 'Viewing created' ); # creating new records - my $updates = { + $updates = { aaaa => undef, tags => [ '2', { id => '3' } ], name => 'Test name', @@ -77,14 +76,14 @@ sub run_tests{ ok ( $onekey, 'Onekey created' ); ok ( $schema->resultset( 'Twokeys_belongsto' )->find( { key1 => $onekey->id, key2 => 1 } ), 'Twokeys created' ); - + is ( $dvd->name, 'Test name', 'Dvd name set' ); # changing existing records my $num_of_users = $user_rs->count; $updates = { - id => $dvd->id, + id => $dvd->dvd_id, # id instead of dvd_id aaaa => undef, - name => 'Test name', + name => undef, tags => [ ], 'owner' => $another_owner->id, current_borrower => { @@ -97,15 +96,27 @@ sub run_tests{ }, }; - $dvd = $dvd_rs->recursive_update( $updates ); - + my $dvd_updated = $dvd_rs->recursive_update( $updates ); + + is ( $dvd_updated->dvd_id, $dvd->dvd_id, 'Pk from "id"' ); is ( $schema->resultset( 'User' )->count, $initial_user_count + 1, "No new user created" ); - is ( $dvd->name, 'Test name', 'Dvd name set' ); - is ( $dvd->owner->id, $another_owner->id, 'Owner updated' ); - is ( $dvd->current_borrower->name, 'new name a', 'Related record modified' ); - is ( $dvd->tags->count, 0, 'Tags deleted' ); - is ( $dvd->liner_notes->notes, 'test note changed', 'might_have record changed' ); + is ( $dvd_updated->name, undef, 'Dvd name deleted' ); + is ( $dvd_updated->owner->id, $another_owner->id, 'Owner updated' ); + is ( $dvd_updated->current_borrower->name, 'new name a', 'Related record modified' ); + is ( $dvd_updated->tags->count, 0, 'Tags deleted' ); + is ( $dvd_updated->liner_notes->notes, 'test note changed', 'might_have record changed' ); + $new_dvd->update( { name => 'New Test Name' } ); + $updates = { + id => $new_dvd->dvd_id, # id instead of dvd_id + like_has_many => [ + { dvd_name => $dvd->name, key2 => 1 } + ], + }; + $dvd_updated = $dvd_rs->recursive_update( $updates ); + ok ( $schema->resultset( 'Twokeys' )->find( { dvd_name => 'New Test Name', key2 => 1 } ), 'Twokeys updated' ); + ok ( !$schema->resultset( 'Twokeys' )->find( { dvd_name => $dvd->name, key2 => 1 } ), 'Twokeys updated' ); + # repeatable $updates = { @@ -134,6 +145,60 @@ sub run_tests{ is( scalar @tags, 2, 'Tags in has_many related record saved' ); ok( $owned_dvds{'temp name 2'}, 'Second name in a has_many related record saved' ); + $updates = { + id => $user->id, + address => { + street => "101 Main Street", + city => "Podunk", + state => "New York" + }, + owned_dvds =>[ + { + id => 1, + }, + ] + }; + $user = $user_rs->recursive_update( $updates ); + $user = $user_rs->recursive_update( $updates ); + is( $schema->resultset( 'Address' )->search({ user_id => $user->id })->count, 1, + 'the right number of addresses' ); + $dvd = $dvd_rs->find( 1 ); + is( $dvd->get_column( 'owner' ), $user->id, 'foreign key set' ); + + $dvd_rs->update( { current_borrower => $user->id } ); + ok( $user->borrowed_dvds->count > 1, 'Precond' ); + $updates = { + id => $user->id, + borrowed_dvds =>[ + { + id => $dvd->id + }, + ] + }; + $user = DBIx::Class::ResultSet::RecursiveUpdate::Functions::recursive_update( + resultset => $user_rs, + updates => $updates, + if_not_submitted => 'set_to_null', + ); + is( $user->borrowed_dvds->count, 1, 'set_to_null' ); + + $dvd_rs->update( { current_borrower => $user->id } ); + $updates = { + id => $user->id, + borrowed_dvds =>[ + { + id => $dvd->id + }, + ] + }; + $user = DBIx::Class::ResultSet::RecursiveUpdate::Functions::recursive_update( + resultset => $user_rs, + updates => $updates, + if_not_submitted => 'delete', + ); + is( $user->borrowed_dvds->count, 1, 'if_not_submitted delete' ); + + # $updates = { # name => 'Test name 1', # };