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
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>