Return to test_unbuffered_query.phpt CVS log

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

Annotation of embedaddon/php/ext/sybase_ct/tests/test_unbuffered_query.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Sybase-CT unbuffered query
        !             3: --SKIPIF--
        !             4: <?php require('skipif.inc'); ?>
        !             5: --FILE--
        !             6: <?php
        !             7: /* This file is part of PHP test framework for ext/sybase_ct
        !             8:  *
        !             9:  * $Id: test_unbuffered_query.phpt 236100 2007-05-22 11:33:36Z thekid $ 
        !            10:  */
        !            11: 
        !            12:   require('test.inc');
        !            13: 
        !            14:   $db= sybase_connect_ex();
        !            15:   var_dump($db);
        !            16:   
        !            17:   // Test #1: num_rows
        !            18:   $q= sybase_unbuffered_query('select name from master..systypes', $db);
        !            19:   var_dump($q);
        !            20:   $i= 0;
        !            21:   while ($r= sybase_fetch_assoc($q)) {
        !            22:     $i++;
        !            23:   }
        !            24:   var_dump($i, sybase_num_rows($q), $i == sybase_num_rows($q), $q);
        !            25:   sybase_free_result($q);
        !            26:   var_dump($q);
        !            27:   
        !            28:   // Test #2: after sybase_free_result, this should be an invalid resource
        !            29:   var_dump(FALSE == sybase_num_rows($q));
        !            30:   
        !            31:   // Test #3: Seeking
        !            32:   $q= sybase_unbuffered_query('select name from master..systypes', $db);
        !            33:   var_dump($q);
        !            34:   $j= 0;
        !            35:   sybase_data_seek($q, 4);
        !            36:   while ($r= sybase_fetch_assoc($q)) {
        !            37:     $j++;
        !            38:   }
        !            39:   var_dump($i, $j, $i - $j);
        !            40:   
        !            41:   sybase_close($db);
        !            42: ?>
        !            43: --EXPECTF--
        !            44: resource(%d) of type (sybase-ct link)
        !            45: resource(%d) of type (sybase-ct result)
        !            46: int(%d)
        !            47: int(%d)
        !            48: bool(true)
        !            49: resource(%d) of type (sybase-ct result)
        !            50: resource(%d) of type (Unknown)
        !            51: 
        !            52: Warning: sybase_num_rows(): %d is not a valid Sybase result resource in %stest_unbuffered_query.php on line %d
        !            53: bool(true)
        !            54: resource(%d) of type (sybase-ct result)
        !            55: int(%d)
        !            56: int(%d)
        !            57: int(4)