CMySQL.h

Go to the documentation of this file.

#ifndef __CMySQL_H__
#define __CMySQL_H__

#define DEBUG       // comment this out if you do not want normal debugging display.

#include <mysql.h>
#include "loc_types.h"

#define RestrictCopy(StrDst,StrSrc) strncpy(StrDst,(StrSrc==NULL?"NULL":StrSrc),sizeof(StrDst)-1)
#define CopyStrValue(dst,sep,src) sprintf(dst,(strcmp(src,"NULL")==0?"%s"sep:"'%s'"sep),src)

struct SFieldInfo
{
    const char *name_of_field;  
    const char *name_of_type;       
    BOOL bNullAllowed;      
    const char *DefaultValue;       
    BOOL bAutoIncrement;    
    BOOL bPrimary;          
    BOOL bIndexKey;         
    BOOL bIndex;            
    BOOL bUnique;           
};

struct STableInfo
{
    char table_name[81];        
    struct SFieldInfo *fields;  
};

class CMySQL
{
    MYSQL mysql;        
    MYSQL_RES *res;     

    BOOL bConnected;    
    BOOL bInitialized;  
public:
    CMySQL();
    ~CMySQL();

    const char *GetClientInfo();

    BOOL Connect(const char *host=NULL,const char *user=NULL,const char *passwd=NULL,const char *db=NULL,uint port=0,const char *usock=NULL,uint clflag=0);
    BOOL Close(BOOL bInit);
    BOOL Init();
    BOOL SelectDB(const char *db);
    const char *Stat();

    BOOL Query(char *str);
    BOOL RealQuery(char *str,uint len);

    BOOL CreateDatabase(const char *db);
    BOOL DropDatabase(const char *db);
    int  GetAffectedRows();

    MYSQL_RES *StoreResult();
    MYSQL_RES *UseResult();
    MYSQL_ROW FetchRow(MYSQL_RES *res);

    void FreeResult(MYSQL_RES *res);
    int  NumRows(MYSQL_RES *res);
    int  NumFields(MYSQL_RES *res);

    void DataSeek(MYSQL_RES *result,ulong offset);
    void DataSeek(ulong offset) { DataSeek(res,offset); };

    const char *GetError() { return mysql_error(&mysql); };
    uint GetErrno() { return mysql_errno(&mysql); };

    BOOL CreateTable(const char *name,struct SFieldInfo **sinfo);
    BOOL CreateTable(struct STableInfo *table) { return CreateTable(table->table_name,&table->fields); };

    MYSQL_RES *ListTables(const char *wild=NULL);

    BOOL TableExists(const char *name);
    BOOL TableExists(struct STableInfo *table) { return TableExists(table->table_name); };

    BOOL DropTable(const char *name,BOOL bCascade=FALSE,BOOL bRestrict=FALSE);
    BOOL DropTable(struct STableInfo *table,BOOL bCascade=FALSE,BOOL bRestrict=FALSE) 
                { return DropTable(table->table_name,bCascade,bRestrict); };
                
    BOOL InsertRow(const char *name,struct SFieldInfo **sinfo,const char *Values);
    BOOL InsertRow(struct STableInfo *table,const char *Values,int ValSize) 
                { return InsertRow(table->table_name,&table->fields,Values); };
                
    long GetTotalCount(struct STableInfo *table);
};

#endif  /* __CMySQL_H__ */