X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2Fsqlitestorage.cpp;h=7c46333d3044ef512311ea7e352dbb7d9a66398c;hp=68120e12ce1b081dc9293d049b3c09b72ff0407e;hb=eab5c456972d723fb3c67fe366548608f3bbeadc;hpb=f3fc0324c8860dff6af722dafbeb05fcb69a0c41 diff --git a/src/core/sqlitestorage.cpp b/src/core/sqlitestorage.cpp index 68120e12..7c46333d 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")); @@ -256,7 +269,7 @@ bool SqliteStorage::removeNetwork(UserId user, const NetworkId &networkId) { if(withTransaction) { sync(); if(!logDb().transaction()) { - qWarning() << "SqliteStorage::removeNetwork(): cannot start transaction. continuing with out rollback support!"; + quWarning() << "SqliteStorage::removeNetwork(): cannot start transaction. continuing with out rollback support!"; withTransaction = false; } } @@ -490,16 +503,19 @@ BufferInfo SqliteStorage::getBufferInfo(UserId user, const NetworkId &networkId, query->exec(); if(!query->first()) { watchQuery(query); - qWarning() << "unable to create BufferInfo for:" << user << networkId << buffer; + quWarning() << "unable to create BufferInfo for:" << user << networkId << buffer; return BufferInfo(); } } 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(); + quError() << "SqliteStorage::getBufferInfo(): received more then one Buffer!"; + quError() << " Query:" << query->lastQuery(); + quError() << " bound Values:"; + QList list = query->boundValues().values(); + for (int i = 0; i < list.size(); ++i) + quError() << 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; @@ -631,7 +662,7 @@ MsgId SqliteStorage::logMessage(Message msg) { logMessageQuery->bindValue(":type", msg.type()); 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()) { @@ -794,7 +825,7 @@ bool SqliteStorage::init(const QVariantMap &settings) { getPasswordsQuery.exec(); if(!watchQuery(&getPasswordsQuery)) { - qWarning() << "unable to migrate to new password format!"; + quError() << "unable to migrate to new password format!"; return false; } @@ -812,6 +843,6 @@ bool SqliteStorage::init(const QVariantMap &settings) { watchQuery(&setPasswordsQuery); } - qDebug() << "successfully migrated passwords!"; + quDebug() << "successfully migrated passwords!"; return true; }