49 #define MIN(x, y) ((x) < (y) ? (x) : (y))
50 #define MAX(x, y) ((x) > (y) ? (x) : (y))
166 status =
DbString(row, field_index, &buffer);
171 if (buffer != NULL) {
228 status =
DbString(row, field_index, &buffer);
233 if (buffer != NULL) {
303 status =
DbInt(row, 0, value);
361 status =
DbString(row, field_index, &data);
401 return mysql_errno((MYSQL*) handle);
424 return mysql_error((MYSQL*) handle);
460 *
id = (
DB_ID) mysql_insert_id((MYSQL*) handle);
498 unsigned long length = 0;
504 length = mysql_real_escape_string((MYSQL*) handle, buffer, in, (
unsigned long) strlen(in));
506 return ( length <= buflen ) ? 0 : 1;
537 int DbDateDiff(
const char* start,
int delta,
int sign,
char* buffer,
size_t buflen)
546 nchar = snprintf(buffer, buflen,
547 "DATE_ADD('%s', INTERVAL %d SECOND)", start, delta);
549 else if (sign == -1) {
550 nchar = snprintf(buffer, buflen,
551 "DATE_ADD('%s', INTERVAL -%d SECOND)", start, delta);
557 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)