QSqlQuery query(logDb());
query.prepare("SELECT networkid FROM network "
"WHERE userid = :userid AND networkname = :networkname");
QSqlQuery query(logDb());
query.prepare("SELECT networkid FROM network "
"WHERE userid = :userid AND networkname = :networkname");
BufferInfo SqliteStorage::getBufferInfo(UserId user, const QString &network, const QString &buffer) {
BufferInfo bufferid;
// TODO: get rid of this hackaround
BufferInfo SqliteStorage::getBufferInfo(UserId user, const QString &network, const QString &buffer) {
BufferInfo bufferid;
// TODO: get rid of this hackaround
QSqlQuery *getBufferInfoQuery = cachedQuery("select_bufferByName");
getBufferInfoQuery->bindValue(":networkname", network);
QSqlQuery *getBufferInfoQuery = cachedQuery("select_bufferByName");
getBufferInfoQuery->bindValue(":networkname", network);
createBuffer(user, network, buffer);
getBufferInfoQuery->exec();
if(getBufferInfoQuery->first()) {
createBuffer(user, network, buffer);
getBufferInfoQuery->exec();
if(getBufferInfoQuery->first()) {
- bufferid = BufferInfo(getBufferInfoQuery->value(0).toUInt(), networkId, 0, network, buffer);
+ bufferid = BufferInfo(getBufferInfoQuery->value(0).value<BufferId>(), networkId, 0, network, buffer);
- bufferid = BufferInfo(getBufferInfoQuery->value(0).toUInt(), networkId, 0, network, buffer);
+ bufferid = BufferInfo(getBufferInfoQuery->value(0).value<BufferId>(), networkId, 0, network, buffer);
- bufferlist << BufferInfo(query.value(0).toUInt(), query.value(2).toUInt(), 0, query.value(3).toString(), query.value(1).toString());
+ bufferlist << BufferInfo(query.value(0).value<BufferId>(), query.value(2).value<NetworkId>(), 0, query.value(3).toString(), query.value(1).toString());
} else { // somethin went wrong... :(
qDebug() << getLastMessageIdQuery->lastQuery() << "time/bufferid/type/sender:" << msg.timestamp().toTime_t() << msg.buffer().uid() << msg.type() << msg.sender();
Q_ASSERT(false);
} else { // somethin went wrong... :(
qDebug() << getLastMessageIdQuery->lastQuery() << "time/bufferid/type/sender:" << msg.timestamp().toTime_t() << msg.buffer().uid() << msg.type() << msg.sender();
Q_ASSERT(false);
requestMsgsOffsetQuery->bindValue(":messageid", offset);
requestMsgsOffsetQuery->exec();
requestMsgsOffsetQuery->first();
requestMsgsOffsetQuery->bindValue(":messageid", offset);
requestMsgsOffsetQuery->exec();
requestMsgsOffsetQuery->first();
requestMsgsQuery->value(5).toString(),
requestMsgsQuery->value(4).toString(),
requestMsgsQuery->value(3).toUInt());
requestMsgsQuery->value(5).toString(),
requestMsgsQuery->value(4).toString(),
requestMsgsQuery->value(3).toUInt());
requestMsgsSinceOffsetQuery->bindValue(":since", since.toTime_t());
requestMsgsSinceOffsetQuery->exec();
requestMsgsSinceOffsetQuery->first();
requestMsgsSinceOffsetQuery->bindValue(":since", since.toTime_t());
requestMsgsSinceOffsetQuery->exec();
requestMsgsSinceOffsetQuery->first();
// now let's select the messages
QSqlQuery *requestMsgsSinceQuery = cachedQuery("select_messagesSince");
// now let's select the messages
QSqlQuery *requestMsgsSinceQuery = cachedQuery("select_messagesSince");
requestMsgsSinceQuery->value(5).toString(),
requestMsgsSinceQuery->value(4).toString(),
requestMsgsSinceQuery->value(3).toUInt());
requestMsgsSinceQuery->value(5).toString(),
requestMsgsSinceQuery->value(4).toString(),
requestMsgsSinceQuery->value(3).toUInt());
requestMsgRangeQuery->value(5).toString(),
requestMsgRangeQuery->value(4).toString(),
requestMsgRangeQuery->value(3).toUInt());
requestMsgRangeQuery->value(5).toString(),
requestMsgRangeQuery->value(4).toString(),
requestMsgRangeQuery->value(3).toUInt());