2009/6/17 Jason Galea <[email protected]>:
> Hi Dave,
>
> package DB::Film;
>
> ...
>
> # has many actors
> __PACKAGE__->has_many('film_actor_maps' => 'DB::FilmActorMap', 'product');
> __PACKAGE__->many_to_many('actors' => 'film_actor_maps', 'actor');
>
> __PACKAGE__->belongs_to('director' => 'DB::Director');
I'd do it the other way around:
package DB::Actor;
...
# Has many films
__PACKAGE__->has_many('actor_film_maps' => 'DB::FilmActorMap', 'product');
__PACKAGE__->many_to_many('films' => 'actor_film_maps', 'film');
my $rs = $actor->films->search(director => 39);
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
