Method storeProcessingSoftwares_

src/openms/source/FORMAT/OMSFileStore.cpp:373–428

  void OMSFileStore::storeProcessingSoftwares_(const IdentificationData& id_data)
  {
    if (id_data.getProcessingSoftwares().empty()) return;

    createTable_("ID_ProcessingSoftware",
                 "id INTEGER PRIMARY KEY NOT NULL, "  \
                 "name TEXT NOT NULL, "               \
                 "version TEXT, "                     \
                 "UNIQUE (name, version)");

    SQLite::Statement query(*db_, "INSERT INTO ID_ProcessingSoftware VALUES ("  \
                  ":id, "                                           \
                  ":name, "                                         \
                  ":version)");
    bool any_scores = false; // does any software have assigned scores stored?
    Key id = 1;
    for (const ID::ProcessingSoftware& software : id_data.getProcessingSoftwares())
    {
      if (!software.assigned_scores.empty()) any_scores = true;
      query.bind(":id", id);
      query.bind(":name", software.getName());
      query.bind(":version", software.getVersion());
      execWithExceptionAndReset(query, 1, __LINE__, OPENMS_PRETTY_FUNCTION, "error inserting data");
      processing_software_keys_[&software] = id;
      ++id;
    }
    if (any_scores)
    {
      createTable_(
        "ID_ProcessingSoftware_AssignedScore",
        "software_id INTEGER NOT NULL, "                                \
        "score_type_id INTEGER NOT NULL, "                              \
        "score_type_order INTEGER NOT NULL, "                           \
        "UNIQUE (software_id, score_type_id), "                         \
        "UNIQUE (software_id, score_type_order), "                      \
        "FOREIGN KEY (software_id) REFERENCES ID_ProcessingSoftware (id), " \
        "FOREIGN KEY (score_type_id) REFERENCES ID_ScoreType (id)");

      SQLite::Statement query2(*db_,
        "INSERT INTO ID_ProcessingSoftware_AssignedScore VALUES ("      \
        ":software_id, "                                                \
        ":score_type_id, "                                              \
        ":score_type_order)");
      for (const ID::ProcessingSoftware& software : id_data.getProcessingSoftwares())
      {
        query2.bind(":software_id", processing_software_keys_[&software]);
        Size counter = 0;
        for (ID::ScoreTypeRef score_type_ref : software.assigned_scores)
        {
          query2.bind(":score_type_id", score_type_keys_[&(*score_type_ref)]);
          query2.bind(":score_type_order", int(++counter));
          execWithExceptionAndReset(query2, 1, __LINE__, OPENMS_PRETTY_FUNCTION, "error inserting data");
        }
      }
    }
  }