1--TEST-- 2PDO::rollBack() 3--EXTENSIONS-- 4pdo_mysql 5--SKIPIF-- 6<?php 7require_once __DIR__ . '/inc/mysql_pdo_test.inc'; 8MySQLPDOTest::skip(); 9MySQLPDOTest::skipNotTransactionalEngine(); 10--FILE-- 11<?php 12 require_once __DIR__ . '/inc/mysql_pdo_test.inc'; 13 $db = MySQLPDOTest::factory(); 14 15 $table = 'pdo_mysql_rollback'; 16 $table2 = 'pdo_mysql_rollback_2'; 17 18 MySQLPDOTest::createTestTable($table, $db, MySQLPDOTest::detect_transactional_mysql_engine($db)); 19 20 $db->beginTransaction(); 21 22 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC); 23 $num = $row['_num']; 24 25 $db->query("INSERT INTO {$table}(id, label) VALUES (100, 'z')"); 26 $num++; 27 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC); 28 if ($row['_num'] != $num) 29 printf("[001] INSERT has failed, test will fail\n"); 30 31 $db->rollBack(); 32 $num--; 33 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table}")->fetch(PDO::FETCH_ASSOC); 34 if ($row['_num'] != $num) 35 printf("[002] ROLLBACK has failed\n"); 36 37 $db->beginTransaction(); 38 $db->query("INSERT INTO {$table}(id, label) VALUES (100, 'z')"); 39 $db->query("CREATE TABLE {$table2}(id INT)"); 40 $num++; 41 try { 42 $db->rollBack(); 43 $failed = false; 44 } catch (PDOException $e) { 45 $failed = true; 46 } 47 if (!$failed) { 48 printf("[003] Rollback should have failed\n"); 49 } 50 51 $db->query("DROP TABLE IF EXISTS {$table2}"); 52 $db->query("CREATE TABLE {$table2}(id INT) ENGINE=MyISAM"); 53 $db->beginTransaction(); 54 $db->query("INSERT INTO {$table2}(id) VALUES (1)"); 55 $db->rollBack(); 56 $row = $db->query("SELECT COUNT(*) AS _num FROM {$table2}")->fetch(PDO::FETCH_ASSOC); 57 if ($row['_num'] != 1) 58 printf("[003] ROLLBACK should have no effect\n"); 59 60 $db->query("DROP TABLE IF EXISTS {$table2}"); 61 62 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1); 63 $db->beginTransaction(); 64 $db->query("DELETE FROM {$table}"); 65 $db->rollBack(); 66 var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT)); 67 68 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, 0); 69 $db->beginTransaction(); 70 $db->query("DELETE FROM {$table}"); 71 $db->rollBack(); 72 var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT)); 73 74 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1); 75 $db->beginTransaction(); 76 $db->query("DELETE FROM {$table}"); 77 $db->commit(); 78 var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT)); 79 80 $db->setAttribute(PDO::ATTR_AUTOCOMMIT, 0); 81 $db->beginTransaction(); 82 $db->query("DELETE FROM {$table}"); 83 $db->commit(); 84 var_dump($db->getAttribute(PDO::ATTR_AUTOCOMMIT)); 85 86 print "done!"; 87?> 88--CLEAN-- 89<?php 90require_once __DIR__ . '/inc/mysql_pdo_test.inc'; 91$db = MySQLPDOTest::factory(); 92$db->exec('DROP TABLE IF EXISTS pdo_mysql_rollback'); 93$db->exec('DROP TABLE IF EXISTS pdo_mysql_rollback_2'); 94?> 95--EXPECT-- 96bool(true) 97bool(false) 98bool(true) 99bool(false) 100done! 101