Create a Global scope

56243a2eabb4-SelectConstraintScope.php

<?php

namespace App\Scopes;

use Illuminate\Database\Eloquent\Scope;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;

class SelectConstraintScope implements Scope
{
    /**
     * Apply the scope to a given Eloquent query builder.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $builder
     * @param  \Illuminate\Database\Eloquent\Model    $model
     * @return void
     */
    public function apply(Builder $builder, Model $model)
    {
        // First, check if there are columns already set in the query being built by the dev.
        // If the columns are empty, it means we are issuing a "SELECT *", so to avoid that
        // and querying the whole row, we will just simply put all the columns except one.
        if (empty($builder->getQuery()->columns) {
            $builder->select([
                $model->getKeyName(), 
                'filename', 
                'path', 
                'service', 
                'format',
                'quality',
                // 'closed_captions', // <-- We don't need this most of the time.
                $model->getCreatedAtColumn(),
                $model->getUpdatedAtColumn()
            ]);
        }        
    }
}