root/trunk/src/mysql_mgmt.h

/*
 * File: mysql_mgmt.h
 * 
 * Authors: ANDREU Francois-Xavier 
 *
 * Copyright (C) 2005 - 2010 GIP RENATER 
 */

/*  This file is part of renetcol. 
 *
 *  renetcol 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.
 *
 *  renetcol 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 renetcol; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 */
#ifndef MYSQL_MGMT_H
#define MYSQL_MGMT_H

#include <mysql/mysql.h>
#include <stdio.h>
#include <stdlib.h>
#include <time.h>
#include <stdlib.h>

#define DB_HOST "0.0.0.0"
#define DB_USER "admin"
#define DB_NAME "collector_control"

#define REQ_OUTPUT_TYPE "SELECT * FROM output_type"
#define REQ_OUTPUT_TABLE "SELECT IDO, TYPE_ID, VALUE from output"
#define REQ_FIELDS_TO_RECORD "SELECT IDR, V9_FIELDS from fields_to_record"
#define REQ_FILTRES_TABLE "SELECT ID, IDR, IDO, BEGIN, END, Tests from filtres where STATUS='0'"

char *get_dbpass();
MYSQL *init_connection();
void close_connection(MYSQL *);
void get_info_bd(MYSQL *);
p_rules get_rules(MYSQL *, p_rules);
void get_fields_to_record(MYSQL *, unsigned short);
void get_output(MYSQL *, unsigned short, p_rules);

#endif /* MYSQL_MGMT_H */