tools/assistant/lib/qhelpdbreader.cpp

   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 Assistant of the Qt Toolkit.
   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 #include "qhelpdbreader_p.h"
  43 #include "qhelp_global.h"
  44
  45 #include <QtCore/QVariant>
  46 #include <QtCore/QFile>
  47 #include <QtSql/QSqlError>
  48 #include <QtSql/QSqlQuery>
  49
  50 QT_BEGIN_NAMESPACE
  51
  52 QHelpDBReader::QHelpDBReader(const QString &dbName)
  53     : QObject(0)
  54 {
  55     initObject(dbName,
  56         QHelpGlobal::uniquifyConnectionName(QLatin1String("QHelpDBReader"),
  57         this));
  58 }
  59
  60 QHelpDBReader::QHelpDBReader(const QString &dbName, const QString &uniqueId,
  61                            QObject *parent)
  62     : QObject(parent)
  63 {
  64     initObject(dbName, uniqueId);
  65 }
  66
  67 void QHelpDBReader::initObject(const QString &dbName, const QString &uniqueId)
  68 {
  69     m_dbName = dbName;
  70     m_uniqueId = uniqueId;
  71     m_initDone = false;
  72     m_query = 0;
  73     m_useAttributesCache = false;
  74 }
  75
  76 QHelpDBReader::~QHelpDBReader()
  77 {
  78     if (m_initDone) {
  79         delete m_query;
  80         QSqlDatabase::removeDatabase(m_uniqueId);
  81     }
  82 }
  83
  84 bool QHelpDBReader::init()
  85 {
  86     if (m_initDone)
  87         return true;
  88
  89     if (!QFile::exists(m_dbName))
  90         return false;
  91
  92     QSqlDatabase db = QSqlDatabase::addDatabase(QLatin1String("QSQLITE"), m_uniqueId);
  93     db.setDatabaseName(m_dbName);
  94     if (!db.open()) {
  95         /*: The placeholders are: %1 - The name of the database which cannot be opened
  96                                   %2 - The unique id for the connection
  97                                   %3 - The actual error string */
  98         m_error = tr("Cannot open database '%1' '%2': %3").arg(m_dbName, m_uniqueId, db.lastError().text());
  99         QSqlDatabase::removeDatabase(m_uniqueId);
 100         return false;
 101     }
 102
 103     m_initDone = true;
 104     m_query = new QSqlQuery(db);
 105
 106     return true;
 107 }
 108
 109 QString QHelpDBReader::databaseName() const
 110 {
 111     return m_dbName;
 112 }
 113
 114 QString QHelpDBReader::errorMessage() const
 115 {
 116     return m_error;
 117 }
 118
 119 QString QHelpDBReader::namespaceName() const
 120 {
 121     if (!m_namespace.isEmpty())
 122         return m_namespace;
 123     if (m_query) {
 124         m_query->exec(QLatin1String("SELECT Name FROM NamespaceTable"));
 125         if (m_query->next())
 126             m_namespace = m_query->value(0).toString();
 127     }
 128     return m_namespace;
 129 }
 130
 131 QString QHelpDBReader::virtualFolder() const
 132 {
 133     if (m_query) {
 134         m_query->exec(QLatin1String("SELECT Name FROM FolderTable WHERE Id=1"));
 135         if (m_query->next())
 136             return m_query->value(0).toString();
 137     }
 138     return QString();
 139 }
 140
 141 QList<QStringList> QHelpDBReader::filterAttributeSets() const
 142 {
 143     QList<QStringList> result;
 144     if (m_query) {
 145         m_query->exec(QLatin1String("SELECT a.Id, b.Name FROM FileAttributeSetTable a, "
 146             "FilterAttributeTable b WHERE a.FilterAttributeId=b.Id ORDER BY a.Id"));
 147         int oldId = -1;
 148         while (m_query->next()) {
 149             int id = m_query->value(0).toInt();
 150             if (id != oldId) {
 151                 result.append(QStringList());
 152                 oldId = id;
 153             }
 154             result.last().append(m_query->value(1).toString());
 155         }
 156     }
 157     return result;
 158 }
 159
 160 bool QHelpDBReader::fileExists(const QString &virtualFolder,
 161                                const QString &filePath,
 162                                const QStringList &filterAttributes) const
 163 {
 164     if (virtualFolder.isEmpty() || filePath.isEmpty() || !m_query)
 165         return false;
 166
 167 //SELECT COUNT(a.Name) FROM FileNameTable a, FolderTable b, FileFilterTable c, FilterAttributeTable d WHERE a.FolderId=b.Id AND b.Name='qtdoc' AND a.Name='qstring.html' AND a.FileId=c.FileId AND c.FilterAttributeId=d.Id AND d.Name='qtrefdoc'
 168
 169     QString query;
 170     namespaceName();
 171     if (filterAttributes.isEmpty()) {
 172         query = QString(QLatin1String("SELECT COUNT(a.Name) FROM FileNameTable a, FolderTable b "
 173             "WHERE a.FolderId=b.Id AND b.Name=\'%1\' AND a.Name=\'%2\'")).arg(quote(virtualFolder)).arg(quote(filePath));
 174     } else {
 175         query = QString(QLatin1String("SELECT COUNT(a.Name) FROM FileNameTable a, FolderTable b, "
 176             "FileFilterTable c, FilterAttributeTable d WHERE a.FolderId=b.Id "
 177             "AND b.Name=\'%1\' AND a.Name=\'%2\' AND a.FileId=c.FileId AND "
 178             "c.FilterAttributeId=d.Id AND d.Name=\'%3\'"))
 179             .arg(quote(virtualFolder)).arg(quote(filePath))
 180             .arg(quote(filterAttributes.first()));
 181         for (int i=1; i<filterAttributes.count(); ++i) {
 182             query.append(QString(QLatin1String(" INTERSECT SELECT COUNT(a.Name) FROM FileNameTable a, "
 183                 "FolderTable b, FileFilterTable c, FilterAttributeTable d WHERE a.FolderId=b.Id "
 184                 "AND b.Name=\'%1\' AND a.Name=\'%2\' AND a.FileId=c.FileId AND "
 185                 "c.FilterAttributeId=d.Id AND d.Name=\'%3\'"))
 186                 .arg(quote(virtualFolder)).arg(quote(filePath))
 187                 .arg(quote(filterAttributes.at(i))));
 188         }
 189     }
 190     m_query->exec(query);
 191     if (m_query->next() && m_query->isValid() && m_query->value(0).toInt())
 192         return true;
 193     return false;
 194 }
 195
 196 QByteArray QHelpDBReader::fileData(const QString &virtualFolder,
 197                                    const QString &filePath) const
 198 {
 199     QByteArray ba;
 200     if (virtualFolder.isEmpty() || filePath.isEmpty() || !m_query)
 201         return ba;
 202
 203     namespaceName();
 204     m_query->prepare(QLatin1String("SELECT a.Data FROM FileDataTable a, FileNameTable b, FolderTable c, "
 205         "NamespaceTable d WHERE a.Id=b.FileId AND (b.Name=? OR b.Name=?) AND b.FolderId=c.Id "
 206         "AND c.Name=? AND c.NamespaceId=d.Id AND d.Name=?"));
 207     m_query->bindValue(0, filePath);
 208     m_query->bindValue(1, QLatin1String("./") + filePath);
 209     m_query->bindValue(2, virtualFolder);
 210     m_query->bindValue(3, m_namespace);
 211     m_query->exec();
 212     if (m_query->next() && m_query->isValid())
 213         ba = qUncompress(m_query->value(0).toByteArray());
 214     return ba;
 215 }
 216
 217 QStringList QHelpDBReader::customFilters() const
 218 {
 219     QStringList lst;
 220     if (m_query) {
 221         m_query->exec(QLatin1String("SELECT Name FROM FilterNameTable"));
 222         while (m_query->next())
 223             lst.append(m_query->value(0).toString());
 224     }
 225     return lst;
 226 }
 227
 228 QStringList QHelpDBReader::filterAttributes(const QString &filterName) const
 229 {
 230     QStringList lst;
 231     if (m_query) {
 232         if (filterName.isEmpty()) {
 233             m_query->prepare(QLatin1String("SELECT Name FROM FilterAttributeTable"));
 234         } else {
 235             m_query->prepare(QLatin1String("SELECT a.Name FROM FilterAttributeTable a, "
 236                 "FilterTable b, FilterNameTable c WHERE c.Name=? "
 237                 "AND c.Id=b.NameId AND b.FilterAttributeId=a.Id"));
 238             m_query->bindValue(0, filterName);
 239         }
 240         m_query->exec();
 241         while (m_query->next())
 242             lst.append(m_query->value(0).toString());
 243     }
 244     return lst;
 245 }
 246
 247 QStringList QHelpDBReader::indicesForFilter(const QStringList &filterAttributes) const
 248 {
 249     QStringList indices;
 250     if (!m_query)
 251         return indices;
 252
 253     //SELECT DISTINCT a.Name FROM IndexTable a, IndexFilterTable b, FilterAttributeTable c WHERE a.Id=b.IndexId AND b.FilterAttributeId=c.Id AND c.Name in ('4.2.3', 'qt')
 254
 255     QString query;
 256     if (filterAttributes.isEmpty()) {
 257         query = QLatin1String("SELECT DISTINCT Name FROM IndexTable");
 258     } else {
 259         query = QString(QLatin1String("SELECT DISTINCT a.Name FROM IndexTable a, "
 260         "IndexFilterTable b, FilterAttributeTable c WHERE a.Id=b.IndexId "
 261         "AND b.FilterAttributeId=c.Id AND c.Name='%1'")).arg(quote(filterAttributes.first()));
 262         for (int i=1; i<filterAttributes.count(); ++i) {
 263             query.append(QString(QLatin1String(" INTERSECT SELECT DISTINCT a.Name FROM IndexTable a, "
 264                 "IndexFilterTable b, FilterAttributeTable c WHERE a.Id=b.IndexId "
 265                 "AND b.FilterAttributeId=c.Id AND c.Name='%1'"))
 266                 .arg(quote(filterAttributes.at(i))));
 267         }
 268     }
 269
 270     m_query->exec(query);
 271     while (m_query->next()) {
 272         if (!m_query->value(0).toString().isEmpty())
 273             indices.append(m_query->value(0).toString());
 274     }
 275     return indices;
 276 }
 277
 278 void QHelpDBReader::linksForKeyword(const QString &keyword, const QStringList &filterAttributes,
 279                                     QMap<QString, QUrl> &linkMap) const
 280 {
 281     if (!m_query)
 282         return;
 283
 284     QString query;
 285     if (filterAttributes.isEmpty()) {
 286         query = QString(QLatin1String("SELECT d.Title, f.Name, e.Name, d.Name, a.Anchor "
 287             "FROM IndexTable a, FileNameTable d, "
 288             "FolderTable e, NamespaceTable f WHERE "
 289             "a.FileId=d.FileId AND d.FolderId=e.Id AND a.NamespaceId=f.Id "
 290             "AND a.Name='%1'")).arg(quote(keyword));
 291     } else if (m_useAttributesCache) {
 292         query = QString(QLatin1String("SELECT d.Title, f.Name, e.Name, d.Name, a.Anchor, a.Id "
 293             "FROM IndexTable a, "
 294             "FileNameTable d, FolderTable e, NamespaceTable f WHERE "
 295             "a.FileId=d.FileId AND d.FolderId=e.Id "
 296             "AND a.NamespaceId=f.Id AND a.Name='%1'"))
 297             .arg(quote(keyword));
 298         m_query->exec(query);
 299         while (m_query->next()) {
 300             if (m_indicesCache.contains(m_query->value(5).toInt())) {
 301                 linkMap.insertMulti(m_query->value(0).toString(), buildQUrl(m_query->value(1).toString(),
 302                     m_query->value(2).toString(), m_query->value(3).toString(),
 303                     m_query->value(4).toString()));
 304             }
 305         }
 306         return;
 307     } else {
 308         query = QString(QLatin1String("SELECT d.Title, f.Name, e.Name, d.Name, a.Anchor "
 309             "FROM IndexTable a, IndexFilterTable b, FilterAttributeTable c, "
 310             "FileNameTable d, FolderTable e, NamespaceTable f "
 311             "WHERE a.FileId=d.FileId AND d.FolderId=e.Id "
 312             "AND a.NamespaceId=f.Id AND b.IndexId=a.Id AND b.FilterAttributeId=c.Id "
 313             "AND a.Name='%1' AND c.Name='%2'")).arg(quote(keyword))
 314             .arg(quote(filterAttributes.first()));
 315         for (int i=1; i<filterAttributes.count(); ++i) {
 316             query.append(QString(QLatin1String(" INTERSECT SELECT d.Title, f.Name, e.Name, d.Name, a.Anchor "
 317                 "FROM IndexTable a, IndexFilterTable b, FilterAttributeTable c, "
 318                 "FileNameTable d, FolderTable e, NamespaceTable f "
 319                 "WHERE a.FileId=d.FileId AND d.FolderId=e.Id "
 320                 "AND a.NamespaceId=f.Id AND b.IndexId=a.Id AND b.FilterAttributeId=c.Id "
 321                 "AND a.Name='%1' AND c.Name='%2'")).arg(quote(keyword))
 322                 .arg(quote(filterAttributes.at(i))));
 323         }
 324     }
 325
 326     QString title;
 327     m_query->exec(query);
 328     while (m_query->next()) {
 329         title = m_query->value(0).toString();
 330         if (title.isEmpty()) // generate a title + corresponding path
 331             title = keyword + QLatin1String(" : ") + m_query->value(3).toString();
 332         linkMap.insertMulti(title, buildQUrl(m_query->value(1).toString(),
 333             m_query->value(2).toString(), m_query->value(3).toString(),
 334             m_query->value(4).toString()));
 335     }
 336 }
 337
 338 void QHelpDBReader::linksForIdentifier(const QString &id,
 339                                        const QStringList &filterAttributes,
 340                                        QMap<QString, QUrl> &linkMap) const
 341 {
 342     if (!m_query)
 343         return;
 344
 345     QString query;
 346     if (filterAttributes.isEmpty()) {
 347         query = QString(QLatin1String("SELECT d.Title, f.Name, e.Name, d.Name, a.Anchor "
 348         "FROM IndexTable a, FileNameTable d, FolderTable e, "
 349         "NamespaceTable f WHERE a.FileId=d.FileId AND "
 350         "d.FolderId=e.Id AND a.NamespaceId=f.Id AND a.Identifier='%1'"))
 351         .arg(quote(id));
 352     } else if (m_useAttributesCache) {
 353         query = QString(QLatin1String("SELECT d.Title, f.Name, e.Name, d.Name, a.Anchor, a.Id "
 354             "FROM IndexTable a,"
 355             "FileNameTable d, FolderTable e, NamespaceTable f WHERE "
 356             "a.FileId=d.FileId AND d.FolderId=e.Id "
 357             "AND a.NamespaceId=f.Id AND a.Identifier='%1'"))
 358             .arg(quote(id));
 359         m_query->exec(query);
 360         while (m_query->next()) {
 361             if (m_indicesCache.contains(m_query->value(5).toInt())) {
 362                 linkMap.insertMulti(m_query->value(0).toString(), buildQUrl(m_query->value(1).toString(),
 363                     m_query->value(2).toString(), m_query->value(3).toString(),
 364                     m_query->value(4).toString()));
 365             }
 366         }
 367         return;
 368     } else {
 369         query = QString(QLatin1String("SELECT d.Title, f.Name, e.Name, d.Name, a.Anchor "
 370             "FROM IndexTable a, IndexFilterTable b, FilterAttributeTable c, "
 371             "FileNameTable d, FolderTable e, NamespaceTable f "
 372             "WHERE a.FileId=d.FileId AND d.FolderId=e.Id "
 373             "AND a.NamespaceId=f.Id AND b.IndexId=a.Id AND b.FilterAttributeId=c.Id "
 374             "AND a.Identifier='%1' AND c.Name='%2'")).arg(quote(id))
 375             .arg(quote(filterAttributes.first()));
 376         for (int i=0; i<filterAttributes.count(); ++i) {
 377             query.append(QString(QLatin1String(" INTERSECT SELECT d.Title, f.Name, e.Name, "
 378                 "d.Name, a.Anchor FROM IndexTable a, IndexFilterTable b, "
 379                 "FilterAttributeTable c, FileNameTable d, "
 380                 "FolderTable e, NamespaceTable f WHERE "
 381                 "a.FileId=d.FileId AND d.FolderId=e.Id AND a.NamespaceId=f.Id "
 382                 "AND b.IndexId=a.Id AND b.FilterAttributeId=c.Id AND "
 383                 "a.Identifier='%1' AND c.Name='%2'")).arg(quote(id))
 384                 .arg(quote(filterAttributes.at(i))));
 385         }
 386     }
 387
 388     m_query->exec(query);
 389     while (m_query->next()) {
 390         linkMap.insertMulti(m_query->value(0).toString(), buildQUrl(m_query->value(1).toString(),
 391             m_query->value(2).toString(), m_query->value(3).toString(),
 392             m_query->value(4).toString()));
 393     }
 394 }
 395
 396 QUrl QHelpDBReader::buildQUrl(const QString &ns, const QString &folder,
 397                               const QString &relFileName, const QString &anchor) const
 398 {
 399     QUrl url;
 400     url.setScheme(QLatin1String("qthelp"));
 401     url.setAuthority(ns);
 402     url.setPath(folder + QLatin1Char('/') + relFileName);
 403     url.setFragment(anchor);
 404     return url;
 405 }
 406
 407 QList<QByteArray> QHelpDBReader::contentsForFilter(const QStringList &filterAttributes) const
 408 {
 409     QList<QByteArray> contents;
 410     if (!m_query)
 411         return contents;
 412
 413     //SELECT DISTINCT a.Data FROM ContentsTable a, ContentsFilterTable b, FilterAttributeTable c WHERE a.Id=b.ContentsId AND b.FilterAttributeId=c.Id AND c.Name='qt' INTERSECT SELECT DISTINCT a.Data FROM ContentsTable a, ContentsFilterTable b, FilterAttributeTable c WHERE a.Id=b.ContentsId AND b.FilterAttributeId=c.Id AND c.Name='3.3.8';
 414
 415     QString query;
 416     if (filterAttributes.isEmpty()) {
 417         query = QLatin1String("SELECT Data from ContentsTable");
 418     } else {
 419         query = QString(QLatin1String("SELECT a.Data FROM ContentsTable a, "
 420             "ContentsFilterTable b, FilterAttributeTable c "
 421             "WHERE a.Id=b.ContentsId AND b.FilterAttributeId=c.Id "
 422             "AND c.Name='%1'")).arg(quote(filterAttributes.first()));
 423         for (int i=1; i<filterAttributes.count(); ++i) {
 424             query.append(QString(QLatin1String(" INTERSECT SELECT a.Data FROM ContentsTable a, "
 425             "ContentsFilterTable b, FilterAttributeTable c "
 426             "WHERE a.Id=b.ContentsId AND b.FilterAttributeId=c.Id "
 427             "AND c.Name='%1'")).arg(quote(filterAttributes.at(i))));
 428         }
 429     }
 430
 431     m_query->exec(query);
 432     while (m_query->next()) {
 433         contents.append(m_query->value(0).toByteArray());
 434     }
 435     return contents;
 436 }
 437
 438 QUrl QHelpDBReader::urlOfPath(const QString &relativePath) const
 439 {
 440     QUrl url;
 441     if (!m_query)
 442         return url;
 443
 444     m_query->exec(QLatin1String("SELECT a.Name, b.Name FROM NamespaceTable a, "
 445         "FolderTable b WHERE a.id=b.NamespaceId and a.Id=1"));
 446     if (m_query->next()) {
 447         QString rp = relativePath;
 448         QString anchor;
 449         int i = rp.indexOf(QLatin1Char('#'));
 450         if (i > -1) {
 451             rp = relativePath.left(i);
 452             anchor = relativePath.mid(i+1);
 453         }
 454         url = buildQUrl(m_query->value(0).toString(),
 455             m_query->value(1).toString(), rp, anchor);
 456     }
 457     return url;
 458 }
 459
 460 QStringList QHelpDBReader::files(const QStringList &filterAttributes,
 461                                  const QString &extensionFilter) const
 462 {
 463     QStringList lst;
 464     if (!m_query)
 465         return lst;
 466
 467     QString query;
 468     QString extension;
 469     if (!extensionFilter.isEmpty())
 470         extension = QString(QLatin1String("AND b.Name like \'%.%1\'")).arg(extensionFilter);
 471
 472     if (filterAttributes.isEmpty()) {
 473         query = QString(QLatin1String("SELECT a.Name, b.Name FROM FolderTable a, "
 474             "FileNameTable b WHERE b.FolderId=a.Id %1"))
 475             .arg(extension);
 476     } else {
 477         query = QString(QLatin1String("SELECT a.Name, b.Name FROM FolderTable a, "
 478             "FileNameTable b, FileFilterTable c, FilterAttributeTable d "
 479             "WHERE b.FolderId=a.Id AND b.FileId=c.FileId "
 480             "AND c.FilterAttributeId=d.Id AND d.Name=\'%1\' %2"))
 481             .arg(quote(filterAttributes.first())).arg(extension);
 482         for (int i=1; i<filterAttributes.count(); ++i) {
 483             query.append(QString(QLatin1String(" INTERSECT SELECT a.Name, b.Name FROM "
 484                 "FolderTable a, FileNameTable b, FileFilterTable c, "
 485                 "FilterAttributeTable d WHERE b.FolderId=a.Id AND "
 486                 "b.FileId=c.FileId AND c.FilterAttributeId=d.Id AND "
 487                 "d.Name=\'%1\' %2")).arg(quote(filterAttributes.at(i)))
 488                 .arg(extension));
 489         }
 490     }
 491     m_query->exec(query);
 492     while (m_query->next()) {
 493         lst.append(m_query->value(0).toString() + QLatin1Char('/')
 494             + m_query->value(1).toString());
 495     }
 496
 497     return lst;
 498 }
 499
 500 QVariant QHelpDBReader::metaData(const QString &name) const
 501 {
 502     QVariant v;
 503     if (!m_query)
 504         return v;
 505
 506     m_query->prepare(QLatin1String("SELECT COUNT(Value), Value FROM MetaDataTable "
 507         "WHERE Name=?"));
 508     m_query->bindValue(0, name);
 509     if (m_query->exec() && m_query->next()
 510         && m_query->value(0).toInt() == 1)
 511         v = m_query->value(1);
 512     return v;
 513 }
 514
 515 QString QHelpDBReader::mergeList(const QStringList &list) const
 516 {
 517     QString str;
 518     foreach (QString s, list)
 519         str.append(QLatin1Char('\'') + quote(s) + QLatin1String("\', "));
 520     if (str.endsWith(QLatin1String(", ")))
 521         str = str.left(str.length()-2);
 522     return str;
 523 }
 524
 525 QString QHelpDBReader::quote(const QString &string) const
 526 {
 527     QString s = string;
 528     s.replace(QLatin1Char('\''), QLatin1String("\'\'"));
 529     return s;
 530 }
 531
 532 QSet<int> QHelpDBReader::indexIds(const QStringList &attributes) const
 533 {
 534     QSet<int> ids;
 535
 536     if (attributes.isEmpty())
 537         return ids;
 538
 539     QString query = QString(QLatin1String("SELECT a.IndexId FROM IndexFilterTable a, "
 540         "FilterAttributeTable b WHERE a.FilterAttributeId=b.Id "
 541         "AND b.Name='%1'")).arg(attributes.first());
 542     for (int i=0; i<attributes.count(); ++i) {
 543         query.append(QString(QLatin1String(" INTERSECT SELECT a.IndexId FROM "
 544             "IndexFilterTable a, FilterAttributeTable b WHERE "
 545             "a.FilterAttributeId=b.Id AND b.Name='%1'"))
 546             .arg(attributes.at(i)));
 547     }
 548
 549     if (!m_query->exec(query))
 550             return ids;
 551
 552     while (m_query->next())
 553         ids.insert(m_query->value(0).toInt());
 554
 555     return ids;
 556 }
 557
 558 bool QHelpDBReader::createAttributesCache(const QStringList &attributes,
 559                                           const QSet<int> &indexIds)
 560 {
 561     m_useAttributesCache = false;
 562
 563     if (attributes.count() < 2) {
 564         m_viewAttributes.clear();
 565         return true;
 566     }
 567
 568     bool needUpdate = !m_viewAttributes.count();
 569
 570     foreach (QString s, attributes)
 571         m_viewAttributes.remove(s);
 572
 573     if (m_viewAttributes.count() || needUpdate) {
 574         m_viewAttributes.clear();
 575         m_indicesCache = indexIds;
 576     }
 577     foreach (QString s, attributes)
 578         m_viewAttributes.insert(s);
 579     m_useAttributesCache = true;
 580     return true;
 581 }
 582
 583 QT_END_NAMESPACE