Method storeParentGroupSets_

src/openms/source/FORMAT/OMSFileStore.cpp:682–762

  void OMSFileStore::storeParentGroupSets_(const IdentificationData& id_data)
  {
    if (id_data.getParentGroupSets().empty()) return;

    createTable_("ID_ParentGroupSet",
                 "id INTEGER PRIMARY KEY NOT NULL, "    \
                 "label TEXT UNIQUE");

    createTable_(
      "ID_ParentGroup",
      "id INTEGER PRIMARY KEY NOT NULL, "                               \
      "grouping_id INTEGER NOT NULL, "                                  \
      "score_type_id INTEGER, "                                         \
      "score REAL, "                                                    \
      "UNIQUE (id, score_type_id), "                                    \
      "FOREIGN KEY (grouping_id) REFERENCES ID_ParentGroupSet (id)");

    createTable_(
      "ID_ParentGroup_ParentSequence",
      "group_id INTEGER NOT NULL, "                                     \
      "parent_id INTEGER NOT NULL, "                                    \
      "UNIQUE (group_id, parent_id), "                                  \
      "FOREIGN KEY (group_id) REFERENCES ID_ParentGroup (id), "         \
      "FOREIGN KEY (parent_id) REFERENCES ID_ParentSequence (id)");

    SQLite::Statement query_grouping(*db_, "INSERT INTO ID_ParentGroupSet VALUES ("     \
                           ":id, "                                      \
                           ":label)");

    SQLite::Statement query_group(*db_, "INSERT INTO ID_ParentGroup VALUES ("          \
                        ":id, "                                        \
                        ":grouping_id, "                               \
                        ":score_type_id, "                             \
                        ":score)");

   SQLite::Statement query_parent(*db_, "INSERT INTO ID_ParentGroup_ParentSequence VALUES (" \
                         ":group_id, "                                  \
                         ":parent_id)");

    Key grouping_id = 1;
    Key group_id = 1;
    for (const ID::ParentGroupSet& grouping : id_data.getParentGroupSets())
    {
      query_grouping.bind(":id", grouping_id);
      query_grouping.bind(":label", grouping.label);
      execWithExceptionAndReset(query_grouping, 1, __LINE__, OPENMS_PRETTY_FUNCTION, "error inserting data");

      for (const ID::ParentGroup& group : grouping.groups)
      {
        query_group.bind(":id", group_id);
        query_group.bind(":grouping_id", grouping_id);
        if (group.scores.empty()) // store group with an empty score
        {
          query_group.bind(":score_type_id");
          query_group.bind(":score");
          execWithExceptionAndReset(query_group, 1, __LINE__, OPENMS_PRETTY_FUNCTION, "error inserting data");
        }
        else // store group multiple times with different scores