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

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