#include <ODEcalCycle.h>

Inheritance diagram for ODEcalCycle:

Public Member Functions
int	getCCSId () const
std::string	getCycleDescription () const
int	getCycleNum () const
std::string	getCycleTag () const
int	getDCCId () const
int	getDCUId () const
int	getId () const
int	getJBH4Id () const
int	getLaserId () const
int	getLTCId () const
int	getLTSId () const
int	getMataqId () const
int	getScanId () const
int	getSeqNum () const
int	getSequenceId () const
int	getSRPId () const
std::string	getTable ()
std::string	getTag () const
int	getTCCEEId () const
int	getTCCId () const
int	getTTCCIId () const
int	getTTCFId () const
int	getVersion () const
	ODEcalCycle ()
void	printout ()
void	setCCSId (int x)
void	setCycleDescription (std::string x)
void	setCycleNum (int x)
void	setCycleTag (std::string x)
void	setDCCId (int x)
void	setDCUId (int x)
void	setId (int id)
void	setJBH4Id (int x)
void	setLaserId (int x)
void	setLTCId (int x)
void	setLTSId (int x)
void	setMataqId (int x)
void	setScanId (int x)
void	setSeqNum (int x)
void	setSequenceId (int x)
void	setSRPId (int x)
void	setTag (std::string x)
void	setTCCEEId (int x)
void	setTCCId (int x)
void	setTTCCIId (int x)
void	setTTCFId (int x)
void	setVersion (int x)
	~ODEcalCycle ()
Private Member Functions
void	clear ()
void	fetchData (ODEcalCycle *result) throw (std::runtime_error)
int	fetchID () throw (std::runtime_error)
void	prepareWrite () throw (std::runtime_error)
void	setByID (int id) throw (std::runtime_error)
void	writeDB () throw (std::runtime_error)
Private Attributes
int	m_ccs
std::string	m_cycle_description
int	m_cycle_num
std::string	m_cycle_tag
int	m_dcc
int	m_dcu
int	m_ID
int	m_jbh4
int	m_laser
int	m_ltc
int	m_lts
int	m_mataq
int	m_scan
int	m_seq_id
int	m_seq_num
int	m_srp
std::string	m_tag
int	m_tcc
int	m_tcc_ee
int	m_ttcci
int	m_ttcf
int	m_version
Friends
class	EcalCondDBInterface

Detailed Description

Definition at line 9 of file ODEcalCycle.h.

Constructor & Destructor Documentation

ODEcalCycle::ODEcalCycle ( )

Definition at line 25 of file ODEcalCycle.cc.

References NULL.

{
  m_env = NULL;
  m_conn = NULL;
  m_writeStmt = NULL;
  m_readStmt = NULL;

   m_ID=0;
   clear();
}

ODEcalCycle::~ODEcalCycle ( )

Definition at line 38 of file ODEcalCycle.cc.

{
}

Member Function Documentation

void ODEcalCycle::clear ( void ) [private]

Definition at line 179 of file ODEcalCycle.cc.

                       {
   m_tag="";
   m_version=0;
   m_seq_num=0;
   m_cycle_num=0;
   m_cycle_tag="";
   m_cycle_description="";
   m_ccs=0;
   m_dcc=0;
   m_laser=0;
   m_ltc=0;
   m_lts=0;
   m_dcu=0;
   m_tcc=0;
   m_tcc_ee=0;
   m_ttcci=0;
   m_jbh4=0;
   m_scan=0;
   //   m_seq_id=0;
   m_ttcf=0;
   m_srp=0;
}

void ODEcalCycle::fetchData ( ODEcalCycle * result ) throw (std::runtime_error) [private]

Definition at line 308 of file ODEcalCycle.cc.

References query::result.

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

  try {

    m_readStmt->setSQL("SELECT tag, version, sequence_num, cycle_num, cycle_tag, description, "
                     "ccs_configuration_id, dcc_configuration_id, laser_configuration_id, "
                     "ltc_configuration_id, lts_configuration_id, tcc_configuration_id, "
                     "\"TTCci_CONFIGURATION_ID\", jbh4_configuration_id, scan_id, TTCF_configuration_id, "
                     "srp_configuration_id, dcu_configuration_id, tcc_ee_configuration_id "
                     "FROM ECAL_CYCLE where cycle_id = :1 " );
    m_readStmt->setInt(1, result->getId());
    ResultSet* rset = m_readStmt->executeQuery();

    rset->next();

    result->setTag(          rset->getString(1) );
    result->setVersion(      rset->getInt(2) );
    result->setSeqNum(       rset->getInt(3) );
    result->setCycleNum(     rset->getInt(4) );
    result->setCycleTag(     rset->getString(5) );
    result->setCycleDescription( rset->getString(6) );
    result->setCCSId(        rset->getInt(7) );
    result->setDCCId(        rset->getInt(8) );
    result->setLaserId(      rset->getInt(9) );
    result->setLTCId(        rset->getInt(10) );
    result->setLTSId(        rset->getInt(11) );
    result->setTCCId(        rset->getInt(12) );
    result->setTTCCIId(        rset->getInt(13) );

   
    result->setJBH4Id(        rset->getInt(14) );
    result->setScanId(        rset->getInt(15) );

    result->setTTCFId(        rset->getInt(16) );
    result->setSRPId(        rset->getInt(17) );
    result->setDCUId(        rset->getInt(18) );
    result->setTCCEEId(      rset->getInt(19) );

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

int ODEcalCycle::fetchID ( ) throw (std::runtime_error) [private]

Definition at line 202 of file ODEcalCycle.cc.

{
  // 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 cycle_id from ECAL_CYCLE_DAT "
               "WHERE sequence_id = :1 ");
    stmt->setInt(1, m_seq_id);

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

int ODEcalCycle::getCCSId ( ) const [inline]

Definition at line 38 of file ODEcalCycle.h.

References m_ccs.

{ return m_ccs; }

std::string ODEcalCycle::getCycleDescription ( ) const [inline]

Definition at line 36 of file ODEcalCycle.h.

References m_cycle_description.

{ return m_cycle_description; }

int ODEcalCycle::getCycleNum ( ) const [inline]

Definition at line 32 of file ODEcalCycle.h.

References m_cycle_num.

{ return m_cycle_num; }

std::string ODEcalCycle::getCycleTag ( ) const [inline]

Definition at line 34 of file ODEcalCycle.h.

References m_cycle_tag.

{ return m_cycle_tag; }

int ODEcalCycle::getDCCId ( ) const [inline]

Definition at line 40 of file ODEcalCycle.h.

References m_dcc.

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

{ return m_dcc; }

int ODEcalCycle::getDCUId ( ) const [inline]

Definition at line 48 of file ODEcalCycle.h.

References m_dcu.

{ return m_dcu; }

int ODEcalCycle::getId ( ) const [inline]

Definition at line 20 of file ODEcalCycle.h.

References m_ID.

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

{ return m_ID; }

int ODEcalCycle::getJBH4Id ( ) const [inline]

Definition at line 58 of file ODEcalCycle.h.

References m_jbh4.

{ return m_jbh4; }

int ODEcalCycle::getLaserId ( ) const [inline]

Definition at line 42 of file ODEcalCycle.h.

References m_laser.

{ return m_laser; }

int ODEcalCycle::getLTCId ( ) const [inline]

Definition at line 44 of file ODEcalCycle.h.

References m_ltc.

{ return m_ltc; }

int ODEcalCycle::getLTSId ( ) const [inline]

Definition at line 46 of file ODEcalCycle.h.

References m_lts.

{ return m_lts; }

int ODEcalCycle::getMataqId ( ) const [inline]

Definition at line 56 of file ODEcalCycle.h.

References m_mataq.

{ return m_mataq; }

int ODEcalCycle::getScanId ( ) const [inline]

Definition at line 60 of file ODEcalCycle.h.

References m_scan.

{ return m_scan; }

int ODEcalCycle::getSeqNum ( ) const [inline]

Definition at line 26 of file ODEcalCycle.h.

References m_seq_num.

{ return m_seq_num; }

int ODEcalCycle::getSequenceId ( ) const [inline]

Definition at line 29 of file ODEcalCycle.h.

References m_seq_id.

{ return m_seq_id; }

int ODEcalCycle::getSRPId ( ) const [inline]

Definition at line 64 of file ODEcalCycle.h.

References m_srp.

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

{ return m_srp; }

std::string ODEcalCycle::getTable ( ) [inline, virtual]

Implements IODConfig.

Definition at line 17 of file ODEcalCycle.h.

{ return "ECAL_CYCLE"; }

std::string ODEcalCycle::getTag ( void ) const [inline]

Definition at line 22 of file ODEcalCycle.h.

References m_tag.

{ return m_tag; }

int ODEcalCycle::getTCCEEId ( ) const [inline]

Definition at line 52 of file ODEcalCycle.h.

References m_tcc_ee.

{ return m_tcc_ee; }

int ODEcalCycle::getTCCId ( ) const [inline]

Definition at line 50 of file ODEcalCycle.h.

References m_tcc.

{ return m_tcc; }

int ODEcalCycle::getTTCCIId ( ) const [inline]

Definition at line 54 of file ODEcalCycle.h.

References m_ttcci.

{ return m_ttcci; }

int ODEcalCycle::getTTCFId ( ) const [inline]

Definition at line 62 of file ODEcalCycle.h.

References m_ttcf.

{ return m_ttcf; }

int ODEcalCycle::getVersion ( ) const [inline]

Definition at line 24 of file ODEcalCycle.h.

References m_version.

{ return m_version; }

void ODEcalCycle::prepareWrite ( ) throw (std::runtime_error) [private, virtual]

Implements IODConfig.

Definition at line 44 of file ODEcalCycle.cc.

References gather_cfg::cout.

{

  std::cout<< "ODEcalCycle::prepareWrite(): this is a view writing specific tables  "<< endl;

}

void ODEcalCycle::printout ( )

Definition at line 286 of file ODEcalCycle.cc.

References gather_cfg::cout.

                          {

  std::cout << "**** ODEcalCycle ****"<< std::endl;
  std::cout << "**** id: "<< m_ID << std::endl;
  std::cout << "**** tag: "<< m_tag << std::endl;
  std::cout << "**** version: "<< m_version << std::endl;
  std::cout << "**** seq_num: "<< m_seq_num << std::endl;
  std::cout << "**** cycle num: "<< m_cycle_num << std::endl;
  std::cout << "**** cycle tag: "<< m_cycle_tag << std::endl;
  std::cout << "**** cycle description: "<< m_cycle_description<< std::endl;
  std::cout << "**** ccs_id: "<< m_ccs <<std::endl;
  std::cout << "**** dcc_id: "<< m_dcc <<std::endl;
  std::cout << "**** laser: "<< m_laser << std::endl;
  std::cout << "**** ttcf_id: "<< m_ttcf << std::endl;
  std::cout << "**** srp_id: "<< m_srp << std::endl;
  std::cout << "**** scan_id: "<< m_scan << std::endl;
  std::cout << "**** ODEcalCycle ****"<< std::endl;
 
 
}

void ODEcalCycle::setByID ( int id ) throw (std::runtime_error) [private]

Definition at line 236 of file ODEcalCycle.cc.

{
   this->checkConnection();

   DateHandler dh(m_env, m_conn);

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

     stmt->setSQL("SELECT tag, version, sequence_num, cycle_num, cycle_tag, description, "
                     "ccs_configuration_id, dcc_configuration_id, laser_configuration_id, "
                     "ltc_configuration_id, lts_configuration_id, tcc_configuration_id, "
                     "\"TTCci_CONFIGURATION_ID\", jbh4_configuration_id, scan_id, TTCF_configuration_id, "
                     "srp_configuration_id, dcu_configuration_id, tcc_ee_configuration_id "
                     "FROM ECAL_CYCLE where cycle_id = :1 " );
     stmt->setInt(1, id);

     ResultSet* rset = stmt->executeQuery();
     if (rset->next()) {
       m_tag = rset->getString(1);
       m_version = rset->getInt(2);
       m_seq_num = rset->getInt(3);
       m_cycle_num = rset->getInt(4);
       m_cycle_tag = rset->getString(5);
       m_cycle_description = rset->getString(6);
       m_ccs = rset->getInt(7);
       m_dcc = rset->getInt(8);
       m_laser = rset->getInt(9);
       m_ltc = rset->getInt(10);
       m_lts = rset->getInt(11);
       m_tcc = rset->getInt(12);
       m_ttcci = rset->getInt(13);
       m_jbh4 = rset->getInt(14);
       m_scan = rset->getInt(15);
       m_ttcf = rset->getInt(16);
       m_srp = rset->getInt(17);
       m_dcu = rset->getInt(18);
       m_tcc_ee = rset->getInt(19);

     } else {
       throw(std::runtime_error("ODEcalCycle::setByID:  Given config_id is not in the database"));
     }
     m_conn->terminateStatement(stmt);
   } catch (SQLException &e) {
     throw(std::runtime_error("ODEcalCycle::setByID:  "+e.getMessage()));
   }
}

void ODEcalCycle::setCCSId ( int x ) [inline]

Definition at line 37 of file ODEcalCycle.h.

References m_ccs, and x.

{ m_ccs = x; }

void ODEcalCycle::setCycleDescription ( std::string x ) [inline]

Definition at line 35 of file ODEcalCycle.h.

References m_cycle_description, and x.

{ m_cycle_description = x; }

void ODEcalCycle::setCycleNum ( int x ) [inline]

Definition at line 31 of file ODEcalCycle.h.

References m_cycle_num, and x.

{ m_cycle_num = x; }

void ODEcalCycle::setCycleTag ( std::string x ) [inline]

Definition at line 33 of file ODEcalCycle.h.

References m_cycle_tag, and x.

{ m_cycle_tag = x; }

void ODEcalCycle::setDCCId ( int x ) [inline]

Definition at line 39 of file ODEcalCycle.h.

References m_dcc, and x.

{ m_dcc = x; }

void ODEcalCycle::setDCUId ( int x ) [inline]

Definition at line 47 of file ODEcalCycle.h.

References m_dcu, and x.

{ m_dcu = x; }

void ODEcalCycle::setId ( int id ) [inline]

Definition at line 19 of file ODEcalCycle.h.

References m_ID.

{ m_ID = id; }

void ODEcalCycle::setJBH4Id ( int x ) [inline]

Definition at line 57 of file ODEcalCycle.h.

References m_jbh4, and x.

{ m_jbh4 = x; }

void ODEcalCycle::setLaserId ( int x ) [inline]

Definition at line 41 of file ODEcalCycle.h.

References m_laser, and x.

{ m_laser = x; }

void ODEcalCycle::setLTCId ( int x ) [inline]

Definition at line 43 of file ODEcalCycle.h.

References m_ltc, and x.

{ m_ltc = x; }

void ODEcalCycle::setLTSId ( int x ) [inline]

Definition at line 45 of file ODEcalCycle.h.

References m_lts, and x.

{ m_lts = x; }

void ODEcalCycle::setMataqId ( int x ) [inline]

Definition at line 55 of file ODEcalCycle.h.

References m_mataq, and x.

{ m_mataq = x; }

void ODEcalCycle::setScanId ( int x ) [inline]

Definition at line 59 of file ODEcalCycle.h.

References m_scan, and x.

{ m_scan = x; }

void ODEcalCycle::setSeqNum ( int x ) [inline]

Definition at line 25 of file ODEcalCycle.h.

References m_seq_num, and x.

{ m_seq_num = x; }

void ODEcalCycle::setSequenceId ( int x ) [inline]

Definition at line 28 of file ODEcalCycle.h.

References m_seq_id, and x.

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

{ m_seq_id = x; }

void ODEcalCycle::setSRPId ( int x ) [inline]

Definition at line 63 of file ODEcalCycle.h.

References m_srp, and x.

{ m_srp = x; }

void ODEcalCycle::setTag ( std::string x ) [inline]

Definition at line 21 of file ODEcalCycle.h.

References m_tag, and x.

{ m_tag = x; }

void ODEcalCycle::setTCCEEId ( int x ) [inline]

Definition at line 51 of file ODEcalCycle.h.

References m_tcc_ee, and x.

{ m_tcc_ee = x; }

void ODEcalCycle::setTCCId ( int x ) [inline]

Definition at line 49 of file ODEcalCycle.h.

References m_tcc, and x.

{ m_tcc = x; }

void ODEcalCycle::setTTCCIId ( int x ) [inline]

Definition at line 53 of file ODEcalCycle.h.

References m_ttcci, and x.

{ m_ttcci = x; }

void ODEcalCycle::setTTCFId ( int x ) [inline]

Definition at line 61 of file ODEcalCycle.h.

References m_ttcf, and x.

{ m_ttcf = x; }

void ODEcalCycle::setVersion ( int x ) [inline]

Definition at line 23 of file ODEcalCycle.h.

References m_version, and x.

{ m_version = x; }

void ODEcalCycle::writeDB ( ) throw (std::runtime_error) [private]

Definition at line 54 of file ODEcalCycle.cc.

{

  ODRunConfigCycleInfo cyc;
  cyc.setTag(this->getCycleTag());
  cyc.setDescription(this->getCycleDescription());
  cyc.setCycleNumber(this->getCycleNum());
  cyc.setSequenceID(this->getSequenceId());
  // here we insert the cycle and get back the id
  cyc.setConnection(m_env, m_conn);
  cyc.insertConfig();
  int cyc_id=cyc.getId();
  cout << "Cycle inserted with ID "<< cyc_id<< endl;
  m_ID=cyc_id;

  if(getCCSId()!=0){ 
    ODCCSCycle ccs_cycle;
    ccs_cycle.setId(cyc_id);
    ccs_cycle.setCCSConfigurationID(getCCSId());
    ccs_cycle.setConnection(m_env, m_conn);
    ccs_cycle.insertConfig();
    cout << "Inserting CCS-cycle in DB..." << flush;
  } 
  if(getDCCId()!=0){
    ODDCCCycle dcc_cycle;
    dcc_cycle.setId(cyc_id);
    dcc_cycle.setDCCConfigurationID(getDCCId());
    dcc_cycle.setConnection(m_env, m_conn);
    dcc_cycle.insertConfig();
    cout << "Inserting DCC-cycle in DB..." << flush;
  }
  if(getLaserId()!=0){
    ODLaserCycle laser_cycle;
    laser_cycle.setId(cyc_id);
    laser_cycle.setLaserConfigurationID(getLaserId());
    laser_cycle.setConnection(m_env, m_conn);
    laser_cycle.insertConfig();
    cout << "Inserting LASER-cycle in DB..." << flush;
  }
  if(getLTCId()!=0){
    ODLTCCycle ltc_cycle;
    ltc_cycle.setId(cyc_id);
    ltc_cycle.setLTCConfigurationID(getLTCId());
    ltc_cycle.setConnection(m_env, m_conn);
    ltc_cycle.insertConfig();
    cout << "Inserting LTC-cycle in DB..." << flush;
  }
  if(getLTSId()!=0){
    ODLTSCycle lts_cycle;
    lts_cycle.setId(cyc_id);
    lts_cycle.setLTSConfigurationID(getLTSId());
    lts_cycle.setConnection(m_env, m_conn);
    lts_cycle.insertConfig();
    cout << "Inserting LTS-cycle in DB..." << flush;
  }
  if(getDCUId()!=0){
    ODDCUCycle dcu_cycle;
    dcu_cycle.setId(cyc_id);
    dcu_cycle.setDCUConfigurationID(getDCUId());
    dcu_cycle.setConnection(m_env, m_conn);
    dcu_cycle.insertConfig();
    cout << "Inserting DCU-cycle in DB..." << flush;
  }
  if(getTCCId()!=0){
    ODTCCCycle tcc_cycle;
    tcc_cycle.setId(cyc_id);
    tcc_cycle.setTCCConfigurationID(getTCCId());
    tcc_cycle.setConnection(m_env, m_conn);
    tcc_cycle.insertConfig();
    cout << "Inserting TCC-cycle in DB..." << flush;
  }
  if(getTCCEEId()!=0){
    ODTCCEECycle tcc_ee_cycle;
    tcc_ee_cycle.setId(cyc_id);
    tcc_ee_cycle.setTCCConfigurationID(getTCCEEId());
    tcc_ee_cycle.setConnection(m_env, m_conn);
    tcc_ee_cycle.insertConfig();
    cout << "Inserting TCCEE-cycle in DB..." << flush;
  }
  if(getTTCCIId()!=0){
    ODTTCciCycle ttcci_cycle;
    ttcci_cycle.setId(cyc_id);
    ttcci_cycle.setTTCciConfigurationID(getTTCCIId());
    ttcci_cycle.setConnection(m_env, m_conn);
    ttcci_cycle.insertConfig();
    cout << "Inserting TTCCI-cycle in DB..." << flush;
  }
  if(getTTCFId()!=0){
    ODTTCFCycle ttcf_cycle;
    ttcf_cycle.setId(cyc_id);
    ttcf_cycle.setTTCFConfigurationID(getTTCFId());
    ttcf_cycle.setConnection(m_env, m_conn);
    ttcf_cycle.insertConfig();
    cout << "Inserting TTCF-cycle in DB..." << flush;
  }
  if(getSRPId()!=0){
    ODSRPCycle srp_cycle;
    srp_cycle.setId(cyc_id);
    srp_cycle.setSRPConfigurationID(getSRPId());
    srp_cycle.setConnection(m_env, m_conn);
    srp_cycle.insertConfig();
    cout << "Inserting SRP-cycle in DB..." << flush;
  }
  if(getJBH4Id()!=0){
    ODJBH4Cycle jbh4_cycle;
    jbh4_cycle.setId(cyc_id);
    jbh4_cycle.setJBH4ConfigurationID(getJBH4Id());
    jbh4_cycle.setConnection(m_env, m_conn);
    jbh4_cycle.insertConfig();
    cout << "Inserting JBH4-cycle in DB..." << flush;
  }
  if(getScanId()!=0){
    ODScanCycle scan_cycle;
    scan_cycle.setId(cyc_id);
    scan_cycle.setScanConfigurationID(getScanId());
    scan_cycle.setConnection(m_env, m_conn);
    scan_cycle.insertConfig();
    cout << "Inserting SCAN-cycle in DB..." << flush;
  }


}