Function loadEdgeValues

app/src/Sessions/ReportData.cpp:182–210

* @brief Loads the first or last numeric value per dataset; ties broken by reading_id. */

 * @brief Loads the first or last numeric value per dataset; ties broken by reading_id.
 */
static void loadEdgeValues(QSqlDatabase& db,
                           int sessionId,
                           std::vector<Sessions::DatasetStats>& datasets,
                           bool first)
{
  const QString aggregator = first ? QStringLiteral("MIN") : QStringLiteral("MAX");
  QSqlQuery q(db);
  q.prepare(QStringLiteral("SELECT unique_id, final_numeric_value FROM readings "
                           "WHERE reading_id IN ("
                           "  SELECT %1(reading_id) FROM readings "
                           "  WHERE session_id = ? AND is_numeric = 1 "
                           "  GROUP BY unique_id)")
              .arg(aggregator));
  q.bindValue(0, sessionId);
  if (!q.exec())
    return;

  while (q.next()) {
    const int uid = q.value(0).toInt();
    auto it       = findDatasetByUid(datasets, uid);
    if (it == datasets.end())
      continue;

    if (first)
      it->firstValue = SerialStudio::toDouble(q.value(1));
    else
      it->lastValue = SerialStudio::toDouble(q.value(1));
  }
}

/**
 * @brief Appends the alphabetically-sorted tag labels for a session into out.tags.