| Index: app/sql/sqlite_features_unittest.cc
|
| diff --git a/app/sql/sqlite_features_unittest.cc b/app/sql/sqlite_features_unittest.cc
|
| new file mode 100644
|
| index 0000000000000000000000000000000000000000..0ee63be988446020b2e60b8c7ffc51036903dbd0
|
| --- /dev/null
|
| +++ b/app/sql/sqlite_features_unittest.cc
|
| @@ -0,0 +1,100 @@
|
| +// 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 <string>
|
| +
|
| +#include "app/sql/connection.h"
|
| +#include "app/sql/statement.h"
|
| +#include "base/file_path.h"
|
| +#include "base/file_util.h"
|
| +#include "base/path_service.h"
|
| +#include "testing/gtest/include/gtest/gtest.h"
|
| +#include "third_party/sqlite/sqlite3.h"
|
| +
|
| +// Test that certain features are/are-not enabled in our SQLite.
|
| +
|
| +namespace {
|
| +
|
| +
|
| +class StatementErrorHandler : public sql::ErrorDelegate {
|
| + public:
|
| + StatementErrorHandler() : error_(SQLITE_OK) {}
|
| +
|
| + virtual int OnError(int error, sql::Connection* connection,
|
| + sql::Statement* stmt) {
|
| + error_ = error;
|
| + const char* sql_txt = stmt ? stmt->GetSQLStatement() : NULL;
|
| + sql_text_ = sql_txt ? sql_txt : "no statement available";
|
| + return error;
|
| + }
|
| +
|
| + int error() const { return error_; }
|
| +
|
| + void reset_error() {
|
| + sql_text_.clear();
|
| + error_ = SQLITE_OK;
|
| + }
|
| +
|
| + const char* sql_statement() const { return sql_text_.c_str(); }
|
| +
|
| + private:
|
| + int error_;
|
| + std::string sql_text_;
|
| +};
|
| +
|
| +class SQLiteFeaturesTest : public testing::Test {
|
| + public:
|
| + SQLiteFeaturesTest() : error_handler_(new StatementErrorHandler) {}
|
| +
|
| + void SetUp() {
|
| + ASSERT_TRUE(PathService::Get(base::DIR_TEMP, &path_));
|
| + path_ = path_.AppendASCII("SQLStatementTest.db");
|
| + file_util::Delete(path_, false);
|
| + ASSERT_TRUE(db_.Open(path_));
|
| + // The |error_handler_| will be called if any sqlite statement operation
|
| + // returns an error code.
|
| + db_.set_error_delegate(error_handler_);
|
| + }
|
| +
|
| + void TearDown() {
|
| + // If any error happened the original sql statement can be found in
|
| + // error_handler_->sql_statement().
|
| + EXPECT_EQ(SQLITE_OK, error_handler_->error());
|
| + db_.Close();
|
| + // If this fails something is going on with cleanup and later tests may
|
| + // fail, so we want to identify problems right away.
|
| + ASSERT_TRUE(file_util::Delete(path_, false));
|
| + }
|
| +
|
| + sql::Connection& db() { return db_; }
|
| +
|
| + int sqlite_error() const { return error_handler_->error(); }
|
| + void reset_error() const { error_handler_->reset_error(); }
|
| +
|
| + private:
|
| + FilePath path_;
|
| + sql::Connection db_;
|
| + scoped_refptr<StatementErrorHandler> error_handler_;
|
| +};
|
| +
|
| +// Do not include fts1 support, it is not useful, and nobody is
|
| +// looking at it.
|
| +TEST_F(SQLiteFeaturesTest, NoFTS1) {
|
| + ASSERT_FALSE(db().Execute("CREATE VIRTUAL TABLE foo USING fts1(x)"));
|
| +}
|
| +
|
| +// fts2 is used for older history files, so we're signed on for
|
| +// keeping our version up-to-date.
|
| +// TODO(shess): Think up a crazy way to get out from having to support
|
| +// this forever.
|
| +TEST_F(SQLiteFeaturesTest, FTS2) {
|
| + ASSERT_TRUE(db().Execute("CREATE VIRTUAL TABLE foo USING fts2(x)"));
|
| +}
|
| +
|
| +// fts3 is used for current history files, and also for WebDatabase.
|
| +TEST_F(SQLiteFeaturesTest, FTS3) {
|
| + ASSERT_TRUE(db().Execute("CREATE VIRTUAL TABLE foo USING fts3(x)"));
|
| +}
|
| +
|
| +} // namespace
|
|
|