Method storeInputFiles_

src/openms/source/FORMAT/OMSFileStore.cpp:341–370

  void OMSFileStore::storeInputFiles_(const IdentificationData& id_data)
  {
    if (id_data.getInputFiles().empty()) return;

    createTable_("ID_InputFile",
                 "id INTEGER PRIMARY KEY NOT NULL, "  \
                 "name TEXT UNIQUE NOT NULL, "        \
                 "experimental_design_id TEXT, "      \
                 "primary_files TEXT");

    SQLite::Statement query(*db_, "INSERT INTO ID_InputFile VALUES ("  \
                  ":id, "                              \
                  ":name, "                            \
                  ":experimental_design_id, "          \
                  ":primary_files)");
    Key id = 1;
    for (const ID::InputFile& input : id_data.getInputFiles())
    {
      query.bind(":id", id);
      query.bind(":name", input.name);
      query.bind(":experimental_design_id",
                      input.experimental_design_id);
      // @TODO: what if a primary file name contains ","?
      String primary_files = ListUtils::concatenate(input.primary_files, ",");
      query.bind(":primary_files", primary_files);
      execWithExceptionAndReset(query, 1, __LINE__, OPENMS_PRETTY_FUNCTION, "error inserting data");
      input_file_keys_[&input] = id;
      ++id;
    }
  }


  void OMSFileStore::storeProcessingSoftwares_(const IdentificationData& id_data)