Method GetNode

Src/Database/DatabaseTree.cpp:374–399

}

TreeItem CDatabaseNode::GetNode(int id)
{
    TreeItem folder(TreeItem::Node);
    if(0 >= id) return folder;
    QSqlQuery query(GetDatabase());
    query.prepare(
        "SELECT `id`, `name`, `parent_id`, `sort_order`, `created_time` "
        "FROM `" + m_szTableName + "` "
        "WHERE `id`=:id"
        );
    query.bindValue(":id", id);
    if (query.exec()) {
        if(query.next()) {
            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());
        }
    } else {
        SetError("Failed to get folder: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery() +  QString::number(id));
        qCritical(log) << GetError();
    }
    return folder;
}

QList<TreeItem> CDatabaseNode::GetAllNodes()
{