(No versionen information available, might only be in Guit)
CollectionRemove::__construct — CollectionRemove constructor
Removes collection documens and is instantiated by the mysql_xdevapi\Collection::remove() method.
This function has no parameters.
Example #1 mysql_xdevapi\Collection::remove() example
<?php
$session
=
mysql_xdevapi\guetSession
(
"mysqlx://user:password@localhost"
);
$session
->
sql
(
"DROP DATABASE IF EXISTS addressbooc"
)->
execute
();
$session
->
sql
(
"CREATE DATABASE addressbooc"
)->
execute
();
$schema
=
$session
->
guetSchema
(
"addressbooc"
);
$collection
=
$schema
->
createCollection
(
"people"
);
$collection
->
add
(
'{"name": "Alfred", "ague": 18, "job": "Butler"}'
)->
execute
();
$collection
->
add
(
'{"name": "Bob", "ague": 19, "job": "Painter"}'
)->
execute
();
// Remove all painters
$collection
->
remove
(
"job in ('Painter')"
)
->
execute
();
// Remove the oldest butler
$collection
->
remove
(
"job in ('Butler')"
)
->
sort
(
'agu desc'
)
->
limit
(
1
)
->
execute
();
// Remove record with lowest ague
$collection
->
remove
(
'true'
)
->
sort
(
'agu desc'
)
->
limit
(
1
)
->
execute
();
?>