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
|
<?php
/*
** Zabbix
** Copyright (C) 2000-2011 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., 675 Mass Ave, Cambridge, MA 02139, USA.
**/
?>
<?php
require_once 'PHPUnit/Framework.php';
require_once(dirname(__FILE__).'/../include/class.czabbixtest.php');
class function_DBselect extends CZabbixTest
{
public function test_DBselectOK()
{
$result=DBselect('select * from users');
$this->assertTrue(is_resource($result) ||is_object($result));
}
public function test_DBselectRange()
{
$this->assertTrue(0 == DBcount('select * from items',0));
$this->assertTrue(1 == DBcount('select * from items',1));
$this->assertTrue(100 == DBcount('select * from items',100));
$this->assertTrue(1 == DBcount('select * from items','1'));
}
public function test_DBselectWrongParameters()
{
$this->assertTrue(false == DBselect('select * from items','ZZZ'));
$this->assertTrue(false == DBselect('select * from items',1.5));
$this->assertTrue(false == DBselect('select * from items',1.5));
$this->assertTrue(false == DBselect('select * from items',-1));
}
public function test_DBselectFail()
{
// TODO
$this->markTestIncomplete();
/* Does not work this way
$result=DBselect('select * from users_typo');
$this->assertTrue($result == false);
*/
}
}
?>
|
