1 /*

     2 * Copyright (c) 2010 Nokia Corporation and/or its subsidiary(-ies).

     3 * All rights reserved.

     4 * This component and the accompanying materials are made available

     5 * under the terms of "Eclipse Public License v1.0"

     6 * which accompanies this distribution, and is available

     7 * at the URL "http://www.eclipse.org/legal/epl-v10.html".

     8 *

     9 * Initial Contributors:

    10 * Nokia Corporation - initial contribution.

    11 *

    12 * Contributors:

    13 *

    14 * Description: 

    15 *

    16 */

    17 

    18 #include "FamiliarItems.h"

    19 #include "../Settings.h"

    20 

    21 #include <QVariant>

    22 

    23 #include <QDebug>

    24 

    25 namespace GVA

    26 {

    27 

    28   FamiliarItems::FamiliarItems()

    29   {

    30     m_db = QSqlDatabase::database("GvaFamiliarItems");

    31     if(!m_db.isValid()){

    32       m_db = QSqlDatabase::addDatabase("QSQLITE", "GvaFamiliarItems");

    33       Settings * settings = Settings::instance();

    34       m_db.setDatabaseName(settings->installRoot() + "/familiar_items_db.sql");

    35       m_db.open();

    36       QSqlQuery q(m_db);

    37       q.exec("create table items(url varchar(100) primary key, title varchar(40), thumbnail varchar(40), tags int)");

    38     }

    39   }

    40   

    41   FamiliarItems::~FamiliarItems()

    42   {

    43     QSqlDatabase::removeDatabase("GvaFamiliarItems");

    44     m_db.close();

    45   }

    46   

    47   void FamiliarItems::updateItem(const FamiliarItems::Item & item)

    48   {

    49     QSqlQuery q(m_db);

    50     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));

    51     bool ok = q.exec(qs);

    52     qDebug() << "Query: " << qs << ": " << ok;

    53   }

    54   

    55   FamiliarItems::Item FamiliarItems::item(const QString url)

    56   {

    57     FamiliarItems::Item item;

    58     item.url = url;

    59     QSqlQuery q(m_db);

    60     q.exec(QString("select title, thumbnail, tags from items where url = '%1'").arg(url.left(100)));

    61     q.first();

    62     item.title = q.value(0).toString();

    63     item.thumbnail = q.value(1).toString();

    64     item.tags = static_cast<FamiliarItems::ItemTag>(q.value(2).toInt());

    65     return item;

    66   }

    67   

    68   QString FamiliarItems::thumbnail(const QString url)

    69   {

    70     QSqlQuery q(m_db);

    71     q.exec(QString("select thumbnail from items where url = '%1'").arg(url.left(100)));

    72     q.first();

    73     QString t = q.value(0).toString();

    74     return t;

    75   }

    76   

    77   QString FamiliarItems::title(const QString url)

    78   {

    79     QSqlQuery q(m_db);

    80     QString qs = QString("select title from items where url = '%1'").arg(url.left(100)); 

    81     bool ok = q.exec(qs);

    82     qDebug() << "Query: " << qs << " : " << ok;

    83     q.first();

    84     QString t = q.value(0).toString();

    85     return t;

    86   }

    87   

    88   FamiliarItems::ItemTag FamiliarItems::tag(const QString url)

    89   {

    90     QSqlQuery q(m_db);

    91     q.exec(QString("select tags from items where url = '%1'").arg(url.left(100)));

    92     q.first();

    93     int t = q.value(0).toInt();

    94     return static_cast<FamiliarItems::ItemTag>(t);

    95   }

    96   

    97 }