Function read_nodes

cp-profiler/src/cpprofiler/db_handler.cpp:57–95

Reads all nodes from a database and builds the tree; returns `true` on success

/// Reads all nodes from a database and builds the tree; returns `true` on success
static bool read_nodes(QSqlDatabase *db, Execution &ex)
{
    const auto query = "select * from Nodes;";

    QSqlQuery select_stmt (*db);
    select_stmt.prepare(query);

    auto &tree = ex.tree();

    const auto total_nodes = count_nodes(db);
    print("We have {} nodes", total_nodes);

    tree.db_initialize(total_nodes);

    bool success = select_stmt.exec();

    if(!success) return false;

    while (select_stmt.next())
    {
        const auto nid = NodeID(select_stmt.value(0).toInt());
        const auto pid = NodeID(select_stmt.value(1).toInt());
        const auto alt = select_stmt.value(2).toInt();
        const auto kids = select_stmt.value(3).toInt();
        const auto status = tree::NodeStatus(select_stmt.value(4).toInt());
        const auto label = select_stmt.value(5).toString().toStdString();

        if (pid == NodeID::NoNode)
        {
            tree.db_createRoot(nid, label);
        }
        else
        {
            tree.db_addChild(nid, pid, alt, status, label);
        }
    }

    return success;
}

/// Read all bookmarks from the database
static bool read_bookmarks(QSqlDatabase *db, Execution &ex)