Method Add

Src/Database/DatabaseTree.cpp:615–671

}

int CDatabaseTree::Add(const TreeItem &item)
{
    bool ok = false;
    // Check if it is a leaf
    if(item.IsNode()) {
        qCritical(log) << "The item is not leaf";
        return 0;
    }

    QSqlQuery query(GetDatabase());
    
    // Check if it already exists
    query.prepare(
        "SELECT `id` FROM `" + m_szTableName + "` "
        " WHERE `key`=:key AND `parent_id`=:parent_id"
        );
    query.bindValue(":key", item.GetKey());
    query.bindValue(":parent_id", item.GetParentId());
    ok = query.exec();
    if(!ok) {
        SetError("Failed to add tree: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
        return 0;
    }
    if(query.next()) {
        return query.value(0).toInt();
    }

    // Insert
    query.prepare(
        "INSERT INTO `" + m_szTableName + "` (`name`, `key`, "
        "`created_time`, `modified_time`, `last_visit_time`, `parent_id`) "
        "VALUES (:name, :key, "
        ":created_time, :modified_time, :last_visit_time, :parent_id)"
        );
    query.bindValue(":name", item.GetName());
    query.bindValue(":key", item.GetKey());
    QDateTime time = QDateTime::currentDateTime();
    query.bindValue(":created_time", time);
    query.bindValue(":modified_time", time);
    query.bindValue(":last_visit_time", time);
    query.bindValue(":parent_id", item.GetParentId());

    bool bRet = query.exec();
    if (!bRet) {
        SetError("Failed to add tree item: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
        return 0;
    }

    int id = query.lastInsertId().toInt();
    if(0 < id)
        emit sigAdd(id, item.GetParentId());
    return id;
}