+void SqliteStorage::setBufferLastSeen(UserId user, const BufferId &bufferId, const QDateTime &seenDate) {
+ QSqlQuery *query = cachedQuery("update_buffer_lastseen");
+ query->bindValue(":userid", user.toInt());
+ query->bindValue(":bufferid", bufferId.toInt());
+ query->bindValue(":lastseen", seenDate.toTime_t());
+ query->exec();
+ watchQuery(query);
+}
+
+QHash<BufferId, QDateTime> SqliteStorage::bufferLastSeenDates(UserId user) {
+ QHash<BufferId, QDateTime> lastSeenHash;
+ QSqlQuery query(logDb());
+ query.prepare(queryString("select_buffer_lastseen_dates"));
+ query.bindValue(":userid", user.toInt());
+ query.exec();
+ if(!watchQuery(&query))
+ return lastSeenHash;
+
+ while(query.next()) {
+ lastSeenHash[query.value(0).toInt()] = QDateTime::fromTime_t(query.value(1).toUInt());
+ }
+ return lastSeenHash;
+}
+