dbutils/dbutils/db.h

/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 *
 * Copyright 2024 Olaf Wintermann. All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 *   1. Redistributions of source code must retain the above copyright
 *      notice, this list of conditions and the following disclaimer.
 *
 *   2. 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.
 *
 * 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.
 */

#ifndef LIBDBU_DB_H
#define LIBDBU_DB_H

#include "dbutils.h"

#ifdef __cplusplus
extern "C" {
#endif

typedef struct DBUConnection DBUConnection;
typedef struct DBUQuery      DBUQuery;
typedef struct DBUResult     DBUResult;    

typedef enum DBUFieldType DBUFieldType;

enum DBUFieldType {
    DBU_FIELD_NULL = 0,
    DBU_FIELD_TEXT,
    DBU_FIELD_INT,
    DBU_FIELD_DOUBLE,
    DBU_FIELD_BINARY
};

typedef struct DBUBytes {
    const unsigned char *bytes;
    size_t length;
} DBUBytes;
    
struct DBUConnection {
    DBUQuery* (*createQuery)(DBUConnection *connection, const CxAllocator *a);
    int (*isActive)(DBUConnection *connection);
    void (*free)(DBUConnection *connection);
    void *data;
};

struct DBUQuery {
    int (*setSQL)(DBUQuery *q, const char *sql);
    int (*setParamString)(DBUQuery *q, int index, cxstring str);
    int (*setParamInt)(DBUQuery *q, int index, int i);
    int (*setParamInt64)(DBUQuery *q, int index, int64_t i);
    int (*setParamDouble)(DBUQuery *q, int index, double d);
    int (*setParamNull)(DBUQuery *q, int index);
    int (*setParamBytes)(DBUQuery *q, int index, void *bytes, int len);
    int (*exec)(DBUQuery *q);
    DBUResult* (*getResult)(DBUQuery *q);
    void (*free)(DBUQuery *q);
    DBUConnection *connection;
    const CxAllocator *allocator;
};

struct DBUResult {
    int (*optional_numRows)(DBUResult *result);
    int (*numFields)(DBUResult *result);
    int (*hasData)(DBUResult *result);
    int (*isOk)(DBUResult *result);
    int (*nextRow)(DBUResult *result);
    const char* (*fieldName)(DBUResult *result, int field);
    DBUFieldType (*fieldType)(DBUResult *result, int field);
    int (*isNull)(DBUResult *result, int field);
    cxstring (*getText)(DBUResult *result, int field);
    int64_t (*optional_getInt)(DBUResult *result, int field);
    double (*optional_getDouble)(DBUResult *result, int field);
    DBUBytes (*optional_getBinary)(DBUResult *result, int field);
    void (*free)(DBUResult *result);
    const CxAllocator *allocator;
    int rowIndex;
};


int dbuQuerySetSQL(DBUQuery *q, const char *sql);
int dbuQuerySetParamString(DBUQuery *q, int index, cxstring str);
int dbuQuerySetParamInt(DBUQuery *q, int index, int i);
int dbuQuerySetParamInt64(DBUQuery *q, int index, int64_t i);
int dbuQuerySetParamDouble(DBUQuery *q, int index, double d);
int dbuQuerySetParamNull(DBUQuery *q, int index);
int dbuQuerySetParamBytes(DBUQuery *q, int index, void *bytes, int len);
int dbuQueryExec(DBUQuery *q);
DBUResult* dbuQueryGetResult(DBUQuery *q);
void dbuQueryFree(DBUQuery *q);


CxList* dbuQuerySingleType(DBUContext *ctx, DBUQuery *query, const char *type);

#ifdef __cplusplus
}
#endif

#endif /* LIBDBU_DB_H */