On Wed, Aug 21, 2013 at 1:52 PM, Bill Moseley <[email protected]> wrote:
> I have a table with a self-referencing parent column. The depth of any
> hierarchy is limited so I can write a join to fetch all the parents.
>
> For example, if the table folder has a parent column:
>
> select
> f.id,
> p0.id as parent0,
> p1.id as parent1,
> p2.id as parent2
> from
> folder f
> left join folder p0 on p0.id = f.parent
> left join folder p1 on p1.id = p0.parent
> left join folder p2 on p2.id = p1.parent
> where
> f.id = ?
>
>
> I know I can specify a join multiple times
>
> join => [ 'parent', 'parent', 'parent' ]
>
> and DBIC will create separate aliases but they all join to the same "base"
> table. But, I need to join like above.
>
> Is there a way to specify these joins or do I need to use a virtual view?
>
Did you try join => { parent => { parent => 'parent' } } ?
Rob
_______________________________________________
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]
