umbrellio/laravel-ltree

Extension LTree (Postgres) for Laravel

7.4.2 2023-12-22 07:24 UTC

Requires

• php: ^7.3|^7.4|^8.0|^8.1
• doctrine/dbal: ^2.9|^3.0
• laravel/framework: ^5.8|^6.20.26|^7.0|^8.40|^9.0|^10.0
• umbrellio/laravel-common-objects: ^2.3
• umbrellio/laravel-pg-extensions: ^5.0

Requires (Dev)

• orchestra/testbench: ^3.5|^6.0
• php-coveralls/php-coveralls: ^2.1
• squizlabs/php_codesniffer: ^3.5
• umbrellio/code-style-php: ^1.0

MIT

• Korben Dallas

• php
• tree
• postgresql
• postgres
• laravel
• ltree
• pg
• ltree-extension

README

LTree Extension (PostgreSQL) for Laravel.

Installation

Run this command to install:

php composer.phar require umbrellio/laravel-ltree

How to use

Implement your Eloquent\Model from LTreeModelInterface and use LTreeModelTrait.

Use LTreeService for build path:

1. when create model: createPath(LTreeModelInterface $model)
2. when update model: updatePath(LTreeModelInterface $model) for update path for model and children
3. when delete model: dropDescendants(LTreeModelInterface $model) for delete children models

The get() method returns LTreeCollection, instead of the usual Eloquent\Collection.

LTreeCollection has a toTree() method that converts a flat collection to a tree.

LTreeResourceCollection & LTreeResource, which take LTreeCollection as an argument, will also be useful.

Authors

Created by Korben Dallas.