1 files changed, 161 insertions, 0 deletions
diff --git a/src/components/utils/src/sqlite_wrapper/sql_query.cc b/src/components/utils/src/sqlite_wrapper/sql_query.cc
new file mode 100644
index 0000000000..5a62ec360d
--- /dev/null
+++ b/src/components/utils/src/sqlite_wrapper/sql_query.cc
@@ -0,0 +1,161 @@
+/*
+ * Copyright (c) 2013, Ford Motor Company
+ * All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice, this
+ * list of conditions and the following disclaimer.
+ *
+ * Redistributions in binary form must reproduce the above copyright notice,
+ * this list of conditions and the following
+ * disclaimer in the documentation and/or other materials provided with the
+ * distribution.
+ *
+ * Neither the name of the Ford Motor Company nor the names of its contributors
+ * may be used to endorse or promote products derived from this software
+ * without specific prior written permission.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
+ * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
+ * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
+ * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
+ * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
+ * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
+ * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
+ * POSSIBILITY OF SUCH DAMAGE.
+ */
+
+#include "sqlite_wrapper/sql_query.h"
+#include <sqlite3.h>
+#include <cassert>
+#include "sqlite_wrapper/sql_database.h"
+
+namespace utils {
+namespace dbms {
+
+SQLQuery::SQLQuery(SQLDatabase* db)
+    : db_(*db), query_(""), statement_(NULL), error_(SQLITE_OK) {}
+
+SQLQuery::~SQLQuery() {
+  Finalize();
+}
+
+bool SQLQuery::Prepare(const std::string& query) {
+  Finalize();
+  sync_primitives::AutoLock auto_lock(statement_lock_);
+  if (statement_)
+    return false;
+  error_ = sqlite3_prepare(
+      db_.conn(), query.c_str(), query.length(), &statement_, NULL);
+  query_ = query;
+  return error_ == SQLITE_OK;
+}
+
+bool SQLQuery::Exec() {
+  error_ = sqlite3_step(statement_);
+  return error_ == SQLITE_ROW || error_ == SQLITE_DONE;
+}
+
+bool SQLQuery::Next() {
+  error_ = sqlite3_step(statement_);
+  return error_ == SQLITE_ROW;
+}
+
+bool SQLQuery::Reset() {
+  error_ = sqlite3_reset(statement_);
+  return error_ == SQLITE_OK;
+}
+
+void SQLQuery::Finalize() {
+  sync_primitives::AutoLock auto_lock(statement_lock_);
+  error_ = sqlite3_finalize(statement_);
+  if (error_ == SQLITE_OK) {
+    statement_ = NULL;
+  }
+}
+
+bool SQLQuery::Exec(const std::string& query) {
+  query_ = query;
+  error_ = sqlite3_exec(db_.conn(), query.c_str(), NULL, NULL, NULL);
+  return error_ == SQLITE_OK;
+}
+
+void SQLQuery::Bind(int pos, int value) {
+  // In SQLite the number of position for binding starts since 1.
+  error_ = sqlite3_bind_int(statement_, pos + 1, value);
+}
+
+void SQLQuery::Bind(int pos, int64_t value) {
+  // In SQLite the number of position for binding starts since 1.
+  error_ = sqlite3_bind_int64(statement_, pos + 1, value);
+}
+
+void SQLQuery::Bind(int pos, double value) {
+  // In SQLite the number of position for binding starts since 1.
+  error_ = sqlite3_bind_double(statement_, pos + 1, value);
+}
+
+void SQLQuery::Bind(int pos, bool value) {
+  Bind(pos, static_cast<int>(value));
+}
+
+void SQLQuery::Bind(int pos, const std::string& value) {
+  // In SQLite the number of position for binding starts since 1.
+  error_ = sqlite3_bind_text(
+      statement_, pos + 1, value.c_str(), value.length(), SQLITE_TRANSIENT);
+}
+
+bool SQLQuery::GetBoolean(int pos) const {
+  return static_cast<bool>(GetInteger(pos));
+}
+
+int SQLQuery::GetInteger(int pos) const {
+  return sqlite3_column_int(statement_, pos);
+}
+
+uint32_t SQLQuery::GetUInteger(int pos) const {
+  return static_cast<uint32_t>(sqlite3_column_int64(statement_, pos));
+}
+
+int64_t SQLQuery::GetLongInt(int pos) const {
+  return static_cast<int64_t>(sqlite3_column_int64(statement_, pos));
+}
+
+double SQLQuery::GetDouble(int pos) const {
+  return sqlite3_column_double(statement_, pos);
+}
+
+std::string SQLQuery::GetString(int pos) const {
+  const unsigned char* str = sqlite3_column_text(statement_, pos);
+  return str ? reinterpret_cast<const char*>(str) : "";
+}
+
+const std::string& SQLQuery::query() const {
+  // TODO(KKolodiy): may return string query with value of arguments
+  return query_;
+}
+
+bool SQLQuery::IsNull(int pos) const {
+  return sqlite3_column_type(statement_, pos) == SQLITE_NULL;
+}
+
+void SQLQuery::Bind(int pos) {
+  // In SQLite the number of position for binding starts since 1.
+  error_ = sqlite3_bind_null(statement_, pos + 1);
+}
+
+SQLError SQLQuery::LastError() const {
+  return SQLError(Error(error_));
+}
+
+int64_t SQLQuery::LastInsertId() const {
+  return sqlite3_last_insert_rowid(db_.conn());
+}
+
+}  // namespace dbms
+}  // namespace utils