[Dbix-class] relationship with additional constraints?

[Matt S Trout]

On Fri, May 18, 2018 at 09:52:09AM +0200, Stuart Dodds wrote:
> On 17/05/18 22:25, Matt S Trout wrote:
> > Surely http://p3rl.org/DBIx::Class::ParameterizedJoinHack is exactly
> > what's needed here - just use it on a belongs_to rel with a join_type of
> > left so non-matching entries are still returned, then prefetch that rel?
> > 
> > (ironic since I'm replying to the man who was kind enough to sponsor Shadowcat
> > to develop that module in the first place :)
> > 
> 
> Yes, I tried it yesterday and it is (almost) exactly what I need, thank you!
> 
> I say "almost" because my use case actually calls for a might_have relationship (rather than has_many) but it is easy enough to ->first off the entry in the rs.

Hmm. So, the only reason there's only a has_many there is because I didn't
really have any "good" use cases for belongs_to at the time.

I wouldn't be averse to adding the feature if you can write up a test for
it.

-- 
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 CPAN
commercial support, training and consultancy packages could help your team.