Method storeDBSearchParams_

src/openms/source/FORMAT/OMSFileStore.cpp:431–514

  void OMSFileStore::storeDBSearchParams_(const IdentificationData& id_data)
  {
    if (id_data.getDBSearchParams().empty()) return;

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

    createTable_(
      "ID_DBSearchParam",
      "id INTEGER PRIMARY KEY NOT NULL, "                               \
      "molecule_type_id INTEGER NOT NULL, "                             \
      "mass_type_average NUMERIC NOT NULL CHECK (mass_type_average in (0, 1)) DEFAULT 0, " \
      "database TEXT, "                                                 \
      "database_version TEXT, "                                         \
      "taxonomy TEXT, "                                                 \
      "charges TEXT, "                                                  \
      "fixed_mods TEXT, "                                               \
      "variable_mods TEXT, "                                            \
      "precursor_mass_tolerance REAL, "                                 \
      "fragment_mass_tolerance REAL, "                                  \
      "precursor_tolerance_ppm NUMERIC NOT NULL CHECK (precursor_tolerance_ppm in (0, 1)) DEFAULT 0, " \
      "fragment_tolerance_ppm NUMERIC NOT NULL CHECK (fragment_tolerance_ppm in (0, 1)) DEFAULT 0, " \
      "digestion_enzyme TEXT, "                                         \
      "enzyme_term_specificity TEXT, " // new in version 2!
      "missed_cleavages NUMERIC, "                                      \
      "min_length NUMERIC, "                                            \
      "max_length NUMERIC, "                                            \
      "FOREIGN KEY (molecule_type_id) REFERENCES ID_MoleculeType (id)");

    SQLite::Statement query(*db_, "INSERT INTO ID_DBSearchParam VALUES (" \
                  ":id, "                                 \
                  ":molecule_type_id, "                   \
                  ":mass_type_average, "                  \
                  ":database, "                           \
                  ":database_version, "                   \
                  ":taxonomy, "                           \
                  ":charges, "                            \
                  ":fixed_mods, "                         \
                  ":variable_mods, "                      \
                  ":precursor_mass_tolerance, "           \
                  ":fragment_mass_tolerance, "            \
                  ":precursor_tolerance_ppm, "            \
                  ":fragment_tolerance_ppm, "             \
                  ":digestion_enzyme, "                   \
                  ":enzyme_term_specificity, "            \
                  ":missed_cleavages, "                   \
                  ":min_length, "                         \
                  ":max_length)");
    Key id = 1;
    for (const ID::DBSearchParam& param : id_data.getDBSearchParams())
    {
      query.bind(":id", id);
      query.bind(":molecule_type_id", int(param.molecule_type) + 1);
      query.bind(":mass_type_average", int(param.mass_type));
      query.bind(":database", param.database);
      query.bind(":database_version", param.database_version);
      query.bind(":taxonomy", param.taxonomy);
      String charges = ListUtils::concatenate(param.charges, ",");
      query.bind(":charges", charges);