diff -r 000000000000 -r 876b1a06bc25 plugins/contacts/symbian/plugin/inc/filtering/cntsqlsearch.h --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/plugins/contacts/symbian/plugin/inc/filtering/cntsqlsearch.h Wed Aug 25 15:49:42 2010 +0300 @@ -0,0 +1,105 @@ +/**************************************************************************** +** +** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies). +** All rights reserved. +** Contact: Nokia Corporation (qt-info@nokia.com) +** +** This file is part of the examples of the Qt Toolkit. +** +** $QT_BEGIN_LICENSE:LGPL$ +** No Commercial Usage +** This file contains pre-release code and may not be distributed. +** You may use this file in accordance with the terms and conditions +** contained in the Technology Preview License Agreement accompanying +** this package. +** +** GNU Lesser General Public License Usage +** Alternatively, this file may be used under the terms of the GNU Lesser +** General Public License version 2.1 as published by the Free Software +** Foundation and appearing in the file LICENSE.LGPL included in the +** packaging of this file. Please review the following information to +** ensure the GNU Lesser General Public License version 2.1 requirements +** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. +** +** In addition, as a special exception, Nokia gives you certain additional +** rights. These rights are described in the Nokia Qt LGPL Exception +** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. +** +** If you have questions regarding the use of this file, please contact +** Nokia at qt-info@nokia.com. +** +** +** +** +** +** +** +** +** $QT_END_LICENSE$ +** +****************************************************************************/ +//#ifdef SYMBIAN_BACKEND_USE_SQLITE + +#include +#include + +// If this macro is defined, searches like "102" are made on one table only +#define SEARCH_FROM_ONE_TABLE + +// If defined, De Morgan's laws are used to replace ORs with ANDs in the +// SELECT statement. +#define USE_DEMORGAN + + +class CntSqlSearch : public QObject +{ + Q_OBJECT + +public: + CntSqlSearch(); + + QString CreatePredictiveSearch(const QString &pattern); + + +private: + + QString SelectTable(const QString &pattern) const; + + QStringList GetTokens(const QString& pattern) const; + + QString CreateQuery(const QString& pattern) const; + + QString ExactMatchSearch(const QString& pattern) const; + + QString CreateSpaceStringSearch(QStringList numbers, const QString &pattern) const; + + QString IntersectionSearch(const QString& pattern, + const QStringList& numbers) const; + QString SearchTokensFromOneTable(const QString& pattern, + const QStringList& tokens) const; + + QString IdenticalTokensSearch(const QString& pattern, + const QStringList& tokens) const; + + QString CompareTwoColumns(const QString& lower, + const QString& upper, + const QString& lower2, + const QString& upper2) const; + + QString ExactMatch(const QString& pattern, QString table = "") const; + + QString CreateJoinTableSearch(QString pattern, QStringList numbers) const; + + QString ExactMatchColumns(QStringList numbers) const; + + QString Order(QStringList numbers) const; + + QString UpperLimit( const QString &pattern ) const; + + QString LowerLimit( const QString &pattern ) const; + + QString Pad( const QString &pattern, char padChar ) const; + + friend class UT_CntSqlSearch; +}; +//#endif