Return to conn_attr_3.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: Set and get of connection attributes with oci_close().
        !             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: if (strcasecmp($user, "system") && strcasecmp($user, "sys")) die("skip needs to be run as a DBA user");
        !             9: if ($test_drcp) die("skip output might vary with DRCP");
        !            10: 
        !            11: if (preg_match('/Release 1[01]\./', oci_server_version($c), $matches) !== 1) {
        !            12:        die("skip expected output only valid when using Oracle 10g or greater database server");
        !            13: } else if (preg_match('/^1[01]\./', oci_client_version()) != 1) {
        !            14:     die("skip test expected to work only with Oracle 10g or greater version of client");
        !            15: }
        !            16: ?>
        !            17: --FILE--
        !            18: <?php
        !            19: require(dirname(__FILE__)."/conn_attr.inc");
        !            20: 
        !            21: echo"**Test Set and get values for  the attributes with oci_close() ************\n";
        !            22: // With oci_connect ,oci_pconnect ,oci_new_connect
        !            23: 
        !            24: var_dump($conn1 = get_conn(1)); //oci_connect()
        !            25: set_attr($conn1,'ACTION',1);
        !            26: get_attr($conn1,'ACTION');
        !            27: oci_close($conn1);
        !            28: 
        !            29: // Open another connect and verify the value.
        !            30: var_dump($conn1 = get_conn(1)); //oci_connect()
        !            31: get_attr($conn1,'ACTION');
        !            32: oci_close($conn1);
        !            33: 
        !            34: var_dump($pconn1 = get_conn(2)); //oci_pconnect()
        !            35: set_attr($pconn1,'MODULE',2);
        !            36: get_attr($pconn1,'MODULE');
        !            37: oci_close($pconn1);
        !            38: 
        !            39: // Open another connect and verify the value.
        !            40: var_dump($pconn1 = get_conn(2)); //oci_pconnect()
        !            41: get_attr($pconn1,'MODULE');
        !            42: oci_close($pconn1);
        !            43: 
        !            44: var_dump($nconn1 = get_conn(3)); //oci_new_connect()
        !            45: set_attr($nconn1,'CLIENT_INFO',3);
        !            46: set_attr($nconn1,'CLIENT_IDENTIFIER',3);
        !            47: get_attr($nconn1,'CLIENT_INFO');
        !            48: get_attr($nconn1,'CLIENT_IDENTIFIER');
        !            49: oci_close($nconn1);
        !            50: 
        !            51: // Open another connect and verify the value.
        !            52: var_dump($nconn1 = get_conn(3)); //oci_new_connect()
        !            53: get_attr($nconn1,'CLIENT_INFO');
        !            54: get_attr($nconn1,'CLIENT_IDENTIFIER');
        !            55: oci_close($nconn1);
        !            56: 
        !            57: clean_up($c);
        !            58: echo "Done\n";
        !            59: 
        !            60: ?>
        !            61: --EXPECTF--
        !            62: **Test Set and get values for  the attributes with oci_close() ************
        !            63: Testing with oci_connect()
        !            64: resource(%d) of type (oci8 connection)
        !            65: Value of ACTION has been set successfully
        !            66: The value of ACTION is TASK1
        !            67: Testing with oci_connect()
        !            68: resource(%d) of type (oci8 connection)
        !            69: The value of ACTION is 
        !            70: Testing with oci_pconnect()
        !            71: resource(%d) of type (oci8 persistent connection)
        !            72: Value of MODULE has been set successfully
        !            73: The value of MODULE is PHP TEST2
        !            74: Testing with oci_pconnect()
        !            75: resource(%d) of type (oci8 persistent connection)
        !            76: The value of MODULE is PHP TEST2
        !            77: Testing with oci_new_connect()
        !            78: resource(%d) of type (oci8 connection)
        !            79: Value of CLIENT_INFO has been set successfully
        !            80: Value of CLIENT_IDENTIFIER has been set successfully
        !            81: The value of CLIENT_INFO is INFO13
        !            82: The value of CLIENT_IDENTIFIER is ID003
        !            83: Testing with oci_new_connect()
        !            84: resource(%d) of type (oci8 connection)
        !            85: The value of CLIENT_INFO is 
        !            86: The value of CLIENT_IDENTIFIER is 
        !            87: Done