Method storeCVTerm_

src/openms/source/FORMAT/OMSFileStore.cpp:154–191

  OMSFileStore::Key OMSFileStore::storeCVTerm_(const CVTerm& cv_term)
  {
    // this assumes the "CVTerm" table exists already!
    auto& query = *prepared_queries_["CVTerm"];
    if (cv_term.getAccession().empty()) // use NULL for empty accessions
    {
      query.bind(":accession");
    }
    else
    {
      query.bind(":accession", cv_term.getAccession());
    }
    query.bind(":name", cv_term.getName());
    query.bind(":cv_identifier_ref", cv_term.getCVIdentifierRef());
    if (execAndReset(query, 1)) // one row was inserted
    {
      return db_->getLastInsertRowid();
    }

    // else: insert has failed, record must already exist - get the key:
    auto& alt_query = *prepared_queries_["CVTerm_2"];
    alt_query.reset();                  // get ready for a new execution
    if (cv_term.getAccession().empty()) // use NULL for empty accessions
    {
      alt_query.bind(":accession");
    }
    else
    {
      alt_query.bind(":accession", cv_term.getAccession());
    }
    alt_query.bind(":name", cv_term.getName());
    if (!alt_query.executeStep())
    {
      raiseDBError_(alt_query.getErrorMsg(), __LINE__, OPENMS_PRETTY_FUNCTION, "error querying database");
    }

    return Key(alt_query.getColumn(0).getInt64());
  }


  void OMSFileStore::createTableMetaInfo_(const String& parent_table, const String& key_column)