crcms / repository
Detached model and controller warehouse data provider
Fund package maintenance!
blog.crcms.cn/reward
Requires
- php: >=7.2
- crcms/event: ~1.0.0
- illuminate/cache: ^5.5|^6.0
- illuminate/console: ^5.5|^6.0
- illuminate/database: ^5.5|^6.0
- illuminate/support: ^5.5|^6.0
README
A specialized data provider layer, based on ORM, only as a data provider, the main role is to separate the coupling before the Controller and Model
Install
You can install the package via composer:
composer require crcms/repository
Laravel
If your version is less than 5.5 please modify config / app.php
'providers' => [ CrCms\Repository\RepositoryServiceProvider::class, ]
If you'd like to make configuration changes in the configuration file you can pubish it with the following Aritsan command:
php artisan vendor:publish --provider="CrCms\Repository\RepositoryServiceProvider"
Commands
php artisan make:repository TestRepository --model TestModel
php artisan make:magic TestMagic
Example
QueryMagic
use CrCms\Repository\AbstractMagic; use CrCms\Repository\Contracts\QueryRelate; class TestMagic extends AbstractMagic { /** * @param QueryRelate $queryRelate * @param int $id * @return QueryRelate */ protected function byName(QueryRelate $queryRelate, string $name) { return $queryRelate->where('name', $name); } /** * @param QueryRelate $queryRelate * @param string $title * @return QueryRelate */ protected function byTitle(QueryRelate $queryRelate, string $title) { return $queryRelate->where('title', 'like', "%{$title}%"); } /** * @param QueryRelate $queryRelate * @param int $id * @return QueryRelate */ protected function byId(QueryRelate $queryRelate, int $id) { return $queryRelate->where('id', $id); } /** * @param QueryRelate $queryRelate * @param array $sort * @return QueryRelate */ protected function bySort(QueryRelate $queryRelate, array $sort) { return $queryRelate->orderByArray($sort); } }
Repository
class TestRepository extends AbstractRepository { /** * @var array */ protected $guard = [ 'id', 'title','other' ]; /** * @return TestModel */ public function newModel(): TestModel { return app(TestModel::class); } /** * @param int $perPage * @return LengthAwarePaginator */ public function paginate(AbstractMagic $magic = null, int $perPage = 15): LengthAwarePaginator { return $this->whenMagic($magic)->where('built_in', 1)->orderBy($this->getModel()->getKeyName(), 'desc')->paginate($perPage); } /** * @param int $name * @param int $title */ public function updateName(string $name, string $title) { $this->where('name', $name)->update(['title' => $title]); } }
Guard Or Scenes
Usually we need to filter the incoming parameter values when adding or modifying and querying the data, and retain the required parameter values.
Guard and scenes are born for this
class TestRepository extends AbstractRepository { /** * @var array */ protected $scenes = [ 'create' => ['sort', 'added_at'], 'modify' => ['sort', 'published_at'] ]; /** * @var array */ protected $guard = [ 'id', 'title', 'other' ]; } $testRepository->create($data, 'create'); //OR $testRepository->setCurrentScene('create')->create($data); //OR $testRepository->setGuard(['sort', 'added_at'])->create($data);
class TestMagic extends AbstractMagic { /** * @var array */ protected $scenes = [ 'frontend' => ['name'], 'backend' => ['title'] ]; /** * @var array */ protected $guard = [ 'title', ]; /** * @param QueryRelate $queryRelate * @param int $id * @return QueryRelate */ protected function byName(QueryRelate $queryRelate, string $name) { return $queryRelate->where('name', $name); } /** * @param QueryRelate $queryRelate * @param string $title * @return QueryRelate */ protected function byTitle(QueryRelate $queryRelate, string $title) { return $queryRelate->where('title', 'like', "%{$title}%"); } } $testRepository->magic(new TestMagic($data, 'frontend'))->paginate(); //OR $testRepository->magic((new TestMagic($data))->setCurrentScene('frontend'))->paginate(); //OR $testRepository->magic((new TestMagic($data))->setGuard(['title']))->paginate(); //OR->create($data);
Note: when guard and scenes are both present, scenes has a higher priority. If scenes is empty, it will use guard.
Listener
TestRepository::observer(TestListener::class); TestListener { public function creating(TestRepository $repository, array $data) { //append the value to be written $repository->addData('append_data','value'); //rewrite all values written $repository->setData(['key'=>'value']); } public function created(TestRepository $repository, TestModel $model) { } public function updating(TestRepository $repository, array $data) { } public function updated(TestRepository $repository, TestModel $model) { } public function deleting(TestRepository $repository, array $ids) { } public function deleted(TestRepository $repository, Collection $models) { } }
Cache
class TestRepository { public function do(User $user) { return $this->byIntId($user->id); } } $repository = new TestRepository;
store
$repository->cache()->do(new User);
forget
$repository->cache()->forget('do')
flush
$repository->cache()->flush()
Repository Methods
public function all(): Collection;
public function get(): Collection;
public function pluck(string $column, string $key = ''): Collection;
public function max(string $column): int;
public function count(string $column = '*'): int;
public function avg($column): int;
public function sum(string $column): int;
public function chunk(int $limit, callable $callback): bool;
public function valueOfString(string $key, string $default = ''): string;
public function valueOfInt(string $key, int $default = 0): int;
public function increment(string $column, int $amount = 1, array $extra = []): int;
public function decrement(string $column, int $amount = 1, array $extra = []): int;
public function delete(): int;
public function deleteByStringId(string $id): int;
public function deleteByIntId(int $id): int;
public function deleteByArray(array $ids): int;
public function paginate(int $perPage = 15) : LengthAwarePaginator;
public function create(array $data) : Model;
public function update(array $data): int;
public function updateByIntId(array $data, int $id) : Model;
public function updateByStringId(array $data, string $id) : Model;
public function byIntId(int $id);
public function byStringId(string $id);
public function byIntIdOrFail(int $id) : Model;
public function byStringIdOrFail(string $id) : Model;
public function oneByString(string $field, string $value): Model;
public function oneByInt(string $field, int $value): Model;
public function oneByStringOrFail(string $field, string $value) : Model;
public function oneByIntOrFail(string $field, int $value) : Model;
public function first();
public function firstOrFail() : Model;
QueryRelate Methods
public function select(array $column = ['*']): QueryRelate;
public function selectRaw(string $expression, array $bindings = []): QueryRelate;
public function skip(int $limit): QueryRelate;
public function take(int $limit): QueryRelate;
public function groupBy(string $column): QueryRelate;
public function groupByArray(array $columns): QueryRelate;
public function orderBy(string $column, string $sort = 'desc'): QueryRelate;
public function orderByArray(array $columns): QueryRelate;
public function distinct(): QueryRelate;
public function where(string $column, string $operator = '=', string $value = ''): QueryRelate;
public function whereClosure(\Closure $callback): QueryRelate;
public function orWhereClosure(\Closure $callback): QueryRelate;
public function orWhere(string $column, string $operator = '=', string $value = ''): QueryRelate;
public function whereBetween(string $column, array $between): QueryRelate;
public function orWhereBetween(string $column, array $between): QueryRelate;
public function whereRaw(string $sql, array $bindings = []): QueryRelate;
public function orWhereRaw(string $sql, array $bindings = []): QueryRelate;
public function orWhereNotBetween($column, array $between): QueryRelate;
public function whereExists(\Closure $callback): QueryRelate;
public function orWhereExists(\Closure $callback): QueryRelate;
public function whereNotExists(\Closure $callback): QueryRelate;
public function orWhereNotExists(\Closure $callback): QueryRelate;
public function whereIn(string $column, array $values): QueryRelate;
public function orWhereIn(string $column, array $values): QueryRelate;
public function whereNotIn(string $column, array $values): QueryRelate;
public function orWhereNotIn(string $column, array $values): QueryRelate;
public function whereNull(string $column): QueryRelate;
public function orWhereNull(string $column): QueryRelate;
public function whereNotNull(string $column): QueryRelate;
public function orWhereNotNull(string $column): QueryRelate;
public function raw(string $sql): QueryRelate;
public function from(string $table): QueryRelate;
public function join(string $table, string $one, string $operator = '=', string $two = ''): QueryRelate;
public function joinClosure(string $table, \Closure $callback): QueryRelate;
public function leftJoin(string $table, string $first, string $operator = '=', string $two = ''): QueryRelate;
public function leftJoinClosure(string $table, \Closure $callback): QueryRelate;
public function rightJoin(string $table, string $first, string $operator = '=', string $two = ''): QueryRelate;
public function rightJoinClosure(string $table, \Closure $callback): QueryRelate;
public function callable(callable $callable): QueryRelate;
public function wheres(array $wheres): QueryRelate;
public function union(QueryRelate $queryRelate): QueryRelate;
public function magic(QueryMagic $queryMagic): QueryRelate;
public function whenMagic(?QueryMagic $queryMagic = null): QueryRelate;
public function with(string $relation): QueryRelate;
public function withArray(array $relations): QueryRelate;
public function without(string $relation): QueryRelate;
public function withoutArray(array $relations): QueryRelate;
public function having(string $column, $operator = null, $value = null): QueryRelate;
public function orHaving(string $column, $operator = null, $value = null): QueryRelate;
public function havingRaw(string $sql, array $bindings = []): QueryRelate;
public function orHavingRaw(string $sql, array $bindings = []): QueryRelate;
public function lockForUpdate(): QueryRelate;
public function sharedLock(): QueryRelate;