Method MoveNode

Src/Database/DatabaseTree.cpp:342–372

}

bool CDatabaseNode::MoveNode(int id, int newParentId)
{
    if(id == newParentId) {
        SetError("Failed to move node. The same node: " + id);
        qWarning(log) << GetError();
        return false;
    }
    // Check the newParentId is not the child of id
    bool bRet = InSubNode(id, newParentId);
    if(bRet) {
        SetError("The id is the parent of newParentId. "
                 + QString::number(id) + " is the parent of "
                 + QString::number(newParentId));
        qWarning(log) << GetError();
        return false;
    }
    QSqlQuery query(GetDatabase());
    query.prepare("UPDATE `" + m_szTableName + "` "
                  " SET `parent_id` = :parent_id WHERE `id` = :id");
    query.bindValue(":id", id);
    query.bindValue(":parent_id", newParentId);
    bRet = query.exec();
    if (bRet)
        emit sigChanged();
    else {
        SetError("Failed to move folders: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
    }
    return bRet;
}

TreeItem CDatabaseNode::GetNode(int id)
{