Initial commit of sync engine code to browser/sync....

chrome/browser/sync/util/query_helpers.h

+// Copyright (c) 2009 The Chromium Authors. All rights reserved.
+// Use of this source code is governed by a BSD-style license that can be
+// found in the LICENSE file.
+//
+// Typesafe composition of SQL query strings.
+
+#ifndef CHROME_BROWSER_SYNC_UTIL_QUERY_HELPERS_H_
+#define CHROME_BROWSER_SYNC_UTIL_QUERY_HELPERS_H_
+
+#include <limits>
+#include <string>
+#include <vector>
+
+#include "base/basictypes.h"
+#include "base/logging.h"
+#include "chrome/browser/sync/util/sync_types.h"
+#include "third_party/sqlite/preprocessed/sqlite3.h"
+
+// Sometimes threads contend on the DB lock itself, especially when one thread
+// is calling SaveChanges.  In the worst case scenario, the user can put his
+// laptop to sleep during db contention, and wake up the laptop days later, so
+// infinity seems like the best choice here.
+const int kDirectoryBackingStoreBusyTimeoutMs = std::numeric_limits<int>::max();
+
+enum SqliteNullType {
+  SQLITE_NULL_VALUE
+};
+
+int SqliteOpen(PathString filename, sqlite3** ppDb);
+
+sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query);
+#if !PATHSTRING_IS_STD_STRING
+sqlite3_stmt* BindArg(sqlite3_stmt*, const PathString&, int index);
+sqlite3_stmt* BindArg(sqlite3_stmt*, const PathChar*, int index);
+#endif
+sqlite3_stmt* BindArg(sqlite3_stmt*, const std::string&, int index);
+sqlite3_stmt* BindArg(sqlite3_stmt*, const char*, int index);
+sqlite3_stmt* BindArg(sqlite3_stmt*, int32, int index);
+sqlite3_stmt* BindArg(sqlite3_stmt*, int64, int index);
+sqlite3_stmt* BindArg(sqlite3_stmt*, double, int index);
+sqlite3_stmt* BindArg(sqlite3_stmt*, bool, int index);
+sqlite3_stmt* BindArg(sqlite3_stmt*, const std::vector<uint8>&, int index);
+sqlite3_stmt* BindArg(sqlite3_stmt*, SqliteNullType, int index);
+
+#if !PATHSTRING_IS_STD_STRING
+void GetColumn(sqlite3_stmt*, int index, PathString* value);
+#endif
+void GetColumn(sqlite3_stmt*, int index, std::string* value);
+void GetColumn(sqlite3_stmt*, int index, int32* value);
+void GetColumn(sqlite3_stmt*, int index, int64* value);
+void GetColumn(sqlite3_stmt*, int index, double* value);
+void GetColumn(sqlite3_stmt*, int index, bool* value);
+void GetColumn(sqlite3_stmt*, int index, std::vector<uint8>* value);
+
+bool DoesTableExist(sqlite3* dbhandle, const std::string& tablename);
+
+// Prepares a query with a WHERE clause that filters the values by the items
+// passed inside of the Vector.
+// Example:
+//
+// vector<PathString> v;
+// v.push_back("abc");
+// v.push_back("123");
+// PrepareQuery(dbhandle, "SELECT * FROM table", "column_name", v.begin(),
+//              v.end(), "ORDER BY id");
+//
+// will produce the following query.
+//
+// SELECT * FROM table WHERE column_name = 'abc' OR column_name = '123' ORDER BY
+// id.
+//
+template<typename ItemIterator>
+sqlite3_stmt* PrepareQueryWhereColumnIn(sqlite3* dbhandle,
+                                        const std::string& query_head,
+                                        const std::string& filtername,
+                                        ItemIterator begin, ItemIterator end,
+                                        const std::string& query_options) {
+  std::string query;
+  query.reserve(512);
+  query += query_head;
+  const char* joiner = " WHERE ";
+  for (ItemIterator it = begin; it != end; ++it) {
+    query += joiner;
+    query += filtername;
+    query += " = ?";
+    joiner = " OR ";
+  }
+  query += " ";
+  query += query_options;
+  sqlite3_stmt* statement = NULL;
+  const char* query_tail;
+  if (SQLITE_OK != sqlite3_prepare(dbhandle, query.data(),
+                                   CountBytes(query), &statement,
+                                   &query_tail)) {
+    LOG(ERROR) << query << "\n" << sqlite3_errmsg(dbhandle);
+  }
+  int index = 1;
+  for (ItemIterator it = begin; it != end; ++it) {
+    BindArg(statement, *it, index);
+    ++index;
+  }
+  return statement;
+}
+
+template <typename Type1>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1) {
+  return BindArg(PrepareQuery(dbhandle, query), arg1, 1);
+}
+
+template <typename Type1, typename Type2>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1), arg2, 2);
+}
+
+template <typename Type1, typename Type2, typename Type3>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2), arg3, 3);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3), arg4, 4);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4),
+                 arg5, 5);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5),
+                 arg6, 6);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6),
+                 arg7, 7);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7),
+                 arg8, 8);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8),
+                 arg9, 9);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9, const Type10& arg10) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8, arg9),
+                 arg10, 10);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9, const Type10& arg10,
+                                  const Type11& arg11) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8, arg9, arg10),
+                 arg11, 11);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9, const Type10& arg10,
+                                  const Type11& arg11, const Type12& arg12) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8, arg9, arg10, arg11),
+                 arg12, 12);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9, const Type10& arg10,
+                                  const Type11& arg11, const Type12& arg12,
+                                  const Type13& arg13) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8, arg9, arg10, arg11, arg12),
+                 arg13, 13);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13, typename Type14>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9, const Type10& arg10,
+                                  const Type11& arg11, const Type12& arg12,
+                                  const Type13& arg13, const Type14& arg14) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8, arg9, arg10, arg11, arg12,
+                              arg13),
+                 arg14, 14);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13, typename Type14, typename Type15>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9, const Type10& arg10,
+                                  const Type11& arg11, const Type12& arg12,
+                                  const Type13& arg13, const Type14& arg14,
+                                  const Type15& arg15) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8, arg9, arg10, arg11, arg12,
+                              arg13, arg14),
+                 arg15, 15);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13, typename Type14, typename Type15, typename Type16>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9, const Type10& arg10,
+                                  const Type11& arg11, const Type12& arg12,
+                                  const Type13& arg13, const Type14& arg14,
+                                  const Type15& arg15, const Type16& arg16) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8, arg9, arg10, arg11, arg12,
+                              arg13, arg14, arg15),
+                 arg16, 16);
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13, typename Type14, typename Type15, typename Type16,
+          typename Type17>
+inline sqlite3_stmt* PrepareQuery(sqlite3* dbhandle, const char* query,
+                                  const Type1& arg1, const Type2& arg2,
+                                  const Type3& arg3, const Type4& arg4,
+                                  const Type5& arg5, const Type6& arg6,
+                                  const Type7& arg7, const Type8& arg8,
+                                  const Type9& arg9, const Type10& arg10,
+                                  const Type11& arg11, const Type12& arg12,
+                                  const Type13& arg13, const Type14& arg14,
+                                  const Type15& arg15, const Type16& arg16,
+                                  const Type17& arg17) {
+  return BindArg(PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                              arg6, arg7, arg8, arg9, arg10, arg11, arg12,
+                              arg13, arg14, arg15, arg16),
+                 arg17, 17);
+}
+
+void ExecOrDie(sqlite3* dbhandle, const char* query);
+
+// Finalizes (deletes) the query before returning.
+void ExecOrDie(sqlite3* dbhandle, const char* query, sqlite3_stmt* statement);
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2,
+                      const Type3& arg3, const Type4& arg4,
+                      const Type5& arg5, const Type6& arg6,
+                      const Type7& arg7, const Type8& arg8,
+                      const Type9& arg9, const Type10& arg10) {
+  return ExecOrDie(dbhandle, query,
+                   PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                                arg6, arg7, arg8, arg9, arg10));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2,
+                      const Type3& arg3, const Type4& arg4,
+                      const Type5& arg5, const Type6& arg6,
+                      const Type7& arg7, const Type8& arg8,
+                      const Type9& arg9) {
+  return ExecOrDie(dbhandle, query,
+                   PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                                arg6, arg7, arg8, arg9));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2,
+                      const Type3& arg3, const Type4& arg4,
+                      const Type5& arg5, const Type6& arg6,
+                      const Type7& arg7, const Type8& arg8) {
+  return ExecOrDie(dbhandle, query,
+                   PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                                arg6, arg7, arg8));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2,
+                      const Type3& arg3, const Type4& arg4,
+                      const Type5& arg5, const Type6& arg6,
+                      const Type7& arg7) {
+  return ExecOrDie(dbhandle, query,
+                   PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                                arg6, arg7));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2,
+                      const Type3& arg3, const Type4& arg4,
+                      const Type5& arg5, const Type6& arg6) {
+  return ExecOrDie(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2,
+                                                 arg3, arg4, arg5, arg6));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2,
+                      const Type3& arg3, const Type4& arg4,
+                      const Type5& arg5) {
+  return ExecOrDie(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2,
+                                                 arg3, arg4, arg5));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2,
+                      const Type3& arg3, const Type4& arg4) {
+  return ExecOrDie(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2,
+                                                 arg3, arg4));
+}
+
+template <typename Type1, typename Type2, typename Type3>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2,
+                      const Type3& arg3) {
+  return ExecOrDie(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2,
+                                                 arg3));
+}
+
+template <typename Type1, typename Type2>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1, const Type2& arg2) {
+  return ExecOrDie(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2));
+}
+
+template <typename Type1>
+inline void ExecOrDie(sqlite3* dbhandle, const char* query,
+                      const Type1& arg1) {
+  return ExecOrDie(dbhandle, query, PrepareQuery(dbhandle, query, arg1));
+}
+
+
+int Exec(sqlite3* dbhandle, const char* query);
+// Finalizes (deletes) the query before returning.
+int Exec(sqlite3* dbhandle, const char* query, sqlite3_stmt* statement);
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13, typename Type14, typename Type15, typename Type16,
+          typename Type17>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9, const Type10& arg10,
+                const Type11& arg11, const Type12& arg12,
+                const Type13& arg13, const Type14& arg14,
+                const Type15& arg15, const Type16& arg16,
+                const Type17& arg17) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13,
+                           arg14, arg15, arg16, arg17));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13, typename Type14, typename Type15, typename Type16>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9, const Type10& arg10,
+                const Type11& arg11, const Type12& arg12,
+                const Type13& arg13, const Type14& arg14,
+                const Type15& arg15, const Type16& arg16) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13,
+                           arg14, arg15, arg16));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13, typename Type14, typename Type15>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9, const Type10& arg10,
+                const Type11& arg11, const Type12& arg12,
+                const Type13& arg13, const Type14& arg14,
+                const Type15& arg15) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13,
+                           arg14, arg15));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13, typename Type14>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9, const Type10& arg10,
+                const Type11& arg11, const Type12& arg12,
+                const Type13& arg13, const Type14& arg14) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13,
+                           arg14));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12,
+          typename Type13>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9, const Type10& arg10,
+                const Type11& arg11, const Type12& arg12,
+                const Type13& arg13) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11, typename Type12>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9, const Type10& arg10,
+                const Type11& arg11, const Type12& arg12) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9, arg10, arg11, arg12));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10, typename Type11>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9, const Type10& arg10,
+                const Type11& arg11) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9, arg10, arg11));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9, typename Type10>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9, const Type10& arg10) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9, arg10));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8,
+          typename Type9>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8,
+                const Type9& arg9) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8, arg9));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7, typename Type8>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7, const Type8& arg8) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7, arg8));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6, typename Type7>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6,
+                const Type7& arg7) {
+  return Exec(dbhandle, query,
+              PrepareQuery(dbhandle, query, arg1, arg2, arg3, arg4, arg5,
+                           arg6, arg7));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5, typename Type6>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5, const Type6& arg6) {
+  return Exec(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2,
+                                            arg3, arg4, arg5, arg6));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4,
+          typename Type5>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4,
+                const Type5& arg5) {
+  return Exec(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2,
+                                            arg3, arg4, arg5));
+}
+
+template <typename Type1, typename Type2, typename Type3, typename Type4>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3, const Type4& arg4) {
+  return Exec(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2,
+                                            arg3, arg4));
+}
+
+template <typename Type1, typename Type2, typename Type3>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2,
+                const Type3& arg3) {
+  return Exec(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2,
+                                            arg3));
+}
+
+template <typename Type1, typename Type2>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1, const Type2& arg2) {
+  return Exec(dbhandle, query, PrepareQuery(dbhandle, query, arg1, arg2));
+}
+
+template <typename Type1>
+inline int Exec(sqlite3* dbhandle, const char* query,
+                const Type1& arg1) {
+  return Exec(dbhandle, query, PrepareQuery(dbhandle, query, arg1));
+}
+
+
+// Holds an sqlite3_stmt* and automatically finalizes when passes out of scope.
+class ScopedStatement {
+ public:
+  explicit ScopedStatement(sqlite3_stmt* statement = 0)
+      : statement_(statement) { }
+  ~ScopedStatement();
+
+  sqlite3_stmt* get() const { return statement_; }
+
+  // Finalizes currently held statement and sets to new one.
+  void reset(sqlite3_stmt* statement);
+ protected:
+  sqlite3_stmt* statement_;
+
+  DISALLOW_COPY_AND_ASSIGN(ScopedStatement);
+};
+
+
+// Holds an sqlite3_stmt* and automatically resets when passes out of scope.
+class ScopedStatementResetter {
+ public:
+  explicit ScopedStatementResetter(sqlite3_stmt* statement)
+      : statement_(statement) { }
+  ~ScopedStatementResetter();
+
+ protected:
+  sqlite3_stmt* const statement_;
+
+  DISALLOW_COPY_AND_ASSIGN(ScopedStatementResetter);
+};
+
+// Useful for encoding any sequence of bytes into a string that can be used in
+// a table name. Kind of like hex encoding, except that A is zero and P is 15.
+std::string APEncode(const std::string& in);
+std::string APDecode(const std::string& in);
+
+#endif  // CHROME_BROWSER_SYNC_UTIL_QUERY_HELPERS_H_