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

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, GetRecoTauVFromDQM_MC_cff::next, l1t::OMDSReader::QueryResults::numberRows(), l1t::OMDSReader::QueryResults::queryFailed(), l1t::OMDSReader::singleAttribute(), AlCaHLTBitMon_QueryRunRegistry::string, and create_public_lumi_plots::transform.

Referenced by L1TMuonEndcapObjectKeysOnlineProd::fillObjectKeys(), L1TMuonGlobalParamsOnlineProd::newObject(), L1TMuonEndCapParamsOnlineProd::newObject(), L1TMuonBarrelParamsOnlineProd::newObject(), L1TCaloParamsOnlineProd::newObject(), and L1TGlobalPrescalesVetosOnlineProd::newObject().

    {
        if( queryColumns.size() == 0 || 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;
    }