Return to lob_030.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Test piecewise fetch of CLOBs equal to, and larger than PHP_OCI_LOB_BUFFER_SIZE
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?> 
                      8: --FILE--
                      9: <?php
                     10: 
                     11: require dirname(__FILE__).'/connect.inc';
                     12: require dirname(__FILE__).'/create_table.inc';
                     13: 
                     14: function insert_verify($c, $tn, $id, $length)
                     15: {
                     16:     // Insert the data
                     17:     $ora_sql = "INSERT INTO
                     18:                        ".$tn." (id, clob)
                     19:                       VALUES (".$id.", empty_clob())
                     20:                       RETURNING
                     21:                                clob
                     22:                       INTO :v_clob ";
                     23: 
                     24:     $statement = oci_parse($c,$ora_sql);
                     25:     $clob = oci_new_descriptor($c,OCI_D_LOB);
                     26:     oci_bind_by_name($statement,":v_clob", $clob, -1, OCI_B_CLOB);
                     27:     oci_execute($statement, OCI_DEFAULT);
                     28: 
                     29:     $data = str_pad("x", $length, "x");
                     30:     $clob->write($data);
                     31: 
                     32:     // Verify the data
                     33:     $select_sql = "SELECT clob FROM ".$tn." where id = ".$id;
                     34:     $s = oci_parse($c, $select_sql);
                     35:     oci_execute($s);
                     36: 
                     37:     $row = oci_fetch_array($s, OCI_RETURN_LOBS);
                     38: 
                     39:     var_dump(strlen($row[0]));
                     40: }
                     41: 
                     42: echo "Test 1: A CLOB with an even number of bytes\n";
                     43: insert_verify($c, $schema.$table_name, 1, 1050000);
                     44: 
                     45: echo "Test 2: A CLOB with an odd number of bytes\n";
                     46: insert_verify($c, $schema.$table_name, 2, 1050001);
                     47: 
                     48: echo "Test 3: A CLOB of 1048576 bytes (== size of PHP_OCI_LOB_BUFFER_SIZE at time of test creation)\n";
                     49: insert_verify($c, $schema.$table_name, 3, 1048576);
                     50: 
                     51: echo "Test 4: A CLOB of 1049028 bytes (the value used for chunks in the code)\n";
                     52: insert_verify($c, $schema.$table_name, 4, 1049028);
                     53: 
                     54: echo "Test 5: A CLOB of 1049028-1 bytes\n";
                     55: insert_verify($c, $schema.$table_name, 5, 1049028-1);
                     56: 
                     57: echo "Test 6: A CLOB of 1049028+1 bytes\n";
                     58: insert_verify($c, $schema.$table_name, 6, 1049028+1);
                     59: 
                     60: require dirname(__FILE__).'/drop_table.inc';
                     61: 
                     62: echo "Done\n";
                     63: 
                     64: ?>
                     65: --EXPECTF--
                     66: Test 1: A CLOB with an even number of bytes
                     67: int(1050000)
                     68: Test 2: A CLOB with an odd number of bytes
                     69: int(1050001)
                     70: Test 3: A CLOB of 1048576 bytes (== size of PHP_OCI_LOB_BUFFER_SIZE at time of test creation)
                     71: int(1048576)
                     72: Test 4: A CLOB of 1049028 bytes (the value used for chunks in the code)
                     73: int(1049028)
                     74: Test 5: A CLOB of 1049028-1 bytes
                     75: int(1049027)
                     76: Test 6: A CLOB of 1049028+1 bytes
                     77: int(1049029)
                     78: Done