Method Update

Src/Database/DatabaseTree.cpp:673–708

}

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

    QSqlQuery query(GetDatabase());
    query.prepare(
        "UPDATE `" + m_szTableName + "` SET "
        "`name` = :name, "
        "`key` = :key, "
        "`created_time` = :created_time, "
        "`modified_time` = :modified_time, "
        "`last_visit_time` = :last_visit_time, "
        "`parent_id` = :parent_id "
        "WHERE `id` = :id"
        );
    query.bindValue(":name", item.GetName());
    query.bindValue(":key", item.GetKey());
    query.bindValue(":created_time", item.GetCreateTime());
    query.bindValue(":modified_time", QDateTime::currentDateTime());
    query.bindValue(":last_visit_time", item.GetLastVisitTime());
    query.bindValue(":parent_id", item.GetParentId());
    query.bindValue(":id", item.GetId());
    qDebug(log) << "Sql:" << query.executedQuery();
    qDebug(log) << "Bound value:" << query.boundValues();
    bool bRet = query.exec();
    if (!bRet) {
        SetError("Failed to update tree item: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery());
        qCritical(log) << GetError();
    }
    return bRet;
}

bool CDatabaseTree::Delete(int id, bool delKey)
{