README

一个简单的模块，作为对数据库表执行 CRUD 操作的 Magento 连接的包装器

安装

composer require alaa/magento2-table-query

public function __construct(\Alaa\TableQuery\Model\QueryInterfaceFactory $queryFactory)
{
        $this->queryFactory = $queryFactory;
}

$query =  $this->queryFactory->create(['table' => 'my_table', 'primaryId' => 'primary_id']);

$data = [
    [
        'name' => 'some name'
        'age' => 33,
        ...
    ],
    [...]
]
$query->put($data);

根据条件检索记录

$query->pull('id = 5')

检索第一条记录并删除它

$query->poll()

检索最后一条记录并删除它

$query->pop()

$query->purge();

$query->update(...)

$it = $query->iterator();

while ($it->valid()) {
    $row = $it->current();
    // ... do something with row
    $it->next();
}

欢迎提出问题和贡献力量

MIT