diff options
Diffstat (limited to 'ext/pgsql/tests')
30 files changed, 0 insertions, 1002 deletions
diff --git a/ext/pgsql/tests/01createdb.phpt b/ext/pgsql/tests/01createdb.phpt deleted file mode 100644 index 15849396c6..0000000000 --- a/ext/pgsql/tests/01createdb.phpt +++ /dev/null @@ -1,28 +0,0 @@ ---TEST-- -PostgreSQL create db ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -// create test table - -include('config.inc'); - -$db = pg_connect($conn_str); -if (!@pg_num_rows(@pg_query($db, "SELECT * FROM ".$table_name))) -{ - @pg_query($db,$table_def); // Create table here - for ($i=0; $i < $num_test_record; $i++) { - pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');"); - } -} -else { - echo pg_last_error()."\n"; -} - -pg_close($db); - -echo "OK"; -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/02connection.phpt b/ext/pgsql/tests/02connection.phpt deleted file mode 100644 index f1258f6df1..0000000000 --- a/ext/pgsql/tests/02connection.phpt +++ /dev/null @@ -1,50 +0,0 @@ ---TEST-- -PostgreSQL connection ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -// connection function tests - -include('config.inc'); - -$db = pg_pconnect($conn_str); -if (pg_connection_status($db) != PGSQL_CONNECTION_OK) -{ - echo "pg_connection_status() error\n"; -} -if (!pg_connection_reset($db)) -{ - echo "pg_connection_reset() error\n"; -} -if (pg_connection_busy($db)) -{ - echo "pg_connection_busy() error\n"; -} -if (!pg_host($db)) -{ - echo "pg_host() error\n"; -} -if (!pg_dbname($db)) -{ - echo "pg_dbname() error\n"; -} -if (!pg_port($db)) -{ - echo "pg_port() error\n"; -} -if (pg_tty($db)) -{ - echo "pg_tty() error\n"; -} -if (pg_options($db)) -{ - echo "pg_options() error\n"; -} - -pg_close($db); - -echo "OK"; -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/03sync_query.phpt b/ext/pgsql/tests/03sync_query.phpt deleted file mode 100644 index 96827fe5a2..0000000000 --- a/ext/pgsql/tests/03sync_query.phpt +++ /dev/null @@ -1,53 +0,0 @@ ---TEST-- -PostgreSQL sync query ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -include('config.inc'); - -$db = pg_connect($conn_str); - -$result = pg_query($db, "SELECT * FROM ".$table_name.";"); -if (!($rows = pg_num_rows($result))) -{ - echo "pg_num_row() error\n"; -} -for ($i=0; $i < $rows; $i++) -{ - pg_fetch_array($result, $i, PGSQL_NUM); -} -for ($i=0; $i < $rows; $i++) -{ - pg_fetch_object($result); -} -for ($i=0; $i < $rows; $i++) -{ - pg_fetch_row($result, $i); -} -for ($i=0; $i < $rows; $i++) -{ - pg_fetch_result($result, $i, 0); -} - -pg_result_error($result); -pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); -pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";")); -pg_field_name($result, 0); -pg_field_num($result, $field_name); -pg_field_size($result, 0); -pg_field_type($result, 0); -pg_field_prtlen($result, 0); -pg_field_is_null($result, 0); - -$result = pg_query($db, "INSERT INTO ".$table_name." VALUES (9999, 'ABC');"); -pg_last_oid($result); - -pg_free_result($result); -pg_close($db); - -echo "OK"; -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/04async_query.phpt b/ext/pgsql/tests/04async_query.phpt deleted file mode 100644 index 7711240a79..0000000000 --- a/ext/pgsql/tests/04async_query.phpt +++ /dev/null @@ -1,65 +0,0 @@ ---TEST-- -PostgreSQL async query ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -include('config.inc'); - -$db = pg_connect($conn_str); - -if (!pg_send_query($db, "SELECT * FROM ".$table_name.";")) { - echo "pg_send_query() error\n"; -} -while(pg_connection_busy($db)); // busy wait: intended -if (pg_connection_status($db) === PGSQL_CONNECTION_BAD) { - echo "pg_connection_status() error\n"; -} -if (!($result = pg_get_result($db))) -{ - echo "pg_get_result() error\n"; -} - -if (!($rows = pg_num_rows($result))) { - echo "pg_num_rows() error\n"; -} -for ($i=0; $i < $rows; $i++) -{ - pg_fetch_array($result, $i, PGSQL_NUM); -} -for ($i=0; $i < $rows; $i++) -{ - pg_fetch_object($result); -} -for ($i=0; $i < $rows; $i++) -{ - pg_fetch_row($result, $i); -} -for ($i=0; $i < $rows; $i++) -{ - pg_fetch_result($result, $i, 0); -} - -pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";")); -pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";")); -pg_field_name($result, 0); -pg_field_num($result, $field_name); -pg_field_size($result, 0); -pg_field_type($result, 0); -pg_field_prtlen($result, 0); -pg_field_is_null($result, 0); - -if (!pg_send_query($db, "INSERT INTO ".$table_name." VALUES (8888, 'GGG');")) -{ - echo "pg_send_query() error\n"; -} - -pg_last_oid($result); -pg_free_result($result); - - -echo "OK"; -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/05large_object.phpt b/ext/pgsql/tests/05large_object.phpt deleted file mode 100644 index a6f30195ae..0000000000 --- a/ext/pgsql/tests/05large_object.phpt +++ /dev/null @@ -1,82 +0,0 @@ ---TEST-- -PostgreSQL large object ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -include('config.inc'); - -$db = pg_connect($conn_str); - -echo "create/write/close LO\n"; -pg_exec ($db, "begin"); -$oid = pg_lo_create ($db); -if (!$oid) echo ("pg_lo_create() error\n"); -$handle = pg_lo_open ($db, $oid, "w"); -if (!$handle) echo ("pg_lo_open() error\n"); -pg_lo_write ($handle, "large object data\n"); -pg_lo_close ($handle); -pg_exec ($db, "commit"); - -echo "open/read/tell/seek/close LO\n"; -pg_exec ($db, "begin"); -$handle = pg_lo_open ($db, $oid, "w"); -pg_lo_read($handle, 100); -pg_lo_tell($handle); -pg_lo_seek($handle, 2); -pg_lo_close($handle); -pg_exec ($db, "commit"); - -echo "open/read_all/close LO\n"; -pg_exec ($db, "begin"); -$handle = pg_lo_open ($db, $oid, "w"); -pg_lo_read_all($handle); -if (pg_last_error()) echo "pg_lo_read_all() error\n".pg_last_error(); -pg_lo_close($handle); -pg_exec ($db, "commit"); - -echo "unlink LO\n"; -pg_exec ($db, "begin"); -pg_lo_unlink($db, $oid) or print("pg_lo_unlink() error 1\n"); -pg_exec ($db, "commit"); - -// more pg_lo_unlink() tests -echo "Test without connection\n"; -pg_exec ($db, "begin"); -$oid = pg_lo_create ($db) or print("pg_lo_create() error\n"); -pg_lo_unlink($oid) or print("pg_lo_unlink() error 2\n"); -pg_exec ($db, "commit"); - -echo "Test with string oid value\n"; -pg_exec ($db, "begin"); -$oid = pg_lo_create ($db) or print("pg_lo_create() error\n"); -pg_lo_unlink($db, (string)$oid) or print("pg_lo_unlink() error 3\n"); -pg_exec ($db, "commit"); - -echo "import/export LO\n"; -$path = dirname(__FILE__) . '/'; -pg_query($db, 'begin'); -$oid = pg_lo_import($db, $path . 'php.gif'); -pg_query($db, 'commit'); -pg_query($db, 'begin'); -@unlink($path . 'php.gif.exported'); -pg_lo_export($oid, $path . 'php.gif.exported', $db); -if (!file_exists($path . 'php.gif.exported')) { - echo "Export failed\n"; -} -@unlink($path . 'php.gif.exported'); -pg_query($db, 'commit'); - -echo "OK"; -?> ---EXPECT-- -create/write/close LO -open/read/tell/seek/close LO -open/read_all/close LO -large object data -unlink LO -Test without connection -Test with string oid value -import/export LO -OK diff --git a/ext/pgsql/tests/06copy.phpt b/ext/pgsql/tests/06copy.phpt deleted file mode 100644 index e5823c43a5..0000000000 --- a/ext/pgsql/tests/06copy.phpt +++ /dev/null @@ -1,15 +0,0 @@ ---TEST-- -PostgreSQL copy functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -include('config.inc'); - - -echo "OK"; - -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/07optional.phpt b/ext/pgsql/tests/07optional.phpt deleted file mode 100644 index e73a9cffe0..0000000000 --- a/ext/pgsql/tests/07optional.phpt +++ /dev/null @@ -1,19 +0,0 @@ ---TEST-- -PostgreSQL optional functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -// optional functions - -include('config.inc'); - -$db = pg_connect($conn_str); -$enc = pg_client_encoding($db); - -pg_set_client_encoding($db, $enc); - -echo "OK"; -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/08escape.phpt b/ext/pgsql/tests/08escape.phpt deleted file mode 100644 index c5a3877e37..0000000000 --- a/ext/pgsql/tests/08escape.phpt +++ /dev/null @@ -1,69 +0,0 @@ ---TEST-- -PostgreSQL escape functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -include 'config.inc'; -define('FILE_NAME', dirname(__FILE__) . '/php.gif'); - -// pg_escape_string() test -$before = "ABC\\ABC\'"; -$expect = "ABC\\\\ABC\\'"; -$after = pg_escape_string($before); -if ($expect === $after) { - echo "pg_escape_string() is Ok\n"; -} -else { - echo "pg_escape_string() is NOT Ok\n"; - var_dump($before); - var_dump($after); - var_dump($expect); -} - -// pg_escape_bytea() test -$before = "ABC\\ABC"; -$expect = "ABC\\\\\\\\ABC"; -$after = pg_escape_bytea($before); -if ($expect === $after) { - echo "pg_escape_bytea() is Ok\n"; -} -else { - echo "pg_escape_byte() is NOT Ok\n"; - var_dump($before); - var_dump($after); - var_dump($expect); -} - -// Test using database -$data = file_get_contents(FILE_NAME); -$db = pg_connect($conn_str); - -// Insert binary to DB -$escaped_data = pg_escape_bytea($data); -pg_query("DELETE FROM ".$table_name." WHERE num = -9999;"); -$sql = "INSERT INTO ".$table_name." (num, bin) VALUES (-9999, CAST ('".$escaped_data."' AS BYTEA));"; -pg_query($db, $sql); - -// Retrieve binary from DB -$sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = -9999"; -$result = pg_query($db, $sql); -$row = pg_fetch_array($result, 0, PGSQL_ASSOC); - -// Compare -// Need to wait PostgreSQL 7.3.x for PQunescapeBytea() -// if ($data === pg_unescape_bytea($row['bin'])) { -// echo "pg_escape_bytea() actually works with databse\n"; -// } -// else { -// echo "pg_escape_bytea() is broken\n"; -// } - -?> ---EXPECT-- -pg_escape_string() is NOT Ok -string(9) "ABC\ABC\'" -string(12) "ABC\\ABC\\''" -string(10) "ABC\\ABC\'" -pg_escape_bytea() is Ok diff --git a/ext/pgsql/tests/09notice.phpt b/ext/pgsql/tests/09notice.phpt deleted file mode 100644 index ccb0c80823..0000000000 --- a/ext/pgsql/tests/09notice.phpt +++ /dev/null @@ -1,28 +0,0 @@ ---TEST-- -PostgreSQL notice function ---SKIPIF-- -<?php include("skipif.inc"); ?> ---INI-- -pgsql.log_notice=1 -pgsql.ignore_notices=0 ---FILE-- -<?php -include 'config.inc'; - -$db = pg_connect($conn_str); -pg_query($db, "BEGIN;"); -pg_query($db, "BEGIN;"); - -$msg = pg_last_notice($db); -if ($msg === FALSE) { - echo "Cannot find notice message in hash\n"; - var_dump($msg); -} -echo $msg."\n"; -echo "pg_last_notice() is Ok\n"; - -?> ---EXPECTF-- -Notice: pg_query(): %s already a transaction in progress in %s on line %d -%s already a transaction in progress -pg_last_notice() is Ok diff --git a/ext/pgsql/tests/10pg_convert.phpt b/ext/pgsql/tests/10pg_convert.phpt deleted file mode 100644 index b88b8e5798..0000000000 --- a/ext/pgsql/tests/10pg_convert.phpt +++ /dev/null @@ -1,26 +0,0 @@ ---TEST-- -PostgreSQL pg_convert() ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -error_reporting(E_ALL); - -include 'config.inc'; - -$db = pg_connect($conn_str); - -$fields = array('num'=>'1234', 'str'=>'AAA', 'bin'=>'BBB'); -$converted = pg_convert($db, $table_name, $fields); - -var_dump($converted); -?> ---EXPECT-- -array(3) { - ["num"]=> - string(4) "1234" - ["str"]=> - string(5) "'AAA'" - ["bin"]=> - string(5) "'BBB'" -} diff --git a/ext/pgsql/tests/11pg_meta_data.phpt b/ext/pgsql/tests/11pg_meta_data.phpt deleted file mode 100644 index a7f8ed47fc..0000000000 --- a/ext/pgsql/tests/11pg_meta_data.phpt +++ /dev/null @@ -1,64 +0,0 @@ ---TEST-- -PostgreSQL pg_metadata() ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -error_reporting(E_ALL); - -include 'config.inc'; - -$db = pg_connect($conn_str); - -$meta = pg_meta_data($db, $table_name); - -var_dump($meta); -?> ---EXPECT-- -array(3) { - ["num"]=> - array(6) { - ["num"]=> - int(1) - ["type"]=> - string(4) "int4" - ["len"]=> - int(4) - ["not null"]=> - bool(false) - ["has default"]=> - bool(false) - ["array dims"]=> - int(0) - } - ["str"]=> - array(6) { - ["num"]=> - int(2) - ["type"]=> - string(4) "text" - ["len"]=> - int(-1) - ["not null"]=> - bool(false) - ["has default"]=> - bool(false) - ["array dims"]=> - int(0) - } - ["bin"]=> - array(6) { - ["num"]=> - int(3) - ["type"]=> - string(5) "bytea" - ["len"]=> - int(-1) - ["not null"]=> - bool(false) - ["has default"]=> - bool(false) - ["array dims"]=> - int(0) - } -} diff --git a/ext/pgsql/tests/12pg_insert.phpt b/ext/pgsql/tests/12pg_insert.phpt deleted file mode 100644 index 8d98f220fd..0000000000 --- a/ext/pgsql/tests/12pg_insert.phpt +++ /dev/null @@ -1,21 +0,0 @@ ---TEST-- -PostgreSQL pg_insert() ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -error_reporting(E_ALL); - -include 'config.inc'; - -$db = pg_connect($conn_str); -$fields = array('num'=>'1234', 'str'=>'AAA', 'bin'=>'BBB'); - -pg_insert($db, $table_name, $fields) or print "Error in test 1\n"; -echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING)."\n"; - -echo "Ok\n"; -?> ---EXPECT-- -INSERT INTO php_pgsql_test (num,str,bin) VALUES (1234,'AAA','BBB'); -Ok diff --git a/ext/pgsql/tests/13pg_select.phpt b/ext/pgsql/tests/13pg_select.phpt deleted file mode 100644 index 55e88db731..0000000000 --- a/ext/pgsql/tests/13pg_select.phpt +++ /dev/null @@ -1,34 +0,0 @@ ---TEST-- -PostgreSQL pg_select() ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -error_reporting(E_ALL); - -include 'config.inc'; - -$db = pg_connect($conn_str); -$fields = array('num'=>'1234', 'str'=>'ABC', 'bin'=>'XYZ'); -$ids = array('num'=>'1234'); - -$res = pg_select($db, $table_name, $ids) or print "Error\n"; -var_dump($res); -echo pg_select($db, $table_name, $ids, PGSQL_DML_STRING)."\n"; -echo "Ok\n"; - -?> ---EXPECT-- -array(1) { - [0]=> - array(3) { - ["num"]=> - string(4) "1234" - ["str"]=> - string(3) "AAA" - ["bin"]=> - string(3) "BBB" - } -} -SELECT * FROM php_pgsql_test WHERE num=1234; -Ok diff --git a/ext/pgsql/tests/14pg_update.phpt b/ext/pgsql/tests/14pg_update.phpt deleted file mode 100644 index ef8d7e49bd..0000000000 --- a/ext/pgsql/tests/14pg_update.phpt +++ /dev/null @@ -1,22 +0,0 @@ ---TEST-- -PostgreSQL pg_update() ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -error_reporting(E_ALL); - -include 'config.inc'; - -$db = pg_connect($conn_str); -$fields = array('num'=>'1234', 'str'=>'ABC', 'bin'=>'XYZ'); -$ids = array('num'=>'1234'); - -pg_update($db, $table_name, $fields, $ids) or print "Error in test 1\n"; -echo pg_update($db, $table_name, $fields, $ids, PGSQL_DML_STRING)."\n"; - -echo "Ok\n"; -?> ---EXPECT-- -UPDATE php_pgsql_test SET num=1234,str='ABC',bin='XYZ' WHERE num=1234; -Ok diff --git a/ext/pgsql/tests/15pg_delete.phpt b/ext/pgsql/tests/15pg_delete.phpt deleted file mode 100644 index e35f4ba78e..0000000000 --- a/ext/pgsql/tests/15pg_delete.phpt +++ /dev/null @@ -1,23 +0,0 @@ ---TEST-- -PostgreSQL pg_delete() ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -error_reporting(E_ALL); - -include 'config.inc'; - -$db = pg_connect($conn_str); - -$fields = array('num'=>'1234', 'str'=>'XXX', 'bin'=>'YYY'); -$ids = array('num'=>'1234'); -if (!pg_delete($db, $table_name, $ids)) { - echo "Error\n"; -} -else { - echo "Ok\n"; -} -?> ---EXPECT-- -Ok diff --git a/ext/pgsql/tests/16pg_result_status.phpt b/ext/pgsql/tests/16pg_result_status.phpt deleted file mode 100644 index 268dc9fd64..0000000000 --- a/ext/pgsql/tests/16pg_result_status.phpt +++ /dev/null @@ -1,19 +0,0 @@ ---TEST-- -PostgreSQL pg_result_status() ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -include 'config.inc'; - -$db = pg_connect($conn_str); - -$sql = "SELECT * FROM ".$table_name." WHERE num = -2"; -$result = pg_query($db, "BEGIN;END"); - -echo pg_result_status($result)."\n"; -echo pg_result_status($result, PGSQL_STATUS_STRING)."\n"; -?> ---EXPECT-- -1 -COMMIT diff --git a/ext/pgsql/tests/17result.phpt b/ext/pgsql/tests/17result.phpt deleted file mode 100644 index c3f9959aa2..0000000000 --- a/ext/pgsql/tests/17result.phpt +++ /dev/null @@ -1,67 +0,0 @@ ---TEST-- -PostgreSQL pg_fetch_*() functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -error_reporting(E_ALL); - -include 'config.inc'; - -$db = pg_connect($conn_str); - -$sql = "SELECT * FROM $table_name"; -$result = pg_query($db, $sql) or die('Cannot qeury db'); -$rows = pg_num_rows($result); - -var_dump(pg_result_seek($result, 1)); -var_dump(pg_fetch_object($result)); -var_dump(pg_fetch_array($result, 1)); -var_dump(pg_fetch_row($result, 1)); -var_dump(pg_fetch_assoc($result, 1)); -var_dump(pg_result_seek($result, 0)); - -echo "Ok\n"; -?> ---EXPECT-- -bool(true) -object(stdClass)#1 (3) { - ["num"]=> - string(1) "1" - ["str"]=> - string(3) "ABC" - ["bin"]=> - NULL -} -array(6) { - [0]=> - string(1) "1" - ["num"]=> - string(1) "1" - [1]=> - string(3) "ABC" - ["str"]=> - string(3) "ABC" - [2]=> - NULL - ["bin"]=> - NULL -} -array(3) { - [0]=> - string(1) "1" - [1]=> - string(3) "ABC" - [2]=> - NULL -} -array(3) { - ["num"]=> - string(1) "1" - ["str"]=> - string(3) "ABC" - ["bin"]=> - NULL -} -bool(true) -Ok diff --git a/ext/pgsql/tests/18pg_escape_bytea.phpt b/ext/pgsql/tests/18pg_escape_bytea.phpt deleted file mode 100644 index 43f98c4467..0000000000 --- a/ext/pgsql/tests/18pg_escape_bytea.phpt +++ /dev/null @@ -1,28 +0,0 @@ ---TEST-- -PostgreSQL pg_escape_bytea() functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -// optional functions - -include('config.inc'); - -$image = file_get_contents(dirname(__FILE__) . '/php.gif'); -$esc_image = pg_escape_bytea($image); - -$db = pg_connect($conn_str); -pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');'); -$result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876'); -$rows = pg_fetch_all($result); -$unesc_image = pg_unescape_bytea($rows[0]['bin']); - -if ($unesc_image !== $image) { - echo "NG"; -} -else { - echo "OK"; -} -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/19pg_ping.phpt b/ext/pgsql/tests/19pg_ping.phpt deleted file mode 100644 index 9059bde470..0000000000 --- a/ext/pgsql/tests/19pg_ping.phpt +++ /dev/null @@ -1,15 +0,0 @@ ---TEST-- -PostgreSQL pg_ping() functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -// optional functions - -include('config.inc'); - -$db = pg_connect($conn_str); -var_dump(pg_ping($db)); -?> ---EXPECT-- -bool(true) diff --git a/ext/pgsql/tests/20pg_get_pid.phpt b/ext/pgsql/tests/20pg_get_pid.phpt deleted file mode 100644 index 06cdfa8656..0000000000 --- a/ext/pgsql/tests/20pg_get_pid.phpt +++ /dev/null @@ -1,17 +0,0 @@ ---TEST-- -PostgreSQL pg_get_pid() functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -// optional functions - -include('config.inc'); - -$db = pg_connect($conn_str); -$pid = pg_get_pid($db); - -is_integer($pid) ? print 'OK' : print 'NG'; -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/21pg_get_notify.phpt b/ext/pgsql/tests/21pg_get_notify.phpt deleted file mode 100644 index 9171fc01aa..0000000000 --- a/ext/pgsql/tests/21pg_get_notify.phpt +++ /dev/null @@ -1,20 +0,0 @@ ---TEST-- -PostgreSQL pg_get_notify() functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -// optional functions - -include('config.inc'); - -$db = pg_connect($conn_str); -pg_query($db, 'LISTEN test_msg'); -pg_query($db, 'NOTIFY test_msg'); - -$msg = pg_get_notify($db); - -isset($msg['message'],$msg['pid']) ? print 'OK' : print 'NG'; -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/22pg_fetch_object.phpt b/ext/pgsql/tests/22pg_fetch_object.phpt deleted file mode 100755 index d0b406d879..0000000000 --- a/ext/pgsql/tests/22pg_fetch_object.phpt +++ /dev/null @@ -1,37 +0,0 @@ ---TEST-- -PostgreSQL pg_fetch_*() functions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -error_reporting(E_ALL); - -include 'config.inc'; - -class test_class { - function __construct($arg1, $arg2) { - echo __METHOD__ . "($arg1,$arg2)\n"; - } -} - -$db = pg_connect($conn_str); - -$sql = "SELECT * FROM $table_name"; -$result = pg_query($db, $sql) or die('Cannot qeury db'); -$rows = pg_num_rows($result); - -var_dump(pg_fetch_object($result, 'test_class', array(1, 2))); - -echo "Ok\n"; -?> ---EXPECT-- -test_class::__construct(1,2) -object(test_class)#1 (3) { - ["num"]=> - string(1) "0" - ["str"]=> - string(3) "ABC" - ["bin"]=> - NULL -} -Ok diff --git a/ext/pgsql/tests/80_bug14383.phpt b/ext/pgsql/tests/80_bug14383.phpt deleted file mode 100644 index c60e11c19a..0000000000 --- a/ext/pgsql/tests/80_bug14383.phpt +++ /dev/null @@ -1,37 +0,0 @@ ---TEST-- -Bug #14383 ---SKIPIF-- -<?php -require_once(dirname(__FILE__).'/../../dba/tests/skipif.inc'); -require_once('skipif.inc'); -?> ---FILE-- -<?php -require_once('config.inc'); - -$dbh = @pg_connect($conn_str); -if (!$dbh) { - die ("Could not connect to the server"); -} -pg_close($dbh); - -require_once(dirname(__FILE__).'/../../dba/tests/test.inc'); -require_once(dirname(__FILE__).'/../../dba/tests/dba_handler.inc'); - -?> ---EXPECTF-- -database handler: %s -3NYNYY -Content String 2 -Content 2 replaced -Read during write:%sallowed -Content 2 replaced 2nd time -The 6th value -array(3) { - ["key number 6"]=> - string(13) "The 6th value" - ["key2"]=> - string(27) "Content 2 replaced 2nd time" - ["key5"]=> - string(23) "The last content string" -}
\ No newline at end of file diff --git a/ext/pgsql/tests/80_bug24499.phpt b/ext/pgsql/tests/80_bug24499.phpt deleted file mode 100755 index ddb3c58a21..0000000000 --- a/ext/pgsql/tests/80_bug24499.phpt +++ /dev/null @@ -1,66 +0,0 @@ ---TEST-- -Bug #24499 Notice: Undefined property: stdClass:: ---SKIPIF-- -<?php -require_once('skipif.inc'); -?> ---FILE-- -<?php - -require_once('config.inc'); - -$dbh = @pg_connect($conn_str); -if (!$dbh) { - die ("Could not connect to the server"); -} - -@pg_query("DROP SEQUENCE id_id_seq"); -@pg_query("DROP TABLE id"); -pg_query("CREATE TABLE id (id SERIAL, t INT)"); - -for ($i=0; $i<4; $i++) { - pg_query("INSERT INTO id (t) VALUES ($i)"); -} - -class Id -{ - public $id; - - public function getId() - { - global $dbh; - - $q = pg_query($dbh, "SELECT id FROM id"); - print_r(pg_fetch_array($q)); - print_r(pg_fetch_array($q)); - $id = pg_fetch_object($q); - var_dump($id); - return $id->id; - } -} - -$id = new Id(); -var_dump($id->getId()); - -pg_close($dbh); - -echo "Done\n"; - -?> ---EXPECTF-- -Array -( - [0] => 1 - [id] => 1 -) -Array -( - [0] => 2 - [id] => 2 -) -object(stdClass)#%d (1) { - ["id"]=> - string(1) "3" -} -string(1) "3" -Done diff --git a/ext/pgsql/tests/98old_api.phpt b/ext/pgsql/tests/98old_api.phpt deleted file mode 100644 index 2667e097e3..0000000000 --- a/ext/pgsql/tests/98old_api.phpt +++ /dev/null @@ -1,33 +0,0 @@ ---TEST-- -PostgreSQL old api ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -include('config.inc'); - -$db = pg_connect($conn_str); -$result = pg_exec("SELECT * FROM ".$table_name); -pg_numrows($result); -pg_numfields($result); -pg_fieldname($result, 0); -pg_fieldsize($result, $field_name); -pg_fieldtype($result, 0); -pg_fieldprtlen($result, 0); -pg_fieldisnull($result, 0); - -pg_result($result,0,0); -$result = pg_exec("INSERT INTO ".$table_name." VALUES (7777, 'KKK')"); -$oid = pg_getlastoid($result); -pg_freeresult($result); -pg_errormessage(); -$result = pg_exec("UPDATE ".$table_name." SET str = 'QQQ' WHERE str like 'RGD';"); -pg_cmdtuples($result); - - - -echo "OK"; -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/9999dropdb.phpt b/ext/pgsql/tests/9999dropdb.phpt deleted file mode 100644 index c60eeda8d6..0000000000 --- a/ext/pgsql/tests/9999dropdb.phpt +++ /dev/null @@ -1,18 +0,0 @@ ---TEST-- -PostgreSQL drop db ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php -// drop test table - -include('config.inc'); - -$db = pg_connect($conn_str); -pg_query($db, "DROP TABLE ".$table_name); - -echo "OK"; - -?> ---EXPECT-- -OK diff --git a/ext/pgsql/tests/README b/ext/pgsql/tests/README deleted file mode 100644 index 1a29a34e64..0000000000 --- a/ext/pgsql/tests/README +++ /dev/null @@ -1,16 +0,0 @@ -Test scripts assumes: - - PostgreSQL server is installed locally - - there is a PostgreSQL account for the users running the test scripts - - there is database named "test" - -For instance, if your login name is 'testuser', you should have PostgreSQL -user account named 'testuser' and grant that user access to the database -'test'. - -If you have account and database, type "createdb test" from command prompt -to create the database to execute the test scripts. By executing the above -command as the same user running the tests you ensure that the user is -granted access to the database. - -If you find problems in PostgreSQL module, please mail to -intenals@lists.php.net, helly@php.net or yohgaki@php.net. diff --git a/ext/pgsql/tests/config.inc b/ext/pgsql/tests/config.inc deleted file mode 100644 index 2b5f05a71d..0000000000 --- a/ext/pgsql/tests/config.inc +++ /dev/null @@ -1,12 +0,0 @@ -<?php -// These vars are used to connect db and create test table. -// values can be set to meet your environment - -$conn_str = "host=localhost dbname=test"; // connection string -$table_name = "php_pgsql_test"; // test table that should be exist -$num_test_record = 1000; // Number of records to create - -$table_def = "CREATE TABLE php_pgsql_test (num int, str text, bin bytea);"; // Test table -$field_name = "num"; // For pg_field_num() - -?>
\ No newline at end of file diff --git a/ext/pgsql/tests/php.gif b/ext/pgsql/tests/php.gif Binary files differdeleted file mode 100644 index 7beda43fd4..0000000000 --- a/ext/pgsql/tests/php.gif +++ /dev/null diff --git a/ext/pgsql/tests/skipif.inc b/ext/pgsql/tests/skipif.inc deleted file mode 100644 index 043a0bd8d2..0000000000 --- a/ext/pgsql/tests/skipif.inc +++ /dev/null @@ -1,18 +0,0 @@ -<?php -// This script prints "skip" unless: -// * the pgsql extension is built-in or loadable, AND -// * there is a database called "test" accessible -// with no username/password, AND -// * we have create/drop privileges on the entire "test" -// database - -include("config.inc"); - -if (!extension_loaded("pgsql")) { - die("skip\n"); -} -$conn = @pg_connect($conn_str); -if (!is_resource($conn)) { - die("skip could not connect\n"); -} -?>
\ No newline at end of file |
