cvs: php-src /ext/pdo_odbc/tests pdo_006.phpt pdo_007.phpt pdo_008.phpt pdo_009.phpt
| From: | Dan Scott | Date: | Thu, 03 Mar 2005 13:53:57 +0000 |
| Subject: | cvs: php-src /ext/pdo_odbc/tests pdo_006.phpt pdo_007.phpt pdo_008.phpt pdo_009.phpt | ||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-30708@lists.php.net to get a copy of this message | ||
dbs Thu Mar 3 08:53:57 2005 EDT
Added files:
/php-src/ext/pdo_odbc/tests pdo_006.phpt pdo_007.phpt pdo_008.phpt
pdo_009.phpt
Log:
Next batch of tests for PDO_ODBC (tested against DB2 V8.2).
http://cvs.php.net/co.php/php-src/ext/pdo_odbc/tests/pdo_006.phpt?r=1.1&p=1
Index: php-src/ext/pdo_odbc/tests/pdo_006.phpt
+++ php-src/ext/pdo_odbc/tests/pdo_006.phpt
--TEST--
PDO_ODBC: PDO_FETCH_GROUP
--SKIPIF--
<?php # vim:ft=php
require_once('skipif.inc'); ?>
--FILE--
<?php
require_once('connection.inc');
require_once('prepare.inc');
require_once($PDO_TESTS . 'pdo_006.inc');
?>
===DONE===
<?php exit(0); ?>
--EXPECTF--
array(2) {
["A"]=>
array(2) {
[0]=>
array(1) {
[0]=>
string(1) "1"
}
[1]=>
array(1) {
[0]=>
string(1) "2"
}
}
["C"]=>
array(1) {
[0]=>
array(1) {
[0]=>
string(1) "3"
}
}
}
array(2) {
["A"]=>
array(2) {
[0]=>
array(1) {
["ID"]=>
string(1) "1"
}
[1]=>
array(1) {
["ID"]=>
string(1) "2"
}
}
["C"]=>
array(1) {
[0]=>
array(1) {
["ID"]=>
string(1) "3"
}
}
}
===DONE===
http://cvs.php.net/co.php/php-src/ext/pdo_odbc/tests/pdo_007.phpt?r=1.1&p=1
Index: php-src/ext/pdo_odbc/tests/pdo_007.phpt
+++ php-src/ext/pdo_odbc/tests/pdo_007.phpt
--TEST--
PDO_ODBC: PDO_FETCH_UNIQUE
--SKIPIF--
<?php # vim:ft=php
require_once('skipif.inc'); ?>
--FILE--
<?php
require_once('connection.inc');
require_once('prepare.inc');
$SQL = array('create'=>'CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val
VARCHAR(10))');
require_once($PDO_TESTS . 'pdo_007.inc');
?>
===DONE===
<?php exit(0); ?>
--EXPECTF--
array(3) {
["A"]=>
array(1) {
[0]=>
string(1) "A"
}
["B"]=>
array(1) {
[0]=>
string(1) "A"
}
["C"]=>
array(1) {
[0]=>
string(1) "C"
}
}
array(3) {
["A"]=>
array(1) {
["VAL"]=>
string(1) "A"
}
["B"]=>
array(1) {
["VAL"]=>
string(1) "A"
}
["C"]=>
array(1) {
["VAL"]=>
string(1) "C"
}
}
===DONE===
http://cvs.php.net/co.php/php-src/ext/pdo_odbc/tests/pdo_008.phpt?r=1.1&p=1
Index: php-src/ext/pdo_odbc/tests/pdo_008.phpt
+++ php-src/ext/pdo_odbc/tests/pdo_008.phpt
--TEST--
PDO_ODBC: PDO_FETCH_UNIQUE conflict
--SKIPIF--
<?php # vim:ft=php
require_once('skipif.inc'); ?>
--FILE--
<?php
require_once('connection.inc');
require_once('prepare.inc');
$SQL = array('create'=>'CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val
VARCHAR(10))');
require_once($PDO_TESTS . 'pdo_008.inc');
?>
===DONE===
<?php exit(0); ?>
--EXPECTF--
array(2) {
["A"]=>
array(1) {
[0]=>
string(1) "B"
}
["C"]=>
array(1) {
[0]=>
string(1) "C"
}
}
===DONE===
http://cvs.php.net/co.php/php-src/ext/pdo_odbc/tests/pdo_009.phpt?r=1.1&p=1
Index: php-src/ext/pdo_odbc/tests/pdo_009.phpt
+++ php-src/ext/pdo_odbc/tests/pdo_009.phpt
--TEST--
PDO_ODBC: PDO_FETCH_CLASSTYPE
--SKIPIF--
<?php # vim:ft=php
require_once('skipif.inc'); ?>
--FILE--
<?php
require_once('connection.inc');
require_once('prepare.inc');
$SQL = array (
'create1'=>'CREATE TABLE classtypes(id INT NOT NULL PRIMARY KEY, name VARCHAR(10)
NOT NULL UNIQUE)',
'create2'=>'CREATE TABLE test(id INT NOT NULL PRIMARY KEY, classtype INT, val
VARCHAR(10))'
);
require_once($PDO_TESTS . 'pdo_009.inc');
?>
===DONE===
<?php exit(0); ?>
--EXPECTF--
array(4) {
[0]=>
array(3) {
[0]=>
string(8) "stdClass"
[1]=>
string(1) "1"
[2]=>
string(1) "A"
}
[1]=>
array(3) {
[0]=>
string(5) "Test1"
[1]=>
string(1) "2"
[2]=>
string(1) "B"
}
[2]=>
array(3) {
[0]=>
string(5) "Test2"
[1]=>
string(1) "3"
[2]=>
string(1) "C"
}
[3]=>
array(3) {
[0]=>
NULL
[1]=>
string(1) "4"
[2]=>
string(1) "D"
}
}
Test1::__construct()
Test2::__construct()
Test3::__construct()
array(4) {
[0]=>
object(stdClass)#%d (2) {
["ID"]=>
string(1) "1"
["VAL"]=>
string(1) "A"
}
[1]=>
object(Test1)#%d (2) {
["ID"]=>
string(1) "2"
["VAL"]=>
string(1) "B"
}
[2]=>
object(Test2)#%d (2) {
["ID"]=>
string(1) "3"
["VAL"]=>
string(1) "C"
}
[3]=>
object(Test3)#%d (2) {
["ID"]=>
string(1) "4"
["VAL"]=>
string(1) "D"
}
}
===DONE===