l1t::OnlineDBqueryHelper Class Reference

#include <OnlineDBqueryHelper.h>

Static Public Member Functions
static std::map< std::string, std::string >	fetch (const std::vector< std::string > &queryColumns, const std::string &table, const std::string &key, l1t::OMDSReader &m_omdsReader)

Detailed Description

Definition at line 16 of file OnlineDBqueryHelper.h.

Member Function Documentation

fetch()

std::map< std::string, std::string > l1t::OnlineDBqueryHelper::fetch ( const std::vector< std::string > &  queryColumns, const std::string &  table, const std::string &  key, l1t::OMDSReader &  m_omdsReader  )

static

Definition at line 3 of file OnlineDBqueryHelper.cc.

References a, b, l1t::OMDSReader::basicQuery(), l1t::OMDSReader::QueryResults::fillVariable(), mps_fire::i, crabWrapper::key, GetRecoTauVFromDQM_MC_cff::next, l1t::OMDSReader::QueryResults::numberRows(), l1t::OMDSReader::QueryResults::queryFailed(), l1t::OMDSReader::singleAttribute(), AlCaHLTBitMon_QueryRunRegistry::string, TableParser::table, and HcalDetIdTransform::transform().

Referenced by L1TMuonOverlapObjectKeysOnlineProd::fillObjectKeys(), L1TMuonEndCapObjectKeysOnlineProd::fillObjectKeys(), L1TMuonEndCapParamsOnlineProd::newObject(), L1TMuonGlobalParamsOnlineProd::newObject(), L1TMuonBarrelParamsOnlineProd::newObject(), L1TMuonOverlapFwVersionOnlineProd::newObject(), L1TCaloParamsOnlineProd::newObject(), and L1TGlobalPrescalesVetosOnlineProd::newObject().

                                                                                                {
  if (queryColumns.empty() || table.length() == 0)
    return std::map<std::string, std::string>();

  l1t::OMDSReader::QueryResults queryResult =
      m_omdsReader.basicQuery(queryColumns, "CMS_TRG_L1_CONF", table, table + ".ID", m_omdsReader.singleAttribute(key));

  if (queryResult.queryFailed() || queryResult.numberRows() != 1)
    throw std::runtime_error(std::string("Cannot get ") + table + ".{" +
                             std::accumulate(std::next(queryColumns.begin()),
                                             queryColumns.end(),
                                             std::string(queryColumns[0]),
                                             [](const std::string &a, const std::string &b) { return a + "," + b; }) +
                             "} for ID = " + key);

  std::vector<std::string> retval(queryColumns.size());

  std::transform(queryColumns.begin(), queryColumns.end(), retval.begin(), [queryResult](const std::string &a) {
    std::string res;
    if (!queryResult.fillVariable(a, res))
      res = "";
    return res;
  });

  std::map<std::string, std::string> retvalMap;
  for (unsigned int i = 0; i < queryColumns.size(); i++)
    retvalMap.insert(make_pair(queryColumns[i], retval[i]));

  return retvalMap;
}