49 #define MIN(x, y) ((x) < (y) ? (x) : (y))
50 #define MAX(x, y) ((x) > (y) ? (x) : (y))
167 status =
DbString(row, field_index, &buffer);
172 if (buffer != NULL) {
230 status =
DbString(row, field_index, &buffer);
235 if (buffer != NULL) {
298 if (status == SQLITE_OK) {
305 status =
DbInt(row, 0, value);
365 status =
DbString(row, field_index, &data);
405 return sqlite3_errcode((sqlite3*) handle);
428 return sqlite3_errmsg((sqlite3*) handle);
466 *
id = (
DB_ID) sqlite3_last_insert_rowid((sqlite3*) handle);
510 sqlite3_snprintf(buflen, buffer,
"%q", in);
512 return ( strlen(buffer) == 0 ) ? 1 : 0;
543 int DbDateDiff(
const char* start,
int delta,
int sign,
char* buffer,
size_t buflen)
552 nchar = snprintf(buffer, buflen,
553 "DATETIME('%s', '+%d SECONDS')", start, delta);
555 else if (sign == -1) {
556 nchar = snprintf(buffer, buflen,
557 "DATETIME('%s', '-%d SECONDS')", start, delta);
563 if (nchar >= (
int)buflen || nchar < 0) {
void DbFreeResult(DB_RESULT result)
int DbFetchRow(DB_RESULT result, DB_ROW *row)
int MsgLog(int status,...)
int DbString(DB_ROW row, int field_index, char **result)
int DbQuoteString(DB_HANDLE handle, const char *in, char *buffer, size_t buflen)
void StrStrncpy(char *dest, const char *src, size_t destlen)
int DbLastRowId(DB_HANDLE handle, DB_ID *id)
const char * DbErrmsg(DB_HANDLE handle)
int DbErrno(DB_HANDLE handle)
void DbFreeRow(DB_ROW row)
int DbExecuteSql(DB_HANDLE handle, const char *stmt_str, DB_RESULT *result)
int DbStringBuffer(DB_ROW row, int field_index, char *buffer, size_t buflen)
int StrStrtoi(const char *string, int *value)
int DbIntQuery(DB_HANDLE handle, int *value, const char *query)
int DbDateDiff(const char *start, int delta, int sign, char *buffer, size_t buflen)
int DbUnsignedLong(DB_ROW row, int field_index, unsigned long *value)
int DbRowId(DB_ROW row, DB_ID *id)
int DbInt(DB_ROW row, int field_index, int *value)
int StrStrtoul(const char *string, unsigned long *value)
int DbExecuteSqlNoResult(DB_HANDLE handle, const char *stmt_str)
void DbStringFree(char *string)