android_history_provider_service_unittest.cc revision cedac228d2dd51db4b79ea1e72c7f249408ee061
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"
9010d83a9304c5a91596085d917d248abff47903aTorne (Richard Coles)#include "chrome/browser/bookmarks/bookmark_model_factory.h"
105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/browser/history/android/android_history_types.h"
115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/common/chrome_constants.h"
125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/test/base/testing_browser_process.h"
135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "chrome/test/base/testing_profile.h"
14868fa2fe829687343ffae624259930155e16dbd8Torne (Richard Coles)#include "chrome/test/base/testing_profile_manager.h"
15cedac228d2dd51db4b79ea1e72c7f249408ee061Torne (Richard Coles)#include "components/bookmarks/test/bookmark_test_helpers.h"
165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "content/public/browser/browser_thread.h"
175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "content/public/test/test_browser_thread.h"
185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)#include "testing/gtest/include/gtest/gtest.h"
195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)namespace {
215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using base::Bind;
235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using base::Time;
245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using content::BrowserThread;
255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using history::AndroidStatement;
265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using history::HistoryAndBookmarkRow;
275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)using history::SearchRow;
285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// The test cases in this file don't intent to test the detail features of
305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// Android content provider which have been covered by
315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// android_provider_backend_unittest.cc, instead, they verify the code path to
325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)// AndroidProviderBackend working fine.
335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)class AndroidHistoryProviderServiceTest : public testing::Test {
355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) public:
365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidHistoryProviderServiceTest()
375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      : profile_manager_(
382a99a7e74a7f215066514fe81d2bfa6639d9edddTorne (Richard Coles)          TestingBrowserProcess::GetGlobal()),
395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        ui_thread_(BrowserThread::UI, &message_loop_),
405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        file_thread_(BrowserThread::FILE, &message_loop_) {
415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  virtual ~AndroidHistoryProviderServiceTest() {
435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) protected:
465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  virtual void SetUp() OVERRIDE {
475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // Setup the testing profile, so the bookmark_model_sql_handler could
485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // get the bookmark model from it.
495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    ASSERT_TRUE(profile_manager_.SetUp());
505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // It seems that the name has to be chrome::kInitialProfile, so it
515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    // could be found by ProfileManager::GetLastUsedProfile().
525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    testing_profile_ = profile_manager_.CreateTestingProfile(
535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        chrome::kInitialProfile);
545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    testing_profile_->CreateBookmarkModel(true);
56010d83a9304c5a91596085d917d248abff47903aTorne (Richard Coles)    test::WaitForBookmarkModelToLoad(
57010d83a9304c5a91596085d917d248abff47903aTorne (Richard Coles)        BookmarkModelFactory::GetForProfile(testing_profile_));
58bbcdd45c55eb7c4641ab97aef9889b0fc828e7d3Ben Murdoch    ASSERT_TRUE(testing_profile_->CreateHistoryService(true, false));
595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    service_.reset(new AndroidHistoryProviderService(testing_profile_));
605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  virtual void TearDown() OVERRIDE {
635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    testing_profile_->DestroyHistoryService();
645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    profile_manager_.DeleteTestingProfile(chrome::kInitialProfile);
655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    testing_profile_=NULL;
665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
675821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) protected:
695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  TestingProfileManager profile_manager_;
7090dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop message_loop_;
715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  content::TestBrowserThread ui_thread_;
725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  content::TestBrowserThread file_thread_;
735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  scoped_ptr<AndroidHistoryProviderService> service_;
745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  CancelableRequestConsumer cancelable_consumer_;
755821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  TestingProfile* testing_profile_;
765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
775821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) private:
785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  DISALLOW_COPY_AND_ASSIGN(AndroidHistoryProviderServiceTest);
795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)};
805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)class CallbackHelper : public base::RefCountedThreadSafe<CallbackHelper> {
825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) public:
835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  CallbackHelper()
845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      : success_(false),
855821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        statement_(NULL),
865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        cursor_position_(0),
875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)        count_(0) {
885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  bool success() const {
915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    return success_;
925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidStatement* statement() const {
955821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    return statement_;
965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
975821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int cursor_position() const {
995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    return cursor_position_;
1005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1025821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int count() const {
1035821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    return count_;
1045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1055821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnInserted(AndroidHistoryProviderService::Handle handle,
1075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                  bool success,
1085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                  int64 id) {
1095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    success_ = success;
11090dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1125821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnQueryResult(AndroidHistoryProviderService::Handle handle,
1145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                     bool success,
1155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                     AndroidStatement* statement) {
1165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    success_ = success;
1175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    statement_ = statement;
11890dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnUpdated(AndroidHistoryProviderService::Handle handle,
1225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                 bool success,
1235821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                 int count) {
1245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    success_ = success;
1255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    count_ = count;
12690dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnDeleted(AndroidHistoryProviderService::Handle handle,
1305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                 bool success,
1315821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                 int count) {
1325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    success_ = success;
1335821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    count_ = count;
13490dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  void OnStatementMoved(AndroidHistoryProviderService::Handle handle,
1385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)                        int cursor_position) {
1395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)    cursor_position_ = cursor_position;
14090dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)    base::MessageLoop::current()->Quit();
1415821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles) private:
1445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  friend class base::RefCountedThreadSafe<CallbackHelper>;
1455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  ~CallbackHelper() {
1465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  }
1475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  bool success_;
1495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidStatement* statement_;
1505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int cursor_position_;
1515821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  int count_;
1525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1535821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  DISALLOW_COPY_AND_ASSIGN(CallbackHelper);
1545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)};
1555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(AndroidHistoryProviderServiceTest, TestHistoryAndBookmark) {
1575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  HistoryAndBookmarkRow row;
1585821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  row.set_raw_url("http://www.google.com");
1595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  row.set_url(GURL("http://www.google.com"));
1605821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  scoped_refptr<CallbackHelper> callback(new CallbackHelper());
1625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Insert a row and verify it succeeded.
1645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->InsertHistoryAndBookmark(row, &cancelable_consumer_,
1655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnInserted, callback.get()));
1665821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
16790dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
1685821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
1695821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1705821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  std::vector<HistoryAndBookmarkRow::ColumnID> projections;
1715821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  projections.push_back(HistoryAndBookmarkRow::ID);
1725821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1735821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Query the inserted row.
1745821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->QueryHistoryAndBookmarks(projections, std::string(),
1755d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)      std::vector<base::string16>(), std::string(), &cancelable_consumer_,
1765821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnQueryResult, callback.get()));
17790dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
1785821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  ASSERT_TRUE(callback->success());
1795821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1805821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Move the cursor to the begining and verify whether we could get
1815821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // the same result.
1825821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidStatement* statement = callback->statement();
1835821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->MoveStatement(statement, 0, -1, &cancelable_consumer_,
1845821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnStatementMoved, callback.get()));
18590dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
1865821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(-1, callback->cursor_position());
1875821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->statement()->statement()->Step());
1885821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_FALSE(callback->statement()->statement()->Step());
1895821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->CloseStatement(statement);
1905821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
1915821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Update the row.
1925821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  HistoryAndBookmarkRow update_row;
1935821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  update_row.set_visit_count(3);
1945821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->UpdateHistoryAndBookmarks(update_row, std::string(),
1955d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)      std::vector<base::string16>(), &cancelable_consumer_,
1965821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnUpdated, callback.get()));
19790dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
1985821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
1995821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(1, callback->count());
2005821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2015821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Delete the row.
2025d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)  service_->DeleteHistoryAndBookmarks(std::string(),
2035d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)      std::vector<base::string16>(),
2045821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      &cancelable_consumer_, Bind(&CallbackHelper::OnDeleted, callback.get()));
20590dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2065821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
2075821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(1, callback->count());
2085821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)}
2095821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2105821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)TEST_F(AndroidHistoryProviderServiceTest, TestSearchTerm) {
2115821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  SearchRow search_row;
2125d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)  search_row.set_search_term(base::UTF8ToUTF16("google"));
2135821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  search_row.set_url(GURL("http://google.com"));
2145821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  search_row.set_template_url_id(1);
2155821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  search_row.set_search_time(Time::Now());
2165821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2175821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  scoped_refptr<CallbackHelper> callback(new CallbackHelper());
2185821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2195821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Insert a row and verify it succeeded.
2205821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->InsertSearchTerm(search_row, &cancelable_consumer_,
2215821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnInserted, callback.get()));
2225821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
22390dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2245821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
2255821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2265821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  std::vector<SearchRow::ColumnID> projections;
2275821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  projections.push_back(SearchRow::ID);
2285821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2295821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Query the inserted row.
2305821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->QuerySearchTerms(projections, std::string(),
2315d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)      std::vector<base::string16>(), std::string(), &cancelable_consumer_,
2325821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnQueryResult, callback.get()));
23390dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2345821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  ASSERT_TRUE(callback->success());
2355821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2365821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Move the cursor to the begining and verify whether we could get
2375821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // the same result.
2385821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  AndroidStatement* statement = callback->statement();
2395821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->MoveStatement(statement, 0, -1, &cancelable_consumer_,
2405821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnStatementMoved, callback.get()));
24190dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2425821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(-1, callback->cursor_position());
2435821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->statement()->statement()->Step());
2445821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_FALSE(callback->statement()->statement()->Step());
2455821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->CloseStatement(statement);
2465821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2475821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Update the row.
2485821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  SearchRow update_row;
2495821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  update_row.set_search_time(Time::Now());
2505821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  service_->UpdateSearchTerms(update_row, std::string(),
2515d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)      std::vector<base::string16>(), &cancelable_consumer_,
2525821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      Bind(&CallbackHelper::OnUpdated, callback.get()));
25390dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2545821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
2555821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(1, callback->count());
2565821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2575821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  // Delete the row.
2585d1f7b1de12d16ceb2c938c56701a3e8bfa558f7Torne (Richard Coles)  service_->DeleteSearchTerms(std::string(), std::vector<base::string16>(),
2595821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)      &cancelable_consumer_, Bind(&CallbackHelper::OnDeleted, callback.get()));
26090dce4d38c5ff5333bea97d859d4e484e27edf0cTorne (Richard Coles)  base::MessageLoop::current()->Run();
2615821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_TRUE(callback->success());
2625821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)  EXPECT_EQ(1, callback->count());
2635821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)}
2645821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)
2655821806d5e7f356e8fa4b058a389a808ea183019Torne (Richard Coles)}  // namespace
266