Method loadParentGroupSets_

src/openms/source/FORMAT/OMSFileLoad.cpp:460–529

  void OMSFileLoad::loadParentGroupSets_(IdentificationData& id_data)
  {
    if (!db_->tableExists("ID_ParentGroupSet")) return;

    // "grouping_order" column was removed in schema version 3:
    String order_by = version_number_ > 2 ? "id" : "grouping_order";

    SQLite::Statement query(*db_, "SELECT * FROM ID_ParentGroupSet ORDER BY " + order_by + " ASC");
    // @TODO: can we combine handling of meta info and applied processing steps?
    SQLite::Statement subquery_info(*db_, "");
    bool have_meta_info = prepareQueryMetaInfo_(subquery_info,
                                                "ID_ParentGroupSet");
    SQLite::Statement subquery_step(*db_, "");
    bool have_applied_steps =
      prepareQueryAppliedProcessingStep_(subquery_step,
                                         "ID_ParentGroupSet");

    SQLite::Statement subquery_group(*db_, "SELECT * FROM ID_ParentGroup WHERE grouping_id = :id");

    SQLite::Statement subquery_parent(*db_, "SELECT parent_id FROM ID_ParentGroup_ParentSequence WHERE group_id = :id");

    while (query.executeStep())
    {
      ID::ParentGroupSet grouping(query.getColumn("label").getString());
      Key grouping_id = query.getColumn("id").getInt64();
      if (have_meta_info)
      {
        handleQueryMetaInfo_(subquery_info, grouping, grouping_id);
      }
      if (have_applied_steps)
      {
        handleQueryAppliedProcessingStep_(subquery_step, grouping, grouping_id);
      }

      subquery_group.bind(":id", grouping_id);
      // get all groups in this grouping:
      map<Key, ID::ParentGroup> groups_map;
      while (subquery_group.executeStep())
      {
        Key group_id = subquery_group.getColumn("id").getInt64();
        auto score_type_id = subquery_group.getColumn("score_type_id");
        if (score_type_id.isNull()) // no scores
        {
          groups_map[group_id]; // insert empty group
        }
        else
        {
          ID::ScoreTypeRef ref = score_type_refs_[score_type_id.getInt64()];
          groups_map[group_id].scores[ref] =
            subquery_group.getColumn("score").getDouble();
        }
      }
      subquery_group.reset(); // get ready for new executeStep()
      // get parent sequences in each group:
      for (auto& pair : groups_map)
      {
        subquery_parent.bind(":id", pair.first);
        while (subquery_parent.executeStep())