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
|
<?php
/*
** Zabbix
** Copyright (C) 2001-2017 Zabbix SIA
**
** 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., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
**/
/**
* Abstract database backend class.
*/
abstract class DbBackend {
protected $error;
/**
* Check if 'dbversion' table exists.
*
* @return boolean
*/
abstract protected function checkDbVersionTable();
/**
* Check if connected database version matches with frontend version.
*
* @return bool
*/
public function checkDbVersion() {
if (!$this->checkDbVersionTable()) {
return false;
}
$version = DBfetch(DBselect('SELECT dv.mandatory,dv.optional FROM dbversion dv'));
if ($version['mandatory'] != ZABBIX_DB_VERSION) {
$this->setError(_s('The frontend does not match Zabbix database. Current database version (mandatory/optional): %d/%d. Required mandatory version: %d. Contact your system administrator.',
$version['mandatory'], $version['optional'], ZABBIX_DB_VERSION));
return false;
}
return true;
}
/**
* Check the integrity of the table "config".
*
* @return bool
*/
public function checkConfig() {
if (!DBfetch(DBselect('SELECT NULL FROM config c'))) {
$this->setError(_('Unable to select configuration.'));
return false;
}
return true;
}
/**
* Create INSERT SQL query for MySQL, PostgreSQL and IBM DB2.
* Creation example:
* INSERT INTO applications (name,hostid,templateid,applicationid)
* VALUES ('CPU','10113','13','868'),('Filesystems','10113','5','869'),('General','10113','21','870');
*
* @param string $table
* @param array $fields
* @param array $values
*
* @return string
*/
public function createInsertQuery($table, array $fields, array $values) {
$sql = 'INSERT INTO '.$table.' ('.implode(',', $fields).') VALUES ';
foreach ($values as $row) {
$sql .= '('.implode(',', array_values($row)).'),';
}
$sql = substr($sql, 0, -1);
return $sql;
}
/**
* Set error string.
*
* @param string $error
*/
public function setError($error) {
$this->error = $error;
}
/**
* Return error or null if no error occurred.
*
* @return mixed
*/
public function getError() {
return $this->error;
}
}
|
