Return to lob_001.phpt CVS log

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

Annotation of embedaddon/php/ext/oci8/tests/lob_001.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: oci_lob_write() and friends
        !             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: 
        !            13: // Initialization
        !            14: 
        !            15: $stmtarray = array(
        !            16:        "drop table lob_001_tab",
        !            17:        "create table lob_001_tab (id number, b1 blob)",
        !            18: );
        !            19: 
        !            20: oci8_test_sql_execute($c, $stmtarray);
        !            21: 
        !            22: echo "Test 1 OCI_B_BLOB bind\n";
        !            23: 
        !            24: $statement = oci_parse($c, "insert into lob_001_tab (id, b1) values (1, empty_blob()) returning b1 into :v_b1 ");
        !            25: $blob = oci_new_descriptor($c,OCI_D_LOB);
        !            26: var_dump(oci_bind_by_name($statement, ":v_b1", $blob, -1, OCI_B_BLOB));
        !            27: oci_execute($statement, OCI_DEFAULT);
        !            28: var_dump($blob);
        !            29: 
        !            30: echo "Test 2\n";
        !            31: 
        !            32: var_dump($blob->write("test"));
        !            33: var_dump($blob->tell());
        !            34: var_dump($blob->seek(10, OCI_SEEK_CUR));
        !            35: var_dump($blob->write("string"));
        !            36: var_dump($blob->flush());
        !            37: 
        !            38: oci_commit($c);
        !            39: 
        !            40: echo "Test 3\n";
        !            41: 
        !            42: $s = oci_parse($c, "select b1 from lob_001_tab where id = 1");
        !            43: oci_execute($s);
        !            44: var_dump(oci_fetch_array($s, OCI_RETURN_LOBS));
        !            45: 
        !            46: echo "Test 4 SQLT_BLOB (an alias for OCI_B_BLOB) bind\n";
        !            47: 
        !            48: $statement = oci_parse($c, "insert into lob_001_tab (id, b1) values (2, empty_blob()) returning b1 into :v_b1 ");
        !            49: $blob = oci_new_descriptor($c,OCI_D_LOB);
        !            50: var_dump(oci_bind_by_name($statement, ":v_b1", $blob, -1, SQLT_BLOB));
        !            51: oci_execute($statement, OCI_DEFAULT);
        !            52: var_dump($blob->write("test row 2"));
        !            53: 
        !            54: $s = oci_parse($c, "select b1 from lob_001_tab where id = 2");
        !            55: oci_execute($s);
        !            56: var_dump(oci_fetch_array($s, OCI_RETURN_LOBS));
        !            57: 
        !            58: // Cleanup
        !            59: 
        !            60: $stmtarray = array(
        !            61:        "drop table lob_001_tab"
        !            62: );
        !            63: 
        !            64: oci8_test_sql_execute($c, $stmtarray);
        !            65: 
        !            66: ?>
        !            67: ===DONE===
        !            68: <?php exit(0); ?>
        !            69: --EXPECTF--
        !            70: Test 1 OCI_B_BLOB bind
        !            71: bool(true)
        !            72: object(OCI-Lob)#%d (1) {
        !            73:   ["descriptor"]=>
        !            74:   resource(%d) of type (oci8 descriptor)
        !            75: }
        !            76: Test 2
        !            77: int(4)
        !            78: int(4)
        !            79: bool(true)
        !            80: int(6)
        !            81: bool(false)
        !            82: Test 3
        !            83: array(2) {
        !            84:   [0]=>
        !            85:   string(20) "teststring"
        !            86:   ["B1"]=>
        !            87:   string(20) "teststring"
        !            88: }
        !            89: Test 4 SQLT_BLOB (an alias for OCI_B_BLOB) bind
        !            90: bool(true)
        !            91: int(10)
        !            92: array(2) {
        !            93:   [0]=>
        !            94:   string(10) "test row 2"
        !            95:   ["B1"]=>
        !            96:   string(10) "test row 2"
        !            97: }
        !            98: ===DONE===