| OLD | NEW |
| 1 // Copyright (c) 2012 The Chromium Authors. All rights reserved. | 1 // Copyright (c) 2012 The Chromium Authors. All rights reserved. |
| 2 // Use of this source code is governed by a BSD-style license that can be | 2 // Use of this source code is governed by a BSD-style license that can be |
| 3 // found in the LICENSE file. | 3 // found in the LICENSE file. |
| 4 | 4 |
| 5 #include <string> | 5 #include <string> |
| 6 | 6 |
| 7 #include "base/bind.h" | 7 #include "base/bind.h" |
| 8 #include "base/files/file_util.h" | 8 #include "base/files/file_util.h" |
| 9 #include "base/files/scoped_temp_dir.h" | 9 #include "base/files/scoped_temp_dir.h" |
| 10 #include "sql/connection.h" | 10 #include "sql/connection.h" |
| 11 #include "sql/statement.h" | 11 #include "sql/statement.h" |
| 12 #include "sql/test/sql_test_base.h" |
| 12 #include "sql/test/test_helpers.h" | 13 #include "sql/test/test_helpers.h" |
| 13 #include "testing/gtest/include/gtest/gtest.h" | 14 #include "testing/gtest/include/gtest/gtest.h" |
| 14 #include "third_party/sqlite/sqlite3.h" | 15 #include "third_party/sqlite/sqlite3.h" |
| 15 | 16 |
| 16 // Test that certain features are/are-not enabled in our SQLite. | 17 // Test that certain features are/are-not enabled in our SQLite. |
| 17 | 18 |
| 18 namespace { | 19 namespace { |
| 19 | 20 |
| 20 void CaptureErrorCallback(int* error_pointer, std::string* sql_text, | 21 void CaptureErrorCallback(int* error_pointer, std::string* sql_text, |
| 21 int error, sql::Statement* stmt) { | 22 int error, sql::Statement* stmt) { |
| 22 *error_pointer = error; | 23 *error_pointer = error; |
| 23 const char* text = stmt ? stmt->GetSQLStatement() : NULL; | 24 const char* text = stmt ? stmt->GetSQLStatement() : NULL; |
| 24 *sql_text = text ? text : "no statement available"; | 25 *sql_text = text ? text : "no statement available"; |
| 25 } | 26 } |
| 26 | 27 |
| 27 class SQLiteFeaturesTest : public testing::Test { | 28 class SQLiteFeaturesTest : public sql::SQLTestBase { |
| 28 public: | 29 public: |
| 29 SQLiteFeaturesTest() : error_(SQLITE_OK) {} | 30 SQLiteFeaturesTest() : error_(SQLITE_OK) {} |
| 30 | 31 |
| 31 void SetUp() override { | 32 void SetUp() override { |
| 32 ASSERT_TRUE(temp_dir_.CreateUniqueTempDir()); | 33 SQLTestBase::SetUp(); |
| 33 ASSERT_TRUE(db_.Open(temp_dir_.path().AppendASCII("SQLStatementTest.db"))); | |
| 34 | 34 |
| 35 // The error delegate will set |error_| and |sql_text_| when any sqlite | 35 // The error delegate will set |error_| and |sql_text_| when any sqlite |
| 36 // statement operation returns an error code. | 36 // statement operation returns an error code. |
| 37 db_.set_error_callback(base::Bind(&CaptureErrorCallback, | 37 db().set_error_callback( |
| 38 &error_, &sql_text_)); | 38 base::Bind(&CaptureErrorCallback, &error_, &sql_text_)); |
| 39 } | 39 } |
| 40 | 40 |
| 41 void TearDown() override { | 41 void TearDown() override { |
| 42 // If any error happened the original sql statement can be found in | 42 // If any error happened the original sql statement can be found in |
| 43 // |sql_text_|. | 43 // |sql_text_|. |
| 44 EXPECT_EQ(SQLITE_OK, error_) << sql_text_; | 44 EXPECT_EQ(SQLITE_OK, error_) << sql_text_; |
| 45 db_.Close(); | 45 |
| 46 SQLTestBase::TearDown(); |
| 46 } | 47 } |
| 47 | 48 |
| 48 sql::Connection& db() { return db_; } | |
| 49 int error() { return error_; } | 49 int error() { return error_; } |
| 50 | 50 |
| 51 private: | 51 private: |
| 52 base::ScopedTempDir temp_dir_; | |
| 53 sql::Connection db_; | |
| 54 | |
| 55 // The error code of the most recent error. | 52 // The error code of the most recent error. |
| 56 int error_; | 53 int error_; |
| 57 // Original statement which has caused the error. | 54 // Original statement which has caused the error. |
| 58 std::string sql_text_; | 55 std::string sql_text_; |
| 59 }; | 56 }; |
| 60 | 57 |
| 61 // Do not include fts1 support, it is not useful, and nobody is | 58 // Do not include fts1 support, it is not useful, and nobody is |
| 62 // looking at it. | 59 // looking at it. |
| 63 TEST_F(SQLiteFeaturesTest, NoFTS1) { | 60 TEST_F(SQLiteFeaturesTest, NoFTS1) { |
| 64 ASSERT_EQ(SQLITE_ERROR, db().ExecuteAndReturnErrorCode( | 61 ASSERT_EQ(SQLITE_ERROR, db().ExecuteAndReturnErrorCode( |
| (...skipping 75 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 140 EXPECT_TRUE(sql::test::CountTableRows(&db(), "children", &rows)); | 137 EXPECT_TRUE(sql::test::CountTableRows(&db(), "children", &rows)); |
| 141 EXPECT_EQ(2u, rows); | 138 EXPECT_EQ(2u, rows); |
| 142 | 139 |
| 143 // Deleting the parent should cascade, i.e., delete the children as well. | 140 // Deleting the parent should cascade, i.e., delete the children as well. |
| 144 ASSERT_TRUE(db().Execute("DELETE FROM parents")); | 141 ASSERT_TRUE(db().Execute("DELETE FROM parents")); |
| 145 EXPECT_TRUE(sql::test::CountTableRows(&db(), "children", &rows)); | 142 EXPECT_TRUE(sql::test::CountTableRows(&db(), "children", &rows)); |
| 146 EXPECT_EQ(0u, rows); | 143 EXPECT_EQ(0u, rows); |
| 147 } | 144 } |
| 148 | 145 |
| 149 } // namespace | 146 } // namespace |
| OLD | NEW |