Method storeParentSequences_

src/openms/source/FORMAT/OMSFileStore.cpp:639–679

  void OMSFileStore::storeParentSequences_(const IdentificationData& id_data)
  {
    if (id_data.getParentSequences().empty()) return;

    if (!db_->tableExists("ID_MoleculeType")) createTableMoleculeType_();

    createTable_(
      "ID_ParentSequence",
      "id INTEGER PRIMARY KEY NOT NULL, "                               \
      "accession TEXT UNIQUE NOT NULL, "                                \
      "molecule_type_id INTEGER NOT NULL, "                             \
      "sequence TEXT, "                                                 \
      "description TEXT, "                                              \
      "coverage REAL, "                                                 \
      "is_decoy NUMERIC NOT NULL CHECK (is_decoy in (0, 1)) DEFAULT 0, " \
      "FOREIGN KEY (molecule_type_id) REFERENCES ID_MoleculeType (id)");

    SQLite::Statement query(*db_, "INSERT INTO ID_ParentSequence VALUES ("  \
                  ":id, "                                   \
                  ":accession, "                            \
                  ":molecule_type_id, "                     \
                  ":sequence, "                             \
                  ":description, "                          \
                  ":coverage, "                             \
                  ":is_decoy)");
    Key id = 1;
    for (const ID::ParentSequence& parent : id_data.getParentSequences())
    {
      query.bind(":id", id);
      query.bind(":accession", parent.accession);
      query.bind(":molecule_type_id", int(parent.molecule_type) + 1);
      query.bind(":sequence", parent.sequence);
      query.bind(":description", parent.description);
      query.bind(":coverage", parent.coverage);
      query.bind(":is_decoy", int(parent.is_decoy));
      execWithExceptionAndReset(query, 1, __LINE__, OPENMS_PRETTY_FUNCTION, "error inserting data");
      parent_sequence_keys_[&parent] = id;
      ++id;
    }
    storeScoredProcessingResults_(id_data.getParentSequences(), "ID_ParentSequence", parent_sequence_keys_);
  }


  void OMSFileStore::storeParentGroupSets_(const IdentificationData& id_data)