[sql] Test helpers to ease testing of simple queries.

sql/test/test_helpers.cc

 // Copyright 2013 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.
 
 #include "sql/test/test_helpers.h"
 
 #include <stddef.h>
 #include <stdint.h>
 
 #include <memory>
@@ skipping 252 matching lines @@
 
 std::string IntegrityCheck(sql::Connection* db) {
   sql::Statement statement(db->GetUniqueStatement("PRAGMA integrity_check"));
 
   // SQLite should always return a row of data.
   EXPECT_TRUE(statement.Step());
 
   return statement.ColumnString(0);
 }
 
+std::string ExecuteWithResult(sql::Connection* db, const char* sql) {
+  sql::Statement s(db->GetUniqueStatement(sql));
+  return s.Step() ? s.ColumnString(0) : std::string();
+}
+
+std::string ExecuteWithResults(sql::Connection* db,
+                               const char* sql,
+                               const char* column_sep,
+                               const char* row_sep) {
+  sql::Statement s(db->GetUniqueStatement(sql));
+  std::string ret;
+  while (s.Step()) {
+    if (!ret.empty())
+      ret += row_sep;
+    for (int i = 0; i < s.ColumnCount(); ++i) {
+      if (i > 0)
+        ret += column_sep;
+      ret += s.ColumnString(i);
+    }
+  }
+  return ret;
+}
+
 }  // namespace test
 }  // namespace sql