Home | History | Annotate | Download | only in sql 
      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
      3 // found in the LICENSE file.
      4 
      5 #include <string>
      6 
      7 #include "base/bind.h"
      8 #include "base/files/file_util.h"
      9 #include "base/files/scoped_temp_dir.h"
     10 #include "sql/connection.h"
     11 #include "sql/statement.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 void CaptureErrorCallback(int* error_pointer, std::string* sql_text,
     20                           int error, sql::Statement* stmt) {
     21   *error_pointer = error;
     22   const char* text = stmt ? stmt->GetSQLStatement() : NULL;
     23   *sql_text = text ? text : "no statement available";
     24 }
     25 
     26 class SQLiteFeaturesTest : public testing::Test {
     27  public:
     28   SQLiteFeaturesTest() : error_(SQLITE_OK) {}
     29 
     30   virtual void SetUp() {
     31     ASSERT_TRUE(temp_dir_.CreateUniqueTempDir());
     32     ASSERT_TRUE(db_.Open(temp_dir_.path().AppendASCII("SQLStatementTest.db")));
     33 
     34     // The error delegate will set |error_| and |sql_text_| when any sqlite
     35     // statement operation returns an error code.
     36     db_.set_error_callback(base::Bind(&CaptureErrorCallback,
     37                                       &error_, &sql_text_));
     38   }
     39 
     40   virtual void TearDown() {
     41     // If any error happened the original sql statement can be found in
     42     // |sql_text_|.
     43     EXPECT_EQ(SQLITE_OK, error_);
     44     db_.Close();
     45   }
     46 
     47   sql::Connection& db() { return db_; }
     48 
     49  private:
     50   base::ScopedTempDir temp_dir_;
     51   sql::Connection db_;
     52 
     53   // The error code of the most recent error.
     54   int error_;
     55   // Original statement which has caused the error.
     56   std::string sql_text_;
     57 };
     58 
     59 // Do not include fts1 support, it is not useful, and nobody is
     60 // looking at it.
     61 TEST_F(SQLiteFeaturesTest, NoFTS1) {
     62   ASSERT_EQ(SQLITE_ERROR, db().ExecuteAndReturnErrorCode(
     63       "CREATE VIRTUAL TABLE foo USING fts1(x)"));
     64 }
     65 
     66 #if !defined(OS_IOS)
     67 // fts2 is used for older history files, so we're signed on for keeping our
     68 // version up-to-date.  iOS does not include fts2, so this test does not run on
     69 // iOS.
     70 // TODO(shess): Think up a crazy way to get out from having to support
     71 // this forever.
     72 TEST_F(SQLiteFeaturesTest, FTS2) {
     73   ASSERT_TRUE(db().Execute("CREATE VIRTUAL TABLE foo USING fts2(x)"));
     74 }
     75 #endif
     76 
     77 // fts3 is used for current history files, and also for WebDatabase.
     78 TEST_F(SQLiteFeaturesTest, FTS3) {
     79   ASSERT_TRUE(db().Execute("CREATE VIRTUAL TABLE foo USING fts3(x)"));
     80 }
     81 
     82 }  // namespace
     83