view-components / eloquent-data-processing
Eloquent ORM support for ViewComponents
Installs: 46 942
Dependents: 2
Suggesters: 0
Security: 0
Stars: 19
Watchers: 2
Forks: 2
Open Issues: 1
Requires
- php: ^5.5||^7||^8
- view-components/view-components: ^0.24.2||^0.25||^0.26.6
Requires (Dev)
This package is auto-updated.
Last update: 2024-11-06 23:42:25 UTC
README
Eloquent ORM support for ViewComponents
Table of Contents
Requirements
- PHP 5.5+ (hhvm & php7 are supported)
Installation
The recommended way of installing the component is through Composer.
Run following command:
composer require view-components/eloquent-data-processing
Usage
Creating Data Provider
EloquentDataProvider supports 3 types of data sources:
- Illuminate\Database\Eloquent\Builder instance (database query builder created from model)
- Illuminate\Database\Query\Builder instance (standard database query builder, don't know about models)
- Class name of Eloquent model
Using Class Name of Eloquent Model as Data Source
use MyApp\UserModel; use ViewComponents\Eloquent\EloquentDataProvider; $provider = new EloquentDataProvider(UserModel::class);
If you use class name of Eloquent model as data source, the only way to modify database query is specifying data provider operations:
use ViewComponents\ViewComponents\Data\Operation\FilterOperation; $provider->operations()->add( new FilterOperation('role', FilterOperation::OPERATOR_EQ, 'Manager') );
Using Illuminate\Database\Eloquent\Builder as Data Source
use ViewComponents\Eloquent\EloquentDataProvider; $provider = new EloquentDataProvider((new MyApp\UserModel)->newQuery());
It's possible to specify query parts before creating EloquentDataProvider but note that some parts of query may be changed by data provider operations.
use ViewComponents\Eloquent\EloquentDataProvider; $query = MyApp\UserModel ::where('role', '=', 'Manager') ->where('company', '=', 'Facebook') ->orderBy('id'); $provider = new EloquentDataProvider($query);
Using Illuminate\Database\Query\Builder as Data Source
It's possible to use EloquentDataProvider if you not deal with Eloquent models.
use DB; use ViewComponents\Eloquent\EloquentDataProvider; $provider = new EloquentDataProvider( DB::table('users')->where('name', '=', 'David') );
Data Provider Operations
Eloquent Data provider modifies database query when it has operations.
Use operations() method for accessing operations collection.
Documentation related to collections can be found here.
Example of adding operation:
$provider ->operations() ->add(new SortOperation('id', SortOperation::ASC));
Also operations can be specified on data provider creation:
use MyApp\UserModel; use ViewComponents\Eloquent\EloquentDataProvider; use ViewComponents\ViewComponents\Data\Operation\FilterOperation; $provider = new EloquentDataProvider( UserModel::class [ new FilterOperation('role', FilterOperation::OPERATOR_EQ, 'Manager') new SortOperation('id', SortOperation::DESC), ] );
Extracting data
Data providers implements IteratorAggregate interface, so you can iterate it like array:
use MyApp\UserModel; use ViewComponents\Eloquent\EloquentDataProvider; $provider = new EloquentDataProvider(UserModel::class); foreach ($provider as $user) { var_dump($user); // instance of UserModel }
Data provider executes DB query when getIterator() method is called or when iteration begins in case if data is not loaded yet, i. e. calling getIterator() twice will not produce 2 database queries. But changing operations collection will cause resetting cache:
use MyApp\UserModel; use ViewComponents\Eloquent\EloquentDataProvider; use ViewComponents\ViewComponents\Data\Operation\FilterOperation; $provider = new EloquentDataProvider(UserModel::class); // databse query will be executed $provider->getIterator(); // databse query will not be executed again, iterating over same data $provider->getIterator(); $provider->operations->add( new FilterOperation('id', FilterOperation::OPERATOR_LTE, 5) ) // databse query will be executed again $provider->getIterator();
Contributing
Please see Contributing Guidelines and Code of Conduct for details.
Testing
This package bundled with unit tests (PHPUnit).
To run tests locally, you must install this package as stand-alone project with dev-dependencies:
composer create-project view-components/eloquent-data-processing
Command for running tests:
composer test
Security
If you discover any security related issues, please email mail@vitaliy.in instead of using the issue tracker.
License
© 2015 — 2016 Vitalii Stepanenko
Licensed under the MIT License.
Please see License File for more information.