diff options
Diffstat (limited to 'clib/src/db.c')
-rw-r--r-- | clib/src/db.c | 407 |
1 files changed, 0 insertions, 407 deletions
diff --git a/clib/src/db.c b/clib/src/db.c deleted file mode 100644 index 0f3c930..0000000 --- a/clib/src/db.c +++ /dev/null @@ -1,407 +0,0 @@ -/* IBM_PROLOG_BEGIN_TAG */ -/* This is an automatically generated prolog. */ -/* */ -/* $Source: clib/src/db.c $ */ -/* */ -/* OpenPOWER FFS Project */ -/* */ -/* Contributors Listed Below - COPYRIGHT 2014,2015 */ -/* [+] International Business Machines Corp. */ -/* */ -/* */ -/* Licensed under the Apache License, Version 2.0 (the "License"); */ -/* you may not use this file except in compliance with the License. */ -/* You may obtain a copy of the License at */ -/* */ -/* http://www.apache.org/licenses/LICENSE-2.0 */ -/* */ -/* Unless required by applicable law or agreed to in writing, software */ -/* distributed under the License is distributed on an "AS IS" BASIS, */ -/* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or */ -/* implied. See the License for the specific language governing */ -/* permissions and limitations under the License. */ -/* */ -/* IBM_PROLOG_END_TAG */ - -/* - * File: db.c - * Author: Shaun Wetzstein <shaun@us.ibm.com> - * Descr: SQlite wrapper - * Note: - * Date: 02/25/11 - */ - -#include <stdio.h> -#include <unistd.h> -#include <stdarg.h> -#include <stdlib.h> -#include <malloc.h> -#include <sqlite3.h> -#include <stdint.h> -#include <string.h> -#include <errno.h> -#include <limits.h> - -#include "assert.h" -#include "err.h" - -#include "db.h" - -/* =======================================================================*/ - -int db_init(db_t * self, const char *path) -{ - assert(self != NULL); - - self->path = strdup(path); - if (self->path == NULL) { - ERRNO(errno); - return -1; - } - - self->db = NULL; - - return 0; -} - -int db_delete(db_t * self) -{ - if (self != NULL) { - db_close(self); - if (self->path != NULL) - free((char *)self->path); - memset(self, 0, sizeof(*self)); - } - - return 0; -} - -int db_execute(db_t * self, const char *fmt, ...) -{ - assert(self != NULL); - - va_list ap; - va_start(ap, fmt); - char *sql = NULL; - vasprintf(&sql, fmt, ap); - - assert(sql != NULL); - - int rc = sqlite3_exec(self->db, sql, NULL, NULL, NULL); - if (sql != NULL) - free(sql); - - if (rc != DB_OK) { - DBERR(self->db); - return -1; - } - - return 0; -} - -int db_open(db_t * self, int flags) -{ - assert(self != NULL); - - int rc = DB_OK; - - if (self->db != NULL) - db_close(self); - - rc = sqlite3_open_v2(self->path, &self->db, flags, NULL); - if (rc != DB_OK) { - DBERR(self->db); - return -1; - } - - return rc; -} - -int db_close(db_t * self) -{ - assert(self != NULL); - - int rc = DB_OK; - - if (self->db != NULL) { - /* finalize statements */ - rc = sqlite3_close(self->db); - } - - return rc; -} - -int db_register_function(db_t * self, const char *name, int argc, db_f func, - void *data) -{ - assert(self != NULL); - - int rc = DB_OK; - - rc = sqlite3_create_function(self->db, name, argc, SQLITE_ANY, data, - func, NULL, NULL); - if (rc != 0) { - DBERR(self->db); - return -1; - } - - return rc; -} - -int db_begin(db_t * self, transaction_type_t type) -{ - assert(self != NULL); - - const char *tran_type = NULL; - - switch (type) { - case tt_DEFERRED: - tran_type = "DEFERRED"; - break; - case tt_IMMEDIATE: - tran_type = "IMMEDIATE"; - break; - case tt_EXCLUSIVE: - tran_type = "EXCLUSIVE"; - break; - default: - UNEXPECTED("'%d' invalid transaction type", type); - return -1; - } - - return db_execute(self, "BEGIN %s TRANSACTION", tran_type); -} - -int db_commit(db_t * self) -{ - assert(self != NULL); - return db_execute(self, "COMMIT TRANSACTION"); -} - -int db_rollback(db_t * self) -{ - assert(self != NULL); - return db_execute(self, "ROLLBACK TRANSACTION"); -} - -/* =======================================================================*/ - -int statement_init(statement_t * self, db_t * db) -{ - assert(self != NULL); - assert(db != NULL); - - self->db = db; - self->stmt = NULL; - - return 0; -} - -int statement_delete(statement_t * self) -{ - assert(self != NULL); - - if (self->stmt != NULL) { - statement_finalize(self); - self->stmt = NULL; - } - - self->db = NULL; - free(self); - - return 0; -} - -int statement_prepare(statement_t * self, const char *sql) -{ - assert(self != NULL); - assert(sql != NULL); - - int rc = DB_OK; - - if (self->stmt != NULL) { - rc = sqlite3_finalize(self->stmt); - if (rc != DB_OK) { - SQLERR(self->db->db, self->stmt); - return -1; - } - } - - rc = sqlite3_prepare_v2(self->db->db, sql, -1, &self->stmt, NULL); - if (rc != DB_OK) { - SQLERR(self->db->db, self->stmt); - return -1; - } - - return rc; -} - -int statement_step(statement_t * self) -{ - assert(self != NULL); - - int rc = DB_OK; - - if (self->stmt != NULL) { - rc = sqlite3_step(self->stmt); - - switch (rc) { - case DB_DONE: - case DB_ROW: - break; - default: - SQLERR(self->db->db, self->stmt); - return -1; - } - } - - return rc; -} - -int statement_reset(statement_t * self) -{ - self = NULL; - return 0; -} - -int statement_finalize(statement_t * self) -{ - assert(self != NULL); - - int rc = DB_OK; - - if (self->stmt != NULL) { - rc = sqlite3_finalize(self->stmt); - if (rc != DB_OK) { - SQLERR(self->db->db, self->stmt); - return -1; - } - self->stmt = NULL; - } - - return rc; -} - -int statement_bind_int(statement_t * self, int pos, int val) -{ - assert(self != NULL); - - int rc = DB_OK; - - if (self->stmt != NULL) { - rc = sqlite3_bind_int(self->stmt, pos, val); - if (rc != DB_OK) { - SQLERR(self->db->db, self->stmt); - return -1; - } - } - - return rc; -} - -int statement_bind_int64(statement_t * self, int pos, int64_t val) -{ - assert(self != NULL); - - int rc = DB_OK; - - if (self->stmt != NULL) { - rc = sqlite3_bind_int64(self->stmt, pos, val); - if (rc != DB_OK) { - SQLERR(self->db->db, self->stmt); - return -1; - } - } - - return rc; -} - -int statement_bind_text(statement_t * self, int pos, const char *val) -{ - assert(self != NULL); - - int rc = DB_OK; - - if (self->stmt != NULL) { - rc = sqlite3_bind_text(self->stmt, pos, val, -1, - SQLITE_TRANSIENT); - if (rc != DB_OK) { - SQLERR(self->db->db, self->stmt); - return -1; - } - } - - return rc; -} - -int statement_bind_blob(statement_t * self, int pos, const void *val, int size) -{ - assert(self != NULL); - - int rc = DB_OK; - - if (self->stmt != NULL) { - rc = sqlite3_bind_blob(self->stmt, pos, val, size, - SQLITE_TRANSIENT); - if (rc != DB_OK) { - SQLERR(self->db->db, self->stmt); - return -1; - } - } - - return rc; -} - -int statement_column_int(statement_t * self, int pos) -{ - assert(self != NULL); - return sqlite3_column_int(self->stmt, pos); -} - -int64_t statement_column_int64(statement_t * self, int pos) -{ - assert(self != NULL); - return sqlite3_column_int64(self->stmt, pos); -} - -int statement_column_bytes(statement_t * self, int pos) -{ - assert(self != NULL); - return sqlite3_column_bytes(self->stmt, pos); -} - -const unsigned char *statement_column_text(statement_t * self, int pos) -{ - assert(self != NULL); - - const unsigned char *rc = NULL; - - if (self->stmt != NULL) { - rc = sqlite3_column_text(self->stmt, pos); - if (rc == NULL) { - SQLERR(self->db->db, self->stmt); - return NULL; - } - } - - return rc; -} - -const void *statement_column_blob(statement_t * self, int pos) -{ - assert(self != NULL); - - const void *rc = NULL; - - if (self->stmt != NULL) { - rc = sqlite3_column_blob(self->stmt, pos); - if (rc == NULL) { - SQLERR(self->db->db, self->stmt); - return NULL; - } - } - - return rc; -} - -/* =======================================================================*/ |