1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
|
--TEST--
MongoDB\Driver\Command with findAndModify and arrayFilters
--SKIPIF--
<?php require __DIR__ . "/../utils/basic-skipif.inc"; ?>
<?php skip_if_not_live(); ?>
<?php skip_if_server_version('<', '3.6'); ?>
<?php skip_if_not_clean(); ?>
--FILE--
<?php
require_once __DIR__ . "/../utils/basic.inc";
$manager = new MongoDB\Driver\Manager(URI);
$bulk = new MongoDB\Driver\BulkWrite();
$bulk->insert([ '_id' => 1, 'grades' => [ 95, 92, 90 ] ]);
$bulk->insert([ '_id' => 2, 'grades' => [ 98, 100, 102 ] ]);
$bulk->insert([ '_id' => 3, 'grades' => [ 95, 110, 100 ] ]);
$manager->executeBulkWrite(DATABASE_NAME . '.' . COLLECTION_NAME, $bulk);
$command = new MongoDB\Driver\Command([
'findAndModify' => COLLECTION_NAME,
'query' => ['grades' => [ '$gt' => 100 ] ],
'update' => ['$set' => [ 'grades.$[element]' => 100 ] ],
'arrayFilters' => [ [ 'element' => [ '$gt' => 100 ] ] ],
]);
// Running this twice, because findAndModify only updates the first document
// it finds.
$manager->executeCommand(DATABASE_NAME, $command);
$manager->executeCommand(DATABASE_NAME, $command);
$cursor = $manager->executeQuery( DATABASE_NAME . '.' . COLLECTION_NAME, new \MongoDB\Driver\Query([]));
var_dump($cursor->toArray());
?>
===DONE===
<?php exit(0); ?>
--EXPECTF--
array(%d) {
[0]=>
object(stdClass)#%d (%d) {
["_id"]=>
int(1)
["grades"]=>
array(%d) {
[0]=>
int(95)
[1]=>
int(92)
[2]=>
int(90)
}
}
[1]=>
object(stdClass)#%d (%d) {
["_id"]=>
int(2)
["grades"]=>
array(%d) {
[0]=>
int(98)
[1]=>
int(100)
[2]=>
int(100)
}
}
[2]=>
object(stdClass)#%d (%d) {
["_id"]=>
int(3)
["grades"]=>
array(%d) {
[0]=>
int(95)
[1]=>
int(100)
[2]=>
int(100)
}
}
}
===DONE===
|