dbs Sat Mar 5 16:03:12 2005 EDT
Added files:
/php-src/ext/pdo/tests pdo_017.inc
/php-src/ext/pdo_odbc/tests pdo_017.phpt
Log:
Test PDO::beginTransaction and PDO::rollBack.
http://cvs.php.net/co.php/php-src/ext/pdo/tests/pdo_017.inc?r=1.1&p=1
Index: php-src/ext/pdo/tests/pdo_017.inc
+++ php-src/ext/pdo/tests/pdo_017.inc
<?php # vim:ft=php
require_once('pdo.inc');
set_sql('create', 'CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val
VARCHAR(10))');
set_sql('insert1', "INSERT INTO test VALUES(1, 'A')");
set_sql('insert2', "INSERT INTO test VALUES(2, 'B')");
set_sql('insert3', "INSERT INTO test VALUES(3, 'C')");
set_sql('select', 'SELECT COUNT(*) FROM test');
set_sql('delete', 'DELETE FROM test');
function countRows($DB, $action) {
global $SQL;
$stmt = $DB->query($SQL['select']);
$res = $stmt->fetchSingle();
return "Counted $res rows after $action.\n";
}
$DB->exec($SQL['create']);
$DB->exec($SQL['insert1']);
$DB->exec($SQL['insert2']);
$DB->exec($SQL['insert3']);
echo countRows($DB, 'insert');
$DB->beginTransaction();
$DB->exec($SQL['delete']);
echo countRows($DB, 'delete');
$DB->rollBack();
echo countRows($DB, 'rollback');
?>
http://cvs.php.net/co.php/php-src/ext/pdo_odbc/tests/pdo_017.phpt?r=1.1&p=1
Index: php-src/ext/pdo_odbc/tests/pdo_017.phpt
+++ php-src/ext/pdo_odbc/tests/pdo_017.phpt
--TEST--
PDO_ODBC: PDO::beginTransaction / PDO::rollBack
--SKIPIF--
<?php # vim:ft=php
require_once('skipif.inc'); ?>
--FILE--
<?php
require_once('connection.inc');
require_once('prepare.inc');
require_once($PDO_TESTS . 'pdo_017.inc');
?>
===DONE===
<?php exit(0); ?>
--EXPECT--
Counted 3 rows after insert.
Counted 0 rows after delete.
Counted 3 rows after rollback.
===DONE===
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
