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