Index: app/sql/transaction_unittest.cc |
diff --git a/app/sql/transaction_unittest.cc b/app/sql/transaction_unittest.cc |
deleted file mode 100644 |
index 3d42a31f3f7d314b32328c97f5d01c7e79d65eae..0000000000000000000000000000000000000000 |
--- a/app/sql/transaction_unittest.cc |
+++ /dev/null |
@@ -1,133 +0,0 @@ |
-// Copyright (c) 2011 The Chromium Authors. All rights reserved. |
-// Use of this source code is governed by a BSD-style license that can be |
-// found in the LICENSE file. |
- |
-#include "app/sql/connection.h" |
-#include "app/sql/statement.h" |
-#include "app/sql/transaction.h" |
-#include "base/file_util.h" |
-#include "base/scoped_temp_dir.h" |
-#include "testing/gtest/include/gtest/gtest.h" |
-#include "third_party/sqlite/sqlite3.h" |
- |
-class SQLTransactionTest : public testing::Test { |
- public: |
- SQLTransactionTest() {} |
- |
- void SetUp() { |
- ASSERT_TRUE(temp_dir_.CreateUniqueTempDir()); |
- ASSERT_TRUE(db_.Open( |
- temp_dir_.path().AppendASCII("SQLTransactionTest.db"))); |
- |
- ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)")); |
- } |
- |
- void TearDown() { |
- db_.Close(); |
- } |
- |
- sql::Connection& db() { return db_; } |
- |
- // Returns the number of rows in table "foo". |
- int CountFoo() { |
- sql::Statement count(db().GetUniqueStatement("SELECT count(*) FROM foo")); |
- count.Step(); |
- return count.ColumnInt(0); |
- } |
- |
- private: |
- ScopedTempDir temp_dir_; |
- sql::Connection db_; |
-}; |
- |
-TEST_F(SQLTransactionTest, Commit) { |
- { |
- sql::Transaction t(&db()); |
- EXPECT_FALSE(t.is_open()); |
- EXPECT_TRUE(t.Begin()); |
- EXPECT_TRUE(t.is_open()); |
- |
- EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); |
- |
- t.Commit(); |
- EXPECT_FALSE(t.is_open()); |
- } |
- |
- EXPECT_EQ(1, CountFoo()); |
-} |
- |
-TEST_F(SQLTransactionTest, Rollback) { |
- // Test some basic initialization, and that rollback runs when you exit the |
- // scope. |
- { |
- sql::Transaction t(&db()); |
- EXPECT_FALSE(t.is_open()); |
- EXPECT_TRUE(t.Begin()); |
- EXPECT_TRUE(t.is_open()); |
- |
- EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); |
- } |
- |
- // Nothing should have been committed since it was implicitly rolled back. |
- EXPECT_EQ(0, CountFoo()); |
- |
- // Test explicit rollback. |
- sql::Transaction t2(&db()); |
- EXPECT_FALSE(t2.is_open()); |
- EXPECT_TRUE(t2.Begin()); |
- |
- EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); |
- t2.Rollback(); |
- EXPECT_FALSE(t2.is_open()); |
- |
- // Nothing should have been committed since it was explicitly rolled back. |
- EXPECT_EQ(0, CountFoo()); |
-} |
- |
-// Rolling back any part of a transaction should roll back all of them. |
-TEST_F(SQLTransactionTest, NestedRollback) { |
- EXPECT_EQ(0, db().transaction_nesting()); |
- |
- // Outermost transaction. |
- { |
- sql::Transaction outer(&db()); |
- EXPECT_TRUE(outer.Begin()); |
- EXPECT_EQ(1, db().transaction_nesting()); |
- |
- // The first inner one gets committed. |
- { |
- sql::Transaction inner1(&db()); |
- EXPECT_TRUE(inner1.Begin()); |
- EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); |
- EXPECT_EQ(2, db().transaction_nesting()); |
- |
- inner1.Commit(); |
- EXPECT_EQ(1, db().transaction_nesting()); |
- } |
- |
- // One row should have gotten inserted. |
- EXPECT_EQ(1, CountFoo()); |
- |
- // The second inner one gets rolled back. |
- { |
- sql::Transaction inner2(&db()); |
- EXPECT_TRUE(inner2.Begin()); |
- EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); |
- EXPECT_EQ(2, db().transaction_nesting()); |
- |
- inner2.Rollback(); |
- EXPECT_EQ(1, db().transaction_nesting()); |
- } |
- |
- // A third inner one will fail in Begin since one has already been rolled |
- // back. |
- EXPECT_EQ(1, db().transaction_nesting()); |
- { |
- sql::Transaction inner3(&db()); |
- EXPECT_FALSE(inner3.Begin()); |
- EXPECT_EQ(1, db().transaction_nesting()); |
- } |
- } |
- EXPECT_EQ(0, db().transaction_nesting()); |
- EXPECT_EQ(0, CountFoo()); |
-} |