kamailio/modules/db_mysql/km_db_mysql.c

/* 
 * $Id$ 
 *
 * MySQL module interface
 *
 * Copyright (C) 2001-2003 FhG Fokus
 * Copyright (C) 2008 1&1 Internet AG
 *
 * This file is part of openser, a free SIP server.
 *
 * openser is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version
 *
 * openser is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License 
 * along with this program; if not, write to the Free Software 
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
/*
 * History:
 * --------
 *  2003-03-11  updated to the new module exports interface (andrei)
 *  2003-03-16  flags export parameter added (janakj)
 */

#include "../../sr_module.h"
#include "dbase.h"
#include "db_mysql.h"

#include <mysql/mysql.h>

unsigned int db_mysql_ping_interval = 5 * 60; /* Default is 5 minutes */
unsigned int db_mysql_timeout_interval = 2;   /* Default is 6 seconds */
unsigned int db_mysql_auto_reconnect = 1;     /* Default is enabled   */

static int mysql_mod_init(void);

MODULE_VERSION


/*
 * MySQL database module interface
 */
static cmd_export_t cmds[] = {
	{"db_use_table",        (cmd_function)db_mysql_use_table,     2, 0, 0, 0},
	{"db_init",             (cmd_function)db_mysql_init,          1, 0, 0, 0},
	{"db_close",            (cmd_function)db_mysql_close,         2, 0, 0, 0},
	{"db_query",            (cmd_function)db_mysql_query,         2, 0, 0, 0},
	{"db_fetch_result",     (cmd_function)db_mysql_fetch_result,  2, 0, 0, 0},
	{"db_raw_query",        (cmd_function)db_mysql_raw_query,     2, 0, 0, 0},
	{"db_free_result",      (cmd_function)db_mysql_free_result,   2, 0, 0, 0},
	{"db_insert",           (cmd_function)db_mysql_insert,        2, 0, 0, 0},
	{"db_delete",           (cmd_function)db_mysql_delete,        2, 0, 0, 0},
	{"db_update",           (cmd_function)db_mysql_update,        2, 0, 0, 0},
	{"db_replace",          (cmd_function)db_mysql_replace,       2, 0, 0, 0},
	{"db_last_inserted_id", (cmd_function)db_last_inserted_id,    1, 0, 0, 0},
	{"db_insert_update",    (cmd_function)db_insert_update,       2, 0, 0, 0},
	{0, 0, 0, 0, 0, 0}
};


/*
 * Exported parameters
 */
static param_export_t params[] = {
	{"ping_interval",    INT_PARAM, &db_mysql_ping_interval},
	{"timeout_interval", INT_PARAM, &db_mysql_timeout_interval},
	{"auto_reconnect",   INT_PARAM, &db_mysql_auto_reconnect},
	{0, 0, 0}
};


struct module_exports exports = {	
	"db_mysql",
	DEFAULT_DLFLAGS, /* dlopen flags */
	cmds,
	params,          /*  module parameters */
	0,               /* exported statistics */
	0,               /* exported MI functions */
	0,               /* exported pseudo-variables */
	0,               /* extra processes */
	mysql_mod_init,  /* module initialization function */
	0,               /* response function*/
	0,               /* destroy function */
	0                /* per-child init function */
};


static int mysql_mod_init(void)
{
	LM_DBG("mysql: MySQL client version is %s\n", mysql_get_client_info());
	return 0;
}