sdragnev / bulkdbinserter
使用PDO创建数据库写入器,支持多行插入
v1.2
2021-12-27 15:42 UTC
Requires
- php: >=5.6.0
- ext-pdo: *
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