Return to lob_029.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/lob_029.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: reading/writing BFILE LOBs
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ob_start();
                      8: phpinfo(INFO_MODULES);
                      9: $phpinfo = ob_get_clean();
                     10: if (preg_match('/Compile-time ORACLE_HOME/', $phpinfo) !== 1) {
                     11:     // Assume building PHP with an ORACLE_HOME means the tested DB is on the same machine as PHP
                     12:     die("skip this test won't work with remote Oracle");
                     13: }
                     14: if (substr(PHP_OS, 0, 3) == 'WIN') die("skip Test script not ported to Windows");
                     15: ?>
                     16: --FILE--
                     17: <?php
                     18: 
                     19: require(dirname(__FILE__).'/connect.inc');
                     20: 
                     21: $realdirname = "/tmp";  // Use /tmp because a local dir can give ORA-22288 depending on perms
                     22: $realfilename1 = "oci8bfiletest1.txt";
                     23: $fullname1 = $realdirname."/".$realfilename1;
                     24: $realfilename2 = "oci8bfiletest2.txt";
                     25: $fullname2 = $realdirname."/".$realfilename2;
                     26: $realfilename3 = "oci8bfiletest3.txt";
                     27: $fullname3 = $realdirname."/".$realfilename3;
                     28: 
                     29: // Setup
                     30: $s = oci_parse($c, "drop table FileTest");
                     31: @oci_execute($s);
                     32: 
                     33: $s = oci_parse($c, "drop directory TestDir");
                     34: @oci_execute($s);
                     35: 
                     36: $s = oci_parse($c, "create directory TestDir as '$realdirname'");
                     37: oci_execute($s);
                     38: 
                     39: file_put_contents($fullname1, 'Some text in the bfile 1');
                     40: file_put_contents($fullname2, 'Some text in the bfile 2');
                     41: file_put_contents($fullname3, 'Some text in the bfile 3');
                     42: 
                     43: $s = oci_parse($c, "create table FileTest (FileNum number, FileDesc varchar2(30), Image bfile)");
                     44: oci_execute($s);
                     45: 
                     46: $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (1, 'Description 1', bfilename('TESTDIR', '$realfilename1'))");
                     47: oci_execute($s);
                     48: 
                     49: $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (2, 'Description 2', bfilename('TESTDIR', '$realfilename2'))");
                     50: oci_execute($s);
                     51: 
                     52: $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (3, 'Description 3', bfilename('TESTDIR', '$realfilename3'))");
                     53: oci_execute($s);
                     54: 
                     55: // Run tests
                     56: 
                     57: echo "Test 1. Check how many rows in the table\n";
                     58: 
                     59: $s = oci_parse($c, "select count(*) numrows from FileTest");
                     60: oci_execute($s);
                     61: oci_fetch_all($s, $res);
                     62: var_dump($res);
                     63: 
                     64: echo "Test 2\n";
                     65: $s = oci_parse($c, "select * from FileTest order by FileNum");
                     66: oci_execute($s);
                     67: oci_fetch_all($s, $res);
                     68: var_dump($res);
                     69: 
                     70: echo "Test 3\n";
                     71: $d = oci_new_descriptor($c, OCI_D_FILE);
                     72: 
                     73: $s = oci_parse($c, "insert into FileTest (FileNum, FileDesc, Image) values (2, 'Description 2', bfilename('TESTDIR', '$realfilename1')) returning Image into :im");
                     74: oci_bind_by_name($s, ":im", $d, -1, OCI_B_BFILE);
                     75: oci_execute($s);
                     76: 
                     77: $r = $d->read(40);
                     78: var_dump($r);
                     79: 
                     80: unlink($fullname1);
                     81: unlink($fullname2);
                     82: unlink($fullname3);
                     83: 
                     84: $s = oci_parse($c, "drop table FileTest");
                     85: oci_execute($s);
                     86: 
                     87: $s = oci_parse($c, "drop directory TestDir");
                     88: oci_execute($s);
                     89: 
                     90: echo "Done\n";
                     91: ?>
                     92: --EXPECTF-- 
                     93: Test 1. Check how many rows in the table
                     94: array(1) {
                     95:   ["NUMROWS"]=>
                     96:   array(1) {
                     97:     [0]=>
                     98:     string(1) "3"
                     99:   }
                    100: }
                    101: Test 2
                    102: array(3) {
                    103:   ["FILENUM"]=>
                    104:   array(3) {
                    105:     [0]=>
                    106:     string(1) "1"
                    107:     [1]=>
                    108:     string(1) "2"
                    109:     [2]=>
                    110:     string(1) "3"
                    111:   }
                    112:   ["FILEDESC"]=>
                    113:   array(3) {
                    114:     [0]=>
                    115:     string(13) "Description 1"
                    116:     [1]=>
                    117:     string(13) "Description 2"
                    118:     [2]=>
                    119:     string(13) "Description 3"
                    120:   }
                    121:   ["IMAGE"]=>
                    122:   array(3) {
                    123:     [0]=>
                    124:     string(24) "Some text in the bfile 1"
                    125:     [1]=>
                    126:     string(24) "Some text in the bfile 2"
                    127:     [2]=>
                    128:     string(24) "Some text in the bfile 3"
                    129:   }
                    130: }
                    131: Test 3
                    132: string(24) "Some text in the bfile 1"
                    133: Done