Method AddNode

Src/Database/DatabaseTree.cpp:208–271

}

int CDatabaseNode::AddNode(const QString &name, int parentId)
{
    bool bRet = false;
    QSqlQuery query(GetDatabase());

    // Check if it already exists
    query.prepare("SELECT id FROM `" + m_szTableName + "` "
                  " WHERE `parent_id` = :parent_id "
                  " AND `name`=:name"
                  );
    query.bindValue(":parent_id", parentId);
    query.bindValue(":name", name);
    bRet = query.exec();
    if(!bRet) {
        SetError("Failed to add folders: " + query.lastError().text()
                       + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
        return 0;
    }
    if(query.next()) {
        return query.value(0).toInt();
    }

    // 获取最大排序值
    query.prepare("SELECT MAX(sort_order) FROM `" + m_szTableName + "` "
                  " WHERE `parent_id` = :parent_id");
    query.bindValue(":parent_id", parentId);
    bRet = query.exec();
    if(!bRet) {
        SetError("Failed to get max sort_order: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
        return 0;
    }
    int maxOrder = 0;
    if (query.next()) {
        maxOrder = query.value(0).toInt() + 1;
    }

    query.prepare(
        "INSERT INTO `" + m_szTableName + "` "
        " (`name`, `parent_id`, `sort_order`) "
        " VALUES (:name, :parent_id, :sort_order) "
        );
    query.bindValue(":name", name);
    query.bindValue(":parent_id", parentId);
    query.bindValue(":sort_order", maxOrder);

    int id = 0;
    bRet = query.exec();
    if (bRet) {
        id = query.lastInsertId().toInt();
        if(id > 0) {
            emit sigAddNode(id, parentId);
            emit sigChanged();
        }
    } else {
        SetError("Failed to add folders: " + query.lastError().text()