| OLD | NEW |
| (Empty) |
| 1 // Copyright (c) 2011 The Chromium Authors. All rights reserved. | |
| 2 // Use of this source code is governed by a BSD-style license that can be | |
| 3 // found in the LICENSE file. | |
| 4 | |
| 5 #include <string> | |
| 6 | |
| 7 #include "app/sql/connection.h" | |
| 8 #include "app/sql/statement.h" | |
| 9 #include "base/file_path.h" | |
| 10 #include "base/file_util.h" | |
| 11 #include "base/path_service.h" | |
| 12 #include "testing/gtest/include/gtest/gtest.h" | |
| 13 #include "third_party/sqlite/sqlite3.h" | |
| 14 | |
| 15 // Test that certain features are/are-not enabled in our SQLite. | |
| 16 | |
| 17 namespace { | |
| 18 | |
| 19 | |
| 20 class StatementErrorHandler : public sql::ErrorDelegate { | |
| 21 public: | |
| 22 StatementErrorHandler() : error_(SQLITE_OK) {} | |
| 23 | |
| 24 virtual int OnError(int error, sql::Connection* connection, | |
| 25 sql::Statement* stmt) { | |
| 26 error_ = error; | |
| 27 const char* sql_txt = stmt ? stmt->GetSQLStatement() : NULL; | |
| 28 sql_text_ = sql_txt ? sql_txt : "no statement available"; | |
| 29 return error; | |
| 30 } | |
| 31 | |
| 32 int error() const { return error_; } | |
| 33 | |
| 34 void reset_error() { | |
| 35 sql_text_.clear(); | |
| 36 error_ = SQLITE_OK; | |
| 37 } | |
| 38 | |
| 39 const char* sql_statement() const { return sql_text_.c_str(); } | |
| 40 | |
| 41 private: | |
| 42 int error_; | |
| 43 std::string sql_text_; | |
| 44 }; | |
| 45 | |
| 46 class SQLiteFeaturesTest : public testing::Test { | |
| 47 public: | |
| 48 SQLiteFeaturesTest() : error_handler_(new StatementErrorHandler) {} | |
| 49 | |
| 50 void SetUp() { | |
| 51 ASSERT_TRUE(PathService::Get(base::DIR_TEMP, &path_)); | |
| 52 path_ = path_.AppendASCII("SQLStatementTest.db"); | |
| 53 file_util::Delete(path_, false); | |
| 54 ASSERT_TRUE(db_.Open(path_)); | |
| 55 // The |error_handler_| will be called if any sqlite statement operation | |
| 56 // returns an error code. | |
| 57 db_.set_error_delegate(error_handler_); | |
| 58 } | |
| 59 | |
| 60 void TearDown() { | |
| 61 // If any error happened the original sql statement can be found in | |
| 62 // error_handler_->sql_statement(). | |
| 63 EXPECT_EQ(SQLITE_OK, error_handler_->error()); | |
| 64 db_.Close(); | |
| 65 // If this fails something is going on with cleanup and later tests may | |
| 66 // fail, so we want to identify problems right away. | |
| 67 ASSERT_TRUE(file_util::Delete(path_, false)); | |
| 68 } | |
| 69 | |
| 70 sql::Connection& db() { return db_; } | |
| 71 | |
| 72 int sqlite_error() const { return error_handler_->error(); } | |
| 73 void reset_error() const { error_handler_->reset_error(); } | |
| 74 | |
| 75 private: | |
| 76 FilePath path_; | |
| 77 sql::Connection db_; | |
| 78 scoped_refptr<StatementErrorHandler> error_handler_; | |
| 79 }; | |
| 80 | |
| 81 // Do not include fts1 support, it is not useful, and nobody is | |
| 82 // looking at it. | |
| 83 TEST_F(SQLiteFeaturesTest, NoFTS1) { | |
| 84 ASSERT_FALSE(db().Execute("CREATE VIRTUAL TABLE foo USING fts1(x)")); | |
| 85 } | |
| 86 | |
| 87 // fts2 is used for older history files, so we're signed on for | |
| 88 // keeping our version up-to-date. | |
| 89 // TODO(shess): Think up a crazy way to get out from having to support | |
| 90 // this forever. | |
| 91 TEST_F(SQLiteFeaturesTest, FTS2) { | |
| 92 ASSERT_TRUE(db().Execute("CREATE VIRTUAL TABLE foo USING fts2(x)")); | |
| 93 } | |
| 94 | |
| 95 // fts3 is used for current history files, and also for WebDatabase. | |
| 96 TEST_F(SQLiteFeaturesTest, FTS3) { | |
| 97 ASSERT_TRUE(db().Execute("CREATE VIRTUAL TABLE foo USING fts3(x)")); | |
| 98 } | |
| 99 | |
| 100 } // namespace | |
| OLD | NEW |