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

Allows to share the documents between multiple transactions which are locking in shared mode.

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();
?>

php mysql xdevapi baseresult fetch warning count from last operation php mysql xdevapi collectionadd execute the statement php mysql xdevapi collectionfind bind value to query placeholder php mysql xdevapi collectionfind collectionfind constructor php mysql xdevapi collectionfind execute the statement php mysql xdevapi collectionfind set document field filter php mysql xdevapi collectionfind set grouping criteria php mysql xdevapi collectionfind execute operation with exclusive lock php mysql xdevapi collectionfind execute operation with shared lock php mysql xdevapi collectionmodify execute modify operation php mysql xdevapi collectionremove execute remove operation php mysql xdevapi docresult get warnings from last operation php mysql xdevapi docresult get warning count from last operation php mysql xdevapi result get warnings from last operation php mysql xdevapi result get warning count from last operation php mysql xdevapi sqlstatement execute the operation php mysql xdevapi tableinsert execute insert query php mysql xdevapi tableselect execute exclusive lock php mysql xdevapi tableselect execute shared lock php mysql xdevapi tableupdate execute update query