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
|
#include <QString>
#include <QtTest>
#include "common/utils_sql.h"
class UtilsSqlTest : public QObject
{
Q_OBJECT
public:
UtilsSqlTest();
private Q_SLOTS:
void testCaseDefault();
void testRemoveEmpties();
void testRemoveComments();
void testRemoveCommentsAndEmpties();
void testDoubleToString();
};
UtilsSqlTest::UtilsSqlTest()
{
qDebug() << QStandardPaths::writableLocation(QStandardPaths::ConfigLocation);
qDebug() << QStandardPaths::writableLocation(QStandardPaths::AppConfigLocation);
qDebug() << QStandardPaths::writableLocation(QStandardPaths::AppDataLocation);
qDebug() << QStandardPaths::writableLocation(QStandardPaths::GenericConfigLocation);
qDebug() << QStandardPaths::writableLocation(QStandardPaths::DataLocation);
}
void UtilsSqlTest::testCaseDefault()
{
QString sql = "select 'dfgh ;sdg '' dfga' from aa; insert into x values ('sdg', ';drghd;;;''', 4); select 1, ''; select 2;";
QStringList sp = quickSplitQueries(sql);
QString failure = "Failure, got: \"%1\"";
QVERIFY2(sp.size() == 4, failure.arg(sp.size()).toLatin1().data());
QVERIFY2(sp[0] == "select 'dfgh ;sdg '' dfga' from aa;", failure.arg(sp[0]).toLatin1().data());
QVERIFY2(sp[1] == " insert into x values ('sdg', ';drghd;;;''', 4);", failure.arg(sp[1]).toLatin1().data());
QVERIFY2(sp[2] == " select 1, '';", failure.arg(sp[2]).toLatin1().data());
QVERIFY2(sp[3] == " select 2;", failure.arg(sp[3]).toLatin1().data());
}
void UtilsSqlTest::testRemoveEmpties()
{
QString sql = "select 'dfgh ;sdg '' dfga' from aa; ; select 1, '';";
QStringList sp = quickSplitQueries(sql, false);
QString failure = "Failure, got: \"%1\"";
QVERIFY2(sp.size() == 2, failure.arg(sp.size()).toLatin1().data());
QVERIFY2(sp[0] == "select 'dfgh ;sdg '' dfga' from aa;", failure.arg(sp[0]).toLatin1().data());
QVERIFY2(sp[1] == " select 1, '';", failure.arg(sp[1]).toLatin1().data());
}
void UtilsSqlTest::testRemoveComments()
{
QString sql = "select 'dfgh ;sdg '' dfga' from aa; select 1/*, ''*/;--select 1\nselect 2;";
QStringList sp = quickSplitQueries(sql, true, true);
QString failure = "Failure, got: \"%1\"";
QVERIFY2(sp.size() == 3, failure.arg(sp.size()).toLatin1().data());
QVERIFY2(sp[0] == "select 'dfgh ;sdg '' dfga' from aa;", failure.arg(sp[0]).toLatin1().data());
QVERIFY2(sp[1] == " select 1;", failure.arg(sp[1]).toLatin1().data());
QVERIFY2(sp[2] == "select 2;", failure.arg(sp[2]).toLatin1().data());
}
void UtilsSqlTest::testRemoveCommentsAndEmpties()
{
QString sql = "select 'dfgh ;sdg /*''*/ dfga' from aa; /*select 1, ''*/;--select 1\n--select 2;";
QStringList sp = quickSplitQueries(sql, false, true);
QString failure = "Failure, got: \"%1\"";
QVERIFY2(sp.size() == 1, failure.arg(sp.size()).toLatin1().data());
QVERIFY2(sp[0] == "select 'dfgh ;sdg /*''*/ dfga' from aa;", failure.arg(sp[0]).toLatin1().data());
}
void UtilsSqlTest::testDoubleToString()
{
QVERIFY(doubleToString(QVariant(5.001)) == "5.001");
QVERIFY(doubleToString(QVariant(5.0000001)) == "5.0000001");
QVERIFY(doubleToString(QVariant(5.000000000000000000000000001)) == "5.0"); // spread of information is too big, considered as round 5
QVERIFY(doubleToString(QVariant(0.0000001)) == "0.0000001");
QVERIFY(doubleToString(QVariant(9.99999999999998)) == "9.99999999999998");
QVERIFY(doubleToString(QVariant(0.1 + 0.1 + 0.1)) == "0.3");
QVERIFY(doubleToString(QVariant(1e-10)) == "0.0000000001");
QVERIFY(doubleToString(QVariant(1e-15)) == "0.000000000000001");
QVERIFY(doubleToString(QVariant(1e-17)) == "1e-17");
QVERIFY(doubleToString(QVariant(1e+20)) == "100000000000000000000.0");
}
QTEST_APPLESS_MAIN(UtilsSqlTest)
#include "tst_utilssqltest.moc"
|
