Return to 08escape.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pgsql / tests

Annotation of embedaddon/php/ext/pgsql/tests/08escape.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PostgreSQL escape functions
        !             3: --SKIPIF--
        !             4: <?php include("skipif.inc"); ?>
        !             5: --FILE--
        !             6: <?php
        !             7: 
        !             8: include 'config.inc';
        !             9: define('FILE_NAME', dirname(__FILE__) . '/php.gif');
        !            10: 
        !            11: // pg_escape_string() test
        !            12: $before = "ABC\\ABC\'";
        !            13: $expect  = "ABC\\\\ABC\\'";
        !            14: $after = pg_escape_string($before);
        !            15: if ($expect === $after) {
        !            16:        echo "pg_escape_string() is Ok\n";
        !            17: }
        !            18: else {
        !            19:        echo "pg_escape_string() is NOT Ok\n";
        !            20:        var_dump($before);
        !            21:        var_dump($after);
        !            22:        var_dump($expect);
        !            23: }
        !            24: 
        !            25: // pg_escape_bytea() test
        !            26: $before = "ABC\\ABC";
        !            27: $expect  = "ABC\\\\\\\\ABC";
        !            28: $after  = pg_escape_bytea($before);
        !            29: if ($expect === $after) {
        !            30:        echo "pg_escape_bytea() is Ok\n";
        !            31: }
        !            32: else {
        !            33:        echo "pg_escape_byte() is NOT Ok\n";
        !            34:        var_dump($before);
        !            35:        var_dump($after);
        !            36:        var_dump($expect);
        !            37: }
        !            38: 
        !            39: // Test using database
        !            40: $data = file_get_contents(FILE_NAME);
        !            41: $db   = pg_connect($conn_str);
        !            42: 
        !            43: // Insert binary to DB
        !            44: $escaped_data = pg_escape_bytea($data);
        !            45: pg_query("DELETE FROM ".$table_name." WHERE num = -9999;");
        !            46: $sql = "INSERT INTO ".$table_name." (num, bin) VALUES (-9999, CAST ('".$escaped_data."' AS BYTEA));";
        !            47: pg_query($db, $sql);
        !            48: 
        !            49: // Retrieve binary from DB
        !            50: $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = -9999";
        !            51: $result = pg_query($db, $sql);
        !            52: $row = pg_fetch_array($result, 0, PGSQL_ASSOC);
        !            53: 
        !            54: if ($data === pg_unescape_bytea($row['bin'])) {
        !            55:        echo "pg_escape_bytea() actually works with database\n";
        !            56: }
        !            57: else {
        !            58:        echo "pg_escape_bytea() is broken\n";
        !            59: }
        !            60: 
        !            61: ?>
        !            62: --EXPECT--
        !            63: pg_escape_string() is NOT Ok
        !            64: string(9) "ABC\ABC\'"
        !            65: string(12) "ABC\\ABC\\''"
        !            66: string(10) "ABC\\ABC\'"
        !            67: pg_escape_bytea() is Ok
        !            68: pg_escape_bytea() actually works with database