ODSRPConfig Class Reference

#include <ODSRPConfig.h>

Inheritance diagram for ODSRPConfig:

Public Member Functions
int	getAutomaticMasks () const
int	getAutomaticSrpSelect () const
std::string	getConfigFile () const
int	getDebugMode () const
int	getDummyMode () const
int	getId () const
std::string	getPatternDirectory () const
int	getSRP0BunchAdjustPosition () const
unsigned char *	getSRPClob () const
unsigned int	getSRPClobSize () const
std::string	getTable () override
	ODSRPConfig ()
void	setAutomaticMasks (int x)
void	setAutomaticSrpSelect (int x)
void	setConfigFile (std::string x)
void	setDebugMode (int x)
void	setDummyMode (int x)
void	setId (int id)
void	setParameters (const std::map< std::string, std::string > &my_keys_map)
void	setPatternDirectory (std::string x)
void	setSRP0BunchAdjustPosition (int x)
void	setSRPClob (unsigned char *x)
	~ODSRPConfig () 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 (ODSRPConfig *result) noexcept(false)
int	fetchID () noexcept(false)
int	fetchNextId () noexcept(false)
void	prepareWrite () noexcept(false) override
void	writeDB () noexcept(false)

Private Attributes
int	m_auto
int	m_auto_srp
int	m_bnch
int	m_debug
int	m_dummy
std::string	m_file
int	m_ID
std::string	m_patdir
unsigned int	m_size
unsigned char *	m_srp_clob

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 17 of file ODSRPConfig.h.

Constructor & Destructor Documentation

ODSRPConfig::ODSRPConfig

(

)

Definition at line 13 of file ODSRPConfig.cc.

References hitfit::clear().

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

   m_ID=0;
   clear();
   m_size=0;
}

ODSRPConfig::~ODSRPConfig ( )

override

Definition at line 37 of file ODSRPConfig.cc.

{
}

Member Function Documentation

void ODSRPConfig::clear ( void  )

private

Definition at line 26 of file ODSRPConfig.cc.

Referenced by getSRPClobSize().

                       {
  //  strcpy((char *)m_srp_clob, "");
 m_debug=0;
 m_dummy=0;
 m_file="";
 m_patdir="";
 m_auto=0;
 m_bnch=0;

}

void ODSRPConfig::fetchData ( ODSRPConfig *  result )

privatenoexcept

Definition at line 203 of file ODSRPConfig.cc.

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

Referenced by getSRPClobSize().

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

  try {

    m_readStmt->setSQL("SELECT  * "
               " FROM ECAL_SRP_CONFIGURATION  "
               " where (srp_configuration_id = :1 or srp_tag=:2 )" );
    m_readStmt->setInt(1, result->getId());
    m_readStmt->setString(2, result->getConfigTag());
    ResultSet* rset = m_readStmt->executeQuery();

    rset->next();
    // 1 is the id and 2 is the config tag

    result->setId(rset->getInt(1));
    result->setConfigTag(rset->getString(2));

    result->setDebugMode(rset->getInt(3));
    result->setDummyMode(rset->getInt(4));
    result->setPatternDirectory(rset->getString(5));
    result->setAutomaticMasks(rset->getInt(6));
    result->setSRP0BunchAdjustPosition(rset->getInt(7));
    result->setConfigFile(rset->getString(8));

    Clob clob = rset->getClob(9);
    m_size = clob.length();
    Stream *instream = clob.getStream (1,0);
    unsigned char *buffer = new unsigned char[m_size];
    memset (buffer, 0, m_size);
    instream->readBuffer ((char*)buffer, m_size);
    /*
    cout << "Opening the clob in Read only mode" << endl;
    clob.open (OCCI_LOB_READONLY);
    int clobLength=clob.length ();
    cout << "Length of the clob is: " << clobLength << endl;
    unsigned char* buffer = readClob (clob, clobLength);
    clob.close ();
    cout<< "the clob buffer is:"<<endl;  
    for (int i = 0; i < clobLength; ++i)
      cout << (char) buffer[i];
    cout << endl;


    */
    result->setSRPClob(buffer );
    result->setAutomaticSrpSelect(rset->getInt(10));

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

int ODSRPConfig::fetchID ( )

privatenoexcept

Definition at line 265 of file ODSRPConfig.cc.

References MillePedeFileConverter_cfg::e.

Referenced by getSRPClobSize().

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

  this->checkConnection();

  try {
    Statement* stmt = m_conn->createStatement();
    stmt->setSQL("SELECT srp_configuration_id FROM ecal_srp_configuration "
                 "WHERE  srp_tag=:srp_tag "
         );

    stmt->setString(1, getConfigTag() );

    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("ODSRPConfig::fetchID:  "+e.getMessage()));
  }

    return m_ID;
}

int ODSRPConfig::fetchNextId ( )

privatenoexcept

Definition at line 41 of file ODSRPConfig.cc.

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

Referenced by getSRPClobSize().

                                              {

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

    m_readStmt = m_conn->createStatement(); 
    m_readStmt->setSQL("select ecal_srp_config_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("ODSRPConfig::fetchNextId():  "+e.getMessage()));
  }

}

int ODSRPConfig::getAutomaticMasks ( ) const

inline

Definition at line 39 of file ODSRPConfig.h.

References m_auto.

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

{ return m_auto; }

int ODSRPConfig::getAutomaticSrpSelect ( ) const

inline

Definition at line 42 of file ODSRPConfig.h.

References m_auto_srp.

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

{ return m_auto_srp; }

std::string ODSRPConfig::getConfigFile ( ) const

inline

Definition at line 48 of file ODSRPConfig.h.

References m_file.

{ return m_file; }

int ODSRPConfig::getDebugMode ( ) const

inline

Definition at line 30 of file ODSRPConfig.h.

References m_debug.

{ return m_debug; }

int ODSRPConfig::getDummyMode ( ) const

inline

Definition at line 33 of file ODSRPConfig.h.

References m_dummy.

{ return m_dummy; }

int ODSRPConfig::getId ( void  ) const

inline

Definition at line 27 of file ODSRPConfig.h.

References m_ID.

{ return m_ID; }

std::string ODSRPConfig::getPatternDirectory ( ) const

inline

Definition at line 36 of file ODSRPConfig.h.

References m_patdir.

{ return m_patdir; }

int ODSRPConfig::getSRP0BunchAdjustPosition ( ) const

inline

Definition at line 45 of file ODSRPConfig.h.

References m_bnch.

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

{ return m_bnch; }

unsigned char* ODSRPConfig::getSRPClob ( ) const

inline

Definition at line 51 of file ODSRPConfig.h.

References m_srp_clob.

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

{ return m_srp_clob; }

unsigned int ODSRPConfig::getSRPClobSize ( ) const

inline

Definition at line 52 of file ODSRPConfig.h.

References clear(), fetchData(), fetchID(), fetchNextId(), m_size, noexcept, prepareWrite(), mps_fire::result, setParameters(), and writeDB().

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

{ return m_size; }

std::string ODSRPConfig::getTable ( )

inlineoverridevirtual

Implements IODConfig.

Definition at line 24 of file ODSRPConfig.h.

{ return "ECAL_SRP_CONFIGURATION"; }

void ODSRPConfig::prepareWrite ( )

overrideprivatevirtualnoexcept

Implements IODConfig.

Definition at line 116 of file ODSRPConfig.cc.

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

Referenced by getSRPClobSize().

{
  this->checkConnection();

  int next_id=fetchNextId();

  try {
    m_writeStmt = m_conn->createStatement();
    m_writeStmt->setSQL("INSERT INTO ECAL_SRP_CONFIGURATION (srp_configuration_id, srp_tag, "
            "   DEBUGMODE, DUMMYMODE, PATTERN_DIRECTORY, AUTOMATIC_MASKS,"
            " SRP0BUNCHADJUSTPOSITION, SRP_CONFIG_FILE, SRP_CONFIGURATION,  AUTOMATICSRPSELECT  ) "
                        "VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10 )");
    m_writeStmt->setInt(1, next_id);
    m_writeStmt->setString(2, getConfigTag());
    m_writeStmt->setInt(3, getDebugMode());
    m_writeStmt->setInt(4, getDummyMode());
    m_writeStmt->setString(5, getPatternDirectory());
    m_writeStmt->setInt(6, getAutomaticMasks());
    m_writeStmt->setInt(10, getAutomaticSrpSelect());
    m_writeStmt->setInt(7, getSRP0BunchAdjustPosition());
    m_writeStmt->setString(8, getConfigFile());
  
    // and now the clob
    oracle::occi::Clob clob(m_conn);
    clob.setEmpty();
    m_writeStmt->setClob(9,clob);
    m_writeStmt->executeUpdate ();
    m_ID=next_id; 

    m_conn->terminateStatement(m_writeStmt);
    std::cout<<"SRP Clob inserted into CONFIGURATION with id="<<next_id<<std::endl;

    // now we read and update it 
    m_writeStmt = m_conn->createStatement(); 
    m_writeStmt->setSQL ("SELECT srp_configuration FROM ECAL_SRP_CONFIGURATION WHERE"
             " srp_configuration_id=:1 FOR UPDATE");

    std::cout<<"updating the clob 0"<<std::endl;

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

  std::cout<<"updating the clob 1 "<<std::endl;
  
}

void ODSRPConfig::setAutomaticMasks ( int  x )

inline

Definition at line 38 of file ODSRPConfig.h.

References m_auto, and x.

{ m_auto = x; }

void ODSRPConfig::setAutomaticSrpSelect ( int  x )

inline

Definition at line 41 of file ODSRPConfig.h.

References m_auto_srp, and x.

{ m_auto_srp = x; }

void ODSRPConfig::setConfigFile ( std::string  x )

inline

Definition at line 47 of file ODSRPConfig.h.

References m_file, and x.

{ m_file = x; }

void ODSRPConfig::setDebugMode ( int  x )

inline

Definition at line 29 of file ODSRPConfig.h.

References m_debug, and x.

{ m_debug = x; }

void ODSRPConfig::setDummyMode ( int  x )

inline

Definition at line 32 of file ODSRPConfig.h.

References m_dummy, and x.

{ m_dummy= x; }

void ODSRPConfig::setId ( int  id )

inline

Definition at line 26 of file ODSRPConfig.h.

References triggerObjects_cff::id, and m_ID.

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

{ m_ID = id; }

void ODSRPConfig::setParameters

(

const std::map< std::string, std::string > &

my_keys_map

)

Definition at line 65 of file ODSRPConfig.cc.

References gather_cfg::cout, end, alignmentValidation::fname, createfilelist::int, dataset::name, AlCaHLTBitMon_QueryRunRegistry::string, and create_public_lumi_plots::transform.

Referenced by getSRPClobSize().

                                                                       {

  // parses the result of the XML parser that is a map of
  // string string with variable name variable value


  for( std::map<std::string, std::string >::const_iterator ci=
         my_keys_map.begin(); ci!=my_keys_map.end(); ci++ ) {

      std::string name = ci->first;
      std::transform(name.begin(), name.end(), name.begin(), (int(*)(int))std::toupper);

    if( name ==  "SRP_CONFIGURATION_ID") setConfigTag(ci->second);
    if( name ==  "DEBUGMODE") setDebugMode(atoi(ci->second.c_str()));
    if( name ==  "DUMMYMODE") setDummyMode(atoi(ci->second.c_str()));
    if( name ==  "PATTERNDIRECTORY") setPatternDirectory(ci->second);
    if( name ==  "PATTERN_DIRECTORY") setPatternDirectory(ci->second);
    if( name ==  "AUTOMATICMASKS") setAutomaticMasks(atoi(ci->second.c_str()));
    if( name ==  "AUTOMATIC_MASKS") setAutomaticMasks(atoi(ci->second.c_str()));
    if( name ==  "AUTOMATICSRPSELECT") setAutomaticSrpSelect(atoi(ci->second.c_str()));
    if( name ==  "SRP0BUNCHADJUSTPOSITION") setSRP0BunchAdjustPosition(atoi(ci->second.c_str()));
    if( name ==  "SRP_CONFIG_FILE") {
      std::string fname=ci->second ;
    
      cout << "fname="<<fname << endl;
      setConfigFile(fname);


      // here we must open the file and read the LTC Clob
      std::cout << "Going to read SRP file: " << fname << endl;

      ifstream inpFile;
      inpFile.open(fname.c_str());

      // tell me size of file 
      int bufsize = 0; 
      inpFile.seekg( 0,ios::end ); 
      bufsize = inpFile.tellg(); 
      std::cout <<" bufsize ="<<bufsize<< std::endl;
      // set file pointer to start again 
      inpFile.seekg( 0,ios::beg ); 

      m_size=bufsize;
      
      inpFile.close();
      
    }
  }

}

void ODSRPConfig::setPatternDirectory ( std::string  x )

inline

Definition at line 35 of file ODSRPConfig.h.

References m_patdir, and x.

{ m_patdir = x; }

void ODSRPConfig::setSRP0BunchAdjustPosition ( int  x )

inline

Definition at line 44 of file ODSRPConfig.h.

References m_bnch, and x.

{ m_bnch = x; }

void ODSRPConfig::setSRPClob ( unsigned char *  x )

inline

Definition at line 50 of file ODSRPConfig.h.

References m_srp_clob, and x.

{ m_srp_clob = x; }

void ODSRPConfig::writeDB ( )

privatenoexcept

Definition at line 166 of file ODSRPConfig.cc.

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

Referenced by getSRPClobSize().

{

  std::cout<<"updating the clob 2"<<std::endl;

  try {
    m_writeStmt->setInt(1, m_ID);
    ResultSet* rset = m_writeStmt->executeQuery();

    while (rset->next ())
      {
        oracle::occi::Clob clob = rset->getClob (1);
        cout << "Opening the clob in read write mode" << endl;
    cout << "Populating the clob" << endl;
    populateClob (clob, getConfigFile(), m_size );
        int clobLength=clob.length ();
        cout << "Length of the clob after writing is: " << clobLength << endl;
      
      }

    m_writeStmt->executeUpdate();

    m_writeStmt->closeResultSet (rset);

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


}

Friends And Related Function Documentation

friend class EcalCondDBInterface

friend

Definition at line 19 of file ODSRPConfig.h.

Member Data Documentation

int ODSRPConfig::m_auto

private

Definition at line 73 of file ODSRPConfig.h.

Referenced by getAutomaticMasks(), and setAutomaticMasks().

int ODSRPConfig::m_auto_srp

private

Definition at line 73 of file ODSRPConfig.h.

Referenced by getAutomaticSrpSelect(), and setAutomaticSrpSelect().

int ODSRPConfig::m_bnch

private

Definition at line 74 of file ODSRPConfig.h.

Referenced by getSRP0BunchAdjustPosition(), and setSRP0BunchAdjustPosition().

int ODSRPConfig::m_debug

private

Definition at line 69 of file ODSRPConfig.h.

Referenced by getDebugMode(), and setDebugMode().

int ODSRPConfig::m_dummy

private

Definition at line 70 of file ODSRPConfig.h.

Referenced by getDummyMode(), and setDummyMode().

std::string ODSRPConfig::m_file

private

Definition at line 71 of file ODSRPConfig.h.

Referenced by getConfigFile(), and setConfigFile().

int ODSRPConfig::m_ID

private

Definition at line 67 of file ODSRPConfig.h.

Referenced by getId(), and setId().

std::string ODSRPConfig::m_patdir

private

Definition at line 72 of file ODSRPConfig.h.

Referenced by getPatternDirectory(), and setPatternDirectory().

unsigned int ODSRPConfig::m_size

private

Definition at line 75 of file ODSRPConfig.h.

Referenced by getSRPClobSize().

unsigned char* ODSRPConfig::m_srp_clob

private

Definition at line 68 of file ODSRPConfig.h.

Referenced by getSRPClob(), and setSRPClob().