dbs             Tue Mar  8 12:39:42 2005 EDT

  Added files:                 
    /php-src/ext/pdo/tests      pdo_020.inc 
    /php-src/ext/pdo_odbc/tests pdo_020.phpt 
  Log:
  Add a test for PDOStatement::columnCount().
  
  

http://cvs.php.net/co.php/php-src/ext/pdo/tests/pdo_020.inc?r=1.1&p=1
Index: php-src/ext/pdo/tests/pdo_020.inc
+++ php-src/ext/pdo/tests/pdo_020.inc
<?php # vim:ft=php

require_once('pdo.inc');

set_sql('create1',  'CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val 
VARCHAR(10), val2 VARCHAR(16))');
set_sql('insert1', "INSERT INTO test VALUES(1, 'A', 'A')"); 
set_sql('insert2', "INSERT INTO test VALUES(2, 'B', 'B')"); 
set_sql('insert3', "INSERT INTO test VALUES(3, 'C', 'C')");
set_sql('select1',  'SELECT id, val FROM test');
set_sql('select2',  'SELECT id, val, val2 FROM test');
set_sql('select3',  'SELECT COUNT(*) FROM test');

function countColumns($DB, $action) {
    global $SQL;
    $stmt = $DB->query($SQL[$action]);
    $res = $stmt->columnCount();
    return "Counted $res columns after $action.\n";
}

$DB->exec($SQL['create1']);
$DB->exec($SQL['insert1']); 
$DB->exec($SQL['insert2']); 
$DB->exec($SQL['insert3']); 

echo countColumns($DB, 'select1');
echo countColumns($DB, 'select2');
echo countColumns($DB, 'select3');
?>

http://cvs.php.net/co.php/php-src/ext/pdo_odbc/tests/pdo_020.phpt?r=1.1&p=1
Index: php-src/ext/pdo_odbc/tests/pdo_020.phpt
+++ php-src/ext/pdo_odbc/tests/pdo_020.phpt
--TEST--
PDO_ODBC: PDOStatement::columnCount
--SKIPIF--
<?php # vim:ft=php
require_once('skipif.inc'); ?>
--FILE--
<?php

require_once('connection.inc');
require_once('prepare.inc');

require_once($PDO_TESTS . 'pdo_020.inc');

?>
===DONE===
<?php exit(0); ?>
--EXPECT--
Counted 2 columns after select1.
Counted 3 columns after select2.
Counted 1 columns after select3.
===DONE===

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

Reply via email to