Return to driver_name.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Verify that the Driver Name attribute is set
                      3: --SKIPIF--
                      4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); 
                      5: 
                      6: require(dirname(__FILE__)."/connect.inc");
                      7: if (strcasecmp($user, "system") && strcasecmp($user, "sys")) die("skip needs to be run as a DBA user");
                      8: if ($test_drcp) die("skip as Output might vary with DRCP");
                      9: 
                     10: if (preg_match('/Release (11\.2|12)/', oci_server_version($c), $matches) !== 1) {
                     11:        die("skip expected output only valid when using Oracle 11gR2 or greater databases");
                     12: } else if (preg_match('/^(11\.2|12\.)/', oci_client_version()) != 1) {
                     13:     die("skip test expected to work only with Oracle 11g or greater version of client");
                     14: }
                     15: 
                     16: ?>
                     17: --FILE--
                     18: <?php
                     19: require(dirname(__FILE__)."/connect.inc");
                     20: 
                     21: echo"**Test 1.1 - Default values for the attribute **************\n";
                     22: get_attr($c);
                     23: oci_close($c);
                     24: 
                     25: echo"\n***Test 1.2 - Get the values from different connections **************\n";
                     26: // with oci_pconnect() 
                     27: echo "Testing with oci_pconnect()\n";
                     28: $pc1=oci_pconnect($user,$password,$dbase);
                     29: get_attr($pc1);
                     30: oci_close($pc1);
                     31: 
                     32: echo "Testing with oci_new_connect()\n";
                     33: $nc1=oci_new_connect($user,$password,$dbase);
                     34: get_attr($nc1);
                     35: oci_close($nc1);
                     36: echo "Done\n";
                     37: 
                     38: function get_attr($conn)
                     39: {
                     40:        $sel_stmt = "select client_driver 
                     41:         from v\$session_connect_info sci, v\$session s 
                     42:         where sci.client_driver is not null 
                     43:           and sci.sid = s.sid 
                     44:           and s.audsid = userenv('SESSIONID')";
                     45:     $s2 = oci_parse($conn,$sel_stmt);
                     46:     oci_execute($s2,OCI_DEFAULT);
                     47:     oci_fetch($s2);
                     48:     echo "The value of DRIVER_NAME is ".oci_result($s2,1)."\n";
                     49: }
                     50: 
                     51: ?>
                     52: --EXPECT--
                     53: **Test 1.1 - Default values for the attribute **************
                     54: The value of DRIVER_NAME is PHP OCI8
                     55: 
                     56: ***Test 1.2 - Get the values from different connections **************
                     57: Testing with oci_pconnect()
                     58: The value of DRIVER_NAME is PHP OCI8
                     59: Testing with oci_new_connect()
                     60: The value of DRIVER_NAME is PHP OCI8
                     61: Done