Return to 05large_object.phpt CVS log

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

Annotation of embedaddon/php/ext/pgsql/tests/05large_object.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PostgreSQL large object
        !             3: --SKIPIF--
        !             4: <?php include("skipif.inc"); ?>
        !             5: --FILE--
        !             6: <?php
        !             7: 
        !             8: include('config.inc');
        !             9: 
        !            10: $db = pg_connect($conn_str);
        !            11: 
        !            12: echo "create/write/close LO\n";
        !            13: pg_exec ($db, "begin");
        !            14: $oid = pg_lo_create ($db);
        !            15: if (!$oid) echo ("pg_lo_create() error\n");
        !            16: $handle = pg_lo_open ($db, $oid, "w");
        !            17: if (!$handle) echo ("pg_lo_open() error\n");
        !            18: pg_lo_write ($handle, "large object data\n");
        !            19: pg_lo_close ($handle);
        !            20: pg_exec ($db, "commit");
        !            21: 
        !            22: echo "open/read/tell/seek/close LO\n";
        !            23: pg_exec ($db, "begin");
        !            24: $handle = pg_lo_open ($db, $oid, "w");
        !            25: pg_lo_read($handle, 100);
        !            26: pg_lo_tell($handle);
        !            27: pg_lo_seek($handle, 2);
        !            28: pg_lo_close($handle);
        !            29: pg_exec ($db, "commit");
        !            30: 
        !            31: echo "open/read_all/close LO\n";
        !            32: pg_exec ($db, "begin");
        !            33: $handle = pg_lo_open ($db, $oid, "w");
        !            34: pg_lo_read_all($handle);
        !            35: if (pg_last_error()) echo "pg_lo_read_all() error\n".pg_last_error();
        !            36: pg_lo_close($handle);
        !            37: pg_exec ($db, "commit");
        !            38: 
        !            39: echo "unlink LO\n";
        !            40: pg_exec ($db, "begin");
        !            41: pg_lo_unlink($db, $oid) or print("pg_lo_unlink() error 1\n");
        !            42: pg_exec ($db, "commit");
        !            43: 
        !            44: // more pg_lo_unlink() tests
        !            45: echo "Test without connection\n";
        !            46: pg_exec ($db, "begin");
        !            47: $oid = pg_lo_create ($db) or print("pg_lo_create() error\n");
        !            48: pg_lo_unlink($oid) or print("pg_lo_unlink() error 2\n");
        !            49: pg_exec ($db, "commit");
        !            50: 
        !            51: echo "Test with string oid value\n";
        !            52: pg_exec ($db, "begin");
        !            53: $oid = pg_lo_create ($db) or print("pg_lo_create() error\n");
        !            54: pg_lo_unlink($db, (string)$oid) or print("pg_lo_unlink() error 3\n");
        !            55: pg_exec ($db, "commit");
        !            56: 
        !            57: echo "import/export LO\n";
        !            58: $path = dirname(__FILE__) . '/';
        !            59: pg_query($db, 'begin');
        !            60: $oid = pg_lo_import($db, $path . 'php.gif');
        !            61: pg_query($db, 'commit');
        !            62: pg_query($db, 'begin');
        !            63: @unlink($path . 'php.gif.exported');
        !            64: pg_lo_export($oid, $path . 'php.gif.exported', $db);
        !            65: if (!file_exists($path . 'php.gif.exported')) {
        !            66:        echo "Export failed\n";
        !            67: }
        !            68: @unlink($path . 'php.gif.exported');
        !            69: pg_query($db, 'commit');
        !            70: 
        !            71: echo "OK";
        !            72: ?>
        !            73: --EXPECT--
        !            74: create/write/close LO
        !            75: open/read/tell/seek/close LO
        !            76: open/read_all/close LO
        !            77: large object data
        !            78: unlink LO
        !            79: Test without connection
        !            80: Test with string oid value
        !            81: import/export LO
        !            82: OK