mirror of
https://github.com/php/pecl-database-mysql_xdevapi.git
synced 2026-03-24 07:12:14 +01:00
d93d86fb32
According to specification, in CRUD operations the 'bind' method is supported for parameter values in filter expression only. By accident it did work also for other methods like arrayAppend, arrayInsert, set, ... Although it stopped with the newest server, where some optimizations related to prepared statements have been introduced.
154 lines
2.8 KiB
PHP
154 lines
2.8 KiB
PHP
--TEST--
|
|
mysqlx modify arrayAppend/Insert
|
|
--SKIPIF--
|
|
--FILE--
|
|
<?php
|
|
require("connect.inc");
|
|
|
|
$session = create_test_db();
|
|
$schema = $session->getSchema($db);
|
|
$coll = $schema->getCollection("test_collection");
|
|
|
|
fill_db_collection($coll);
|
|
|
|
$coll->modify("name in ('Marco', 'Alfredo', 'Carlo', 'Leonardo')")
|
|
->arrayAppend('job', 'Grafico')
|
|
->set('name', 'ENTITY')->execute();
|
|
$coll->modify('name like :name')
|
|
->arrayInsert('job[0]', 'Calciatore')
|
|
->bind(['name' => 'ENTITY'])->execute();
|
|
$coll->modify('age > :age')->sort('age desc')->unset(['age'])->bind(['age' => 20])->limit(4)->execute();
|
|
$coll->modify("name like 'ENTITY' and age > :age")->bind(['age' => 23])->unset(['age'])->execute();
|
|
$coll->modify("name in ('ENTITY', 'Lucia')")->sort('_id desc')->limit(2)->set('auto', 'BMW')->execute();
|
|
|
|
try {
|
|
$coll->modify('TRUE')->limit(-1)->unset('name')->execute();
|
|
} catch(Exception $ex) {
|
|
print "Exception!\n";
|
|
}
|
|
$res = $coll->find("name in ('ENTITY', 'Lucia')")->execute();
|
|
$data = $res->fetchAll();
|
|
var_dump($data);
|
|
|
|
print "done!";
|
|
?>
|
|
--CLEAN--
|
|
<?php
|
|
require("connect.inc");
|
|
clean_test_db();
|
|
?>
|
|
--EXPECTF--
|
|
Exception!
|
|
array(6) {
|
|
[0]=>
|
|
array(5) {
|
|
["_id"]=>
|
|
string(1) "1"
|
|
["age"]=>
|
|
int(19)
|
|
["job"]=>
|
|
array(3) {
|
|
[0]=>
|
|
string(10) "Calciatore"
|
|
[1]=>
|
|
string(13) "Programmatore"
|
|
[2]=>
|
|
string(7) "Grafico"
|
|
}
|
|
["name"]=>
|
|
string(6) "ENTITY"
|
|
["ordinal"]=>
|
|
int(1)
|
|
}
|
|
[1]=>
|
|
array(4) {
|
|
["_id"]=>
|
|
string(2) "11"
|
|
["job"]=>
|
|
string(7) "Barista"
|
|
["name"]=>
|
|
string(5) "Lucia"
|
|
["ordinal"]=>
|
|
int(11)
|
|
}
|
|
[2]=>
|
|
array(4) {
|
|
["_id"]=>
|
|
string(2) "15"
|
|
["job"]=>
|
|
array(3) {
|
|
[0]=>
|
|
string(10) "Calciatore"
|
|
[1]=>
|
|
string(10) "Calciatore"
|
|
[2]=>
|
|
string(7) "Grafico"
|
|
}
|
|
["name"]=>
|
|
string(6) "ENTITY"
|
|
["ordinal"]=>
|
|
int(15)
|
|
}
|
|
[3]=>
|
|
array(5) {
|
|
["_id"]=>
|
|
string(2) "16"
|
|
["age"]=>
|
|
int(23)
|
|
["job"]=>
|
|
array(3) {
|
|
[0]=>
|
|
string(10) "Calciatore"
|
|
[1]=>
|
|
string(13) "Programmatore"
|
|
[2]=>
|
|
string(7) "Grafico"
|
|
}
|
|
["name"]=>
|
|
string(6) "ENTITY"
|
|
["ordinal"]=>
|
|
int(16)
|
|
}
|
|
[4]=>
|
|
array(5) {
|
|
["_id"]=>
|
|
string(1) "5"
|
|
["job"]=>
|
|
array(3) {
|
|
[0]=>
|
|
string(10) "Calciatore"
|
|
[1]=>
|
|
string(13) "Programmatore"
|
|
[2]=>
|
|
string(7) "Grafico"
|
|
}
|
|
["auto"]=>
|
|
string(3) "BMW"
|
|
["name"]=>
|
|
string(6) "ENTITY"
|
|
["ordinal"]=>
|
|
int(5)
|
|
}
|
|
[5]=>
|
|
array(5) {
|
|
["_id"]=>
|
|
string(1) "7"
|
|
["job"]=>
|
|
array(3) {
|
|
[0]=>
|
|
string(10) "Calciatore"
|
|
[1]=>
|
|
string(13) "Programmatore"
|
|
[2]=>
|
|
string(7) "Grafico"
|
|
}
|
|
["auto"]=>
|
|
string(3) "BMW"
|
|
["name"]=>
|
|
string(6) "ENTITY"
|
|
["ordinal"]=>
|
|
int(7)
|
|
}
|
|
}
|
|
done!%A
|