1--TEST-- 2PostgreSQL large object 3--EXTENSIONS-- 4pgsql 5--SKIPIF-- 6<?php include("inc/skipif.inc"); ?> 7--FILE-- 8<?php 9 10include('inc/config.inc'); 11 12$db = pg_connect($conn_str); 13 14echo "create/write/close LO\n"; 15pg_exec ($db, "BEGIN"); 16$oid = pg_lo_create ($db); 17if (!$oid) echo ("pg_lo_create() error\n"); 18$handle = pg_lo_open ($db, $oid, "w"); 19if (!$handle) echo ("pg_lo_open() error\n"); 20pg_lo_write ($handle, "large object data"); 21pg_lo_close ($handle); 22pg_exec ($db, "COMMIT"); 23 24echo "open/read/tell/seek/close LO\n"; 25pg_exec ($db, "BEGIN"); 26$handle = pg_lo_open ($db, $oid, "w"); 27var_dump(pg_lo_read($handle, 5)); 28var_dump(pg_lo_tell($handle)); 29var_dump(pg_lo_seek($handle, 2, /* PGSQL_SEEK_CUR */)); // This is the default so move cursor from 5 30var_dump(pg_lo_read($handle, 100)); // Read to the end because chunk is larger then remaining content 31var_dump(pg_lo_tell($handle)); 32var_dump(pg_lo_seek($handle, 0, PGSQL_SEEK_SET)); /* Reset cursor to beginning */ 33var_dump(pg_lo_read($handle)); 34var_dump(pg_lo_seek($handle, -4, PGSQL_SEEK_END)); /* Seek from the end */ 35var_dump(pg_lo_read($handle)); 36pg_lo_close($handle); 37pg_exec ($db, "COMMIT"); 38 39echo "open/read_all/close LO\n"; 40pg_exec ($db, "BEGIN"); 41$handle = pg_lo_open ($db, $oid, "w"); 42/* Will write to stdout */ 43$bytesWritten = pg_lo_read_all($handle); 44echo "\n"; 45var_dump($bytesWritten); 46if (pg_last_error($db)) echo "pg_lo_read_all() error\n".pg_last_error(); 47pg_lo_close($handle); 48pg_exec ($db, "COMMIT"); 49 50echo "unlink LO\n"; 51pg_exec ($db, "BEGIN"); 52pg_lo_unlink($db, $oid) or print("pg_lo_unlink() error 1\n"); 53pg_exec ($db, "COMMIT"); 54 55// more pg_lo_unlink() tests 56echo "Test without connection\n"; 57pg_exec ($db, "BEGIN"); 58$oid = pg_lo_create ($db) or print("pg_lo_create() error\n"); 59pg_lo_unlink($oid) or print("pg_lo_unlink() error 2\n"); 60pg_exec ($db, "COMMIT"); 61 62echo "Test with string oid value\n"; 63pg_exec ($db, "BEGIN"); 64$oid = pg_lo_create ($db) or print("pg_lo_create() error\n"); 65pg_lo_unlink($db, (string)$oid) or print("pg_lo_unlink() error 3\n"); 66pg_exec ($db, "COMMIT"); 67 68echo "import/export LO\n"; 69$path = __DIR__ . '/'; 70pg_query($db, 'BEGIN'); 71$oid = pg_lo_import($db, $path . 'php.gif'); 72pg_query($db, 'COMMIT'); 73pg_query($db, 'BEGIN'); 74@unlink($path . 'php.gif.exported'); 75pg_lo_export($db, $oid, $path . 'php.gif.exported'); 76if (!file_exists($path . 'php.gif.exported')) { 77 echo "Export failed\n"; 78} 79@unlink($path . 'php.gif.exported'); 80pg_query($db, 'COMMIT'); 81 82/* invalid OID values */ 83try { 84 pg_lo_create(-15); 85} catch (\ValueError $e) { 86 echo $e->getMessage(), \PHP_EOL; 87} 88try { 89 pg_lo_create($db, -15); 90} catch (\ValueError $e) { 91 echo $e->getMessage(), \PHP_EOL; 92} 93try { 94 pg_lo_create('giberrish'); 95} catch (\ValueError $e) { 96 echo $e->getMessage(), \PHP_EOL; 97} 98try { 99 pg_lo_create($db, 'giberrish'); 100} catch (\ValueError $e) { 101 echo $e->getMessage(), \PHP_EOL; 102} 103 104echo "OK"; 105?> 106--EXPECTF-- 107create/write/close LO 108open/read/tell/seek/close LO 109string(5) "large" 110int(5) 111bool(true) 112string(10) "bject data" 113int(17) 114bool(true) 115string(17) "large object data" 116bool(true) 117string(4) "data" 118open/read_all/close LO 119large object data 120int(17) 121unlink LO 122Test without connection 123 124Deprecated: pg_lo_unlink(): Automatic fetching of PostgreSQL connection is deprecated in %s on line %d 125Test with string oid value 126import/export LO 127 128Deprecated: pg_lo_create(): Automatic fetching of PostgreSQL connection is deprecated in %s on line %d 129Invalid OID value passed 130Invalid OID value passed 131 132Deprecated: pg_lo_create(): Automatic fetching of PostgreSQL connection is deprecated in %s on line %d 133Invalid OID value passed 134Invalid OID value passed 135OK 136
