/*
 * 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();
    }