cvs: php4 /pear/DB/tests limit.inc /pear/DB/tests/oci8 13limit.phpt

cox Thu Nov 29 20:30:34 2001 EDT Added files: /php4/pear/DB/tests/oci8 13limit.phpt Modified files: /php4/pear/DB/tests limit.inc Log: Added tests for the oci8 limit query support Index: php4/pear/DB/tests/limit.inc diff -u php4/pear/DB/tests/limit.inc:1.3 php4/pear/DB/tests/limit.inc:1.4 --- php4/pear/DB/tests/limit.inc:1.3 Thu Nov 1 19:47:26 2001 +++ php4/pear/DB/tests/limit.inc Thu Nov 29 20:30:32 2001 @@ -14,13 +14,19 @@ for ($i=0; $i<=$numrows+2; $i++) { $dbh->query("INSERT INTO php_limit VALUES('result $i')"); } +// Hack for upper case col returned by Oracle +if($dbh->dsn['phptype'] == 'oci8') { + $key = 'A'; +} else { + $key = 'a'; +} for ($i = 0; $i <= 3; $i++) { $from = 10 * $i; $res = $dbh->limitQuery("select * from php_limit", $from, $count); echo "======= From: $from || Number of rows to fetch: $count =======\n"; while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) { - echo $res->getRowCounter() . '.- ' . $row['a'] . "\n"; + echo $res->getRowCounter() . '.- ' . $row[$key] . "\n"; } } -$dbh->query("DROP TABLE php_limit"); +//$dbh->query("DROP TABLE php_limit"); ?> Index: php4/pear/DB/tests/oci8/13limit.phpt +++ php4/pear/DB/tests/oci8/13limit.phpt --TEST-- DB_oci8 row limit --SKIPIF-- <?php require "skipif.inc"; ?> --FILE-- <?php require 'connect.inc'; include '../limit.inc'; ?> --EXPECT-- ======= From: 0 || Number of rows to fetch: 10 ======= 1.- result 0 2.- result 1 3.- result 2 4.- result 3 5.- result 4 6.- result 5 7.- result 6 8.- result 7 9.- result 8 10.- result 9 ======= From: 10 || Number of rows to fetch: 10 ======= 11.- result 10 12.- result 11 13.- result 12 14.- result 13 15.- result 14 16.- result 15 17.- result 16 18.- result 17 19.- result 18 20.- result 19 ======= From: 20 || Number of rows to fetch: 10 ======= 21.- result 20 22.- result 21 23.- result 22 24.- result 23 25.- result 24 26.- result 25 27.- result 26 28.- result 27 29.- result 28 30.- result 29 ======= From: 30 || Number of rows to fetch: 10 ======= 31.- result 30 32.- result 31 33.- result 32