LMFLmrSubIOV Class Reference

#include <LMFLmrSubIOV.h>

Inheritance diagram for LMFLmrSubIOV:

Public Member Functions
std::list< LMFLmrSubIOV >	fetchByLMFIOV (const LMFIOV &iov)
std::list< int >	getIOVIDsLaterThan (const Tm &t) noexcept(false)
std::list< int >	getIOVIDsLaterThan (const Tm &tmin, const Tm &tmax) noexcept(false)
std::list< int >	getIOVIDsLaterThan (const Tm &t, int howMany) noexcept(false)
std::list< int >	getIOVIDsLaterThan (const Tm &t, const Tm &tmax, int howMany) noexcept(false)
LMFIOV	getLMFIOV () const
int	getLMFIOVID () const
Tm	getT1 ()
Tm	getT2 ()
Tm	getT3 ()
Tm	getTime (int i)
void	getTimes (Tm *t1, Tm *t2, Tm *t3) const
std::vector< Tm >	getTimes () const
void	getTimes (Tm *t) const
	LMFLmrSubIOV ()
	LMFLmrSubIOV (EcalDBConnection *c)
	LMFLmrSubIOV (oracle::occi::Environment *env, oracle::occi::Connection *conn)
bool	operator!= (const LMFLmrSubIOV &m) const
bool	operator== (const LMFLmrSubIOV &m) const
LMFLmrSubIOV &	setLMFIOV (const LMFIOV &iov)
LMFLmrSubIOV &	setLMFIOV (int i)
LMFLmrSubIOV &	setTimes (const Tm &t1, const Tm &t2, const Tm &t3)
LMFLmrSubIOV &	setTimes (const std::vector< Tm > &t)
LMFLmrSubIOV &	setTimes (Tm *t)
	~LMFLmrSubIOV () 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 () const
virtual bool	isValid ()
	LMFUnique ()
	LMFUnique (oracle::occi::Environment *env, oracle::occi::Connection *conn)
	LMFUnique (EcalDBConnection *c)
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::string	fetchIdSql (Statement *stmt) override
void	getParameters (ResultSet *rset) override
void	init ()
std::string	setByIDSql (Statement *stmt, int id) override
std::string	writeDBSql (Statement *stmt) override

Private Attributes
int	m_lmfIOV
Tm	m_t [3]

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 int const	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 13 of file LMFLmrSubIOV.h.

Constructor & Destructor Documentation

LMFLmrSubIOV::LMFLmrSubIOV

(

)

Definition at line 15 of file LMFLmrSubIOV.cc.

References init().

{ init(); }

LMFLmrSubIOV::LMFLmrSubIOV

(

EcalDBConnection *

c

)

Definition at line 17 of file LMFLmrSubIOV.cc.

References init().

: LMFUnique(c) { init(); }

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

Definition at line 19 of file LMFLmrSubIOV.cc.

References init().

                                                                                 : LMFUnique(env, conn) {
  init();
}

LMFLmrSubIOV::~LMFLmrSubIOV ( )

override

Definition at line 23 of file LMFLmrSubIOV.cc.

{}

Member Function Documentation

std::list<LMFLmrSubIOV> LMFLmrSubIOV::fetchByLMFIOV

(

const LMFIOV &

iov

)

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

overrideprivatevirtual

Reimplemented from LMFUnique.

Definition at line 47 of file LMFLmrSubIOV.cc.

References gather_cfg::cout, cuy::dh, mps_fire::i, LMFUnique::m_className, IDBObject::m_conn, LMFUnique::m_debug, IDBObject::m_env, m_lmfIOV, m_t, AlCaHLTBitMon_QueryRunRegistry::string, submitPVValidationJobs::t, and DateHandler::tmToDate().

                                                  {
  if (!m_lmfIOV) {
    if (m_debug) {
      std::cout << m_className << ": LMFIOV not set" << std::endl;
    }
    return "";
  }

  std::string sql =
      "SELECT LMR_SUB_IOV_ID FROM "
      "CMS_ECAL_LASER_COND.LMF_LMR_SUB_IOV "
      "WHERE "
      "IOV_ID  = :1 AND "
      "T1      = :2 AND "
      "T2      = :3 AND "
      "T3      = :4";
  stmt->setSQL(sql);
  stmt->setInt(1, m_lmfIOV);
  DateHandler dh(m_env, m_conn);
  for (int i = 0; i < 3; i++) {
    oracle::occi::Date t = dh.tmToDate(m_t[i]);
    stmt->setDate(i + 2, t);
  }
  return sql;
}

std::list< int > LMFLmrSubIOV::getIOVIDsLaterThan ( const Tm &  t )

noexcept

Definition at line 145 of file LMFLmrSubIOV.cc.

References Tm::setToString(), and submitPVValidationJobs::t.

Referenced by LMFCorrCoefDat::fetchBetween().

                                                                         {
  Tm tinf;
  tinf.setToString("9999-12-31 23:59:59");
  return getIOVIDsLaterThan(t, tinf, 0);
}

std::list< int > LMFLmrSubIOV::getIOVIDsLaterThan ( const Tm &  tmin, const Tm &  tmax  )

noexcept

Definition at line 157 of file LMFLmrSubIOV.cc.

References tmax.

                                                                                            {
  return getIOVIDsLaterThan(tmin, tmax, 0);
}

std::list< int > LMFLmrSubIOV::getIOVIDsLaterThan ( const Tm &  t, int  howMany  )

noexcept

Definition at line 151 of file LMFLmrSubIOV.cc.

References Tm::setToString(), and submitPVValidationJobs::t.

                                                                                      {
  Tm tinf;
  tinf.setToString("9999-12-31 23:59:59");
  return getIOVIDsLaterThan(t, tinf, howmany);
}

std::list< int > LMFLmrSubIOV::getIOVIDsLaterThan ( const Tm &  t, const Tm &  tmax, int  howMany  )

noexcept

Definition at line 161 of file LMFLmrSubIOV.cc.

References gather_cfg::cout, cuy::dh, alignCSCRings::e, runTheMatrix::ret, Tm::setToString(), AlCaHLTBitMon_QueryRunRegistry::string, tmax, and DateHandler::tmToDate().

                                                                                                         {
  Tm tinf;
  tinf.setToString("9999-12-31 23:59:59");
  std::string sql =
      "SELECT * FROM (SELECT LMR_SUB_IOV_ID "
      "FROM CMS_ECAL_LASER_COND.LMF_LMR_SUB_IOV WHERE T3 > :1 ";
  if (tmax != tinf) {
    sql += "AND T3 < :2 ORDER BY T3 ASC) ";
    if (howMany > 0) {
      sql += "WHERE ROWNUM <= :3";
    }
  } else {
    sql += "ORDER BY T3 ASC) ";
    if (howMany > 0) {
      sql += "WHERE ROWNUM <= :2";
    }
  }
  if (m_debug) {
    std::cout << "Executing query: " << std::endl << sql << std::endl;
  }
  std::list<int> ret;
  if (m_conn != nullptr) {
    try {
      DateHandler dh(m_env, m_conn);
      Statement *stmt = m_conn->createStatement();
      stmt->setPrefetchRowCount(10000);
      stmt->setSQL(sql);
      stmt->setDate(1, dh.tmToDate(tmin));
      if (tmax != tinf) {
        stmt->setDate(2, dh.tmToDate(tmax));
        if (howMany > 0) {
          stmt->setInt(3, howMany);
        }
      } else {
        if (howMany > 0) {
          stmt->setInt(2, howMany);
        }
      }
      ResultSet *rset = stmt->executeQuery();
      int row = 1;
      while (rset->next() != 0) {
        if (m_debug) {
          std::cout << "Getting row " << row++ << std::endl;
        }
        ret.push_back(rset->getInt(1));
      }
      stmt->setPrefetchRowCount(0);
      m_conn->terminateStatement(stmt);
    } catch (oracle::occi::SQLException &e) {
#if defined(_GLIBCXX_USE_CXX11_ABI) && (_GLIBCXX_USE_CXX11_ABI == 0)
      throw(std::runtime_error(m_className + "::getLmrSubIOVLaterThan: " + e.getMessage()));
#else
      throw(
          std::runtime_error(m_className + "::getLmrSubIOVLaterThan: error code " + std::to_string(e.getErrorCode())));
#endif
    }
  } else {
    throw(std::runtime_error(m_className + "::getLmrSubIOVLaterThan: " + "Connection not set"));
  }
  if (m_debug) {
    std::cout << "Sorting..." << std::flush;
  }
  ret.sort();
  if (m_debug) {
    std::cout << "Done!" << std::endl << std::flush;
  }
  return ret;
}

LMFIOV LMFLmrSubIOV::getLMFIOV ( ) const

inline

Definition at line 29 of file LMFLmrSubIOV.h.

References IDBObject::m_conn, IDBObject::m_env, m_lmfIOV, and LMFUnique::setByID().

                           {
    LMFIOV iov(m_env, m_conn);
    iov.setByID(m_lmfIOV);
    return iov;
  };

int LMFLmrSubIOV::getLMFIOVID ( ) const

inline

Definition at line 28 of file LMFLmrSubIOV.h.

References m_lmfIOV.

{ return m_lmfIOV; };

void LMFLmrSubIOV::getParameters ( ResultSet *  rset )

overrideprivatevirtualnoexcept

Reimplemented from LMFUnique.

Definition at line 110 of file LMFLmrSubIOV.cc.

References util.getRunInfo::day(), mps_fire::i, min(), seconds(), AlCaHLTBitMon_QueryRunRegistry::string, submitPVValidationJobs::t, and groupFilesInBlocks::tt.

                                                                {
  m_lmfIOV = rset->getInt(1);
  for (int i = 0; i < 3; i++) {
    oracle::occi::Date t = rset->getDate(i + 2);
#if defined(_GLIBCXX_USE_CXX11_ABI) && (_GLIBCXX_USE_CXX11_ABI == 0)
    m_t[i].setToString(t.toText("YYYY-MM-DD HH24:MI:SS"));
#else
    int year = 0;
    unsigned int month = 0;
    unsigned int day = 0;
    unsigned int hour = 0;
    unsigned int min = 0;
    unsigned int seconds = 0;
    t.getDate(year, month, day, hour, min, seconds);
    const std::tm tt = {.tm_sec = static_cast<int>(seconds),
                        .tm_min = static_cast<int>(min),
                        .tm_hour = static_cast<int>(hour),
                        .tm_mday = static_cast<int>(day),
                        .tm_mon = static_cast<int>(month),
                        .tm_year = year - 1900,
                        .tm_wday = 0,
                        .tm_yday = 0,
                        .tm_isdst = 0,
                        .tm_gmtoff = 0,
                        .tm_zone = nullptr};
    char tt_str[30] = {0};
    if (std::strftime(tt_str, sizeof(tt_str), "%F %T", &tt)) {
      m_t[i].setToString(std::string(tt_str));
    } else {
      throw std::runtime_error("LMFLmrSubIOV::writeDBSql: failed to generate the date string");
    }
#endif
  }
}

Tm LMFLmrSubIOV::getT1 ( )

inline

Definition at line 58 of file LMFLmrSubIOV.h.

References m_t.

{ return m_t[0]; }

Tm LMFLmrSubIOV::getT2 ( )

inline

Definition at line 59 of file LMFLmrSubIOV.h.

References m_t.

{ return m_t[1]; }

Tm LMFLmrSubIOV::getT3 ( )

inline

Definition at line 60 of file LMFLmrSubIOV.h.

References m_t.

{ return m_t[2]; }

Tm LMFLmrSubIOV::getTime ( int  i )

inline

Definition at line 51 of file LMFLmrSubIOV.h.

References m_t, and submitPVValidationJobs::t.

                           {
    Tm t;
    if ((i > 0) && (i < 4)) {
      t = m_t[i - 1];
    }
    return t;
  }

void LMFLmrSubIOV::getTimes ( Tm *  t1, Tm *  t2, Tm *  t3  ) const

inline

Definition at line 34 of file LMFLmrSubIOV.h.

References m_t.

Referenced by LMFCorrCoefDat::getTimes().

                                                     {
    *t1 = m_t[0];
    *t2 = m_t[1];
    *t3 = m_t[2];
  }

std::vector<Tm> LMFLmrSubIOV::getTimes ( ) const

inline

Definition at line 39 of file LMFLmrSubIOV.h.

References m_t, and findQualityFiles::v.

                                 {
    std::vector<Tm> v;
    v.push_back(m_t[0]);
    v.push_back(m_t[1]);
    v.push_back(m_t[2]);
    return v;
  }

void LMFLmrSubIOV::getTimes ( Tm *  t ) const

inline

Definition at line 46 of file LMFLmrSubIOV.h.

References m_t.

                                    {
    t[0] = m_t[0];
    t[1] = m_t[1];
    t[2] = m_t[2];
  }

void LMFLmrSubIOV::init ( void  )

private

Definition at line 6 of file LMFLmrSubIOV.cc.

References LMFUnique::m_className, m_lmfIOV, and m_t.

Referenced by LMFLmrSubIOV().

                        {
  m_className = "LMFLmrSubIOV";

  m_lmfIOV = 0;
  m_t[0] = Tm();
  m_t[1] = Tm();
  m_t[2] = Tm();
}

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

inline

Definition at line 72 of file LMFLmrSubIOV.h.

References visualization-live-secondInstance_cfg::m.

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

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

inline

Definition at line 68 of file LMFLmrSubIOV.h.

References m_lmfIOV, and m_t.

                                                      {
    return ((m_lmfIOV == m.m_lmfIOV) && (m_t[0] == m.m_t[0]) && (m_t[1] == m.m_t[1]) && (m_t[2] == m.m_t[2]));
  }

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

overrideprivatevirtual

Reimplemented from LMFUnique.

Definition at line 73 of file LMFLmrSubIOV.cc.

References AlCaHLTBitMon_QueryRunRegistry::string.

                                                          {
  std::string sql =
      "SELECT IOV_ID, T1, T2, T3 FROM "
      "CMS_ECAL_LASER_COND.LMF_LMR_SUB_IOV "
      "WHERE LMR_SUB_IOV_ID = :1";
  stmt->setSQL(sql);
  stmt->setInt(1, id);
  return sql;
}

LMFLmrSubIOV & LMFLmrSubIOV::setLMFIOV

(

const LMFIOV &

iov

)

Definition at line 25 of file LMFLmrSubIOV.cc.

References gather_cfg::cout, LMFUnique::getID(), LMFUnique::m_debug, and m_lmfIOV.

                                                       {
  if (m_debug) {
    std::cout << "[LMFLmrSubIOV] Setting IOV_ID as " << iov.getID() << std::endl << std::flush;
  }
  m_lmfIOV = iov.getID();
  return *this;
}

LMFLmrSubIOV& LMFLmrSubIOV::setLMFIOV

(

int

i

)

LMFLmrSubIOV & LMFLmrSubIOV::setTimes	(	const Tm &	t1,
		const Tm &	t2,
		const Tm &	t3
	)

Definition at line 40 of file LMFLmrSubIOV.cc.

References m_t.

                                                                             {
  m_t[0] = t1;
  m_t[1] = t2;
  m_t[2] = t3;
  return *this;
}

LMFLmrSubIOV& LMFLmrSubIOV::setTimes

(

const std::vector< Tm > &

t

)

LMFLmrSubIOV & LMFLmrSubIOV::setTimes

(

Tm *

t

)

Definition at line 33 of file LMFLmrSubIOV.cc.

References m_t.

                                          {
  m_t[0] = t[0];
  m_t[1] = t[1];
  m_t[2] = t[2];
  return *this;
}

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

overrideprivatevirtual

Reimplemented from LMFUnique.

Definition at line 83 of file LMFLmrSubIOV.cc.

References cuy::dh, DateHandler::getPlusInfTm(), mps_fire::i, LMFUnique::m_className, IDBObject::m_conn, IDBObject::m_env, m_lmfIOV, m_t, LMFUnique::sequencePostfix(), AlCaHLTBitMon_QueryRunRegistry::string, and DateHandler::tmToDate().

                                                  {
  // Validate the data, use infinity-till convention
  DateHandler dh(m_env, m_conn);

  for (int i = 0; i < 3; i++) {
    if (m_t[i].isNull()) {
      m_t[i] = dh.getPlusInfTm();
    }
  }

  if (m_lmfIOV == 0) {
    throw(std::runtime_error(m_className + "::writeDB: LMFIOV not set"));
  }
  std::string sp = sequencePostfix(m_t[0]);
  std::string sql =
      "INSERT INTO LMF_LMR_SUB_IOV (LMR_SUB_IOV_ID, "
      "IOV_ID, T1, T2, T3) "
      "VALUES (LMF_LMR_SUB_IOV_ID_" +
      sp + "_SQ.NextVal, :1, :2, :3, :4)";
  stmt->setSQL(sql);
  stmt->setInt(1, m_lmfIOV);
  for (int i = 0; i < 3; i++) {
    stmt->setDate(i + 2, dh.tmToDate(m_t[i]));
  }
  return sql;
}

Friends And Related Function Documentation

friend class EcalCondDBInterface

friend

Definition at line 15 of file LMFLmrSubIOV.h.

Member Data Documentation

int LMFLmrSubIOV::m_lmfIOV

private

Definition at line 77 of file LMFLmrSubIOV.h.

Referenced by fetchIdSql(), getLMFIOV(), getLMFIOVID(), init(), operator==(), setLMFIOV(), and writeDBSql().

Tm LMFLmrSubIOV::m_t[3]

private

Definition at line 78 of file LMFLmrSubIOV.h.

Referenced by fetchIdSql(), getT1(), getT2(), getT3(), getTime(), getTimes(), init(), operator==(), setTimes(), and writeDBSql().