diff -r bf4420e9fa4d -r 2e16851ffecd ginebra2/items/FamiliarItems.cpp --- a/ginebra2/items/FamiliarItems.cpp Fri Jun 11 16:23:26 2010 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,97 +0,0 @@ -/* -* 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 - -#include - -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(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(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(t); - } - -}