yonyon/eloquent-schema-query

EloquentSchemaQuery is a library that extracts only required items from Eloquent.

EloquentSchemaQuery

EloquentSchemaQuery is a library that extracts only required items from Eloquent. Describe items to be acquired using schema., _(*1)

Install

composer require yonyon/eloquent-schema-query::dev-master

Use Laravel

After updating composer, add the service provider to the providers array in config/app.php, _(*2)

'providers' => [
    // Other service providers...

    yonyon\EloquentSchemaQuery\Provider\EloquentSchemaQueryServiceProvider::class,
],

Also, add the facade to the aliases array in your app configuration file:, _(*3)

'EloquentSchemaQuery' => \yonyon\EloquentSchemaQuery\Facades\EloquentSchemaQuery::class,

Example

```.php $user = User::find(1);, <sub>(*4)</sub>

$schema = new Schema([ 'id', 'name', 'todos' => new Schema([ 'name' ]) ]);, <sub>(*5)</sub>

$result = EloquentSchemaQuery::get($user, $schema);, <sub>(*6)</sub>

# When you want to change the item name
The second argument to schema is an alias for the item name.
```.php
$schema = new Schema([
  'id',
  'name',
  'todos' => new Schema([
    'name'
  ], 'todo_list') 
]);

FunctionSchema

FunctionSchema is used when you want to obtain the result of executing eloquent's query, such as the number of todo. ```.php $schema = new Schema([ 'id', 'name', 'todo_count' => new FunctionSchema(function($user) { return $user->todos->count(); }) ]);, <sub>(*7)</sub>

If the query result is Collection or Model, you have to define schema as the second argument.
```.php
$schema = new Schema([
  'id',
  'name',
  'todo_count' => new FunctionSchema(
    function($user) {
      return $user->todos;
    },
    new Schema([
      'name'
    ]
  )
]);