Return to conn_attr.inc CVS log

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

Annotation of embedaddon/php/ext/oci8/tests/conn_attr.inc, revision 1.1.1.1

1.1       misho       1: <?php
                      2: 
                      3: require(dirname(__FILE__)."/connect.inc");
                      4: 
                      5: $sv = oci_server_version($c);
                      6: $sv = preg_match('/Release (11\.2|12)\./', $sv, $matches);
                      7: if ($sv == 1) {
                      8:     // Server is Oracle 11.2+
                      9:     $stmtarray = array(
                     10:         "drop user testuser cascade",
                     11:         "create user testuser identified by testuser",
                     12:         "grant connect,resource,dba to testuser",
                     13:         "alter user testuser enable editions",
                     14:         "drop edition myedition1",
                     15:         "drop edition myedition",
                     16:         "grant create any edition to testuser",
                     17:         "create edition myedition",
                     18:         "create edition myedition1 as child of myedition",
                     19:         "grant use on edition myedition to testuser",
                     20:         "grant use on edition myedition1 to testuser",
                     21:     );
                     22: }
                     23: else {
                     24:     // Server is Pre 11.2 
                     25:     $stmtarray = array(
                     26:         "drop user testuser cascade",
                     27:         "create user testuser identified by testuser",
                     28:         "grant connect,resource,dba to testuser",
                     29:     );
                     30: }
                     31: 
                     32: foreach ($stmtarray as $stmt) {
                     33:     $s = oci_parse($c, $stmt);
                     34:     $r = @oci_execute($s);
                     35:        if (!$r) {
                     36:                $m = oci_error($s);
                     37:                if (!in_array($m['code'], array(   // ignore expected errors
                     38:                         942 // table or view does not exist
                     39:                      , 1918 // user does not exist 
                     40:                      , 2289 // sequence does not exist
                     41:                      , 4080 // trigger does not exist
                     42:                     , 38802 // edition does not exist
                     43:                 ))) {
                     44:                        echo "Error:" . $stmt . PHP_EOL . $m['message'] . PHP_EOL;
                     45:             if ($m['code'] == 38807) {
                     46:                 echo "You appear to already have an edition in use that prevents this PHP test from running.  Query DBA_EDITIONS to see existing editions.". PHP_EOL;
                     47:             }
                     48:             die;
                     49:                }
                     50:        }
                     51: }
                     52: 
                     53: function get_attr($conn,$attr)
                     54: {
                     55:     $sel_stmt="select " .$attr. " from v\$session where sid = 
                     56:        (select sid from v\$session where audsid = 
                     57:        sys_context('userenv','sessionid')) order by 1";
                     58:     $s2 = oci_parse($conn,$sel_stmt);
                     59:     oci_execute($s2,OCI_DEFAULT);
                     60:     while (oci_fetch($s2)) {
                     61:         echo "The value of ".$attr ." is ".oci_result($s2,1)."\n";
                     62:     }
                     63: }
                     64: 
                     65: /* Pass $conn_type=1 for a connection with oci_connect() 
                     66:    Pass $conn_type=2 for ooci_pconnect 
                     67:    Default will give a oci_new_connect */
                     68: 
                     69: function get_conn($conn_type)
                     70: {
                     71:        $user = 'testuser';
                     72:        $password = 'testuser';
                     73:        $dbase = $GLOBALS['dbase'];
                     74:        switch($conn_type) {
                     75:         case 1:
                     76:             echo "Testing with oci_connect()\n";
                     77:             return(oci_connect($user,$password,$dbase));
                     78:             break;
                     79:         case 2:
                     80:             echo "Testing with oci_pconnect()\n";
                     81:             return(oci_pconnect($user,$password,$dbase));
                     82:             break;
                     83:         default:
                     84:             echo "Testing with oci_new_connect()\n";
                     85:             return(oci_new_connect($user,$password,$dbase));
                     86:             break;
                     87:        }
                     88: }
                     89: 
                     90: function set_attr($conn,$attr,$sufix)
                     91: {
                     92:        if (!strcmp($attr,'MODULE')) 
                     93:                $r = oci_set_module_name($conn,'PHP TEST'.$sufix);
                     94:        else if (!strcmp($attr,'ACTION')) 
                     95:         $r = oci_set_action($conn,'TASK'.$sufix);
                     96:        else if (!strcmp($attr,'CLIENT_INFO')) 
                     97:         $r = oci_set_client_info($conn,'INFO1'.$sufix);
                     98:        else if (!strcmp($attr,'CLIENT_IDENTIFIER')) 
                     99:         $r = oci_set_client_identifier($conn,'ID00'.$sufix);
                    100:        else
                    101:                echo "Pass one of the above four attibutes!!!\n";
                    102:        if ($r) {
                    103:                echo "Value of $attr has been set successfully\n";
                    104:     }
                    105:     
                    106:        //Do a round-trip here
                    107:        oci_server_version($conn);
                    108:        return $r;    
                    109: }
                    110: 
                    111: function set_edit_attr($value)
                    112: {
                    113:        $r = oci_set_edition($value);
                    114:     if ($r) {
                    115:                echo " The value of edition has been successfully set\n";
                    116:     }
                    117:        return $r;
                    118: }
                    119: 
                    120: function get_edit_attr ($conn) {
                    121:        $sel_stmt = "select sys_context('USERENV', 'CURRENT_EDITION_NAME') from dual";
                    122:     $s2 = oci_parse($conn,$sel_stmt);
                    123:     oci_execute($s2,OCI_DEFAULT);
                    124:     while (oci_fetch($s2)) {
                    125:         echo "The value of current EDITION is ".oci_result($s2,1)."\n";
                    126:     }
                    127: }
                    128: 
                    129: function get_sys_attr($conn,$attr)
                    130: {
                    131:        $sel_stmt="select " .$attr. " from v\$session where sid = 
                    132:        (select sid from v\$session where audsid = sys_context('userenv','sessionid')) order by 1";
                    133:     $s2 = oci_parse($conn,$sel_stmt);
                    134:     oci_execute($s2,OCI_DEFAULT);
                    135:     while (oci_fetch($s2)) {
                    136:         echo "The value of ".$attr ." is ".oci_result($s2,1)."\n";
                    137:     }
                    138: }
                    139: 
                    140: function clean_up($c) {
                    141:        $stmtarray = array(
                    142:         "drop user testuser cascade",
                    143:         "drop edition myedition1",
                    144:         "drop edition myedition",
                    145:        );
                    146:     
                    147:        foreach ($stmtarray as $stmt) {
                    148:         $s = oci_parse($c, $stmt);
                    149:         @oci_execute($s);
                    150:        }
                    151: }