X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fp5-DBIx-Class-ResultSet-RecursiveUpdate;a=blobdiff_plain;f=t%2Flib%2FRunTests.pm;h=8e5afa8e3bc0e83b01aa125ea8497345140cceff;hp=fd4fe71d9cf655003c477a1c0767fc6696952247;hb=df9cba8acd38f0929da6d62ec6980cbc3415421a;hpb=f6641f7ade5a9b4227feef8a538228fcea80a5b2 diff --git a/t/lib/RunTests.pm b/t/lib/RunTests.pm index fd4fe71..8e5afa8 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 => 29; + plan tests => 36; my $dvd_rs = $schema->resultset( 'Dvd' ); my $user_rs = $schema->resultset( 'User' ); @@ -19,7 +19,7 @@ sub run_tests{ my $initial_user_count = $user_rs->count; my $initial_dvd_count = $dvd_rs->count; my $updates; - + # creating new record linked to some old record $updates = { name => 'Test name 2', @@ -81,7 +81,7 @@ sub run_tests{ my $num_of_users = $user_rs->count; $updates = { - id => $dvd->id, + id => $dvd->dvd_id, # id instead of dvd_id aaaa => undef, name => undef, tags => [ ], @@ -96,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, undef, 'Dvd name deleted' ); - 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 } + ], + }; + my $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 = { @@ -139,14 +151,54 @@ sub run_tests{ 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', # };