lengbin / sub-table
sub table
dev-master
2022-12-01 08:26 UTC
Requires
- php: >=7.4
- lengbin/error-code: 2.0.x-dev
This package is auto-updated.
Last update: 2025-03-01 00:39:09 UTC
README
简单分表
Install
The preferred way to install this extension is through composer.
Either run
composer require lengbin/sub-table
or add
"lengbin/sub-table": "*"
to the require section of your composer.json
file.
Use date
$tableName = "t_user_log"; $pdo = new PDO(); $subTable = (new SubTableFactory)->make(SubTableMode::DATE()) $subTable->setKey(date('Y')); // $this->subTable->suffix(); // 根据生成后缀 $this->subTable->setPdo($pdo); // 设置 pdo $this->subTable->createSubTable($tableName); // 生成分表
Use hash
$tableName = "t_user_log"; $pdo = new PDO(); $subTable = (new SubTableFactory)->make(SubTableMode::HASH()) $subTable->setKey(1234); $subTable->setSlices("32"); // 设置 分片 默认 10 // $this->subTable->suffix(); // 根据hash 求余 生成后缀 $this->subTable->setPdo($pdo); // 设置 pdo $this->subTable->createSubTable($tableName); // 生成分表