-BufferId SqliteStorage::getBufferId(UserId user, QString network, QString buffer) {
- BufferId bufferid;
- getBufferIdQuery->bindValue(":networkname", network);
- getBufferIdQuery->bindValue(":userid", user);
- getBufferIdQuery->bindValue(":buffername", buffer);
- getBufferIdQuery->exec();
+uint SqliteStorage::getNetworkId(UserId user, const QString &network) {
+ QSqlQuery query(logDb);
+ query.prepare("SELECT networkid FROM network "
+ "WHERE userid = :userid AND networkname = :networkname");
+ query.bindValue(":userid", user);
+ query.bindValue(":networkname", network);
+ query.exec();
+
+ if(query.first())
+ return query.value(0).toUInt();
+ else
+ return 0;
+}
+
+BufferInfo SqliteStorage::getBufferInfo(UserId user, const QString &network, const QString &buffer) {
+ BufferInfo bufferid;
+ uint networkId = getNetworkId(user, network);
+ getBufferInfoQuery->bindValue(":networkname", network);
+ getBufferInfoQuery->bindValue(":userid", user);
+ getBufferInfoQuery->bindValue(":buffername", buffer);
+ getBufferInfoQuery->exec();