#include <EcalCondDBInterface.h>

Inheritance diagram for EcalCondDBInterface:

Public Member Functions
void	dummy ()

	EcalCondDBInterface (std::string host, std::string sid, std::string user, std::string pass, int port=1521)

	EcalCondDBInterface (std::string sid, std::string user, std::string pass)

CaliIOV	fetchCaliIOV (CaliTag *tag, const Tm &evenTm) throw (std::runtime_error)

template<class DATT , class ICONF >
void	fetchConfigDataSet (std::vector< DATT > fillMap, ICONF iconf) throw (std::runtime_error)

template<class ICONF >
void	fetchConfigSet (ICONF *iconf) throw (std::runtime_error)

template<class DATT , class IOVT >
void	fetchDataSet (std::map< EcalLogicID, DATT > fillMap, IOVT iov) throw (std::runtime_error)

template<class DATT , class IOVT >
void	fetchDataSetWithMap (std::map< EcalLogicID, DATT > fillMap, IOVT iov, std::string mapping_name) throw (std::runtime_error)

template<class DATT >
void	fetchDCSDataSet (std::list< std::pair< Tm, std::map< EcalLogicID, DATT > > > *fillMap, const Tm &t) throw (std::runtime_error)

DCSPTMTempList	fetchDCSPTMTempList (const EcalLogicID &ecid) throw (std::runtime_error)

DCSPTMTempList	fetchDCSPTMTempList (const EcalLogicID &ecid, const Tm &start, const Tm &end) throw (std::runtime_error)

DCUIOV	fetchDCUIOV (DCUTag *tag, const Tm &evenTm) throw (std::runtime_error)

std::list< ODDelaysDat >	fetchFEDelaysForRun (RunIOV *iov) throw (std::runtime_error)

RunList	fetchGlobalRunListByLocation (const RunTag &tag, int min_run, int max_run, const LocationDef &locDef) throw (std::runtime_error)

template<class ICONF >
void	fetchLastConfigSet (ICONF *iconf) throw (std::runtime_error)

RunIOV	fetchLMFLastRun () const

LMFRunIOV	fetchLMFRunIOV (RunTag runtag, LMFRunTag lmftag, run_t run, subrun_t lmfrun) throw (std::runtime_error)

bool	fetchLMFRunIOV (const LMFSeqDat &, LMFRunIOV &, int lmr, int type, int color) const

MonRunIOV	fetchMonRunIOV (RunTag runtag, MonRunTag montag, run_t run, subrun_t monrun) throw (std::runtime_error)

MonRunList	fetchMonRunList (const RunTag &tag, const MonRunTag &monruntag) throw (std::runtime_error)

MonRunList	fetchMonRunList (const RunTag &tag, const MonRunTag &monruntag, int min_run, int max_run) throw (std::runtime_error)

MonRunList	fetchMonRunListLastNRuns (const RunTag &tag, const MonRunTag &monruntag, int max_run, int n_runs) throw (std::runtime_error)

RunList	fetchNonEmptyGlobalRunList (const RunTag &tag, int min_run, int max_run) throw (std::runtime_error)

RunList	fetchNonEmptyRunList (const RunTag &tag, int min_run, int max_run) throw (std::runtime_error)

RunIOV	fetchRunIOV (RunTag *tag, run_t run) throw (std::runtime_error)

RunIOV	fetchRunIOV (std::string location, run_t run) throw (std::runtime_error)

RunIOV	fetchRunIOV (std::string location, const Tm &t) throw (std::runtime_error)

RunList	fetchRunList (const RunTag &tag) throw (std::runtime_error)

RunList	fetchRunList (const RunTag &tag, int min_run, int max_run) throw (std::runtime_error)

RunList	fetchRunListByLocation (const RunTag &tag, int min_run, int max_run, const LocationDef &locDef) throw (std::runtime_error)

RunList	fetchRunListLastNRuns (const RunTag &tag, int max_run, int n_runs) throw (std::runtime_error)

template<class DATT , class IOVT >
void	fetchValidDataSet (std::map< EcalLogicID, DATT > fillMap, IOVT fillIOV, RunTag *tag, run_t run=(unsigned int)-1) throw (std::runtime_error)

template<class DATT , class IOVT >
void	fetchValidDataSet (std::map< EcalLogicID, DATT > fillMap, IOVT fillIOV, std::string location, run_t run=(unsigned int)-1) throw (std::runtime_error)

DateHandler *	getDateHandler ()

std::map< int, int >	getDetId2LogicIdMap ()

int	getDetIdFromLogicId (int logic_id)

EcalLogicID	getEcalLogicID (std::string name, int id1=EcalLogicID::NULLID, int id2=EcalLogicID::NULLID, int id3=EcalLogicID::NULLID, std::string mapsTo="") throw (std::runtime_error)

EcalLogicID	getEcalLogicID (int logicID) throw (std::runtime_error)

std::map< int, int >	getEcalLogicID2LmrMap ()

std::vector< EcalLogicID >	getEcalLogicIDForLMPN (int lmr_logic_id)

std::vector< EcalLogicID >	getEcalLogicIDForLMPN (const EcalLogicID &lmr_logic_id)

std::vector< EcalLogicID >	getEcalLogicIDForLMR (int lmr_logic_id)

std::vector< EcalLogicID >	getEcalLogicIDForLMR (const EcalLogicID &lmr_logic_id)

std::vector< EcalLogicID >	getEcalLogicIDMappedTo (int logic_id, std::string maps_to)

std::vector< EcalLogicID >	getEcalLogicIDSet (std::string name, int fromId1=EcalLogicID::NULLID, int toId1=EcalLogicID::NULLID, int fromId2=EcalLogicID::NULLID, int toId2=EcalLogicID::NULLID, int fromId3=EcalLogicID::NULLID, int toId3=EcalLogicID::NULLID, std::string mapsTo="") throw (std::runtime_error)

std::vector< EcalLogicID >	getEcalLogicIDSetOrdered (std::string name, int fromId1, int toId1, int fromId2=EcalLogicID::NULLID, int toId2=EcalLogicID::NULLID, int fromId3=EcalLogicID::NULLID, int toId3=EcalLogicID::NULLID, std::string mapsTo="", int orderedBy=EcalLogicID::NULLID) throw (std::runtime_error)

std::map< int, int >	getLogicId2DetIdMap ()

int	getLogicIdFromDetId (int det_id)

template<class DATT , class ICONF >
void	insertConfigDataArraySet (const std::vector< DATT > &data, ICONF *iconf) throw (std::runtime_error)

template<class DATT , class ICONF >
void	insertConfigDataSet (const std::vector< DATT > data, ICONF *iconf) throw (std::runtime_error)

template<class ICONF >
void	insertConfigSet (ICONF *iconf) throw (std::runtime_error)

template<class DATT , class IOVT >
void	insertDataArraySet (const std::map< EcalLogicID, DATT > data, IOVT iov) throw (std::runtime_error)

template<class DATT , class IOVT >
void	insertDataSet (const std::map< EcalLogicID, DATT > data, IOVT iov) throw (std::runtime_error)

template<class DATT , class IOVT >
void	insertDataSetVector (const std::vector< EcalLogicID > &ecid, const std::vector< IOVT > &run_iov, const std::vector< DATT > &data) throw (std::runtime_error)

void	insertDCUIOV (DCUIOV *iov) throw (std::runtime_error)

void	insertLmfDat (LMFDat *dat) throw (std::runtime_error)

void	insertLmfDat (std::list< LMFDat * > dat) throw (std::runtime_error)

void	insertLmfIOV (LMFIOV *iov) throw (std::runtime_error)

void	insertLmfLmrSubIOV (LMFLmrSubIOV *iov) throw (std::runtime_error)

void	insertLmfRunIOV (LMFRunIOV *iov) throw (std::runtime_error)

void	insertLmfSeq (LMFSeqDat *iov) throw (std::runtime_error)

void	insertMonRunIOV (MonRunIOV *iov) throw (std::runtime_error)

void	insertRunIOV (RunIOV *iov) throw (std::runtime_error)

void	updateRunConfig (ODRunConfigInfo *od) throw (std::runtime_error)

void	updateRunIOV (RunIOV *iov) throw (std::runtime_error)

void	updateRunIOVEndTime (RunIOV *iov) throw (std::runtime_error)

void	updateRunIOVStartTime (RunIOV *iov) throw (std::runtime_error)

virtual	~EcalCondDBInterface () throw (std::runtime_error)

Public Member Functions inherited from EcalDBConnection
void	commit ()

oracle::occi::Statement *	createStatement ()

	EcalDBConnection (std::string host, std::string sid, std::string user, std::string pass, int port=1521) throw (std::runtime_error)

	EcalDBConnection (std::string sid, std::string user, std::string pass) throw (std::runtime_error)

oracle::occi::Clob	getClobLocator ()

oracle::occi::Connection *	getConn () const

oracle::occi::Environment *	getEnv () const

void	rollback ()

void	terminateStatement (oracle::occi::Statement *stmt)

virtual	~EcalDBConnection () throw (std::runtime_error)

Private Member Functions
	EcalCondDBInterface ()

	EcalCondDBInterface (const EcalCondDBInterface &copy)

void	fillLogicId2DetIdMaps ()

Private Attributes
std::map< int, int >	_detId2LogicId

std::map< int, int >	_logicId2DetId

DateHandler *	dh

Additional Inherited Members
Protected Attributes inherited from EcalDBConnection
oracle::occi::Connection *	conn

oracle::occi::Environment *	env

std::string	host

std::string	pass

int	port

std::string	sid

oracle::occi::Statement *	stmt

std::string	user

Detailed Description

Definition at line 38 of file EcalCondDBInterface.h.

Constructor & Destructor Documentation

EcalCondDBInterface::EcalCondDBInterface	(	std::string	host,
		std::string	sid,
		std::string	user,
		std::string	pass,
		int	port = `1521`
	)

inline

Constructor, makes connection to DB without TNS_ADMIN === Parameters === host: DB host machine sid: DB SID (name) user: User to connect pass: Password for user port: port number to connect, default 1521

Definition at line 54 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, dh, and EcalDBConnection::env.

     : EcalDBConnection( host, sid, user, pass, port )
     {
       // call the parent constructor
 
       // create a DateHandler
       dh = new DateHandler(env, conn);
     }

EcalCondDBInterface::EcalCondDBInterface	(	std::string	sid,
		std::string	user,
		std::string	pass
	)

inline

Constructor, makes connection to DB with TNS_ADMIN === Parameters === sid: DB SID (name) user: User to connect pass: Password for user

Definition at line 76 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, dh, and EcalDBConnection::env.

     : EcalDBConnection( sid, user, pass )
     {
       // call the parent constructor
 
       // create a DateHandler
       dh = new DateHandler(env, conn);
     }

virtual EcalCondDBInterface::~EcalCondDBInterface	(		)
throw	(	std::runtime_error
	)

inlinevirtual

Destructor

Definition at line 91 of file EcalCondDBInterface.h.

References dh.

     {
       // call the parent destructor
       
       // destroy the DateHandler
       delete(dh);
     }

EcalCondDBInterface::EcalCondDBInterface ( )

private

EcalCondDBInterface::EcalCondDBInterface ( const EcalCondDBInterface & copy )

private

Member Function Documentation

void EcalCondDBInterface::dummy ( )

Definition at line 919 of file EcalCondDBInterface.cc.

920 {

921 }

CaliIOV EcalCondDBInterface::fetchCaliIOV	(	CaliTag *	tag,
		const Tm &	evenTm
	)
throw	(	std::runtime_error
	)

Return a Calibration IOV object

Definition at line 791 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, CaliIOV::setByTm(), IDBObject::setConnection(), and GlobalPosition_Frontier_DevDB_cff::tag.

 {
   CaliIOV caliiov;
   caliiov.setConnection(env, conn);
   caliiov.setByTm(tag, eventTm);
   return caliiov;
 }

template<class DATT , class ICONF >

void EcalCondDBInterface::fetchConfigDataSet	(	std::vector< DATT > *	fillMap,
		ICONF *	iconf
	)
throw	(	std::runtime_error
	)

inline

Definition at line 557 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, and EcalDBConnection::env.

   {
 
     DATT datiface;
     datiface.setConnection(env, conn);
     datiface.createReadStatement();
     datiface.setPrefetchRowCount(1024);
     datiface.fetchData( fillMap, iconf );
     datiface.terminateReadStatement();
 
   }

template<class ICONF >

void EcalCondDBInterface::fetchConfigSet	(	ICONF *	iconf	)
throw	(	std::runtime_error
	)

inline

Definition at line 448 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, and EcalDBConnection::env.

Referenced by EcalTPGDBApp::readFromConfDB_TPGPedestals().

   {
 
     iconf->clear();
     iconf->setConnection(env, conn);
     iconf->createReadStatement();
     iconf->fetchData(iconf);
     iconf->terminateReadStatement();
 
   }

template<class DATT , class IOVT >

void EcalCondDBInterface::fetchDataSet	(	std::map< EcalLogicID, DATT > *	fillMap,
		IOVT *	iov
	)
throw	(	std::runtime_error
	)

inline

Definition at line 580 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, EcalDBConnection::env, and o2o::iov.

Referenced by EcalTPGParamBuilder::analyze(), ecaldqm::fetchAndFill(), EcalTPGDBApp::readFromCondDB_Pedestals(), and EcalTPGDBApp::readFromConfDB_TPGPedestals().

   {
     fillMap->clear();
 
     DATT datiface;
     datiface.setConnection(env, conn);
     datiface.createReadStatement();
     datiface.setPrefetchRowCount(1024);
     datiface.fetchData( fillMap, iov );
     datiface.terminateReadStatement();
 
   }

template<class DATT , class IOVT >

void EcalCondDBInterface::fetchDataSetWithMap	(	std::map< EcalLogicID, DATT > *	fillMap,
		IOVT *	iov,
		std::string	mapping_name
	)
throw	(	std::runtime_error
	)

inline

Definition at line 624 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, EcalDBConnection::env, and o2o::iov.

   {
     fillMap->clear();
 
     DATT datiface;
     datiface.setConnection(env, conn);
     datiface.createReadStatement();
     datiface.setPrefetchRowCount(1024);
     datiface.fetchData( fillMap, iov , mapping_name);
     datiface.terminateReadStatement();
 
   }

template<class DATT >

void EcalCondDBInterface::fetchDCSDataSet	(	std::list< std::pair< Tm, std::map< EcalLogicID, DATT > > > *	fillMap,
		const Tm &	t
	)
throw	(	std::runtime_error
	)

inline

Definition at line 601 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, EcalDBConnection::env, and tree::t.

   {
     fillMap->clear();
     
     DATT datiface;
     datiface.setConnection(env, conn);
     datiface.createReadStatement();
     datiface.setPrefetchRowCount(1024);
     datiface.fetchHistoricalData( fillMap, t );
     datiface.terminateReadStatement();
     
   }

DCSPTMTempList EcalCondDBInterface::fetchDCSPTMTempList	(	const EcalLogicID &	ecid	)
throw	(	std::runtime_error
	)

Return a PTM Temp List

Definition at line 800 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, DCSPTMTempList::fetchValuesForECID(), alignCSCRings::r, and IDBObject::setConnection().

 {  
   DCSPTMTempList r;
   r.setConnection(env, conn);
   r.fetchValuesForECID(ecid);
   return r;
 }

DCSPTMTempList EcalCondDBInterface::fetchDCSPTMTempList	(	const EcalLogicID &	ecid,
		const Tm &	start,
		const Tm &	end
	)
throw	(	std::runtime_error
	)

Definition at line 809 of file EcalCondDBInterface.cc.

References results_mgr::conn, end, web.browse_db::env, DCSPTMTempList::fetchValuesForECIDAndTime(), alignCSCRings::r, IDBObject::setConnection(), and dqm_diff::start.

 {  
   DCSPTMTempList r;
   r.setConnection(env, conn);
   r.fetchValuesForECIDAndTime(ecid, start, end);
   return r;
 }

DCUIOV EcalCondDBInterface::fetchDCUIOV	(	DCUTag *	tag,
		const Tm &	evenTm
	)
throw	(	std::runtime_error
	)

Return a DCU IOV object

Definition at line 736 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, DCUIOV::setByTm(), IDBObject::setConnection(), and GlobalPosition_Frontier_DevDB_cff::tag.

 {
   DCUIOV dcuiov;
   dcuiov.setConnection(env, conn);
   dcuiov.setByTm(tag, eventTm);
   return dcuiov;
 }

std::list< ODDelaysDat > EcalCondDBInterface::fetchFEDelaysForRun	(	RunIOV *	iov	)
throw	(	std::runtime_error
	)

Return run Fe Config Dat objects for a given run

Definition at line 106 of file EcalCondDBInterface.cc.

References results_mgr::conn, ztail::d, alignCSCRings::e, web.browse_db::env, RunFEConfigDat::fetchData(), ODDelaysDat::fetchData(), ODFEDAQConfig::fetchData(), ODFEDAQConfig::getDelayId(), i, o2o::iov, run_regression::ret, IDBObject::setConnection(), ODFEDAQConfig::setId(), and groupFilesInBlocks::temp.

 {
   std::list<ODDelaysDat> ret;
   RunFEConfigDat d;
   std::map<EcalLogicID, RunFEConfigDat > fillMap;
   try {
     d.setConnection(env, conn);
     d.fetchData(&fillMap, iov);
   } catch (std::runtime_error &e) {
     throw e;
   }
   std::map<EcalLogicID, RunFEConfigDat >::const_iterator i = fillMap.begin();
   std::map<EcalLogicID, RunFEConfigDat >::const_iterator e = fillMap.end();
   while (i != e) {
     ODFEDAQConfig feDaqConfig;
     ODFEDAQConfig temp;
     temp.setId(i->second.getConfigId());
     feDaqConfig.setConnection(env, conn);
     feDaqConfig.fetchData(&temp);
     std::vector<ODDelaysDat> delays;
     ODDelaysDat temp2;
     temp2.setConnection(env, conn);
     temp2.fetchData(&delays, temp.getDelayId());
     std::vector<ODDelaysDat>::const_iterator di = delays.begin();
     std::vector<ODDelaysDat>::const_iterator de = delays.end();
     while (di != de) {
       ret.push_back(*di++);
     }
     i++;
   }
   return ret;
 }

RunList EcalCondDBInterface::fetchGlobalRunListByLocation	(	const RunTag &	tag,
		int	min_run,
		int	max_run,
		const LocationDef &	locDef
	)
throw	(	std::runtime_error
	)

Definition at line 861 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, RunList::fetchGlobalRunsByLocation(), alignCSCRings::r, IDBObject::setConnection(), RunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

                           {
   RunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.fetchGlobalRunsByLocation( min_run,  max_run, locDef);
   return r;
 }

template<class ICONF >

void EcalCondDBInterface::fetchLastConfigSet	(	ICONF *	iconf	)
throw	(	std::runtime_error
	)

inline

Definition at line 464 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, and EcalDBConnection::env.

   {
 
     iconf->clear();
     iconf->setConnection(env, conn);
     iconf->createReadStatement();
     iconf->fetchLastData(iconf);
     iconf->terminateReadStatement();
 
   }

RunIOV EcalCondDBInterface::fetchLMFLastRun ( ) const

Definition at line 745 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and LMFSeqDat::fetchLastRun().

                                                   {
   LMFSeqDat seq(env, conn);
   return seq.fetchLastRun();
 }

LMFRunIOV EcalCondDBInterface::fetchLMFRunIOV	(	RunTag *	runtag,
		LMFRunTag *	lmftag,
		run_t	run,
		subrun_t	lmfrun
	)
throw	(	std::runtime_error
	)

Return a laser monitoring farm run object

Definition at line 750 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, DTTTrigCorrFirst::run, and IDBObject::setConnection().

 {
   RunIOV runiov = fetchRunIOV(runtag, run);
   LMFRunIOV lmfiov;
   lmfiov.setConnection(env, conn);
   //  lmfiov.setByRun(lmftag, &runiov, subrun);
   return lmfiov;
 }

bool EcalCondDBInterface::fetchLMFRunIOV	(	const LMFSeqDat &	seq,
		LMFRunIOV &	iov,
		int	lmr,
		int	type,
		int	color
	)		const

Definition at line 760 of file EcalCondDBInterface.cc.

References results_mgr::conn, gather_cfg::cout, web.browse_db::env, LMFRunIOV::fetchBySequence(), LMFRunIOV::fetchLastBeforeSequence(), LMFUnique::getID(), ntuplemaker::iovlist, run_regression::ret, alignCSCRings::s, and IDBObject::setConnection().

                                                           {
   bool ret = false;
   iov.setConnection(env, conn);
   std::list<LMFRunIOV> iovlist = iov.fetchBySequence(seq, lmr, type, color);
   int s = iovlist.size();
   if (s > 0) {
     iov = iovlist.front();
     ret = true;
     if (s > 1) {
       // should not happen
       std::cout << "################################" << std::endl;
       std::cout << "################################" << std::endl;
       std::cout << "WARNING: More than one LMFRUNIOV" << std::endl;
       std::cout << "         Found for seq " << seq.getID() << std::endl;
       std::cout << "         lmr " << lmr << " type " << type << std::endl;
       std::cout << "         and color " << color << std::endl;
       std::cout << "################################" << std::endl;
       std::cout << "################################" << std::endl;
     }
   } else {
     // find the most recent data
     iovlist = iov.fetchLastBeforeSequence(seq, lmr, type, color);
     s = iovlist.size();
     if (s == 1) {
       iov = iovlist.front();
     } 
   }
   return ret;
 }

MonRunIOV EcalCondDBInterface::fetchMonRunIOV	(	RunTag *	runtag,
		MonRunTag *	montag,
		run_t	run,
		subrun_t	monrun
	)
throw	(	std::runtime_error
	)

Return a monitoring run object

Definition at line 724 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, DTTTrigCorrFirst::run, MonRunIOV::setByRun(), and IDBObject::setConnection().

Referenced by EcalCondDBWriter::dqmEndJob(), EcalCondDBReader::EcalCondDBReader(), and EcalPedOffset::writeDb().

 {
   RunIOV runiov = fetchRunIOV(runtag, run);
   MonRunIOV moniov;
   moniov.setConnection(env, conn);
   moniov.setByRun(montag, &runiov, subrun);
   return moniov;
 }

MonRunList EcalCondDBInterface::fetchMonRunList	(	const RunTag &	tag,
		const MonRunTag &	monruntag
	)
throw	(	std::runtime_error
	)

Definition at line 884 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, MonRunList::fetchRuns(), alignCSCRings::r, IDBObject::setConnection(), MonRunList::setMonRunTag(), MonRunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

 {  
   MonRunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.setMonRunTag(monrunTag);
   r.fetchRuns();
   return r;
 }

MonRunList EcalCondDBInterface::fetchMonRunList	(	const RunTag &	tag,
		const MonRunTag &	monruntag,
		int	min_run,
		int	max_run
	)
throw	(	std::runtime_error
	)

Definition at line 895 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, MonRunList::fetchRuns(), alignCSCRings::r, IDBObject::setConnection(), MonRunList::setMonRunTag(), MonRunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

 {  
   MonRunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.setMonRunTag(monrunTag);
   r.fetchRuns(min_run, max_run);
   return r;
 }

MonRunList EcalCondDBInterface::fetchMonRunListLastNRuns	(	const RunTag &	tag,
		const MonRunTag &	monruntag,
		int	max_run,
		int	n_runs
	)
throw	(	std::runtime_error
	)

Definition at line 906 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, MonRunList::fetchLastNRuns(), alignCSCRings::r, IDBObject::setConnection(), MonRunList::setMonRunTag(), MonRunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

Referenced by EcalTPGDBApp::readFromCondDB_Pedestals().

 {  
   MonRunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.setMonRunTag(monrunTag);
   r.fetchLastNRuns(max_run, n_runs );
   return r;
 }

RunList EcalCondDBInterface::fetchNonEmptyGlobalRunList	(	const RunTag &	tag,
		int	min_run,
		int	max_run
	)
throw	(	std::runtime_error
	)

Definition at line 844 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, RunList::fetchNonEmptyGlobalRuns(), alignCSCRings::r, IDBObject::setConnection(), RunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

                                                                                                                           {
   RunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.fetchNonEmptyGlobalRuns( min_run,  max_run);
   return r;
 }

RunList EcalCondDBInterface::fetchNonEmptyRunList	(	const RunTag &	tag,
		int	min_run,
		int	max_run
	)
throw	(	std::runtime_error
	)

Definition at line 836 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, RunList::fetchNonEmptyRuns(), alignCSCRings::r, IDBObject::setConnection(), RunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

                                                                                                                     {
   RunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.fetchNonEmptyRuns( min_run,  max_run);
   return r;
 }

RunIOV EcalCondDBInterface::fetchRunIOV	(	RunTag *	tag,
		run_t	run
	)
throw	(	std::runtime_error
	)

Return a run IOV object for a given tag

Definition at line 666 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, o2o::iov, DTTTrigCorrFirst::run, RunIOV::setByRun(), IDBObject::setConnection(), and GlobalPosition_Frontier_DevDB_cff::tag.

Referenced by EcalCondDBWriter::dqmEndJob(), EcalCondDBReader::EcalCondDBReader(), and EcalPedOffset::writeDb().

 {  
   RunIOV iov;
   iov.setConnection(env, conn);
   iov.setByRun(tag, run);
   return iov;
 }

RunIOV EcalCondDBInterface::fetchRunIOV	(	std::string	location,
		run_t	run
	)
throw	(	std::runtime_error
	)

Return a run IOV object for a given location. It is not guarunteed that a run is unique for a location only, so an exception is thrown if more than one result exists.

Definition at line 677 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, o2o::iov, DTTTrigCorrFirst::run, RunIOV::setByRun(), and IDBObject::setConnection().

 {  
   RunIOV iov;
   iov.setConnection(env, conn);
   iov.setByRun(location, run);
   return iov;
 }

RunIOV EcalCondDBInterface::fetchRunIOV	(	std::string	location,
		const Tm &	t
	)
throw	(	std::runtime_error
	)

Definition at line 686 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, o2o::iov, RunIOV::setByTime(), IDBObject::setConnection(), and tree::t.

 {
   RunIOV iov;
   iov.setConnection(env, conn);
   iov.setByTime(location, t);
   return iov;
 }

RunList EcalCondDBInterface::fetchRunList	(	const RunTag &	tag	)
throw	(	std::runtime_error
	)

Return a Run List

Definition at line 818 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, RunList::fetchRuns(), alignCSCRings::r, IDBObject::setConnection(), RunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

 {  
   RunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.fetchRuns();
   return r;
 }

RunList EcalCondDBInterface::fetchRunList	(	const RunTag &	tag,
		int	min_run,
		int	max_run
	)
throw	(	std::runtime_error
	)

Definition at line 828 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, RunList::fetchRuns(), alignCSCRings::r, IDBObject::setConnection(), RunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

                                                                                                             {
   RunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.fetchRuns( min_run,  max_run);
   return r;
 }

RunList EcalCondDBInterface::fetchRunListByLocation	(	const RunTag &	tag,
		int	min_run,
		int	max_run,
		const LocationDef &	locDef
	)
throw	(	std::runtime_error
	)

Definition at line 852 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, RunList::fetchRunsByLocation(), alignCSCRings::r, IDBObject::setConnection(), RunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

                           {
   RunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.fetchRunsByLocation( min_run,  max_run, locDef);
   return r;
 }

RunList EcalCondDBInterface::fetchRunListLastNRuns	(	const RunTag &	tag,
		int	max_run,
		int	n_runs
	)
throw	(	std::runtime_error
	)

Definition at line 870 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, RunList::fetchLastNRuns(), alignCSCRings::r, IDBObject::setConnection(), RunList::setRunTag(), and GlobalPosition_Frontier_DevDB_cff::tag.

                          {
   RunList r;
   r.setConnection(env, conn);
   r.setRunTag(tag);
   r.fetchLastNRuns( max_run,  n_runs);
   return r;
 }

template<class DATT , class IOVT >

void EcalCondDBInterface::fetchValidDataSet	(	std::map< EcalLogicID, DATT > *	fillMap,
		IOVT *	fillIOV,
		RunTag *	tag,
		run_t	run = `(unsigned int)-1`
	)
throw	(	std::runtime_error
	)

inline

Definition at line 646 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, EcalDBConnection::env, DTTTrigCorrFirst::run, and GlobalPosition_Frontier_DevDB_cff::tag.

   {
     fillMap->clear();
     DATT datiface;
     fillIOV->setConnection(env, conn);
     fillIOV->setByRecentData(datiface.getTable(), tag, run);
     datiface.setConnection(env, conn);
     datiface.createReadStatement();
     datiface.setPrefetchRowCount(1024);
     datiface.fetchData( fillMap, fillIOV );
     datiface.terminateReadStatement();
   }

template<class DATT , class IOVT >

void EcalCondDBInterface::fetchValidDataSet	(	std::map< EcalLogicID, DATT > *	fillMap,
		IOVT *	fillIOV,
		std::string	location,
		run_t	run = `(unsigned int)-1`
	)
throw	(	std::runtime_error
	)

inline

Definition at line 670 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, EcalDBConnection::env, and DTTTrigCorrFirst::run.

   {
     fillMap->clear();
     DATT datiface;
     fillIOV->setConnection(env, conn);
     fillIOV->setByRecentData(datiface.getTable(), location, run);
     datiface.setConnection(env, conn);
     datiface.createReadStatement();
     datiface.setPrefetchRowCount(1024);
     datiface.fetchData( fillMap, fillIOV );
     datiface.terminateReadStatement();
   }

void EcalCondDBInterface::fillLogicId2DetIdMaps ( )

private

Private method: fill a private map used to associate logicIds to DetIds

Definition at line 28 of file EcalCondDBInterface.cc.

References EcalLogicID::NULLID.

Referenced by getDetId2LogicIdMap(), getDetIdFromLogicId(), getLogicId2DetIdMap(), and getLogicIdFromDetId().

                                                 {
   // retrieve the lists of logic_ids, to build the detids
   std::vector<EcalLogicID> crystals_EB  =
     getEcalLogicIDSetOrdered( "EB_crystal_angle",
                   -85,85,1,360,
                   EcalLogicID::NULLID,EcalLogicID::NULLID,
                   "EB_crystal_number", 4 );
   std::vector<EcalLogicID> crystals_EE  =
     getEcalLogicIDSetOrdered( "EE_crystal_number",
                   -1,1,1,100,
                   1,100,
                   "EE_crystal_number", 4 );
   // fill the barrel map
   std::vector<EcalLogicID>::const_iterator ieb = crystals_EB.begin();
   std::vector<EcalLogicID>::const_iterator eeb = crystals_EB.end();
   while (ieb != eeb) {
     int iEta = ieb->getID1();
     int iPhi = ieb->getID2();
     EBDetId ebdetid(iEta,iPhi);
     _logicId2DetId[ieb->getLogicID()] = ebdetid;
     _detId2LogicId[ebdetid] = ieb->getLogicID();
     ieb++;
   }
 
   // fill the endcap map
   std::vector<EcalLogicID>::const_iterator iee = crystals_EE.begin();
   std::vector<EcalLogicID>::const_iterator eee = crystals_EE.end();
 
   while (iee != eee) {
     int iSide = iee->getID1();
     int iX    = iee->getID2();
     int iY    = iee->getID3();
     EEDetId eedetidpos(iX,iY,iSide);
     _logicId2DetId[iee->getLogicID()] = eedetidpos;
     _detId2LogicId[eedetidpos] = iee->getLogicID();
     iee++;
   }
   
 }

DateHandler* EcalCondDBInterface::getDateHandler ( )

inline

Return a date handler associated with this connection

Definition at line 104 of file EcalCondDBInterface.h.

References dh.

     {
       return dh;
     }

std::map<int, int> EcalCondDBInterface::getDetId2LogicIdMap ( )

inline

Definition at line 715 of file EcalCondDBInterface.h.

References _detId2LogicId, _logicId2DetId, and fillLogicId2DetIdMaps().

                                                 {
     if (_logicId2DetId.size() == 0) {
       fillLogicId2DetIdMaps();
     }
     return _detId2LogicId;
   }

int EcalCondDBInterface::getDetIdFromLogicId ( int logic_id )

inline

Definition at line 686 of file EcalCondDBInterface.h.

References _logicId2DetId, cond::rpcobgas::detid, and fillLogicId2DetIdMaps().

                                                {
     int detid = -1;
     if (_logicId2DetId.size() == 0) {
       fillLogicId2DetIdMaps();
     }
     if (_logicId2DetId.find(logic_id) != _logicId2DetId.end()) {
       detid = _logicId2DetId[logic_id];
     }
     return detid;
   }

EcalLogicID EcalCondDBInterface::getEcalLogicID	(	std::string	name,
		int	id1 = `EcalLogicID::NULLID`,
		int	id2 = `EcalLogicID::NULLID`,
		int	id3 = `EcalLogicID::NULLID`,
		std::string	mapsTo = `""`
	)
throw	(	std::runtime_error
	)

Look up the "human readable" ids and return an EcalLogicID object which contains the "database readable" logic_id === Parameters === name: name of the channel type you are specifying id1, id2, id3: ids of the channel type mapsTo: name of the channel type you are mapping to

Referenced by EcalTPGParamBuilder::analyze(), popcon::EcalLaserHandler::dumpBarrelPayload(), popcon::EcalLaserHandler::dumpEndcapPayload(), and EcalPedOffset::writeDb().

EcalLogicID EcalCondDBInterface::getEcalLogicID	(	int	logicID	)
throw	(	std::runtime_error
	)

Look up the database logic_id and return the EcalLogicID object which contains the "human readable" ids === Parameters === logicID: DB logic_id

Definition at line 69 of file EcalCondDBInterface.cc.

References alignCSCRings::e, visualization-live-secondInstance_cfg::msg, mergeVDriftHistosByStation::name, and EcalLogicID::NULLID.

 {
 
   string sql = "SELECT name, logic_id, id1, id2, id3, maps_to FROM channelView WHERE logic_id = :logicID AND name=maps_to";
   
   int id1, id2, id3;
   string name, mapsTo;
   
   try {
     stmt->setSQL(sql);
     stmt->setInt(1, logicID);
     ResultSet* rset = stmt->executeQuery();
 
     if (rset->next()) {
       name = rset->getString(1);
       logicID = rset->getInt(2);
       id1 = rset->getInt(3);
       if (rset->isNull(3)) { id1 = EcalLogicID::NULLID; }
       id2 = rset->getInt(4);
       if (rset->isNull(4)) { id2 = EcalLogicID::NULLID; }
       id3 = rset->getInt(5);
       if (rset->isNull(5)) { id3 = EcalLogicID::NULLID; }
       mapsTo = rset->getString(6);
     } else {
       stringstream msg;
       msg << "ERROR:  Cannot build EcalLogicID for logic_id " << logicID;
       throw(std::runtime_error(msg.str()));
     }
 
   } catch (SQLException &e) {    
     throw(std::runtime_error("ERROR:  Failed to retrive ids:  " + e.getMessage() ));
   }
   
   return EcalLogicID( name, logicID, id1, id2, id3, mapsTo );  
 }

std::map< int, int > EcalCondDBInterface::getEcalLogicID2LmrMap ( )

Definition at line 294 of file EcalCondDBInterface.cc.

References i, EcalLogicID::NULLID, and run_regression::ret.

                                                             {
   std::map<int, int> ret;
   std::vector<EcalLogicID> crystals_EB  =
     getEcalLogicIDSetOrdered( "EB_crystal_number",
                   1,36,1,1700,
                   EcalLogicID::NULLID,EcalLogicID::NULLID,
                   "EB_crystal_number", EcalLogicID::NULLID);
   std::vector<EcalLogicID> crystals_EE  =
     getEcalLogicIDSetOrdered( "EE_crystal_number",
                   -1,1,1,100,
                   1,100,
                   "EE_crystal_number", EcalLogicID::NULLID);
   std::vector<EcalLogicID> EB_lmr  =
     getEcalLogicIDSetOrdered( "EB_crystal_number",
                   1,36,1,1700,
                   EcalLogicID::NULLID,EcalLogicID::NULLID,
                   "ECAL_LMR", EcalLogicID::NULLID);
   std::vector<EcalLogicID> EE_lmr  =
     getEcalLogicIDSetOrdered( "EE_crystal_number",
                   -1,1,1,100,
                   1,100,
                   "ECAL_LMR", EcalLogicID::NULLID);
   unsigned int neb = crystals_EB.size();
   unsigned int nee = crystals_EE.size();
   if (neb != EB_lmr.size()) {
     throw(std::runtime_error("ERROR: EB Vectors size do not agree"));
   }
   if (nee != EE_lmr.size()) {
     throw(std::runtime_error("ERROR: EE Vectors size do not agree"));
   }
   for (unsigned int i = 0; i < neb; i++) {
     ret[crystals_EB[i].getLogicID()] = EB_lmr[i].getLogicID() % 100;
   }
   for (unsigned int i = 0; i < nee; i++) {
     ret[crystals_EE[i].getLogicID()] = EE_lmr[i].getLogicID() % 100;
   }
   return ret;
 }

std::vector< EcalLogicID > EcalCondDBInterface::getEcalLogicIDForLMPN ( int lmr_logic_id )

Definition at line 388 of file EcalCondDBInterface.cc.

                                                                          {
   if ((lmr / 1000000000) == 2) {
     return getEcalLogicIDMappedTo(lmr, "EE_LM_PN");
   } else {
     return getEcalLogicIDMappedTo(lmr, "EB_LM_PN");
   }
 }

std::vector< EcalLogicID > EcalCondDBInterface::getEcalLogicIDForLMPN ( const EcalLogicID & lmr_logic_id )

Definition at line 396 of file EcalCondDBInterface.cc.

References EcalLogicID::getLogicID().

                                                                                         {
   return getEcalLogicIDForLMR(lmr.getLogicID());
 }

std::vector< EcalLogicID > EcalCondDBInterface::getEcalLogicIDForLMR ( int lmr_logic_id )

Definition at line 380 of file EcalCondDBInterface.cc.

                                                                         {
   return getEcalLogicIDMappedTo(lmr, "ECAL_LMR");
 }

std::vector< EcalLogicID > EcalCondDBInterface::getEcalLogicIDForLMR ( const EcalLogicID & lmr_logic_id )

Definition at line 384 of file EcalCondDBInterface.cc.

References EcalLogicID::getLogicID().

                                                                                        {
   return getEcalLogicIDForLMR(lmr.getLogicID());
 }

std::vector< EcalLogicID > EcalCondDBInterface::getEcalLogicIDMappedTo	(	int	logic_id,
		std::string	maps_to
	)

Build various reverse maps Map an LMR, or a Ex_LM_PN into the set of components

Definition at line 333 of file EcalCondDBInterface.cc.

References IDBObject::ECALDB_NROWS, mergeVDriftHistosByStation::name, EcalLogicID::NULLID, run_regression::ret, and AlCaHLTBitMon_QueryRunRegistry::string.

                                                                                                       {
   std::string name = "EB_crystal_angle";
   std::string sql = "SELECT LOGIC_ID, ID1, ID2, ID3 "
     "FROM CHANNELVIEW WHERE NAME = 'EB_crystal_angle' AND LOGIC_ID IN "
     "(SELECT LOGIC_ID FROM CHANNELVIEW WHERE NAME = 'EB_crystal_number' AND "
     "ID1*10000+ID2 IN (SELECT DISTINCT ID1*10000+ID2 FROM CHANNELVIEW "
     "WHERE LOGIC_ID = :1 AND NAME = 'EB_crystal_number' AND MAPS_TO = :2) "
     "AND NAME = MAPS_TO)"; 
   if ((lmr_logic_id / 1000000000) == 2) {
     name = "EE_crystal_number";
     sql = "SELECT LOGIC_ID, ID1, ID2, ID3 "
       "FROM CHANNELVIEW WHERE NAME = 'EE_crystal_number' AND LOGIC_ID IN "
       "(SELECT LOGIC_ID FROM CHANNELVIEW WHERE NAME = 'EE_crystal_number' AND "
       "ID1*10000000+ID2*10000+ID3 IN (SELECT DISTINCT "
       "ID1*10000000+ID2*10000+ID3 FROM CHANNELVIEW "
       "WHERE LOGIC_ID = :1 AND NAME = 'EE_crystal_number' AND MAPS_TO = :2) "
       "AND NAME = MAPS_TO) AND NAME = MAPS_TO"; 
   }
   std::vector<EcalLogicID> ret;
   try {
     stmt->setSQL(sql.c_str());
     stmt->setInt(1, lmr_logic_id);
     stmt->setString(2, maps_to);
     stmt->setPrefetchRowCount(IDBObject::ECALDB_NROWS);    
     
     ResultSet* rset = stmt->executeQuery();
     
     while (rset->next()) {
       int logic_id = rset->getInt(1);
       int id1 = rset->getInt(2);
       if (rset->isNull(2)) { id1 = EcalLogicID::NULLID; }
       int id2 = rset->getInt(3);
       if (rset->isNull(3)) { id2 = EcalLogicID::NULLID; }
       int id3 = rset->getInt(4);
       if (rset->isNull(4)) { id3 = EcalLogicID::NULLID; }
       
       EcalLogicID ecid = EcalLogicID( name, logic_id, id1, id2, id3, maps_to );
       ret.push_back(ecid);
     }
     stmt->setPrefetchRowCount(0);
   }
   catch (SQLException &e) {
     throw(std::runtime_error("ERROR:  Failure while getting EcalLogicID set:  " + e.getMessage() ));
   }
   return ret;
 }

std::vector< EcalLogicID > EcalCondDBInterface::getEcalLogicIDSet	(	std::string	name,
		int	fromId1 = `EcalLogicID::NULLID`,
		int	toId1 = `EcalLogicID::NULLID`,
		int	fromId2 = `EcalLogicID::NULLID`,
		int	toId2 = `EcalLogicID::NULLID`,
		int	fromId3 = `EcalLogicID::NULLID`,
		int	toId3 = `EcalLogicID::NULLID`,
		std::string	mapsTo = `""`
	)
throw	(	std::runtime_error
	)

Get a set of EcalLogicID in one transaction === Parameters === name: name of the channel type you are specifying fromId1, toId1: Range of id1 in the DB to retrieve fromId2, toId2: Range of id2 in the DB to retrieve fromId3, toId3: Range of id3 in the DB to retrieve string mapsTo: channel type name these ids map to

Definition at line 202 of file EcalCondDBInterface.cc.

References IDBObject::ECALDB_NROWS, i, mergeVDriftHistosByStation::name, EcalLogicID::NULLID, query::result, and contentValuesCheck::ss.

 {
   if (mapsTo == "") {
     mapsTo = name;
   }
   
   int idArray[] = { fromId1, toId1, fromId2, toId2, fromId3, toId3 };
   int from, to;
   
   stringstream ss;
   ss << "SELECT name, logic_id, id1, id2, id3, maps_to FROM channelView WHERE name = :name AND ";
   
   // loop through the three ids
   for (int i=1; i<=3; i++) {
     from = idArray[2*(i-1)];
     to   = idArray[2*(i-1) + 1];
     
     // check the id arguments in pairs
     if ((from == EcalLogicID::NULLID && to != EcalLogicID::NULLID) || // one is null
     (from != EcalLogicID::NULLID && to == EcalLogicID::NULLID) || //   but not the other
     (from > to)) { // negative interval
       throw(std::runtime_error("ERROR:  Bad arguments for getEcalLogicIDSet"));
     }
     
     // build the sql
     if (from == EcalLogicID::NULLID && to == EcalLogicID::NULLID) {
       ss << "id" << i << " IS NULL AND ";
     } else {
       ss << "id" << i << " >= :id" << i << "from AND " <<
     "id" << i << " <= :id" << i << "to AND ";
     }
   }
   ss << "maps_to = :maps_to ORDER BY id1, id2, id3";
   
   std::vector<EcalLogicID> result;
   
   try {
     stmt->setSQL(ss.str());
 
     // bind the parameters
     int j = 1;  // parameter number counter
     stmt->setString(j, name);
     j++;
     
     for (int i=0; i<3; i++) {
       from = idArray[2*i];
       to   = idArray[2*i + 1];
       if (from != EcalLogicID::NULLID) {
     stmt->setInt(j, from);
     j++;
     stmt->setInt(j, to);
     j++;
       }
     }
 
     stmt->setString(j, mapsTo);
 
   
     stmt->setPrefetchRowCount(IDBObject::ECALDB_NROWS);    
 
     ResultSet* rset = stmt->executeQuery();
 
     int id1, id2, id3, logicId;
 
     while (rset->next()) {
       name = rset->getString(1);
       logicId = rset->getInt(2);
       id1 = rset->getInt(3);
       if (rset->isNull(3)) { id1 = EcalLogicID::NULLID; }
       id2 = rset->getInt(4);
       if (rset->isNull(4)) { id2 = EcalLogicID::NULLID; }
       id3 = rset->getInt(5);
       if (rset->isNull(5)) { id3 = EcalLogicID::NULLID; }
       mapsTo = rset->getString(6);
 
       EcalLogicID ecid = EcalLogicID( name, logicId, id1, id2, id3, mapsTo );
       result.push_back(ecid);
     }
     stmt->setPrefetchRowCount(0);
 
   } catch (SQLException &e) {
     throw(std::runtime_error("ERROR:  Failure while getting EcalLogicID set:  " + e.getMessage() ));    
   }
 
   return result;
 }

std::vector< EcalLogicID > EcalCondDBInterface::getEcalLogicIDSetOrdered	(	std::string	name,
		int	fromId1,
		int	toId1,
		int	fromId2 = `EcalLogicID::NULLID`,
		int	toId2 = `EcalLogicID::NULLID`,
		int	fromId3 = `EcalLogicID::NULLID`,
		int	toId3 = `EcalLogicID::NULLID`,
		std::string	mapsTo = `""`,
		int	orderedBy = `EcalLogicID::NULLID`
	)
throw	(	std::runtime_error
	)

Definition at line 400 of file EcalCondDBInterface.cc.

References IDBObject::ECALDB_NROWS, i, mergeVDriftHistosByStation::name, EcalLogicID::NULLID, query::result, and contentValuesCheck::ss.

Referenced by EcalTPGParamBuilder::analyze().

 {
   if (mapsTo == "") {
     mapsTo = name;
   }
   
   int idArray[] = { fromId1, toId1, fromId2, toId2, fromId3, toId3 };
   int from, to;
   
   stringstream ss;
   ss << "SELECT name, logic_id, id1, id2, id3, maps_to FROM channelView WHERE name = :name AND ";
   
   // loop through the three ids
   for (int i=1; i<=3; i++) {
     from = idArray[2*(i-1)];
     to   = idArray[2*(i-1) + 1];
     
     // check the id arguments in pairs
     if ((from == EcalLogicID::NULLID && to != EcalLogicID::NULLID) || // one is null
     (from != EcalLogicID::NULLID && to == EcalLogicID::NULLID) || //   but not the other
     (from > to)) { // negative interval
       throw(std::runtime_error("ERROR:  Bad arguments for getEcalLogicIDSet"));
     }
     
     // build the sql
     if (from == EcalLogicID::NULLID && to == EcalLogicID::NULLID) {
       ss << "id" << i << " IS NULL AND ";
     } else {
       ss << "id" << i << " >= :id" << i << "from AND " <<
     "id" << i << " <= :id" << i << "to AND ";
     }
   }
   ss << "maps_to = :maps_to ";
 
   if(orderedBy==EcalLogicID::NULLID){
     ss<<"  ORDER BY id1, id2, id3";
   } else if(orderedBy==1 || orderedBy==12 || orderedBy==123){
     ss<<"  ORDER BY id1, id2, id3 ";
   } else if (orderedBy==213 || orderedBy==21 ){ 
     ss<<"  ORDER BY id2, id1, id3 ";
   } else if (orderedBy==231|| orderedBy==23){ 
     ss<<"  ORDER BY id2, id3, id1 ";
   } else if (orderedBy==321|| orderedBy==32){
     ss<<"  ORDER BY id3, id2, id1 ";
   } else if (orderedBy==312|| orderedBy==31){
     ss<<"  ORDER BY id3, id1, id2 ";
   } else if (orderedBy==132|| orderedBy==13){ 
     ss<<"  ORDER BY id1, id3, id2 ";
   } else if (orderedBy==1234 ){ 
     ss<<"  ORDER BY id1, id2, id3, logic_id ";
   } else if (orderedBy==4) {
     ss<<"  ORDER BY logic_id ";
   } else {
     ss<<"  ORDER BY id1, id2, id3";
   }
   
   std::vector<EcalLogicID> result;
   
   try {
     stmt->setSQL(ss.str());
 
     // bind the parameters
     int j = 1;  // parameter number counter
     stmt->setString(j, name);
     j++;
     
     for (int i=0; i<3; i++) {
       from = idArray[2*i];
       to   = idArray[2*i + 1];
       if (from != EcalLogicID::NULLID) {
     stmt->setInt(j, from);
     j++;
     stmt->setInt(j, to);
     j++;
       }
     }
 
     stmt->setString(j, mapsTo);
 
   
     stmt->setPrefetchRowCount(IDBObject::ECALDB_NROWS);    
 
     ResultSet* rset = stmt->executeQuery();
 
     int id1, id2, id3, logicId;
 
     while (rset->next()) {
       name = rset->getString(1);
       logicId = rset->getInt(2);
       id1 = rset->getInt(3);
       if (rset->isNull(3)) { id1 = EcalLogicID::NULLID; }
       id2 = rset->getInt(4);
       if (rset->isNull(4)) { id2 = EcalLogicID::NULLID; }
       id3 = rset->getInt(5);
       if (rset->isNull(5)) { id3 = EcalLogicID::NULLID; }
       mapsTo = rset->getString(6);
 
       EcalLogicID ecid = EcalLogicID( name, logicId, id1, id2, id3, mapsTo );
       result.push_back(ecid);
     }
     stmt->setPrefetchRowCount(0);
 
   } catch (SQLException &e) {
     throw(std::runtime_error("ERROR:  Failure while getting EcalLogicID set:  " + e.getMessage() ));    
   }
 
   return result;
 }

std::map<int, int> EcalCondDBInterface::getLogicId2DetIdMap ( )

inline

Definition at line 708 of file EcalCondDBInterface.h.

References _logicId2DetId, and fillLogicId2DetIdMaps().

                                                 {
     if (_logicId2DetId.size() == 0) {
       fillLogicId2DetIdMaps();
     }
     return _logicId2DetId;
   }

int EcalCondDBInterface::getLogicIdFromDetId ( int det_id )

inline

Definition at line 697 of file EcalCondDBInterface.h.

References _detId2LogicId, _logicId2DetId, and fillLogicId2DetIdMaps().

                                              {
     int logic_id = -1;
     if (_logicId2DetId.size() == 0) {
       fillLogicId2DetIdMaps();
     }
     if (_detId2LogicId.find(det_id) != _detId2LogicId.end()) {
       logic_id = _detId2LogicId[det_id];
     }
     return logic_id;
   }

template<class DATT , class ICONF >

void EcalCondDBInterface::insertConfigDataArraySet	(	const std::vector< DATT > &	data,
		ICONF *	iconf
	)
throw	(	std::runtime_error
	)

inline

Definition at line 521 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, gather_cfg::cout, data, alignCSCRings::e, and EcalDBConnection::env.

Referenced by EcalDccWeightBuilder::writeWeightToDB().

   {
     try {
       iconf->setConnection(env, conn);
       // if it has not yet been written then write 
       if(iconf->getId()==0){
     std::cout<<"EcalCondDBInterface>> config_id was not set we retrieve it from DB"<<std::endl;
     iconf->fetchID();
       } 
       if(iconf->getId()==0){
     std::cout<<"EcalCondDBInterface>> configuration info was not written we write it"<<std::endl;
     iconf->writeDB();
       } 
       
       DATT dataIface;
       dataIface.setConnection(env, conn);
       dataIface.prepareWrite();
       
       dataIface.writeArrayDB(data, iconf);
       conn->commit();
       
       dataIface.terminateWriteStatement();
    
     } catch (std::runtime_error &e) {
       conn->rollback();
       throw(e);
     } catch (...) {
       conn->rollback();
       throw(std::runtime_error("EcalCondDBInterface::insertConfigDataArraySet:  Unknown exception caught"));
     }
   }

template<class DATT , class ICONF >

void EcalCondDBInterface::insertConfigDataSet	(	const std::vector< DATT >	data,
		ICONF *	iconf
	)
throw	(	std::runtime_error
	)

inline

Definition at line 482 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, gather_cfg::cout, data, alignCSCRings::e, EcalDBConnection::env, and AlCaHLTBitMon_ParallelJobs::p.

   {
     try {
       iconf->setConnection(env, conn);
       // if it has not yet been written then write 
       if(iconf->getId()==0){
     std::cout<<"EcalCondDBInterface>> config_id was not set we retrieve it from DB"<<std::endl;
     iconf->fetchID();
       } 
       if(iconf->getId()==0){
     std::cout<<"EcalCondDBInterface>> configuration info was not written we write it"<<std::endl;
     iconf->writeDB();
       } 
       
       DATT dataIface;
       dataIface.setConnection(env, conn);
       dataIface.prepareWrite();
       
       const DATT* dataitem;
 
       for (int p = 0; p != data->size(); ++p) {
     dataitem = data[p];
     dataIface.writeDB( dataitem, iconf);
       }
       conn->commit();
       dataIface.terminateWriteStatement();
     } catch (std::runtime_error &e) {
       conn->rollback();
       throw(e);
     } catch (...) {
       conn->rollback();
       throw(std::runtime_error("EcalCondDBInterface::insertConfigDataSet:  Unknown exception caught"));
     }
   }

template<class ICONF >

void EcalCondDBInterface::insertConfigSet	(	ICONF *	iconf	)
throw	(	std::runtime_error
	)

inline

Definition at line 424 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, gather_cfg::cout, alignCSCRings::e, and EcalDBConnection::env.

Referenced by EcalTPGDBApp::writeToConfDB_Delay(), EcalTPGDBApp::writeToConfDB_Spike(), EcalTPGDBApp::writeToConfDB_TPGFgr(), EcalTPGDBApp::writeToConfDB_TPGLinearCoef(), EcalTPGDBApp::writeToConfDB_TPGLUT(), EcalTPGDBApp::writeToConfDB_TPGMain(), EcalTPGDBApp::writeToConfDB_TPGPedestals(), EcalTPGDBApp::writeToConfDB_TPGSliding(), EcalTPGDBApp::writeToConfDB_TPGWeight(), and EcalDccWeightBuilder::writeWeightToDB().

    {
      try {
        iconf->setConnection(env, conn);
        iconf->prepareWrite();
        // if it has not yet been written then write 
        iconf->writeDB();
        std::cout<< "iconf inserted with ID="<<iconf->getId()<<std::endl;
        conn->commit();
        iconf->terminateWriteStatement();
      } catch (std::runtime_error &e) {
        conn->rollback();
        throw(e);
      } catch (...) {
        conn->rollback();
        throw(std::runtime_error("EcalCondDBInterface::insertDataSet:  Unknown exception caught"));
      }
    }

template<class DATT , class IOVT >

void EcalCondDBInterface::insertDataArraySet	(	const std::map< EcalLogicID, DATT > *	data,
		IOVT *	iov
	)
throw	(	std::runtime_error
	)

inline

Definition at line 347 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, gather_cfg::cout, data, alignCSCRings::e, EcalDBConnection::env, and o2o::iov.

   {
     try {
       iov->setConnection(env, conn);
       if(iov->getID()==0){
     std::cout<<"IOV was not set we retrieve it from DB"<<std::endl;
     iov->fetchID();
       } 
       if(iov->getID()==0){
     std::cout<<"IOV was not written we write it"<<std::endl;
     iov->writeDB();
       } 
 
       std::cout<<"id="<<iov->getID()<<std::endl;
 
       DATT dataIface;
       dataIface.setConnection(env, conn);
       dataIface.prepareWrite();
       
       dataIface.writeArrayDB(data, iov);
       conn->commit();
       
       dataIface.terminateWriteStatement();
    
     } catch (std::runtime_error &e) {
       conn->rollback();
       throw(e);
     } catch (...) {
       conn->rollback();
       throw(std::runtime_error("EcalCondDBInterface::insertDataSet:  Unknown exception caught"));
     }
   }

template<class DATT , class IOVT >

void EcalCondDBInterface::insertDataSet	(	const std::map< EcalLogicID, DATT > *	data,
		IOVT *	iov
	)
throw	(	std::runtime_error
	)

inline

Definition at line 307 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, gather_cfg::cout, alignCSCRings::e, EcalDBConnection::env, o2o::iov, and AlCaHLTBitMon_ParallelJobs::p.

Referenced by ecaldqm::TestPulseWriter::run(), ecaldqm::SummaryWriter::run(), and EcalPedOffset::writeDb().

   {
     try {
       iov->setConnection(env, conn);
       // if it has not yet been written then write 
       if(iov->getID()==0){
     std::cout<<"IOV was not set we retrieve it from DB"<<std::endl;
     iov->fetchID();
       } 
       if(iov->getID()==0){
     std::cout<<"IOV was not written we write it"<<std::endl;
     iov->writeDB();
       } 
       
       DATT dataIface;
       dataIface.setConnection(env, conn);
       dataIface.prepareWrite();
       
       const EcalLogicID* channel;
       const DATT* dataitem;
       typedef typename std::map< EcalLogicID, DATT >::const_iterator CI;
       for (CI p = data->begin(); p != data->end(); ++p) {
     channel = &(p->first);
     dataitem = &(p->second);
     dataIface.writeDB( channel, dataitem, iov);
       }
       conn->commit();
       dataIface.terminateWriteStatement();
     } catch (std::runtime_error &e) {
       conn->rollback();
       throw(e);
     } catch (...) {
       conn->rollback();
       throw(std::runtime_error("EcalCondDBInterface::insertDataSet:  Unknown exception caught"));
     }
   }

template<class DATT , class IOVT >

void EcalCondDBInterface::insertDataSetVector	(	const std::vector< EcalLogicID > &	ecid,
		const std::vector< IOVT > &	run_iov,
		const std::vector< DATT > &	data
	)
throw	(	std::runtime_error
	)

inline

Definition at line 382 of file EcalCondDBInterface.h.

References EcalDBConnection::conn, data, alignCSCRings::e, EcalDBConnection::env, and i.

   {
    
     int nruns= run_iov.size();
    
     if(run_iov.size()!=ecid.size() &&ecid.size()!=data.size()){
       throw(std::runtime_error("EcalCondDBInterface::insertDataSetVector:  vector sizes are different.."));
     } 
 
 
     try {
       
       DATT dataIface;
       dataIface.setConnection(env, conn);
       dataIface.prepareWrite();
 
       for (int i=0; i<nruns; i++){
 
     run_iov[i].setConnection(env, conn);
     run_iov[i].writeDB();
       
     dataIface.writeDB( &ecid[i], &data[i], &run_iov[i]);
     
     conn->commit();
       }
     } catch (std::runtime_error &e) {
       conn->rollback();
       throw(e);
     } catch (...) {
       conn->rollback();
       throw(std::runtime_error("EcalCondDBInterface::insertDataSet:  Unknown exception caught"));
     }
   }

void EcalCondDBInterface::insertDCUIOV	(	DCUIOV *	iov	)
throw	(	std::runtime_error
	)

Insert a DCU IOV object. Nothing is committed in the event of an exception

Definition at line 708 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

 {
   try {
     iov->setConnection(env, conn);
     iov->writeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::insertLmfDat	(	LMFDat *	dat	)
throw	(	std::runtime_error
	)

Definition at line 570 of file EcalCondDBInterface.cc.

References results_mgr::conn, and web.browse_db::env.

 {
   try {
     dat->setConnection(env, conn);
     dat->writeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::insertLmfDat	(	std::list< LMFDat * >	dat	)
throw	(	std::runtime_error
	)

Definition at line 583 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and i.

 {
   try {
     std::list<LMFDat *>::iterator i = dat.begin();
     std::list<LMFDat *>::iterator e = dat.end();
     while (i != e) {
       (*i)->setConnection(env, conn);
       (*i)->writeDB();
       i++;
     }
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::insertLmfIOV	(	LMFIOV *	iov	)
throw	(	std::runtime_error
	)

Definition at line 557 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

 {
   try {
     iov->setConnection(env, conn);
     iov->writeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::insertLmfLmrSubIOV	(	LMFLmrSubIOV *	iov	)
throw	(	std::runtime_error
	)

Definition at line 544 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

 {
   try {
     iov->setConnection(env, conn);
     iov->writeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::insertLmfRunIOV	(	LMFRunIOV *	iov	)
throw	(	std::runtime_error
	)

Definition at line 601 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

 {
   try {
     iov->setConnection(env, conn);
     iov->writeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::insertLmfSeq	(	LMFSeqDat *	iov	)
throw	(	std::runtime_error
	)

Definition at line 531 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

 {
   try {
     iov->setConnection(env, conn);
     iov->writeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::insertMonRunIOV	(	MonRunIOV *	iov	)
throw	(	std::runtime_error
	)

Insert a monitoring run object. Nothing is committed in the event of an exception

Definition at line 695 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

Referenced by EcalCondDBWriter::dqmEndJob().

 {
   try {
     iov->setConnection(env, conn);
     iov->writeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::insertRunIOV	(	RunIOV *	iov	)
throw	(	std::runtime_error
	)

Insert a run IOV object. Nothing is committed in the event of an exception

Definition at line 518 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

Referenced by EcalCondDBWriter::dqmEndJob().

 {
   try {
     iov->setConnection(env, conn);
     iov->writeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::updateRunConfig	(	ODRunConfigInfo *	od	)
throw	(	std::runtime_error
	)

Definition at line 653 of file EcalCondDBInterface.cc.

References results_mgr::conn, and web.browse_db::env.

 {
   try {
     od->setConnection(env, conn);
     od->updateDefaultCycle();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::updateRunIOV	(	RunIOV *	iov	)
throw	(	std::runtime_error
	)

Definition at line 614 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

 {
   try {
     iov->setConnection(env, conn);
     iov->updateEndTimeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::updateRunIOVEndTime	(	RunIOV *	iov	)
throw	(	std::runtime_error
	)

Definition at line 627 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

 {
   try {
     iov->setConnection(env, conn);
     iov->updateEndTimeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }

void EcalCondDBInterface::updateRunIOVStartTime	(	RunIOV *	iov	)
throw	(	std::runtime_error
	)

Definition at line 640 of file EcalCondDBInterface.cc.

References results_mgr::conn, web.browse_db::env, and o2o::iov.

 {
   try {
     iov->setConnection(env, conn);
     iov->updateStartTimeDB();
   } catch(std::runtime_error &e) {
     conn->rollback();
     throw(e);
   }
   conn->commit();
 }