Method GetAllNodes

Src/Database/DatabaseTree.cpp:401–427

}

QList<TreeItem> CDatabaseNode::GetAllNodes()
{
    QList<TreeItem> folders;
    QSqlQuery query(GetDatabase());
    query.prepare(
        "SELECT `id`, `name`, `parent_id`, `sort_order`, `created_time` "
        " FROM `" + m_szTableName + "` "
        " ORDER BY `parent_id`, `sort_order`, `name`"
        );
    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 all folders: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
    }

    return folders;
}

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