#include <FEConfigBadTTDat.h>

Inheritance diagram for FEConfigBadTTDat:

Public Member Functions
	FEConfigBadTTDat ()
int	getFedId () const
int	getId () const
int	getStatus () const
std::string	getTable ()
int	getTCCId () const
int	getTTId () const
void	setFedId (int x)
void	setId (int dac)
void	setStatus (int dac)
void	setTCCId (int dac)
void	setTTId (int dac)
	~FEConfigBadTTDat ()
Private Member Functions
void	fetchData (std::vector< FEConfigBadTTDat > fillMap, FEConfigBadTTInfo iov) throw (std::runtime_error)
void	prepareWrite () throw (std::runtime_error)
void	writeArrayDB (const std::vector< FEConfigBadTTDat > data, FEConfigBadTTInfo *iov) throw (std::runtime_error)
void	writeDB (const FEConfigBadTTDat item, FEConfigBadTTInfo iov) throw (std::runtime_error)
Private Attributes
int	m_fed
int	m_ID
int	m_t1
int	m_tcc
int	m_tt
Friends
class	EcalCondDBInterface

Detailed Description

Definition at line 10 of file FEConfigBadTTDat.h.

Constructor & Destructor Documentation

FEConfigBadTTDat::FEConfigBadTTDat ( )

Definition at line 10 of file FEConfigBadTTDat.cc.

References NULL.

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

  m_tcc = 0;
  m_fed = 0;
  m_tt = 0;
  m_t1 = 0;

}

FEConfigBadTTDat::~FEConfigBadTTDat ( )

Definition at line 26 of file FEConfigBadTTDat.cc.

{
}

Member Function Documentation

void FEConfigBadTTDat::fetchData	(	std::vector< FEConfigBadTTDat > *	fillMap,
		FEConfigBadTTInfo *	iov
	)		throw (std::runtime_error) `[private]`

Definition at line 68 of file FEConfigBadTTDat.cc.

References o2o::iov, L1TEmulatorMonitor_cff::p, setFedId(), setStatus(), setTCCId(), and setTTId().

{
  this->checkConnection();

  iov->setConnection(m_env, m_conn);
  int iovID = iov->fetchID();
  if (!iovID) { 
    //  throw(std::runtime_error("FEConfigBadTTDat::writeDB:  IOV not in DB")); 
    return;
  }

  try {
    m_readStmt->setSQL("SELECT * FROM " + getTable() + " WHERE rec_id = :rec_id order by tcc_id, fed_id, tt_id ");
    m_readStmt->setInt(1, iovID);
    ResultSet* rset = m_readStmt->executeQuery();
    
    //    std::vector< FEConfigBadTTDat > p;
    FEConfigBadTTDat dat;
    while(rset->next()) {
      // dat.setId( rset->getInt(1) );
      dat.setTCCId( rset->getInt(2) );
      dat.setFedId( rset->getInt(3) );
      dat.setTTId( rset->getInt(4) );
      dat.setStatus( rset->getInt(5) );

      p->push_back( dat);

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

int FEConfigBadTTDat::getFedId ( ) const [inline]

Definition at line 23 of file FEConfigBadTTDat.h.

References m_fed.

Referenced by writeArrayDB().

{ return m_fed; }

int FEConfigBadTTDat::getId ( ) const [inline]

Definition at line 20 of file FEConfigBadTTDat.h.

References m_ID.

{ return m_ID; }

int FEConfigBadTTDat::getStatus ( void ) const [inline]

Definition at line 33 of file FEConfigBadTTDat.h.

References m_t1.

Referenced by popcon::EcalTPGBadTTHandler::getNewObjects(), and writeArrayDB().

{ return m_t1; }

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

Implements IODConfig.

Definition at line 17 of file FEConfigBadTTDat.h.

{ return "FE_CONFIG_BadTT_DAT"; }

int FEConfigBadTTDat::getTCCId ( ) const [inline]

Definition at line 26 of file FEConfigBadTTDat.h.

References m_tcc.

Referenced by popcon::EcalTPGBadTTHandler::getNewObjects(), and writeArrayDB().

{ return m_tcc; }

int FEConfigBadTTDat::getTTId ( ) const [inline]

Definition at line 29 of file FEConfigBadTTDat.h.

References m_tt.

Referenced by popcon::EcalTPGBadTTHandler::getNewObjects(), and writeArrayDB().

{ return m_tt; }

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

Implements IODConfig.

Definition at line 32 of file FEConfigBadTTDat.cc.

{
  this->checkConnection();

  try {
    m_writeStmt = m_conn->createStatement();
    m_writeStmt->setSQL("INSERT INTO "+getTable()+" (rec_id, tcc_id, fed_id, tt_id, status ) "
                        "VALUES (:1, :2, :3, :4, :5 )");
  } catch (SQLException &e) {
    throw(std::runtime_error("FEConfigBadTTDat::prepareWrite():  "+e.getMessage()));
  }
}

void FEConfigBadTTDat::setFedId ( int x ) [inline]

Definition at line 22 of file FEConfigBadTTDat.h.

References m_fed, and x.

Referenced by fetchData().

{ m_fed = x; }

void FEConfigBadTTDat::setId ( int dac ) [inline]

Definition at line 19 of file FEConfigBadTTDat.h.

References m_ID.

{ m_ID = dac; }

void FEConfigBadTTDat::setStatus ( int dac ) [inline]

Definition at line 32 of file FEConfigBadTTDat.h.

References m_t1.

Referenced by fetchData().

{ m_t1 = dac; }

void FEConfigBadTTDat::setTCCId ( int dac ) [inline]

Definition at line 25 of file FEConfigBadTTDat.h.

References m_tcc.

Referenced by fetchData().

{ m_tcc = dac; }

void FEConfigBadTTDat::setTTId ( int dac ) [inline]

Definition at line 28 of file FEConfigBadTTDat.h.

References m_tt.

Referenced by fetchData().

{ m_tt = dac; }

void FEConfigBadTTDat::writeArrayDB	(	const std::vector< FEConfigBadTTDat >	data,
		FEConfigBadTTInfo *	iov
	)		throw (std::runtime_error) `[private]`

Definition at line 104 of file FEConfigBadTTDat.cc.

References prof2calltree::count, runTheMatrix::data, getFedId(), getStatus(), getTCCId(), getTTId(), and o2o::iov.

{
  this->checkConnection();

  int iovID = iov->fetchID();
  if (!iovID) { throw(std::runtime_error("FEConfigDelays::writeArrayDB:  FEConfigBadTTInfo not in DB")); }


  int nrows=data.size(); 
  int* ids= new int[nrows];
  int* xx= new int[nrows];
  int* yy= new int[nrows];
  int* zz= new int[nrows];
  int* st= new int[nrows];



  ub2* ids_len= new ub2[nrows];
  ub2* x_len= new ub2[nrows];
  ub2* y_len= new ub2[nrows];
  ub2* z_len= new ub2[nrows];
  ub2* st_len= new ub2[nrows];


  FEConfigBadTTDat dataitem;
  

  for (size_t count = 0; count != data.size(); count++) {
    dataitem=data[count];
    ids[count]=iovID;
    xx[count]=dataitem.getTCCId();
    yy[count]=dataitem.getFedId();
    zz[count]=dataitem.getTTId();
    st[count]=dataitem.getStatus();


        ids_len[count]=sizeof(ids[count]);
        x_len[count]=sizeof(xx[count]);
        y_len[count]=sizeof(yy[count]);
        z_len[count]=sizeof(zz[count]);
        st_len[count]=sizeof(st[count]);

     }


  try {
    m_writeStmt->setDataBuffer(1, (dvoid*)ids, OCCIINT, sizeof(ids[0]),ids_len);
    m_writeStmt->setDataBuffer(2, (dvoid*)xx, OCCIINT , sizeof(xx[0]), x_len );
    m_writeStmt->setDataBuffer(3, (dvoid*)yy, OCCIINT , sizeof(yy[0]), y_len );
    m_writeStmt->setDataBuffer(4, (dvoid*)zz, OCCIINT , sizeof(zz[0]), z_len );
    m_writeStmt->setDataBuffer(5, (dvoid*)st, OCCIINT , sizeof(st[0]), st_len );

    m_writeStmt->executeArrayUpdate(nrows);

    delete [] ids;
    delete [] xx;
    delete [] yy;
    delete [] zz;
    delete [] st;

    delete [] ids_len;
    delete [] x_len;
    delete [] y_len;
    delete [] z_len;
    delete [] st_len;

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

void FEConfigBadTTDat::writeDB	(	const FEConfigBadTTDat *	item,
		FEConfigBadTTInfo *	iov
	)		throw (std::runtime_error) `[private]`

Definition at line 48 of file FEConfigBadTTDat.cc.

{
  this->checkConnection();

  try {
    m_writeStmt->setInt(1, item->getId());
    m_writeStmt->setInt(2, item->getTCCId() );
    m_writeStmt->setInt(3, item->getFedId());
    m_writeStmt->setInt(4, item->getTTId() );
    m_writeStmt->setInt(5, item->getStatus() );

    m_writeStmt->executeUpdate();
  } catch (SQLException &e) {
    throw(std::runtime_error("FEConfigBadTTDat::writeDB():  "+e.getMessage()));
  }
}