|
1 /* |
|
2 * Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies). |
|
3 * All rights reserved. |
|
4 * This component and the accompanying materials are made available |
|
5 * under the terms of "Eclipse Public License v1.0" |
|
6 * which accompanies this distribution, and is available |
|
7 * at the URL "http://www.eclipse.org/legal/epl-v10.html". |
|
8 * |
|
9 * Initial Contributors: |
|
10 * Nokia Corporation - initial contribution. |
|
11 * |
|
12 * Contributors: |
|
13 * |
|
14 * Description: SQL queries, tagname,macros. |
|
15 * |
|
16 */ |
|
17 |
|
18 #ifndef CONTENTINFODBCOMMON_H_ |
|
19 #define CONTENTINFODBCOMMON_H_ |
|
20 |
|
21 #ifndef CONTENTINFODB_UNITTESTING |
|
22 #define CONTENTINFODB_CLASS(aClassName) |
|
23 #else |
|
24 #define CONTENTINFODB_CLASS(aClassName) class aClassName; |
|
25 #endif |
|
26 |
|
27 #ifndef CONTENTINFODB_UNITTESTING |
|
28 #define CONTENTINFODB_FRIEND_CLASS(aClassName) |
|
29 #else |
|
30 #define CONTENTINFODB_FRIEND_CLASS(aClassName) friend class aClassName; |
|
31 #endif |
|
32 |
|
33 #ifdef BUILD_CONTENTINFODB |
|
34 #define DECL_CONTENTINFODB Q_DECL_EXPORT |
|
35 #else |
|
36 #define DECL_CONTENTINFODB Q_DECL_IMPORT |
|
37 #endif |
|
38 |
|
39 //sql queries |
|
40 // sql query to create a master table |
|
41 #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))" |
|
42 |
|
43 // sql query to insert row into the mentioned table |
|
44 #define QUERYINSERTROW "INSERT INTO %1 (%2) values('%3')" |
|
45 |
|
46 //sql query to update the value on mentioned table and field |
|
47 #define QUERYUPDATEDATA "UPDATE %1 SET %2='%3' WHERE %4='%5'" |
|
48 |
|
49 //sql query to create activity uri table |
|
50 #define QUERYCREATEACTIONURITABLE "create table %1 (uristring varchar(300) primary key,licon varchar(50),lname varchar(50),uriref varchar(20),action varchar(20))" |
|
51 |
|
52 //sql query to create field map table |
|
53 #define QUERYCREATEFIELDMAPTABLE "create table %1 (field varchar(300) primary key,urilist varchar(50))" |
|
54 |
|
55 //sql query to create a table for field map values |
|
56 #define QUERYCREATEFIELDMAPSUBTABLE "create table %1 (auri varchar(20) primary key)" |
|
57 |
|
58 //sql query to create a table for firstline information |
|
59 #define QUERYCREATEFIRSTLINETABLE "create table %1 (field varchar(50) primary key)" |
|
60 |
|
61 //sql query to create a table for relevancy information |
|
62 #define QUERYCREATERELEVANCYTABLE "create table %1 (field varchar(50) primary key,boostvalue varchar(20))" |
|
63 |
|
64 #define QUERYDATARETRIVAL "SELECT %1 FROM %2 WHERE %3 ='%4'" |
|
65 |
|
66 #define QUERYPRIMARYKEYS "SELECT DISTINCT %1 FROM %2" |
|
67 |
|
68 #define QUERYFILTERDATA "SELECT %1 FROM %2 WHERE %3 LIKE '%%4%'" |
|
69 |
|
70 #define QUERYSORT "SELECT name FROM maintable ORDER BY displayorder" |
|
71 |
|
72 #define QUERYDELETE "DELETE FROM maintable WHERE name ='%1'" |
|
73 |
|
74 #define QUERYCOUNT "SELECT COUNT(*) FROM maintable" |
|
75 |
|
76 // Database info |
|
77 // master table name |
|
78 #define MAINTABLENAME "maintable" |
|
79 |
|
80 // connection name |
|
81 #define CONNECTIONNAME "contentinfodb" |
|
82 |
|
83 //database type |
|
84 #define DATABASETYPE "QSQLITE" |
|
85 |
|
86 //path of contentinfo db |
|
87 #define DBNAME "c:\\private\\2001f6fb\\contentinfo.sq" |
|
88 |
|
89 //dynamic table creation |
|
90 #define DYNAMICTABLE "table%1" |
|
91 |
|
92 // xml tag name |
|
93 #define TAGPRIMARYKEY "name" |
|
94 #define TAGACTIONURI "actionuri" |
|
95 #define TAGACTIONURISTRING "uristring" |
|
96 #define TAGFIELDMAP "fieldmap" |
|
97 #define TAGRELEVANCY "relevancy" |
|
98 #define TAGFIELD "field" |
|
99 #define TAGURILIST "urilist" |
|
100 #define TAGAURI "auri" |
|
101 #define TAGRESULTFIRSTLINE "resultfirstline" |
|
102 #define TAGBOOSTVALUE "boostvalue" |
|
103 #define TAGACTION "action" |
|
104 #define TAGLNAME "lname" |
|
105 #define TAGLICON "licon" |
|
106 #define TAGURIREF "uriref" |
|
107 |
|
108 #define PRIMARYVALUE "primary" |
|
109 #define SECONDARYVALUE "secondary" |
|
110 |
|
111 #endif /* CONTENTINFODBCOMMON_H_ */ |