ODRunConfigSeqInfo Class Reference

#include <ODRunConfigSeqInfo.h>

Inheritance diagram for ODRunConfigSeqInfo:

Public Member Functions
std::string	getDescription () const
int	getEcalConfigId () const
int	getId () const
int	getNumberOfCycles () const
RunSeqDef	getRunSeqDef () const
int	getSequenceId () const
int	getSequenceNumber () const
std::string	getTable () override
	ODRunConfigSeqInfo ()
bool	operator!= (const ODRunConfigSeqInfo &r) const
bool	operator== (const ODRunConfigSeqInfo &r) const
void	setDescription (std::string x)
void	setEcalConfigId (int x)
void	setId (int id)
void	setNumberOfCycles (int x)
void	setRunSeqDef (const RunSeqDef &runSeqDef)
void	setSequenceId (int x)
void	setSequenceNumber (int x)
	~ODRunConfigSeqInfo () 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 (ODRunConfigSeqInfo *result) noexcept(false)
int	fetchID () noexcept(false)
int	fetchIDLast () noexcept(false)
void	prepareWrite () noexcept(false) override
void	setByID (int id) noexcept(false)
void	writeDB () noexcept(false)

Private Attributes
int	m_cycles
std::string	m_description
int	m_ecal_config_id
int	m_ID
RunSeqDef	m_run_seq
int	m_seq_num
int	m_sequence_id

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 15 of file ODRunConfigSeqInfo.h.

Constructor & Destructor Documentation

ODRunConfigSeqInfo()

ODRunConfigSeqInfo::ODRunConfigSeqInfo

(

)

Definition at line 11 of file ODRunConfigSeqInfo.cc.

                                       {
  m_env = nullptr;
  m_conn = nullptr;
  m_writeStmt = nullptr;
  m_readStmt = nullptr;

  m_ID = 0;
  //
  m_ecal_config_id = 0;
  m_seq_num = 0;
  m_cycles = 0;
  m_run_seq = RunSeqDef();
  m_description = "";
}

~ODRunConfigSeqInfo()

ODRunConfigSeqInfo::~ODRunConfigSeqInfo ( )

override

Definition at line 26 of file ODRunConfigSeqInfo.cc.

{}

Member Function Documentation

clear()

void ODRunConfigSeqInfo::clear ( void  )

private

Definition at line 172 of file ODRunConfigSeqInfo.cc.

                               {
  //  m_ecal_config_id =0;
  //  m_seq_num =0;
  m_ID = 0;
  m_cycles = 0;
  m_run_seq = RunSeqDef();
  m_description = "";
}

fetchData()

void ODRunConfigSeqInfo::fetchData ( ODRunConfigSeqInfo *  result )

privatenoexcept

Definition at line 181 of file ODRunConfigSeqInfo.cc.

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

                                                                             {
  this->checkConnection();
  //  result->clear();
  if (result->getId() == 0) {
    //    throw(std::runtime_error("ODRunConfigSeqInfo::fetchData(): no Id defined for this record "));
    result->fetchID();
  }

  try {
    m_readStmt->setSQL(
        "SELECT ecal_config_id, sequence_num, num_of_cycles, "
        "sequence_type_def_id, description FROM ECAL_sequence_DAT WHERE sequence_id = :1 ");

    m_readStmt->setInt(1, result->getId());
    ResultSet* rset = m_readStmt->executeQuery();

    rset->next();

    result->setEcalConfigId(rset->getInt(1));
    result->setSequenceNumber(rset->getInt(2));
    result->setNumberOfCycles(rset->getInt(3));
    int seq_def_id = rset->getInt(4);

    m_run_seq.setConnection(m_env, m_conn);
    m_run_seq.setByID(seq_def_id);
    result->setDescription(rset->getString(5));

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

fetchID()

int ODRunConfigSeqInfo::fetchID ( )

privatenoexcept

Definition at line 37 of file ODRunConfigSeqInfo.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 sequence_id from ECAL_sequence_DAT "
        "WHERE ecal_config_id = :id1 "
        " and sequence_num = :id2  ");
    stmt->setInt(1, m_ecal_config_id);
    stmt->setInt(2, m_seq_num);

    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("ODRunConfigSeqInfo::fetchID:  " + e.getMessage()));
  }
  setByID(m_ID);
  return m_ID;
}

fetchIDLast()

int ODRunConfigSeqInfo::fetchIDLast ( )

privatenoexcept

Definition at line 71 of file ODRunConfigSeqInfo.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(sequence_id) FROM ecal_sequence_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("ODRunConfigSeqInfo::fetchIDLast:  " + e.getMessage()));
  }

  setByID(m_ID);
  return m_ID;
}

getDescription()

std::string ODRunConfigSeqInfo::getDescription ( ) const

inline

Definition at line 30 of file ODRunConfigSeqInfo.h.

References m_description.

{ return m_description; }

getEcalConfigId()

int ODRunConfigSeqInfo::getEcalConfigId ( ) const

inline

Definition at line 32 of file ODRunConfigSeqInfo.h.

References m_ecal_config_id.

{ return m_ecal_config_id; }

getId()

int ODRunConfigSeqInfo::getId ( void  ) const

inline

Definition at line 27 of file ODRunConfigSeqInfo.h.

References m_ID.

{ return m_ID; }

getNumberOfCycles()

int ODRunConfigSeqInfo::getNumberOfCycles ( ) const

inline

Definition at line 36 of file ODRunConfigSeqInfo.h.

References m_cycles.

{ return m_cycles; }

getRunSeqDef()

RunSeqDef ODRunConfigSeqInfo::getRunSeqDef

(

)

const

Definition at line 29 of file ODRunConfigSeqInfo.cc.

{ return m_run_seq; }

getSequenceId()

int ODRunConfigSeqInfo::getSequenceId ( ) const

inline

Definition at line 35 of file ODRunConfigSeqInfo.h.

References m_ID.

{ return m_ID; }

getSequenceNumber()

int ODRunConfigSeqInfo::getSequenceNumber ( ) const

inline

Definition at line 38 of file ODRunConfigSeqInfo.h.

References m_seq_num.

{ return m_seq_num; }

getTable()

std::string ODRunConfigSeqInfo::getTable ( )

inlineoverridevirtual

Implements IODConfig.

Definition at line 22 of file ODRunConfigSeqInfo.h.

{ return "ECAL_SEQUENCE_DAT"; }

operator!=()

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

inline

Definition at line 45 of file ODRunConfigSeqInfo.h.

References alignCSCRings::r.

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

operator==()

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

inline

Definition at line 44 of file ODRunConfigSeqInfo.h.

References m_ID, and alignCSCRings::r.

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

prepareWrite()

void ODRunConfigSeqInfo::prepareWrite ( )

overrideprivatevirtualnoexcept

Implements IODConfig.

Definition at line 129 of file ODRunConfigSeqInfo.cc.

References MillePedeFileConverter_cfg::e.

                                                      {
  this->checkConnection();

  try {
    m_writeStmt = m_conn->createStatement();
    m_writeStmt->setSQL(
        "INSERT INTO ECAL_SEQUENCE_DAT ( ecal_config_id, "
        "sequence_num, num_of_cycles, sequence_type_def_id, description ) "
        "VALUES (:1, :2, :3 , :4, :5 )");
  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigSeqInfo::prepareWrite():  " + e.getMessage()));
  }
}

setByID()

void ODRunConfigSeqInfo::setByID ( int  id )

privatenoexcept

Definition at line 95 of file ODRunConfigSeqInfo.cc.

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

                                                       {
  this->checkConnection();

  DateHandler dh(m_env, m_conn);

  cout << "ODRunConfigSeqInfo::setByID called for id " << id << endl;

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

    stmt->setSQL(
        "SELECT ecal_config_id, sequence_num, num_of_cycles, sequence_type_def_id, description FROM ECAL_sequence_DAT "
        "WHERE sequence_id = :1 ");
    stmt->setInt(1, id);

    ResultSet* rset = stmt->executeQuery();
    if (rset->next()) {
      m_ecal_config_id = rset->getInt(1);
      m_seq_num = rset->getInt(2);
      m_cycles = rset->getInt(3);
      int seq_def_id = rset->getInt(4);
      m_description = rset->getString(5);
      m_ID = id;
      m_run_seq.setConnection(m_env, m_conn);
      m_run_seq.setByID(seq_def_id);
    } else {
      throw(std::runtime_error("ODRunConfigSeqInfo::setByID:  Given config_id is not in the database"));
    }
    m_conn->terminateStatement(stmt);
  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigSeqInfo::setByID:  " + e.getMessage()));
  }
}

setDescription()

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

inline

Definition at line 29 of file ODRunConfigSeqInfo.h.

References m_description, and x.

{ m_description = x; }

setEcalConfigId()

void ODRunConfigSeqInfo::setEcalConfigId ( int  x )

inline

Definition at line 31 of file ODRunConfigSeqInfo.h.

References m_ecal_config_id, and x.

{ m_ecal_config_id = x; }

setId()

void ODRunConfigSeqInfo::setId ( int  id )

inline

Definition at line 26 of file ODRunConfigSeqInfo.h.

References EcalPhiSymFlatTableProducers_cfi::id, and m_ID.

{ m_ID = id; }

setNumberOfCycles()

void ODRunConfigSeqInfo::setNumberOfCycles ( int  x )

inline

Definition at line 33 of file ODRunConfigSeqInfo.h.

References m_cycles, and x.

{ m_cycles = x; }

setRunSeqDef()

void ODRunConfigSeqInfo::setRunSeqDef

(

const RunSeqDef &

runSeqDef

)

Definition at line 30 of file ODRunConfigSeqInfo.cc.

                                                              {
  if (run_seq != m_run_seq) {
    m_run_seq = run_seq;
  }
}

setSequenceId()

void ODRunConfigSeqInfo::setSequenceId ( int  x )

inline

Definition at line 34 of file ODRunConfigSeqInfo.h.

References m_ID, and x.

{ m_ID = x; }

setSequenceNumber()

void ODRunConfigSeqInfo::setSequenceNumber ( int  x )

inline

Definition at line 37 of file ODRunConfigSeqInfo.h.

References m_seq_num, and x.

{ m_seq_num = x; }

writeDB()

void ODRunConfigSeqInfo::writeDB ( )

privatenoexcept

Definition at line 142 of file ODRunConfigSeqInfo.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_run_seq.setConnection(m_env, m_conn);
    int seq_def_id = m_run_seq.writeDB();

    m_writeStmt->setInt(1, this->getEcalConfigId());
    m_writeStmt->setInt(2, this->getSequenceNumber());
    m_writeStmt->setInt(3, this->getNumberOfCycles());
    m_writeStmt->setInt(4, seq_def_id);
    m_writeStmt->setString(5, this->getDescription());

    m_writeStmt->executeUpdate();

  } catch (SQLException& e) {
    throw(std::runtime_error("ODRunConfigSeqInfo::writeDB():  " + e.getMessage()));
  }
  if (!this->fetchID()) {
    throw(std::runtime_error("ODRunConfigSeqInfo::writeDB:  Failed to write"));
  }
  cout << "ODRunConfigSeqInfo::writeDB>> done inserting ODRunConfigSeqInfo with id=" << m_ID << endl;
}

Friends And Related Function Documentation

EcalCondDBInterface

friend class EcalCondDBInterface

friend

Definition at line 17 of file ODRunConfigSeqInfo.h.

Member Data Documentation

m_cycles

int ODRunConfigSeqInfo::m_cycles

private

Definition at line 52 of file ODRunConfigSeqInfo.h.

Referenced by getNumberOfCycles(), and setNumberOfCycles().

m_description

std::string ODRunConfigSeqInfo::m_description

private

Definition at line 54 of file ODRunConfigSeqInfo.h.

Referenced by getDescription(), and setDescription().

m_ecal_config_id

int ODRunConfigSeqInfo::m_ecal_config_id

private

Definition at line 49 of file ODRunConfigSeqInfo.h.

Referenced by getEcalConfigId(), and setEcalConfigId().

m_ID

int ODRunConfigSeqInfo::m_ID

private

Definition at line 48 of file ODRunConfigSeqInfo.h.

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

m_run_seq

RunSeqDef ODRunConfigSeqInfo::m_run_seq

private

Definition at line 53 of file ODRunConfigSeqInfo.h.

m_seq_num

int ODRunConfigSeqInfo::m_seq_num

private

Definition at line 50 of file ODRunConfigSeqInfo.h.

Referenced by getSequenceNumber(), and setSequenceNumber().

m_sequence_id

int ODRunConfigSeqInfo::m_sequence_id

private

Definition at line 51 of file ODRunConfigSeqInfo.h.