Return to define3.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: Test oci_define_by_name() LOB descriptor
        !             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: $stmtarray = array(
        !            14:        "drop table phpdefblobtable",
        !            15:        "create table phpdefblobtable (id number(10), fileimage blob)"
        !            16: );
        !            17:                                                 
        !            18: oci8_test_sql_execute($c, $stmtarray);
        !            19: 
        !            20: // Load data
        !            21: $stmt = oci_parse ($c, "insert into phpdefblobtable (id, fileimage) values (:id, empty_blob()) returning fileimage into :fileimage");
        !            22: $fileimage = oci_new_descriptor($c,OCI_D_LOB);
        !            23: oci_bind_by_name($stmt,":id",$id);
        !            24: oci_bind_by_name($stmt,":fileimage",$fileimage,-1,OCI_B_BLOB);
        !            25: $id = 1;
        !            26: oci_execute($stmt, OCI_DEFAULT);
        !            27: $fileimage->savefile(dirname(__FILE__)."/test.gif");
        !            28: $data = $fileimage->load();
        !            29: var_dump(md5($data));  // original md5
        !            30: oci_commit($c);
        !            31: 
        !            32: // New row with different data
        !            33: $id = 2;
        !            34: $data = strrev($data);
        !            35: var_dump(md5($data));
        !            36: oci_execute($stmt, OCI_DEFAULT);
        !            37: $fileimage->save($data);
        !            38: oci_commit($c);
        !            39: 
        !            40: echo "Test 1\n";
        !            41: $stmt = oci_parse($c, "SELECT fileimage FROM phpdefblobtable");
        !            42: var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $f));
        !            43: oci_execute($stmt);
        !            44: 
        !            45: while (oci_fetch($stmt)) {
        !            46:    var_dump($f);
        !            47:    echo "file md5:" . md5($f->load()) . "\n";
        !            48: }
        !            49: 
        !            50: echo "Test 2\n";
        !            51: $stmt = oci_parse($c, "SELECT fileimage FROM phpdefblobtable");
        !            52: var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $outdata, SQLT_STR));
        !            53: oci_execute($stmt);
        !            54: 
        !            55: while (oci_fetch($stmt)) {
        !            56:    echo "file md5:" . md5($outdata) . "\n";
        !            57: }
        !            58: 
        !            59: echo "Test 3\n";
        !            60: $stmt = oci_parse($c, "SELECT fileimage FROM phpdefblobtable");
        !            61: var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $outdata, SQLT_BIN));
        !            62: oci_execute($stmt);
        !            63: 
        !            64: while (oci_fetch($stmt)) {
        !            65:    echo "file md5:" . md5($outdata) . "\n";
        !            66: }
        !            67: 
        !            68: echo "Test 4\n";
        !            69: $fid = oci_new_descriptor($c,OCI_D_LOB);
        !            70: $stmt = oci_parse($c, "SELECT fileimage FROM phpdefblobtable");
        !            71: var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $fid));
        !            72: oci_execute($stmt);
        !            73: 
        !            74: while (oci_fetch($stmt)) {
        !            75:    echo "file md5:" . md5($fid->load()) . "\n";
        !            76: }
        !            77: 
        !            78: $stmtarray = array(
        !            79:        "drop table phpdefblobtable"
        !            80: );
        !            81:                                                 
        !            82: oci8_test_sql_execute($c, $stmtarray);
        !            83: 
        !            84: echo "Done\n";
        !            85: 
        !            86: ?>
        !            87: --EXPECTF--
        !            88: string(32) "614fcbba1effb7caa27ef0ef25c27fcf"
        !            89: string(32) "06d4f219d946c74d748d43932cd9dcb2"
        !            90: Test 1
        !            91: bool(true)
        !            92: object(OCI-Lob)#%d (1) {
        !            93:   ["descriptor"]=>
        !            94:   resource(%d) of type (oci8 descriptor)
        !            95: }
        !            96: file md5:614fcbba1effb7caa27ef0ef25c27fcf
        !            97: object(OCI-Lob)#%d (1) {
        !            98:   ["descriptor"]=>
        !            99:   resource(%d) of type (oci8 descriptor)
        !           100: }
        !           101: file md5:06d4f219d946c74d748d43932cd9dcb2
        !           102: Test 2
        !           103: bool(true)
        !           104: 
        !           105: Warning: oci_fetch(): ORA-00932: %s on line %d
        !           106: Test 3
        !           107: bool(true)
        !           108: file md5:614fcbba1effb7caa27ef0ef25c27fcf
        !           109: file md5:06d4f219d946c74d748d43932cd9dcb2
        !           110: Test 4
        !           111: bool(true)
        !           112: file md5:614fcbba1effb7caa27ef0ef25c27fcf
        !           113: file md5:06d4f219d946c74d748d43932cd9dcb2
        !           114: Done
        !           115: