在 Eloquent 模型类而不是 querybuilder 中指定选定的列

Question

每当我使用 eloquent 模型时，它都会选择 *，除非我在 querybuilder 对象中指定它。但是，我想指定类中允许的字段。这对于确保正确的用户级别获得他们有权获得的详细信息非常有用，因此它与班级一起存在。

我希望能够将其作为成员变量来执行，例如 $with：

/**

 * @property mixed id

 */

class Attribute extends Model

{

    protected $fillable = ["id", "business_id", "attribute_name"];

    protected $with = ["attributeDetail", "business"];

    protected $selectedFieldsThatMeanSelectStarDoesntHappen = ["id", "business_id", "attribute_name"];

}

因此，只要使用该类，任何使用上述类的查询都会执行SELECT id, business_id, attribute_name，而不是SELECT *.

是否存在上述功能？我能得到的最接近的是全局范围：

class Attribute extends Model

{

    /**

     * The "booted" method of the model.

     *

     * @return void

     */

    protected static function booted()

    {

        static::addGlobalScope('selectFields', function (Builder $builder) {

            $builder->select("id", "business_id", "attribute_name");

        });

    }

}

Answer 1

您可以尝试一下：创建一个新的构建器和一个使用这个新构建器的特征：class BuilderWithSpecifiedColumns extends Builder{    public $selectedColumns = [];    public function __construct(ConnectionInterface $connection, Grammar $grammar = null, Processor $processor = null, array $selectedColumns = ['*'])    {        parent::__construct($connection, $grammar, $processor);        $this->selectedColumns = $selectedColumns;    }    /**     * @param string[] $columns     * @return \Illuminate\Support\Collection     */    public function get($columns = ['*'])    {        return parent::get($this->selectedColumns ? $this->selectedColumns : $columns);    }}trait HasSelectedColumns{    protected function newBaseQueryBuilder()    {        $connection = $this->getConnection();        return new BuilderWithSpecifiedColumns(            $connection,            $connection->getQueryGrammar(),            $connection->getPostProcessor(),            $this->selectedFieldsThatMeanSelectStarDoesntHappen,        );    }}使用以上特征/** * @property mixed id */class Attribute extends Model{    use HasSelectedColumns;    protected $fillable = ["id", "business_id", "attribute_name"];    protected $with = ["attributeDetail", "business"];    protected $selectedFieldsThatMeanSelectStarDoesntHappen = ["id", "business_id", "attribute_name"];}