1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465 |
- --TEST--
- PostgreSQL pg_convert() (9.0+)
- --EXTENSIONS--
- pgsql
- --SKIPIF--
- <?php
- include("skipif.inc");
- skip_bytea_not_hex();
- ?>
- --FILE--
- <?php
- error_reporting(E_ALL);
- include 'config.inc';
- $db = pg_connect($conn_str);
- pg_query($db, "SET standard_conforming_strings = 0");
- $fields = array('num'=>'1234', 'str'=>'AAA', 'bin'=>'BBB');
- $converted = pg_convert($db, $table_name, $fields);
- var_dump($converted);
- /* Invalid values */
- try {
- $converted = pg_convert($db, $table_name, [5 => 'AAA']);
- } catch (\ValueError $e) {
- echo $e->getMessage(), \PHP_EOL;
- }
- try {
- $converted = pg_convert($db, $table_name, ['AAA']);
- } catch (\ValueError $e) {
- echo $e->getMessage(), \PHP_EOL;
- }
- try {
- $converted = pg_convert($db, $table_name, ['num' => []]);
- } catch (\TypeError $e) {
- echo $e->getMessage(), \PHP_EOL;
- }
- try {
- $converted = pg_convert($db, $table_name, ['num' => new stdClass()]);
- } catch (\TypeError $e) {
- echo $e->getMessage(), \PHP_EOL;
- }
- try {
- $converted = pg_convert($db, $table_name, ['num' => $db]);
- var_dump($converted);
- } catch (\TypeError $e) {
- echo $e->getMessage(), \PHP_EOL;
- }
- ?>
- --EXPECT--
- array(3) {
- [""num""]=>
- string(4) "1234"
- [""str""]=>
- string(6) "E'AAA'"
- [""bin""]=>
- string(12) "E'\\x424242'"
- }
- Array of values must be an associative array with string keys
- Array of values must be an associative array with string keys
- Values must be of type string|int|float|bool|null, array given
- Values must be of type string|int|float|bool|null, stdClass given
- Values must be of type string|int|float|bool|null, PgSql\Connection given
|