diff options
Diffstat (limited to 'ext/pgsql/tests/08escape.phpt')
-rw-r--r-- | ext/pgsql/tests/08escape.phpt | 72 |
1 files changed, 36 insertions, 36 deletions
diff --git a/ext/pgsql/tests/08escape.phpt b/ext/pgsql/tests/08escape.phpt index 6b0d1899d4..6b510aef73 100644 --- a/ext/pgsql/tests/08escape.phpt +++ b/ext/pgsql/tests/08escape.phpt @@ -14,13 +14,13 @@ $expect = "ABC\\\\ABC\\'"; $expect2 = "ABC\\\\ABC\\\\''"; //the way escape string differs from PostgreSQL 9.0 $after = pg_escape_string($before); if ($expect === $after || $expect2 === $after) { - echo "pg_escape_string() is Ok\n"; + 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); + echo "pg_escape_string() is NOT Ok\n"; + var_dump($before); + var_dump($after); + var_dump($expect); } // pg_escape_bytea() test @@ -28,13 +28,13 @@ $before = "ABC\\ABC"; $expect = "ABC\\\\\\\\ABC"; $after = pg_escape_bytea($before); if ($expect === $after) { - echo "pg_escape_bytea() is Ok\n"; + 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); + echo "pg_escape_byte() is NOT Ok\n"; + var_dump($before); + var_dump($after); + var_dump($expect); } // Test using database @@ -49,23 +49,23 @@ pg_query($db, $sql); // Retrieve binary from DB for ($i = 0; $i < 2; $i++) { - $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = 10000"; - $result = pg_query($db, $sql); - $row = pg_fetch_array($result, 0, PGSQL_ASSOC); + $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = 10000"; + $result = pg_query($db, $sql); + $row = pg_fetch_array($result, 0, PGSQL_ASSOC); - if ($data === pg_unescape_bytea($row['bin'])) { - echo "pg_escape_bytea() actually works with database\n"; - break; - } - elseif (!$i) { - // Force bytea escaping and retry - @pg_query($db, "SET bytea_output = 'escape'"); - } - else { - $result = pg_query($db, $sql); - echo "pg_escape_bytea() is broken\n"; - break; - } + if ($data === pg_unescape_bytea($row['bin'])) { + echo "pg_escape_bytea() actually works with database\n"; + break; + } + elseif (!$i) { + // Force bytea escaping and retry + @pg_query($db, "SET bytea_output = 'escape'"); + } + else { + $result = pg_query($db, $sql); + echo "pg_escape_bytea() is broken\n"; + break; + } } // pg_escape_literal/pg_escape_identifier @@ -73,26 +73,26 @@ $before = "ABC\\ABC\'"; $expect = " E'ABC\\\\ABC\\\\'''"; $after = pg_escape_literal($before); if ($expect === $after) { - echo "pg_escape_literal() is Ok\n"; + echo "pg_escape_literal() is Ok\n"; } else { - echo "pg_escape_literal() is NOT Ok\n"; - var_dump($before); - var_dump($after); - var_dump($expect); + echo "pg_escape_literal() is NOT Ok\n"; + var_dump($before); + var_dump($after); + var_dump($expect); } $before = "ABC\\ABC\'"; $expect = "\"ABC\ABC\'\""; $after = pg_escape_identifier($before); if ($expect === $after) { - echo "pg_escape_identifier() is Ok\n"; + echo "pg_escape_identifier() is Ok\n"; } else { - echo "pg_escape_identifier() is NOT Ok\n"; - var_dump($before); - var_dump($after); - var_dump($expect); + echo "pg_escape_identifier() is NOT Ok\n"; + var_dump($before); + var_dump($after); + var_dump($expect); } ?> |