Return to conn_attr_4.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Set and get of connection attributes with errors.
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: if (getenv('SKIP_SLOW_TESTS')) die('skip slow tests excluded by request');
                      8: 
                      9: if (strcasecmp($user, "system") && strcasecmp($user, "sys")) 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 (11\.2|12)\./', oci_server_version($c), $matches) !== 1) {
                     13:     // Bug fixed in 11.2 prevents client_info being rest
                     14:        die("skip expected output only valid when using Oracle 11gR2 or greater database server");
                     15: } else if (preg_match('/^1[01]\./', oci_client_version()) != 1) {
                     16:     die("skip test expected to work only with Oracle 10g or greater version of client");
                     17: }
                     18: ?>
                     19: --FILE--
                     20: <?php
                     21: 
                     22: 
                     23: require(dirname(__FILE__)."/conn_attr.inc");
                     24: 
                     25: $user='testuser';
                     26: $password='testuser';
                     27: $attr_array = array('MODULE','ACTION','CLIENT_INFO','CLIENT_IDENTIFIER');
                     28: 
                     29: echo"**Test  Negative cases************\n";
                     30: 
                     31: echo "\nInvalid Connection resource\n";
                     32: $nc1=NULL;
                     33: // Invalid connection handle.
                     34: var_dump(oci_set_action($nc1,$nc1));
                     35: 
                     36: // Variable instead of a connection resource.
                     37: echo "\nInvalid Connection resource 2\n";
                     38: $str1= 'not a conn';
                     39: var_dump(oci_set_client_info($str1,$str1));
                     40: 
                     41: // Setting an Invalid value.
                     42: echo "\nInvalid Value \n";
                     43: $c1=oci_connect($user,$password,$dbase);
                     44: var_dump(oci_set_action($c1,$c1));
                     45: 
                     46: // Setting values multiple times.
                     47: echo "\nSet Values multiple times \n";
                     48: var_dump(oci_set_action($c1,'ACTION1'));
                     49: var_dump(oci_set_action($c1,'ACTION1'));
                     50: var_dump(oci_set_action($c1,'ACTION2'));
                     51: var_dump(oci_set_action($c1,'ACTION1'));
                     52: get_attr($c1,'ACTION');
                     53: 
                     54: // Testing with different types of values
                     55: // NB.  This may diff in 11.1.0.6 due to a bug causing CLIENT_INFO of NULL to be ignored.
                     56: echo "\nSetting to different values \n";
                     57: $values_array = array(1000,NULL,'this is a very huge string with a length  > 64 !!!!!this is a very huge string with a length  > 64 !!!!!this is a very huge string with a length  > 64 !!!!!this is a very huge string with a length  > 64 !!!!!');
                     58: 
                     59: foreach($values_array as $val ) {
                     60:        oci_set_module_name($c1,$val);
                     61:        oci_set_client_identifier($c1,$val);
                     62:        oci_set_client_info($c1,$val);
                     63:        $r = oci_set_action($c1,$val);  
                     64:        if ($r) {
                     65:                echo "Values set succesfully to $val\n";
                     66:                foreach($attr_array as $attr) {
                     67:             get_attr($c1,$attr);
                     68:         }
                     69:        }
                     70: }
                     71: 
                     72: clean_up($c);
                     73: echo "Done\n";
                     74: ?>
                     75: --EXPECTF--
                     76: **Test  Negative cases************
                     77: 
                     78: Invalid Connection resource
                     79: 
                     80: Warning: oci_set_action() expects parameter 1 to be resource, null given in %s on line %d
                     81: NULL
                     82: 
                     83: Invalid Connection resource 2
                     84: 
                     85: Warning: oci_set_client_info() expects parameter 1 to be resource, %s given in %s on line %d
                     86: NULL
                     87: 
                     88: Invalid Value 
                     89: 
                     90: Warning: oci_set_action() expects parameter 2 to be %s, resource given in %s on line %d
                     91: NULL
                     92: 
                     93: Set Values multiple times 
                     94: bool(true)
                     95: bool(true)
                     96: bool(true)
                     97: bool(true)
                     98: The value of ACTION is ACTION1
                     99: 
                    100: Setting to different values 
                    101: Values set succesfully to 1000
                    102: The value of MODULE is 1000
                    103: The value of ACTION is 1000
                    104: The value of CLIENT_INFO is 1000
                    105: The value of CLIENT_IDENTIFIER is 1000
                    106: Values set succesfully to 
                    107: The value of MODULE is 
                    108: The value of ACTION is 
                    109: The value of CLIENT_INFO is 
                    110: The value of CLIENT_IDENTIFIER is 
                    111: 
                    112: Warning: oci_set_module_name(): ORA-24960: %s OCI_ATTR_MODULE %s on line %d
                    113: 
                    114: Warning: oci_set_client_identifier(): ORA-24960: %s OCI_ATTR_CLIENT_IDENTIFIER %s on line %d
                    115: 
                    116: Warning: oci_set_client_info(): ORA-24960: %s OCI_ATTR_CLIENT_INFO %s on line %d
                    117: 
                    118: Warning: oci_set_action(): ORA-24960: %s OCI_ATTR_ACTION %s on line %d
                    119: Done