51 #define MIN(x, y) ((x) < (y) ? (x) : (y))
52 #define MAX(x, y) ((x) > (y) ? (x) : (y))
168 status =
DbString(row, field_index, &buffer);
173 if (buffer != NULL) {
230 status =
DbString(row, field_index, &buffer);
235 if (buffer != NULL) {
305 status =
DbInt(row, 0, value);
363 status =
DbString(row, field_index, &data);
403 return mysql_errno((MYSQL*) handle);
426 return mysql_error((MYSQL*) handle);
462 *
id = (
DB_ID) mysql_insert_id((MYSQL*) handle);
500 unsigned long length = 0;
506 length = mysql_real_escape_string((MYSQL*) handle, buffer, in, (
unsigned long) strlen(in));
508 return ( length <= buflen ) ? 0 : 1;
539 int DbDateDiff(
const char* start,
int delta,
int sign,
char* buffer,
size_t buflen)
548 nchar = snprintf(buffer, buflen,
549 "DATE_ADD('%s', INTERVAL %d SECOND)", start, delta);
551 else if (sign == -1) {
552 nchar = snprintf(buffer, buflen,
553 "DATE_ADD('%s', INTERVAL -%d SECOND)", start, delta);
559 if (nchar >= (
int) buflen || nchar < 0) {
void DbFreeResult(DB_RESULT result)
int DbUnsignedLong(DB_ROW row, int field_index, unsigned long *value)
int DbFetchRow(DB_RESULT result, DB_ROW *row)
int DbQuoteString(DB_HANDLE handle, const char *in, char *buffer, size_t buflen)
int DbInt(DB_ROW row, int field_index, int *value)
int DbRowId(DB_ROW row, DB_ID *id)
int MsgLog(int status,...)
int DbDateDiff(const char *start, int delta, int sign, char *buffer, size_t buflen)
int DbString(DB_ROW row, int field_index, char **result)
void StrStrncpy(char *dest, const char *src, size_t destlen)
void DbFreeRow(DB_ROW row)
int DbIntQuery(DB_HANDLE handle, int *value, const char *query)
int DbExecuteSql(DB_HANDLE handle, const char *stmt_str, DB_RESULT *result)
int StrStrtoi(const char *string, int *value)
int DbLastRowId(DB_HANDLE handle, DB_ID *id)
int DbStringBuffer(DB_ROW row, int field_index, char *buffer, size_t buflen)
int DbErrno(DB_HANDLE handle)
int DbExecuteSqlNoResult(DB_HANDLE handle, const char *stmt_str)
int StrStrtoul(const char *string, unsigned long *value)
const char * DbErrmsg(DB_HANDLE handle)
void DbStringFree(char *string)