/*

 * Copyright (c) 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:  SQL queries, tagname,macros.

 *

 */

#ifndef CONTENTINFODBCOMMON_H_

#define CONTENTINFODBCOMMON_H_

#ifndef CONTENTINFODB_UNITTESTING

#define CONTENTINFODB_CLASS(aClassName)

#else

#define CONTENTINFODB_CLASS(aClassName) class aClassName;

#endif 

#ifndef CONTENTINFODB_UNITTESTING

#define CONTENTINFODB_FRIEND_CLASS(aClassName)

#else

#define CONTENTINFODB_FRIEND_CLASS(aClassName) friend class aClassName;

#endif 

#ifdef BUILD_CONTENTINFODB

#define DECL_CONTENTINFODB Q_DECL_EXPORT

#else

#define DECL_CONTENTINFODB Q_DECL_IMPORT

#endif

//sql queries

// sql query to create a master table

#define QUERYCREATEMAINTABLE "create table maintable (name varchar(50) primary key,ins int default '0', bls int default '0',actionuri varchar(20),licon varchar(50),baseapp varchar(50),lname varchar(50),displayorder varchar(10),exceptionstring varchar(50),tsfile varchar(50),fieldmap varchar(20),indexcontentsize varchar(5),relevancy varchar(20),policy varchar(50),resultfirstline varchar(20))"

// sql query to insert row into the mentioned table

#define QUERYINSERTROW "INSERT INTO %1 (%2) values('%3')"

//sql query to update the value on mentioned table and field

#define QUERYUPDATEDATA "UPDATE %1 SET %2='%3' WHERE %4='%5'"

//sql query to create activity uri table

#define QUERYCREATEACTIONURITABLE "create table %1 (uristring varchar(300) primary key,licon varchar(50),lname varchar(50),uriref varchar(20),action varchar(20))"

//sql query to create field map table

#define QUERYCREATEFIELDMAPTABLE "create table %1 (field varchar(300) primary key,urilist varchar(50))"

//sql query to create a table for field map values

#define QUERYCREATEFIELDMAPSUBTABLE "create table %1 (auri varchar(20) primary key)"

//sql query to create a table for firstline information

#define QUERYCREATEFIRSTLINETABLE "create table %1 (field varchar(50) primary key)"

//sql query to create a table for relevancy information

#define QUERYCREATERELEVANCYTABLE "create table %1 (field varchar(50) primary key,boostvalue varchar(20))"

#define QUERYDATARETRIVAL "SELECT %1 FROM %2 WHERE %3 ='%4'"

#define QUERYPRIMARYKEYS "SELECT DISTINCT %1 FROM %2"

#define QUERYFILTERDATA "SELECT %1 FROM %2 WHERE %3 LIKE '%%4%'"

#define QUERYSORT "SELECT name FROM maintable ORDER BY displayorder"

#define QUERYDELETE "DELETE FROM maintable WHERE name ='%1'"

#define QUERYCOUNT "SELECT COUNT(*) FROM maintable"

// Database info

// master table name

#define MAINTABLENAME "maintable"

// connection name 

#define CONNECTIONNAME "contentinfodb"

//database type

#define DATABASETYPE "QSQLITE"

//path of contentinfo db

#define DBNAME "c:\\private\\2001f6fb\\contentinfo.sq"

//dynamic table creation

#define DYNAMICTABLE "table%1"

// xml tag name

#define TAGPRIMARYKEY "name"

#define TAGACTIONURI "actionuri"

#define TAGACTIONURISTRING "uristring"

#define TAGFIELDMAP "fieldmap"

#define TAGRELEVANCY "relevancy"

#define TAGFIELD "field"

#define TAGURILIST "urilist"

#define TAGAURI "auri" 

#define TAGRESULTFIRSTLINE "resultfirstline"

#define TAGBOOSTVALUE "boostvalue"

#define TAGACTION "action"

#define TAGLNAME "lname"

#define TAGLICON "licon"

#define TAGURIREF "uriref"

#define PRIMARYVALUE "primary"

#define SECONDARYVALUE "secondary"

#endif /* CONTENTINFODBCOMMON_H_ */