[PHP-CVS] cvs: php-src(PHP_5_3) /ext/pdo/tests bug_44861.phpt /ext/pdo_pgsql/tests bug44861.phpt

[Matteo Beccati]

mbeccati                Tue May 12 23:40:32 2009 UTC

  Added files:                 (Branch: PHP_5_3)
    /php-src/ext/pdo/tests      bug_44861.phpt 

  Removed files:               
    /php-src/ext/pdo_pgsql/tests        bug44861.phpt 
  Log:
  MFH
  - Moved test for bug #44861 to PDO commons and added support for pdo_oci
  # This allows scrollable cursors to be tested with all the drivers
  # that currently support them (pgsql and oci), ensuring a consistent
  # behaviour. The test is skipped when using other drivers.
  
  

http://cvs.php.net/viewvc.cgi/php-src/ext/pdo/tests/bug_44861.phpt?view=markup&rev=1.1
Index: php-src/ext/pdo/tests/bug_44861.phpt
+++ php-src/ext/pdo/tests/bug_44861.phpt
--TEST--
PDO Common: Bug #44861 (scrollable cursor don't work with pgsql)
--SKIPIF--
<?php # vim:ft=php
if (!extension_loaded('pdo')) die('skip');
$dir = getenv('REDIR_TEST_DIR');
if (false == $dir) die('skip no driver');
$allowed = array('oci', 'pgsql');
$ok = false;
foreach ($allowed as $driver) {
        if (!strncasecmp(getenv('PDOTEST_DSN'), $driver, strlen($driver))) {
                $ok = true;
        }
}
if (!$ok) {
        die("skip Scrollable cursors not supported");
}
require_once $dir . 'pdo_test.inc';
PDOTest::skip();
?>
--FILE--
<?php
if (getenv('REDIR_TEST_DIR') === false) 
putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/');
require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
$db = PDOTest::factory();

$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') {
        $from = 'FROM DUAL';
} else {
        $from = '';
}

$query = "SELECT 'row1' AS r $from UNION SELECT 'row2' $from UNION SELECT 
'row3' $from UNION SELECT 'row4' $from";
$aParams = array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL);

$res = $db->prepare($query, $aParams);
$res->execute();
var_dump($res->fetchColumn());
var_dump($res->fetchColumn());
var_dump($res->fetchColumn());
var_dump($res->fetchColumn());
var_dump($res->fetchColumn());

var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_ABS, 3));
var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_PRIOR));
var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_FIRST));
var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_LAST));
var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_REL, -1));

var_dump($res->fetchAll(PDO::FETCH_ASSOC));

// Test binding params via emulated prepared query
$res = $db->prepare("SELECT ? $from", $aParams);
$res->execute(array("it's working"));
var_dump($res->fetch(PDO::FETCH_NUM));


// Test bug #48188, trying to execute again
$res->execute(array("try again"));
var_dump($res->fetchColumn());
var_dump($res->fetchColumn());

?>
--EXPECT--
string(4) "row1"
string(4) "row2"
string(4) "row3"
string(4) "row4"
bool(false)
array(1) {
  [0]=>
  string(4) "row3"
}
array(1) {
  [0]=>
  string(4) "row2"
}
array(1) {
  [0]=>
  string(4) "row1"
}
array(1) {
  [0]=>
  string(4) "row4"
}
array(1) {
  [0]=>
  string(4) "row3"
}
array(1) {
  [0]=>
  array(1) {
    ["r"]=>
    string(4) "row4"
  }
}
array(1) {
  [0]=>
  string(12) "it's working"
}
string(9) "try again"
bool(false)



-- 
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php