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
|
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Test for generating CREATE TRIGGER query from HTTP request
*
* @package PhpMyAdmin-test
*/
/*
* Needed for backquote()
*/
require_once 'libraries/Util.class.php';
/*
* Needed by PMA_TRI_getQueryFromRequest()
*/
require_once 'libraries/php-gettext/gettext.inc';
/*
* Include to test.
*/
require_once 'libraries/rte/rte_triggers.lib.php';
require_once 'libraries/database_interface.inc.php';
require_once 'libraries/Tracker.class.php';
/**
* Test for generating CREATE TRIGGER query from HTTP request
*
* @package PhpMyAdmin-test
*/
class PMA_TRI_GetQueryFromRequest_Test extends PHPUnit_Framework_TestCase
{
/**
* Set up
*
* @return void
*/
public function setUp()
{
$GLOBALS['db'] = 'pma_test';
}
/**
* Test for PMA_TRI_getQueryFromRequest
*
* @param string $definer Definer
* @param string $name Name
* @param string $timing Timing
* @param string $event Event
* @param string $table Table
* @param string $definition Definition
* @param string $query Query
* @param string $num_err Error number
*
* @return void
*
* @dataProvider provider
*/
public function testgetQueryFromRequest(
$definer, $name, $timing, $event, $table, $definition, $query, $num_err
) {
global $_REQUEST, $errors;
$errors = array();
PMA_TRI_setGlobals();
$_REQUEST['item_definer'] = $definer;
$_REQUEST['item_name'] = $name;
$_REQUEST['item_timing'] = $timing;
$_REQUEST['item_event'] = $event;
$_REQUEST['item_table'] = $table;
$_REQUEST['item_definition'] = $definition;
$this->assertEquals($query, PMA_TRI_getQueryFromRequest());
$this->assertEquals($num_err, count($errors));
}
/**
* Data provider for testgetQueryFromRequest
*
* @return array
*/
public function provider()
{
return array(
array('',
'',
'',
'',
'',
'',
'CREATE TRIGGER ON FOR EACH ROW ',
5
),
array(
'root',
'trigger',
'BEFORE',
'INSERT',
'table`2',
'SET @A=NULL',
'CREATE TRIGGER `trigger` BEFORE INSERT ON FOR EACH ROW SET @A=NULL',
2
),
array(
'foo`s@host',
'trigger`s test',
'AFTER',
'foo',
'table3',
'BEGIN SET @A=1; SET @B=2; END',
'CREATE DEFINER=`foo``s`@`host` TRIGGER `trigger``s test` AFTER ON FOR EACH ROW BEGIN SET @A=1; SET @B=2; END',
2
),
array(
'root@localhost',
'trigger',
'BEFORE',
'INSERT',
'table1',
'SET @A=NULL',
'CREATE DEFINER=`root`@`localhost` TRIGGER `trigger` BEFORE INSERT ON `table1` FOR EACH ROW SET @A=NULL',
0
),
);
}
}
|
