Details
-
Type:
Improvement
-
Status:
Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 0.1.3, 0.1.4, 0.1.5, 0.2.0
-
Fix Version/s: 1.5.0
-
Component/s: Zend_Db_Table
-
Labels:None
-
Fix Version Priority:Nice to Have
Description
http://framework.zend.com/developer/ticket/27
I would like to suggest allowing the fetch/find methods of Zend_Db_Table to accept a $forUpdate boolean parameter.
That is in Zend_Db_Table:
function find($val) // would become function find($val, $forUpdate = false) function fetchRow($where = null, $order = null) // would become function fetchRow($where = null, $order = null, $forUpdate = false) function fetchAll($where = null, $order = null, $count = null, $offset = null) // would become function fetchAll($where = null, $order = null, $count = null, $offset = null, $forUpdate = false)
Note: Zend_Db_Table::find() would especially benefit from this syntax.
This would make it much easier for developpers to keep database integrity and would also make the Zend_Db_Table more widely accepted.
Issue Links
| This issue is related to: | ||||
| ZF-3653 | Zend_Db_Table::find() doesn't support For Update |
|
|
|
There should also be support for SELECT ... LOCK IN SHARE, and the corresponding locking modes in SQLite ( http://www.sqlite.org/lockingv3.html ), and similar for the other adapters. This issue is closely related to, and overlaps with,
ZF-40, although I believeZF-40should be a higher priority.ZF-40, although I believeZF-40should be a higher priority.