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