diff options
Diffstat (limited to 'tests/conn_attr_4.phpt')
| -rw-r--r-- | tests/conn_attr_4.phpt | 122 |
1 files changed, 122 insertions, 0 deletions
diff --git a/tests/conn_attr_4.phpt b/tests/conn_attr_4.phpt new file mode 100644 index 0000000000..9f55f53263 --- /dev/null +++ b/tests/conn_attr_4.phpt @@ -0,0 +1,122 @@ +--TEST-- +Set and get of connection attributes with errors. +--SKIPIF-- +<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); +require(dirname(__FILE__)."/connect.inc"); +if (strcasecmp($user, "system") && strcasecmp($user, "sys")) die("skip needs to be run as a DBA user"); +if ($test_drcp) die("skip output might vary with DRCP"); +if ($stress_test !== true) die ('skip Slow test not run when $stress_test is FALSE'); + +$sv = oci_server_version($c); +$sv = preg_match('/Release 1[012]\./', $sv, $matches); +if ($sv == 1) { + ob_start(); + phpinfo(INFO_MODULES); + $phpinfo = ob_get_clean(); + $iv = preg_match('/Oracle .*Version => 1[012]\./', $phpinfo); + if ($iv != 1) { + die ("skip test expected to work only with Oracle 10g or greater version of client"); + } +} +else { + die ("skip test expected to work only with Oracle 10g or greater version of server"); +} +?> +--FILE-- +<?php +require(dirname(__FILE__)."/conn_attr.inc"); + +$user='testuser'; +$password='testuser'; +$attr_array = array('MODULE','ACTION','CLIENT_INFO','CLIENT_IDENTIFIER'); + +echo"**Test Negative cases************\n"; + +echo "\nInvalid Connection resource\n"; +$nc1=NULL; +// Invalid connection handle. +var_dump(oci_set_action($nc1,$nc1)); + +// Variable instead of a connection resource. +echo "\nInvalid Connection resource 2\n"; +$str1= 'not a conn'; +var_dump(oci_set_client_info($str1,$str1)); + +// Setting an Invalid value. +echo "\nInvalid Value \n"; +$c1=oci_connect($user,$password,$dbase); +var_dump(oci_set_action($c1,$c1)); + +// Setting values multiple times. +echo "\nSet Values multiple times \n"; +var_dump(oci_set_action($c1,'ACTION1')); +var_dump(oci_set_action($c1,'ACTION1')); +var_dump(oci_set_action($c1,'ACTION2')); +var_dump(oci_set_action($c1,'ACTION1')); +get_attr($c1,'ACTION'); + +// Testing with different types of values +echo "\nSetting to different values \n"; +$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 !!!!!'); + +foreach($values_array as $val ) { + oci_set_module_name($c1,$val); + oci_set_client_identifier($c1,$val); + oci_set_client_info($c1,$val); + $r = oci_set_action($c1,$val); + if ($r) { + echo "Values set succesfully to $val\n"; + foreach($attr_array as $attr) { + get_attr($c1,$attr); + } + } +} + +clean_up($c); +echo "Done\n"; +?> +--EXPECTF-- +**Test Negative cases************ + +Invalid Connection resource + +Warning: oci_set_action() expects parameter 1 to be resource, null given in %s on line %d +NULL + +Invalid Connection resource 2 + +Warning: oci_set_client_info() expects parameter 1 to be resource, %s given in %s on line %d +NULL + +Invalid Value + +Warning: oci_set_action() expects parameter 2 to be %s, resource given in %s on line %d +NULL + +Set Values multiple times +bool(true) +bool(true) +bool(true) +bool(true) +The value of ACTION is ACTION1 + +Setting to different values +Values set succesfully to 1000 +The value of MODULE is 1000 +The value of ACTION is 1000 +The value of CLIENT_INFO is 1000 +The value of CLIENT_IDENTIFIER is 1000 +Values set succesfully to +The value of MODULE is +The value of ACTION is +The value of CLIENT_INFO is +The value of CLIENT_IDENTIFIER is + +Warning: oci_set_module_name(): ORA-24960: %s OCI_ATTR_MODULE %s on line %d + +Warning: oci_set_client_identifier(): ORA-24960: %s OCI_ATTR_CLIENT_IDENTIFIER %s on line %d + +Warning: oci_set_client_info(): ORA-24960: %s OCI_ATTR_CLIENT_INFO %s on line %d + +Warning: oci_set_action(): ORA-24960: %s OCI_ATTR_ACTION %s on line %d +Done |