#include <LMFSeqDat.h>

Inheritance diagram for LMFSeqDat:

Public Member Functions
std::map< int, LMFSeqDat >	fetchByRunIOV (RunIOV &iov)

std::map< int, LMFSeqDat >	fetchByRunIOV (RunIOV &iov, const LMFColor &col)

LMFSeqDat	fetchByRunIOV (RunIOV &iov, int seq_num)

std::map< int, LMFSeqDat >	fetchByRunNumber (int runno)

LMFSeqDat	fetchByRunNumber (int runno, const Tm &taken_at)

LMFSeqDat	fetchByRunNumber (int runno, int seq_num)

LMFSeqDat	fetchByRunNumber (int runno, std::string taken_at)

LMFSeqDat	fetchLast ()

RunIOV	fetchLastRun ()

RunIOV	getRunIOV () const

int	getSequenceNumber () const

Tm	getSequenceStart () const

Tm	getSequenceStop () const

int	getVmax () const

int	getVmin () const

bool	isValid () const override

	LMFSeqDat ()

	LMFSeqDat (EcalDBConnection *c)

	LMFSeqDat (oracle::occi::Environment env, oracle::occi::Connection conn)

bool	operator!= (const LMFSeqDat &m) const

bool	operator== (const LMFSeqDat &m) const

LMFSeqDat &	setRunIOV (const RunIOV &iov)

LMFSeqDat &	setSequenceNumber (int n)

LMFSeqDat &	setSequenceStart (const Tm &start)

LMFSeqDat &	setSequenceStop (const Tm &end)

LMFSeqDat &	setVersions (int vmin, int vmax)

	~LMFSeqDat () override

Public Member Functions inherited from LMFUnique
void	attach (std::string name, LMFUnique *u)

void	debug ()

virtual void	dump () const

virtual void	dump (int n) const

virtual bool	exists ()

virtual std::list< std::unique_ptr< LMFUnique > >	fetchAll () const noexcept(false)

int	fetchID () noexcept(false) override

std::string	getClassName ()

std::string	getClassName () const

int	getID () const

int	getInt (std::string fieldname) const

std::string	getString (std::string fieldname) const

virtual bool	isValid ()

	LMFUnique ()

	LMFUnique (EcalDBConnection *c)

	LMFUnique (oracle::occi::Environment env, oracle::occi::Connection conn)

void	nodebug ()

virtual bool	operator< (const LMFUnique &r)

virtual bool	operator<= (const LMFUnique &r)

std::string	sequencePostfix (const Tm &t)

void	setByID (int id) noexcept(false) override

LMFUnique &	setInt (std::string key, int value)

LMFUnique &	setString (std::string key, std::string value)

void	startProfiling ()

void	stopProfiling ()

	~LMFUnique () override

Public Member Functions inherited from IDBObject
oracle::occi::Connection *	getConn () const

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

void	setConnection (oracle::occi::Environment env, oracle::occi::Connection conn)

virtual	~IDBObject ()

Private Member Functions
std::map< int, LMFSeqDat >	fetchByRunIOV (const std::vector< std::string > &par, std::string sql, std::string method) noexcept(false)

std::map< int, LMFSeqDat >	fetchByRunIOV (int par, std::string sql, std::string method) noexcept(false)

std::map< int, LMFSeqDat >	fetchByRunIOV (std::string sql, std::string method) noexcept(false)

std::string	fetchIdSql (Statement *stmt) override

void	fetchParentIDs () noexcept(false) override

void	getParameters (ResultSet *rset) override

std::string	setByIDSql (Statement *stmt, int id) override

void	setVmax (int v)

void	setVmin (int v)

std::string	writeDBSql (Statement *stmt) override

Private Attributes
RunIOV	m_runIOV

Friends
class	EcalCondDBInterface

Additional Inherited Members
Public Types inherited from LMFUnique
typedef oracle::occi::ResultSet	ResultSet

typedef oracle::occi::Statement	Statement

Static Public Attributes inherited from IDBObject
static const int	ECALDB_NROWS = 1024

Protected Member Functions inherited from LMFUnique
virtual void	setClassName (std::string s)

virtual int	writeDB () noexcept(false)

virtual int	writeForeignKeys () noexcept(false)

Protected Member Functions inherited from IDBObject
void	checkConnection () const noexcept(false)

Protected Attributes inherited from LMFUnique
bool	_profiling

std::string	m_className

char	m_debug

std::map< std::string, LMFUnique * >	m_foreignKeys

std::map< std::string, int >	m_intFields

std::map< std::string, std::string >	m_stringFields

Protected Attributes inherited from IUniqueDBObject
int	m_ID

Protected Attributes inherited from IDBObject
oracle::occi::Connection *	m_conn

oracle::occi::Environment *	m_env

Detailed Description

Definition at line 14 of file LMFSeqDat.h.

Constructor & Destructor Documentation

◆ LMFSeqDat() [1/3]

LMFSeqDat::LMFSeqDat ( )

Definition at line 10 of file LMFSeqDat.cc.

                      : LMFUnique() {
   setClassName("LMFSeqDat");
  
   m_runIOV = RunIOV();
   m_intFields["seq_num"] = 0;
   Tm t;
   t = t.plusInfinity();
   m_stringFields["seq_start"] = t.str();
   m_stringFields["seq_stop"] = t.str();
   m_intFields["vmin"] = 1;
   m_intFields["vmax"] = 0;
 }

References LMFUnique::m_intFields, m_runIOV, LMFUnique::m_stringFields, LMFUnique::setClassName(), and submitPVValidationJobs::t.

◆ LMFSeqDat() [2/3]

LMFSeqDat::LMFSeqDat	(	oracle::occi::Environment *	env,
		oracle::occi::Connection *	conn
	)

Definition at line 36 of file LMFSeqDat.cc.

                                                                            : LMFUnique(env, conn) {
   setClassName("LMFSeqDat");
  
   m_runIOV = RunIOV();
   m_intFields["seq_num"] = 0;
   Tm t;
   t = t.plusInfinity();
   m_stringFields["seq_start"] = t.str();
   m_stringFields["seq_stop"] = t.str();
   m_intFields["vmin"] = 1;
   m_intFields["vmax"] = 0;
 }

References LMFUnique::m_intFields, m_runIOV, LMFUnique::m_stringFields, LMFUnique::setClassName(), and submitPVValidationJobs::t.

◆ LMFSeqDat() [3/3]

LMFSeqDat::LMFSeqDat ( EcalDBConnection * c )

Definition at line 23 of file LMFSeqDat.cc.

                                         : LMFUnique(c) {
   setClassName("LMFSeqDat");
  
   m_runIOV = RunIOV();
   m_intFields["seq_num"] = 0;
   Tm t;
   t = t.plusInfinity();
   m_stringFields["seq_start"] = t.str();
   m_stringFields["seq_stop"] = t.str();
   m_intFields["vmin"] = 1;
   m_intFields["vmax"] = 0;
 }

References LMFUnique::m_intFields, m_runIOV, LMFUnique::m_stringFields, LMFUnique::setClassName(), and submitPVValidationJobs::t.

◆ ~LMFSeqDat()

LMFSeqDat::~LMFSeqDat ( )

override

Definition at line 49 of file LMFSeqDat.cc.

49 {}

Member Function Documentation

◆ fetchByRunIOV() [1/6]

std::map< int, LMFSeqDat > LMFSeqDat::fetchByRunIOV	(	const std::vector< std::string > &	par,
		std::string	sql,
		std::string	method
	)

privatenoexcept

Definition at line 198 of file LMFSeqDat.cc.

                                                                                     {
   std::map<int, LMFSeqDat> l;
   this->checkConnection();
   try {
     Statement *stmt = m_conn->createStatement();
     stmt->setSQL(sql);
     for (unsigned int i = 0; i < pars.size(); i++) {
       if (pars[i][0] == 'I') {
         stmt->setInt(i + 1, atoi(pars[i].c_str() + 1));
       } else if (pars[i][0] == 'S') {
         stmt->setString(i + 1, pars[i].c_str() + 1);
       } else {
         throw(std::runtime_error(m_className + "::" + method + ": " + "Invalid type"));
       }
     }
     ResultSet *rset = stmt->executeQuery();
     while (rset->next() != 0) {
       int seq_id = rset->getInt(1);
       LMFSeqDat s;
       s.setConnection(m_env, m_conn);
       s.setByID(seq_id);
       l[s.getSequenceNumber()] = s;
     }
     m_conn->terminateStatement(stmt);
   } catch (SQLException &e) {
     throw(std::runtime_error(m_className + "::" + method + ": " + e.getMessage()));
   }
   return l;
 }

References MillePedeFileConverter_cfg::e, mps_fire::i, cmsLHEtoEOSManager::l, AlcaSiPixelAliHarvester0T_cff::method, and alignCSCRings::s.

◆ fetchByRunIOV() [2/6]

std::map< int, LMFSeqDat > LMFSeqDat::fetchByRunIOV	(	int	par,
		std::string	sql,
		std::string	method
	)

privatenoexcept

Definition at line 190 of file LMFSeqDat.cc.

                                                                                                         {
   std::vector<std::string> pars;
   std::stringstream ss;
   ss << "I" << par;
   pars.push_back(ss.str());
   return fetchByRunIOV(pars, sql, method);
 }

References AlcaSiPixelAliHarvester0T_cff::method, and contentValuesCheck::ss.

◆ fetchByRunIOV() [3/6]

std::map< int, LMFSeqDat > LMFSeqDat::fetchByRunIOV ( RunIOV & iov )

Definition at line 245 of file LMFSeqDat.cc.

                                                            {
   int runIOVID = iov.getID();
   return fetchByRunIOV(runIOVID,
                        "SELECT SEQ_ID FROM CMS_ECAL_LASER_COND.LMF_SEQ_DAT "
                        "WHERE RUN_IOV_ID = :1",
                        "fetchByRunIOV");
 }

References RunIOV::getID().

Referenced by fetchByRunIOV(), fetchByRunNumber(), and fetchLast().

◆ fetchByRunIOV() [4/6]

std::map< int, LMFSeqDat > LMFSeqDat::fetchByRunIOV	(	RunIOV &	iov,
		const LMFColor &	col
	)

Definition at line 253 of file LMFSeqDat.cc.

                                                                                 {
   int runIOVID = iov.getID();
   int colorId = col.getID();
   std::vector<std::string> pars;
   std::stringstream ss;
   ss << "I" << runIOVID;
   pars.push_back(ss.str());
   ss.str(std::string());
   ss << "I" << colorId;
   pars.push_back(ss.str());
   return fetchByRunIOV(pars,
                        "SELECT S.SEQ_ID FROM CMS_ECAL_LASER_COND.LMF_SEQ_DAT "
                        "S JOIN CMS_ECAL_LASER_COND.LMF_RUN_IOV R"
                        " ON S.SEQ_ID = R.SEQ_ID WHERE RUN_IOV_ID = :1 AND "
                        " COLOR_ID = :2",
                        "fetchByRunIOVAndColor");
 }

References cuy::col, fetchByRunIOV(), RunIOV::getID(), contentValuesCheck::ss, and AlCaHLTBitMon_QueryRunRegistry::string.

◆ fetchByRunIOV() [5/6]

LMFSeqDat LMFSeqDat::fetchByRunIOV	(	RunIOV &	iov,
		int	seq_num
	)

inline

Definition at line 65 of file LMFSeqDat.h.

65 { return fetchByRunIOV(iov)[seq_num]; }

References fetchByRunIOV().

Referenced by fetchByRunIOV().

◆ fetchByRunIOV() [6/6]

std::map< int, LMFSeqDat > LMFSeqDat::fetchByRunIOV	(	std::string	sql,
		std::string	method
	)

privatenoexcept

Definition at line 185 of file LMFSeqDat.cc.

                                                                                                {
   std::vector<std::string> pars;
   return fetchByRunIOV(pars, sql, method);
 }

References AlcaSiPixelAliHarvester0T_cff::method.

◆ fetchByRunNumber() [1/4]

std::map< int, LMFSeqDat > LMFSeqDat::fetchByRunNumber ( int runno )

Definition at line 271 of file LMFSeqDat.cc.

                                                             {
   return fetchByRunIOV(runno,
                        "SELECT SEQ_ID FROM CMS_ECAL_LASER_COND.LMF_SEQ_DAT D "
                        "JOIN CMS_ECAL_COND.RUN_IOV R ON "
                        "D.RUN_IOV_ID = R.IOV_ID WHERE RUN_NUM = :1",
                        "fetchByRunNumber");
 }

References fetchByRunIOV(), and visualization-live-secondInstance_cfg::runno.

Referenced by fetchByRunNumber().

◆ fetchByRunNumber() [2/4]

LMFSeqDat LMFSeqDat::fetchByRunNumber	(	int	runno,
		const Tm &	taken_at
	)

Definition at line 279 of file LMFSeqDat.cc.

279 { return fetchByRunNumber(runno, taken_at.str()); }

References fetchByRunNumber(), visualization-live-secondInstance_cfg::runno, and Tm::str().

◆ fetchByRunNumber() [3/4]

LMFSeqDat LMFSeqDat::fetchByRunNumber	(	int	runno,
		int	seq_num
	)

inline

Definition at line 67 of file LMFSeqDat.h.

67 { return fetchByRunNumber(runno)[seq_num]; }

References fetchByRunNumber(), and visualization-live-secondInstance_cfg::runno.

Referenced by fetchByRunNumber().

◆ fetchByRunNumber() [4/4]

LMFSeqDat LMFSeqDat::fetchByRunNumber	(	int	runno,
		std::string	taken_at
	)

Definition at line 281 of file LMFSeqDat.cc.

                                                                    {
   std::map<int, LMFSeqDat> l;
   std::vector<std::string> pars;
   std::stringstream ss;
   ss << "I" << runno;
   pars.push_back(ss.str());
   ss.str(std::string());
   ss << "S" << taken_at;
   pars.push_back(ss.str());
   std::string q =
       "SELECT SEQ_ID FROM CMS_ECAL_LASER_COND.LMF_SEQ_DAT D "
       "JOIN CMS_ECAL_COND.RUN_IOV R ON "
       "D.RUN_IOV_ID = R.IOV_ID WHERE RUN_NUM = :1 AND "
       "SEQ_START >= TO_DATE(:2, 'YYYY-MM-DD HH24:MI:SS') "
       "AND SEQ_STOP <= TO_DATE(:2, 'YYYY-MM-DD HH24:MI:SS')";
   l = fetchByRunIOV(pars, q, "fetchByRunNumberAt");
   LMFSeqDat ret;
   if (l.size() == 1) {
     std::map<int, LMFSeqDat>::const_iterator x = l.begin();
     ret = x->second;
   } else if (l.size() > 1) {
     std::cout << "WARNING: Your query returned more than one result. " << std::endl;
     std::cout << "         This was not expected. Please check the DB!!!" << std::endl;
     std::cout << "Your query: " << std::endl << q << std::endl;
     std::cout << "Your parameters: " << std::endl;
     for (unsigned int i = 0; i < pars.size(); i++) {
       std::cout << i << ": " << pars[i] << std::endl;
     }
   }
   return ret;
 }

References gather_cfg::cout, fetchByRunIOV(), mps_fire::i, cmsLHEtoEOSManager::l, submitPVResolutionJobs::q, runTheMatrix::ret, visualization-live-secondInstance_cfg::runno, contentValuesCheck::ss, AlCaHLTBitMon_QueryRunRegistry::string, and x.

◆ fetchIdSql()

std::string LMFSeqDat::fetchIdSql ( Statement * stmt )

overrideprivatevirtual

Reimplemented from LMFUnique.

Definition at line 67 of file LMFSeqDat.cc.

                                                {
   int runIOVID = m_runIOV.getID();
   if (!runIOVID) {
     if (m_debug) {
       std::cout << m_className << ": RunIOV not set" << endl;
     }
     return "";
   }
  
   if (m_debug) {
     std::cout << "Run IOV ID: " << runIOVID << std::endl;
     std::cout << "SEQ #     : " << getSequenceNumber() << std::endl;
     std::cout << "Versions  : " << getVmin() << " - " << getVmax() << endl;
   }
   std::string sql =
       "SELECT SEQ_ID FROM CMS_ECAL_LASER_COND.LMF_SEQ_DAT "
       "WHERE "
       "RUN_IOV_ID   = :1 AND "
       "SEQ_NUM      = :2 AND "
       "VMIN         = :3 ";
   if (getVmax() > 0) {
     sql += "AND VMAX = :4";
   } else {
     sql += "ORDER BY VMAX DESC";
   }
   stmt->setSQL(sql);
   stmt->setInt(1, runIOVID);
   stmt->setInt(2, getSequenceNumber());
   stmt->setInt(3, getVmin());
   if (getVmax() > 0) {
     stmt->setInt(4, getVmax());
   }
   return sql;
 }

References gather_cfg::cout, RunIOV::getID(), getSequenceNumber(), getVmax(), getVmin(), LMFUnique::m_className, LMFUnique::m_debug, m_runIOV, and AlCaHLTBitMon_QueryRunRegistry::string.

◆ fetchLast()

LMFSeqDat LMFSeqDat::fetchLast ( )

Definition at line 230 of file LMFSeqDat.cc.

                                {
   LMFSeqDat ret;
   std::map<int, LMFSeqDat> m = fetchByRunIOV(
       "SELECT SEQ_ID FROM CMS_ECAL_LASER_COND.LMF_SEQ_DAT "
       "WHERE SEQ_ID = "
       "(SELECT MAX(SEQ_ID) FROM CMS_ECAL_LASER_COND.LMF_SEQ_DAT)",
       "fetchLast");
   if (!m.empty()) {
     ret = m.begin()->second;
   }
   return ret;
 }

References fetchByRunIOV(), visualization-live-secondInstance_cfg::m, and runTheMatrix::ret.

Referenced by fetchLastRun().

◆ fetchLastRun()

RunIOV LMFSeqDat::fetchLastRun ( )

Definition at line 243 of file LMFSeqDat.cc.

243 { return fetchLast().getRunIOV(); }

References fetchLast(), and getRunIOV().

◆ fetchParentIDs()

void LMFSeqDat::fetchParentIDs ( )

overrideprivatevirtualnoexcept

Reimplemented from LMFUnique.

Definition at line 174 of file LMFSeqDat.cc.

                                                {
   // get the RunIOV
   m_runIOV.setConnection(m_env, m_conn);
   int runIOVID = m_runIOV.getID();
   m_runIOV.setByID(runIOVID);
  
   if (m_runIOV.getID() == 0) {
     throw(std::runtime_error("LMFSeqDat:  Given RunIOV does not exist in DB"));
   }
 }

References RunIOV::getID(), IDBObject::m_conn, IDBObject::m_env, m_runIOV, RunIOV::setByID(), and IDBObject::setConnection().

◆ getParameters()

void LMFSeqDat::getParameters ( ResultSet * rset )

overrideprivatevirtual

Reimplemented from LMFUnique.

Definition at line 111 of file LMFSeqDat.cc.

                                              {
   DateHandler dh(m_env, m_conn);
   int runIOVID = rset->getInt(1);
   setInt("seq_num", rset->getInt(2));
   Date startDate = rset->getDate(3);
   Date endDate = rset->getDate(4);
   setInt("vmin", rset->getInt(5));
   setInt("vmax", rset->getInt(6));
  
   setString("seq_start", dh.dateToTm(startDate).str());
   setString("seq_stop", dh.dateToTm(endDate).str());
  
   m_runIOV.setConnection(m_env, m_conn);
   m_runIOV.setByID(runIOVID);
 }

References cuy::dh, IDBObject::m_conn, IDBObject::m_env, m_runIOV, RunIOV::setByID(), IDBObject::setConnection(), LMFUnique::setInt(), and LMFUnique::setString().

◆ getRunIOV()

RunIOV LMFSeqDat::getRunIOV ( ) const

Definition at line 57 of file LMFSeqDat.cc.

57 { return m_runIOV; }

References m_runIOV.

Referenced by fetchLastRun(), and operator==().

◆ getSequenceNumber()

int LMFSeqDat::getSequenceNumber ( ) const

inline

Definition at line 44 of file LMFSeqDat.h.

44 { return getInt("seq_num"); }

References LMFUnique::getInt().

Referenced by fetchIdSql(), operator==(), and writeDBSql().

◆ getSequenceStart()

Tm LMFSeqDat::getSequenceStart ( ) const

inline

Definition at line 45 of file LMFSeqDat.h.

                               {
     Tm t;
     t.setToString(getString("seq_start"));
     return t;
   }

References LMFUnique::getString(), and submitPVValidationJobs::t.

Referenced by isValid(), operator==(), and writeDBSql().

◆ getSequenceStop()

Tm LMFSeqDat::getSequenceStop ( ) const

Definition at line 51 of file LMFSeqDat.cc.

                                     {
   Tm t;
   t.setToString(getString("seq_stop"));
   return t;
 }

References LMFUnique::getString(), and submitPVValidationJobs::t.

Referenced by isValid(), operator==(), and writeDBSql().

◆ getVmax()

int LMFSeqDat::getVmax ( ) const

inline

Definition at line 52 of file LMFSeqDat.h.

52 { return getInt("vmax"); }

References LMFUnique::getInt().

Referenced by fetchIdSql(), operator==(), and writeDBSql().

◆ getVmin()

int LMFSeqDat::getVmin ( ) const

inline

Definition at line 51 of file LMFSeqDat.h.

51 { return getInt("vmin"); }

References LMFUnique::getInt().

Referenced by fetchIdSql(), operator==(), and writeDBSql().

◆ isValid()

bool LMFSeqDat::isValid ( void ) const

overridevirtual

Reimplemented from LMFUnique.

Definition at line 127 of file LMFSeqDat.cc.

                               {
   bool ret = true;
   if (getSequenceStart().isNull()) {
     ret = false;
   }
   if ((getSequenceStop().str().length() > 0) && (getSequenceStop().microsTime() < getSequenceStart().microsTime())) {
     ret = false;
   }
   if (getSequenceStop() == Tm().plusInfinity()) {
     ret = false;
   }
   return ret;
 }

References getSequenceStart(), getSequenceStop(), runTheMatrix::ret, and str.

Referenced by ntupleDataFormat._Object::_checkIsValid(), core.AutoHandle.AutoHandle::ReallyLoad(), and writeDBSql().

◆ operator!=()

bool LMFSeqDat::operator!= ( const LMFSeqDat & m ) const

inline

Definition at line 62 of file LMFSeqDat.h.

62 { return !(*this == m); }

References visualization-live-secondInstance_cfg::m.

◆ operator==()

bool LMFSeqDat::operator== ( const LMFSeqDat & m ) const

inline

Definition at line 56 of file LMFSeqDat.h.

                                             {
     return (getSequenceNumber() == m.getSequenceNumber() && getRunIOV() == m.getRunIOV() &&
             getSequenceStart() == m.getSequenceStart() && getSequenceStop() == m.getSequenceStop() &&
             getVmin() == m.getVmin() && getVmax() == m.getVmax());
   }

References getRunIOV(), getSequenceNumber(), getSequenceStart(), getSequenceStop(), getVmax(), getVmin(), and visualization-live-secondInstance_cfg::m.

◆ setByIDSql()

std::string LMFSeqDat::setByIDSql	(	Statement *	stmt,
		int	id
	)

overrideprivatevirtual

Reimplemented from LMFUnique.

Definition at line 102 of file LMFSeqDat.cc.

                                                        {
   std::string sql =
       "SELECT RUN_IOV_ID, SEQ_NUM, SEQ_START, SEQ_STOP, "
       "VMIN, VMAX FROM CMS_ECAL_LASER_COND.LMF_SEQ_DAT WHERE SEQ_ID = :1";
   stmt->setSQL(sql);
   stmt->setInt(1, id);
   return sql;
 }

References AlCaHLTBitMon_QueryRunRegistry::string.

◆ setRunIOV()

LMFSeqDat & LMFSeqDat::setRunIOV ( const RunIOV & iov )

Definition at line 59 of file LMFSeqDat.cc.

                                                  {
   if (iov != m_runIOV) {
     m_ID = 0;
     m_runIOV = iov;
   }
   return *this;
 }

References IUniqueDBObject::m_ID, and m_runIOV.

◆ setSequenceNumber()

LMFSeqDat& LMFSeqDat::setSequenceNumber ( int n )

inline

Definition at line 25 of file LMFSeqDat.h.

                                       {
     setInt("seq_num", n);
     return *this;
   }

References dqmiodumpmetadata::n, and LMFUnique::setInt().

◆ setSequenceStart()

LMFSeqDat& LMFSeqDat::setSequenceStart ( const Tm & start )

inline

Definition at line 29 of file LMFSeqDat.h.

                                                {
     setString("seq_start", start.str());
     return *this;
   }

References LMFUnique::setString().

◆ setSequenceStop()

LMFSeqDat& LMFSeqDat::setSequenceStop ( const Tm & end )

inline

Definition at line 33 of file LMFSeqDat.h.

                                             {
     setString("seq_stop", end.str());
     return *this;
   }

References mps_fire::end, and LMFUnique::setString().

Referenced by writeDBSql().

◆ setVersions()

LMFSeqDat& LMFSeqDat::setVersions	(	int	vmin,
		int	vmax
	)

inline

Definition at line 37 of file LMFSeqDat.h.

                                              {
     setVmin(vmin);
     setVmax(vmax);
     return *this;
   }

References setVmax(), and setVmin().

◆ setVmax()

void LMFSeqDat::setVmax ( int v )

inlineprivate

Definition at line 77 of file LMFSeqDat.h.

77 { setInt("vmax", v); }

References LMFUnique::setInt(), and findQualityFiles::v.

Referenced by setVersions().

◆ setVmin()

void LMFSeqDat::setVmin ( int v )

inlineprivate

Definition at line 76 of file LMFSeqDat.h.

76 { setInt("vmin", v); }

References LMFUnique::setInt(), and findQualityFiles::v.

Referenced by setVersions().

◆ writeDBSql()

std::string LMFSeqDat::writeDBSql ( Statement * stmt )

overrideprivatevirtual

Reimplemented from LMFUnique.

Definition at line 141 of file LMFSeqDat.cc.

                                                {
   // Validate the data, use infinity-till convention
   DateHandler dh(m_env, m_conn);
  
   if (!isValid()) {
     dump();
     throw(std::runtime_error("LMFSeqDat::writeDB: not valid"));
   }
  
   if (getSequenceStop().str().length() == 0) {
     setSequenceStop(dh.getPlusInfTm());
   }
   int runIOVID = m_runIOV.getID();
   if (runIOVID == 0) {
     throw(std::runtime_error("LMFSeqDat::writeDB: RunIOV not set"));
   }
   std::string sp = sequencePostfix(getSequenceStart());
   std::string sql =
       "INSERT INTO LMF_SEQ_DAT (SEQ_ID, RUN_IOV_ID, SEQ_NUM, "
       "SEQ_START, SEQ_STOP, VMIN, VMAX) "
       "VALUES (SEQ_ID_" +
       sp + "_SQ.NextVal, :1, :2, :3, :4, :5, :6)";
   cout << sql << endl;
   stmt->setSQL(sql);
   stmt->setInt(1, runIOVID);
   stmt->setInt(2, getSequenceNumber());
   stmt->setDate(3, dh.tmToDate(getSequenceStart()));
   stmt->setDate(4, dh.tmToDate(getSequenceStop()));
   stmt->setInt(5, getVmin());
   stmt->setInt(6, getVmax());
   return sql;
 }

References gather_cfg::cout, cuy::dh, LMFUnique::dump(), RunIOV::getID(), getSequenceNumber(), getSequenceStart(), getSequenceStop(), getVmax(), getVmin(), isValid(), IDBObject::m_conn, IDBObject::m_env, m_runIOV, LMFUnique::sequencePostfix(), setSequenceStop(), str, and AlCaHLTBitMon_QueryRunRegistry::string.

Friends And Related Function Documentation

◆ EcalCondDBInterface

friend class EcalCondDBInterface

friend

Definition at line 16 of file LMFSeqDat.h.

Member Data Documentation

◆ m_runIOV

RunIOV LMFSeqDat::m_runIOV

private

Definition at line 74 of file LMFSeqDat.h.

Referenced by fetchIdSql(), fetchParentIDs(), getParameters(), getRunIOV(), LMFSeqDat(), setRunIOV(), and writeDBSql().

Public Member Functions

Private Member Functions

Private Attributes

Friends

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ LMFSeqDat() [1/3]

◆ LMFSeqDat() [2/3]

◆ LMFSeqDat() [3/3]

◆ ~LMFSeqDat()

Member Function Documentation

◆ fetchByRunIOV() [1/6]

◆ fetchByRunIOV() [2/6]

◆ fetchByRunIOV() [3/6]

◆ fetchByRunIOV() [4/6]

◆ fetchByRunIOV() [5/6]

◆ fetchByRunIOV() [6/6]

◆ fetchByRunNumber() [1/4]

◆ fetchByRunNumber() [2/4]

◆ fetchByRunNumber() [3/4]

◆ fetchByRunNumber() [4/4]

◆ fetchIdSql()

◆ fetchLast()

◆ fetchLastRun()

◆ fetchParentIDs()

◆ getParameters()

◆ getRunIOV()

◆ getSequenceNumber()

◆ getSequenceStart()

◆ getSequenceStop()

◆ getVmax()

◆ getVmin()

◆ isValid()

◆ operator!=()

◆ operator==()

◆ setByIDSql()

◆ setRunIOV()

◆ setSequenceNumber()

◆ setSequenceStart()

◆ setSequenceStop()

◆ setVersions()

◆ setVmax()

◆ setVmin()

◆ writeDBSql()

Friends And Related Function Documentation

◆ EcalCondDBInterface

Member Data Documentation

◆ m_runIOV