1 files changed, 122 insertions, 0 deletions
diff --git a/src/components/utils/src/sqlite_wrapper/sql_database.cc b/src/components/utils/src/sqlite_wrapper/sql_database.cc
new file mode 100644
index 0000000000..4763ddc776
--- /dev/null
+++ b/src/components/utils/src/sqlite_wrapper/sql_database.cc
@@ -0,0 +1,122 @@
+/*
+ * 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 "utils/sqlite_wrapper/sql_database.h"
+#include <sqlite3.h>
+
+namespace utils {
+namespace dbms {
+
+namespace {
+const char* kInMemory = ":memory:";
+const char* kExtension = ".sqlite";
+}  // namespace
+
+SQLDatabase::SQLDatabase()
+    : conn_(NULL), database_path_(kInMemory), error_(SQLITE_OK) {}
+
+SQLDatabase::SQLDatabase(const std::string& database_path,
+                         const std::string& connection_name)
+    : conn_(NULL)
+    , database_path_(database_path + kExtension)
+    , connection_name_(connection_name)
+    , error_(SQLITE_OK) {}
+
+SQLDatabase::~SQLDatabase() {
+  Close();
+}
+
+bool SQLDatabase::Open() {
+  sync_primitives::AutoLock auto_lock(conn_lock_);
+  if (conn_)
+    return true;
+  error_ = sqlite3_open(database_path_.c_str(), &conn_);
+  return error_ == SQLITE_OK;
+  return true;
+}
+
+bool SQLDatabase::IsReadWrite() {
+  const char* schema = "main";
+  return sqlite3_db_readonly(conn_, schema) == 0;
+  return true;
+}
+
+void SQLDatabase::Close() {
+  if (!conn_) {
+    return;
+  }
+
+  sync_primitives::AutoLock auto_lock(conn_lock_);
+  error_ = sqlite3_close(conn_);
+  if (error_ == SQLITE_OK) {
+    conn_ = NULL;
+  }
+}
+
+bool SQLDatabase::BeginTransaction() {
+  return Exec("BEGIN TRANSACTION");
+}
+
+bool SQLDatabase::CommitTransaction() {
+  return Exec("COMMIT TRANSACTION");
+}
+
+bool SQLDatabase::RollbackTransaction() {
+  return Exec("ROLLBACK TRANSACTION");
+}
+
+bool SQLDatabase::Exec(const std::string& query) {
+  sync_primitives::AutoLock auto_lock(conn_lock_);
+  error_ = sqlite3_exec(conn_, query.c_str(), NULL, NULL, NULL);
+  return error_ == SQLITE_OK;
+}
+
+SQLError SQLDatabase::LastError() const {
+  return SQLError(Error(error_));
+}
+
+bool SQLDatabase::HasErrors() const {
+  return Error(error_) != OK;
+}
+sqlite3* SQLDatabase::conn() const {
+  return conn_;
+}
+
+std::string SQLDatabase::get_path() const {
+  return database_path_;
+}
+
+bool SQLDatabase::Backup() {
+  return true;
+}
+}  // namespace dbms
+}  // namespace utils