Return to drcp_scope5.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: DRCP: oci_pconnect() 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: // Similar to drcp_scope3.phpt but does a commit before end of
        !            14: // function2, allowing the table to be dropped cleanly at the end.
        !            15: 
        !            16: // The test opens a connection within function1 and updates a table
        !            17: // (without committing).  Another connection is opened from function
        !            18: // 2, and the table queried.  When function1 ends, the connection from
        !            19: // function1 is not closed, so the updated value will be seen in
        !            20: // function2.  Also the table can't be dropped because an uncommitted
        !            21: // transaction exists.
        !            22: 
        !            23: // Create the table
        !            24: $c = oci_new_connect($user,$password,$dbase);
        !            25: @drcp_drop_table($c);
        !            26: drcp_create_table($c);
        !            27: 
        !            28: echo "This is with a OCI_PCONNECT\n";
        !            29: function1($user,$password,$dbase);
        !            30: 
        !            31: // Should return the OLD value
        !            32: function2($user,$password,$dbase);
        !            33: 
        !            34: // This is the first scope for the script
        !            35: 
        !            36: function function1($user,$password,$dbase)
        !            37: {
        !            38:        var_dump($c = oci_pconnect($user,$password,$dbase));
        !            39:        drcp_update_table($c);
        !            40: }
        !            41: 
        !            42: // This is the second scope
        !            43: 
        !            44: function function2($user,$password,$dbase)
        !            45: {
        !            46:        var_dump($c = oci_pconnect($user,$password,$dbase));
        !            47:        drcp_select_value($c);
        !            48:        oci_commit($c);
        !            49: }
        !            50: 
        !            51: drcp_drop_table($c);
        !            52: oci_close($c);
        !            53: 
        !            54: echo "Done\n";
        !            55: 
        !            56: ?>
        !            57: --EXPECTF--
        !            58: This is with a OCI_PCONNECT
        !            59: resource(%d) of type (oci8 persistent connection)
        !            60: Update done-- DEPT value has been set to NEWDEPT
        !            61: resource(%d) of type (oci8 persistent connection)
        !            62: The value of DEPT for id 105 is NEWDEPT
        !            63: Done