ODRunConfigInfo Class Reference

#include <ODRunConfigInfo.h>

Inheritance diagram for ODRunConfigInfo:

Public Member Functions
Tm	getDBTime () const
int	getDefaults () const
std::string	getDescription () const
int	getId () const
int	getNumberOfEvents () const
int	getNumberOfSequences () const
RunModeDef	getRunModeDef () const
RunTypeDef	getRunTypeDef () const
std::string	getTable () override
std::string	getTag () const
std::string	getTriggerMode () const
std::string	getUsageStatus () const
int	getVersion () const
	ODRunConfigInfo ()
bool	operator!= (const ODRunConfigInfo &r) const
bool	operator== (const ODRunConfigInfo &r) const
void	setDBTime (const Tm &x)
void	setDefaults (int x)
void	setDescription (std::string x)
void	setId (int id)
void	setNumberOfEvents (int x)
void	setNumberOfSequences (int n)
void	setRunModeDef (const RunModeDef &runModeDef)
void	setRunTypeDef (const RunTypeDef &runTypeDef)
void	setTag (std::string x)
void	setTriggerMode (std::string x)
void	setUsageStatus (std::string x)
void	setVersion (int x)
	~ODRunConfigInfo () override
Public Member Functions inherited from IODConfig
std::string	getConfigTag ()
void	setConfigTag (std::string x)
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
void	clear ()
void	fetchData (ODRunConfigInfo *result) noexcept(false)
int	fetchID () noexcept(false)
int	fetchIDFromTagAndVersion () noexcept(false)
int	fetchIDLast () noexcept(false)
int	fetchNextId () noexcept(false)
void	prepareWrite () noexcept(false) override
void	setByID (int id) noexcept(false)
int	updateDefaultCycle () noexcept(false)
void	writeDB () noexcept(false)

Private Attributes
Tm	m_db_time
int	m_defaults
std::string	m_description
int	m_ID
int	m_num_events
int	m_num_seq
RunModeDef	m_runModeDef
RunTypeDef	m_runTypeDef
std::string	m_tag
std::string	m_trigger_mode
std::string	m_usage_status
int	m_version

Friends
class	EcalCondDBInterface

Additional Inherited Members
Public Types inherited from IODConfig
typedef oracle::occi::Clob	Clob
typedef oracle::occi::SQLException	SQLException
typedef oracle::occi::Statement	Statement
typedef oracle::occi::Stream	Stream
Public Attributes inherited from IODConfig
std::string	m_config_tag
Static Public Attributes inherited from IDBObject
static int const	ECALDB_NROWS = 1024
Protected Member Functions inherited from IODConfig
void	checkPrepare () noexcept(false)
void	createReadStatement () noexcept(false)
void	populateClob (Clob &clob, std::string fname, unsigned int bufsize) noexcept(false)
unsigned char *	readClob (Clob &clob, int size) noexcept(false)
void	setPrefetchRowCount (int ncount) noexcept(false)
void	terminateReadStatement () noexcept(false)
void	terminateWriteStatement () noexcept(false)
Protected Member Functions inherited from IDBObject
void	checkConnection () const noexcept(false)
Protected Attributes inherited from IODConfig
Statement *	m_readStmt
Statement *	m_writeStmt
Protected Attributes inherited from IDBObject
oracle::occi::Connection *	m_conn
oracle::occi::Environment *	m_env

Detailed Description

Definition at line 12 of file ODRunConfigInfo.h.

Constructor & Destructor Documentation

ODRunConfigInfo()

ODRunConfigInfo::ODRunConfigInfo

(

)

Definition at line 11 of file ODRunConfigInfo.cc.

                                 {
  m_env = nullptr;
  m_conn = nullptr;
  m_ID = 0;
  //
  m_tag = "";
  m_version = 0;
  m_num_seq = 0;
  m_runTypeDef = RunTypeDef();
  m_runModeDef = RunModeDef();
  m_defaults = 0;
  m_trigger_mode = "";
  m_num_events = 0;
}

~ODRunConfigInfo()

ODRunConfigInfo::~ODRunConfigInfo ( )

override

Definition at line 26 of file ODRunConfigInfo.cc.

{}

Member Function Documentation

clear()

void ODRunConfigInfo::clear ( void  )

private

Definition at line 260 of file ODRunConfigInfo.cc.

                            {
  m_num_seq = 0;
  m_runTypeDef = RunTypeDef();
  m_runModeDef = RunModeDef();
  m_defaults = 0;
  m_trigger_mode = "";
  m_num_events = 0;
}

fetchData()

void ODRunConfigInfo::fetchData ( ODRunConfigInfo *  result )

privatenoexcept

Definition at line 269 of file ODRunConfigInfo.cc.

References gather_cfg::cout, cuy::dh, MillePedeFileConverter_cfg::e, and mps_fire::result.

                                                                       {
  this->checkConnection();
  DateHandler dh(m_env, m_conn);
  //  result->clear();

  if (result->getId() == 0) {
    //throw(std::runtime_error("FEConfigMainInfo::fetchData(): no Id defined for this FEConfigMainInfo "));
    result->fetchID();
  }
  try {
    m_readStmt->setSQL(
        "SELECT config_id, tag, version, run_type_def_id, run_mode_def_id, \
      num_of_sequences, description, defaults, trg_mode, num_of_events, db_timestamp, usage_status \
      FROM ECAL_RUN_CONFIGURATION_DAT WHERE config_id = :1 ");
    m_readStmt->setInt(1, result->getId());

    ResultSet* rset = m_readStmt->executeQuery();
    rset->next();

    result->setId(rset->getInt(1));
    result->setTag(rset->getString(2));
    result->setVersion(rset->getInt(3));
    //    RunTypeDef myRunType = rset->getInt(4);
    //    result->setRunTypeDef( myRunType );
    //    RunModeDef myRunMode = rset->getInt(5);
    //    result->setRunModeDef( myRunMode );
    result->setNumberOfSequences(rset->getInt(6));
    result->setDescription(rset->getString(7));
    result->setDefaults(rset->getInt(8));
    result->setTriggerMode(rset->getString(9));
    result->setNumberOfEvents(rset->getInt(10));
    Date dbdate = rset->getDate(11);
    result->setDBTime(dh.dateToTm(dbdate));
    result->setUsageStatus(rset->getString(12));

  } catch (SQLException& e) {
    cout << " ODRunConfigInfo::fetchData():  " << e.getMessage() << endl;
    throw(std::runtime_error("ODRunConfigInfo::fetchData():  " + e.getMessage()));
  }
}

fetchID()

int ODRunConfigInfo::fetchID ( )

privatenoexcept

Definition at line 65 of file ODRunConfigInfo.cc.

References cuy::dh, and MillePedeFileConverter_cfg::e.

                                             {
  // Return from memory if available
  if (m_ID > 0) {
    return m_ID;
  }

  this->checkConnection();

  DateHandler dh(m_env, m_conn);

  try {
    Statement* stmt = m_conn->createStatement();
    stmt->setSQL(
        "SELECT config_id from ECAL_RUN_CONFIGURATION_DAT "
        "WHERE tag = :tag "
        " and version = :version ");
    stmt->setString(1, m_tag);
    stmt->setInt(2, m_version);

    ResultSet* rset = stmt->executeQuery();
    if (rset->next()) {
      m_ID = rset->getInt(1);
    } else {
      m_ID = 0;
    }
    m_conn->terminateStatement(stmt);
  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigInfo::fetchID:  " + e.getMessage()));
  }
  setByID(m_ID);
  return m_ID;
}

fetchIDFromTagAndVersion()

int ODRunConfigInfo::fetchIDFromTagAndVersion ( )

privatenoexcept

Definition at line 123 of file ODRunConfigInfo.cc.

                                                              {
  fetchID();
  return m_ID;
}

fetchIDLast()

int ODRunConfigInfo::fetchIDLast ( )

privatenoexcept

Definition at line 98 of file ODRunConfigInfo.cc.

References cuy::dh, and MillePedeFileConverter_cfg::e.

                                                 {
  this->checkConnection();

  DateHandler dh(m_env, m_conn);

  try {
    Statement* stmt = m_conn->createStatement();
    stmt->setSQL("SELECT max(config_id) FROM ecal_run_configuration_dat ");
    ResultSet* rset = stmt->executeQuery();

    if (rset->next()) {
      m_ID = rset->getInt(1);
    } else {
      m_ID = 0;
    }
    m_conn->terminateStatement(stmt);
  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigInfo::fetchIDLast:  " + e.getMessage()));
  }

  setByID(m_ID);
  return m_ID;
}

fetchNextId()

int ODRunConfigInfo::fetchNextId ( )

privatenoexcept

Definition at line 46 of file ODRunConfigInfo.cc.

References MillePedeFileConverter_cfg::e, and mps_fire::result.

                                                 {
  int result = 0;
  try {
    this->checkConnection();

    m_readStmt = m_conn->createStatement();
    m_readStmt->setSQL("select ecal_run_sq.NextVal from dual");
    ResultSet* rset = m_readStmt->executeQuery();
    while (rset->next()) {
      result = rset->getInt(1);
    }
    m_conn->terminateStatement(m_readStmt);
    return result;

  } catch (SQLException& e) {
    throw(std::runtime_error("ODDCCConfig::fetchNextId():  " + e.getMessage()));
  }
}

getDBTime()

Tm ODRunConfigInfo::getDBTime ( ) const

inline

Definition at line 24 of file ODRunConfigInfo.h.

References m_db_time.

{ return m_db_time; }

getDefaults()

int ODRunConfigInfo::getDefaults ( ) const

inline

Definition at line 39 of file ODRunConfigInfo.h.

References m_defaults.

{ return m_defaults; }

getDescription()

std::string ODRunConfigInfo::getDescription ( ) const

inline

Definition at line 30 of file ODRunConfigInfo.h.

References m_description.

{ return m_description; }

getId()

int ODRunConfigInfo::getId ( void  ) const

inline

Definition at line 21 of file ODRunConfigInfo.h.

References m_ID.

Referenced by popcon::EcalSRPHandler::getNewObjects().

{ return m_ID; }

getNumberOfEvents()

int ODRunConfigInfo::getNumberOfEvents ( ) const

inline

Definition at line 45 of file ODRunConfigInfo.h.

References m_num_events.

{ return m_num_events; }

getNumberOfSequences()

int ODRunConfigInfo::getNumberOfSequences ( ) const

inline

Definition at line 36 of file ODRunConfigInfo.h.

References m_num_seq.

{ return m_num_seq; }

getRunModeDef()

RunModeDef ODRunConfigInfo::getRunModeDef

(

)

const

Definition at line 37 of file ODRunConfigInfo.cc.

{ return m_runModeDef; }

getRunTypeDef()

RunTypeDef ODRunConfigInfo::getRunTypeDef

(

)

const

Definition at line 29 of file ODRunConfigInfo.cc.

{ return m_runTypeDef; }

getTable()

std::string ODRunConfigInfo::getTable ( )

inlineoverridevirtual

Implements IODConfig.

Definition at line 18 of file ODRunConfigInfo.h.

{ return "ECAL_RUN_CONFIGURATION_DAT"; }

getTag()

std::string ODRunConfigInfo::getTag ( ) const

inline

Definition at line 27 of file ODRunConfigInfo.h.

References m_tag.

{ return m_tag; }

getTriggerMode()

std::string ODRunConfigInfo::getTriggerMode ( ) const

inline

Definition at line 42 of file ODRunConfigInfo.h.

References m_trigger_mode.

{ return m_trigger_mode; }

getUsageStatus()

std::string ODRunConfigInfo::getUsageStatus ( ) const

inline

Definition at line 48 of file ODRunConfigInfo.h.

References m_usage_status.

{ return m_usage_status; }

getVersion()

int ODRunConfigInfo::getVersion ( ) const

inline

Definition at line 33 of file ODRunConfigInfo.h.

References m_version.

{ return m_version; }

operator!=()

bool ODRunConfigInfo::operator!= ( const ODRunConfigInfo &  r ) const

inline

Definition at line 58 of file ODRunConfigInfo.h.

References alignCSCRings::r.

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

operator==()

bool ODRunConfigInfo::operator== ( const ODRunConfigInfo &  r ) const

inline

Definition at line 57 of file ODRunConfigInfo.h.

References m_ID, and alignCSCRings::r.

{ return (m_ID == r.m_ID); }

prepareWrite()

void ODRunConfigInfo::prepareWrite ( )

overrideprivatevirtualnoexcept

Implements IODConfig.

Definition at line 170 of file ODRunConfigInfo.cc.

References MillePedeFileConverter_cfg::e.

                                                   {
  this->checkConnection();

  int next_id = fetchNextId();

  try {
    m_writeStmt = m_conn->createStatement();
    m_writeStmt->setSQL(
        "INSERT INTO ECAL_RUN_CONFIGURATION_DAT (CONFIG_ID, tag, version, run_type_def_id, "
        " run_mode_def_id, num_of_sequences, defaults, trg_mode, num_of_events, description, usage_status ) "
        " VALUES (:1, :2, :3 , :4, :5, :6 ,:7, :8, :9, :10 , :11)");

    m_writeStmt->setInt(1, next_id);
    m_ID = next_id;

  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigInfo::prepareWrite():  " + e.getMessage()));
  }
}

setByID()

void ODRunConfigInfo::setByID ( int  id )

privatenoexcept

Definition at line 128 of file ODRunConfigInfo.cc.

References cuy::dh, MillePedeFileConverter_cfg::e, and triggerObjects_cff::id.

                                                    {
  this->checkConnection();

  DateHandler dh(m_env, m_conn);

  try {
    Statement* stmt = m_conn->createStatement();

    stmt->setSQL(
        "SELECT tag, version, run_type_def_id, run_mode_def_id, num_of_sequences, description, defaults,"
        " trg_mode,num_of_events, db_timestamp, usage_status"
        " FROM ECAL_RUN_CONFIGURATION_DAT WHERE config_id = :1");
    stmt->setInt(1, id);

    ResultSet* rset = stmt->executeQuery();
    if (rset->next()) {
      m_tag = rset->getString(1);
      m_version = rset->getInt(2);
      int run_type_id = rset->getInt(3);
      int run_mode_id = rset->getInt(4);
      m_num_seq = rset->getInt(5);
      m_description = rset->getString(6);
      m_defaults = rset->getInt(7);
      m_trigger_mode = rset->getString(8);
      m_num_events = rset->getInt(9);
      Date dbdate = rset->getDate(10);
      m_db_time = dh.dateToTm(dbdate);
      m_ID = id;
      m_runModeDef.setConnection(m_env, m_conn);
      m_runModeDef.setByID(run_mode_id);
      m_runTypeDef.setConnection(m_env, m_conn);
      m_runTypeDef.setByID(run_type_id);
      m_usage_status = rset->getString(11);
    } else {
      throw(std::runtime_error("ODRunConfigInfo::setByID:  Given config_id is not in the database"));
    }
    m_conn->terminateStatement(stmt);
  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigInfo::setByID:  " + e.getMessage()));
  }
}

setDBTime()

void ODRunConfigInfo::setDBTime ( const Tm &  x )

inline

Definition at line 23 of file ODRunConfigInfo.h.

References m_db_time, and x.

{ m_db_time = x; }

setDefaults()

void ODRunConfigInfo::setDefaults ( int  x )

inline

Definition at line 38 of file ODRunConfigInfo.h.

References m_defaults, and x.

{ m_defaults = x; }

setDescription()

void ODRunConfigInfo::setDescription ( std::string  x )

inline

Definition at line 29 of file ODRunConfigInfo.h.

References m_description, and x.

{ m_description = x; }

setId()

void ODRunConfigInfo::setId ( int  id )

inline

Definition at line 20 of file ODRunConfigInfo.h.

References triggerObjects_cff::id, and m_ID.

{ m_ID = id; }

setNumberOfEvents()

void ODRunConfigInfo::setNumberOfEvents ( int  x )

inline

Definition at line 44 of file ODRunConfigInfo.h.

References m_num_events, and x.

{ m_num_events = x; }

setNumberOfSequences()

void ODRunConfigInfo::setNumberOfSequences ( int  n )

inline

Definition at line 35 of file ODRunConfigInfo.h.

References m_num_seq, and dqmiodumpmetadata::n.

{ m_num_seq = n; }

setRunModeDef()

void ODRunConfigInfo::setRunModeDef

(

const RunModeDef &

runModeDef

)

Definition at line 38 of file ODRunConfigInfo.cc.

                                                                {
  if (runModeDef != m_runModeDef) {
    m_ID = 0;
    m_runModeDef = runModeDef;
  }
}

setRunTypeDef()

void ODRunConfigInfo::setRunTypeDef

(

const RunTypeDef &

runTypeDef

)

Definition at line 30 of file ODRunConfigInfo.cc.

                                                                {
  if (runTypeDef != m_runTypeDef) {
    m_ID = 0;
    m_runTypeDef = runTypeDef;
  }
}

setTag()

void ODRunConfigInfo::setTag ( std::string  x )

inline

Definition at line 26 of file ODRunConfigInfo.h.

References m_tag, and x.

Referenced by popcon::EcalSRPHandler::getNewObjects().

{ m_tag = x; }

setTriggerMode()

void ODRunConfigInfo::setTriggerMode ( std::string  x )

inline

Definition at line 41 of file ODRunConfigInfo.h.

References m_trigger_mode, and x.

{ m_trigger_mode = x; }

setUsageStatus()

void ODRunConfigInfo::setUsageStatus ( std::string  x )

inline

Definition at line 47 of file ODRunConfigInfo.h.

References m_usage_status, and x.

{ m_usage_status = x; }

setVersion()

void ODRunConfigInfo::setVersion ( int  x )

inline

Definition at line 32 of file ODRunConfigInfo.h.

References m_version, and x.

Referenced by popcon::EcalSRPHandler::getNewObjects().

{ m_version = x; }

updateDefaultCycle()

int ODRunConfigInfo::updateDefaultCycle ( )

privatenoexcept

Definition at line 234 of file ODRunConfigInfo.cc.

References MillePedeFileConverter_cfg::e, and dtFineDelayCorr_cfi::writeDB.

                                                        {
  this->checkConnection();

  // Check if this has already been written
  if (!this->fetchID()) {
    this->writeDB();
  }

  try {
    Statement* stmt = m_conn->createStatement();

    stmt->setSQL("UPDATE ecal_run_configuration_dat set defaults=:1 where config_id=:2 ");

    stmt->setInt(1, m_defaults);
    stmt->setInt(2, m_ID);

    stmt->executeUpdate();

    m_conn->terminateStatement(stmt);
  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigInfo::writeDB:  " + e.getMessage()));
  }

  return m_ID;
}

writeDB()

void ODRunConfigInfo::writeDB ( )

privatenoexcept

Definition at line 190 of file ODRunConfigInfo.cc.

References gather_cfg::cout, cuy::dh, and MillePedeFileConverter_cfg::e.

                                              {
  this->checkConnection();
  this->checkPrepare();

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

  try {
    // get the run mode
    m_runModeDef.setConnection(m_env, m_conn);
    int run_mode_id = m_runModeDef.fetchID();

    // get the run type
    m_runTypeDef.setConnection(m_env, m_conn);
    int run_type_id = m_runTypeDef.fetchID();

    // now insert

    m_writeStmt->setString(2, this->getTag());
    m_writeStmt->setInt(3, this->getVersion());
    m_writeStmt->setInt(4, run_type_id);
    m_writeStmt->setInt(5, run_mode_id);
    m_writeStmt->setInt(6, this->getNumberOfSequences());
    m_writeStmt->setInt(7, this->getDefaults());
    m_writeStmt->setString(8, this->getTriggerMode());
    m_writeStmt->setInt(9, this->getNumberOfEvents());
    m_writeStmt->setString(10, this->getDescription());
    m_writeStmt->setString(11, this->getUsageStatus());

    m_writeStmt->executeUpdate();

  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigInfo::writeDB:  " + e.getMessage()));
  }
  // Now get the ID
  if (!this->fetchID()) {
    throw(std::runtime_error("ODRunConfigInfo::writeDB  Failed to write"));
  }

  this->setByID(m_ID);

  cout << "ODRunConfigInfo::writeDB>> done inserting ODRunConfigInfo with id=" << m_ID << endl;
}

Friends And Related Function Documentation

EcalCondDBInterface

friend class EcalCondDBInterface

friend

Definition at line 14 of file ODRunConfigInfo.h.

Member Data Documentation

m_db_time

Tm ODRunConfigInfo::m_db_time

private

Definition at line 63 of file ODRunConfigInfo.h.

Referenced by getDBTime(), and setDBTime().

m_defaults

int ODRunConfigInfo::m_defaults

private

Definition at line 70 of file ODRunConfigInfo.h.

Referenced by getDefaults(), and setDefaults().

m_description

std::string ODRunConfigInfo::m_description

private

Definition at line 69 of file ODRunConfigInfo.h.

Referenced by getDescription(), and setDescription().

m_ID

int ODRunConfigInfo::m_ID

private

Definition at line 62 of file ODRunConfigInfo.h.

Referenced by getId(), operator==(), and setId().

m_num_events

int ODRunConfigInfo::m_num_events

private

Definition at line 72 of file ODRunConfigInfo.h.

Referenced by getNumberOfEvents(), and setNumberOfEvents().

m_num_seq

int ODRunConfigInfo::m_num_seq

private

Definition at line 68 of file ODRunConfigInfo.h.

Referenced by getNumberOfSequences(), and setNumberOfSequences().

m_runModeDef

RunModeDef ODRunConfigInfo::m_runModeDef

private

Definition at line 66 of file ODRunConfigInfo.h.

m_runTypeDef

RunTypeDef ODRunConfigInfo::m_runTypeDef

private

Definition at line 67 of file ODRunConfigInfo.h.

m_tag

std::string ODRunConfigInfo::m_tag

private

Definition at line 64 of file ODRunConfigInfo.h.

Referenced by getTag(), and setTag().

m_trigger_mode

std::string ODRunConfigInfo::m_trigger_mode

private

Definition at line 71 of file ODRunConfigInfo.h.

Referenced by getTriggerMode(), and setTriggerMode().

m_usage_status

std::string ODRunConfigInfo::m_usage_status

private

Definition at line 73 of file ODRunConfigInfo.h.

Referenced by getUsageStatus(), and setUsageStatus().

m_version

int ODRunConfigInfo::m_version

private

Definition at line 65 of file ODRunConfigInfo.h.

Referenced by getVersion(), and setVersion().