Return to bind_rowid.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Test ROWID bind
                      3: --SKIPIF--
                      4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
                      5: --FILE--
                      6: <?php
                      7: 
                      8: require(dirname(__FILE__)."/connect.inc");
                      9: 
                     10: function do_query($c)
                     11: {
                     12:        $s = oci_parse($c, 'select address from rid_tab order by id');
                     13:        $id = 1;
                     14:        oci_execute($s, OCI_DEFAULT);
                     15:        while ($row = oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)) {
                     16:                var_dump($row);
                     17:        }
                     18: }
                     19: 
                     20: $stmtarray = array(
                     21:        "drop table rid_tab",
                     22:        "create table rid_tab (id number, address varchar2(40))",
                     23:        "insert into rid_tab (id, address) values (1, 'original text #1')",
                     24:        "insert into rid_tab (id, address) values (2, 'original text #2')"
                     25: );
                     26: 
                     27: oci8_test_sql_execute($c, $stmtarray);
                     28: 
                     29: echo "Initial Data\n";
                     30: do_query($c);
                     31: 
                     32: $s = oci_parse($c, 'select rowid, address from rid_tab where id = :l_bv for update');
                     33: $id = 1;
                     34: oci_bind_by_name($s, ':l_bv', $id);
                     35: oci_execute($s, OCI_DEFAULT);
                     36: $row = oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS);
                     37: 
                     38: $rid = $row['ROWID'];
                     39: $addr = $row['ADDRESS'];
                     40: 
                     41: $addr = 'Some new text';
                     42: 
                     43: // Save changes
                     44: $s = oci_parse($c,'update rid_tab set address = :a_bv where rowid = :r_bv');
                     45: oci_bind_by_name($s, ':r_bv', $rid, -1, OCI_B_ROWID);
                     46: oci_bind_by_name($s, ':a_bv', $addr);
                     47: oci_execute($s);
                     48: 
                     49: echo "Verify Change\n";
                     50: do_query($c);
                     51: 
                     52: // Cleanup
                     53: 
                     54: $stmtarray = array(
                     55:     "drop table rid_tab"
                     56: );
                     57: 
                     58: oci8_test_sql_execute($c, $stmtarray);
                     59: 
                     60: echo "Done\n";
                     61: 
                     62: ?>
                     63: --EXPECT--
                     64: Initial Data
                     65: array(1) {
                     66:   ["ADDRESS"]=>
                     67:   string(16) "original text #1"
                     68: }
                     69: array(1) {
                     70:   ["ADDRESS"]=>
                     71:   string(16) "original text #2"
                     72: }
                     73: Verify Change
                     74: array(1) {
                     75:   ["ADDRESS"]=>
                     76:   string(13) "Some new text"
                     77: }
                     78: array(1) {
                     79:   ["ADDRESS"]=>
                     80:   string(16) "original text #2"
                     81: }
                     82: Done