X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fp5-DBIx-Class-ResultSet-RecursiveUpdate;a=blobdiff_plain;f=t%2Flib%2FRunTests.pm;h=53d3c6b174809bbebdf4bfc4fc0dbb844694cefc;hp=3ba2afc055cde3cafb152faaac33d0f8106bba51;hb=861d0d247104ba5d9a05184728e19f1516521396;hpb=052ba095d490f76c1f57ea0834a3957c97e6d7a3 diff --git a/t/lib/RunTests.pm b/t/lib/RunTests.pm index 3ba2afc..53d3c6b 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 => 40; 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', @@ -76,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 => { @@ -96,16 +96,28 @@ 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' ); - # repeatable + $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 = { name => 'temp name', @@ -133,6 +145,75 @@ 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' ); + + @tags = $schema->resultset( 'Tag' )->search(); + $dvd_updated = DBIx::Class::ResultSet::RecursiveUpdate::Functions::recursive_update( + resultset => $schema->resultset( 'Dvd' ), + updates => { + id => $dvd->dvd_id, # id instead of dvd_id + tags => [ { id => $tags[0]->id, file => 'file0'}, { id => $tags[1]->id, file => 'file1' } ], + } + ); + $tags[$_]->discard_changes for 0 .. 1; + is( $tags[0]->file, 'file0', 'file set in tag' ); + is( $tags[1]->file, 'file1', 'file set in tag' ); + my @rel_tags = $dvd_updated->tags; + is( scalar @rel_tags, 2, 'tags related' ); + ok( $rel_tags[0]->file eq 'file0' || $rel_tags[0]->file eq 'file1', 'tags related' ); + + # $updates = { # name => 'Test name 1', # };