summaryrefslogtreecommitdiff
path: root/src/backends/sqlite.c
diff options
context:
space:
mode:
authorVicent Marti <tanoku@gmail.com>2011-06-12 11:40:14 +0200
committerVicent Marti <tanoku@gmail.com>2011-06-14 17:40:17 +0200
commitb0233216691fc52c6886a7f53c650d56a651cc84 (patch)
treee7424326ef33a43904419f42683ba95e02443d1d /src/backends/sqlite.c
parent0f49a589013d0f5c75cccf75ee2dd6cc99ce3d91 (diff)
downloadlibgit2-b0233216691fc52c6886a7f53c650d56a651cc84.tar.gz
Remove custom backends
All the custom backend code will be moved to a separate project, together with the new MySQL backend.
Diffstat (limited to 'src/backends/sqlite.c')
-rw-r--r--src/backends/sqlite.c296
1 files changed, 0 insertions, 296 deletions
diff --git a/src/backends/sqlite.c b/src/backends/sqlite.c
deleted file mode 100644
index 8626349ec..000000000
--- a/src/backends/sqlite.c
+++ /dev/null
@@ -1,296 +0,0 @@
-/*
- * This file is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License, version 2,
- * as published by the Free Software Foundation.
- *
- * In addition to the permissions in the GNU General Public License,
- * the authors give you unlimited permission to link the compiled
- * version of this file into combinations with other programs,
- * and to distribute those combinations without any restriction
- * coming from the use of this file. (The General Public License
- * restrictions do apply in other respects; for example, they cover
- * modification of the file, and distribution when not linked into
- * a combined executable.)
- *
- * This file is distributed in the hope that it will be useful, but
- * WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- * General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with this program; see the file COPYING. If not, write to
- * the Free Software Foundation, 51 Franklin Street, Fifth Floor,
- * Boston, MA 02110-1301, USA.
- */
-
-#include "common.h"
-#include "git2/object.h"
-#include "hash.h"
-#include "odb.h"
-
-#include "git2/odb_backend.h"
-
-#ifdef GIT2_SQLITE_BACKEND
-
-#include <sqlite3.h>
-
-#define GIT2_TABLE_NAME "git2_odb"
-
-typedef struct {
- git_odb_backend parent;
- sqlite3 *db;
- sqlite3_stmt *st_read;
- sqlite3_stmt *st_write;
- sqlite3_stmt *st_read_header;
-} sqlite_backend;
-
-int sqlite_backend__read_header(size_t *len_p, git_otype *type_p, git_odb_backend *_backend, const git_oid *oid)
-{
- sqlite_backend *backend;
- int error;
-
- assert(len_p && type_p && _backend && oid);
-
- backend = (sqlite_backend *)_backend;
- error = GIT_ERROR;
-
- if (sqlite3_bind_text(backend->st_read_header, 1, (char *)oid->id, 20, SQLITE_TRANSIENT) == SQLITE_OK) {
- if (sqlite3_step(backend->st_read_header) == SQLITE_ROW) {
- *type_p = (git_otype)sqlite3_column_int(backend->st_read_header, 0);
- *len_p = (size_t)sqlite3_column_int(backend->st_read_header, 1);
- assert(sqlite3_step(backend->st_read_header) == SQLITE_DONE);
- error = GIT_SUCCESS;
- } else {
- error = GIT_ENOTFOUND;
- }
- }
-
- sqlite3_reset(backend->st_read_header);
- return error == GIT_SUCCESS ? GIT_SUCCESS : git__rethrow(error, "SQLite backend: Failed to read header");
-}
-
-
-int sqlite_backend__read(void **data_p, size_t *len_p, git_otype *type_p, git_odb_backend *_backend, const git_oid *oid)
-{
- sqlite_backend *backend;
- int error;
-
- assert(data_p && len_p && type_p && _backend && oid);
-
- backend = (sqlite_backend *)_backend;
- error = GIT_ERROR;
-
- if (sqlite3_bind_text(backend->st_read, 1, (char *)oid->id, 20, SQLITE_TRANSIENT) == SQLITE_OK) {
- if (sqlite3_step(backend->st_read) == SQLITE_ROW) {
- *type_p = (git_otype)sqlite3_column_int(backend->st_read, 0);
- *len_p = (size_t)sqlite3_column_int(backend->st_read, 1);
- *data_p = git__malloc(*len_p);
-
- if (*data_p == NULL) {
- error = GIT_ENOMEM;
- } else {
- memcpy(*data_p, sqlite3_column_blob(backend->st_read, 2), *len_p);
- error = GIT_SUCCESS;
- }
-
- assert(sqlite3_step(backend->st_read) == SQLITE_DONE);
- } else {
- error = GIT_ENOTFOUND;
- }
- }
-
- sqlite3_reset(backend->st_read);
- return error == GIT_SUCCESS ? GIT_SUCCESS : git__rethrow(error, "SQLite backend: Failed to read");
-}
-
-int sqlite_backend__read_prefix(git_oid *out_oid, void **data_p, size_t *len_p, git_otype *type_p, git_odb_backend *_backend,
- const git_oid *short_oid, unsigned int len) {
- if (len >= GIT_OID_HEXSZ) {
- /* Just match the full identifier */
- int error = sqlite_backend__read(data_p, len_p, type_p, _backend, short_oid);
- if (error == GIT_SUCCESS)
- git_oid_cpy(out_oid, short_oid);
-
- return error;
- } else if (len < GIT_OID_HEXSZ) {
- /* TODO */
- return git__throw(GIT_ENOTIMPLEMENTED, "Sqlite backend cannot search objects from short oid");
- }
-}
-
-int sqlite_backend__exists(git_odb_backend *_backend, const git_oid *oid)
-{
- sqlite_backend *backend;
- int found;
-
- assert(_backend && oid);
-
- backend = (sqlite_backend *)_backend;
- found = 0;
-
- if (sqlite3_bind_text(backend->st_read_header, 1, (char *)oid->id, 20, SQLITE_TRANSIENT) == SQLITE_OK) {
- if (sqlite3_step(backend->st_read_header) == SQLITE_ROW) {
- found = 1;
- assert(sqlite3_step(backend->st_read_header) == SQLITE_DONE);
- }
- }
-
- sqlite3_reset(backend->st_read_header);
- return found;
-}
-
-
-int sqlite_backend__write(git_oid *id, git_odb_backend *_backend, const void *data, size_t len, git_otype type)
-{
- int error;
- sqlite_backend *backend;
-
- assert(id && _backend && data);
-
- backend = (sqlite_backend *)_backend;
-
- if ((error = git_odb_hash(id, data, len, type)) < 0)
- return git__rethrow(error, "SQLite backend: Failed to write");
-
- error = SQLITE_ERROR;
-
- if (sqlite3_bind_text(backend->st_write, 1, (char *)id->id, 20, SQLITE_TRANSIENT) == SQLITE_OK &&
- sqlite3_bind_int(backend->st_write, 2, (int)type) == SQLITE_OK &&
- sqlite3_bind_int(backend->st_write, 3, len) == SQLITE_OK &&
- sqlite3_bind_blob(backend->st_write, 4, data, len, SQLITE_TRANSIENT) == SQLITE_OK) {
- error = sqlite3_step(backend->st_write);
- }
-
- sqlite3_reset(backend->st_write);
- return (error == SQLITE_DONE) ? GIT_SUCCESS : git__throw(GIT_ERROR, "SQLite backend: Failed to write");
-}
-
-
-void sqlite_backend__free(git_odb_backend *_backend)
-{
- sqlite_backend *backend;
- assert(_backend);
- backend = (sqlite_backend *)_backend;
-
- sqlite3_finalize(backend->st_read);
- sqlite3_finalize(backend->st_read_header);
- sqlite3_finalize(backend->st_write);
- sqlite3_close(backend->db);
-
- free(backend);
-}
-
-static int create_table(sqlite3 *db)
-{
- static const char *sql_creat =
- "CREATE TABLE '" GIT2_TABLE_NAME "' ("
- "'oid' CHARACTER(20) PRIMARY KEY NOT NULL,"
- "'type' INTEGER NOT NULL,"
- "'size' INTEGER NOT NULL,"
- "'data' BLOB);";
-
- if (sqlite3_exec(db, sql_creat, NULL, NULL, NULL) != SQLITE_OK)
- return git__throw(GIT_ERROR, "SQLite backend: Failed to create table");
-
- return GIT_SUCCESS;
-}
-
-static int init_db(sqlite3 *db)
-{
- static const char *sql_check =
- "SELECT name FROM sqlite_master WHERE type='table' AND name='" GIT2_TABLE_NAME "';";
-
- sqlite3_stmt *st_check;
- int error;
-
- if (sqlite3_prepare_v2(db, sql_check, -1, &st_check, NULL) != SQLITE_OK)
- return git__throw(GIT_ERROR, "SQLite backend: Failed to initialize database");
-
- switch (sqlite3_step(st_check)) {
- case SQLITE_DONE:
- /* the table was not found */
- error = create_table(db);
- break;
-
- case SQLITE_ROW:
- /* the table was found */
- error = GIT_SUCCESS;
- break;
-
- default:
- error = GIT_ERROR;
- break;
- }
-
- sqlite3_finalize(st_check);
- return error == GIT_SUCCESS ? GIT_SUCCESS : git__rethrow(error, "SQLite backend: Failed to initialize database");
-}
-
-static int init_statements(sqlite_backend *backend)
-{
- static const char *sql_read =
- "SELECT type, size, data FROM '" GIT2_TABLE_NAME "' WHERE oid = ?;";
-
- static const char *sql_read_header =
- "SELECT type, size FROM '" GIT2_TABLE_NAME "' WHERE oid = ?;";
-
- static const char *sql_write =
- "INSERT OR IGNORE INTO '" GIT2_TABLE_NAME "' VALUES (?, ?, ?, ?);";
-
- if (sqlite3_prepare_v2(backend->db, sql_read, -1, &backend->st_read, NULL) != SQLITE_OK)
- return git__throw(GIT_ERROR, "SQLite backend: Failed to initialize statements");
-
- if (sqlite3_prepare_v2(backend->db, sql_read_header, -1, &backend->st_read_header, NULL) != SQLITE_OK)
- return git__throw(GIT_ERROR, "SQLite backend: Failed to initialize statements");
-
- if (sqlite3_prepare_v2(backend->db, sql_write, -1, &backend->st_write, NULL) != SQLITE_OK)
- return git__throw(GIT_ERROR, "SQLite backend: Failed to initialize statements");
-
- return GIT_SUCCESS;
-}
-
-int git_odb_backend_sqlite(git_odb_backend **backend_out, const char *sqlite_db)
-{
- sqlite_backend *backend;
- int error;
-
- backend = git__calloc(1, sizeof(sqlite_backend));
- if (backend == NULL)
- return GIT_ENOMEM;
-
- if (sqlite3_open(sqlite_db, &backend->db) != SQLITE_OK)
- goto cleanup;
-
- error = init_db(backend->db);
- if (error < 0)
- goto cleanup;
-
- error = init_statements(backend);
- if (error < 0)
- goto cleanup;
-
- backend->parent.read = &sqlite_backend__read;
- backend->parent.read_prefix = &sqlite_backend__read_prefix;
- backend->parent.read_header = &sqlite_backend__read_header;
- backend->parent.write = &sqlite_backend__write;
- backend->parent.exists = &sqlite_backend__exists;
- backend->parent.free = &sqlite_backend__free;
-
- *backend_out = (git_odb_backend *)backend;
- return GIT_SUCCESS;
-
-cleanup:
- sqlite_backend__free((git_odb_backend *)backend);
- return git__throw(GIT_ERROR, "SQLite backend: Failed to get ODB backend");
-}
-
-#else
-
-int git_odb_backend_sqlite(git_odb_backend **GIT_UNUSED(backend_out), const char *GIT_UNUSED(sqlite_db))
-{
- GIT_UNUSED_ARG(backend_out);
- GIT_UNUSED_ARG(sqlite_db);
- return git__throw(GIT_ENOTIMPLEMENTED, "SQLite backend: Failed to get ODB backend. Operation not yet implemented");
-}
-
-#endif /* HAVE_SQLITE3 */