From f6641f7ade5a9b4227feef8a538228fcea80a5b2 Mon Sep 17 00:00:00 2001 From: zby Date: Mon, 4 May 2009 22:30:59 +0000 Subject: [PATCH] might_have with non pk fk --- lib/DBIx/Class/ResultSet/RecursiveUpdate.pm | 19 ++++++++---- t/lib/DBSchema.pm | 2 +- t/lib/DBSchema/Result/Address.pm | 32 ++++++++++++++++++++ t/lib/DBSchema/Result/User.pm | 6 ++++ t/lib/RunTests.pm | 16 +++++++++- t/sqlite.t | 2 +- t/var/dvdzbr.db | Bin 19456 -> 37888 bytes 7 files changed, 68 insertions(+), 9 deletions(-) create mode 100644 t/lib/DBSchema/Result/Address.pm diff --git a/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm b/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm index ca6a40d..884cf05 100644 --- a/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm +++ b/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm @@ -30,8 +30,6 @@ sub recursive_update { if ( blessed($updates) && $updates->isa('DBIx::Class::Row') ) { return $updates; } - - # direct column accessors my %columns; @@ -76,7 +74,7 @@ sub recursive_update { } $object ||= $self->new( {} ); -# first update columns and other accessors - so that later related records can be found + # first update columns and other accessors - so that later related records can be found for my $name ( keys %columns ) { $object->$name( $updates->{$name} ); } @@ -85,7 +83,6 @@ sub recursive_update { _update_relation( $self, $name, $updates, $object, $info ); } # $self->_delete_empty_auto_increment($object); - # don't allow insert to recurse to related objects - we do the recursion ourselves # $object->{_rel_in_storage} = 1; $object->update_or_insert; @@ -151,8 +148,18 @@ sub _update_relation { else { my $sub_updates = $updates->{$name}; $sub_updates = { %$sub_updates, %$resolved } if $resolved && ref( $sub_updates ) eq 'HASH'; - my $sub_object = - recursive_update( resultset => $related_result, updates => $sub_updates ); + my $sub_object; + if( $info->{attrs}{accessor} eq 'single' && defined $object->$name ){ + $sub_object = recursive_update( + resultset => $related_result, + updates => $sub_updates, + object => $object->$name + ); + } + else{ + $sub_object = + recursive_update( resultset => $related_result, updates => $sub_updates ); + } $object->set_from_related( $name, $sub_object ); } } diff --git a/t/lib/DBSchema.pm b/t/lib/DBSchema.pm index f44ee45..e729155 100644 --- a/t/lib/DBSchema.pm +++ b/t/lib/DBSchema.pm @@ -15,7 +15,7 @@ sub get_test_schema { $dsn ||= 'dbi:SQLite:dbname=t/var/dvdzbr.db'; warn "testing $dsn"; my $schema = __PACKAGE__->connect( $dsn, $user, $pass, {} ); - $schema->deploy({ }); + $schema->deploy({ add_drop_table => 1, }); $schema->populate('User', [ [ qw/username name password / ], [ 'jgda', 'Jonas Alves', ''], diff --git a/t/lib/DBSchema/Result/Address.pm b/t/lib/DBSchema/Result/Address.pm new file mode 100644 index 0000000..e5a36ba --- /dev/null +++ b/t/lib/DBSchema/Result/Address.pm @@ -0,0 +1,32 @@ +package DBSchema::Result::Address; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("Core"); +__PACKAGE__->table("address"); +__PACKAGE__->add_columns( + "address_id", + { data_type => "INTEGER", is_auto_increment => 1, + is_nullable => 0 }, + "user_id", + { data_type => "INTEGER", is_nullable => 0 }, + "street", + { data_type => "VARCHAR", is_nullable => 0, size => 32 }, + "city", + { data_type => "VARCHAR", is_nullable => 0, size => 32 }, + "state", + { data_type => "VARCHAR", is_nullable => 0, size => 32 }, +); +__PACKAGE__->set_primary_key("address_id"); + +__PACKAGE__->belongs_to( + 'user', + 'DBSchema::Result::User', + 'user_id', +); + + +1; diff --git a/t/lib/DBSchema/Result/User.pm b/t/lib/DBSchema/Result/User.pm index b8f53a5..363271d 100644 --- a/t/lib/DBSchema/Result/User.pm +++ b/t/lib/DBSchema/Result/User.pm @@ -38,5 +38,11 @@ __PACKAGE__->has_many( ); __PACKAGE__->many_to_many('roles', 'user_roles' => 'role'); +__PACKAGE__->might_have( + "address", + "DBSchema::Result::Address", + { 'foreign.user_id' => 'self.id' } +); + 1; diff --git a/t/lib/RunTests.pm b/t/lib/RunTests.pm index 4557e01..fd4fe71 100644 --- a/t/lib/RunTests.pm +++ b/t/lib/RunTests.pm @@ -9,7 +9,7 @@ use Test::More; sub run_tests{ my $schema = shift; - plan tests => 28; + plan tests => 29; my $dvd_rs = $schema->resultset( 'Dvd' ); my $user_rs = $schema->resultset( 'User' ); @@ -133,6 +133,20 @@ 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" + } + }; + $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' ); + + # $updates = { # name => 'Test name 1', # }; diff --git a/t/sqlite.t b/t/sqlite.t index 2d2a041..ca3e72e 100644 --- a/t/sqlite.t +++ b/t/sqlite.t @@ -5,7 +5,7 @@ use DBSchema; use RunTests; use Test::More; -unlink 't/var/dvdzbr.db'; +#unlink 't/var/dvdzbr.db'; my $schema = DBSchema::get_test_schema(); run_tests( $schema ); diff --git a/t/var/dvdzbr.db b/t/var/dvdzbr.db index 318983a2c0da7f687115882d1ffb28ea29b02613..73c1fcd598d63602623953b284c2cc14118a6dae 100644 GIT binary patch literal 37888 zcmeHQ|8Eq>6`$F6dwV|W&~P}1L8tIZ>s#fGT`a{((kt+2c=pWEjtrXN>iWDiLRU=htrABR41r*Uhf9ac<-Sw`0 zXB?#VlWyHH&wAAbyKauM1mm1NZ<>s;@8efoPvDp1 z_j%t(PhNtyp-V?DfLnrhKl~T&z%BUKh7zu2nn@2fLtrVTh#Y@G4TfAJTFL@{^WnHls96#4&(_90F zFhfDGyo8Y*&+tYjmf755wdz#rg;}p!^_HBfpRwLF<7UiZA*&;;Miq=~Cd1!+scz4f z9fd=}&v<(5g_Gk-+_Y)BMFeJg{F~!b=IN=4$+4*!^QG|_^VG}J=BZaso*Y0HA%l6z zuFjpatGWE}uqBA@LU9)1UPJemDo)jOD|Kfc{b)9;YZ)+!+~%r|U3a}op=jg3pK$8# zf+J$=a$P{PnjAi;AeXdN){N}29^Nn{%673>b!s*FAF)`&EZkzjr}-YlfL@1R;Os}6 zIX^F}afTb&o*w?j_awyethE@_VOk+hSgrfQ?w1tuMX{{atBzAQUmcq|_Tt!7Zgj+o zL+#d=TSnIE0?b#(usLl%fX<#n=zL)SosPYo=yLcI!w+4A03pye2<+oY#t(My*7L)8 zbJBJz<{9}La@s2{R!XOwC3D8BmeMFMhkFb^THATYv=9!$mn6<8R%eLDrU+#Uqj*{;JdXBW+~$IImbNiIMs8D zIM%9S^wXR_$2-_WhVxOzPP=mzcdleE;?THi){*%|yE5-q=FKT@u7vCyMuvw+2Z!^6 z`NQVO=+XSh(c!#!|EJ(R27iT{@E&{u|Avp?9(+KLo)91eHYEZHU_2!pL%iY>NfFdV zkSC-I($$0uT($q#8T<@BfZxEc;1}?FcneB{cE zmK0%4_Wwcl{~^-<=W_lJ_`8h1tNj$Vg@4!J&2_}RD)gX@lGKAa^A9tRzR*fCJ^fA28(6h6k8|G%IX z;09cWcOEhEs5*oIAYIvn^3_P;av|gh?RzD~T0UT8ySsT~GO+2b+w+(P-E?f2rD$@Lg~6u7 zC`{9o9vfa^;sFymaa?sUm&`ub-D+H=3M}N6ziq}sM7#OLKy1uHTH#`}kQ;B6+qqi$ zwTwOj7$FBz*36fiXDw1jvwo~q)+>zBtdVLpk_U}!e?M=Wk?@vXG-EDQyt-411h>b4 zjzmbb)%`{csztUj%js~Co3_3?U}Pt-9$ATBqznmSP)0!pBC%hLi5!V&l1#`R;V^UR z#w}Xv{qN8J3EjV#1El%C;CGLFLSR!NAZGhga{ezR=l={j|7XbgzeJPyzp(wQwtr8y z{!eKBe^Whlsw^SkBOuy8$o8*A=Kt5)|A4grQT=}o|6ur`ix40L+7^MGNnk@b3_(j| z9F3T`wzD$t6vg}BU;necZAB-+2mwN16#}BCkW8xezjqkiSrtvUga9GXrU;}su&gaE z(f)DM54s2eLSPFbAlg5mxj$O}eneLPTks!%L~ct29)kqy>$Def-ypl}+Lg4HVBMX? zs*T%xrMU>tc?(W)S@r*KF||EcTS7rX5dwrjfIuh5<%8jJLb?8j!^aFibP)oCK$|15 zJ<-b}%|E(_=ROp@AHQOiOdo6T9|$NK@B~^X4e>^gv`%VtJ}%dpG%iY`DSuN&-`g28 zmJ-CVu4ML=p;l&Of+OFZ%#QcA;*iT*s$SVCi>NHB6v~gn605=8QPa=+F0pd= z7{XHYVJxvK_ePfo(Gsgxn}Y`Xe>PiUrSyNd8Qd1Foi0Lv5NK}%#P%U8{eLz7zl-bt z+FNRpju0ROA_%DUfByLYQ(XTSiK8GPKnS!o0&4xA+W*J5|7&Y`NjO4)5Qrim?ElpM zKRR4M`+wZ|v+9?p=I$#0n9VjTRw!qvu#gc3mkA$;}=c&niO(dmi_M$;3)R!bS^{9kFOZ;vmbj zF4nZ}T&}0BM(6NnF`K}{Ol8Sp1D!QlhcbvV@JWnpXk#Cl&w%8|?R^IG>*@4;bB;pZ z4|I7WXaIpa{cX|)B!~{SO%*i^&S3T9vN7|A^%4m42R~kIohov(8hb{K>=0U=C6VAvJwJu z1jzm;jtAWl0$TzBW&fiq`(LvE*%Hs3gd_xf1eE=c?%V&}!}Grg8bW{&*g6OZ`yXom zTjzO`q=Y~efff6|4%W-qRsIbB9siGZPWvOAg=&Vjfc9#^59{qlzT%dArvAEe9kr0M_U&t jiwMgJ1D|&d^)rvq8tSjFr*92bE{Dfdy3aneHPrtDbeEho delta 636 zcmZoz!PGE=ae}m<9s?@io~UCZ!pQs^B+A45oADZBE+Zqu6lV5`juN8T?Cj#g!i>B5?X){FCoYl42B^9H5ZTrYpcE?kGK3R!?HGLzsZF zFfbfg8hL>sC@sy{SO|%^@_b+%6qi6K&dDvM#jKoQUAE;4lV!>{ShyPHxF*jm(_`eF ze4?y?k$ZANh{EK^as_d|Mr|H&JTyTPL1}Rj5b;l5JYg14t=&X9MuEw(6Ej%(*u-7s Y!H$?0BEl%RD28KG1`E$-mWDs<0E<7YO8@`> -- 2.43.0