Return to edition_1.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Basic test for setting Oracle 11gR2 "edition" attribute
                      3: --SKIPIF--
                      4: <?php 
                      5: if (!extension_loaded('oci8')) die("skip no oci8 extension"); 
                      6: require(dirname(__FILE__)."/connect.inc");
                      7: if (strcasecmp($user, "system") && strcasecmp($user, "sys")) {
                      8:     die("skip needs to be run as a DBA user");
                      9: }
                     10: if ($test_drcp) {
                     11:     die("skip as Output might vary with DRCP");
                     12: }
                     13: if (preg_match('/Release (1[1]\.2|12)\./', oci_server_version($c), $matches) !== 1) {
                     14:        die("skip expected output only valid when using Oracle 11gR2 or greater databases");
                     15: } else if (preg_match('/^(11\.2|12)\./', oci_client_version()) != 1) {
                     16:     die("skip test expected to work only with Oracle 11gR2 or greater version of client");
                     17: }
                     18: ?>
                     19: --FILE--
                     20: <?php
                     21: 
                     22: /* In 11.2, there can only be one child edition.  So this test will
                     23:  * fail to create the necessary editions if a child edition exists
                     24:  * already 
                     25:  */
                     26: 
                     27: require(dirname(__FILE__)."/conn_attr.inc");
                     28: 
                     29: function select_fn($conn) {
                     30:        $s = oci_parse($conn,"select * from view_ed");
                     31:        oci_execute($s);
                     32:        while ($row = oci_fetch_row($s)) {
                     33:                var_dump($row);
                     34:        }
                     35: }
                     36: /* Create a editon MYEDITION 
                     37:    create a view view_ed in MYEDITION1.
                     38:    create the same view 'view_ed' with a different definition in MYEDITION.
                     39:    select from both the editions and verify the contents. */
                     40: 
                     41: set_edit_attr('MYEDITION');
                     42: $conn = oci_connect('testuser','testuser',$dbase); 
                     43: if ($conn === false) {
                     44:     $m = oci_error();
                     45:     die("Error:" . $m['message']);
                     46: }
                     47:     
                     48: $stmtarray = array(
                     49:     "drop table edit_tab",
                     50:     "create table edit_tab (name varchar2(10),age number,job varchar2(50), salary number)",
                     51:     "insert into edit_tab values('mike',30,'Senior engineer',200)",
                     52:     "insert into edit_tab values('juan',25,'engineer',100)",
                     53:     "create or replace editioning view view_ed as select name,age,job from edit_tab",
                     54: );
                     55: 
                     56: oci8_test_sql_execute($conn, $stmtarray);
                     57: 
                     58: // Check the current edition of the DB and the contents of view_ed.
                     59: get_edit_attr($conn);
                     60: select_fn($conn);
                     61: 
                     62: // Create a different version of view_ed in MYEDITION1.
                     63: set_edit_attr('MYEDITION1');
                     64: $conn2 = oci_new_connect('testuser','testuser',$dbase); 
                     65: $stmt = "create or replace editioning view view_ed as select name,age,job,salary from edit_tab";
                     66: $s = oci_parse($conn2, $stmt);
                     67: oci_execute($s);
                     68: 
                     69: // Check the current edition of the DB and the contents of view_ed.
                     70: get_edit_attr($conn2);
                     71: select_fn($conn2);
                     72: 
                     73: // Verify the contents in MYEDITION EDITION.
                     74: echo "version of view_ed in MYEDITION \n";
                     75: get_edit_attr($conn);
                     76: select_fn($conn);
                     77: 
                     78: clean_up($c);
                     79: 
                     80: oci_close($conn);
                     81: oci_close($conn2);
                     82: echo "Done\n";
                     83: 
                     84: ?>
                     85: --EXPECTF--
                     86: The value of edition has been successfully set
                     87: The value of current EDITION is MYEDITION
                     88: array(3) {
                     89:   [0]=>
                     90:   %unicode|string%(%d) "mike"
                     91:   [1]=>
                     92:   %unicode|string%(%d) "30"
                     93:   [2]=>
                     94:   %unicode|string%(%d) "Senior engineer"
                     95: }
                     96: array(3) {
                     97:   [0]=>
                     98:   %unicode|string%(%d) "juan"
                     99:   [1]=>
                    100:   %unicode|string%(%d) "25"
                    101:   [2]=>
                    102:   %unicode|string%(%d) "engineer"
                    103: }
                    104:  The value of edition has been successfully set
                    105: The value of current EDITION is MYEDITION1
                    106: array(4) {
                    107:   [0]=>
                    108:   %unicode|string%(%d) "mike"
                    109:   [1]=>
                    110:   %unicode|string%(%d) "30"
                    111:   [2]=>
                    112:   %unicode|string%(%d) "Senior engineer"
                    113:   [3]=>
                    114:   %unicode|string%(%d) "200"
                    115: }
                    116: array(4) {
                    117:   [0]=>
                    118:   %unicode|string%(%d) "juan"
                    119:   [1]=>
                    120:   %unicode|string%(%d) "25"
                    121:   [2]=>
                    122:   %unicode|string%(%d) "engineer"
                    123:   [3]=>
                    124:   %unicode|string%(%d) "100"
                    125: }
                    126: version of view_ed in MYEDITION 
                    127: The value of current EDITION is MYEDITION
                    128: array(3) {
                    129:   [0]=>
                    130:   %unicode|string%(%d) "mike"
                    131:   [1]=>
                    132:   %unicode|string%(%d) "30"
                    133:   [2]=>
                    134:   %unicode|string%(%d) "Senior engineer"
                    135: }
                    136: array(3) {
                    137:   [0]=>
                    138:   %unicode|string%(%d) "juan"
                    139:   [1]=>
                    140:   %unicode|string%(%d) "25"
                    141:   [2]=>
                    142:   %unicode|string%(%d) "engineer"
                    143: }
                    144: Done