Method GetLeaves

Src/Database/DatabaseTree.cpp:852–885

}

QList<TreeItem> CDatabaseTree::GetLeaves(int nodeId)
{
    QList<TreeItem> items;
    QSqlQuery query(GetDatabase());
    QString szSql;
    szSql = "SELECT `id`, `name`, `key`, "
            "`created_time`, `modified_time`, `last_visit_time`, `parent_id` "
            "FROM `" + m_szTableName + "`";
    if(0 <= nodeId)
        szSql += " WHERE `parent_id` = :parent_id";
    query.prepare(szSql);
    query.bindValue(":parent_id", nodeId);
    bool bRet = query.exec();
    if (!bRet) {
        SetError("Failed to get leaves: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery()
                 + "; parentId: " + QString::number(nodeId));
        qCritical(log) << GetError();
        return items;
    }
    while(query.next()) {
        TreeItem item(TreeItem::Leaf);
        item.SetId(query.value(0).toInt());
        item.SetName(query.value(1).toString());
        item.SetKey(query.value(2).toInt());
        item.SetCreateTime(query.value(3).toDateTime());
        item.SetModifyTime(query.value(4).toDateTime());
        item.SetLastVisitTime(query.value(5).toDateTime());
        item.SetParentId(query.value(6).toInt());

        items.append(item);
    }
    return items;
}

QList<TreeItem> CDatabaseTree::GetLeavesByKey(int key)
{