Method storeConsensusFeatures_

src/openms/source/FORMAT/OMSFileStore.cpp:1499–1573

  void OMSFileStore::storeConsensusFeatures_(const ConsensusMap& consensus)
  {
    if (consensus.empty()) return;

    // create table(s) for BaseFeature parent class:
    // any meta infos on features?
    bool any_metainfo = any_of(consensus.begin(), consensus.end(), [](const ConsensusFeature& feature) {
      return !feature.isMetaEmpty();
    });
    // any ID observations on features?
    bool any_idmatches = any_of(consensus.begin(), consensus.end(), [](const ConsensusFeature& feature) {
      return !feature.getIDMatches().empty();
    });
    createTableBaseFeature_(any_metainfo, any_idmatches);

    createTable_("FEAT_FeatureHandle",
                 "feature_id INTEGER NOT NULL, "                        \
                 "map_index INTEGER NOT NULL, "                                    \
                 "FOREIGN KEY (feature_id) REFERENCES FEAT_BaseFeature (id)");
    SQLite::Statement query_handle(*db_,
                                   "INSERT INTO FEAT_FeatureHandle VALUES (" \
                                   ":feature_id, "                      \
                                   ":map_index)");

    // any ratios on consensus features?
    unique_ptr<SQLite::Statement> query_ratio; // only assign if needed below
    if (any_of(consensus.begin(), consensus.end(), [](const ConsensusFeature& feature) {
      return !feature.getRatios().empty();
    }))
    {
      createTable_("FEAT_ConsensusRatio",
                   "feature_id INTEGER NOT NULL, "                      \
                   "ratio_index INTEGER NOT NULL CHECK (ratio_index >= 0), " \
                   "ratio_value REAL, "                                 \
                   "denominator_ref TEXT, "                             \
                   "numerator_ref TEXT, "                               \
                   "description TEXT, "                                 \
                   "FOREIGN KEY (feature_id) REFERENCES FEAT_BaseFeature (id)");
      query_ratio = make_unique<SQLite::Statement>(*db_, "INSERT INTO FEAT_ConsensusRatio VALUES (" \
                                                   ":feature_id, "      \
                                                   ":ratio_index, "     \
                                                   ":ratio_value, "     \
                                                   ":denominator_ref, " \
                                                   ":numerator_ref, "   \
                                                   ":description)");
    }

    // consensus features and their subfeatures are stored in DFS-like order:
    int feature_id = 0;
    for (const ConsensusFeature& feat : consensus)
    {
      storeBaseFeature_(feat, feature_id, -1);
      int parent_id = feature_id;
      for (const FeatureHandle& handle : feat.getFeatures())
      {
        storeBaseFeature_(BaseFeature(handle), ++feature_id, parent_id);
        query_handle.bind(":feature_id", feature_id);
        query_handle.bind(":map_index", int64_t(handle.getMapIndex()));