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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
|
/*
** Zabbix
** Copyright (C) 2000,2001,2002,2003 Alexei Vladishev
**
** 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_DB_H
#define ZABBIX_DB_H
/* time_t */
#include <time.h>
#include "config.h"
#include "common.h"
#ifdef HAVE_MYSQL
#include "mysql.h"
#endif
#ifdef HAVE_PGSQL
#include "libpq-fe.h"
#endif
#define DB_ITEM struct item_type
#define DB_TRIGGER struct trigger_type
#define DB_ACTION struct action_type
#define DB_ALERT struct alert_type
#define DB_FUNCTION struct function_type
#define DB_MEDIA struct media_type
#ifdef HAVE_MYSQL
#define DB_RESULT MYSQL_RES
#define DBfree_result mysql_free_result
#endif
#ifdef HAVE_PGSQL
#define DB_RESULT PGresult
#define DBfree_result PQclear
#endif
DB_ITEM
{
int itemid;
int hostid;
int type;
char *description;
char *key;
char *host;
int useip;
char *ip;
char *shortname;
char *snmp_community;
char *snmp_oid;
int snmp_port;
char *trapper_hosts;
int port;
int delay;
int history;
double lastvalue;
char *lastvalue_str;
int lastvalue_null;
double prevvalue;
char *prevvalue_str;
int prevvalue_null;
time_t lastdelete;
time_t lastcheck;
time_t nextcheck;
int value_type;
};
DB_FUNCTION
{
int functionid;
int itemid;
int triggerid;
double lastvalue;
int lastvalue_null;
char *function;
/* int parameter;*/
char *parameter;
};
DB_MEDIA
{
int mediaid;
char *type;
char *sendto;
int active;
};
DB_TRIGGER
{
int triggerid;
char *expression;
char *description;
int status;
int value;
int priority;
};
DB_ACTION
{
int actionid;
int triggerid;
int userid;
int scope;
int severity;
int good;
int delay;
int lastcheck;
char subject[MAX_STRING_LEN+1];
char message[MAX_STRING_LEN+1];
};
DB_ALERT
{
int alertid;
int actionid;
int clock;
char *type;
char *sendto;
char *subject;
char *message;
int status;
int retries;
};
void DBconnect(char *dbhost, char *dbname, char *dbuser, char *dbpassword, char *dbsocket);
void DBclose(void);
void DBvacuum(void);
int DBexecute( char *query );
DB_RESULT *DBselect(char *query);
char *DBget_field(DB_RESULT *result, int rownum, int fieldnum);
int DBnum_rows(DB_RESULT *result);
int DBget_function_result(double *result,char *functionid);
void DBupdate_host_status(int hostid,int status,int clock);
int DBupdate_item_status_to_notsupported(int itemid);
int DBadd_history(int itemid, double value);
int DBadd_history_str(int itemid, char *value);
int DBadd_service_alarm(int serviceid,int status,int clock);
int DBadd_alert(int actionid, char *type, char *sendto, char *subject, char *message);
void DBupdate_triggers_status_after_restart(void);
int DBget_prev_trigger_value(int triggerid);
int DBupdate_trigger_value(int triggerid,int value,int clock);
int DBget_items_count(void);
int DBget_history_count(void);
#endif
|
