From ceef2f6e064b545522595546f975248c64c04c63 Mon Sep 17 00:00:00 2001 From: "G. Richardson" Date: Wed, 4 Oct 2017 10:00:35 +0200 Subject: [PATCH] Business - Rose relationships customers und vendors --- SL/DB/Business.pm | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/SL/DB/Business.pm b/SL/DB/Business.pm index 25a553656..91cdd672a 100644 --- a/SL/DB/Business.pm +++ b/SL/DB/Business.pm @@ -5,6 +5,21 @@ use strict; use SL::DB::MetaSetup::Business; use SL::DB::Manager::Business; +__PACKAGE__->meta->add_relationship( + customers => { + type => 'one to many', + class => 'SL::DB::Customer', + column_map => { id => 'business_id' }, + query_args => [ \' id IN ( SELECT id FROM customer ) ' ], + }, + vendors => { + type => 'one to many', + class => 'SL::DB::Vendor', + column_map => { id => 'business_id' }, + query_args => [ \' id IN ( SELECT id FROM vendor ) ' ], + }, +); + __PACKAGE__->meta->initialize; sub validate { -- 2.20.1