CollectionFind::lockShared
(No version information available, might only be in Git)
CollectionFind::lockShared — Execute operation with SHARED LOCK
说明
public mysql_xdevapi\CollectionFind::lockShared
([ integer $lock_waiting_option
] ) : mysql_xdevapi\CollectionFind
Other sessions can read the rows, but cannot modify them until your transaction commits.
If any of these rows were changed by another transaction that has not yet committed,
your query waits until that transaction ends and then uses the latest values.
参数
-
lock_waiting_option
-
Optional waiting option. By default it is MYSQLX_LOCK_DEFAULT. Valid values are these constants:
MYSQLX_LOCK_DEFAULT
MYSQLX_LOCK_NOWAIT
MYSQLX_LOCK_SKIP_LOCKED
返回值
A CollectionFind object that can be used for further processing
范例
Example #1 mysql_xdevapi\CollectionFind::lockShared() example
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$schema = $session->getSchema("addressbook");
$collection = $schema->createCollection("people");
$session->startTransaction();
$result = $collection
->find("age > 50")
->lockShared()
->execute();
// ... read the object in shared mode
// Complete the transaction and unlock the document
$session->commit();
?>