1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
/**
* 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;
}
}
|