Method GetSubNodes

Src/Database/DatabaseTree.cpp:429–459

}

QList<TreeItem> CDatabaseNode::GetSubNodes(int parentId)
{
    QList<TreeItem> folders;

    QSqlQuery query(GetDatabase());
    query.prepare(
        "SELECT `id`, `name`, `parent_id`, `sort_order`, `created_time` "
        "FROM `" + m_szTableName + "` "
        "WHERE `parent_id` = :parent_id "
        "ORDER BY `sort_order`, `name`"
        );
    query.bindValue(":parent_id", parentId);
    if (query.exec()) {
        while (query.next()) {
            TreeItem folder(TreeItem::Node);
            folder.SetId(query.value(0).toInt());
            folder.SetName(query.value(1).toString());
            folder.SetParentId(query.value(2).toInt());
            folder.SetSortOrder(query.value(3).toInt());
            folder.SetCreateTime(query.value(4).toDateTime());
            folders.append(folder);
        }
    } else {
        SetError("Failed to get sub folders: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery()
                 + "; parentId: " + QString::number(parentId));
        qCritical(log) << GetError();
    }

    return folders;
}

bool CDatabaseNode::InSubNode(int parentId, int id)
{