Return to conn_attr_1.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Set and get of connection attributes with all types of connections.
                      3: --SKIPIF--
                      4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); 
                      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"))
                      9:     die("skip needs to be run as a DBA user");
                     10: if ($test_drcp) die("skip output might vary with DRCP");
                     11: 
                     12: if (preg_match('/Release 1[01]\./', oci_server_version($c), $matches) !== 1) {
                     13:        die("skip expected output only valid when using Oracle 10g or greater database server");
                     14: } else if (preg_match('/^1[01]\./', oci_client_version()) != 1) {
                     15:     die("skip test expected to work only with Oracle 10g or greater version of client");
                     16: }
                     17: 
                     18: ?>
                     19: --FILE--
                     20: <?php
                     21: require(dirname(__FILE__)."/conn_attr.inc");
                     22: 
                     23: $attr_array = array('MODULE','ACTION','CLIENT_INFO','CLIENT_IDENTIFIER');
                     24: 
                     25: echo"**Test 1.1 - Default values for the attributes **************\n";
                     26: $c = get_conn(1);
                     27: foreach($attr_array as $attr) {
                     28:         get_attr($c,$attr);
                     29: }
                     30: 
                     31: echo"**Test 1.2 - Set and get values for the attributes **************\n";
                     32: 
                     33: // With oci_connect, oci_pconnect, oci_new_connect
                     34: 
                     35: $conn1 = get_conn(1); //oci_connect()
                     36: foreach($attr_array as $attr) {
                     37:        set_attr($conn1,$attr,1);
                     38:     get_attr($conn1,$attr);
                     39: }
                     40: 
                     41: $conn2 = get_conn(2); //oci_pconnect()
                     42: foreach($attr_array as $attr) {
                     43:        set_attr($conn2,$attr,2);
                     44:     get_attr($conn2,$attr);
                     45: }
                     46: 
                     47: $conn3 = get_conn(3); //oci_new_connect()
                     48: foreach($attr_array as $attr) {
                     49:        set_attr($conn3,$attr,3);
                     50:     get_attr($conn3,$attr);
                     51: }
                     52: 
                     53: // clean up
                     54: oci_close($conn1);
                     55: oci_close($conn2);
                     56: oci_close($conn3);
                     57: clean_up($c);
                     58: 
                     59: echo "Done\n";
                     60: 
                     61: ?>
                     62: --EXPECTF--
                     63: **Test 1.1 - Default values for the attributes **************
                     64: Testing with oci_connect()
                     65: The value of MODULE is %s
                     66: The value of ACTION is 
                     67: The value of CLIENT_INFO is 
                     68: The value of CLIENT_IDENTIFIER is 
                     69: **Test 1.2 - Set and get values for the attributes **************
                     70: Testing with oci_connect()
                     71: Value of MODULE has been set successfully
                     72: The value of MODULE is PHP TEST1
                     73: Value of ACTION has been set successfully
                     74: The value of ACTION is TASK1
                     75: Value of CLIENT_INFO has been set successfully
                     76: The value of CLIENT_INFO is INFO11
                     77: Value of CLIENT_IDENTIFIER has been set successfully
                     78: The value of CLIENT_IDENTIFIER is ID001
                     79: Testing with oci_pconnect()
                     80: Value of MODULE has been set successfully
                     81: The value of MODULE is PHP TEST2
                     82: Value of ACTION has been set successfully
                     83: The value of ACTION is TASK2
                     84: Value of CLIENT_INFO has been set successfully
                     85: The value of CLIENT_INFO is INFO12
                     86: Value of CLIENT_IDENTIFIER has been set successfully
                     87: The value of CLIENT_IDENTIFIER is ID002
                     88: Testing with oci_new_connect()
                     89: Value of MODULE has been set successfully
                     90: The value of MODULE is PHP TEST3
                     91: Value of ACTION has been set successfully
                     92: The value of ACTION is TASK3
                     93: Value of CLIENT_INFO has been set successfully
                     94: The value of CLIENT_INFO is INFO13
                     95: Value of CLIENT_IDENTIFIER has been set successfully
                     96: The value of CLIENT_IDENTIFIER is ID003
                     97: Done