/*

* Copyright (c) 2007-2009 Nokia Corporation and/or its subsidiary(-ies). 

* All rights reserved.

* This component and the accompanying materials are made available

* under the terms of "Eclipse Public License v1.0"

* which accompanies this distribution, and is available

* at the URL "http://www.eclipse.org/legal/epl-v10.html".

*

* Initial Contributors:

* Nokia Corporation - initial contribution.

*

* Contributors:

*

* Description:  Includes predefined SQL clauses for usage of*

*/

#ifndef __MDSFINDSQLCLAUSEDEF_H__

#define __MDSFINDSQLCLAUSEDEF_H__

// ---------------------------------------------------------------------------

// Misc definitions

// ---------------------------------------------------------------------------

//

_LIT( KEmpty, "" );

_LIT( KSpace, " " );

_LIT( KLeftBracket, "(" );

_LIT( KRightBracket, ")" );

_LIT( KComma, "," );

_LIT( KSemicolon, ";" );

_LIT( KVariable, "?" );

_LIT( KWildcard, "%" );

_LIT( KEmptyTrue, "1" ); // used from always pass true tests

_LIT( KCommaVariable, ",?" );

_LIT( KNotIn, " NOT IN" );

_LIT( KIn, " IN" );

_LIT( KOrderBy, " ORDER BY " );

_LIT( KNoCaseSensitive, " COLLATE NOCASE ");

_LIT( KLimit, "LIMIT " );

_LIT( KOffset, "OFFSET " );

_LIT( KAsc, " ASC");

_LIT( KDesc, " DESC" );

_LIT( KIsNull,  " ISNULL" );

_LIT( KNotNull, " NOTNULL" );

_LIT( KUnion, " UNION " );

_LIT( KIntersect, " INTERSECT " );

_LIT( KUnionAll, " UNION ALL " );

_LIT( KAsBoJoin, " AS BO JOIN " );

_LIT( KBaseObjectObjectId, "BO.ObjectId" );

_LIT( KObjectObjectId,     "O.ObjectId" );

_LIT( KRelationId, "RelationId" );

_LIT( KEventId,    "EventId" );

_LIT( KSelectPropertyFilterBegin, "SELECT BO.ObjectId,BO.ObjectDefId,BO.Flags,BO.MediaId,BO.UsageCount,BO.GuidHigh,BO.GuidLow,BO.URI" );

_LIT( KBaseObjectDot, "BO." );

_LIT( KObjectDot,     "O." );

_LIT( KGroupByObjectId, "GROUP BY BO.ObjectId " );

// ---------------------------------------------------------------------------

// Object flags

// ---------------------------------------------------------------------------

//

_LIT( KGetFlagAnd, "(Flags&?)AND " );        // Flag is set

_LIT( KGetNotFlagAnd, "(NOT Flags&?)AND " ); // Flag is not set

_LIT( KGetNotFlag, "(NOT Flags&?) " );        // Flag is not set

_LIT( KWhereNotFlag, "WHERE(NOT Flags&?)" ); // Flag is not set

// ---------------------------------------------------------------------------

// SELECT clauses

// ---------------------------------------------------------------------------

//

_LIT( KSelect, "SELECT " );

_LIT( KSelectCount, 

	"SELECT count(*) "

	);

_LIT( KSelect1,

	"SELECT 1 "

	);

_LIT( KSelectObjectIds,

    "SELECT BO.ObjectId "

    );

_LIT( KSelectAllFromBaseObject, 

	"SELECT BO.* "

	);

_LIT( KAllFromObject, 

	",O.* "

	);

_LIT( KSelectFreeTextCountAndTotalLength, 

	",count(D.Word),sum(length(D.Word)) "

	);

// distict queries

_LIT( KSelectDistinct, 

	"SELECT DISTINCT "

	);

_LIT( KSelectAllFrom, 

	"SELECT * "

	);

_LIT( KSelectEventIds, 

	"SELECT Event"

	);

_LIT( KDotEventId, 

	".EventId "

	);

_LIT( KSelectRelationIds, 

	"SELECT Relations"

	);

_LIT( KDotRelationId, 

	".RelationId "

	);

// ---------------------------------------------------------------------------

// FROM clauses

// ---------------------------------------------------------------------------

//

_LIT( KFromBaseObject, 

	"FROM Object"

	);

_LIT( KAsBaseObject, 

	" AS BO "

	);

_LIT( KAsObjectOnEqual, 

	" AS O ON BO.ObjectId=O.ObjectId "

	);

_LIT( KFreeTextLeftJoinBegin,

	"LEFT JOIN TextSearchDictionary"

	);

_LIT( KFreeTextLeftJoinMiddle,

	" AS D ON D.WordId IN(SELECT WordId FROM TextSearch"

	);

_LIT( KFreeTextLeftJoinEnd,

	" WHERE BO.ObjectId=ObjectId) "

	);

_LIT( KFromEvent, 

    "FROM Event"

    );

_LIT( KFromRealtions, 

    "FROM Relations"

    );

// ---------------------------------------------------------------------------

// WHERE statement and comparison operators

// ---------------------------------------------------------------------------

//

_LIT( KWhere, "WHERE" );

// Comparison operators

_LIT( KEqual,          "=?" );

_LIT( KNotEqual,       "!=?" );

_LIT( KLess,           "<?" );

_LIT( KLessOrEqual,    "<=?" );

_LIT( KGreater,        ">?" );

_LIT( KGreaterOrEqual, ">=?" );

_LIT( KBetween,        " BETWEEN ? AND ?" );

_LIT( KNotBetween,     " NOT BETWEEN ? AND ?" );

_LIT( KLike,           " LIKE ?" );

// Logic operators

_LIT( KAnd,          "AND " );

_LIT( KOr,           "OR "  );

_LIT( KSpaceWithNot, " NOT" );

_LIT( KNotWithSpace, "NOT " );

_LIT( KNot, "NOT" );

// Object conditions

_LIT( KObjectIdEqual,       "ObjectId=?" );

_LIT( KObjectIdIn,          "ObjectId IN" );

_LIT( KObjectDefIdEqual,    "ObjectDefId=?" );

_LIT( KObjectGuidEqual,     "(GuidHigh=? AND GuidLow=?)" );

_LIT( KObjectUsageCount,    "UsageCount" );

_LIT( KObjectUriEqual,      "URI=?" );

_LIT( KObjectUriBeginsWith, "URI LIKE ?" );

_LIT( KBaseObjectIdIn,    "BO.ObjectId IN" );

_LIT( KBaseObjectIdNotIn, "BO.ObjectId NOT IN" );

// Object searches

_LIT( KSelectObjectIdFromBaseObject, "SELECT ObjectId FROM Object" );

_LIT( KSelectObjectIdFrom, "SELECT ObjectId FROM " );

// Freetext searches

_LIT( KObjectFreeTextSearchStart,           "(ObjectId IN(SELECT ObjectID FROM TextSearch");

_LIT( KObjectFreeTextSearchWhere,           " WHERE WordId IN(SELECT WordId FROM TextSearchDictionary");

_LIT( KObjectFreeTextSearchDictionaryWhere, " WHERE Word" );

_LIT( KObjectFreeTextSearchEnd,             ")))" );

// Event searches

_LIT( KSelectEventIdFromEvent,  "SELECT EventId FROM Event" );

_LIT( KSelectObjectIdFromEvent, "SELECT ObjectId FROM Event" );

_LIT( KEventObjectIdIn,         "ObjectId IN" );

_LIT( KEventTimeStamp,          "TimeStamp" );

_LIT( KEventIdEqual,            "EventId=?" );

_LIT( KEventDefIdEqual,         "EventDefId=?" );

_LIT( KEventSourceEqual,        "Source=?" );

_LIT( KEventParticipantEqual,   "Participant=?" );

// Relation searches

_LIT( KSelectRelationIdFromRelation,    "SELECT RelationId FROM Relations" );

_LIT( KSelectLeftObjectIdFromRelation,  "SELECT LeftObjectId FROM Relations" );

_LIT( KSelectRightObjectIdFromRelation, "SELECT RightObjectId FROM Relations" );

_LIT( KRelationIdEqual,                 "RelationId=?" );

_LIT( KRelationIdIn,                  	"RelationId IN" );

_LIT( KRelationDefIdEqual,              "RelationDefId=?" );

_LIT( KRelationGuidEqual,               "GuidHigh=? AND GuidLow=?" );

_LIT( KRelationParameter,               "Parameter" );

_LIT( KRelationLastModifiedDate,        "LastModifiedDate" );

_LIT( KRelationLeftObjectIdIn,          "LeftObjectId IN" );

_LIT( KRelationRightObjectIdIn,         "RightObjectId IN" );

#endif // __MDSFINDSQLCLAUSEDEF_H__