X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=t%2Fdb_helper%2Frecord_links.t;h=e063b33a1d068c2a272e488dcbf8cb0e3a91d4a0;hb=9c1e389807fe1e1fbadbcffcdd3332b841fc9035;hp=856277644619a41220f0a6be87ba3bce63fc0752;hpb=964cc586548d39408468696e96c4aa0be1c547d3;p=kivitendo-erp.git diff --git a/t/db_helper/record_links.t b/t/db_helper/record_links.t index 856277644..e063b33a1 100644 --- a/t/db_helper/record_links.t +++ b/t/db_helper/record_links.t @@ -1,4 +1,4 @@ -use Test::More; +use Test::More tests => 49; use strict; @@ -9,6 +9,7 @@ use Carp; use Data::Dumper; use Support::TestSetup; use Test::Exception; +use List::Util qw(max); use SL::DB::Buchungsgruppe; use SL::DB::Currency; @@ -113,6 +114,9 @@ is $link->to_table, 'ar', 'to_table'; is $link->to_id, $i->id, 'to_id'; # retrieve link +$links = $o1->linked_records; +is $links->[0]->id, $i->id, 'simple retrieve'; + $links = $o1->linked_records(direction => 'to', to => 'Invoice'); is $links->[0]->id, $i->id, 'direct retrieve 1'; @@ -164,7 +168,10 @@ $i = new_invoice(); $o2->link_to_record($d); $d->link_to_record($i); - +# at this point the structure is: +# +# o1 <--> o2 ---> d ---> i +# $links = $d->linked_records(direction => 'both', to => 'Invoice', from => 'Order', sort_by => 'customer_id', sort_dir => 1); is $links->[0]->id, $o2->id, 'both with different from/to 1'; @@ -178,6 +185,10 @@ $links = $o2->linked_records(direction => 'to', to => 'DeliveryOrder'); is @$links, 1, 'double link is only added once 1'; $d->link_to_record($o2, bidirectional => 1); +# at this point the structure is: +# +# o1 <--> o2 <--> d ---> i +# $links = $o2->linked_records(direction => 'to', to => 'DeliveryOrder'); is @$links, 1, 'double link is only added once 2'; @@ -186,6 +197,11 @@ is @$links, 1, 'double link is only added once 2'; $links = $o2->linked_records(direction => 'both'); is @$links, 2, 'links without from/to get all'; +# doc states you can limit with direction when giving excess params +$links = $d->linked_records(direction => 'to', to => 'Invoice', from => 'Order'); +is $links->[0]->id, $i->id, 'direction to limit params 1'; +is @$links, 1, 'direction to limit params 2'; + # doc says there will be special values set... lets see $links = $o1->linked_records(direction => 'to', to => 'Order'); is $links->[0]->{_record_link_direction}, 'to', '_record_link_direction to'; @@ -195,11 +211,13 @@ $links = $o1->linked_records(direction => 'from', from => 'Order'); is $links->[0]->{_record_link_direction}, 'from', '_record_link_direction from'; is $links->[0]->{_record_link}->to_id, $o1->id, '_record_link from'; -# check if bidi returns an array of links -{ local $TODO = 'does not work as advertised'; +# check if bidi returns an array of links even if aready existing my @links = $d->link_to_record($o2, bidirectional => 1); +# at this point the structure is: +# +# o1 <--> o2 <--> d ---> i +# is @links, 2, 'bidi returns array of links in array context'; -} # via $links = $o2->linked_records(direction => 'to', to => 'Invoice', via => 'DeliveryOrder'); @@ -213,15 +231,16 @@ is $links->[0]->id, $i->id, 'simple case via links (2 hops)'; # multiple links in the same direction from one object $o1->link_to_record($d); -$links = $o2->linked_records(direction => 'to', to => 'Invoice', via => 'DeliveryOrder'); -is $links->[0]->id, $i->id, 'simple case via links (string)'; - # at this point the structure is: # -# o1 <--> o2 ---> d ---> i +# o1 <--> o2 <--> d ---> i # \____________,^ # +$links = $o2->linked_records(direction => 'to', to => 'Invoice', via => 'DeliveryOrder'); +is $links->[0]->id, $i->id, 'simple case via links (string)'; + + # o1 must have 2 linked records now: $links = $o1->linked_records(direction => 'to'); is @$links, 2, 'more than one link'; @@ -272,6 +291,22 @@ is_deeply $sorted, [$o2, $i, $o1, $d], 'sorting by transdate'; $sorted = SL::DB::Helper::LinkedRecords->sort_linked_records('date', 0, @records); is_deeply $sorted, [$d, $o1, $i, $o2], 'sorting by transdate desc'; -done_testing(); +# now recursive stuff 2, with backlinks +$links = $o1->linked_records(direction => 'to', recursive => 1, save_path => 1); +is @$links, 4, 'recursive finds all 4 (backlink to self because of bidi o1<->o2)'; + +# because of the link o1->d the longest path should be legth 2. test that +is max(map { $_->{_record_link_depth} } @$links), 2, 'longest path is 2'; + +$links = $o2->linked_records(direction => 'to', recursive => 1); +is @$links, 4, 'recursive from o2 finds 4'; + +$links = $o1->linked_records(direction => 'from', recursive => 1, save_path => 1); +is @$links, 3, 'recursive from o1 finds 3 (not i)'; + +$links = $i->linked_records(direction => 'from', recursive => 1, save_path => 1); +is @$links, 3, 'recursive from i finds 3 (not i)'; +$links = $o1->linked_records(direction => 'both', recursive => 1, save_path => 1); +is @$links, 4, 'recursive dir=both does not give duplicates'; 1;