X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsqlitestorage.cpp;h=3176ec4b05318d8a8f472499504fc43f98cbda70;hp=d4b7d0c39e88f67f8648ce7820e9da968f093d42;hb=8ec76e512d20ce5d1dc76de556bb98a06b75d695;hpb=9f9d207ecf28dd5470ecef9d4076a3f447662a20 diff --git a/src/core/sqlitestorage.cpp b/src/core/sqlitestorage.cpp index d4b7d0c3..3176ec4b 100644 --- a/src/core/sqlitestorage.cpp +++ b/src/core/sqlitestorage.cpp @@ -612,11 +612,16 @@ MsgId SqliteStorage::logMessage(Message msg) { return msgId; } -QList SqliteStorage::requestMsgs(BufferInfo buffer, int lastmsgs, int offset) { +QList SqliteStorage::requestMsgs(UserId user, BufferId bufferId, int lastmsgs, int offset) { QList messagelist; + + BufferInfo bufferInfo = getBufferInfo(user, bufferId); + if(!bufferInfo.isValid()) + return messagelist; + // we have to determine the real offset first QSqlQuery *offsetQuery = cachedQuery("select_messagesOffset"); - offsetQuery->bindValue(":bufferid", buffer.bufferId().toInt()); + offsetQuery->bindValue(":bufferid", bufferId.toInt()); offsetQuery->bindValue(":messageid", offset); offsetQuery->exec(); offsetQuery->first(); @@ -624,7 +629,7 @@ QList SqliteStorage::requestMsgs(BufferInfo buffer, int lastmsgs, int o // now let's select the messages QSqlQuery *msgQuery = cachedQuery("select_messages"); - msgQuery->bindValue(":bufferid", buffer.bufferId().toInt()); + msgQuery->bindValue(":bufferid", bufferId.toInt()); msgQuery->bindValue(":limit", lastmsgs); msgQuery->bindValue(":offset", offset); msgQuery->exec(); @@ -633,7 +638,7 @@ QList SqliteStorage::requestMsgs(BufferInfo buffer, int lastmsgs, int o while(msgQuery->next()) { Message msg(QDateTime::fromTime_t(msgQuery->value(1).toInt()), - buffer, + bufferInfo, (Message::Type)msgQuery->value(2).toUInt(), msgQuery->value(5).toString(), msgQuery->value(4).toString(), @@ -645,11 +650,16 @@ QList SqliteStorage::requestMsgs(BufferInfo buffer, int lastmsgs, int o } -QList SqliteStorage::requestMsgs(BufferInfo buffer, QDateTime since, int offset) { +QList SqliteStorage::requestMsgs(UserId user, BufferId bufferId, QDateTime since, int offset) { QList messagelist; + + BufferInfo bufferInfo = getBufferInfo(user, bufferId); + if(!bufferInfo.isValid()) + return messagelist; + // we have to determine the real offset first QSqlQuery *offsetQuery = cachedQuery("select_messagesSinceOffset"); - offsetQuery->bindValue(":bufferid", buffer.bufferId().toInt()); + offsetQuery->bindValue(":bufferid", bufferId.toInt()); offsetQuery->bindValue(":since", since.toTime_t()); offsetQuery->exec(); offsetQuery->first(); @@ -657,7 +667,7 @@ QList SqliteStorage::requestMsgs(BufferInfo buffer, QDateTime since, in // now let's select the messages QSqlQuery *msgQuery = cachedQuery("select_messagesSince"); - msgQuery->bindValue(":bufferid", buffer.bufferId().toInt()); + msgQuery->bindValue(":bufferid", bufferId.toInt()); msgQuery->bindValue(":since", since.toTime_t()); msgQuery->bindValue(":offset", offset); msgQuery->exec(); @@ -666,7 +676,7 @@ QList SqliteStorage::requestMsgs(BufferInfo buffer, QDateTime since, in while(msgQuery->next()) { Message msg(QDateTime::fromTime_t(msgQuery->value(1).toInt()), - buffer, + bufferInfo, (Message::Type)msgQuery->value(2).toUInt(), msgQuery->value(5).toString(), msgQuery->value(4).toString(), @@ -679,10 +689,15 @@ QList SqliteStorage::requestMsgs(BufferInfo buffer, QDateTime since, in } -QList SqliteStorage::requestMsgRange(BufferInfo buffer, int first, int last) { +QList SqliteStorage::requestMsgRange(UserId user, BufferId bufferId, int first, int last) { QList messagelist; + + BufferInfo bufferInfo = getBufferInfo(user, bufferId); + if(!bufferInfo.isValid()) + return messagelist; + QSqlQuery *rangeQuery = cachedQuery("select_messageRange"); - rangeQuery->bindValue(":bufferid", buffer.bufferId().toInt()); + rangeQuery->bindValue(":bufferid", bufferId.toInt()); rangeQuery->bindValue(":firstmsg", first); rangeQuery->bindValue(":lastmsg", last); rangeQuery->exec(); @@ -691,7 +706,7 @@ QList SqliteStorage::requestMsgRange(BufferInfo buffer, int first, int while(rangeQuery->next()) { Message msg(QDateTime::fromTime_t(rangeQuery->value(1).toInt()), - buffer, + bufferInfo, (Message::Type)rangeQuery->value(2).toUInt(), rangeQuery->value(5).toString(), rangeQuery->value(4).toString(),