summaryrefslogtreecommitdiff
path: root/ext/pgsql/tests/10pg_convert_json_array.phpt
diff options
context:
space:
mode:
Diffstat (limited to 'ext/pgsql/tests/10pg_convert_json_array.phpt')
-rw-r--r--ext/pgsql/tests/10pg_convert_json_array.phpt37
1 files changed, 37 insertions, 0 deletions
diff --git a/ext/pgsql/tests/10pg_convert_json_array.phpt b/ext/pgsql/tests/10pg_convert_json_array.phpt
new file mode 100644
index 0000000000..960cfd6c99
--- /dev/null
+++ b/ext/pgsql/tests/10pg_convert_json_array.phpt
@@ -0,0 +1,37 @@
+--TEST--
+PostgreSQL pg_convert() and JSON/Array
+--SKIPIF--
+<?php
+include("skipif.inc");
+skip_server_version('9.2');
+?>
+--FILE--
+<?php
+error_reporting(E_ALL);
+
+include 'config.inc';
+
+$db = pg_connect($conn_str);
+
+$fields = array(
+ 'textary'=>'{"meeting", "lunch", "training", "presentation"}',
+ 'jsn'=>'{"f1":1,"f2":"foo"}',
+);
+$converted = pg_convert($db, $table_name_92, $fields);
+var_dump($converted);
+
+if (!pg_insert($db, $table_name_92, $fields)) {
+ echo "Error\n";
+} else {
+ echo "OK\n";
+}
+
+?>
+--EXPECT--
+array(2) {
+ [""textary""]=>
+ string(51) "E'{"meeting", "lunch", "training", "presentation"}'"
+ [""jsn""]=>
+ string(22) "E'{"f1":1,"f2":"foo"}'"
+}
+OK