diff options
Diffstat (limited to 'src/components/utils/src/sqlite_wrapper/sql_database.cc')
-rw-r--r-- | src/components/utils/src/sqlite_wrapper/sql_database.cc | 122 |
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 |