xLib/mysql_tool.h File Reference

MySQL用ライブラリ ヘッダ. More...

#include "xtools.h"
#include <mysql/mysql.h>

Include dependency graph for mysql_tool.h:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Defines
#define	SQL_CONF_FILE   "/etc/my.cnf"
#define	SQL_DEFAULT_TIMEOUT   10
Functions
MYSQL *	sql_open (char *hostname, char *dbname, char *username, char *passwd, unsigned int tmot)
void	sql_close (MYSQL *mysql)

---

Detailed Description

Author:

Fumi.Iseki (C)

コンパイルオプション

--I/usr/local/mysql/include -L/usr/local/mysql/lib/mysql -lmysqlclient

Definition in file mysql_tool.h.

---

Define Documentation

#define SQL_CONF_FILE   "/etc/my.cnf"

Definition at line 25 of file mysql_tool.h.

Referenced by sql_open().

#define SQL_DEFAULT_TIMEOUT   10

Definition at line 26 of file mysql_tool.h.

Referenced by sql_open().

---

Function Documentation

void sql_close

(

MYSQL *

mysql

)

Definition at line 50 of file mysql_tool.c.

{
    if (mysql!=NULL) mysql_close(mysql);

    return;
}

MYSQL* sql_open	(	char *	hostname,
		char *	dbname,
		char *	username,
		char *	passwd,
		unsigned int	tmot
	)

Definition at line 14 of file mysql_tool.c.

References Buffer::buf, decomp_hostport(), file_exist(), free_Buffer(), make_Buffer_bystr, SQL_CONF_FILE, and SQL_DEFAULT_TIMEOUT.

{
    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;
}

Here is the call graph for this function: