pendingmessagesmanager.cpp

/**
 * Copyright (C) 2013 Canonical, Ltd.
 *
 * This program is free software: you can redistribute it and/or modify it under
 * the terms of the GNU Lesser General Public License version 3, as published by
 * the Free Software Foundation.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranties of MERCHANTABILITY,
 * SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * Authors: Tiago Salem Herrmann <tiago.herrmann@canonical.com>
 */

#include <QDebug>
#include <QSqlQuery>
#include <QSqlError>
#include "pendingmessagesmanager.h"
#include "sqlitedatabase.h"

PendingMessagesManager::PendingMessagesManager(QObject *parent) :
    QObject(parent),
    mDatabase(SQLiteDatabase::instance()->database())
{
}

PendingMessagesManager *PendingMessagesManager::instance()
{
    static PendingMessagesManager *self = new PendingMessagesManager();
    return self;
}

QString PendingMessagesManager::recipientIdForMessageId(const QString &messageId)
{
    QSqlQuery query(SQLiteDatabase::instance()->database());
    QString queryString("SELECT recipientId FROM pending_messages WHERE messageId=:messageId");
    query.prepare(queryString);
    query.bindValue(":messageId", messageId);

    if (!query.exec()) {
        qCritical() << "Error:" << query.lastError() << query.lastQuery();
        return QString();
    }

    if(!query.next()) {
        return QString();
    }

    return query.value(0).toString();
}

void PendingMessagesManager::addPendingMessage(const QString &messageId, const QString &recipientId)
{
    QSqlQuery query(SQLiteDatabase::instance()->database());

    PendingMessage message;
    message.recipientId = recipientId;
    message.timestamp = QDateTime::currentDateTimeUtc();

    QString queryString("INSERT into pending_messages (messageId, recipientId, timestamp) VALUES (:messageId, :recipientId, :timestamp)");
    query.prepare(queryString);
    query.bindValue(":messageId", messageId);
    query.bindValue(":recipientId", message.recipientId);
    query.bindValue(":timestamp", message.timestamp.toString(Qt::ISODate));

    if (!query.exec()) {
        qCritical() << "Error:" << query.lastError() << query.lastQuery();
        return;
    }
}

void PendingMessagesManager::removePendingMessage(const QString &messageId)
{
    QSqlQuery query(SQLiteDatabase::instance()->database());
    QString queryString("DELETE FROM pending_messages WHERE messageId=:messageId");

    query.prepare(queryString);
    query.bindValue(":messageId", messageId);

    if (!query.exec()) {
        qCritical() << "Error:" << query.lastError() << query.lastQuery();
        return;
    }
}