Return to drcp_cclass1.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: DRCP: Test setting connection class inline
                      3: --SKIPIF--
                      4: <?php 
                      5: if (!extension_loaded('oci8')) die ("skip no oci8 extension"); 
                      6: require(dirname(__FILE__)."/details.inc");
                      7: if (!$test_drcp) die("skip testing DRCP connection class only works in DRCP mode");
                      8: if (strcasecmp($user, "system") && strcasecmp($user, "sys")) die("skip needs to be run as a DBA user"); 
                      9: ?>
                     10: --FILE--
                     11: <?php
                     12: 
                     13: require(dirname(__FILE__)."/details.inc");
                     14: 
                     15: // Initialization
                     16: 
                     17: $t = time();
                     18: $cc1 = 'cc1_'.$t;
                     19: $cc2 = 'cc2_'.$t;
                     20: 
                     21: // Run Test
                     22: 
                     23: echo "Test 1\n";
                     24: 
                     25: ini_set('oci8.connection_class', $cc1);
                     26: $c = oci_pconnect($user, $password, $dbase);
                     27: $s = oci_parse($c, "select * from dual");
                     28: oci_execute($s);
                     29: oci_fetch_all($s, $r);
                     30: var_dump($r);
                     31: 
                     32: echo "Test 2\n";
                     33: 
                     34: ini_set('oci8.connection_class', $cc2);
                     35: $c = oci_pconnect($user, $password, $dbase);
                     36: $s = oci_parse($c, "select * from dual");
                     37: oci_execute($s);
                     38: oci_fetch_all($s, $r);
                     39: var_dump($r);
                     40: 
                     41: echo "Test 3\n";
                     42: 
                     43: $s = oci_parse($c, "select cclass_name from v\$cpool_cc_stats where cclass_name like '%.cc__$t' order by cclass_name");
                     44: oci_execute($s);
                     45: oci_fetch_all($s, $r);
                     46: var_dump($r);
                     47: 
                     48: // Cleanup
                     49: 
                     50: echo "Done\n";
                     51: 
                     52: ?>
                     53: --EXPECTF--
                     54: Test 1
                     55: array(1) {
                     56:   ["DUMMY"]=>
                     57:   array(1) {
                     58:     [0]=>
                     59:     string(1) "X"
                     60:   }
                     61: }
                     62: Test 2
                     63: array(1) {
                     64:   ["DUMMY"]=>
                     65:   array(1) {
                     66:     [0]=>
                     67:     string(1) "X"
                     68:   }
                     69: }
                     70: Test 3
                     71: array(1) {
                     72:   ["CCLASS_NAME"]=>
                     73:   array(2) {
                     74:     [0]=>
                     75:     string(21) "%s.cc1_%d"
                     76:     [1]=>
                     77:     string(21) "%s.cc2_%d"
                     78:   }
                     79: }
                     80: Done