Download the PHP package acdevelopers/l5-repository-slim without Composer

Laravel 5 Repositories Slim

Laravel 5 Repositories Slim is a trimmed down version of Anderson Andrade's andersao/l5-repository used to abstract the data layer. Always thought the original package had a little more than what i needed not to mention some its features already come right out of the box with newer versions of Laravel. So everthing is still the same only i've removed Validator, Presenter and Transformer, figured they could be substituted with Laravel's FormRequest and Resource classes.

You want to know a little more about the Repository pattern? Read this great article.

Table of Contents

• Installation
  • Composer
  • Laravel
• Methods
  • RepositoryInterface
  • RepositoryCriteriaInterface
  • CacheableInterface
  • CriteriaInterface
• Usage
  • Create a Model
  • Create a Repository
  • Generators
  • Use methods
  • Create a Criteria
  • Using the Criteria in a Controller
  • Using the RequestCriteria
• Cache
  • Usage
  • Config
• Credits
• Licence

Installation

Composer

Execute the following command to get the latest version of the package:

Laravel

>= laravel5.5

ServiceProvider will be attached automatically

Other

In your config/app.php add AcDevelopers\Repository\Providers\RepositoryServiceProvider::class to the end of the providers array:

If Lumen

Publish Configuration

Methods

AcDevelopers\Repository\Contracts\RepositoryInterface

• all($columns = array('*'))
• first($columns = array('*'))
• firstOrNew(array $attributes = [])
• firstOrCreate(array $attributes = [])
• paginate($limit = null, $columns = ['*'])
• find($id, $columns = ['*'])
• findByField($field, $value, $columns = ['*'])
• findWhere(array $where, $columns = ['*'])
• findWhereIn($field, array $where, $columns = [*])
• findWhereNotIn($field, array $where, $columns = [*])
• create(array $attributes)
• update(array $attributes, $id)
• updateOrCreate(array $attributes, array $values = [])
• delete($id)
• deleteWhere(array $where)
• orderBy($column, $direction = 'asc');
• with(array $relations);
• has(string $relation);
• whereHas(string $relation, closure $closure);
• hidden(array $fields);
• visible(array $fields);
• scopeQuery(Closure $scope);
• getFieldsSearchable();
• setPresenter($presenter);
• skipPresenter($status = true);

AcDevelopers\Repository\Contracts\RepositoryCriteriaInterface

• pushCriteria($criteria)
• popCriteria($criteria)
• getCriteria()
• getByCriteria(CriteriaInterface $criteria)
• skipCriteria($status = true)
• getFieldsSearchable()

AcDevelopers\Repository\Contracts\CacheableInterface

• setCacheRepository(CacheRepository $repository)
• getCacheRepository()
• getCacheKey($method, $args = null)
• getCacheMinutes()
• skipCache($status = true)

AcDevelopers\Repository\Contracts\CriteriaInterface

• apply($model, RepositoryInterface $repository);

Usage

Create a Model

Create your model normally, but it is important to define the attributes that can be filled from the input form data.

Create a Repository

Generators

Create your repositories easily through the generator.

Config

You must first configure the storage location of the repository files. By default is the "app" folder and the namespace "App". Please note that, values in the paths array are acutally used as both namespace and file paths. Relax though, both foreward and backward slashes are taken care of during generation.

You may want to save the root of your project folder out of the app and add another namespace, for example

Additionally, you may wish to customize where your generated classes end up being saved. That can be accomplished by editing the paths node to your liking. For example:

Commands

To generate everything you need for your Model, run this command:

This will create the Controller, the Validator, the Model, the Repository, the Presenter and the Transformer classes. It will also create a new service provider that will be used to bind the Eloquent Repository with its corresponding Repository Interface. To load it, just add this to your AppServiceProvider@register method:

You can also pass the options from the command, since this command is just a wrapper.

To generate a repository for your Post model, use the following command

To generate a repository for your Post model with Blog namespace, use the following command

Added fields that are fillable

To add validations rules directly with your command you need to pass the --rules option and create migrations as well:

The command will also create your basic RESTfull controller so just add this line into your routes.php file and you will have a basic CRUD:

When running the command, you will be creating the "Entities" folder and "Repositories" inside the folder that you set as the default.

Done, done that just now you do bind its interface for your real repository, for example in your own Repositories Service Provider.

And use

Alternatively, you could use the artisan command to do the binding for you.

Use methods

Find all results in Repository

Find all results in Repository with pagination

Find by result by id

Hiding attributes of the model

Showing only specific attributes of the model

Loading the Model relationships

Find by result by field name

Find by result by multiple fields

Find by result by multiple values in one field

Find by result by excluding multiple values in one field

Find all using custom scope

Create new entry in Repository

Update entry in Repository

Delete entry in Repository

Delete entry in Repository by multiple fields

Create a Criteria

Using the command

Criteria are a way to change the repository of the query by applying specific conditions according to your needs. You can add multiple Criteria in your repository.

Using the Criteria in a Controller

Getting results from Criteria

Setting the default Criteria in Repository

Skip criteria defined in the repository

Use skipCriteria before any other chaining method

Popping criteria

Use popCriteria to remove a criteria

Using the RequestCriteria

RequestCriteria is a standard Criteria implementation. It enables filters to perform in the repository from parameters sent in the request.

You can perform a dynamic search, filter the data and customize the queries.

To use the Criteria in your repository, you can add a new criteria in the boot method of your repository, or directly use in your controller, in order to filter out only a few requests.

Enabling in your Repository

Remember, you need to define which fields from the model can be searchable.

In your repository set $fieldSearchable with the name of the fields to be searchable or a relation to fields.

You can set the type of condition which will be used to perform the query, the default condition is "="

Enabling in your Controller

Example the Criteria

Request all data without filter by request

http://ac-developers.local/users

Conducting research in the repository

http://ac-developers.local/users?search=John%20Doe

or

http://ac-developers.local/users?search=John&searchFields=name:like

or

http://ac-developers.local/[email protected]&searchFields=email:=

or

http://ac-developers.local/users?search=name:John Doe;email:[email protected]

or

http://ac-developers.local/users?search=name:John;email:[email protected]&searchFields=name:like;email:=

By default RequestCriteria makes its queries using the OR comparison operator for each query parameter. http://ac-developers.local/users?search=age:17;email:[email protected]

The above example will execute the following query:

In order for it to query using the AND, pass the searchJoin parameter as shown below:

http://ac-developers.local/users?search=age:17;email:[email protected]&searchJoin=and

Filtering fields

http://ac-developers.local/users?filter=id;name

Sorting the results

http://ac-developers.local/users?filter=id;name&orderBy=id&sortedBy=desc

Sorting through related tables

http://ac-developers.local/users?orderBy=posts|title&sortedBy=desc

Query will have something like this

http://ac-developers.local/users?orderBy=posts:custom_id|posts.title&sortedBy=desc

Query will have something like this

Add relationship

http://ac-developers.local/users?with=groups

Overwrite params name

You can change the name of the parameters in the configuration file config/repository.php

Cache

Add a layer of cache easily to your repository

Cache Usage

Implements the interface CacheableInterface and use CacheableRepository Trait.

Done , done that your repository will be cached , and the repository cache is cleared whenever an item is created, modified or deleted.

Cache Config

You can change the cache settings in the file config/repository.php and also directly on your repository.

config/repository.php

It is possible to override these settings directly in the repository.

The cacheable methods are : all, paginate, find, findByField, findWhere, getByCriteria

Credits

• Anderson Andrade

Licence

The L5 Repository Slim is open-sourced software licensed under the MIT license.