cvs: php4 /ext/pgsql/tests 08escape.phpt escape.inc php.gif

yohgaki Fri Apr 5 01:05:29 2002 EDT Added files: /php4/ext/pgsql/tests php.gif Modified files: /php4/ext/pgsql/tests escape.inc 08escape.phpt Log: Add real pg_escape_bytea() test. Index: php4/ext/pgsql/tests/escape.inc diff -u php4/ext/pgsql/tests/escape.inc:1.2 php4/ext/pgsql/tests/escape.inc:1.3 --- php4/ext/pgsql/tests/escape.inc:1.2 Thu Apr 4 10:25:46 2002 +++ php4/ext/pgsql/tests/escape.inc Fri Apr 5 01:05:28 2002 @@ -1,6 +1,11 @@ <?php -$before = "ABC\\ABC"; -$expect = "ABC\\\\ABC"; + +include 'config.inc'; +define('FILE_NAME', './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"; @@ -12,6 +17,7 @@ var_dump($expect); } +// pg_escape_bytea() test $before = "ABC\\ABC"; $expect = "ABC\\\\\\\\ABC"; $after = pg_escape_bytea($before); @@ -23,6 +29,28 @@ var_dump($before); var_dump($after); var_dump($expect); +} + +// Test using database +$fp = fopen(FILE_NAME,'r'); +$data = fread($fp, filesize(FILE_NAME)); + +$db = pg_connect($conn_str); +$escaped_data = pg_escape_bytea($data); +//$out = fopen('php.gif_escaped','w'); +//fwrite($out, $escaped_data); +//exit; +pg_query("DELETE FROM ".$table_name." WHERE num = -2;"); +$sql = "INSERT INTO ".$table_name." (num, bin) VALUES (-2, '".$escaped_data."');"; +pg_query($db, $sql); +$sql = "SELECT * FROM ".$table_name." WHERE num = -2"; +$result = pg_query($db, $sql); +$row = pg_fetch_row($result, 0); +if ($data === $row['bin']) { + echo "pg_escape_bytea actually works\n"; +} +else { + echo "pg_escape_bytea is broken\n"; } ?> Index: php4/ext/pgsql/tests/08escape.phpt diff -u php4/ext/pgsql/tests/08escape.phpt:1.2 php4/ext/pgsql/tests/08escape.phpt:1.3 --- php4/ext/pgsql/tests/08escape.phpt:1.2 Thu Apr 4 10:25:46 2002 +++ php4/ext/pgsql/tests/08escape.phpt Fri Apr 5 01:05:28 2002 @@ -9,3 +9,4 @@ --EXPECT-- pg_escape_string() is Ok pg_escape_bytea() is Ok +pg_escape_bytea() actually works with databse