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
|
/*
** Zabbix
** Copyright (C) 2001-2020 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.
**/
#include "zbxmocktest.h"
#include "zbxmockdata.h"
#include "zbxmockutil.h"
#include "config.h"
#include "common.h"
#include "zbxalgo.h"
#include "zbxregexp.h"
#include "db.h"
void zbx_mock_test_entry(void **state)
{
#if defined(HAVE_SQLITE3)
# define RESULT "out.sqlite_regex"
#else
#if defined(HAVE_ORACLE)
# define RESULT "out.sqlora_regex"
#else
# define RESULT "out.sql_regex"
#endif
#endif
const char *sql_where, *sql_rgx, *field_name;
zbx_vector_uint64_t in_ids;
int i, count1, count2, shift, repeat;
uint64_t value_id, value;
char *sql;
size_t sql_alloc = 4 * ZBX_KIBIBYTE, sql_offset = 0;
ZBX_UNUSED(state);
sql_where = zbx_mock_get_parameter_string("in.sql_where");
field_name = zbx_mock_get_parameter_string("in.field_name");
value_id = zbx_mock_get_parameter_uint64("in.start_id");
count1 = atoi(zbx_mock_get_parameter_string("in.count1"));
count2 = atoi(zbx_mock_get_parameter_string("in.count2"));
shift = atoi(zbx_mock_get_parameter_string("in.shift"));
repeat = atoi(zbx_mock_get_parameter_string("in.repeat"));
sql_rgx = zbx_mock_get_parameter_string(RESULT);
sql = (char *)zbx_malloc(NULL, sql_alloc);
zbx_vector_uint64_create(&in_ids);
value = value_id;
do
{
for (i = 0; i < count1; i++)
zbx_vector_uint64_append(&in_ids, value++);
value_id += shift;
value = value_id;
for (i = 0; i < count2; i++)
zbx_vector_uint64_append(&in_ids, value++);
if (0 != count2)
{
value_id += shift;
value = value_id;
}
}
while (repeat--);
zbx_strcpy_alloc(&sql, &sql_alloc, &sql_offset, sql_where);
DBadd_condition_alloc(&sql, &sql_alloc, &sql_offset, field_name, in_ids.values, in_ids.values_num);
zbx_vector_uint64_destroy(&in_ids);
if (NULL == zbx_regexp_match(sql, sql_rgx, NULL))
{
unsigned int len;
if (sql_offset > (len = 4 * ZBX_KIBIBYTE) * 2)
{
printf("Start of prepared sql (total=%zu): \"%.*s\"\n", sql_offset, len, sql);
printf("End of prepared sql: \"%s\"\n", &sql[sql_offset - len]);
}
else
printf("Prepared sql (total=%zu): \"%s\"\n", sql_offset, sql);
zbx_free(sql);
fail_msg("Regular expression %s=\"%s\" does not much sql", RESULT, sql_rgx);
}
else
zbx_free(sql);
}
|
