blob: 0e44e7d04cc32dcbf1c1ac46574584c0ae3f9e57 (
plain) (
blame)
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
|
#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();
};
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");
}
QTEST_APPLESS_MAIN(LexerTest)
#include "tst_lexertest.moc"
|
