sdragnev/

bulkdbinserter

使用PDO创建数据库写入器,支持多行插入

v1.2 2021-12-27 15:42 UTC

This package is auto-updated.

Last update: 2024-09-27 21:42:55 UTC


README

辅助类,可以将多个PDO写入操作缓冲到一个查询中。

示例用法,在给定的PDO连接对象$pdo中,每次插入500(默认)条记录,插入"accounts"表中的1200条记录

// Inserts 1200 records in 3 queries (500 + 500 + 200)
$writer = new BulkInserter($pdo, "accounts", ["id", "name"]);
// $writer->setBatch(600); // optionally set the buffer size to a different number

for ($i = 0; $i < 1200; $i++) {
    $writer->write([$i, "John $i"]);
}

$writer->flush(true);   // flushes the remaining buffer