我可以在 CakePHP 的更新语句中添加条件吗？

发布于 2024-08-06 07:31:54 字数 797 浏览 10 评论 0原文

由于 CakePHP 中似乎不支持乐观锁定，我正在尝试构建一种实现它的行为。经过对行为的一些研究后，我想我可以在 beforeSave 事件中运行查询来检查版本字段是否未更改。

实现检查，

WHERE id = ?

但是，我宁愿通过将更新语句的 WHERE 子句从更改为来

WHERE id = ? and version = ?

这样我就不必担心在读取版本和执行更新之间其他请求更改数据库记录。这也意味着我可以进行一次数据库调用，而不是两次。

我可以看到 DboSource.update() 方法支持条件，但 Model.save() 从未向其传递任何条件。

看来我有几个选择：

在 beforeSave() 中进行检查并接受它不是防弹的事实。
破解我的 CakePHP 本地副本，检查 Model.save() 的 options 数组中的 conditions 键，并将其传递给 <代码>DboSource.update() 方法。

现在，我倾向于第二种选择，但这意味着我无法与其他用户分享我的行为，除非他们将我的黑客应用到他们的框架中。

我错过了一个更简单的选择吗？

原文

Since there doesn't seem to be any support for optimistic locking in CakePHP, I'm taking a stab at building a behaviour that implements it. After a little research into behaviours, I think I could run a query in the beforeSave event to check that the version field hasn't changed.

However, I'd rather implement the check by changing the update statement's WHERE clause from

WHERE id = ?

WHERE id = ? and version = ?

This way I don't have to worry about other requests changing the database record between the time I read the version and the time I execute the update. It also means I can do one database call instead of two.

I can see that the DboSource.update() method supports conditions, but Model.save() never passes any conditions to it.

It seems like I have a couple of options:

Do the check in beforeSave() and live with the fact that it's not bulletproof.
Hack my local copy of CakePHP to check for a conditions key in the options array of Model.save() and pass it along to the DboSource.update() method.

Right now, I'm leaning in favour of the second option, but that means I can't share my behaviour with other users unless they apply my hack to their framework.

Have I missed an easier option?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

深海夜未眠 2024-08-13 07:31:54

当使用 save() 更新记录时，Cake 期望存在 id，并且只会更新具有该 id 的记录。

您要寻找的是 updateAll()：

updateAll(数组$fields, 数组$conditions)
在一次调用中更新许多记录。要更新的记录由 $conditions 数组标识，要更新的字段及其值由 $fields 数组标识。
例如，要批准所有成为会员一年以上的面包师，更新调用可能类似于：
$this_year = date('Ymd h:i:s', strtotime('-1 年'));

$this->Baker->updateAll(
    array('Baker.approved' => true),
    array('Baker.created <=' => "$this_year")
）；

When using save() to update a record, Cake expects an id to be present and will update only the record with this id.

What you're looking for is updateAll():

updateAll(array $fields, array $conditions)
Updates many records in a single call. Records to be updated are identified by the $conditions array, and fields to be updated, along with their values, are identified by the $fields array.
For example, to approve all bakers who have been members for over a year, the update call might look something like:
$this_year = date('Y-m-d h:i:s', strtotime('-1 year'));

$this->Baker->updateAll(
    array('Baker.approved' => true),
    array('Baker.created <=' => "$this_year")
);

回复收藏 0 原文