[Dbix-class] $c->stash for complex/cascaded relationship bridges

Peter Rabbitson rabbit+dbic at rabbit.us
Sat Jan 21 13:29:34 GMT 2012


Roland Philibert wrote:
> Hello all.
> 
> I have the following situation in my database where table3 and table5 are acting as relationship bridges between a common table2:
> table1-><-table3-><-table2-><-table5-><-table4>
> 
> So for correlated queries and for a given primary key in table1, how does one retrieve resultset(s) to stash to content in order to get all related columns of table4 for each related object of table2?
> What would be the recommended/simplest way of doing this?
> Any examples greatly appreciated.
> 
> Hope this make sense.
> Many thanks in advance.

This is a rather open-ended question. Could you show what
have you tried, also some (perhaps pseudo-sql) examples of
of what exactly you want to retrieve?

Cheers



More information about the DBIx-Class mailing list