Annotation of embedaddon/php/ext/oci8/tests/drcp_scope2.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: DRCP: oci_new_connect() and oci_connect with scope end when oci8.old_oci_close_semantics OFF
! 3: --SKIPIF--
! 4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
! 5: --INI--
! 6: oci8.old_oci_close_semantics=0
! 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: drcp_drop_table($c);
! 73: oci_close($c);
! 74:
! 75: echo "Done\n";
! 76:
! 77: ?>
! 78: --EXPECTF--
! 79: This is with a OCI_NEW_CONNECT
! 80: resource(%d) of type (oci8 connection)
! 81: Update done-- DEPT value has been set to NEWDEPT
! 82: resource(%d) of type (oci8 connection)
! 83: The value of DEPT for id 105 is HR
! 84:
! 85:
! 86: This is with a OCI_CONNECT
! 87: resource(%d) of type (oci8 connection)
! 88: Update done-- DEPT value has been set to NEWDEPT
! 89: resource(%d) of type (oci8 connection)
! 90: The value of DEPT for id 105 is HR
! 91: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>