MessageRecord HistoryDB::get(const ChatId &id)
{
QSqlQuery query(QSqlDatabase::database(m_id));
query.prepare(LS("SELECT id, senderId, destId, status, date, command, text, data FROM messages WHERE messageId = :messageId LIMIT 1;"));
query.bindValue(LS(":messageId"), id.toBase32());
query.exec();
if (!query.first())
return MessageRecord();
MessageRecord record;
record.id = query.value(0).toLongLong();
record.messageId = id.toByteArray();
record.senderId = SimpleID::decode(query.value(1).toByteArray());
record.destId = SimpleID::decode(query.value(2).toByteArray());
record.status = query.value(3).toLongLong();
record.date = query.value(4).toLongLong();
record.command = query.value(5).toString();
record.text = query.value(6).toString();
record.data = query.value(7).toByteArray();
return record;
}
void PreviewCore::add(const ChatId &id, const QList<QUrl> &urls)
{
SLOG_DEBUG(id.toBase32() << urls);
m_storage->add(id, urls);
}
