Return to pdo_oci_stream_1.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_oci/tests/pdo_oci_stream_1.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PDO_OCI: stream_get_contents length & offset test
        !             3: --SKIPIF--
        !             4: <?php
        !             5: if (!extension_loaded('pdo') || !extension_loaded('pdo_oci')) die('skip not loaded');
        !             6: require(dirname(__FILE__).'/../../pdo/tests/pdo_test.inc');
        !             7: if (!strpos(strtolower(getenv('PDOTEST_DSN')), 'charset=we8mswin1252')) die('skip expected output valid for WE8MSWIN1252 character set');
        !             8: PDOTest::skip();
        !             9: ?>
        !            10: --FILE--
        !            11: <?php
        !            12: 
        !            13: require(dirname(__FILE__) . '/../../pdo/tests/pdo_test.inc');
        !            14: 
        !            15: $dbh = PDOTest::factory();
        !            16: 
        !            17: $dbh->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
        !            18: 
        !            19: // Initialization
        !            20: @$dbh->exec("drop table pdo_oci_stream_1_tab");
        !            21: 
        !            22: $stmtarray = array(
        !            23:        "create table pdo_oci_stream_1_tab (id number, data clob)",
        !            24: );
        !            25: 
        !            26: foreach ($stmtarray as $stmt) {
        !            27:        $dbh->exec($stmt);
        !            28: }
        !            29: 
        !            30: $dbh->exec("
        !            31:   declare
        !            32:     lob1 clob := 'abc' || lpad('j',30000,'j') || 'xyz';
        !            33:    begin
        !            34:     insert into pdo_oci_stream_1_tab (id,data) values (1, 'abcdefghijklmnopqrstuvwxyz');
        !            35:     insert into pdo_oci_stream_1_tab (id,data) values (2, lob1);
        !            36:   end;");
        !            37: 
        !            38: echo "Test 1\n";
        !            39: 
        !            40: $s = $dbh->prepare("select data from pdo_oci_stream_1_tab where id = 1");
        !            41: $s->execute();
        !            42: $r = $s->fetch();
        !            43: 
        !            44: // stream_get_contents ( resource $handle [, int $maxlength = -1 [, int $offset = -1 ]] )
        !            45: echo 'Read '.stream_get_contents($r['data'], 1, 1)."$\n";  // b
        !            46: echo 'Read '.stream_get_contents($r['data'], 2, 1)."$\n";  // cd
        !            47: echo 'Read '.stream_get_contents($r['data'], 2, 0)."$\n";  // ab
        !            48: echo 'Read '.stream_get_contents($r['data'], 26, 0)."$\n"; // abcdefghijklmnopqrstuvwxyz
        !            49: echo 'Read '.stream_get_contents($r['data'], 27, 0)."$\n"; // abcdefghijklmnopqrstuvwxyz
        !            50: echo 'Read '.stream_get_contents($r['data'], 27, 1)."$\n"; // bcdefghijklmnopqrstuvwxyz
        !            51: echo 'Read '.stream_get_contents($r['data'], 1, 20)."$\n"; // u
        !            52: echo 'Read '.stream_get_contents($r['data'], 1, 25)."$\n"; // z
        !            53: echo 'Read '.stream_get_contents($r['data'], 1, 26)."$\n"; // <blank>
        !            54: echo 'Read '.stream_get_contents($r['data'], 1, 0)."$\n";  // a
        !            55: 
        !            56: echo "\nTest 2\n";
        !            57: 
        !            58: $s = $dbh->prepare("select data from pdo_oci_stream_1_tab where id = 2");
        !            59: $s->execute();
        !            60: $r = $s->fetch();
        !            61: 
        !            62: echo 'Read '.stream_get_contents($r['data'], 5, 0)."\n";           // abcjj
        !            63: echo 'Read '.stream_get_contents($r['data'], 5, 2)."\n";           // cjjjj
        !            64: echo 'Read '.stream_get_contents($r['data'], 6, 1)."\n";           // bcjjjj
        !            65: echo 'Read '.strlen(stream_get_contents($r['data'], -1,0))."\n";   // 30006
        !            66: echo 'Read '.strlen(stream_get_contents($r['data'], 0,0))."\n";    // 0
        !            67: echo 'Read '.strlen(stream_get_contents($r['data'], 0,1))."\n";    // 0
        !            68: echo 'Read '.strlen(stream_get_contents($r['data'], 10,100))."\n"; // 10
        !            69: echo 'Read '.stream_get_contents($r['data'], 6, 30000)."\n";       // jjjxyz
        !            70: echo 'Read '.stream_get_contents($r['data'], 7, 30000)."\n";       // jjjxyz
        !            71: echo 'Read '.strlen(stream_get_contents($r['data']))."\n";         // 0
        !            72: echo 'Read '.strlen(stream_get_contents($r['data'], 0))."\n";      // 0
        !            73: echo 'Read '.strlen(stream_get_contents($r['data'], -1))."\n";     // 0
        !            74: echo 'Read '.stream_get_contents($r['data'], -1, 30000)."\n";      // jjjxyz
        !            75: 
        !            76: // Clean up
        !            77: 
        !            78: $stmtarray = array(
        !            79:        "drop table pdo_oci_stream_1_tab"
        !            80: );
        !            81: 
        !            82: foreach ($stmtarray as $stmt) {
        !            83:        $dbh->exec($stmt);
        !            84: }
        !            85: 
        !            86: ?>
        !            87: --EXPECTF--
        !            88: Test 1
        !            89: Read b$
        !            90: Read cd$
        !            91: Read ab$
        !            92: Read abcdefghijklmnopqrstuvwxyz$
        !            93: Read abcdefghijklmnopqrstuvwxyz$
        !            94: Read bcdefghijklmnopqrstuvwxyz$
        !            95: Read u$
        !            96: Read z$
        !            97: Read $
        !            98: Read a$
        !            99: 
        !           100: Test 2
        !           101: Read abcjj
        !           102: Read cjjjj
        !           103: Read bcjjjj
        !           104: Read 30006
        !           105: Read 0
        !           106: Read 0
        !           107: Read 10
        !           108: Read jjjxyz
        !           109: Read jjjxyz
        !           110: Read 0
        !           111: Read 0
        !           112: Read 0
        !           113: Read jjjxyz