Jam Materialized Path

, _(*1)

Materialized path nesting for Jam ORM models, _(*2)

Usage

Add this behaviors your Model, _(*3)

class Model_Category extends Jam_Model {

    public static function initialize(Jam_Meta $meta)
    {
        $meta
            ->behaviors(array(
                'materializedpath' => Jam::behavior('materializedpath')
            ));
    }
}

Database Table:, _(*4)

┌─────────────────────────┐
│ Table: Category         │
├─────────────┬───────────┤
│ id          │ ingeter   │
│ name        │ string    │
│ parent_id*  │ integer   │
│ path*       │ string    │
└─────────────┴───────────┘
* Required fields

Methods

It will add "parent" and "children" associations to the repo. The model will get the convenience methods:, _(*5)

Method	Description
decendents()	Get a query builder collection for all the decendents
ansestors()	Get a query builder collection for all the ansestors
is_root()	Boolean check if it is root (has parent) or not
is_descendent_of(Jam_Model $parent)	Chech if a model is descendant
is_ansestor_of(Jam_Model $child)	Chech if model is ansestor
depth()	The depth of the item in the hierarchy