lengbin / sub-table
sub table
Installs: 172
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 1
Forks: 0
Open Issues: 0
pkg:composer/lengbin/sub-table
Requires
- php: >=7.4
- lengbin/error-code: 2.0.x-dev
This package is auto-updated.
Last update: 2025-09-29 03:08:16 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); // 生成分表