mysql_tool.c

Go to the documentation of this file.

 
#include "mysql_tool.h"
 
 
MYSQL*  sql_open(char* hostname, char* dbname, char* username, char* passwd, unsigned int tmot)
{
    MYSQL* mysql;
    MYSQL* cnnct;
 
    Buffer host;
    unsigned short port;
 
    if (hostname==NULL || dbname==NULL || username==NULL || passwd==NULL) return NULL;
 
    Buffer wrk = make_Buffer_bystr(hostname);
    decomp_hostport(wrk, &host, &port);
    free_Buffer(&wrk);
    if (host.buf==NULL) return NULL;
 
    if (tmot==0) tmot = SQL_DEFAULT_TIMEOUT;
 
    mysql = mysql_init(NULL);
    if (mysql==NULL) return NULL;
 
    if (file_exist(SQL_CONF_FILE)) {
        mysql_options(mysql, MYSQL_READ_DEFAULT_FILE, SQL_CONF_FILE);
    }
    mysql_options(mysql, MYSQL_OPT_CONNECT_TIMEOUT, (char*)&tmot);
 
    cnnct = mysql_real_connect(mysql, (char*)host.buf, username, passwd, dbname, (int)port, NULL, 0);
    if (cnnct==NULL) {
        mysql_close(mysql);
        mysql = NULL;
        return NULL;
    }
 
    return mysql;
}
 
 
void  sql_close(MYSQL* mysql)
{
    if (mysql!=NULL) mysql_close(mysql);
 
    return;
}