denis-kisel/batch-update

批量更新

维护者

详情

github.com/denis-kisel/batch-update

源代码

问题

安装: 14

依赖: 1

建议者: 0

安全: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

v1.0.0 2022-06-17 10:39 UTC

MIT 9465a8b5cb5a5c82c3d43a7f6db4cb25b55cd085

  • Denis Kisel

This package is auto-updated.

Last update: 2024-09-17 15:40:14 UTC

README

在一查询中更新批量行！

支持

laravel

安装

composer require denis-kisel/batch-update

基本用法

(new UpdateBatch('table_name', $batchArrayData))->run();


# Specify primary key
(new UpdateBatch('table_name', $batchArrayData, 'primary_key'))->run();

# Add filter where
(new UpdateBatch('table_name', $batchArrayData, 'primary_key'))
    ->where('type', '=', $this->tmpOfferType)
    ->run();

# Support where
(new UpdateBatch('table_name', $batchArrayData, 'primary_key'))
    ->where('type', '=', $this->tmpOfferType)
    ->run();
    
# Support whereIn
(new UpdateBatch('table_name', $batchArrayData, 'primary_key'))
    ->whereIn('id', [1, 2, 3])
    ->run();
    
# Another methods
(new UpdateBatch('table_name'))
    ->multipleData($batchDataToUpdate)
    ->referenceColumn('primary_id')
    ->run();