[Dbix-class] many_to_many and search_related

[Matt S Trout]

Rolf Schaufelberger wrote:
> Hi, 
> I'm currently trying to move my application from CDBI to Dbix::Class.
> 
> Now I have a many_to many relationship and I want to do a search on the 
> related table as described in the pod. yet I get an errror:
> 
> DBIx::Class::Relationship::Base::search_related(): No such relationship motive 
> at t/05_format.t line 26
> 
> yet, doing fetching all objects works for both directions,
> 
> the lines are : 
> PW::DB::Format.pm :
> 
> ...
> __PACKAGE__->has_many(mformate   => 'PW::DB::MFormat', 'format_id');
> __PACKAGE__->many_to_many('motive' => 'mformate', 'motiv_id');
> 
> 
> PW::DB::Motiv.pm :
> ...
> __PACKAGE__->has_many( mformate  => 'PW::DB::MFormat', 'motiv_id');
> __PACKAGE__->many_to_many('formate' => 'mformate', 'format_id');

many-many is a bridge across two relationships.

$obj->motive

is pretty much equivalent to

$obj->search_related('mformate')->search_related('motiv_id')

-- 
      Matt S Trout       Offering custom development, consultancy and support
   Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +