diff -r 556534771396 -r d4d56f5e7c55 harvester/contentinfodb/src/contentinfodbreadprivate.cpp
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/harvester/contentinfodb/src/contentinfodbreadprivate.cpp	Tue Oct 05 13:15:12 2010 +0530
@@ -0,0 +1,168 @@
+/*
+ * 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:  read api implementation 
+ *
+ */
+#include "contentinfodbreadprivate.h"
+#include "contentinfodb.h"
+#include "cpixcontentinfodbread.h"
+
+
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::ContentInfoDbReadPrivate()
+// ---------------------------------------------------------------------------
+//
+ContentInfoDbReadPrivate::ContentInfoDbReadPrivate(QObject* aParent)
+    {
+    iReadPtr = reinterpret_cast<ContentInfoDbRead*> (aParent);
+    mdb = ContentInfoDb::instance();
+    connect(mdb, SIGNAL(dbUpdated()),this, SLOT(slotdataChanged()));
+
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::ContentInfoDbReadPrivate()
+// ---------------------------------------------------------------------------
+//
+ContentInfoDbReadPrivate::~ContentInfoDbReadPrivate()
+    {
+    ContentInfoDb::deleteinstance();
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::ContentInfoDbReadPrivate()
+// ---------------------------------------------------------------------------
+//
+QStringList ContentInfoDbReadPrivate::getPrimaryKeys()
+    {
+    return mdb->readData(QString(QUERYSORT));
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::ContentInfoDbReadPrivate()
+// ---------------------------------------------------------------------------
+//
+QString ContentInfoDbReadPrivate::getValues(QString Key, QString columnname)
+    {
+    return mdb->readStringData(
+            QString(QUERYDATARETRIVAL).arg(columnname).arg(MAINTABLENAME).arg(
+                    TAGPRIMARYKEY).arg(Key));
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::ContentInfoDbReadPrivate()
+// ---------------------------------------------------------------------------
+//
+QStringList ContentInfoDbReadPrivate::getActionuri(QString Key)
+    {
+    QString tablename = mdb->readStringData(QString(QUERYDATARETRIVAL).arg(
+            TAGACTIONURI).arg(MAINTABLENAME).arg(TAGPRIMARYKEY).arg(Key));
+    if (!tablename.length())
+        return QStringList();
+    return mdb->readData(
+            QString(QUERYPRIMARYKEYS).arg(TAGACTIONURISTRING).arg(tablename));
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::ContentInfoDbReadPrivate()
+// ---------------------------------------------------------------------------
+//
+QString ContentInfoDbReadPrivate::getShortTaburi(QString Key)
+    {
+    QString tablename = mdb->readStringData(QString(QUERYDATARETRIVAL).arg(
+            TAGACTIONURI).arg(MAINTABLENAME).arg(TAGPRIMARYKEY).arg(Key));
+    if (!tablename.length())
+        return NULL;
+    return mdb->readStringData(QString(QUERYFILTERDATA).arg(
+            TAGACTIONURISTRING).arg(tablename).arg(TAGACTION).arg(
+            PRIMARYVALUE));
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::ContentInfoDbReadPrivate()
+// ---------------------------------------------------------------------------
+//
+QStringList ContentInfoDbReadPrivate::getLongTaburi(QString Key,
+        QString FieldName)
+    {
+    QStringList longurilist;
+
+    QString tablename = mdb->readStringData(QString(QUERYDATARETRIVAL).arg(
+            TAGACTIONURI).arg(MAINTABLENAME).arg(TAGPRIMARYKEY).arg(Key));
+    if (!tablename.length())
+        return QStringList();
+    QString fieldmaptable =
+            mdb->readStringData(
+                    QString(QUERYDATARETRIVAL).arg(TAGFIELDMAP).arg(
+                            MAINTABLENAME).arg(TAGPRIMARYKEY).arg(Key));
+
+    QString
+            filedmapsubtable = mdb->readStringData(
+                    QString(QUERYDATARETRIVAL).arg(TAGURILIST).arg(
+                            fieldmaptable).arg(TAGFIELD).arg(FieldName));
+
+    QStringList urireflist = mdb->readData(QString(QUERYPRIMARYKEYS).arg(
+            TAGAURI).arg(filedmapsubtable));
+
+    for (int i = 0; i < urireflist.count(); i++)
+        {
+        QString str;
+
+        str = mdb->readStringData(QString(QUERYDATARETRIVAL).arg(
+                TAGACTIONURISTRING).arg(tablename).arg(TAGURIREF).arg(
+                urireflist.at(i)));
+
+        if (str.length())
+            longurilist.append(str);
+        }
+    return longurilist;
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::ContentInfoDbReadPrivate()
+// ---------------------------------------------------------------------------
+//
+bool ContentInfoDbReadPrivate::geturiDetails(QString key, QString uri,
+        QString& iconname, QString& displayname)
+    {
+    QString tablename = mdb->readStringData(QString(QUERYDATARETRIVAL).arg(
+            TAGACTIONURI).arg(MAINTABLENAME).arg(TAGPRIMARYKEY).arg(key));
+
+    if (!tablename.length())
+        return false;
+
+    iconname = QString();
+    displayname = QString();
+
+    iconname = mdb->readStringData(
+            QString(QUERYDATARETRIVAL).arg(TAGLNAME).arg(tablename).arg(
+                    TAGACTIONURISTRING).arg(uri));
+
+    displayname = mdb->readStringData(
+            QString(QUERYDATARETRIVAL).arg(TAGLICON).arg(tablename).arg(
+                    TAGACTIONURISTRING).arg(uri));
+    if (iconname.length() && displayname.length())
+        return true;
+    return false;
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::slotdataChanged()
+// ---------------------------------------------------------------------------
+//
+void ContentInfoDbReadPrivate::slotdataChanged()
+    {
+    if(iReadPtr)
+        emit iReadPtr->dataChanged();
+    }
+// ---------------------------------------------------------------------------
+// ContentInfoDbReadPrivate::categoryCount()
+// ---------------------------------------------------------------------------
+//
+int ContentInfoDbReadPrivate::categoryCount()
+    {
+    return (mdb->readStringData(QString(QUERYCOUNT))).toInt();
+    }