/*

* 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:

*

*/

#include <QFile>

#include <QSqlQuery>

#include <QSqlRecord> 

#include <QSqlDatabase>

#include <QVariant>

#include "irsearchresultdb.h"

#include "irqisdsdatastructure.h"

IRSearchResultDB::IRSearchResultDB()

{

    createDBConnection();

}

IRSearchResultDB::~IRSearchResultDB()

{

    if (iDB->isOpen())

    {

        iDB->close();

    }        

    delete iDB;

    iDB = NULL;

}

IRQError IRSearchResultDB::cacheChannelList(QList<IRQChannelItem*> *aChannelList)

{

    IRQError ret = EIRQErrorNone;

    if( NULL == aChannelList )

    {

        return EIRQErrorBadParameter;

    }

    if( iDB->isOpen() )

    {

        clearCache();

        for(int i=0; i<aChannelList->count(); i++)

        {

            IRQChannelItem* insertItem = aChannelList->at(i);

            QString name = insertItem->channelName;

            int channelID = insertItem->channelID;

            QString imageURL = insertItem->imageURL;

            QString description = insertItem->shortDescription;

            //if some data overflows, we just skip it.note that

            //the VARCHAR is word-based, so here we use the real size 

            if( name.size()>= 256 || imageURL.size() >= 256 || description.size() >= 256 )

            {

                continue;

            }            

            QSqlQuery query;

            bool result;

            result = query.prepare("INSERT INTO searchresult (name, channelID, imageURL, description) "

                "VALUES (:name, :channelID, :imageURL, :description)");

            query.bindValue(":name", name);

            query.bindValue(":channelID",channelID);

            query.bindValue(":imageURL", imageURL);

            query.bindValue(":description", description);

            result = query.exec();

            if( !result )

            {

                ret = EIRQErrorServiceUnavailable;

                break;

            }

        }

    }

    else

    {

        ret = EIRQErrorGeneral;

    }

    return ret;

}

QList<IRQChannelItem*> *IRSearchResultDB::getCahcedChannelList()

{

    if( !iDB->isOpen() )

    {

        return NULL;

    }

    QList<IRQChannelItem*> *channelList = new QList<IRQChannelItem*>();

    QSqlQuery query("SELECT * FROM searchresult");

    QSqlRecord rec = query.record();

    int nameCol = rec.indexOf("name");

    int channelIDCol = rec.indexOf("channelID");

    int imageURLCol = rec.indexOf("imageURL");

    int descriptionCol = rec.indexOf("description");     

    while(query.next())

    {

        IRQChannelItem *oneItem = new IRQChannelItem();

        oneItem->channelName = query.value(nameCol).toString();

        oneItem->channelID = query.value(channelIDCol).toInt();

        oneItem->imageURL = query.value(imageURLCol).toString();

        oneItem->shortDescription = query.value(descriptionCol).toString();

        channelList->append(oneItem);

    }

    return channelList;    

}

IRQError IRSearchResultDB::clearCache()

{

    IRQError ret = EIRQErrorNone;

    if( !iDB->open())

    {

        ret = EIRQErrorServiceUnavailable;

    }

    else

    { 

        QSqlQuery query("DELETE FROM searchresult");         

        bool ret = query.exec();

        if( !ret )

        {

            ret = EIRQErrorServiceUnavailable;

        }

    }

    return ret;

}

void IRSearchResultDB::createDBConnection()

{ 

    bool created = QFile::exists("searchresult.dat");    

    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");     

    iDB = new QSqlDatabase(db);

    iDB->setDatabaseName("searchresult.dat");

    if (!iDB->open())

    {         

        return;

    }

    if (!created)

    {

        bool dbResult = false;

        QSqlQuery query;         

        //note: the VARCHAR is word-based but not byte-based. and 255 

        //means 255 unicode words.

        dbResult = query.exec("CREATE TABLE searchresult ("

            "id INTEGER PRIMARY KEY AUTOINCREMENT, "

            "name VARCHAR(255) NOT NULL, "

            "channelID INTEGER, "

            "imageURL VARCHAR(255), "

            "description VARCHAR(255) NOT NULL)");

        if (!dbResult)

        {             

            return;

        }

    } 

}