1 | /**************************************************************************** |
2 | ** |
3 | ** Copyright (C) 2016 The Qt Company Ltd. |
4 | ** Contact: https://www.qt.io/licensing/ |
5 | ** |
6 | ** This file is part of the Qt Assistant of the Qt Toolkit. |
7 | ** |
8 | ** $QT_BEGIN_LICENSE:LGPL$ |
9 | ** Commercial License Usage |
10 | ** Licensees holding valid commercial Qt licenses may use this file in |
11 | ** accordance with the commercial license agreement provided with the |
12 | ** Software or, alternatively, in accordance with the terms contained in |
13 | ** a written agreement between you and The Qt Company. For licensing terms |
14 | ** and conditions see https://www.qt.io/terms-conditions. For further |
15 | ** information use the contact form at https://www.qt.io/contact-us. |
16 | ** |
17 | ** GNU Lesser General Public License Usage |
18 | ** Alternatively, this file may be used under the terms of the GNU Lesser |
19 | ** General Public License version 3 as published by the Free Software |
20 | ** Foundation and appearing in the file LICENSE.LGPL3 included in the |
21 | ** packaging of this file. Please review the following information to |
22 | ** ensure the GNU Lesser General Public License version 3 requirements |
23 | ** will be met: https://www.gnu.org/licenses/lgpl-3.0.html. |
24 | ** |
25 | ** GNU General Public License Usage |
26 | ** Alternatively, this file may be used under the terms of the GNU |
27 | ** General Public License version 2.0 or (at your option) the GNU General |
28 | ** Public license version 3 or any later version approved by the KDE Free |
29 | ** Qt Foundation. The licenses are as published by the Free Software |
30 | ** Foundation and appearing in the file LICENSE.GPL2 and LICENSE.GPL3 |
31 | ** included in the packaging of this file. Please review the following |
32 | ** information to ensure the GNU General Public License requirements will |
33 | ** be met: https://www.gnu.org/licenses/gpl-2.0.html and |
34 | ** https://www.gnu.org/licenses/gpl-3.0.html. |
35 | ** |
36 | ** $QT_END_LICENSE$ |
37 | ** |
38 | ****************************************************************************/ |
39 | |
40 | #include "qhelpenginecore.h" |
41 | #include "qhelpfilterengine.h" |
42 | #include "qhelpsearchindexreader_default_p.h" |
43 | |
44 | #include <QtCore/QSet> |
45 | #include <QtSql/QSqlDatabase> |
46 | #include <QtSql/QSqlQuery> |
47 | |
48 | QT_BEGIN_NAMESPACE |
49 | |
50 | namespace fulltextsearch { |
51 | namespace qt { |
52 | |
53 | void Reader::setIndexPath(const QString &path) |
54 | { |
55 | m_indexPath = path; |
56 | m_namespaceAttributes.clear(); |
57 | m_filterEngineNamespaceList.clear(); |
58 | m_useFilterEngine = false; |
59 | } |
60 | |
61 | void Reader::addNamespaceAttributes(const QString &namespaceName, const QStringList &attributes) |
62 | { |
63 | m_namespaceAttributes.insert(akey: namespaceName, avalue: attributes); |
64 | } |
65 | |
66 | void Reader::setFilterEngineNamespaceList(const QStringList &namespaceList) |
67 | { |
68 | m_useFilterEngine = true; |
69 | m_filterEngineNamespaceList = namespaceList; |
70 | } |
71 | |
72 | static QString namespacePlaceholders(const QMultiMap<QString, QStringList> &namespaces) |
73 | { |
74 | QString placeholders; |
75 | const auto &namespaceList = namespaces.uniqueKeys(); |
76 | bool firstNS = true; |
77 | for (const QString &ns : namespaceList) { |
78 | if (firstNS) |
79 | firstNS = false; |
80 | else |
81 | placeholders += QLatin1String(" OR " ); |
82 | placeholders += QLatin1String("(namespace = ?" ); |
83 | |
84 | const QList<QStringList> &attributeSets = namespaces.values(akey: ns); |
85 | bool firstAS = true; |
86 | for (const QStringList &attributeSet : attributeSets) { |
87 | if (!attributeSet.isEmpty()) { |
88 | if (firstAS) { |
89 | firstAS = false; |
90 | placeholders += QLatin1String(" AND (" ); |
91 | } else { |
92 | placeholders += QLatin1String(" OR " ); |
93 | } |
94 | placeholders += QLatin1String("attributes = ?" ); |
95 | } |
96 | } |
97 | if (!firstAS) |
98 | placeholders += QLatin1Char(')'); // close "AND (" |
99 | placeholders += QLatin1Char(')'); |
100 | } |
101 | return placeholders; |
102 | } |
103 | |
104 | static void bindNamespacesAndAttributes(QSqlQuery *query, const QMultiMap<QString, QStringList> &namespaces) |
105 | { |
106 | const auto &namespaceList = namespaces.uniqueKeys(); |
107 | for (const QString &ns : namespaceList) { |
108 | query->addBindValue(val: ns); |
109 | |
110 | const QList<QStringList> &attributeSets = namespaces.values(akey: ns); |
111 | for (const QStringList &attributeSet : attributeSets) { |
112 | if (!attributeSet.isEmpty()) |
113 | query->addBindValue(val: attributeSet.join(sep: QLatin1Char('|'))); |
114 | } |
115 | } |
116 | } |
117 | |
118 | static QString namespacePlaceholders(const QStringList &namespaceList) |
119 | { |
120 | QString placeholders; |
121 | bool firstNS = true; |
122 | for (int i = namespaceList.count(); i; --i) { |
123 | if (firstNS) |
124 | firstNS = false; |
125 | else |
126 | placeholders += QLatin1String(" OR " ); |
127 | placeholders += QLatin1String("namespace = ?" ); |
128 | } |
129 | return placeholders; |
130 | } |
131 | |
132 | static void bindNamespacesAndAttributes(QSqlQuery *query, const QStringList &namespaceList) |
133 | { |
134 | for (const QString &ns : namespaceList) |
135 | query->addBindValue(val: ns); |
136 | } |
137 | |
138 | QVector<QHelpSearchResult> Reader::queryTable(const QSqlDatabase &db, |
139 | const QString &tableName, |
140 | const QString &searchInput) const |
141 | { |
142 | const QString nsPlaceholders = m_useFilterEngine |
143 | ? namespacePlaceholders(namespaceList: m_filterEngineNamespaceList) |
144 | : namespacePlaceholders(namespaces: m_namespaceAttributes); |
145 | QSqlQuery query(db); |
146 | query.prepare(query: QLatin1String("SELECT url, title, snippet(" ) + tableName + |
147 | QLatin1String(", -1, '<b>', '</b>', '...', '10') FROM " ) + tableName + |
148 | QLatin1String(" WHERE (" ) + nsPlaceholders + |
149 | QLatin1String(") AND " ) + tableName + |
150 | QLatin1String(" MATCH ? ORDER BY rank" )); |
151 | m_useFilterEngine |
152 | ? bindNamespacesAndAttributes(query: &query, namespaceList: m_filterEngineNamespaceList) |
153 | : bindNamespacesAndAttributes(query: &query, namespaces: m_namespaceAttributes); |
154 | query.addBindValue(val: searchInput); |
155 | query.exec(); |
156 | |
157 | QVector<QHelpSearchResult> results; |
158 | |
159 | while (query.next()) { |
160 | const QString &url = query.value(name: QLatin1String("url" )).toString(); |
161 | const QString &title = query.value(name: QLatin1String("title" )).toString(); |
162 | const QString &snippet = query.value(i: 2).toString(); |
163 | results.append(t: QHelpSearchResult(url, title, snippet)); |
164 | } |
165 | |
166 | return results; |
167 | } |
168 | |
169 | void Reader::searchInDB(const QString &searchInput) |
170 | { |
171 | const QString &uniqueId = QHelpGlobal::uniquifyConnectionName(name: QLatin1String("QHelpReader" ), pointer: this); |
172 | { |
173 | QSqlDatabase db = QSqlDatabase::addDatabase(type: QLatin1String("QSQLITE" ), connectionName: uniqueId); |
174 | db.setConnectOptions(QLatin1String("QSQLITE_OPEN_READONLY" )); |
175 | db.setDatabaseName(m_indexPath + QLatin1String("/fts" )); |
176 | |
177 | if (db.open()) { |
178 | const QVector<QHelpSearchResult> titleResults = queryTable(db, |
179 | tableName: QLatin1String("titles" ), searchInput); |
180 | const QVector<QHelpSearchResult> contentResults = queryTable(db, |
181 | tableName: QLatin1String("contents" ), searchInput); |
182 | |
183 | // merge results form title and contents searches |
184 | m_searchResults = QVector<QHelpSearchResult>(); |
185 | |
186 | QSet<QUrl> urls; |
187 | |
188 | for (const QHelpSearchResult &result : titleResults) { |
189 | const QUrl &url = result.url(); |
190 | if (!urls.contains(value: url)) { |
191 | urls.insert(value: url); |
192 | m_searchResults.append(t: result); |
193 | } |
194 | } |
195 | |
196 | for (const QHelpSearchResult &result : contentResults) { |
197 | const QUrl &url = result.url(); |
198 | if (!urls.contains(value: url)) { |
199 | urls.insert(value: url); |
200 | m_searchResults.append(t: result); |
201 | } |
202 | } |
203 | } |
204 | } |
205 | QSqlDatabase::removeDatabase(connectionName: uniqueId); |
206 | } |
207 | |
208 | QVector<QHelpSearchResult> Reader::searchResults() const |
209 | { |
210 | return m_searchResults; |
211 | } |
212 | |
213 | static bool attributesMatchFilter(const QStringList &attributes, |
214 | const QStringList &filter) |
215 | { |
216 | for (const QString &attribute : filter) { |
217 | if (!attributes.contains(str: attribute, cs: Qt::CaseInsensitive)) |
218 | return false; |
219 | } |
220 | |
221 | return true; |
222 | } |
223 | |
224 | void QHelpSearchIndexReaderDefault::run() |
225 | { |
226 | QMutexLocker lock(&m_mutex); |
227 | |
228 | if (m_cancel) |
229 | return; |
230 | |
231 | const QString searchInput = m_searchInput; |
232 | const QString collectionFile = m_collectionFile; |
233 | const QString indexPath = m_indexFilesFolder; |
234 | const bool usesFilterEngine = m_usesFilterEngine; |
235 | |
236 | lock.unlock(); |
237 | |
238 | QHelpEngineCore engine(collectionFile, nullptr); |
239 | if (!engine.setupData()) |
240 | return; |
241 | |
242 | emit searchingStarted(); |
243 | |
244 | // setup the reader |
245 | m_reader.setIndexPath(indexPath); |
246 | |
247 | if (usesFilterEngine) { |
248 | m_reader.setFilterEngineNamespaceList( |
249 | engine.filterEngine()->namespacesForFilter( |
250 | filterName: engine.filterEngine()->activeFilter())); |
251 | } else { |
252 | const QStringList ®isteredDocs = engine.registeredDocumentations(); |
253 | const QStringList ¤tFilter = engine.filterAttributes(filterName: engine.currentFilter()); |
254 | |
255 | for (const QString &namespaceName : registeredDocs) { |
256 | const QList<QStringList> &attributeSets = |
257 | engine.filterAttributeSets(namespaceName); |
258 | |
259 | for (const QStringList &attributes : attributeSets) { |
260 | if (attributesMatchFilter(attributes, filter: currentFilter)) { |
261 | m_reader.addNamespaceAttributes(namespaceName, attributes); |
262 | } |
263 | } |
264 | } |
265 | } |
266 | |
267 | lock.relock(); |
268 | if (m_cancel) { |
269 | emit searchingFinished(searchResultCount: 0); // TODO: check this, speed issue while locking??? |
270 | return; |
271 | } |
272 | lock.unlock(); |
273 | |
274 | m_searchResults.clear(); |
275 | m_reader.searchInDB(searchInput); // TODO: should this be interruptible as well ??? |
276 | |
277 | lock.relock(); |
278 | m_searchResults = m_reader.searchResults(); |
279 | lock.unlock(); |
280 | |
281 | emit searchingFinished(searchResultCount: m_searchResults.count()); |
282 | } |
283 | |
284 | } // namespace std |
285 | } // namespace fulltextsearch |
286 | |
287 | QT_END_NAMESPACE |
288 | |