Laravel Eloquent模子中乐观锁的实现
本篇文章给各人带来了关于laravel的相关知识，其中主要跟各人先容laravel eloquent模子中乐观锁的实现，有代码示例，感兴趣的朋侪下面一起来看一下吧，希望对各人有资助。
在app/Utils/Traits目录下建设OptimisticLockTrait.php，代码如下：
namespace App\Utils\Traits;use Illuminate\Database\Eloquent\Builder;trait OptimisticLockTrait{
/**
* @var array $optimisticConditions
* @var array $bindings
*/
protected $optimisticConditions, $bindings;
/**
* @var string $optimisticConditionRaw
*/
protected $optimisticConditionRaw;
/**
* save 时增添乐观锁条件
* @param Builder $builder
*/
protected function performUpdate(Builder $builder)
{
if (!empty($this->optimisticConditions)) {
foreach ($this->optimisticConditions as $field => $value) {
if (is_array($value)) {
$count = count($value);
if ($count >= 3) {
switch (strtoupper($value[1])) {
case 'IN':
$builder->whereIn($value[0], $value[2]);
break;
case 'NOT IN':
$builder->whereNotIn($value[0], $value[2]);
break;
case 'BETWEEN':
$builder->whereBetween($value[0], $value[2]);
break;
case 'NOT BETWEEN':
$builder->whereNotBetween($value[0], $value[2]);
break;
default:
$builder->where($value[0], $value[1], $value[2]);
}
} else {
$builder->where($value);
}
} else {
$builder->where($field, $value);
}
}
}
// 原始条件注入
if ($this->optimisticConditionRaw)
$builder->whereRaw($this->optimisticConditionRaw, $this->bindings);
return $this->clearOptimistic()->perFormUpdating($builder);
}
/**
* updating with optimistic
*
* @param Builder $builder
* @return bool
*/
protected function perFormUpdating(Builder $builder)
{
// If the updating event returns false, we will cancel the update operation so
// developers can hook Validation systems into their models and cancel this
// operation if the model does not pass validation. Otherwise, we update.
if ($this->fireModelEvent('updating') === false) {
return false;
}
// First we need to create a fresh query instance and touch the creation and
// update timestamp on the model which are maintained by us for developer
// convenience. Then we will just continue saving the model instances.
if ($this->usesTimestamps()) {
$this->updateTimestamps();
}
// Once we have run the update operation, we will fire the "updated" event for
// this model instance. This will allow developers to hook into these after
// models are updated, giving them a chance to do any special processing.
$dirty = $this->getDirty();
$res = 0;
if (count($dirty) > 0) {
$res = $this->setKeysForSaveQuery($builder)->update($dirty);
$this->syncChanges();
$this->fireModelEvent('updated', false);
}
return !empty($res);
}
// 扫除乐观锁条件
function clearOptimistic()
{
$this->optimisticConditions = null;
$this->optimisticConditionRaw = null;
return $this;
}
// 设置乐观锁条件字段名列表
function setOptimistic(array $optimisticConditions)
{
$this->optimisticConditions = $optimisticConditions;
return $this;
}
// 设置乐观锁原始条件字段名列表
function setOptimisticRaw(string $optimisticConditionRaw, array $bindings = [])
{
$this->optimisticConditionRaw = $optimisticConditionRaw;
$this->bindings = $bindings;
return $this;
}}
登录后复制
乐观锁使用说明
1、在模子中(Models)或模子父类使用
/**
* App\Models\BaseModel
* @mixin \Eloquent
* @method static \Illuminate\Database\Eloquent\Builder|BaseModel newModelQuery()
* @method static \Illuminate\Database\Eloquent\Builder|BaseModel newQuery()
* @method static \Illuminate\Database\Eloquent\Builder|BaseModel query()
*/class BaseModel extends Model{
use OptimisticLockTrait;}
登录后复制
2、使用要领：
$ord = Order::find(1);
$ord->payment_status = 1;
if(!$model->setOptimistic(['payment_status' => 0]))->save())
throws new Exception('订单已付过款了');
登录后复制
或者使用原始SQL方法:
$ord = Order::find(1);
$ord->payment_status = 1;
if(!$model->setOptimisticRaw('payment_status = ?',[1]))->save())
throws new Exception('订单已付过款了');
登录后复制
若是统一工具小涉及到多次更新，则可以扫除锁条件
$ord->clearOptimistic();
登录后复制
以上就是乐观锁的实现方法，在现实开发中较量常用也很有须要。
推荐学习：《laravel视频教程》
以上就是Laravel Eloquent模子中乐观锁的实现的详细内容，更多请关注本网内其它相关文章！
免责说明：以上展示内容泉源于相助媒体、企业机构、网友提供或网络网络整理，版权争议与本站无关，文章涉及看法与看法不代表尊龙凯时人生就是博滤油机网官方态度，请读者仅做参考。本文接待转载，转载请说明来由。若您以为本文侵占了您的版权信息，或您发明该内容有任何涉及有违公德、冒犯执法等违法信息，请您连忙联系尊龙凯时人生就是博实时修正或删除。
