diff options
Diffstat (limited to 'ext/pdo/tests/pdo_017.phpt')
-rw-r--r-- | ext/pdo/tests/pdo_017.phpt | 72 |
1 files changed, 0 insertions, 72 deletions
diff --git a/ext/pdo/tests/pdo_017.phpt b/ext/pdo/tests/pdo_017.phpt deleted file mode 100644 index 651ee2860c..0000000000 --- a/ext/pdo/tests/pdo_017.phpt +++ /dev/null @@ -1,72 +0,0 @@ ---TEST-- -PDO Common: transactions ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded('pdo')) die('skip'); -$dir = getenv('REDIR_TEST_DIR'); -if (false == $dir) die('skip no driver'); -require_once $dir . 'pdo_test.inc'; -PDOTest::skip(); - -$db = PDOTest::factory(); -try { - $db->beginTransaction(); -} catch (PDOException $e) { - die('skip no working transactions: ' . $e->getMessage()); -} - -if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') { - if (false === PDOTest::detect_transactional_mysql_engine($db)) { - die('skip your mysql configuration does not support working transactions'); - } -} -?> ---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(); - -if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') { - $suf = ' Type=' . PDOTest::detect_transactional_mysql_engine($db); -} else { - $suf = ''; -} - -$db->exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10))'.$suf); -$db->exec("INSERT INTO test VALUES(1, 'A')"); -$db->exec("INSERT INTO test VALUES(2, 'B')"); -$db->exec("INSERT INTO test VALUES(3, 'C')"); -$delete = $db->prepare('DELETE FROM test'); - -function countRows($action) { - global $db; - $select = $db->prepare('SELECT COUNT(*) FROM test'); - $select->execute(); - $res = $select->fetchColumn(); - return "Counted $res rows after $action.\n"; -} - -echo countRows('insert'); - -$db->beginTransaction(); -$delete->execute(); -echo countRows('delete'); -$db->rollBack(); - -echo countRows('rollback'); - -$db->beginTransaction(); -$delete->execute(); -echo countRows('delete'); -$db->commit(); - -echo countRows('commit'); - -?> ---EXPECT-- -Counted 3 rows after insert. -Counted 0 rows after delete. -Counted 3 rows after rollback. -Counted 0 rows after delete. -Counted 0 rows after commit. |