X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsqlitestorage.cpp;h=ef510e7c9d8607a7a94d1eb09326a4670dfa5793;hp=8cd4d5b05a720a84d23e16f0c7cd3d4ce062de65;hb=99934fe47293f61e1e62ecc0f0d49f958a992c32;hpb=8bae520ba868e36a2b53028f0571a022172abeb5 diff --git a/src/core/sqlitestorage.cpp b/src/core/sqlitestorage.cpp index 8cd4d5b0..ef510e7c 100644 --- a/src/core/sqlitestorage.cpp +++ b/src/core/sqlitestorage.cpp @@ -25,6 +25,7 @@ #include "network.h" #include "util.h" +#include "logger.h" SqliteStorage::SqliteStorage(QObject *parent) : AbstractSqlStorage(parent) @@ -112,6 +113,18 @@ UserId SqliteStorage::validateUser(const QString &user, const QString &password) } } +UserId SqliteStorage::internalUser() { + QSqlQuery query(logDb()); + query.prepare(queryString("select_internaluser")); + query.exec(); + + if(query.first()) { + return query.value(0).toInt(); + } else { + return 0; + } +} + void SqliteStorage::delUser(UserId user) { QSqlQuery query(logDb()); query.prepare(queryString("delete_backlog_by_uid")); @@ -497,9 +510,12 @@ BufferInfo SqliteStorage::getBufferInfo(UserId user, const NetworkId &networkId, BufferInfo bufferInfo = BufferInfo(query->value(0).toInt(), networkId, (BufferInfo::Type)query->value(1).toInt(), 0, buffer); if(query->next()) { - qWarning() << "SqliteStorage::getBufferInfo(): received more then one Buffer!"; - qWarning() << " Query:" << query->lastQuery(); - qWarning() << " bound Values:" << query->boundValues(); + qCritical() << "SqliteStorage::getBufferInfo(): received more then one Buffer!"; + qCritical() << " Query:" << query->lastQuery(); + qCritical() << " bound Values:"; + QList list = query->boundValues().values(); + for (int i = 0; i < list.size(); ++i) + qCritical() << i << ":" << list.at(i).toString().toAscii().data(); Q_ASSERT(false); } @@ -538,6 +554,21 @@ QList SqliteStorage::requestBuffers(UserId user) { return bufferlist; } +QList SqliteStorage::requestBufferIdsForNetwork(UserId user, NetworkId networkId) { + QList bufferList; + QSqlQuery query(logDb()); + query.prepare(queryString("select_buffers_for_network")); + query.bindValue(":networkid", networkId.toInt()); + query.bindValue(":userid", user.toInt()); + + query.exec(); + watchQuery(&query); + while(query.next()) { + bufferList << BufferId(query.value(0).toInt()); + } + return bufferList; +} + bool SqliteStorage::removeBuffer(const UserId &user, const BufferId &bufferId) { if(!isValidBuffer(user, bufferId)) return false; @@ -629,9 +660,9 @@ MsgId SqliteStorage::logMessage(Message msg) { logMessageQuery->bindValue(":time", msg.timestamp().toTime_t()); logMessageQuery->bindValue(":bufferid", msg.bufferInfo().bufferId().toInt()); logMessageQuery->bindValue(":type", msg.type()); - logMessageQuery->bindValue(":flags", msg.flags()); + logMessageQuery->bindValue(":flags", (int)msg.flags()); logMessageQuery->bindValue(":sender", msg.sender()); - logMessageQuery->bindValue(":message", msg.text()); + logMessageQuery->bindValue(":message", msg.contents()); logMessageQuery->exec(); if(logMessageQuery->lastError().isValid()) { @@ -688,7 +719,7 @@ QList SqliteStorage::requestMsgs(UserId user, BufferId bufferId, int la (Message::Type)msgQuery->value(2).toUInt(), msgQuery->value(5).toString(), msgQuery->value(4).toString(), - msgQuery->value(3).toUInt()); + (Message::Flags)msgQuery->value(3).toUInt()); msg.setMsgId(msgQuery->value(0).toInt()); messagelist << msg; } @@ -726,7 +757,7 @@ QList SqliteStorage::requestMsgs(UserId user, BufferId bufferId, QDateT (Message::Type)msgQuery->value(2).toUInt(), msgQuery->value(5).toString(), msgQuery->value(4).toString(), - msgQuery->value(3).toUInt()); + (Message::Flags)msgQuery->value(3).toUInt()); msg.setMsgId(msgQuery->value(0).toInt()); messagelist << msg; } @@ -756,7 +787,7 @@ QList SqliteStorage::requestMsgRange(UserId user, BufferId bufferId, in (Message::Type)rangeQuery->value(2).toUInt(), rangeQuery->value(5).toString(), rangeQuery->value(4).toString(), - rangeQuery->value(3).toUInt()); + (Message::Flags)rangeQuery->value(3).toUInt()); msg.setMsgId(rangeQuery->value(0).toInt()); messagelist << msg; } @@ -794,7 +825,7 @@ bool SqliteStorage::init(const QVariantMap &settings) { getPasswordsQuery.exec(); if(!watchQuery(&getPasswordsQuery)) { - qWarning() << "unable to migrate to new password format!"; + qCritical() << "unable to migrate to new password format!"; return false; }