Laravel 在数据透视表中雄辩的 UUID

2021-12-26 00:00:00 pivot php laravel laravel-5.4 eloquent

这个问题是这样的:laravel uuid 未显示在查询中.然而，这个问题的不同之处在于该表是一个带有 id 字段的数据透视表，使用通过 MySQL 触发器在插入时生成的 UUID.

This question is like this one: laravel uuid not showing in query. However, the difference in this question is about that table is a pivot table with id field uses UUID generated via MySQL trigger on insert.

我不想为该数据透视表创建另一个模型来为其提供类似问题的答案所考虑的解决方案.那么，有没有什么办法可以从与之相关的另一个模型中对数据透视表进行类型转换?

I don't want to create another model for that pivot table to supply it with the solution regarded on the similar question's answer. So, is there any way to perform type casting of the pivot table from another model related to it?

推荐答案

我想这可能是你想要的:

I think this might be what you want:

在定义 BelongsToMany 关系的模型中添加此属性:

In your model that defines the BelongsToMany relationship add this property:

protected $casts = ['relationName.pivot.id' => 'string'];

更新

我想我们可以在这里使用 php7.0 中的匿名类，而不是为枢轴创建模型类:

I guess we can make use of anonymous classes in php7.0 here instead of creating a model class for the pivot:

我没有测试这段代码，所以我不知道它是否有效，这只是一个想法

public function activeStatuses()
{
    return $this->belongsToMany('ModelName')
                ->using(class_basename(new class extends IlluminateDatabaseEloquentRelationsPivot {
                    protected $casts = ['id' => 'string'];
                }));
}

通常我更愿意为数据透视表创建模型或简单地使用数据透视类

Generally i would prefer to create model for the pivot table or simply use a pivot class

相关文章