On Thu, Apr 29, 2010 at 12:49:30PM -0700, Bill Moseley wrote: > On Wed, Apr 28, 2010 at 7:27 AM, Matt S Trout <[email protected]> wrote: > > > > For that to happen the $session_attendee needs to be specific to a given > > > session (Session id is stored with the $session_attendee instance). > > > > You just answered your own question. > > > > You want a result from the many-many link table and to traverse from there, > > since that table has (session_id, attendee_id). > > > > That seems to reason, yes. Sadly, I'm not seeing the implementation so I > ask for a bit more help. > > Again, what I'm after is: > > $session_one = $schema->resultset( 'Session' )->find( 1 ); > > $session_one_attendees = $session_one->attendees; > $first_user_session_one_notes = $session_one_attendees->first->notes;
Again, no it isn't. You need to expose the link entry directly and add relationships to it, and you need to add methods to *there* - proxy => on the belongs_to across to Attendee will let you proxy the Attendee things. Then you end up with an object that you can -treat- as an Attendee but is actually an AttendeeWithSession - i.e. a SessionAttendee - i.e. a member of the many-many link class. -- Matt S Trout - Shadowcat Systems - Perl consulting with a commit bit and a clue http://shadowcat.co.uk/blog/matt-s-trout/ http://twitter.com/shadowcat_mst/ Email me now on mst (at) shadowcat.co.uk and let's chat about how our Catalyst commercial support, training and consultancy packages could help your team. _______________________________________________ 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]
