Download the PHP package dees040/repository without Composer

Laravel Repository Package

THIS PACKAGE IS A WORK IN PROGRESS

This packages helps you to easily implement the repository package in your Laravel application.

Why use this package out of the many other Laravel repository package? This package was inspired by multiple other Laravel repository package. I took all the good things from those packages and create one unique package for it. Also I keep maintain this package, because I use it in multiple of my own projects.

Installation

You can install this package using composer, by running the following command:

The service provider is automatically added via Laravel package discovery.

Methods

Dees040\Repository\Contracts\Repository

• all($columns = ['*'])
• paginate($perPage = null, $columns = ['*'])
• first($columns = ['*'])
• find($id, $columns = ['*'])
• findOrFail($id, $columns = ['*'])
• findByField($field, $value, $columns = ['*'])
• findWhere(array $where, $columns = ['*'])
• findWhereIn(array $where, $columns = ['*'])
• firstOrCreate(array $attributes, array $values = [])
• create(array $attributes = [])
• insert(array $attributes = [])
• update($id, array $attributes)
• updateOrCreate(array $attributes, array $values = [])
• delete($id)
• deleteWhere(array $where)
• deleteWhereIn(array $where)
• orderBy($column, $direction = 'asc')
• with($relations)
• has($relation)
• whereHas($relation, \Closure $closure)
• orWhereHas($relation, \Closure $closure)
• sync($id, $relation, $attributes, $detaching = true)
• syncWithoutDetaching($id, $relation, $attributes)

Usage

Creating a repository

Repositories can be created by hand or via a command provided in this package. If you'd like to create a repository by hand you should create two files for each repository.

One class for the repository contract:

And one class for the actual repository:

The other option is creating the file using the make:repository command:

Usage in controllers

After creating the repository you should bind the repository contract to the correct repository using the Laravel Container. By doing this Laravel knows exactly which repository to use for which contract. This makes it very easy to switch between a eloquent repository or e.g. a MongoDB repository.

So before using any repositories in your controller make sure to bind it to the container. You can do that using the bind($abstract, concrete) method in the Container. E.g.: App::bind(\App\Repositories\Contracts\PostRepository::class, \App\Repositories\PostEloquentRepository::class).

Personally I like to create a new service provider named \App\Providers\RepositoryServiceProvider.php and do something like this:

After binding in to the container you can use dependency injection inside your controller to get the repository.

Using criteria

If you'd like to execute custom queries to the database call you can use criteria. You can add criteria to your call by calling the pushCriteria method.

Make sure that your custom criteria classes are implementing the \Dees040\Repository\Contracts\Criteria interface. An example of custom criteria is:

RequestCriteria

The package ships with a useful criteria out of the box. The RequestCriteria. It gives you the ability to easily perform extra actions on your queries via the route parameters. You can add order by items or search through your models. You can add the criteria by default in the constructor of a repository:

After doing this you can add following query parameters.

• https://example.test/posts?order_by=created_at
• https://example.test/posts?order_by=created_at&sort_by=desc
• https://example.test/posts?search=Lorem ipsum
• https://example.test/posts?search=Lorem ipsum&search_fields=body
• https://example.test/posts?search=Lorem ipsum&search_fields=title,body:like
• https://example.test/posts?search=Lorem ipsum&search_fields=title,body:like&order_by=title

If you'd like to have the ability to search you should override the getSearchableFields() method in your repository. All the fields returned in the array of that method are then searchable via the route parameters.

TODOS

• [x] Create a build in criteria class for requests
• [x] Search fields in the request criteria
• [ ] Create cache
• [ ] Parse results
• [ ] Pagination options
• [ ] Search on custom fields in request criteria
• [ ] Dynamic criteria class
• [ ] Regex split on search fields
• [ ] Add dot nation for relations in request criteria
• [ ] Create commands