1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
/*
** ZABBIX
** Copyright (C) 2000-2005 SIA Zabbix
**
** This program 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.
**
** This program 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., 675 Mass Ave, Cambridge, MA 02139, USA.
**/
#ifndef ZABBIX_ZBXDB_H
#define ZABBIX_ZBXDB_H
#include "config.h"
#include "common.h"
#define ZBX_DB_OK 0
#define ZBX_DB_FAIL 1
#define ZBX_DB_DOWN 2
#ifdef HAVE_MYSQL
# include "mysql.h"
# include "errmsg.h"
# include "mysqld_error.h"
# define DB_HANDLE MYSQL
#endif /* HAVE_MYSQL */
#ifdef HAVE_ORACLE
# include "sqlora.h"
#endif /* HAVE_ORACLE */
#ifdef HAVE_POSTGRESQL
# include <libpq-fe.h>
#endif /* HAVE_POSTGRESQL */
#ifdef HAVE_SQLITE3
# include <sqlite3.h>
#endif /* HAVE_SQLITE3 */
#ifdef HAVE_SQLITE3
/* We have to put double % here for sprintf */
# define ZBX_SQL_MOD(x,y) #x "%%" #y
#else
# define ZBX_SQL_MOD(x,y) "mod(" #x "," #y ")"
#endif
#ifdef HAVE_SQLITE3
#include "mutexs.h"
#define DB_ROW char **
#define DB_RESULT ZBX_SQ_DB_RESULT*
#define DBfree_result SQ_DBfree_result
typedef struct zbx_sq_db_result_s
{
int curow;
char **data;
int nrow;
int ncolumn;
DB_ROW values;
} ZBX_SQ_DB_RESULT;
void SQ_DBfree_result(DB_RESULT result);
extern PHP_MUTEX sqlite_access;
#endif
#ifdef HAVE_MYSQL
#define DB_RESULT MYSQL_RES *
#define DBfree_result mysql_free_result
#define DB_ROW MYSQL_ROW
#endif
#ifdef HAVE_POSTGRESQL
#define DB_ROW char **
#define DB_RESULT ZBX_PG_DB_RESULT*
#define DBfree_result PG_DBfree_result
typedef struct zbx_pg_db_result_s
{
PGresult *pg_result;
int row_num;
int fld_num;
int cursor;
DB_ROW values;
} ZBX_PG_DB_RESULT;
void PG_DBfree_result(DB_RESULT result);
#endif
#ifdef HAVE_ORACLE
#define DB_RESULT sqlo_stmt_handle_t
#define DBfree_result sqlo_close
#define DB_ROW char **
#endif
int zbx_db_connect(char *host, char *user, char *password, char *dbname, char *dbsocket, int port);
void zbx_db_close(void);
void zbx_db_vacuum(void);
int zbx_db_vexecute(const char *fmt, va_list args);
DB_RESULT zbx_db_vselect(const char *fmt, va_list args);
DB_RESULT zbx_db_select_n(char *query, int n);
DB_ROW zbx_db_fetch(DB_RESULT result);
zbx_uint64_t zbx_db_insert_id(int exec_result, const char *table, const char *field);
int zbx_db_is_null(char *field);
void zbx_db_begin();
void zbx_db_commit();
void zbx_db_rollback();
#endif
|