android_history_provider_service_unittest.cc revision bbcdd45c55eb7c4641ab97aef9889b0fc828e7d3
15821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Copyright (c) 2012 The Chromium Authors. All rights reserved.
25821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Use of this source code is governed by a BSD-style license that can be
35821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// found in the LICENSE file.
45821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
55821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/history/android/android_history_provider_service.h"
65821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
7868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles)#include "base/strings/utf_string_conversions.h"
8eb525c5499e34cc9c4b825d6d9e75bb07cc06aceBen Murdoch#include "base/time/time.h"
95821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/history/android/android_history_types.h"
105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/common/chrome_constants.h"
115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/test/base/testing_browser_process.h"
125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/test/base/testing_profile.h"
13868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles)#include "chrome/test/base/testing_profile_manager.h"
142a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)#include "chrome/test/base/ui_test_utils.h"
155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "content/public/browser/browser_thread.h"
165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "content/public/test/test_browser_thread.h"
175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "testing/gtest/include/gtest/gtest.h"
185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)namespace {
205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using base::Bind;
225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using base::Time;
235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using content::BrowserThread;
245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using history::AndroidStatement;
255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using history::HistoryAndBookmarkRow;
265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using history::SearchRow;
275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// The test cases in this file don't intent to test the detail features of
295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Android content provider which have been covered by
305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// android_provider_backend_unittest.cc, instead, they verify the code path to
315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// AndroidProviderBackend working fine.
325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)class AndroidHistoryProviderServiceTest : public testing::Test {
345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) public:
355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidHistoryProviderServiceTest()
365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      : profile_manager_(
372a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)          TestingBrowserProcess::GetGlobal()),
385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        ui_thread_(BrowserThread::UI, &message_loop_),
395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        file_thread_(BrowserThread::FILE, &message_loop_) {
405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  virtual ~AndroidHistoryProviderServiceTest() {
425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) protected:
455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  virtual void SetUp() OVERRIDE {
465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // Setup the testing profile, so the bookmark_model_sql_handler could
475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // get the bookmark model from it.
485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    ASSERT_TRUE(profile_manager_.SetUp());
495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // It seems that the name has to be chrome::kInitialProfile, so it
505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // could be found by ProfileManager::GetLastUsedProfile().
515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    testing_profile_ = profile_manager_.CreateTestingProfile(
525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        chrome::kInitialProfile);
535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    testing_profile_->CreateBookmarkModel(true);
552a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)    ui_test_utils::WaitForBookmarkModelToLoad(testing_profile_);
56bbcdd45c55eb7c4641ab97aef9889b0fc828e7d3Ben Murdoch    ASSERT_TRUE(testing_profile_->CreateHistoryService(true, false));
575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    service_.reset(new AndroidHistoryProviderService(testing_profile_));
585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  virtual void TearDown() OVERRIDE {
615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    testing_profile_->DestroyHistoryService();
625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    profile_manager_.DeleteTestingProfile(chrome::kInitialProfile);
635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    testing_profile_=NULL;
645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) protected:
675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  TestingProfileManager profile_manager_;
6890dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop message_loop_;
695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  content::TestBrowserThread ui_thread_;
705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  content::TestBrowserThread file_thread_;
715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  scoped_ptr<AndroidHistoryProviderService> service_;
725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  CancelableRequestConsumer cancelable_consumer_;
735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  TestingProfile* testing_profile_;
745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) private:
765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  DISALLOW_COPY_AND_ASSIGN(AndroidHistoryProviderServiceTest);
775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)};
785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)class CallbackHelper : public base::RefCountedThreadSafe<CallbackHelper> {
805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) public:
815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  CallbackHelper()
825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      : success_(false),
835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        statement_(NULL),
845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        cursor_position_(0),
855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        count_(0) {
865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  bool success() const {
895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    return success_;
905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidStatement* statement() const {
935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    return statement_;
945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int cursor_position() const {
975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    return cursor_position_;
985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int count() const {
1015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    return count_;
1025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnInserted(AndroidHistoryProviderService::Handle handle,
1055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                  bool success,
1065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                  int64 id) {
1075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    success_ = success;
10890dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnQueryResult(AndroidHistoryProviderService::Handle handle,
1125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                     bool success,
1135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                     AndroidStatement* statement) {
1145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    success_ = success;
1155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    statement_ = statement;
11690dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnUpdated(AndroidHistoryProviderService::Handle handle,
1205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                 bool success,
1215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                 int count) {
1225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    success_ = success;
1235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    count_ = count;
12490dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnDeleted(AndroidHistoryProviderService::Handle handle,
1285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                 bool success,
1295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                 int count) {
1305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    success_ = success;
1315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    count_ = count;
13290dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnStatementMoved(AndroidHistoryProviderService::Handle handle,
1365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                        int cursor_position) {
1375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    cursor_position_ = cursor_position;
13890dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) private:
1425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  friend class base::RefCountedThreadSafe<CallbackHelper>;
1435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  ~CallbackHelper() {
1445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  bool success_;
1475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidStatement* statement_;
1485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int cursor_position_;
1495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int count_;
1505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  DISALLOW_COPY_AND_ASSIGN(CallbackHelper);
1525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)};
1535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(AndroidHistoryProviderServiceTest, TestHistoryAndBookmark) {
1555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  HistoryAndBookmarkRow row;
1565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  row.set_raw_url("http://www.google.com");
1575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  row.set_url(GURL("http://www.google.com"));
1585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  scoped_refptr<CallbackHelper> callback(new CallbackHelper());
1605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Insert a row and verify it succeeded.
1625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->InsertHistoryAndBookmark(row, &cancelable_consumer_,
1635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnInserted, callback.get()));
1645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
16590dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
1665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
1675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  std::vector<HistoryAndBookmarkRow::ColumnID> projections;
1695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  projections.push_back(HistoryAndBookmarkRow::ID);
1705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Query the inserted row.
1725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->QueryHistoryAndBookmarks(projections, std::string(),
1735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      std::vector<string16>(), std::string(), &cancelable_consumer_,
1745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnQueryResult, callback.get()));
17590dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
1765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  ASSERT_TRUE(callback->success());
1775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Move the cursor to the begining and verify whether we could get
1795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // the same result.
1805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidStatement* statement = callback->statement();
1815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->MoveStatement(statement, 0, -1, &cancelable_consumer_,
1825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnStatementMoved, callback.get()));
18390dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
1845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(-1, callback->cursor_position());
1855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->statement()->statement()->Step());
1865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_FALSE(callback->statement()->statement()->Step());
1875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->CloseStatement(statement);
1885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Update the row.
1905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  HistoryAndBookmarkRow update_row;
1915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  update_row.set_visit_count(3);
1925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->UpdateHistoryAndBookmarks(update_row, std::string(),
1935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      std::vector<string16>(), &cancelable_consumer_,
1945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnUpdated, callback.get()));
19590dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
1965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
1975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(1, callback->count());
1985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Delete the row.
2005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->DeleteHistoryAndBookmarks(std::string(), std::vector<string16>(),
2015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      &cancelable_consumer_, Bind(&CallbackHelper::OnDeleted, callback.get()));
20290dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
2045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(1, callback->count());
2055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)}
2065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(AndroidHistoryProviderServiceTest, TestSearchTerm) {
2085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  SearchRow search_row;
2095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  search_row.set_search_term(UTF8ToUTF16("google"));
2105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  search_row.set_url(GURL("http://google.com"));
2115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  search_row.set_template_url_id(1);
2125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  search_row.set_search_time(Time::Now());
2135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  scoped_refptr<CallbackHelper> callback(new CallbackHelper());
2155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Insert a row and verify it succeeded.
2175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->InsertSearchTerm(search_row, &cancelable_consumer_,
2185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnInserted, callback.get()));
2195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
22090dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
2225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  std::vector<SearchRow::ColumnID> projections;
2245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  projections.push_back(SearchRow::ID);
2255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Query the inserted row.
2275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->QuerySearchTerms(projections, std::string(),
2285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      std::vector<string16>(), std::string(), &cancelable_consumer_,
2295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnQueryResult, callback.get()));
23090dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  ASSERT_TRUE(callback->success());
2325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Move the cursor to the begining and verify whether we could get
2345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // the same result.
2355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidStatement* statement = callback->statement();
2365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->MoveStatement(statement, 0, -1, &cancelable_consumer_,
2375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnStatementMoved, callback.get()));
23890dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(-1, callback->cursor_position());
2405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->statement()->statement()->Step());
2415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_FALSE(callback->statement()->statement()->Step());
2425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->CloseStatement(statement);
2435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Update the row.
2455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  SearchRow update_row;
2465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  update_row.set_search_time(Time::Now());
2475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->UpdateSearchTerms(update_row, std::string(),
2485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      std::vector<string16>(), &cancelable_consumer_,
2495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnUpdated, callback.get()));
25090dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
2525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(1, callback->count());
2535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Delete the row.
2555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->DeleteSearchTerms(std::string(), std::vector<string16>(),
2565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      &cancelable_consumer_, Bind(&CallbackHelper::OnDeleted, callback.get()));
25790dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
2595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(1, callback->count());
2605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)}
2615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)}  // namespace
263