Return to drcp_scope1.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: DRCP: oci_new_connect() and oci_connect() with scope end when oci8.old_oci_close_semantics ON
                      3: --SKIPIF--
                      4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
                      5: --INI--
                      6: oci8.old_oci_close_semantics=1
                      7: --FILE--
                      8: <?php
                      9: 
                     10: require dirname(__FILE__)."/drcp_functions.inc";
                     11: require dirname(__FILE__)."/details.inc";
                     12: 
                     13: // Scope considered here is the  functional scope
                     14: // Test will open a connection within a function (function 1).
                     15: // Update a table
                     16: // Open another connection from function 2.
                     17: // When the scope ends the txn is rolled back and hence the updated value
                     18: // will not be  reflected for oci_connect and oci_new_connect.
                     19: 
                     20: // Create the table
                     21: $c = oci_new_connect($user,$password,$dbase);
                     22: @drcp_drop_table($c);
                     23: drcp_create_table($c);
                     24: 
                     25: // OCI_NEW_CONNECT
                     26: $conn_type = 1;
                     27: echo "This is with a OCI_NEW_CONNECT\n";
                     28: function1($user,$password,$dbase,$conn_type);
                     29: 
                     30: // Should return the OLD value
                     31: function2($user,$password,$dbase,$conn_type);
                     32: 
                     33: // OCI_CONNECT
                     34: $conn_type = 2;
                     35: echo "\n\nThis is with a OCI_CONNECT\n";
                     36: function1($user,$password,$dbase,$conn_type);
                     37: 
                     38: // Should return the OLD value
                     39: function2($user,$password,$dbase,$conn_type);
                     40: 
                     41: //This is the first scope for the script
                     42: 
                     43: function function1($user,$password,$dbase,$conn_type)
                     44: {
                     45:        switch($conn_type)
                     46:        {
                     47:        case 1:
                     48:                var_dump($conn1 = oci_new_connect($user,$password,$dbase));
                     49:                break;
                     50:        case 2:
                     51:                var_dump($conn1 = oci_connect($user,$password,$dbase));
                     52:                break;
                     53:        }
                     54:        drcp_update_table($conn1);
                     55: }
                     56: 
                     57: // This is the second scope
                     58: 
                     59: function function2($user,$password,$dbase,$conn_type)
                     60: {
                     61:        switch($conn_type)
                     62:        {
                     63:        case 1:
                     64:                var_dump($conn1 = oci_new_connect($user,$password,$dbase));
                     65:                break;
                     66:        case 2:
                     67:                var_dump($conn1 = oci_connect($user,$password,$dbase));
                     68:                break;
                     69:        }
                     70:        drcp_select_value($conn1);
                     71: }
                     72: 
                     73: drcp_drop_table($c);
                     74: oci_close($c);
                     75: 
                     76: echo "Done\n";
                     77: 
                     78: ?>
                     79: --EXPECTF--
                     80: This is with a OCI_NEW_CONNECT
                     81: resource(%d) of type (oci8 connection)
                     82: Update done-- DEPT value has been set to NEWDEPT
                     83: resource(%d) of type (oci8 connection)
                     84: The value of DEPT for id 105 is HR
                     85: 
                     86: 
                     87: This is with a OCI_CONNECT
                     88: resource(%d) of type (oci8 connection)
                     89: Update done-- DEPT value has been set to NEWDEPT
                     90: resource(%d) of type (oci8 connection)
                     91: The value of DEPT for id 105 is HR
                     92: Done