| 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());
|
| -}
|
|
|