1ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen// Copyright (c) 2011 The Chromium Authors. All rights reserved. 2ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen// Use of this source code is governed by a BSD-style license that can be 3ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen// found in the LICENSE file. 4ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 5ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen#include <vector> 6ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 7ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen#include "app/sql/connection.h" 8ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen#include "base/format_macros.h" 9ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen#include "base/string_util.h" 10ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen#include "chrome/browser/history/history_unittest_base.h" 11ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 12ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsennamespace history { 13ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 14ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian MonsenHistoryUnitTestBase::~HistoryUnitTestBase() { 15ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen} 16ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 17ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsenvoid HistoryUnitTestBase::ExecuteSQLScript(const FilePath& sql_path, 18ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen const FilePath& db_path) { 19ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen std::string sql; 20ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen ASSERT_TRUE(file_util::ReadFileToString(sql_path, &sql)); 21ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 22ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen // Replace the 'last_visit_time', 'visit_time', 'time_slot' values in this 23ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen // SQL with the current time. 24ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen int64 now = base::Time::Now().ToInternalValue(); 25ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen std::vector<std::string> sql_time; 26ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen sql_time.push_back(StringPrintf("%" PRId64, now)); // last_visit_time 27ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen sql_time.push_back(StringPrintf("%" PRId64, now)); // visit_time 28ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen sql_time.push_back(StringPrintf("%" PRId64, now)); // time_slot 29ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen sql = ReplaceStringPlaceholders(sql, sql_time, NULL); 30ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 31ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen sql::Connection connection; 32ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen ASSERT_TRUE(connection.Open(db_path)); 33ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen ASSERT_TRUE(connection.Execute(sql.c_str())); 34ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen} 35ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 36ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian MonsenHistoryUnitTestBase::HistoryUnitTestBase() { 37ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen} 38ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen 39ddb351dbec246cf1fab5ec20d2d5520909041de1Kristian Monsen} // namespace history 40