/*
* Copyright (c) 2010 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 "FamiliarItems.h"
#include "../Settings.h"

#include <QVariant>

#include <QDebug>

namespace GVA
{

  FamiliarItems::FamiliarItems()
  {
    m_db = QSqlDatabase::database("GvaFamiliarItems");
    if(!m_db.isValid()){
      m_db = QSqlDatabase::addDatabase("QSQLITE", "GvaFamiliarItems");
      Settings * settings = Settings::instance();
      m_db.setDatabaseName(settings->installRoot() + "/familiar_items_db.sql");
      m_db.open();
      QSqlQuery q(m_db);
      q.exec("create table items(url varchar(100) primary key, title varchar(40), thumbnail varchar(40), tags int)");
    }
  }
  
  FamiliarItems::~FamiliarItems()
  {
    QSqlDatabase::removeDatabase("GvaFamiliarItems");
    m_db.close();
  }
  
  void FamiliarItems::updateItem(const FamiliarItems::Item & item)
  {
    QSqlQuery q(m_db);
    QString qs =  QString("replace into items values('%1', '%2', '%3', %4)").arg(item.url.left(100)).arg(item.title.left(40)).arg(item.thumbnail.left(40)).arg(static_cast<int>(item.tags));
    bool ok = q.exec(qs);
    qDebug() << "Query: " << qs << ": " << ok;
  }
  
  FamiliarItems::Item FamiliarItems::item(const QString url)
  {
    FamiliarItems::Item item;
    item.url = url;
    QSqlQuery q(m_db);
    q.exec(QString("select title, thumbnail, tags from items where url = '%1'").arg(url.left(100)));
    q.first();
    item.title = q.value(0).toString();
    item.thumbnail = q.value(1).toString();
    item.tags = static_cast<FamiliarItems::ItemTag>(q.value(2).toInt());
    return item;
  }
  
  QString FamiliarItems::thumbnail(const QString url)
  {
    QSqlQuery q(m_db);
    q.exec(QString("select thumbnail from items where url = '%1'").arg(url.left(100)));
    q.first();
    QString t = q.value(0).toString();
    return t;
  }
  
  QString FamiliarItems::title(const QString url)
  {
    QSqlQuery q(m_db);
    QString qs = QString("select title from items where url = '%1'").arg(url.left(100)); 
    bool ok = q.exec(qs);
    qDebug() << "Query: " << qs << " : " << ok;
    q.first();
    QString t = q.value(0).toString();
    return t;
  }
  
  FamiliarItems::ItemTag FamiliarItems::tag(const QString url)
  {
    QSqlQuery q(m_db);
    q.exec(QString("select tags from items where url = '%1'").arg(url.left(100)));
    q.first();
    int t = q.value(0).toInt();
    return static_cast<FamiliarItems::ItemTag>(t);
  }
  
}