1 /**************************************************************************** |
|
2 ** |
|
3 ** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies). |
|
4 ** All rights reserved. |
|
5 ** Contact: Nokia Corporation (qt-info@nokia.com) |
|
6 ** |
|
7 ** This file is part of the Qt Mobility Components. |
|
8 ** |
|
9 ** $QT_BEGIN_LICENSE:LGPL$ |
|
10 ** No Commercial Usage |
|
11 ** This file contains pre-release code and may not be distributed. |
|
12 ** You may use this file in accordance with the terms and conditions |
|
13 ** contained in the Technology Preview License Agreement accompanying |
|
14 ** this package. |
|
15 ** |
|
16 ** GNU Lesser General Public License Usage |
|
17 ** Alternatively, this file may be used under the terms of the GNU Lesser |
|
18 ** General Public License version 2.1 as published by the Free Software |
|
19 ** Foundation and appearing in the file LICENSE.LGPL included in the |
|
20 ** packaging of this file. Please review the following information to |
|
21 ** ensure the GNU Lesser General Public License version 2.1 requirements |
|
22 ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. |
|
23 ** |
|
24 ** In addition, as a special exception, Nokia gives you certain additional |
|
25 ** rights. These rights are described in the Nokia Qt LGPL Exception |
|
26 ** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. |
|
27 ** |
|
28 ** If you have questions regarding the use of this file, please contact |
|
29 ** Nokia at qt-info@nokia.com. |
|
30 ** |
|
31 ** |
|
32 ** |
|
33 ** |
|
34 ** |
|
35 ** |
|
36 ** |
|
37 ** |
|
38 ** $QT_END_LICENSE$ |
|
39 ** |
|
40 ****************************************************************************/ |
|
41 |
|
42 |
|
43 #include <QtTest/QtTest> |
|
44 #include <QStringList> |
|
45 |
|
46 #include "ut_cntsqlsearch.h" |
|
47 #include "cntsqlsearch.h" |
|
48 |
|
49 #define WRITE_LOGS |
|
50 //#define SQL_QT_TEST |
|
51 |
|
52 #if defined(WRITE_LOGS) |
|
53 #include <e32debug.h> // RDebug |
|
54 |
|
55 #define LOG(a) WriteLog(a, "") |
|
56 #define LOG2(a, b) WriteLog(a, b) |
|
57 #define TEST_BEGIN_LOG(a) LOG(a##" begins") |
|
58 #define TEST_PASSED_LOG(a) LOG(a##" passed") |
|
59 |
|
60 void WriteLog(const QString a, const QString b); |
|
61 void WritePart(const TDesC& s); |
|
62 #else |
|
63 #define LOG(a) |
|
64 #define LOG2(a, b) |
|
65 #define TEST_BEGIN_LOG(a) |
|
66 #define TEST_PASSED_LOG(a) |
|
67 #endif |
|
68 |
|
69 |
|
70 void UT_CntSqlSearch::initTestCase() |
|
71 { |
|
72 } |
|
73 |
|
74 void UT_CntSqlSearch::cleanupTestCase() |
|
75 { |
|
76 } |
|
77 |
|
78 |
|
79 void UT_CntSqlSearch::init() |
|
80 { |
|
81 mCntSqlSearch = new CntSqlSearch(); |
|
82 } |
|
83 |
|
84 void UT_CntSqlSearch::cleanup() |
|
85 { |
|
86 delete mCntSqlSearch; |
|
87 mCntSqlSearch = 0; |
|
88 |
|
89 } |
|
90 void UT_CntSqlSearch::testPredictiveSearch() |
|
91 { |
|
92 TEST_BEGIN_LOG("testPredictiveSearch"); |
|
93 |
|
94 QString pattern = QString("205"); |
|
95 #if defined(SEARCH_FROM_ONE_TABLE) |
|
96 #if defined(USE_DEMORGAN) |
|
97 QString reference("SELECT contact_id FROM predictivesearch2 WHERE NOT(NOT(NOT(NOT(nbr>145522562959409151 AND nbr<145804037936119808) AND NOT(nbr2>145522562959409151 AND nbr2<145804037936119808) AND NOT(nbr3>145522562959409151 AND nbr3<145804037936119808) AND NOT(nbr4>145522562959409151 AND nbr4<145804037936119808))) AND NOT(NOT(NOT(nbr2>360287970189639679 AND nbr2<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr3>144115188075855871 AND nbr3<216172782113783808))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>360287970189639679 AND nbr2<432345564227567616) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>360287970189639679 AND nbr2<432345564227567616) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>360287970189639679 AND nbr3<432345564227567616)))) ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
98 #else // #if defined(USE_DEMORGAN) |
|
99 QString reference("SELECT contact_id FROM predictivesearch2 WHERE \ |
|
100 ((nbr>145522562959409151 AND nbr<145804037936119808) OR (nbr2>145522562959409151 AND nbr2<145804037936119808) \ |
|
101 OR (nbr3>145522562959409151 AND nbr3<145804037936119808) OR (nbr4>145522562959409151 AND nbr4<145804037936119808)) OR \ |
|
102 (nbr2>360287970189639679 AND nbr2<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
103 (nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
104 (nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
105 (nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
106 (nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
107 (nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr3>144115188075855871 AND nbr3<216172782113783808) OR \ |
|
108 (nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) OR \ |
|
109 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) OR \ |
|
110 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>360287970189639679 AND nbr2<432345564227567616) OR \ |
|
111 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) OR \ |
|
112 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>360287970189639679 AND nbr2<432345564227567616) OR \ |
|
113 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>360287970189639679 AND nbr3<432345564227567616) \ |
|
114 ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
115 #endif // #if defined(USE_DEMORGAN) |
|
116 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
117 QString reference("SELECT predictivesearch2.contact_id FROM predictivesearch2 WHERE EXISTS (SELECT contact_id FROM predictivesearch5 WHERE predictivesearch2.contact_id = predictivesearch5.contact_id) OR (SELECT contact_id FROM predictivesearch2 WHERE (NOT(NOT(predictivesearch2.nbr>145522562959409151 AND predictivesearch2.nbr<145804037936119808) AND NOT(predictivesearch2.nbr2>145522562959409151 AND predictivesearch2.nbr2<145804037936119808) AND NOT(predictivesearch2.nbr3>145522562959409151 AND predictivesearch2.nbr3<145804037936119808) AND NOT(predictivesearch2.nbr4>145522562959409151 AND predictivesearch2.nbr4<145804037936119808)))) ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
118 #endif // #if defined(SEARCH_FROM_ONE_TABLE) |
|
119 QString result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
120 qDebug() << pattern << "-> result" << result; |
|
121 LOG2(pattern, result); |
|
122 QVERIFY(!result.compare(reference)); |
|
123 |
|
124 pattern = QString("101"); |
|
125 #if defined(USE_DEMORGAN) |
|
126 reference = QString("SELECT contact_id FROM predictivesearch1 WHERE NOT(NOT(NOT(NOT(nbr>72339069014638591 AND nbr<72620543991349248) AND NOT(nbr2>72339069014638591 AND nbr2<72620543991349248) AND NOT(nbr3>72339069014638591 AND nbr3<72620543991349248) AND NOT(nbr4>72339069014638591 AND nbr4<72620543991349248))) AND NOT(NOT(NOT(nbr2>72057594037927935 AND nbr2<144115188075855872 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr2>72057594037927935 AND nbr2<144115188075855872) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr2>72057594037927935 AND nbr2<144115188075855872) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr3>72057594037927935 AND nbr3<144115188075855872)))) ORDER BY predictivesearch1.first_name, predictivesearch1.last_name ASC;"); |
|
127 #else |
|
128 reference = QString("SELECT contact_id FROM predictivesearch1 WHERE ((nbr>72339069014638591 AND nbr<72620543991349248) OR (nbr2>72339069014638591 AND nbr2<72620543991349248) OR (nbr3>72339069014638591 AND nbr3<72620543991349248) OR (nbr4>72339069014638591 AND nbr4<72620543991349248)) OR (nbr2>72057594037927935 AND nbr2<144115188075855872 AND nbr>72057594037927935 AND nbr<144115188075855872) OR (nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr>72057594037927935 AND nbr<144115188075855872) OR (nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr2>72057594037927935 AND nbr2<144115188075855872) OR (nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr>72057594037927935 AND nbr<144115188075855872) OR (nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr2>72057594037927935 AND nbr2<144115188075855872) OR (nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr3>72057594037927935 AND nbr3<144115188075855872) ORDER BY predictivesearch1.first_name, predictivesearch1.last_name ASC;"); |
|
129 #endif |
|
130 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
131 qDebug() << pattern << " -> result" << result; |
|
132 LOG2(pattern, result); |
|
133 QVERIFY(!result.compare(reference)); |
|
134 |
|
135 pattern = QString("202"); |
|
136 #if defined(USE_DEMORGAN) |
|
137 reference = QString("SELECT contact_id FROM predictivesearch2 WHERE NOT(NOT(NOT(NOT(nbr>144678138029277183 AND nbr<144959613005987840) AND NOT(nbr2>144678138029277183 AND nbr2<144959613005987840) AND NOT(nbr3>144678138029277183 AND nbr3<144959613005987840) AND NOT(nbr4>144678138029277183 AND nbr4<144959613005987840))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>144115188075855871 AND nbr3<216172782113783808)))) ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
138 #else |
|
139 reference = QString("TODO"); |
|
140 #endif |
|
141 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
142 qDebug() << pattern << " -> result" << result; |
|
143 LOG2(pattern, result); |
|
144 QVERIFY(!result.compare(reference)); |
|
145 |
|
146 pattern = QString("25"); |
|
147 #if defined(USE_DEMORGAN) |
|
148 reference = QString("SELECT contact_id FROM predictivesearch2 WHERE (NOT(NOT(nbr>166633186212708351 AND nbr<171136785840078848) AND NOT(nbr2>166633186212708351 AND nbr2<171136785840078848) AND NOT(nbr3>166633186212708351 AND nbr3<171136785840078848) AND NOT(nbr4>166633186212708351 AND nbr4<171136785840078848))) ORDER BY first_name, last_name ASC;"); |
|
149 #else |
|
150 reference = QString("SELECT contact_id FROM predictivesearch2 WHERE (NOT(NOT(nbr>166633186212708351 AND nbr<171136785840078848) AND NOT(nbr2>166633186212708351 AND nbr2<171136785840078848) AND NOT(nbr3>166633186212708351 AND nbr3<171136785840078848) AND NOT(nbr4>166633186212708351 AND nbr4<171136785840078848))) ORDER BY first_name, last_name ASC;"); |
|
151 #endif |
|
152 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
153 qDebug() << pattern << " -> result" << result; |
|
154 LOG2(pattern, result); |
|
155 QVERIFY(!result.compare( reference)); |
|
156 |
|
157 |
|
158 pattern = QString("56606"); |
|
159 #if defined(SEARCH_FROM_ONE_TABLE) |
|
160 #if defined(USE_DEMORGAN) |
|
161 reference = QString("SELECT contact_id FROM predictivesearch5 WHERE NOT(NOT(NOT(NOT(nbr>389005014883893247 AND nbr<389006114395521024) AND NOT(nbr2>389005014883893247 AND nbr2<389006114395521024) AND NOT(nbr3>389005014883893247 AND nbr3<389006114395521024) AND NOT(nbr4>389005014883893247 AND nbr4<389006114395521024))) AND NOT(NOT(NOT(nbr2>432345564227567615 AND nbr2<504403158265495552 AND nbr>388998417814126591 AND nbr<389279892790837248) AND NOT(nbr3>432345564227567615 AND nbr3<504403158265495552 AND nbr>388998417814126591 AND nbr<389279892790837248) AND NOT(nbr3>432345564227567615 AND nbr3<504403158265495552 AND nbr2>388998417814126591 AND nbr2<389279892790837248) AND NOT(nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr>388998417814126591 AND nbr<389279892790837248) AND NOT(nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr2>388998417814126591 AND nbr2<389279892790837248) AND NOT(nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr3>388998417814126591 AND nbr3<389279892790837248))) AND NOT(NOT(NOT(nbr2>388998417814126591 AND nbr2<389279892790837248 AND nbr>432345564227567615 AND nbr<504403158265495552) AND NOT(nbr3>388998417814126591 AND nbr3<389279892790837248 AND nbr>432345564227567615 AND nbr<504403158265495552) AND NOT(nbr3>388998417814126591 AND nbr3<389279892790837248 AND nbr2>432345564227567615 AND nbr2<504403158265495552) AND NOT(nbr4>388998417814126591 AND nbr4<389279892790837248 AND nbr>432345564227567615 AND nbr<504403158265495552) AND NOT(nbr4>388998417814126591 AND nbr4<389279892790837248 AND nbr2>432345564227567615 AND nbr2<504403158265495552) AND NOT(nbr4>388998417814126591 AND nbr4<389279892790837248 AND nbr3>432345564227567615 AND nbr3<504403158265495552)))) ORDER BY predictivesearch5.first_name, predictivesearch5.last_name ASC;"); |
|
162 #else // #if defined(USE_DEMORGAN) |
|
163 reference = QString("SELECT contact_id FROM predictivesearch5 WHERE \ |
|
164 ((nbr>389005014883893247 AND nbr<389006114395521024) OR (nbr2>389005014883893247 AND nbr2<389006114395521024) OR \ |
|
165 (nbr3>389005014883893247 AND nbr3<389006114395521024) OR (nbr4>389005014883893247 AND nbr4<389006114395521024)) OR \ |
|
166 (nbr2>432345564227567615 AND nbr2<504403158265495552 AND nbr>388998417814126591 AND nbr<389279892790837248) OR \ |
|
167 (nbr3>432345564227567615 AND nbr3<504403158265495552 AND nbr>388998417814126591 AND nbr<389279892790837248) OR \ |
|
168 (nbr3>432345564227567615 AND nbr3<504403158265495552 AND nbr2>388998417814126591 AND nbr2<389279892790837248) OR \ |
|
169 (nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr>388998417814126591 AND nbr<389279892790837248) OR \ |
|
170 (nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr2>388998417814126591 AND nbr2<389279892790837248) OR \ |
|
171 (nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr3>388998417814126591 AND nbr3<389279892790837248) OR \ |
|
172 (nbr2>388998417814126591 AND nbr2<389279892790837248 AND nbr>432345564227567615 AND nbr<504403158265495552) OR \ |
|
173 (nbr3>388998417814126591 AND nbr3<389279892790837248 AND nbr>432345564227567615 AND nbr<504403158265495552) OR \ |
|
174 (nbr3>388998417814126591 AND nbr3<389279892790837248 AND nbr2>432345564227567615 AND nbr2<504403158265495552) OR \ |
|
175 (nbr4>388998417814126591 AND nbr4<389279892790837248 AND nbr>432345564227567615 AND nbr<504403158265495552) OR \ |
|
176 (nbr4>388998417814126591 AND nbr4<389279892790837248 AND nbr2>432345564227567615 AND nbr2<504403158265495552) OR \ |
|
177 (nbr4>388998417814126591 AND nbr4<389279892790837248 AND nbr3>432345564227567615 AND nbr3<504403158265495552) \ |
|
178 ORDER BY predictivesearch5.first_name, predictivesearch5.last_name ASC;"); |
|
179 #endif //#if defined(USE_DEMORGAN) |
|
180 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
181 reference = QString("SELECT contact_id FROM (SELECT predictivesearch5.contact_id, predictivesearch5.first_name, predictivesearch5.last_name FROM predictivesearch5 WHERE (NOT(NOT(predictivesearch5.nbr>389005014883893247 AND predictivesearch5.nbr<389006114395521024) AND NOT(predictivesearch5.nbr2>389005014883893247 AND predictivesearch5.nbr2<389006114395521024) AND NOT(predictivesearch5.nbr3>389005014883893247 AND predictivesearch5.nbr3<389006114395521024) AND NOT(predictivesearch5.nbr4>389005014883893247 AND predictivesearch5.nbr4<389006114395521024))) UNION SELECT predictivesearch5.contact_id, predictivesearch5.first_name, predictivesearch5.last_name FROM predictivesearch5 JOIN predictivesearch6 ON predictivesearch5.contact_id = predictivesearch6.contact_id WHERE(NOT(NOT(predictivesearch5.nbr>388998417814126591 AND predictivesearch5.nbr<389279892790837248) AND NOT(predictivesearch5.nbr2>388998417814126591 AND predictivesearch5.nbr2<389279892790837248) AND NOT(predictivesearch5.nbr3>388998417814126591 AND predictivesearch5.nbr3<389279892790837248) AND NOT(predictivesearch5.nbr4>388998417814126591 AND predictivesearch5.nbr4<389279892790837248)))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
182 #endif // #if defined(SEARCH_FROM_ONE_TABLE) |
|
183 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
184 qDebug() << pattern << " -> result" << result; |
|
185 LOG2(pattern, result); |
|
186 QVERIFY( !result.compare( reference) ); |
|
187 |
|
188 pattern = QString("3"); |
|
189 reference = QString ("SELECT contact_id FROM predictivesearch3 ORDER BY first_name, last_name ASC;"); |
|
190 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
191 qDebug() << pattern << " -> result" << result; |
|
192 LOG2(pattern, result); |
|
193 QVERIFY( !result.compare( reference) ); |
|
194 |
|
195 pattern = QString("0"); |
|
196 reference = QString ("SELECT contact_id FROM predictivesearch0 ORDER BY first_name, last_name ASC;"); |
|
197 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
198 qDebug() << pattern << " -> result" << result; |
|
199 LOG2(pattern, result); |
|
200 QVERIFY(!result.compare( reference)); |
|
201 |
|
202 // TODO: Test this case on HW and verify leading zeros. |
|
203 pattern.clear(); |
|
204 pattern = "0705"; |
|
205 #if defined(SEARCH_FROM_ONE_TABLE) |
|
206 #if defined(USE_DEMORGAN) |
|
207 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE NOT(NOT(NOT(NOT(nbr>31613158321815551 AND nbr<31630750507859968) AND NOT(nbr2>31613158321815551 AND nbr2<31630750507859968) AND NOT(nbr3>31613158321815551 AND nbr3<31630750507859968) AND NOT(nbr4>31613158321815551 AND nbr4<31630750507859968))) AND NOT(NOT(NOT(nbr2>360287970189639679 AND nbr2<432345564227567616 AND nbr>31525197391593471 AND nbr<36028797018963968) AND NOT(nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr>31525197391593471 AND nbr<36028797018963968) AND NOT(nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr2>31525197391593471 AND nbr2<36028797018963968) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr>31525197391593471 AND nbr<36028797018963968) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr2>31525197391593471 AND nbr2<36028797018963968) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr3>31525197391593471 AND nbr3<36028797018963968))) AND NOT(NOT(NOT(nbr2>31525197391593471 AND nbr2<36028797018963968 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr3>31525197391593471 AND nbr3<36028797018963968 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr3>31525197391593471 AND nbr3<36028797018963968 AND nbr2>360287970189639679 AND nbr2<432345564227567616) AND NOT(nbr4>31525197391593471 AND nbr4<36028797018963968 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr4>31525197391593471 AND nbr4<36028797018963968 AND nbr2>360287970189639679 AND nbr2<432345564227567616) AND NOT(nbr4>31525197391593471 AND nbr4<36028797018963968 AND nbr3>360287970189639679 AND nbr3<432345564227567616)))) ORDER BY predictivesearch0.first_name, predictivesearch0.last_name ASC;"); |
|
208 #else // #if defined(USE_DEMORGAN) |
|
209 |
|
210 #endif //#if defined(USE_DEMORGAN) |
|
211 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
212 reference = QString("SELECT contact_id FROM (SELECT predictivesearch0.contact_id, predictivesearch0.first_name, predictivesearch0.last_name FROM predictivesearch0 WHERE (NOT(NOT(predictivesearch0.nbr>31613158321815551 AND predictivesearch0.nbr<31630750507859968) AND NOT(predictivesearch0.nbr2>31613158321815551 AND predictivesearch0.nbr2<31630750507859968) AND NOT(predictivesearch0.nbr3>31613158321815551 AND predictivesearch0.nbr3<31630750507859968) AND NOT(predictivesearch0.nbr4>31613158321815551 AND predictivesearch0.nbr4<31630750507859968))) UNION SELECT predictivesearch0.contact_id, predictivesearch0.first_name, predictivesearch0.last_name FROM predictivesearch0 JOIN predictivesearch5 ON predictivesearch0.contact_id = predictivesearch5.contact_id WHERE(NOT(NOT(predictivesearch0.nbr>31525197391593471 AND predictivesearch0.nbr<36028797018963968) AND NOT(predictivesearch0.nbr2>31525197391593471 AND predictivesearch0.nbr2<36028797018963968) AND NOT(predictivesearch0.nbr3>31525197391593471 AND predictivesearch0.nbr3<36028797018963968) AND NOT(predictivesearch0.nbr4>31525197391593471 AND predictivesearch0.nbr4<36028797018963968)))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
213 #endif // #if defined(SEARCH_FROM_ONE_TABLE) |
|
214 |
|
215 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
216 //qDebug() << pattern << result; |
|
217 LOG2(pattern, result); |
|
218 QVERIFY(!result.compare(reference)); |
|
219 |
|
220 pattern.clear(); |
|
221 pattern = "4301"; |
|
222 #if defined(SEARCH_FROM_ONE_TABLE) |
|
223 #if defined(USE_DEMORGAN) |
|
224 reference = QString("SELECT contact_id FROM predictivesearch4 WHERE NOT(NOT(NOT(NOT(nbr>301758767219867647 AND nbr<301776359405912064) AND NOT(nbr2>301758767219867647 AND nbr2<301776359405912064) AND NOT(nbr3>301758767219867647 AND nbr3<301776359405912064) AND NOT(nbr4>301758767219867647 AND nbr4<301776359405912064))) AND NOT(NOT(NOT(nbr2>72057594037927935 AND nbr2<144115188075855872 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr2>301741175033823231 AND nbr2<306244774661193728) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr2>301741175033823231 AND nbr2<306244774661193728) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr3>301741175033823231 AND nbr3<306244774661193728))) AND NOT(NOT(NOT(nbr2>301741175033823231 AND nbr2<306244774661193728 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr3>301741175033823231 AND nbr3<306244774661193728 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr3>301741175033823231 AND nbr3<306244774661193728 AND nbr2>72057594037927935 AND nbr2<144115188075855872) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr2>72057594037927935 AND nbr2<144115188075855872) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr3>72057594037927935 AND nbr3<144115188075855872)))) ORDER BY predictivesearch4.first_name, predictivesearch4.last_name ASC;"); |
|
225 #else // #if defined(USE_DEMORGAN) |
|
226 |
|
227 #endif //#if defined(USE_DEMORGAN) |
|
228 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
229 reference = QString("SELECT contact_id FROM (SELECT predictivesearch4.contact_id, predictivesearch4.first_name, predictivesearch4.last_name FROM predictivesearch4 WHERE (NOT(NOT(predictivesearch4.nbr>301758767219867647 AND predictivesearch4.nbr<301776359405912064) AND NOT(predictivesearch4.nbr2>301758767219867647 AND predictivesearch4.nbr2<301776359405912064) AND NOT(predictivesearch4.nbr3>301758767219867647 AND predictivesearch4.nbr3<301776359405912064) AND NOT(predictivesearch4.nbr4>301758767219867647 AND predictivesearch4.nbr4<301776359405912064))) UNION SELECT predictivesearch4.contact_id, predictivesearch4.first_name, predictivesearch4.last_name FROM predictivesearch4 JOIN predictivesearch1 ON predictivesearch4.contact_id = predictivesearch1.contact_id WHERE(NOT(NOT(predictivesearch4.nbr>301741175033823231 AND predictivesearch4.nbr<306244774661193728) AND NOT(predictivesearch4.nbr2>301741175033823231 AND predictivesearch4.nbr2<306244774661193728) AND NOT(predictivesearch4.nbr3>301741175033823231 AND predictivesearch4.nbr3<306244774661193728) AND NOT(predictivesearch4.nbr4>301741175033823231 AND predictivesearch4.nbr4<306244774661193728)))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
230 #endif // #if defined(SEARCH_FROM_ONE_TABLE) |
|
231 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
232 //qDebug() << pattern << result; |
|
233 LOG2(pattern, result); |
|
234 QVERIFY(!result.compare(reference)); |
|
235 |
|
236 pattern.clear(); |
|
237 pattern = "4304"; |
|
238 #if defined(USE_DEMORGAN) |
|
239 reference = QString("SELECT contact_id FROM predictivesearch4 WHERE NOT(NOT(NOT(NOT(nbr>301811543778000895 AND nbr<301829135964045312) AND NOT(nbr2>301811543778000895 AND nbr2<301829135964045312) AND NOT(nbr3>301811543778000895 AND nbr3<301829135964045312) AND NOT(nbr4>301811543778000895 AND nbr4<301829135964045312))) AND NOT(NOT(NOT(nbr2>288230376151711743 AND nbr2<360287970189639680 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr3>288230376151711743 AND nbr3<360287970189639680 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr3>288230376151711743 AND nbr3<360287970189639680 AND nbr2>301741175033823231 AND nbr2<306244774661193728) AND NOT(nbr4>288230376151711743 AND nbr4<360287970189639680 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr4>288230376151711743 AND nbr4<360287970189639680 AND nbr2>301741175033823231 AND nbr2<306244774661193728) AND NOT(nbr4>288230376151711743 AND nbr4<360287970189639680 AND nbr3>301741175033823231 AND nbr3<306244774661193728))) AND NOT(NOT(NOT(nbr2>301741175033823231 AND nbr2<306244774661193728 AND nbr>288230376151711743 AND nbr<360287970189639680) AND NOT(nbr3>301741175033823231 AND nbr3<306244774661193728 AND nbr>288230376151711743 AND nbr<360287970189639680) AND NOT(nbr3>301741175033823231 AND nbr3<306244774661193728 AND nbr2>288230376151711743 AND nbr2<360287970189639680) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr>288230376151711743 AND nbr<360287970189639680) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr2>288230376151711743 AND nbr2<360287970189639680) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr3>288230376151711743 AND nbr3<360287970189639680)))) ORDER BY predictivesearch4.first_name, predictivesearch4.last_name ASC;"); |
|
240 #else |
|
241 //TODO: |
|
242 #endif |
|
243 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
244 //qDebug() << pattern << result; |
|
245 LOG2(pattern, result); |
|
246 QVERIFY(!result.compare(reference)); |
|
247 |
|
248 pattern.clear(); |
|
249 pattern = "4043"; |
|
250 #if defined(USE_DEMORGAN) |
|
251 reference = QString("SELECT contact_id FROM predictivesearch4 WHERE NOT(NOT(NOT(NOT(nbr>289409052616687615 AND nbr<289426644802732032) AND NOT(nbr2>289409052616687615 AND nbr2<289426644802732032) AND NOT(nbr3>289409052616687615 AND nbr3<289426644802732032) AND NOT(nbr4>289409052616687615 AND nbr4<289426644802732032))) AND NOT(NOT(NOT(nbr2>301741175033823231 AND nbr2<306244774661193728 AND nbr>288230376151711743 AND nbr<360287970189639680) AND NOT(nbr3>301741175033823231 AND nbr3<306244774661193728 AND nbr>288230376151711743 AND nbr<360287970189639680) AND NOT(nbr3>301741175033823231 AND nbr3<306244774661193728 AND nbr2>288230376151711743 AND nbr2<360287970189639680) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr>288230376151711743 AND nbr<360287970189639680) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr2>288230376151711743 AND nbr2<360287970189639680) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr3>288230376151711743 AND nbr3<360287970189639680))) AND NOT(NOT(NOT(nbr2>288230376151711743 AND nbr2<360287970189639680 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr3>288230376151711743 AND nbr3<360287970189639680 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr3>288230376151711743 AND nbr3<360287970189639680 AND nbr2>301741175033823231 AND nbr2<306244774661193728) AND NOT(nbr4>288230376151711743 AND nbr4<360287970189639680 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr4>288230376151711743 AND nbr4<360287970189639680 AND nbr2>301741175033823231 AND nbr2<306244774661193728) AND NOT(nbr4>288230376151711743 AND nbr4<360287970189639680 AND nbr3>301741175033823231 AND nbr3<306244774661193728)))) ORDER BY predictivesearch4.first_name, predictivesearch4.last_name ASC;"); |
|
252 #else |
|
253 //TODO: |
|
254 #endif |
|
255 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
256 //qDebug() << pattern << result; |
|
257 LOG2(pattern, result); |
|
258 QVERIFY(!result.compare(reference)); |
|
259 |
|
260 pattern = QString("03"); |
|
261 #if defined(USE_DEMORGAN) |
|
262 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE (NOT(NOT(nbr>13510798882111487 AND nbr<18014398509481984) AND NOT(nbr2>13510798882111487 AND nbr2<18014398509481984) AND NOT(nbr3>13510798882111487 AND nbr3<18014398509481984) AND NOT(nbr4>13510798882111487 AND nbr4<18014398509481984))) ORDER BY first_name, last_name ASC;"); |
|
263 #else |
|
264 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE (nbr>13510798882111487 AND nbr<18014398509481984) OR (nbr2>13510798882111487 AND nbr2<18014398509481984) OR (nbr3>13510798882111487 AND nbr3<18014398509481984) OR (nbr4>13510798882111487 AND nbr4<18014398509481984) ORDER BY first_name, last_name ASC;"); |
|
265 #endif |
|
266 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
267 qDebug() << pattern << " -> result" << result; |
|
268 LOG2(pattern, result); |
|
269 QVERIFY(!result.compare( reference)); |
|
270 |
|
271 // Empty pattern |
|
272 pattern = QString(""); |
|
273 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
274 qDebug() << pattern << " -> result" << result; |
|
275 LOG2(pattern, result); |
|
276 QVERIFY(result.length() == 0); |
|
277 |
|
278 // Too long pattern (16 digits) |
|
279 pattern = QString("0123456789012345"); |
|
280 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
281 qDebug() << pattern << " -> result" << result; |
|
282 LOG2(pattern, result); |
|
283 QVERIFY(result.length() == 0); |
|
284 |
|
285 pattern = QString("0000000000000000"); // 16 zeros |
|
286 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
287 qDebug() << pattern << " -> result" << result; |
|
288 LOG2(pattern, result); |
|
289 QVERIFY(result.length() == 0); |
|
290 |
|
291 // Full of zeros |
|
292 pattern = QString("000000000000000"); // 15 zeros |
|
293 #if defined(USE_DEMORGAN) |
|
294 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE (NOT(NOT(nbr>-1 AND nbr<1) AND NOT(nbr2>-1 AND nbr2<1) AND NOT(nbr3>-1 AND nbr3<1) AND NOT(nbr4>-1 AND nbr4<1))) ORDER BY first_name, last_name ASC;"); |
|
295 #else |
|
296 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE (nbr>-1 AND nbr<1) OR (nbr2>-1 AND nbr2<1) OR (nbr3>-1 AND nbr3<1) OR (nbr4>-1 AND nbr4<1) ORDER BY first_name, last_name ASC;"); |
|
297 #endif |
|
298 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
299 qDebug() << pattern << " -> result" << result; |
|
300 LOG2(pattern, result); |
|
301 QVERIFY(!result.compare(reference)); |
|
302 |
|
303 // Full of nines |
|
304 pattern = QString("999999999999999"); // 15 nines |
|
305 #if defined(USE_DEMORGAN) |
|
306 reference = QString("SELECT contact_id FROM predictivesearch9 WHERE (NOT(NOT(nbr>691752902764108184 AND nbr<691752902764108186) AND NOT(nbr2>691752902764108184 AND nbr2<691752902764108186) AND NOT(nbr3>691752902764108184 AND nbr3<691752902764108186) AND NOT(nbr4>691752902764108184 AND nbr4<691752902764108186))) ORDER BY first_name, last_name ASC;"); |
|
307 #else |
|
308 reference = QString("SELECT contact_id FROM predictivesearch9 WHERE (nbr>691752902764108184 AND nbr<691752902764108186) OR (nbr2>691752902764108184 AND nbr2<691752902764108186) OR (nbr3>691752902764108184 AND nbr3<691752902764108186) OR (nbr4>691752902764108184 AND nbr4<691752902764108186) ORDER BY first_name, last_name ASC;"); |
|
309 #endif |
|
310 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
311 qDebug() << pattern << " -> result" << result; |
|
312 LOG2(pattern, result); |
|
313 QVERIFY(!result.compare(reference)); |
|
314 |
|
315 // Leading zeros |
|
316 pattern = QString("001100"); |
|
317 #if defined(USE_DEMORGAN) |
|
318 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE (NOT(NOT(nbr>299067162755071 AND nbr<299135882231808) AND NOT(nbr2>299067162755071 AND nbr2<299135882231808) AND NOT(nbr3>299067162755071 AND nbr3<299135882231808) AND NOT(nbr4>299067162755071 AND nbr4<299135882231808))) ORDER BY first_name, last_name ASC;"); |
|
319 #else |
|
320 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE (nbr>299067162755071 AND nbr<299135882231808) OR (nbr2>299067162755071 AND nbr2<299135882231808) OR (nbr3>299067162755071 AND nbr3<299135882231808) OR (nbr4>299067162755071 AND nbr4<299135882231808) ORDER BY first_name, last_name ASC;"); |
|
321 #endif |
|
322 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
323 qDebug() << pattern << " -> result" << result; |
|
324 LOG2(pattern, result); |
|
325 QVERIFY(!result.compare(reference)); |
|
326 |
|
327 pattern = QString("43043"); |
|
328 reference = QString("SELECT contact_id FROM predictivesearch4 WHERE NOT(NOT(NOT(NOT(nbr>301814842312884223 AND nbr<301815941824512000) AND NOT(nbr2>301814842312884223 AND nbr2<301815941824512000) AND NOT(nbr3>301814842312884223 AND nbr3<301815941824512000) AND NOT(nbr4>301814842312884223 AND nbr4<301815941824512000))) AND NOT(NOT(NOT(nbr2>301741175033823231 AND nbr2<306244774661193728 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr3>301741175033823231 AND nbr3<306244774661193728 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr3>301741175033823231 AND nbr3<306244774661193728 AND nbr2>301741175033823231 AND nbr2<306244774661193728) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr>301741175033823231 AND nbr<306244774661193728) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr2>301741175033823231 AND nbr2<306244774661193728) AND NOT(nbr4>301741175033823231 AND nbr4<306244774661193728 AND nbr3>301741175033823231 AND nbr3<306244774661193728)))) ORDER BY predictivesearch4.first_name, predictivesearch4.last_name ASC;"); |
|
329 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
330 qDebug() << pattern << " -> result" << result; |
|
331 LOG2(pattern, result); |
|
332 QVERIFY(!result.compare(reference)); |
|
333 |
|
334 pattern = QString("0020030"); |
|
335 #if defined(USE_DEMORGAN) |
|
336 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE NOT(NOT(NOT(NOT(nbr>563156111851519 AND nbr<563160406818816) AND NOT(nbr2>563156111851519 AND nbr2<563160406818816) AND NOT(nbr3>563156111851519 AND nbr3<563160406818816) AND NOT(nbr4>563156111851519 AND nbr4<563160406818816))) AND NOT(NOT(NOT(nbr2>216172782113783807 AND nbr2<220676381741154304 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr3>216172782113783807 AND nbr3<220676381741154304 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr3>216172782113783807 AND nbr3<220676381741154304 AND nbr2>562949953421311 AND nbr2<844424930131968) AND NOT(nbr4>216172782113783807 AND nbr4<220676381741154304 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr4>216172782113783807 AND nbr4<220676381741154304 AND nbr2>562949953421311 AND nbr2<844424930131968) AND NOT(nbr4>216172782113783807 AND nbr4<220676381741154304 AND nbr3>562949953421311 AND nbr3<844424930131968))) AND NOT(NOT(NOT(nbr2>562949953421311 AND nbr2<844424930131968 AND nbr>216172782113783807 AND nbr<220676381741154304) AND NOT(nbr3>562949953421311 AND nbr3<844424930131968 AND nbr>216172782113783807 AND nbr<220676381741154304) AND NOT(nbr3>562949953421311 AND nbr3<844424930131968 AND nbr2>216172782113783807 AND nbr2<220676381741154304) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr>216172782113783807 AND nbr<220676381741154304) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr2>216172782113783807 AND nbr2<220676381741154304) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr3>216172782113783807 AND nbr3<220676381741154304)))) ORDER BY predictivesearch0.first_name, predictivesearch0.last_name ASC;"); |
|
337 #else |
|
338 // TODO: add non-De Morgan case |
|
339 #endif |
|
340 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
341 qDebug() << pattern << " -> result" << result; |
|
342 LOG2(pattern, result); |
|
343 QVERIFY(!result.compare(reference)); |
|
344 |
|
345 pattern = QString("00430001020"); |
|
346 #if defined(USE_DEMORGAN) |
|
347 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE NOT(NOT(NOT(NOT(nbr>1178676735508479 AND nbr<1178676735574016) AND NOT(nbr2>1178676735508479 AND nbr2<1178676735574016) AND NOT(nbr3>1178676735508479 AND nbr3<1178676735574016) AND NOT(nbr4>1178676735508479 AND nbr4<1178676735574016))) AND NOT(NOT(NOT(nbr2>72620543991349247 AND nbr2<72638136177393664 AND nbr>1178676464975871 AND nbr<1196268651020288) AND NOT(nbr3>72620543991349247 AND nbr3<72638136177393664 AND nbr>1178676464975871 AND nbr<1196268651020288) AND NOT(nbr3>72620543991349247 AND nbr3<72638136177393664 AND nbr2>1178676464975871 AND nbr2<1196268651020288) AND NOT(nbr4>72620543991349247 AND nbr4<72638136177393664 AND nbr>1178676464975871 AND nbr<1196268651020288) AND NOT(nbr4>72620543991349247 AND nbr4<72638136177393664 AND nbr2>1178676464975871 AND nbr2<1196268651020288) AND NOT(nbr4>72620543991349247 AND nbr4<72638136177393664 AND nbr3>1178676464975871 AND nbr3<1196268651020288))) AND NOT(NOT(NOT(nbr2>1178676464975871 AND nbr2<1196268651020288 AND nbr>72620543991349247 AND nbr<72638136177393664) AND NOT(nbr3>1178676464975871 AND nbr3<1196268651020288 AND nbr>72620543991349247 AND nbr<72638136177393664) AND NOT(nbr3>1178676464975871 AND nbr3<1196268651020288 AND nbr2>72620543991349247 AND nbr2<72638136177393664) AND NOT(nbr4>1178676464975871 AND nbr4<1196268651020288 AND nbr>72620543991349247 AND nbr<72638136177393664) AND NOT(nbr4>1178676464975871 AND nbr4<1196268651020288 AND nbr2>72620543991349247 AND nbr2<72638136177393664) AND NOT(nbr4>1178676464975871 AND nbr4<1196268651020288 AND nbr3>72620543991349247 AND nbr3<72638136177393664)))) ORDER BY predictivesearch0.first_name, predictivesearch0.last_name ASC;"); |
|
348 #else |
|
349 // TODO: add non-De Morgan case |
|
350 #endif |
|
351 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
352 qDebug() << pattern << " -> result" << result; |
|
353 LOG2(pattern, result); |
|
354 QVERIFY(!result.compare(reference)); |
|
355 |
|
356 pattern = QString("227264583788306"); // 15 digits |
|
357 #if defined(USE_DEMORGAN) |
|
358 reference = QString("SELECT contact_id FROM predictivesearch2 WHERE NOT(NOT(NOT(NOT(nbr>155134792167883525 AND nbr<155134792167883527) AND NOT(nbr2>155134792167883525 AND nbr2<155134792167883527) AND NOT(nbr3>155134792167883525 AND nbr3<155134792167883527) AND NOT(nbr4>155134792167883525 AND nbr4<155134792167883527))) AND NOT(NOT(NOT(nbr2>432345564227567615 AND nbr2<504403158265495552 AND nbr>155134792167883519 AND nbr<155134792167883776) AND NOT(nbr3>432345564227567615 AND nbr3<504403158265495552 AND nbr>155134792167883519 AND nbr<155134792167883776) AND NOT(nbr3>432345564227567615 AND nbr3<504403158265495552 AND nbr2>155134792167883519 AND nbr2<155134792167883776) AND NOT(nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr>155134792167883519 AND nbr<155134792167883776) AND NOT(nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr2>155134792167883519 AND nbr2<155134792167883776) AND NOT(nbr4>432345564227567615 AND nbr4<504403158265495552 AND nbr3>155134792167883519 AND nbr3<155134792167883776))) AND NOT(NOT(NOT(nbr2>155134792167883519 AND nbr2<155134792167883776 AND nbr>432345564227567615 AND nbr<504403158265495552) AND NOT(nbr3>155134792167883519 AND nbr3<155134792167883776 AND nbr>432345564227567615 AND nbr<504403158265495552) AND NOT(nbr3>155134792167883519 AND nbr3<155134792167883776 AND nbr2>432345564227567615 AND nbr2<504403158265495552) AND NOT(nbr4>155134792167883519 AND nbr4<155134792167883776 AND nbr>432345564227567615 AND nbr<504403158265495552) AND NOT(nbr4>155134792167883519 AND nbr4<155134792167883776 AND nbr2>432345564227567615 AND nbr2<504403158265495552) AND NOT(nbr4>155134792167883519 AND nbr4<155134792167883776 AND nbr3>432345564227567615 AND nbr3<504403158265495552)))) ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
359 #else |
|
360 // TODO: add non-De Morgan case |
|
361 #endif |
|
362 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
363 qDebug() << pattern << " -> result" << result; |
|
364 LOG2(pattern, result); |
|
365 QVERIFY(!result.compare(reference)); |
|
366 |
|
367 |
|
368 pattern = QString("34096"); |
|
369 #if defined(USE_DEMORGAN) |
|
370 reference = QString("SELECT contact_id FROM predictivesearch3 WHERE NOT(NOT(NOT(NOT(nbr>234352107367432191 AND nbr<234353206879059968) AND NOT(nbr2>234352107367432191 AND nbr2<234353206879059968) AND NOT(nbr3>234352107367432191 AND nbr3<234353206879059968) AND NOT(nbr4>234352107367432191 AND nbr4<234353206879059968))) AND NOT(NOT(NOT(nbr2>675539944105574399 AND nbr2<680043543732944896 AND nbr>234187180623265791 AND nbr<238690780250636288) AND NOT(nbr3>675539944105574399 AND nbr3<680043543732944896 AND nbr>234187180623265791 AND nbr<238690780250636288) AND NOT(nbr3>675539944105574399 AND nbr3<680043543732944896 AND nbr2>234187180623265791 AND nbr2<238690780250636288) AND NOT(nbr4>675539944105574399 AND nbr4<680043543732944896 AND nbr>234187180623265791 AND nbr<238690780250636288) AND NOT(nbr4>675539944105574399 AND nbr4<680043543732944896 AND nbr2>234187180623265791 AND nbr2<238690780250636288) AND NOT(nbr4>675539944105574399 AND nbr4<680043543732944896 AND nbr3>234187180623265791 AND nbr3<238690780250636288))) AND NOT(NOT(NOT(nbr2>234187180623265791 AND nbr2<238690780250636288 AND nbr>675539944105574399 AND nbr<680043543732944896) AND NOT(nbr3>234187180623265791 AND nbr3<238690780250636288 AND nbr>675539944105574399 AND nbr<680043543732944896) AND NOT(nbr3>234187180623265791 AND nbr3<238690780250636288 AND nbr2>675539944105574399 AND nbr2<680043543732944896) AND NOT(nbr4>234187180623265791 AND nbr4<238690780250636288 AND nbr>675539944105574399 AND nbr<680043543732944896) AND NOT(nbr4>234187180623265791 AND nbr4<238690780250636288 AND nbr2>675539944105574399 AND nbr2<680043543732944896) AND NOT(nbr4>234187180623265791 AND nbr4<238690780250636288 AND nbr3>675539944105574399 AND nbr3<680043543732944896)))) ORDER BY predictivesearch3.first_name, predictivesearch3.last_name ASC;"); |
|
371 #else |
|
372 // TODO: add non-De Morgan case |
|
373 #endif |
|
374 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
375 qDebug() << pattern << " -> result" << result; |
|
376 LOG2(pattern, result); |
|
377 QVERIFY(!result.compare(reference)); |
|
378 |
|
379 pattern = QString("522000000000007"); // 15 digits |
|
380 #if defined(USE_DEMORGAN) |
|
381 reference = QString("SELECT contact_id FROM predictivesearch5 WHERE NOT(NOT(NOT(NOT(nbr>369858119397801990 AND nbr<369858119397801992) AND NOT(nbr2>369858119397801990 AND nbr2<369858119397801992) AND NOT(nbr3>369858119397801990 AND nbr3<369858119397801992) AND NOT(nbr4>369858119397801990 AND nbr4<369858119397801992))) AND NOT(NOT(NOT(nbr2>504403158265495551 AND nbr2<576460752303423488 AND nbr>369858119397801983 AND nbr<370139594374512640) AND NOT(nbr3>504403158265495551 AND nbr3<576460752303423488 AND nbr>369858119397801983 AND nbr<370139594374512640) AND NOT(nbr3>504403158265495551 AND nbr3<576460752303423488 AND nbr2>369858119397801983 AND nbr2<370139594374512640) AND NOT(nbr4>504403158265495551 AND nbr4<576460752303423488 AND nbr>369858119397801983 AND nbr<370139594374512640) AND NOT(nbr4>504403158265495551 AND nbr4<576460752303423488 AND nbr2>369858119397801983 AND nbr2<370139594374512640) AND NOT(nbr4>504403158265495551 AND nbr4<576460752303423488 AND nbr3>369858119397801983 AND nbr3<370139594374512640))) AND NOT(NOT(NOT(nbr2>369858119397801983 AND nbr2<370139594374512640 AND nbr>504403158265495551 AND nbr<576460752303423488) AND NOT(nbr3>369858119397801983 AND nbr3<370139594374512640 AND nbr>504403158265495551 AND nbr<576460752303423488) AND NOT(nbr3>369858119397801983 AND nbr3<370139594374512640 AND nbr2>504403158265495551 AND nbr2<576460752303423488) AND NOT(nbr4>369858119397801983 AND nbr4<370139594374512640 AND nbr>504403158265495551 AND nbr<576460752303423488) AND NOT(nbr4>369858119397801983 AND nbr4<370139594374512640 AND nbr2>504403158265495551 AND nbr2<576460752303423488) AND NOT(nbr4>369858119397801983 AND nbr4<370139594374512640 AND nbr3>504403158265495551 AND nbr3<576460752303423488)))) ORDER BY predictivesearch5.first_name, predictivesearch5.last_name ASC;"); |
|
382 #else |
|
383 // TODO: add non-De Morgan case |
|
384 #endif |
|
385 result = mCntSqlSearch->CreatePredictiveSearch(pattern); |
|
386 qDebug() << pattern << " -> result" << result; |
|
387 LOG2(pattern, result); |
|
388 QVERIFY(!result.compare(reference)); |
|
389 |
|
390 TEST_PASSED_LOG("testPredictiveSearch"); |
|
391 } |
|
392 |
|
393 void UT_CntSqlSearch::testSelectTableView() |
|
394 { |
|
395 TEST_BEGIN_LOG("testSelectTableView"); |
|
396 |
|
397 QString pattern = QString("0"); |
|
398 QString reference = QString("predictivesearch0"); |
|
399 QString result = mCntSqlSearch->SelectTable(pattern); |
|
400 QVERIFY( !result.compare( reference) ); |
|
401 |
|
402 pattern = QString("1"); |
|
403 reference = QString("predictivesearch1"); |
|
404 result = mCntSqlSearch->SelectTable(pattern); |
|
405 QVERIFY( !result.compare( reference) ); |
|
406 |
|
407 pattern = QString("2"); |
|
408 reference = QString("predictivesearch2"); |
|
409 result = mCntSqlSearch->SelectTable(pattern); |
|
410 QVERIFY( !result.compare( reference) ); |
|
411 |
|
412 pattern = QString("3"); |
|
413 reference = QString("predictivesearch3"); |
|
414 result = mCntSqlSearch->SelectTable(pattern); |
|
415 QVERIFY( !result.compare( reference) ); |
|
416 |
|
417 pattern = QString("4"); |
|
418 reference = QString("predictivesearch4"); |
|
419 result = mCntSqlSearch->SelectTable(pattern); |
|
420 QVERIFY( !result.compare( reference) ); |
|
421 |
|
422 pattern = QString("5"); |
|
423 reference = QString("predictivesearch5"); |
|
424 result = mCntSqlSearch->SelectTable(pattern); |
|
425 QVERIFY( !result.compare( reference) ); |
|
426 |
|
427 pattern = QString("6"); |
|
428 reference = QString("predictivesearch6"); |
|
429 result = mCntSqlSearch->SelectTable(pattern); |
|
430 QVERIFY( !result.compare( reference) ); |
|
431 |
|
432 pattern = QString("7"); |
|
433 reference = QString("predictivesearch7"); |
|
434 result = mCntSqlSearch->SelectTable(pattern); |
|
435 QVERIFY( !result.compare( reference) ); |
|
436 |
|
437 pattern = QString("8"); |
|
438 reference = QString("predictivesearch8"); |
|
439 result = mCntSqlSearch->SelectTable(pattern); |
|
440 QVERIFY( !result.compare( reference) ); |
|
441 |
|
442 pattern = QString("9"); |
|
443 reference = QString("predictivesearch9"); |
|
444 result = mCntSqlSearch->SelectTable(pattern); |
|
445 QVERIFY( !result.compare( reference) ); |
|
446 |
|
447 pattern = QString("09"); |
|
448 reference = QString("predictivesearch0"); |
|
449 result = mCntSqlSearch->SelectTable(pattern); |
|
450 QVERIFY( !result.compare( reference) ); |
|
451 |
|
452 pattern = QString("090"); |
|
453 reference = QString("predictivesearch0"); |
|
454 result = mCntSqlSearch->SelectTable(pattern); |
|
455 QVERIFY( !result.compare( reference) ); |
|
456 |
|
457 pattern = QString("909"); |
|
458 reference = QString("predictivesearch9"); |
|
459 result = mCntSqlSearch->SelectTable(pattern); |
|
460 QVERIFY( !result.compare( reference) ); |
|
461 |
|
462 pattern = QString("99"); |
|
463 reference = QString("predictivesearch9"); |
|
464 result = mCntSqlSearch->SelectTable(pattern); |
|
465 QVERIFY( !result.compare( reference) ); |
|
466 |
|
467 pattern = QString("000"); |
|
468 reference = QString("predictivesearch0"); |
|
469 result = mCntSqlSearch->SelectTable(pattern); |
|
470 QVERIFY( !result.compare( reference) ); |
|
471 |
|
472 TEST_PASSED_LOG("testSelectTableView"); |
|
473 } |
|
474 |
|
475 void UT_CntSqlSearch::testCreateQuery() |
|
476 { |
|
477 TEST_BEGIN_LOG("testCreateQuery"); |
|
478 QString pattern = QString("102"); |
|
479 |
|
480 #if defined(SEARCH_FROM_ONE_TABLE) |
|
481 #if defined(USE_DEMORGAN) |
|
482 QString reference("SELECT contact_id FROM predictivesearch1 WHERE NOT(NOT(NOT(NOT(nbr>72620543991349247 AND nbr<72902018968059904) AND NOT(nbr2>72620543991349247 AND nbr2<72902018968059904) AND NOT(nbr3>72620543991349247 AND nbr3<72902018968059904) AND NOT(nbr4>72620543991349247 AND nbr4<72902018968059904))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>72057594037927935 AND nbr2<144115188075855872) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>72057594037927935 AND nbr<144115188075855872) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>72057594037927935 AND nbr2<144115188075855872) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>72057594037927935 AND nbr3<144115188075855872))) AND NOT(NOT(NOT(nbr2>72057594037927935 AND nbr2<144115188075855872 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr3>144115188075855871 AND nbr3<216172782113783808)))) ORDER BY predictivesearch1.first_name, predictivesearch1.last_name ASC;"); |
|
483 #else // #if defined(USE_DEMORGAN) |
|
484 QString reference("SELECT contact_id FROM predictivesearch1 WHERE \ |
|
485 ((nbr>72620543991349247 AND nbr<72902018968059904) OR \ |
|
486 (nbr2>72620543991349247 AND nbr2<72902018968059904) OR \ |
|
487 (nbr3>72620543991349247 AND nbr3<72902018968059904) OR \ |
|
488 (nbr4>72620543991349247 AND nbr4<72902018968059904)) OR \ |
|
489 (nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>72057594037927935 AND nbr<144115188075855872) OR \ |
|
490 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>72057594037927935 AND nbr<144115188075855872) OR \ |
|
491 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>72057594037927935 AND nbr2<144115188075855872) OR \ |
|
492 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>72057594037927935 AND nbr<144115188075855872) OR \ |
|
493 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>72057594037927935 AND nbr2<144115188075855872) OR \ |
|
494 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>72057594037927935 AND nbr3<144115188075855872) OR \ |
|
495 (nbr2>72057594037927935 AND nbr2<144115188075855872 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
496 (nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
497 (nbr3>72057594037927935 AND nbr3<144115188075855872 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
498 (nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
499 (nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
500 (nbr4>72057594037927935 AND nbr4<144115188075855872 AND nbr3>144115188075855871 AND nbr3<216172782113783808) \ |
|
501 ORDER BY predictivesearch1.first_name, predictivesearch1.last_name ASC;"); |
|
502 #endif // #if defined(USE_DEMORGAN) |
|
503 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
504 QString reference("SELECT predictivesearch1.contact_id FROM predictivesearch1 WHERE EXISTS (SELECT contact_id FROM predictivesearch2 WHERE predictivesearch1.contact_id = predictivesearch2.contact_id) OR (SELECT contact_id FROM predictivesearch1 WHERE (NOT(NOT(predictivesearch1.nbr>72620543991349247 AND predictivesearch1.nbr<72902018968059904) AND NOT(predictivesearch1.nbr2>72620543991349247 AND predictivesearch1.nbr2<72902018968059904) AND NOT(predictivesearch1.nbr3>72620543991349247 AND predictivesearch1.nbr3<72902018968059904) AND NOT(predictivesearch1.nbr4>72620543991349247 AND predictivesearch1.nbr4<72902018968059904)))) ORDER BY predictivesearch1.first_name, predictivesearch1.last_name ASC;"); |
|
505 #endif // #if defined(SEARCH_FROM_ONE_TABLE) |
|
506 QString result = mCntSqlSearch->CreateQuery(pattern); |
|
507 //qDebug() << pattern << " -> result" << result; |
|
508 //TODO: Fix test result |
|
509 LOG2(pattern, result); |
|
510 QVERIFY(!result.compare(reference)); |
|
511 |
|
512 pattern = QString("00202"); |
|
513 #if defined(SEARCH_FROM_ONE_TABLE) |
|
514 #if defined(USE_DEMORGAN) |
|
515 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE NOT(NOT(NOT(NOT(nbr>565148976676863 AND nbr<566248488304640) AND NOT(nbr2>565148976676863 AND nbr2<566248488304640) AND NOT(nbr3>565148976676863 AND nbr3<566248488304640) AND NOT(nbr4>565148976676863 AND nbr4<566248488304640))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>562949953421311 AND nbr2<844424930131968) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>562949953421311 AND nbr2<844424930131968) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>562949953421311 AND nbr3<844424930131968))) AND NOT(NOT(NOT(nbr2>562949953421311 AND nbr2<844424930131968 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>562949953421311 AND nbr3<844424930131968 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>562949953421311 AND nbr3<844424930131968 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr3>144115188075855871 AND nbr3<216172782113783808)))) ORDER BY predictivesearch0.first_name, predictivesearch0.last_name ASC;"); |
|
516 #else // #if defined(USE_DEMORGAN) |
|
517 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE \ |
|
518 ((nbr>565148976676863 AND nbr<566248488304640) OR \ |
|
519 (nbr2>565148976676863 AND nbr2<566248488304640) OR \ |
|
520 (nbr3>565148976676863 AND nbr3<566248488304640) OR \ |
|
521 (nbr4>565148976676863 AND nbr4<566248488304640)) OR \ |
|
522 (nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>562949953421311 AND nbr<844424930131968) OR \ |
|
523 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>562949953421311 AND nbr<844424930131968) OR \ |
|
524 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>562949953421311 AND nbr2<844424930131968) OR \ |
|
525 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>562949953421311 AND nbr<844424930131968) OR \ |
|
526 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>562949953421311 AND nbr2<844424930131968) OR \ |
|
527 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>562949953421311 AND nbr3<844424930131968) OR \ |
|
528 (nbr2>562949953421311 AND nbr2<844424930131968 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
529 (nbr3>562949953421311 AND nbr3<844424930131968 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
530 (nbr3>562949953421311 AND nbr3<844424930131968 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
531 (nbr4>562949953421311 AND nbr4<844424930131968 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
532 (nbr4>562949953421311 AND nbr4<844424930131968 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
533 (nbr4>562949953421311 AND nbr4<844424930131968 AND nbr3>144115188075855871 AND nbr3<216172782113783808) \ |
|
534 ORDER BY predictivesearch0.first_name, predictivesearch0.last_name ASC;"); |
|
535 #endif // #if defined(USE_DEMORGAN) |
|
536 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
537 // TODO: Test this case on HW and verify leading zeros. |
|
538 reference = QString("SELECT contact_id FROM (SELECT predictivesearch0.contact_id, predictivesearch0.first_name, predictivesearch0.last_name FROM predictivesearch0 WHERE (NOT(NOT(predictivesearch0.nbr>565148976676863 AND predictivesearch0.nbr<566248488304640) AND NOT(predictivesearch0.nbr2>565148976676863 AND predictivesearch0.nbr2<566248488304640) AND NOT(predictivesearch0.nbr3>565148976676863 AND predictivesearch0.nbr3<566248488304640) AND NOT(predictivesearch0.nbr4>565148976676863 AND predictivesearch0.nbr4<566248488304640))) UNION SELECT predictivesearch0.contact_id, predictivesearch0.first_name, predictivesearch0.last_name FROM predictivesearch0 JOIN predictivesearch2 ON predictivesearch0.contact_id = predictivesearch2.contact_id WHERE(NOT(NOT(predictivesearch0.nbr>562949953421311 AND predictivesearch0.nbr<844424930131968) AND NOT(predictivesearch0.nbr2>562949953421311 AND predictivesearch0.nbr2<844424930131968) AND NOT(predictivesearch0.nbr3>562949953421311 AND predictivesearch0.nbr3<844424930131968) AND NOT(predictivesearch0.nbr4>562949953421311 AND predictivesearch0.nbr4<844424930131968)))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
539 #endif // #if defined(SEARCH_FROM_ONE_TABLE) |
|
540 result = mCntSqlSearch->CreateQuery(pattern); |
|
541 qDebug() << pattern << " -> result" << result; |
|
542 LOG2(pattern, result); |
|
543 QVERIFY( !result.compare( reference) ); |
|
544 |
|
545 pattern = QString("202000"); |
|
546 #if defined(USE_DEMORGAN) |
|
547 // TODO: Test this case on HW and verify trailing zeros. |
|
548 reference = QString("SELECT contact_id FROM predictivesearch2 WHERE NOT(NOT(NOT(NOT(nbr>144678138029277183 AND nbr<144678206748753920) AND NOT(nbr2>144678138029277183 AND nbr2<144678206748753920) AND NOT(nbr3>144678138029277183 AND nbr3<144678206748753920) AND NOT(nbr4>144678138029277183 AND nbr4<144678206748753920))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<144132780261900288 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>144115188075855871 AND nbr3<144132780261900288 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>144115188075855871 AND nbr3<144132780261900288 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>144115188075855871 AND nbr4<144132780261900288 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr4>144115188075855871 AND nbr4<144132780261900288 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>144115188075855871 AND nbr4<144132780261900288 AND nbr3>144115188075855871 AND nbr3<216172782113783808))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>144115188075855871 AND nbr<144132780261900288) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>144115188075855871 AND nbr<144132780261900288) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>144115188075855871 AND nbr2<144132780261900288) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>144115188075855871 AND nbr<144132780261900288) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>144115188075855871 AND nbr2<144132780261900288) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>144115188075855871 AND nbr3<144132780261900288)))) ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
549 #else |
|
550 // TODO: add non-De Morgan version |
|
551 #endif |
|
552 |
|
553 /*reference = QString("SELECT contact_id FROM predictivesearch2 WHERE \ |
|
554 ((nbr>144678138029277183 AND nbr<144678206748753920) OR (nbr2>144678138029277183 AND nbr2<144678206748753920) OR \ |
|
555 (nbr3>144678138029277183 AND nbr3<144678206748753920) OR (nbr4>144678138029277183 AND nbr4<144678206748753920)) OR \ |
|
556 (nbr2>144115188075855871 AND nbr2<144132780261900288 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
557 (nbr3>144115188075855871 AND nbr3<144132780261900288 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
558 (nbr3>144115188075855871 AND nbr3<144132780261900288 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
559 (nbr4>144115188075855871 AND nbr4<144132780261900288 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
560 (nbr4>144115188075855871 AND nbr4<144132780261900288 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
561 (nbr4>144115188075855871 AND nbr4<144132780261900288 AND nbr3>144115188075855871 AND nbr3<216172782113783808) OR \ |
|
562 (nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>144115188075855871 AND nbr<144132780261900288) OR \ |
|
563 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>144115188075855871 AND nbr<144132780261900288) OR \ |
|
564 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>144115188075855871 AND nbr2<144132780261900288) OR \ |
|
565 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>144115188075855871 AND nbr<144132780261900288) OR \ |
|
566 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>144115188075855871 AND nbr2<144132780261900288) OR \ |
|
567 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>144115188075855871 AND nbr3<144132780261900288) \ |
|
568 ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;");*/ |
|
569 |
|
570 result = mCntSqlSearch->CreateQuery(pattern); |
|
571 qDebug() << pattern << " -> result" << result; |
|
572 LOG2(pattern, result); |
|
573 QVERIFY( !result.compare( reference) ); |
|
574 |
|
575 pattern = QString("0020200"); |
|
576 #if defined(SEARCH_FROM_ONE_TABLE) |
|
577 #if defined(USE_DEMORGAN) |
|
578 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE NOT(NOT(NOT(NOT(nbr>565148976676863 AND nbr<565153271644160) AND NOT(nbr2>565148976676863 AND nbr2<565153271644160) AND NOT(nbr3>565148976676863 AND nbr3<565153271644160) AND NOT(nbr4>565148976676863 AND nbr4<565153271644160))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<144396663052566528 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr3>144115188075855871 AND nbr3<144396663052566528 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr3>144115188075855871 AND nbr3<144396663052566528 AND nbr2>562949953421311 AND nbr2<844424930131968) AND NOT(nbr4>144115188075855871 AND nbr4<144396663052566528 AND nbr>562949953421311 AND nbr<844424930131968) AND NOT(nbr4>144115188075855871 AND nbr4<144396663052566528 AND nbr2>562949953421311 AND nbr2<844424930131968) AND NOT(nbr4>144115188075855871 AND nbr4<144396663052566528 AND nbr3>562949953421311 AND nbr3<844424930131968))) AND NOT(NOT(NOT(nbr2>562949953421311 AND nbr2<844424930131968 AND nbr>144115188075855871 AND nbr<144396663052566528) AND NOT(nbr3>562949953421311 AND nbr3<844424930131968 AND nbr>144115188075855871 AND nbr<144396663052566528) AND NOT(nbr3>562949953421311 AND nbr3<844424930131968 AND nbr2>144115188075855871 AND nbr2<144396663052566528) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr>144115188075855871 AND nbr<144396663052566528) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr2>144115188075855871 AND nbr2<144396663052566528) AND NOT(nbr4>562949953421311 AND nbr4<844424930131968 AND nbr3>144115188075855871 AND nbr3<144396663052566528)))) ORDER BY predictivesearch0.first_name, predictivesearch0.last_name ASC;"); |
|
579 #else // #if defined(USE_DEMORGAN) |
|
580 reference = QString("SELECT contact_id FROM predictivesearch0 WHERE \ |
|
581 ((nbr>565148976676863 AND nbr<565153271644160) OR (nbr2>565148976676863 AND nbr2<565153271644160) OR \ |
|
582 (nbr3>565148976676863 AND nbr3<565153271644160) OR (nbr4>565148976676863 AND nbr4<565153271644160)) OR \ |
|
583 (nbr2>144115188075855871 AND nbr2<144396663052566528 AND nbr>562949953421311 AND nbr<844424930131968) OR \ |
|
584 (nbr3>144115188075855871 AND nbr3<144396663052566528 AND nbr>562949953421311 AND nbr<844424930131968) OR \ |
|
585 (nbr3>144115188075855871 AND nbr3<144396663052566528 AND nbr2>562949953421311 AND nbr2<844424930131968) OR \ |
|
586 (nbr4>144115188075855871 AND nbr4<144396663052566528 AND nbr>562949953421311 AND nbr<844424930131968) OR \ |
|
587 (nbr4>144115188075855871 AND nbr4<144396663052566528 AND nbr2>562949953421311 AND nbr2<844424930131968) OR \ |
|
588 (nbr4>144115188075855871 AND nbr4<144396663052566528 AND nbr3>562949953421311 AND nbr3<844424930131968) OR \ |
|
589 (nbr2>562949953421311 AND nbr2<844424930131968 AND nbr>144115188075855871 AND nbr<144396663052566528) OR \ |
|
590 (nbr3>562949953421311 AND nbr3<844424930131968 AND nbr>144115188075855871 AND nbr<144396663052566528) OR \ |
|
591 (nbr3>562949953421311 AND nbr3<844424930131968 AND nbr2>144115188075855871 AND nbr2<144396663052566528) OR \ |
|
592 (nbr4>562949953421311 AND nbr4<844424930131968 AND nbr>144115188075855871 AND nbr<144396663052566528) OR \ |
|
593 (nbr4>562949953421311 AND nbr4<844424930131968 AND nbr2>144115188075855871 AND nbr2<144396663052566528) OR \ |
|
594 (nbr4>562949953421311 AND nbr4<844424930131968 AND nbr3>144115188075855871 AND nbr3<144396663052566528) \ |
|
595 ORDER BY predictivesearch0.first_name, predictivesearch0.last_name ASC;"); |
|
596 #endif // #if defined(USE_DEMORGAN) |
|
597 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
598 // TODO: Test this case on HW and verify leading zeros. |
|
599 reference = QString("SELECT contact_id FROM (SELECT predictivesearch0.contact_id, predictivesearch0.first_name, predictivesearch0.last_name FROM predictivesearch0 WHERE (NOT(NOT(predictivesearch0.nbr>565148976676863 AND predictivesearch0.nbr<565153271644160) AND NOT(predictivesearch0.nbr2>565148976676863 AND predictivesearch0.nbr2<565153271644160) AND NOT(predictivesearch0.nbr3>565148976676863 AND predictivesearch0.nbr3<565153271644160) AND NOT(predictivesearch0.nbr4>565148976676863 AND predictivesearch0.nbr4<565153271644160))) UNION SELECT predictivesearch0.contact_id, predictivesearch0.first_name, predictivesearch0.last_name FROM predictivesearch0 JOIN predictivesearch2 ON predictivesearch0.contact_id = predictivesearch2.contact_id WHERE((NOT(NOT(predictivesearch0.nbr>562949953421311 AND predictivesearch0.nbr<844424930131968) AND NOT(predictivesearch0.nbr2>562949953421311 AND predictivesearch0.nbr2<844424930131968) AND NOT(predictivesearch0.nbr3>562949953421311 AND predictivesearch0.nbr3<844424930131968) AND NOT(predictivesearch0.nbr4>562949953421311 AND predictivesearch0.nbr4<844424930131968))) AND (NOT(NOT(predictivesearch2.nbr>144115188075855871 AND predictivesearch2.nbr<144396663052566528) AND NOT(predictivesearch2.nbr2>144115188075855871 AND predictivesearch2.nbr2<144396663052566528) AND NOT(predictivesearch2.nbr3>144115188075855871 AND predictivesearch2.nbr3<144396663052566528) AND NOT(predictivesearch2.nbr4>144115188075855871 AND predictivesearch2.nbr4<144396663052566528))))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
600 #endif //#if defined(SEARCH_FROM_ONE_TABLE) |
|
601 result = mCntSqlSearch->CreateQuery(pattern); |
|
602 qDebug() << pattern << " -> result" << result; |
|
603 LOG2(pattern, result); |
|
604 QVERIFY( !result.compare( reference) ); |
|
605 |
|
606 pattern = QString("20322"); |
|
607 #if defined(SEARCH_FROM_ONE_TABLE) |
|
608 #if defined(USE_DEMORGAN) |
|
609 reference = QString("SELECT contact_id FROM predictivesearch2 WHERE NOT(NOT(NOT(NOT(nbr>144996996401332223 AND nbr<144998095912960000) AND NOT(nbr2>144996996401332223 AND nbr2<144998095912960000) AND NOT(nbr3>144996996401332223 AND nbr3<144998095912960000) AND NOT(nbr4>144996996401332223 AND nbr4<144998095912960000))) AND NOT(NOT(NOT(nbr2>225742931321946111 AND nbr2<226024406298656768 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>225742931321946111 AND nbr3<226024406298656768 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>225742931321946111 AND nbr3<226024406298656768 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>225742931321946111 AND nbr4<226024406298656768 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr4>225742931321946111 AND nbr4<226024406298656768 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>225742931321946111 AND nbr4<226024406298656768 AND nbr3>144115188075855871 AND nbr3<216172782113783808))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>225742931321946111 AND nbr<226024406298656768) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>225742931321946111 AND nbr<226024406298656768) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>225742931321946111 AND nbr2<226024406298656768) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>225742931321946111 AND nbr<226024406298656768) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>225742931321946111 AND nbr2<226024406298656768) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>225742931321946111 AND nbr3<226024406298656768)))) ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
610 #else // #if defined(USE_DEMORGAN) |
|
611 reference = QString("SELECT contact_id FROM predictivesearch2 WHERE \ |
|
612 ((nbr>144996996401332223 AND nbr<144998095912960000) OR (nbr2>144996996401332223 AND nbr2<144998095912960000) OR \ |
|
613 (nbr3>144996996401332223 AND nbr3<144998095912960000) OR (nbr4>144996996401332223 AND nbr4<144998095912960000)) OR \ |
|
614 (nbr2>225742931321946111 AND nbr2<226024406298656768 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
615 (nbr3>225742931321946111 AND nbr3<226024406298656768 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
616 (nbr3>225742931321946111 AND nbr3<226024406298656768 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
617 (nbr4>225742931321946111 AND nbr4<226024406298656768 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
618 (nbr4>225742931321946111 AND nbr4<226024406298656768 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
619 (nbr4>225742931321946111 AND nbr4<226024406298656768 AND nbr3>144115188075855871 AND nbr3<216172782113783808) OR \ |
|
620 (nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>225742931321946111 AND nbr<226024406298656768) OR \ |
|
621 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>225742931321946111 AND nbr<226024406298656768) OR \ |
|
622 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>225742931321946111 AND nbr2<226024406298656768) OR \ |
|
623 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>225742931321946111 AND nbr<226024406298656768) OR \ |
|
624 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>225742931321946111 AND nbr2<226024406298656768) OR \ |
|
625 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>225742931321946111 AND nbr3<226024406298656768) \ |
|
626 ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
627 #endif // #if defined(USE_DEMORGAN) |
|
628 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
629 reference = QString("SELECT contact_id FROM (SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 WHERE (NOT(NOT(predictivesearch2.nbr>144996996401332223 AND predictivesearch2.nbr<144998095912960000) AND NOT(predictivesearch2.nbr2>144996996401332223 AND predictivesearch2.nbr2<144998095912960000) AND NOT(predictivesearch2.nbr3>144996996401332223 AND predictivesearch2.nbr3<144998095912960000) AND NOT(predictivesearch2.nbr4>144996996401332223 AND predictivesearch2.nbr4<144998095912960000))) UNION SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 JOIN predictivesearch3 ON predictivesearch2.contact_id = predictivesearch3.contact_id WHERE(NOT(NOT(predictivesearch3.nbr>225742931321946111 AND predictivesearch3.nbr<226024406298656768) AND NOT(predictivesearch3.nbr2>225742931321946111 AND predictivesearch3.nbr2<226024406298656768) AND NOT(predictivesearch3.nbr3>225742931321946111 AND predictivesearch3.nbr3<226024406298656768) AND NOT(predictivesearch3.nbr4>225742931321946111 AND predictivesearch3.nbr4<226024406298656768)))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
630 #endif // #if defined(SEARCH_FROM_ONE_TABLE) |
|
631 result = mCntSqlSearch->CreateQuery(pattern); |
|
632 qDebug() << pattern << " -> result" << result; |
|
633 LOG2(pattern, result); |
|
634 QVERIFY( !result.compare( reference) ); |
|
635 |
|
636 TEST_PASSED_LOG("testCreateQuery"); |
|
637 } |
|
638 |
|
639 void UT_CntSqlSearch::testExactMatchSearch() |
|
640 { |
|
641 TEST_BEGIN_LOG("testExactMatchSearch"); |
|
642 |
|
643 QString pattern("120"); |
|
644 #if defined(USE_DEMORGAN) |
|
645 QString reference("SELECT contact_id FROM predictivesearch1 WHERE (NOT(NOT(nbr>81064793292668927 AND nbr<81346268269379584) AND NOT(nbr2>81064793292668927 AND nbr2<81346268269379584) AND NOT(nbr3>81064793292668927 AND nbr3<81346268269379584) AND NOT(nbr4>81064793292668927 AND nbr4<81346268269379584)))"); |
|
646 #else // #if defined(USE_DEMORGAN) |
|
647 QString reference("SELECT contact_id FROM predictivesearch1 WHERE (nbr>81064793292668927 AND nbr<81346268269379584) OR (nbr2>81064793292668927 AND nbr2<81346268269379584) OR (nbr3>81064793292668927 AND nbr3<81346268269379584) OR (nbr4>81064793292668927 AND nbr4<81346268269379584)"); |
|
648 #endif // #if defined(USE_DEMORGAN) |
|
649 QString result = mCntSqlSearch->ExactMatchSearch(pattern); |
|
650 // qDebug() << pattern << " -> result" << result; |
|
651 LOG2(pattern, result); |
|
652 QVERIFY(result == reference); |
|
653 |
|
654 |
|
655 pattern = QString("5"); |
|
656 #if defined(USE_DEMORGAN) |
|
657 reference = "SELECT contact_id FROM predictivesearch5 WHERE (NOT(NOT(nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr2>360287970189639679 AND nbr2<432345564227567616) AND NOT(nbr3>360287970189639679 AND nbr3<432345564227567616) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616)))"; |
|
658 #else // #if defined(USE_DEMORGAN) |
|
659 reference = "SELECT contact_id FROM predictivesearch5 WHERE (nbr>360287970189639679 AND nbr<432345564227567616) OR (nbr2>360287970189639679 AND nbr2<432345564227567616) OR (nbr3>360287970189639679 AND nbr3<432345564227567616) OR (nbr4>360287970189639679 AND nbr4<432345564227567616)"; |
|
660 #endif // #if defined(USE_DEMORGAN) |
|
661 result = mCntSqlSearch->ExactMatchSearch(pattern); |
|
662 // qDebug() << pattern << " -> result" << result; |
|
663 LOG2(pattern, result); |
|
664 QVERIFY(result == reference); |
|
665 |
|
666 |
|
667 pattern = QString("25"); |
|
668 #if defined(USE_DEMORGAN) |
|
669 reference = "SELECT contact_id FROM predictivesearch2 WHERE (NOT(NOT(nbr>166633186212708351 AND nbr<171136785840078848) AND NOT(nbr2>166633186212708351 AND nbr2<171136785840078848) AND NOT(nbr3>166633186212708351 AND nbr3<171136785840078848) AND NOT(nbr4>166633186212708351 AND nbr4<171136785840078848)))"; |
|
670 #else // #if defined(USE_DEMORGAN) |
|
671 reference = "SELECT contact_id FROM predictivesearch2 WHERE (nbr>166633186212708351 AND nbr<171136785840078848) OR (nbr2>166633186212708351 AND nbr2<171136785840078848) OR (nbr3>166633186212708351 AND nbr3<171136785840078848) OR (nbr4>166633186212708351 AND nbr4<171136785840078848)"; |
|
672 #endif // #if defined(USE_DEMORGAN) |
|
673 result = mCntSqlSearch->ExactMatchSearch(pattern); |
|
674 // qDebug() << pattern << " -> result" << result; |
|
675 LOG2(pattern, result); |
|
676 QVERIFY(result == reference); |
|
677 |
|
678 TEST_PASSED_LOG("testExactMatchSearch"); |
|
679 } |
|
680 |
|
681 void UT_CntSqlSearch::testIntersectionSearch() |
|
682 { |
|
683 TEST_BEGIN_LOG("testIntersectionSearch"); |
|
684 |
|
685 QString pattern("205"); |
|
686 QStringList tokens; |
|
687 tokens << "2" << "5"; |
|
688 #if defined(SEARCH_FROM_ONE_TABLE) |
|
689 #if defined(USE_DEMORGAN) |
|
690 QString reference("SELECT contact_id FROM predictivesearch2 WHERE NOT(NOT(NOT(NOT(nbr>145522562959409151 AND nbr<145804037936119808) AND NOT(nbr2>145522562959409151 AND nbr2<145804037936119808) AND NOT(nbr3>145522562959409151 AND nbr3<145804037936119808) AND NOT(nbr4>145522562959409151 AND nbr4<145804037936119808))) AND NOT(NOT(NOT(nbr2>360287970189639679 AND nbr2<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr2>144115188075855871 AND nbr2<216172782113783808) AND NOT(nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr3>144115188075855871 AND nbr3<216172782113783808))) AND NOT(NOT(NOT(nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>360287970189639679 AND nbr2<432345564227567616) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>360287970189639679 AND nbr2<432345564227567616) AND NOT(nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>360287970189639679 AND nbr3<432345564227567616)))) ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
691 #else // #if defined(USE_DEMORGAN) |
|
692 QString reference("SELECT contact_id FROM predictivesearch2 WHERE \ |
|
693 ((nbr>145522562959409151 AND nbr<145804037936119808) OR (nbr2>145522562959409151 AND nbr2<145804037936119808) OR \ |
|
694 (nbr3>145522562959409151 AND nbr3<145804037936119808) OR (nbr4>145522562959409151 AND nbr4<145804037936119808)) OR \ |
|
695 (nbr2>360287970189639679 AND nbr2<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
696 (nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
697 (nbr3>360287970189639679 AND nbr3<432345564227567616 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
698 (nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr>144115188075855871 AND nbr<216172782113783808) OR \ |
|
699 (nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr2>144115188075855871 AND nbr2<216172782113783808) OR \ |
|
700 (nbr4>360287970189639679 AND nbr4<432345564227567616 AND nbr3>144115188075855871 AND nbr3<216172782113783808) OR \ |
|
701 (nbr2>144115188075855871 AND nbr2<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) OR \ |
|
702 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) OR \ |
|
703 (nbr3>144115188075855871 AND nbr3<216172782113783808 AND nbr2>360287970189639679 AND nbr2<432345564227567616) OR \ |
|
704 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr>360287970189639679 AND nbr<432345564227567616) OR \ |
|
705 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr2>360287970189639679 AND nbr2<432345564227567616) OR \ |
|
706 (nbr4>144115188075855871 AND nbr4<216172782113783808 AND nbr3>360287970189639679 AND nbr3<432345564227567616) \ |
|
707 ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
708 #endif // #if defined(USE_DEMORGAN) |
|
709 #else // #if defined(SEARCH_FROM_ONE_TABLE) |
|
710 QString reference("SELECT predictivesearch2.contact_id FROM predictivesearch2 WHERE EXISTS (SELECT contact_id FROM predictivesearch5 WHERE predictivesearch2.contact_id = predictivesearch5.contact_id) OR (SELECT contact_id FROM predictivesearch2 WHERE (NOT(NOT(predictivesearch2.nbr>145522562959409151 AND predictivesearch2.nbr<145804037936119808) AND NOT(predictivesearch2.nbr2>145522562959409151 AND predictivesearch2.nbr2<145804037936119808) AND NOT(predictivesearch2.nbr3>145522562959409151 AND predictivesearch2.nbr3<145804037936119808) AND NOT(predictivesearch2.nbr4>145522562959409151 AND predictivesearch2.nbr4<145804037936119808)))) ORDER BY predictivesearch2.first_name, predictivesearch2.last_name ASC;"); |
|
711 #endif // #if defined(SEARCH_FROM_ONE_TABLE) |
|
712 QString result = mCntSqlSearch->IntersectionSearch(pattern, tokens); |
|
713 // qDebug() << pattern << " -> result" << result; |
|
714 LOG2(pattern, result); |
|
715 QVERIFY( !result.compare( reference) ); |
|
716 |
|
717 TEST_PASSED_LOG("testIntersectionSearch"); |
|
718 } |
|
719 |
|
720 void UT_CntSqlSearch::testExactMatch() |
|
721 { |
|
722 TEST_BEGIN_LOG("testExactMatch"); |
|
723 |
|
724 QString pattern("25"); |
|
725 #if defined(USE_DEMORGAN) |
|
726 QString reference("(NOT(NOT(nbr>166633186212708351 AND nbr<171136785840078848) AND NOT(nbr2>166633186212708351 AND nbr2<171136785840078848) AND NOT(nbr3>166633186212708351 AND nbr3<171136785840078848) AND NOT(nbr4>166633186212708351 AND nbr4<171136785840078848)))"); |
|
727 #else // #if defined(USE_DEMORGAN) |
|
728 QString reference("(nbr>166633186212708351 AND nbr<171136785840078848) OR (nbr2>166633186212708351 AND nbr2<171136785840078848) OR (nbr3>166633186212708351 AND nbr3<171136785840078848) OR (nbr4>166633186212708351 AND nbr4<171136785840078848)"); |
|
729 #endif // #if defined(USE_DEMORGAN) |
|
730 QString result = mCntSqlSearch->ExactMatch(pattern); |
|
731 // LOG2(pattern, result); |
|
732 QVERIFY(!result.compare(reference)); |
|
733 |
|
734 TEST_PASSED_LOG("testExactMatch"); |
|
735 } |
|
736 |
|
737 void UT_CntSqlSearch::testCreateJoinTableSearch() |
|
738 { |
|
739 TEST_BEGIN_LOG("testCreateJoinTableSearch"); |
|
740 |
|
741 QString pattern("5606"); |
|
742 QStringList tokens; |
|
743 tokens << "56" << "6"; |
|
744 #if defined(USE_DEMORGAN) |
|
745 QString reference("SELECT contact_id FROM (SELECT predictivesearch5.contact_id, predictivesearch5.first_name, predictivesearch5.last_name FROM predictivesearch5 WHERE (NOT(NOT(predictivesearch5.nbr>387415121070129151 AND predictivesearch5.nbr<387432713256173568) AND NOT(predictivesearch5.nbr2>387415121070129151 AND predictivesearch5.nbr2<387432713256173568) AND NOT(predictivesearch5.nbr3>387415121070129151 AND predictivesearch5.nbr3<387432713256173568) AND NOT(predictivesearch5.nbr4>387415121070129151 AND predictivesearch5.nbr4<387432713256173568))) UNION SELECT predictivesearch5.contact_id, predictivesearch5.first_name, predictivesearch5.last_name FROM predictivesearch5 JOIN predictivesearch6 ON predictivesearch5.contact_id = predictivesearch6.contact_id WHERE(NOT(NOT(predictivesearch5.nbr>387309567953862655 AND predictivesearch5.nbr<391813167581233152) AND NOT(predictivesearch5.nbr2>387309567953862655 AND predictivesearch5.nbr2<391813167581233152) AND NOT(predictivesearch5.nbr3>387309567953862655 AND predictivesearch5.nbr3<391813167581233152) AND NOT(predictivesearch5.nbr4>387309567953862655 AND predictivesearch5.nbr4<391813167581233152)))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
746 #else // #if defined(USE_DEMORGAN) |
|
747 // TODO: add non-De Morgan cases |
|
748 #endif // #if defined(USE_DEMORGAN) |
|
749 QString result = mCntSqlSearch->CreateJoinTableSearch(pattern, tokens); |
|
750 //qDebug() << pattern << " -> result" << result; |
|
751 LOG2(pattern, result); |
|
752 QVERIFY(!result.compare(reference)); |
|
753 |
|
754 pattern = QString ("250052"); |
|
755 tokens.clear(); |
|
756 tokens << "25" << "52"; |
|
757 #if defined(USE_DEMORGAN) |
|
758 reference = QString("SELECT contact_id FROM (SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 WHERE (NOT(NOT(predictivesearch2.nbr>166638821209800703 AND predictivesearch2.nbr<166638889929277440) AND NOT(predictivesearch2.nbr2>166638821209800703 AND predictivesearch2.nbr2<166638889929277440) AND NOT(predictivesearch2.nbr3>166638821209800703 AND predictivesearch2.nbr3<166638889929277440) AND NOT(predictivesearch2.nbr4>166638821209800703 AND predictivesearch2.nbr4<166638889929277440))) UNION SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 JOIN predictivesearch5 ON predictivesearch2.contact_id = predictivesearch5.contact_id WHERE((NOT(NOT(predictivesearch2.nbr>166633186212708351 AND predictivesearch2.nbr<171136785840078848) AND NOT(predictivesearch2.nbr2>166633186212708351 AND predictivesearch2.nbr2<171136785840078848) AND NOT(predictivesearch2.nbr3>166633186212708351 AND predictivesearch2.nbr3<171136785840078848) AND NOT(predictivesearch2.nbr4>166633186212708351 AND predictivesearch2.nbr4<171136785840078848))) AND (NOT(NOT(predictivesearch5.nbr>369295169444380671 AND predictivesearch5.nbr<373798769071751168) AND NOT(predictivesearch5.nbr2>369295169444380671 AND predictivesearch5.nbr2<373798769071751168) AND NOT(predictivesearch5.nbr3>369295169444380671 AND predictivesearch5.nbr3<373798769071751168) AND NOT(predictivesearch5.nbr4>369295169444380671 AND predictivesearch5.nbr4<373798769071751168))))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
759 #else // #if defined(USE_DEMORGAN) |
|
760 // TODO: add non-De Morgan cases |
|
761 #endif // #if defined(USE_DEMORGAN) |
|
762 result = mCntSqlSearch->CreateJoinTableSearch(pattern, tokens); |
|
763 //qDebug() << pattern << " -> result" << result; |
|
764 LOG2(pattern, result); |
|
765 QVERIFY(!result.compare(reference)); |
|
766 |
|
767 pattern.clear(); |
|
768 pattern = "2505"; |
|
769 tokens.clear(); |
|
770 tokens << "25" << "5"; |
|
771 #if defined(USE_DEMORGAN) |
|
772 reference = QString("SELECT contact_id FROM (SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 WHERE (NOT(NOT(predictivesearch2.nbr>166721147142930431 AND predictivesearch2.nbr<166738739328974848) AND NOT(predictivesearch2.nbr2>166721147142930431 AND predictivesearch2.nbr2<166738739328974848) AND NOT(predictivesearch2.nbr3>166721147142930431 AND predictivesearch2.nbr3<166738739328974848) AND NOT(predictivesearch2.nbr4>166721147142930431 AND predictivesearch2.nbr4<166738739328974848))) UNION SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 JOIN predictivesearch5 ON predictivesearch2.contact_id = predictivesearch5.contact_id WHERE(NOT(NOT(predictivesearch2.nbr>166633186212708351 AND predictivesearch2.nbr<171136785840078848) AND NOT(predictivesearch2.nbr2>166633186212708351 AND predictivesearch2.nbr2<171136785840078848) AND NOT(predictivesearch2.nbr3>166633186212708351 AND predictivesearch2.nbr3<171136785840078848) AND NOT(predictivesearch2.nbr4>166633186212708351 AND predictivesearch2.nbr4<171136785840078848)))) AS PR ORDER BY PR.first_name, PR.last_name ASC;"); |
|
773 #else // #if defined(USE_DEMORGAN) |
|
774 // TODO: add non-De Morgan cases |
|
775 #endif // #if defined(USE_DEMORGAN) |
|
776 result = mCntSqlSearch->CreateJoinTableSearch(pattern, tokens); |
|
777 //qDebug() << pattern << " -> result" << result; |
|
778 LOG2(pattern, result); |
|
779 QVERIFY(!result.compare(reference)); |
|
780 |
|
781 // TODO: Test this case on HW and verify leading zeros. |
|
782 pattern.clear(); |
|
783 pattern = "0705"; |
|
784 tokens.clear(); |
|
785 tokens << "7" << "5"; |
|
786 #if defined(USE_DEMORGAN) |
|
787 reference = QString("SELECT contact_id FROM (SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 WHERE (NOT(NOT(predictivesearch2.nbr>145557747331497983 AND predictivesearch2.nbr<145575339517542400) AND NOT(predictivesearch2.nbr2>145557747331497983 AND predictivesearch2.nbr2<145575339517542400) AND NOT(predictivesearch2.nbr3>145557747331497983 AND predictivesearch2.nbr3<145575339517542400) AND NOT(predictivesearch2.nbr4>145557747331497983 AND predictivesearch2.nbr4<145575339517542400))) UNION SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 JOIN predictivesearch5 ON predictivesearch2.contact_id = predictivesearch5.contact_id WHERE(NOT(NOT(predictivesearch5.nbr>369295169444380671 AND predictivesearch5.nbr<373798769071751168) AND NOT(predictivesearch5.nbr2>369295169444380671 AND predictivesearch5.nbr2<373798769071751168) AND NOT(predictivesearch5.nbr3>369295169444380671 AND predictivesearch5.nbr3<373798769071751168) AND NOT(predictivesearch5.nbr4>369295169444380671 AND predictivesearch5.nbr4<373798769071751168)))) AS PR ORDER BY PR.first_name, PR.last_name ASC"); |
|
788 #else // #if defined(USE_DEMORGAN) |
|
789 // TODO: add non-De Morgan cases |
|
790 #endif // #if defined(USE_DEMORGAN) |
|
791 result = mCntSqlSearch->CreateJoinTableSearch(pattern, tokens); |
|
792 //qDebug() << pattern << result; |
|
793 LOG2(pattern, result); |
|
794 QVERIFY(!result.compare(result)); |
|
795 |
|
796 pattern.clear(); |
|
797 pattern = "2052"; |
|
798 tokens.clear(); |
|
799 tokens << "2" << "52"; |
|
800 #if defined(USE_DEMORGAN) |
|
801 reference = QString("SELECT contact_id FROM (SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 WHERE (NOT(NOT(predictivesearch2.nbr>145557747331497983 AND predictivesearch2.nbr<145575339517542400) AND NOT(predictivesearch2.nbr2>145557747331497983 AND predictivesearch2.nbr2<145575339517542400) AND NOT(predictivesearch2.nbr3>145557747331497983 AND predictivesearch2.nbr3<145575339517542400) AND NOT(predictivesearch2.nbr4>145557747331497983 AND predictivesearch2.nbr4<145575339517542400))) UNION SELECT predictivesearch2.contact_id, predictivesearch2.first_name, predictivesearch2.last_name FROM predictivesearch2 JOIN predictivesearch5 ON predictivesearch2.contact_id = predictivesearch5.contact_id WHERE(NOT(NOT(predictivesearch5.nbr>369295169444380671 AND predictivesearch5.nbr<373798769071751168) AND NOT(predictivesearch5.nbr2>369295169444380671 AND predictivesearch5.nbr2<373798769071751168) AND NOT(predictivesearch5.nbr3>369295169444380671 AND predictivesearch5.nbr3<373798769071751168) AND NOT(predictivesearch5.nbr4>369295169444380671 AND predictivesearch5.nbr4<373798769071751168)))) AS PR ORDER BY PR.first_name, PR.last_name ASC"); |
|
802 #else // #if defined(USE_DEMORGAN) |
|
803 // TODO: add non-De Morgan cases |
|
804 #endif // #if defined(USE_DEMORGAN) |
|
805 result = mCntSqlSearch->CreateJoinTableSearch(pattern, tokens); |
|
806 //qDebug() << "pattern " << result; |
|
807 LOG2(pattern, result); |
|
808 QVERIFY(!result.compare(result)); |
|
809 |
|
810 TEST_PASSED_LOG("testCreateJoinTableSearch"); |
|
811 } |
|
812 |
|
813 void UT_CntSqlSearch::testUpperLimit() |
|
814 { |
|
815 TEST_BEGIN_LOG("testUpperLimit"); |
|
816 |
|
817 QString pattern("234"); |
|
818 QString result; |
|
819 QString reference("159033361841520640"); |
|
820 result = mCntSqlSearch->UpperLimit(pattern); |
|
821 qDebug() << pattern << " -> result" << result; |
|
822 QVERIFY( result == reference ); |
|
823 |
|
824 pattern = QString("234456576687687"); |
|
825 reference = QString("158828188945381000"); |
|
826 result = mCntSqlSearch->UpperLimit(pattern); |
|
827 qDebug() << pattern << " -> result" << result; |
|
828 QVERIFY( result == reference ); |
|
829 |
|
830 // Same result as above case, characters beyond 15th are ignored |
|
831 pattern = QString("2344565766876874906754968"); |
|
832 result = mCntSqlSearch->UpperLimit(pattern); |
|
833 qDebug() << pattern << " -> result" << result; |
|
834 QVERIFY( result == reference ); |
|
835 |
|
836 pattern = QString("004456"); |
|
837 reference = QString("1202247245496320"); |
|
838 result = mCntSqlSearch->UpperLimit(pattern); |
|
839 qDebug() << pattern << " -> result" << result; |
|
840 QVERIFY( result == reference ); |
|
841 |
|
842 pattern = QString(""); |
|
843 reference = QString("1152921504606846976"); |
|
844 result = mCntSqlSearch->UpperLimit(pattern); |
|
845 qDebug() << pattern << " -> result" << result; |
|
846 QVERIFY( result == reference ); |
|
847 |
|
848 |
|
849 pattern = QString("000000000000000"); |
|
850 reference = QString("1"); |
|
851 result = mCntSqlSearch->UpperLimit(pattern); |
|
852 qDebug() << pattern << " -> result" << result; |
|
853 QVERIFY( result == reference ); |
|
854 |
|
855 pattern = QString("0000000000000"); |
|
856 reference = QString("256"); |
|
857 result = mCntSqlSearch->UpperLimit(pattern); |
|
858 qDebug() << pattern << " -> result" << result; |
|
859 QVERIFY( result == reference ); |
|
860 |
|
861 TEST_PASSED_LOG("testUpperLimit"); |
|
862 } |
|
863 |
|
864 void UT_CntSqlSearch::testLowerLimit() |
|
865 { |
|
866 TEST_BEGIN_LOG("testLowerLimit"); |
|
867 |
|
868 QString pattern("234"); |
|
869 QString result; |
|
870 QString reference("158751886864809983"); |
|
871 result = mCntSqlSearch->LowerLimit(pattern); |
|
872 qDebug() << pattern << " -> result" << result; |
|
873 QVERIFY( result == reference ); |
|
874 |
|
875 pattern = QString("234456576687687"); |
|
876 reference = QString("158828188945380998"); |
|
877 result = mCntSqlSearch->LowerLimit(pattern); |
|
878 qDebug() << pattern << " -> result" << result; |
|
879 QVERIFY( result == reference ); |
|
880 |
|
881 // Same result as above case, characters beyond 15th are ignored |
|
882 pattern = QString("23445657668768749067549685"); |
|
883 result = mCntSqlSearch->LowerLimit(pattern); |
|
884 qDebug() << pattern << " -> result" << result; |
|
885 QVERIFY( result == reference ); |
|
886 |
|
887 pattern = QString("001021"); |
|
888 reference = QString("283742719442943"); |
|
889 result = mCntSqlSearch->LowerLimit(pattern); |
|
890 qDebug() << pattern << " -> result" << result; |
|
891 QVERIFY( result == reference ); |
|
892 |
|
893 pattern = QString("1021500"); |
|
894 reference = QString("72643633735532543"); |
|
895 result = mCntSqlSearch->LowerLimit(pattern); |
|
896 qDebug() << pattern << " -> result" << result; |
|
897 QVERIFY( result == reference ); |
|
898 |
|
899 pattern = QString(""); |
|
900 reference = QString("-1"); |
|
901 result = mCntSqlSearch->LowerLimit(pattern); |
|
902 qDebug() << pattern << " -> result" << result; |
|
903 QVERIFY( result == reference ); |
|
904 |
|
905 // Lower limit for this is -1 |
|
906 pattern = QString("000000000000000"); |
|
907 reference = QString("-1"); // Lower limit is now zero minus one |
|
908 result = mCntSqlSearch->LowerLimit(pattern); |
|
909 qDebug() << pattern << " -> result" << result; |
|
910 QVERIFY( result == reference ); |
|
911 |
|
912 // Lower limit for this is -1 |
|
913 pattern = QString("00"); |
|
914 reference = QString("-1"); |
|
915 result = mCntSqlSearch->LowerLimit(pattern); |
|
916 qDebug() << pattern << " -> result" << result; |
|
917 QVERIFY( result == reference ); |
|
918 |
|
919 TEST_PASSED_LOG("testLowerLimit"); |
|
920 } |
|
921 |
|
922 void UT_CntSqlSearch::testGetTokens() |
|
923 { |
|
924 TEST_BEGIN_LOG("testGetTokens"); |
|
925 |
|
926 QStringList tokens = mCntSqlSearch->GetTokens(""); |
|
927 QVERIFY(tokens.count() == 0); |
|
928 |
|
929 tokens = mCntSqlSearch->GetTokens("0"); |
|
930 QVERIFY(tokens.count() == 0); |
|
931 |
|
932 tokens = mCntSqlSearch->GetTokens("00"); |
|
933 QVERIFY(tokens.count() == 0); |
|
934 |
|
935 tokens = mCntSqlSearch->GetTokens("000000000000000000000000"); |
|
936 QVERIFY(tokens.count() == 0); |
|
937 |
|
938 tokens = mCntSqlSearch->GetTokens("1"); |
|
939 QVERIFY(tokens.count() == 1); |
|
940 QVERIFY(tokens.at(0) == "1"); |
|
941 |
|
942 tokens = mCntSqlSearch->GetTokens("01"); |
|
943 QVERIFY(tokens.count() == 1); |
|
944 QVERIFY(tokens.at(0) == "1"); |
|
945 |
|
946 tokens = mCntSqlSearch->GetTokens("1"); |
|
947 QVERIFY(tokens.count() == 1); |
|
948 QVERIFY(tokens.at(0) == "1"); |
|
949 |
|
950 tokens = mCntSqlSearch->GetTokens("000028"); |
|
951 QVERIFY(tokens.count() == 1); |
|
952 QVERIFY(tokens.at(0) == "28"); |
|
953 |
|
954 tokens = mCntSqlSearch->GetTokens("000019700"); |
|
955 QVERIFY(tokens.count() == 1); |
|
956 QVERIFY(tokens.at(0) == "197"); |
|
957 |
|
958 tokens = mCntSqlSearch->GetTokens("101"); |
|
959 QVERIFY(tokens.count() == 2); |
|
960 QVERIFY(tokens.at(0) == "1"); |
|
961 QVERIFY(tokens.at(1) == "1"); |
|
962 |
|
963 tokens = mCntSqlSearch->GetTokens("1203"); |
|
964 QVERIFY(tokens.count() == 2); |
|
965 QVERIFY(tokens.at(0) == "12"); |
|
966 QVERIFY(tokens.at(1) == "3"); |
|
967 |
|
968 tokens = mCntSqlSearch->GetTokens("000012013"); |
|
969 QVERIFY(tokens.count() == 2); |
|
970 QVERIFY(tokens.at(0) == "000012"); |
|
971 QVERIFY(tokens.at(1) == "13"); |
|
972 |
|
973 tokens = mCntSqlSearch->GetTokens("00206"); |
|
974 QVERIFY(tokens.count() == 2); |
|
975 QVERIFY(tokens.at(0) == "002"); |
|
976 QVERIFY(tokens.at(1) == "6"); |
|
977 |
|
978 tokens = mCntSqlSearch->GetTokens("001230045067800900"); |
|
979 QVERIFY(tokens.count() == 2); |
|
980 QVERIFY(tokens.at(0) == "00123"); |
|
981 QVERIFY(tokens.at(1) == "45067800900"); |
|
982 |
|
983 tokens = mCntSqlSearch->GetTokens("1000002030405060708090011"); |
|
984 QVERIFY(tokens.count() == 2); |
|
985 QVERIFY(tokens.at(0) == "1"); |
|
986 QVERIFY(tokens.at(1) == "2030405060708090011"); |
|
987 |
|
988 tokens = mCntSqlSearch->GetTokens("4304"); |
|
989 QVERIFY(tokens.count() == 2); |
|
990 QVERIFY(tokens.at(0) == "43"); |
|
991 QVERIFY(tokens.at(1) == "4"); |
|
992 |
|
993 tokens = mCntSqlSearch->GetTokens("010203040506070809011001200130014001500"); |
|
994 QVERIFY(tokens.count() == 2); |
|
995 QVERIFY(tokens.at(0) == "01"); |
|
996 QVERIFY(tokens.at(1) == "203040506070809011001200130014001500"); |
|
997 |
|
998 TEST_PASSED_LOG("testGetTokens"); |
|
999 } |
|
1000 |
|
1001 #if defined(WRITE_LOGS) |
|
1002 void WriteLog(const QString a, const QString b) |
|
1003 { |
|
1004 TPtrC16 ptr(reinterpret_cast<const TUint16*>(a.utf16())); |
|
1005 WritePart(ptr); |
|
1006 |
|
1007 if (b.size() > 0) |
|
1008 { |
|
1009 TPtrC16 ptr2(reinterpret_cast<const TUint16*>(b.utf16())); |
|
1010 WritePart(ptr2); |
|
1011 } |
|
1012 } |
|
1013 |
|
1014 void WritePart(const TDesC& s) |
|
1015 { |
|
1016 // RDebug::Print() only writes first 256 chars |
|
1017 const TInt KMaxLength = 255; |
|
1018 |
|
1019 TInt pos(0); |
|
1020 TInt len = s.Length(); |
|
1021 while (pos < len) |
|
1022 { |
|
1023 TInt partLength = KMaxLength; |
|
1024 if (pos + partLength > len) |
|
1025 { |
|
1026 partLength = len - pos; |
|
1027 } |
|
1028 TPtrC16 part = s.Mid(pos, partLength); |
|
1029 RDebug::Print(part); |
|
1030 pos += KMaxLength; |
|
1031 } |
|
1032 } |
|
1033 #endif // #if defined(WRITE_LOGS) |
|
1034 |
|
1035 |
|
1036 #ifdef SQL_QT_TEST |
|
1037 QTEST_MAIN(UT_CntSqlSearch) |
|
1038 #endif |
|
1039 |
|