Method storeObservations_

src/openms/source/FORMAT/OMSFileStore.cpp:589–636

  void OMSFileStore::storeObservations_(const IdentificationData& id_data)
  {
    if (id_data.getObservations().empty()) return;

    createTable_("ID_Observation",
                 "id INTEGER PRIMARY KEY NOT NULL, "                    \
                 "data_id TEXT NOT NULL, "                              \
                 "input_file_id INTEGER NOT NULL, "                     \
                 "rt REAL, "                                            \
                 "mz REAL, "                                            \
                 "UNIQUE (data_id, input_file_id), "                    \
                 "FOREIGN KEY (input_file_id) REFERENCES ID_InputFile (id)");

    SQLite::Statement query(*db_, "INSERT INTO ID_Observation VALUES (" \
                  ":id, "                             \
                  ":data_id, "                        \
                  ":input_file_id, "                  \
                  ":rt, "                             \
                  ":mz)");
    Key id = 1;
    for (const ID::Observation& obs : id_data.getObservations())
    {
      query.bind(":id", id);
      query.bind(":data_id", obs.data_id);
      query.bind(":input_file_id", input_file_keys_[&(*obs.input_file)]);
      if (obs.rt == obs.rt)
      {
        query.bind(":rt", obs.rt);
      }
      else // NaN
      {
        query.bind(":rt"); // NULL
      }
      if (obs.mz == obs.mz)
      {
        query.bind(":mz", obs.mz);
      }
      else // NaN
      {
        query.bind(":mz"); // NULL
      }
      execWithExceptionAndReset(query, 1, __LINE__, OPENMS_PRETTY_FUNCTION, "error inserting data");

      observation_keys_[&obs] = id;
      ++id;
    }
    storeMetaInfos_(id_data.getObservations(), "ID_Observation", observation_keys_);
  }


  void OMSFileStore::storeParentSequences_(const IdentificationData& id_data)