/*

 * 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:  Implementation of contentinfodb 

 *

 */

#include "contentinfodb.h"

#include <qdir.h>

#include <qvariant.h>

#include <qsqlquery.h>

#include <qstringlist.h>

ContentInfoDb *ContentInfoDb::m_instance = 0;

int ContentInfoDb::m_instanceCounter = 0;

// ---------------------------------------------------------------------------

// ContentInfoDb::ContentInfoDb()

// ---------------------------------------------------------------------------

//

ContentInfoDb::ContentInfoDb()

    {

    m_db = QSqlDatabase::addDatabase(DATABASETYPE, CONNECTIONNAME);

    m_db.setDatabaseName(DBNAME);

    }

// ---------------------------------------------------------------------------

// ContentInfoDb::~ContentInfoDb()

// ---------------------------------------------------------------------------

//

ContentInfoDb::~ContentInfoDb()

    {

    Close();

    }

// ---------------------------------------------------------------------------

// ContentInfoDb::writeData()

// ---------------------------------------------------------------------------

//

bool ContentInfoDb::writeData(QString query)

    {

    if (Open())

        {

        QSqlQuery q(QSqlDatabase::database(CONNECTIONNAME));

        q.prepare(query);

        if (q.exec())

            {

            emit dbUpdated();

            return true;

            }

        return false;

        }

    return false;

    }

// ---------------------------------------------------------------------------

// ContentInfoDb::readData()

// ---------------------------------------------------------------------------

//

QStringList ContentInfoDb::readData(QString query)

    {

    QStringList list;

    if (Open())

        {        

        QSqlQuery q(QSqlDatabase::database(CONNECTIONNAME));

        q.prepare(query);

        q.exec();

        while (q.next())

            {

            list.append(q.value(0).toString());  

            }

        }

    return list;

    }

// ---------------------------------------------------------------------------

// ContentInfoDb::readStringData()

// ---------------------------------------------------------------------------

//

QString ContentInfoDb::readStringData(QString query)

    {

    if (Open())

        {

        QSqlQuery q(QSqlDatabase::database(CONNECTIONNAME));

        q.prepare(query);

        q.exec();

        q.next();

        return q.value(0).toString();

        }

    return QString();

    }

// ---------------------------------------------------------------------------

// ContentInfoDb::createTable()

// ---------------------------------------------------------------------------

//

void ContentInfoDb::createTable(QString tablename, QString query)

    {

    if (!m_db.tables().contains(tablename))

        {

        QSqlQuery q(query, m_db);

        }

    }

// ---------------------------------------------------------------------------

// ContentInfoDb::open()

// ---------------------------------------------------------------------------

//    

bool ContentInfoDb::Open()

    {

    if (!m_db.isValid())

        {

        Close();

        return false;

        }

    if (!m_db.isOpen())

        {

        if (!m_db.open())

            {

            Close();

            return false;

            }

        }

    if (!m_db.tables().contains(MAINTABLENAME))

        {

        QSqlQuery q(QUERYCREATEMAINTABLE, m_db);

        }

    return true;

    }

// ---------------------------------------------------------------------------

// ContentInfoDb::Close()

// ---------------------------------------------------------------------------

//

void ContentInfoDb::Close()

    {

    m_db.close();

    }