问题描述
对于 Maria-DB 和 MySQL 中支持的 动态 列，我们有 JSON 列类型.对于我们的一个项目，我们应该为 Maria-DB(而不是 Mysql)实现一个数据库.
For Dynamic column supported in Maria-DB and in MySQL we have JSON column type. For one of our projects, we should be implementing a database for Maria-DB (not Mysql).
使用yii2支持动态列-dynamic-ar 包.
The Dynamic Column is supported using yii2-dynamic-ar package.
如何覆盖Laravel 中的Eloquent orm 来添加dynamic-columns.在 Yii 包中，将这个特性添加到 ActiveRecord 这个类可以覆盖 ActiveRecord 类
how can can override Eloquent orm in Laravel to add dynamic-columns. in the Yii package which added this feature to ActiveRecord this classes can override ActiveRecord class
Yii 框架中的实现类以支持 ActiveRecord ORM:
implementations classes in Yii framework to support in ActiveRecord ORM:
- DynamicActiveRecord.php
- DynamicActiveQuery.php
推荐答案
我刚刚创建了使用 eloquent 和查询生成器处理 MariaDB 动态列的包.
I just created package for handling MariaDB dynamic Column using eloquent and query builder.
要安装软件包，请运行以下命令:
To install package run this command:
composer require halalsoft/laravel-dynamic-column
您可以通过添加 HasDynamicColumn trait 并使用 Dynamic 作为转换到模型的属性来开始使用该包.
You can start using the package by adding the HasDynamicColumn trait and use Dynamic as attribute cast to your models.
示例:
use IlluminateDatabaseEloquentModel;
use HalalsoftLaravelDynamicColumnDynamic;
use HalalsoftLaravelDynamicColumnHasDynamicColumn;
class MyModel extends Model
{
use HasDynamicColumn;
protected $casts
= [
'the_column' => Dynamic::class,
];
}
现在您可以使用 eloquent 或查询构建器使用动态列，如 json 列:
Now You can use dynamic column like json column using eloquent or query builder:
$modelData = MyModel::find(1);
$columnData = $modelData->the_column;
$columnData['data1'] = 'value';
$columnData['data2'] = 'value2';
$modelData->the_column = $columnData;
$modelData->save();
您也可以将数据字段创建为数组
You can also create data field as array
$newData = MyModel::create([
'other_column' => 'this just another column data',
'the_column' => ['data1'=>'value1','data2'=>'value2']
]);
要更新您使用的 json 字段/键，您可以在调用更新方法时使用 -> 运算符:
to update a json field/key you use, you may use the -> operator when calling the update method:
$page->update(['content->data1' => 'value1new']);
或者您仍然可以使用普通数组更新整列:
or you can still update whole column using normal array:
$page->update(['content' => ['data1'=>'value1new','data2'=>'value2new']]);
您可以使用updateOrCreate()、firstOrCreate()等其他方法设置为数组
You can set as array using other method like updateOrCreate(), firstOrCreate(), etc.
这个包还支持查询生成器使用:
This package also support query builder using:
Model::query()->where('the_column->data1', 'value1')->first();
这个包仍然是新的，如果有任何问题或请求，请转到github issue
This package is still new, if any issue or request just go to github issue
这篇关于Laravel Eloquent 支持 MariaDb 动态列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！