- // now let's select the messages
- QSqlQuery *msgQuery = cachedQuery("select_messages");
- msgQuery->bindValue(":bufferid", bufferId.toInt());
- msgQuery->bindValue(":limit", lastmsgs);
- msgQuery->bindValue(":offset", offset);
- msgQuery->exec();
-
- watchQuery(msgQuery);
-
- while(msgQuery->next()) {
- Message msg(QDateTime::fromTime_t(msgQuery->value(1).toInt()),
- bufferInfo,
- (Message::Type)msgQuery->value(2).toUInt(),
- msgQuery->value(5).toString(),
- msgQuery->value(4).toString(),
- (Message::Flags)msgQuery->value(3).toUInt());
- msg.setMsgId(msgQuery->value(0).toInt());
- messagelist << msg;
- }
- return messagelist;
-}
-
-
-QList<Message> SqliteStorage::requestMsgs(UserId user, BufferId bufferId, QDateTime since, int offset) {
- QList<Message> messagelist;
+ query.bindValue(":bufferid", bufferId.toInt());
+ query.bindValue(":firstmsg", first.toInt());
+ query.bindValue(":limit", limit);
+ safeExec(query);