Method GetLeavesByKey

Src/Database/DatabaseTree.cpp:887–918

}

QList<TreeItem> CDatabaseTree::GetLeavesByKey(int key)
{
    QList<TreeItem> items;
    QSqlQuery query(GetDatabase());
    QString szSql;
    szSql = "SELECT `id`, `name`, "
            " `created_time`, `modified_time`, `last_visit_time`, `parent_id` "
            " FROM `" + m_szTableName + "` "
            " WHERE `key` = :key";
    query.prepare(szSql);
    query.bindValue(":key", key);
    bool success = query.exec();
    if (!success) {
        SetError("Failed to get leaves by key: " + query.lastError().text()
                 + "; Sql: " + query.executedQuery()
                 + "; key: " + QString::number(key));
        return items;
    }
    while(query.next()) {
        TreeItem item(TreeItem::Leaf);
        item.SetId(query.value(0).toInt());
        item.SetName(query.value(1).toString());
        item.SetKey(key);
        item.SetCreateTime(query.value(2).toDateTime());
        item.SetModifyTime(query.value(3).toDateTime());
        item.SetLastVisitTime(query.value(4).toDateTime());
        item.SetParentId(query.value(5).toInt());

        items.append(item);
    }
    return items;
}

QList<TreeItem> CDatabaseTree::GetLeavesByKey(QList<int> key)
{