Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Re: DBIx::Class - shortcutting relationships

by Your Mother (Bishop)
on Oct 04, 2012 at 18:42 UTC ( #997289=note: print w/replies, xml ) Need Help??

in reply to DBIx::Class - shortcutting relationships [resolved]

many_to_many detailed in DBIx::Class::Relationship is what you want, I think. FWIW, it sounds like your data is set-up well. Refactoring the tables for this would be a mistake. Fake, untested code for your case–

{ package MyApp::Schema::Result::League; # ... __PACKAGE__->has_many( league_teams => "MyApp::Schema::Result::Lea +gueTeam", "league" ); __PACKAGE__->many_to_many( teams => "league_teams", "team" ); # ... } { package MyApp::Schema::Result::Team; __PACKAGE__->has_many( league_teams => "MyApp::Schema::Result::Lea +gueTeam", "team" ); __PACKAGE__->many_to_many( leagues => "league_teams", "league" ); # ... } { package MyApp::Schema::Result::LeagueTeam; # ... __PACKAGE__->belongs_to( league => "MyApp::Schema::Result::League" + ); __PACKAGE__->belongs_to( team => "MyApp::Schema::Result::Team" ); # ... }

Replies are listed 'Best First'.
Re^2: DBIx::Class - shortcutting relationships
by cLive ;-) (Prior) on Oct 04, 2012 at 18:48 UTC
    Yeah, thanks. About 10 minutes after I posted it I worked it out. I was so wrapped up in a detail that I didn't think to look up many to many. Heh.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://997289]
and John Coltrane plays...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (2)
As of 2018-05-27 18:33 GMT
Find Nodes?
    Voting Booth?