aidask/yii-closure-table-behavior

ActiveRecord model behavior that allows to work with tree data.

Yii Closure Table behavior

Extension allows managing trees stored in database., _(*1)

Configuration

Add behavior to model as follows:, _(*2)

public function behaviors()
{
    return array(
        'closureTableBehavior'=>array(
            'class'=>'ext.ClosureTableBehavior',
            'closureTableName'=>'table_name',
        )
    );
}

Examples

Model configuration: /tests/models/Folder.php, _(*3)

Schema example: /tests/schema/db.sql, _(*4)

Behavior usage: /tests/unit/ClosureTableBehaviorTest.php, _(*5)

Contribution

Your participation to Yii Closure Table behavior development is very welcome!, _(*6)

To ensure consistency throughout the source code, keep these rules in mind as you are working: * All features or bug fixes must be tested by one or more specs. * Your code should follow PSR-2 coding style guide, _(*7)

Literature:

http://www.slideshare.net/billkarwin/models-for-hierarchical-data, _(*8)

http://www.mysqlperformanceblog.com/2011/02/14/moving-subtrees-in-closure-table/, _(*9)