[Dbix-class] more complex relationships

[Jonas Alves]

On Friday 24 March 2006 14:21, Matt S Trout wrote:
> Jess Robinson wrote:
> > I'd still like to see the DBIx::Class code..
> >
> > So, if I read it correctly now, from sale_item, which has a sale_id and a
> > product_d, you want to get the entry in vendor_product?
> >
> > $schema->resultset('VendorProduct')->find({vendor_name =>
> >                                     $saleitem->sale->vendor_name,
> >                                    product_id =>
> >                                      $saleitem->product_id});
> > ?
> >
> > .. so it wants a sort of infinite level relationship search similar to
> > how we do it with joins already?
>
> I think what we're basically looking at here is a relationship that's only
> valid on a sort-of-a-view across two tables. So something like
>
> ->add_relationship('vendor_product', 'My::VendorProduct', {
> 'foreign.vendor_name' => 'self.sale.vendor_name', foreign.product_id =>
> 'self.product_id' });
>

I also need relationships based in column constant values. eg:

->add_relationship('vendor_product', 'My::VendorProduct', {
 'foreign.product_id' => 'self.product_id',
 'self.product_reference' => '123'
});

--Jonas