cvs: php-src /ext/pdo/tests pdo_017.inc /ext/pdo_odbc/tests pdo_017.phpt

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===