Method GetFavorite

App/Client/Favorite/FavoriteDatabase.cpp:319–352

}

CFavoriteDatabase::Item CFavoriteDatabase::GetFavorite(int id)
{
    Item item(TreeItem::Leaf);
    auto leaf = GetLeaf(id);
    if(leaf.GetId() == 0)
        return item;

    QSqlQuery query(GetDatabase());
    query.prepare(
        "SELECT id, name, icon, file, description FROM favorite "
        "WHERE id = :id"
        );
    query.bindValue(":id", leaf.GetKey());
    //qDebug(log) << "SQL:" << query.executedQuery();
    //qDebug(log) << "Bound value:" << query.boundValues();
    bool ok = query.exec();
    if(!ok) {
        SetError("Failed to get favorite: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery()
                 + "; id: " + QString::number(id));
        qCritical(log) << GetError();
        return item;
    }
    if(query.next()) {
        item.id = leaf.GetId();
        item.parentId = leaf.GetParentId();
        item.szName = query.value(1).toString();
        item.icon = m_IconDB.GetIcon(query.value(2).toInt());
        item.szFile = query.value(3).toString();
        item.szDescription = query.value(4).toString();
        item.type = TreeItem::Leaf;
    }
    return item;
}

QList<CFavoriteDatabase::Item> CFavoriteDatabase::GetFavorite(const QString &szFile)
{