diff options
Diffstat (limited to 'ext/pgsql/tests/large_object.inc')
| -rw-r--r-- | ext/pgsql/tests/large_object.inc | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/ext/pgsql/tests/large_object.inc b/ext/pgsql/tests/large_object.inc index 5b8d1f8b72..f21912b5b6 100644 --- a/ext/pgsql/tests/large_object.inc +++ b/ext/pgsql/tests/large_object.inc @@ -3,6 +3,8 @@ include('config.inc'); $db = pg_connect($conn_str); + +// create/write/close LO pg_exec ($db, "begin"); $oid = pg_lo_create ($db); if (!$oid) echo ("pg_lo_create() error\n"); @@ -12,6 +14,7 @@ pg_lo_write ($handle, "large object data\n"); pg_lo_close ($handle); pg_exec ($db, "commit"); +// open/read/tell/seek/close LO pg_exec ($db, "begin"); $handle = pg_lo_open ($db, $oid, "w"); pg_lo_read($handle, 100); @@ -20,6 +23,7 @@ pg_lo_seek($handle, 2); pg_lo_close($handle); pg_exec ($db, "commit"); +// open/read_all/close LO pg_exec ($db, "begin"); $handle = pg_lo_open ($db, $oid, "w"); pg_lo_read_all($handle); @@ -27,6 +31,7 @@ if (pg_last_error()) echo "pg_lo_read_all() error\n".pg_last_error(); pg_lo_close($handle); pg_exec ($db, "commit"); +// unlink LO pg_exec ($db, "begin"); pg_lo_unlink($db, $oid) or print("pg_lo_unlink() error\n"); pg_exec ($db, "commit"); @@ -44,6 +49,19 @@ $oid = pg_lo_create ($db) or print("pg_lo_create() error\n"); pg_lo_unlink($db, (string)$oid) or print("pg_lo_unlink() error\n"); pg_exec ($db, "commit"); +// import/export LO +pg_query($db, 'begin'); +$oid = pg_lo_import($db, 'php.gif'); +pg_query($db, 'commit'); +pg_query($db, 'begin'); +@unlink('php.gif.exported'); +pg_lo_export($oid, 'php.gif.exported', $db); +if (!file_exists('php.gif.exported')) { + echo "Export failed\n"; +} +@unlink('php.gif.exported'); +pg_query($db, 'commit'); + echo "OK"; ?>
\ No newline at end of file |