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.

Macros
#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.

Macro Definition Documentation

SQL_CONF_FILE

#define SQL_CONF_FILE   "/etc/my.cnf"

Definition at line 22 of file mysql_tool.h.

Referenced by sql_open().

SQL_DEFAULT_TIMEOUT

#define SQL_DEFAULT_TIMEOUT   10

Definition at line 23 of file mysql_tool.h.

Referenced by sql_open().

Function Documentation

sql_close()

void sql_close

(

MYSQL *

mysql

)

Definition at line 50 of file mysql_tool.c.

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

sql_open()

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

Definition at line 14 of file mysql_tool.c.

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

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

Here is the call graph for this function: