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
|
/*
* Copyright (c) 2013, 2014, Oracle and/or its affiliates. All rights reserved.
*
* 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; version 2 of the
* License.
*
* 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 St, Fifth Floor, Boston, MA
* 02110-1301 USA
*/
#include "grtsqlparser/sql_facade.h"
#include "wb_helpers.h"
// This file contains unit tests for the yacc based invalid sql parser.
//--------------------------------------------------------------------------------------------------
BEGIN_TEST_DATA_CLASS(mysql_invalid_sql_parser_test)
protected:
WBTester _tester;
SqlFacade::Ref _facade;
std::string _specifics_delimiter;
std::string _user_delimiter;
TEST_DATA_CONSTRUCTOR(mysql_invalid_sql_parser_test)
{
populate_grt(_tester.grt, _tester);
_facade = SqlFacade::instance_for_rdbms_name(_tester.grt, "Mysql");
Sql_specifics::Ref sql_specifics = _facade ->sqlSpecifics();
_specifics_delimiter = sql_specifics->non_std_sql_delimiter();
if (_specifics_delimiter == ";;")
_user_delimiter = "%%";
else
_user_delimiter = ";;";
}
END_TEST_DATA_CLASS
TEST_MODULE(mysql_invalid_sql_parser_test, "MySQL invalid sql parser test suite (yacc)");
//--------------------------------------------------------------------------------------------------
TEST_FUNCTION(5)
{
std::string trigger_sql = "CREATE TRIGGER `ins_film` AFTER INSERT ON `film` FOR EACH ROW BEGIN\n"
" INSERT INTO film_text (film_id, title, description)\n"
" VALUES (new.film_id, new.title, new.description);\n"
"END";
Invalid_sql_parser::Ref parser = _facade->invalidSqlParser();
db_mysql_CatalogRef catalog(_tester.grt);
db_mysql_SchemaRef schema(_tester.grt);
schema->name("sakila");
catalog->schemata().insert(schema);
schema->owner(catalog);
db_mysql_TableRef table(_tester.grt);
table->name("film");
schema->tables().insert(table);
table->owner(schema);
db_mysql_TriggerRef trigger(_tester.grt);
table->triggers().insert(trigger);
trigger->owner(table);
parser->parse_trigger(trigger, trigger_sql);
// The parsing process returns one line break before the actual sql definition, even if no delimiter
// etc. was given. This is due to the way query separation works there.
// So we exclude the first char from the result in our comparisons.
std::string result = (*trigger->sqlDefinition()).substr(1);
ensure_equals("5.1 Trigger SQL differs", result, trigger_sql);
std::string sql = "use test;\n" + trigger_sql;
parser->parse_trigger(trigger, trigger_sql);
result = (*trigger->sqlDefinition()).substr(1);
ensure_equals("5.2 Trigger SQL differs", result, trigger_sql);
sql = "DELIMITER ;\n" + trigger_sql;
parser->parse_trigger(trigger, trigger_sql);
result = (*trigger->sqlDefinition()).substr(1);
ensure_equals("5.3 Trigger SQL differs", result, trigger_sql);
sql = "DELIMITER " + _specifics_delimiter + "\n" + trigger_sql;
parser->parse_trigger(trigger, trigger_sql);
result = (*trigger->sqlDefinition()).substr(1);
ensure_equals("5.4 Trigger SQL differs", result, trigger_sql);
sql = "DELIMITER " + _specifics_delimiter + "\nuse test" + _specifics_delimiter + "\n" + trigger_sql;
parser->parse_trigger(trigger, trigger_sql);
result = (*trigger->sqlDefinition()).substr(1);
ensure_equals("5.5 Trigger SQL differs", result, trigger_sql);
sql = "DELIMITER " + _specifics_delimiter + "\nDELIMITER " + _user_delimiter +
"\nDELIMITER ;\nDELIMITER " + _user_delimiter + "\nDELIMITER " +
_specifics_delimiter + "\nDELIMITER " + _specifics_delimiter + "\nuse test" + _specifics_delimiter + "\n" + trigger_sql;
parser->parse_trigger(trigger, trigger_sql);
result = (*trigger->sqlDefinition()).substr(1);
ensure_equals("5.6 Trigger SQL differs", result, trigger_sql);
sql = "DELIMITER " + _user_delimiter + "\nuse test" + _specifics_delimiter + "\n\n\n\n" + trigger_sql;
parser->parse_trigger(trigger, trigger_sql);
result = (*trigger->sqlDefinition()).substr(1);
ensure_equals("5.7 Trigger SQL differs", result, trigger_sql);
}
END_TESTS;
//----------------------------------------------------------------------------------------------------------------------
|
