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
|
#include "parser/lexer.h"
#include <QString>
#include <QtTest>
class LexerTest : public QObject
{
Q_OBJECT
public:
LexerTest();
private Q_SLOTS:
void testStringCase1();
void testStringCase2();
void testFloat();
void testHex1();
void testHex2();
void testBindParam1();
void testBlobLiteral();
void testDollarId();
};
LexerTest::LexerTest()
{
}
void LexerTest::testStringCase1()
{
QString sql = "INSERT INTO tab VALUES (1, 2, :val); /* test";
Lexer lex;
TokenList tokens = lex.tokenize(sql);
QVERIFY(tokens.size() == 20);
}
void LexerTest::testStringCase2()
{
QString sql = "SELECT 1 = '1'";
Lexer lex;
TokenList tokens = lex.tokenize(sql);
QCOMPARE(tokens.size(), 7);
QCOMPARE(tokens[2]->type, Token::INTEGER);
QCOMPARE(tokens[6]->type, Token::STRING);
}
void LexerTest::testFloat()
{
QString sql = "SELECT .2";
Lexer lex;
TokenList tokens = lex.tokenize(sql);
QVERIFY(tokens.size() == 3);
QVERIFY(tokens[2]->type == Token::FLOAT);
}
void LexerTest::testHex1()
{
QString sql = "SELECT 0x";
Lexer lex;
TokenList tokens = lex.tokenize(sql);
QVERIFY(tokens.size() == 3);
QVERIFY(tokens[2]->type == Token::INVALID);
}
void LexerTest::testHex2()
{
QString sql = "SELECT 0x5zzz";
Lexer lex;
TokenList tokens = lex.tokenize(sql);
QVERIFY(tokens.size() == 4);
QVERIFY(tokens[2]->type == Token::INTEGER);
QVERIFY(tokens[3]->type == Token::OTHER);
QVERIFY(tokens[3]->value == "zzz");
}
void LexerTest::testBindParam1()
{
QString sql = "SELECT * FROM test WHERE id = ?1 OR id = ?123 OR id = ? OR id = :id OR id = @id";
Lexer lex;
TokenList tokens = lex.tokenize(sql);
TokenList bindTokens = tokens.filter(Token::BIND_PARAM);
QVERIFY(bindTokens.size() == 5);
QVERIFY(bindTokens[0]->value == "?1");
QVERIFY(bindTokens[1]->value == "?123");
QVERIFY(bindTokens[2]->value == "?");
QVERIFY(bindTokens[3]->value == ":id");
QVERIFY(bindTokens[4]->value == "@id");
}
void LexerTest::testBlobLiteral()
{
QString sql = "SELECT X'010f0E'";
Lexer lex;
TokenList tokens = lex.tokenize(sql);
QCOMPARE(tokens.size(), 3);
QCOMPARE(tokens[2]->value, "X'010f0E'");
}
void LexerTest::testDollarId()
{
QString sql = "SELECT v$test";
Lexer lex;
TokenList tokens = lex.tokenize(sql);
QCOMPARE(tokens.size(), 3);
QCOMPARE(tokens[2]->value, "v$test");
QCOMPARE(tokens[2]->type, Token::OTHER);
}
QTEST_APPLESS_MAIN(LexerTest)
#include "tst_lexertest.moc"
|
