[Catalyst] Users hierarchy

[Jonathan Rockway]

* On Wed, Jun 04 2008, jakac wrote:
> I checked out DBIx::OO::Tree also but using this module would mean
> that I would have to change my table schema (add columns parent,lft,rgt,mvg)..
> I don't see why this is necessary since the whole thing needs only two colums -
> user_id and parent_id ...? If I know a user_id then I can always get all users
> where their parent_id = this_user_id etc.
>
> Like I said in my previous postings - I really don't want to change my database
> schema because a lot of other applications depend on it. There is no problem
> adding columns lft,rgt and mvg but if I change my primary key from
> "user_id" to "id" and change my column "parent_id" to "parent" like this module
> requires it would mean changing a lot of other older applications which depend
> on this database...
>

What about DBIx::Class::Tree?  I've used this for a user hierarchy,
actually.

Regards,
Jonathan Rockway

-- 
print just => another => perl => hacker => if $,=$"