#include <HLTPrescaleSetLoader.h>

Inheritance diagram for TrigConf::HLTPrescaleSetLoader:

Collaboration diagram for TrigConf::HLTPrescaleSetLoader:

Public Member Functions
	HLTPrescaleSetLoader (StorageMgr &sm, coral::ISessionProxy &session)

virtual	~HLTPrescaleSetLoader () override=default

virtual bool	load (HLTPrescaleSet &hltpss) override

virtual void	setLevel (MSGTC::Level lvl) override
	access to output stream More...

virtual MSGTC::Level	outputLevel () const override

void	startSession ()
	start session if not already active More...

void	commitSession ()
	commit session if not already done More...

bool	loadL1MasterKey (int SuperMasterKey, int &Lvl1MasterKey)
	get l1 master from super master More...

bool	loadL1MenuKey (int SuperMasterKey, int &Lvl1MenuKey)
	get l1 menu id from super master More...

unsigned int	triggerDBSchemaVersion ()

virtual int	verbose () const override

virtual void	setVerbose (int v) override

bool	isRun1 ()

bool	isRun2 ()

bool	msgLvl (const MSGTC::Level lvl) const
	Test the output level. More...

MsgStreamTC &	msg () const
	The standard message stream. More...

MsgStreamTC &	msg (const MSGTC::Level lvl) const
	The standard message stream. More...

Protected Attributes
StorageMgr &	m_storageMgr
	reference to the storage manager More...

coral::ISessionProxy &	m_session
	CORAL interface to database session. More...

bool	m_sessionOwner {false}
	remember if the loader started the session in the first place More...

Private Member Functions
std::tuple< unsigned int, unsigned int >	loadSchemaVersion () const
	get DB schema version and run number More...

Private Attributes
int	m_verbose {1}

boost::thread_specific_ptr< MsgStreamTC >	m_msg_tls
	MsgStreamTC instance (a std::cout like with print-out levels) More...

std::string	m_name

Detailed Description

Definition at line 25 of file HLTPrescaleSetLoader.h.

Constructor & Destructor Documentation

◆ HLTPrescaleSetLoader()

TrigConf::HLTPrescaleSetLoader::HLTPrescaleSetLoader	(	StorageMgr &	sm,
		coral::ISessionProxy &	session
	)

inline

Definition at line 28 of file HLTPrescaleSetLoader.h.

28 : DBLoader("HLTPrescaleSetLoader", sm, session) {}

◆ ~HLTPrescaleSetLoader()

virtual TrigConf::HLTPrescaleSetLoader::~HLTPrescaleSetLoader ( )

overridevirtualdefault

Member Function Documentation

◆ commitSession()

void TrigConf::DBLoader::commitSession ( )

inherited

commit session if not already done

Definition at line 45 of file DBLoader.cxx.

 {
    if ( m_session.transaction().isActive() && m_sessionOwner) {
       m_session.transaction().commit();
    }
 }

◆ isRun1()

bool TrigConf::DBLoader::isRun1 ( )

inlineinherited

Definition at line 60 of file DBLoader.h.

60 { return ! isRun2(); }

◆ isRun2()

bool DBLoader::isRun2 ( )

inherited

Definition at line 54 of file DBLoader.cxx.

                  {
    const static unsigned int run = std::get<1>(loadSchemaVersion());
    return run == 2;
 }

◆ load()

bool TrigConf::HLTPrescaleSetLoader::load ( HLTPrescaleSet & hltpss )

overridevirtual

Implements TrigConf::IHLTPrescaleSetLoader.

Definition at line 49 of file HLTPrescaleSetLoader.cxx.

                                                            {
  
    using std::string;
    
    TRG_MSG_INFO("Started loading data with HLT PSK: " << hltpss.id());
  
    //Find if old or new schema is being used:
    try {
  
       triggerDBSchemaVersion();
  
       startSession();
  
       unique_ptr< coral::IQuery > q( m_session.nominalSchema().newQuery() );
  
       //Set the tables that are used
       q->addToTableList ( "HLT_PRESCALE_SET", "PS" );
       q->addToTableList ( "HLT_PRESCALE",     "PR" );
  
       //printTable(m_session.nominalSchema().tableHandle( "HLT_PRESCALE"));
  
       //Bind list
       coral::AttributeList bindList;
       bindList.extend<int>("psid");
       bindList[0].data<int>() = (int)hltpss.id();
  
       // selection condition
       string theCondition = " PS.HPS_ID = :psid";
       theCondition += " AND PS.HPS_ID = PR.HPR_PRESCALE_SET_ID";
       q->setCondition( theCondition, bindList );
  
       // output data
       coral::AttributeList attList;
       attList.extend<string>( "PS.HPS_NAME"              );
       attList.extend<int>   ( "PS.HPS_VERSION"           );
       if(isRun1()) { 
          attList.extend<string>( "PR.HPR_L2_OR_EF"       ); 
          attList.extend<string>( "PR.HPR_PASS_THROUGH_RATE" ); 
          attList.extend<string>( "PR.HPR_PRESCALE"          ); 
       } else { 
          attList.extend<float>   ( "PR.HPR_VALUE" ); 
          attList.extend<string>  ( "PR.HPR_TYPE" ); 
          attList.extend<string>  ( "PR.HPR_CONDITION" ); 
       } 
       attList.extend<int>   ( "PR.HPR_CHAIN_COUNTER" ); 
  
       fillQuery(q.get(),attList);
  
       // the ordering
       string theOrder = ""; 
       if(isRun1()) { 
          theOrder = " PR.HPR_L2_OR_EF DESC, PR.HPR_CHAIN_COUNTER ASC"; 
       } else { 
          theOrder += "PR.HPR_CHAIN_COUNTER ASC"; 
       } 
       q->addToOrderList( theOrder );
  
  
       q->setRowCacheSize(1000);
       q->setDistinct();
  
       // process the query
       coral::ICursor& cursor = q->execute();
  
       bool pssnameset = false;
       
  
       // fill chain info list
       while (cursor.next()) {
         
          const coral::AttributeList& row = cursor.currentRow();
  
          if(!pssnameset) {
             string pssname = CheckTilda(row["PS.HPS_NAME"].data<string>());
             int    pssversion = row["PS.HPS_VERSION"].data<int>();
             hltpss.setName(pssname);
             hltpss.setVersion(pssversion);
             pssnameset=true;
          }
  
          string level = isRun1() ? row["PR.HPR_L2_OR_EF"].data<string>() : "HLT";  
          int counter = row["PR.HPR_CHAIN_COUNTER"].data<int>(); 
  
          // this is faster than boost::lexical_cast string->float:
          if(isRun1()) {
             float  ps(-999);
             float  pt(-999); 
             std::string prescaleStr = row["PR.HPR_PRESCALE"].data<string>(); 
             if(prescaleStr=="-0" || prescaleStr=="na" ) prescaleStr = "-1"; 
             if (!convert(prescaleStr, ps)) { 
                TRG_MSG_WARNING("Could not convert prescale string '" << prescaleStr << "' of chain " << counter << " to float");
             } 
      
             std::string passThroughStr = row["PR.HPR_PASS_THROUGH_RATE"].data<string>(); 
             if (!convert(passThroughStr, pt)) { 
                TRG_MSG_WARNING("Could not convert passthrough string '" << passThroughStr << "' of chain " << counter << " to float");
             }
  
             if(level=="L2" || level=="l2" || level=="EF" || level=="ef" || level=="hlt" || level=="HLT" || level=="") {
                hltpss.thePrescale( counter, str2lvl(level) )
                   .setPrescale(ps)
                   .setPassThrough(pt);
             } else {
                std::string streamnametype(level);
                // sanity check: stream name and type are separated by ':'
                if(streamnametype.rfind(':')==std::string::npos)
                   streamnametype += ":" + streamnametype;
             }
          } else {
             // RUN 2 
             float value = row["PR.HPR_VALUE"].data<float>(); 
             string pstype = row["PR.HPR_TYPE"].data<string>(); 
             string pscondition = row["PR.HPR_CONDITION"].data<string>(); 
  
             TRG_MSG_DEBUG("Loaded prescales:"<< setw(4) << right << counter << " : " << pstype << " (" << pscondition << ") => " << value );
  
             auto& thePS = hltpss.thePrescale( counter, str2lvl("HLT") );
  
             if(pstype=="Prescale") { 
                thePS.setPrescale(value);
             } else if (pstype=="Pass_Through") { 
                thePS.setPassThrough(value);
             } else if (pstype=="ReRun") { 
                if(pscondition=="0") pscondition="";
                thePS.setRerunPrescale(pscondition,value);
             } else if (pstype=="Stream") { 
                // pscontition : stream name
                thePS.setStreamPrescale(pscondition,value);
             } else {
                TRG_MSG_WARNING("Could not interpret this entry in the prescale set table: counter " << counter << " : " << pstype << " (" << pscondition << ") => " << value);
             }
          }
       }
  
       if(isRun1()) {
          TRG_MSG_INFO("Loaded " << hltpss.size(L2) << " L2 prescales and " << hltpss.size(EF) << " EF prescales.");
       } else {
          TRG_MSG_INFO("Loaded " << hltpss.size() << " HLT prescales");
       }
       commitSession();
    }
    catch (const coral::SchemaException& e) {
       TRG_MSG_ERROR("HLTPrescaleSetLoader >> IRelationalException: " << e.what()); 
       m_session.transaction().rollback();
       return false;
    }
    catch (const std::exception& e) {
       TRG_MSG_ERROR("HLTPrescaleSetLoader >> Standard C++ exception: " << e.what()); 
       m_session.transaction().rollback();
       return false;
    }
    catch (...) {
       TRG_MSG_ERROR("HLTPrescaleSetLoader >> unknown C++ exception");
       m_session.transaction().rollback();
       return false;
    }
  
    return true;
  
 }

◆ loadL1MasterKey()

bool TrigConf::DBLoader::loadL1MasterKey	(	int	SuperMasterKey,
		int &	Lvl1MasterKey
	)

inherited

get l1 master from super master

Definition at line 128 of file DBLoader.cxx.

                                                              {
    try {
       startSession();
       
       unique_ptr< coral::IQuery > q( m_session.nominalSchema().tableHandle( "SUPER_MASTER_TABLE").newQuery() );
       q->setRowCacheSize( 5 );
  
       //Bind list
       coral::AttributeList bindings;
       bindings.extend<int>("smtid");
       bindings[0].data<int>() = smk;
       q->setCondition( "SMT_ID = :smtid", bindings );
  
       //Output data and types
       coral::AttributeList attList;
       attList.extend<int>( "SMT_L1_MASTER_TABLE_ID" );
       fillQuery(q.get(), attList);
  
       coral::ICursor& cursor = q->execute();
       if ( ! cursor.next() ) {
          msg() << "DBLoader:           No such SuperMaster key exists " << smk << endl;
          throw runtime_error( "DBLoader:        SuperMasterKey not available" );
       }
     
       const coral::AttributeList& row = cursor.currentRow();
       Lvl1MasterKey = row["SMT_L1_MASTER_TABLE_ID"].data<int>();
    }
    catch( const std::exception& e ) {
       commitSession();
       msg() << "DBLoader:         C++ exception: " << e.what() << std::endl;
       throw;
    }
    commitSession();
    return true; 
 }

◆ loadL1MenuKey()

bool TrigConf::DBLoader::loadL1MenuKey	(	int	SuperMasterKey,
		int &	Lvl1MenuKey
	)

inherited

get l1 menu id from super master

Definition at line 167 of file DBLoader.cxx.

                                                                     {
    try {
  
       int l1Master = 0;
       loadL1MasterKey(SuperMasterKey, l1Master);
  
       startSession();
     
       unique_ptr< coral::IQuery > q( m_session.nominalSchema().tableHandle( "L1_MASTER_TABLE").newQuery() );
       q->setRowCacheSize( 5 );
  
       //Bind list
       coral::AttributeList bindings;
       bindings.extend<int>("l1mtid");
       bindings[0].data<int>() = l1Master;
       q->setCondition( "L1MT_ID = :l1mtid" , bindings );
  
       //Output data and types
       coral::AttributeList attList;
       attList.extend<int>( "L1MT_TRIGGER_MENU_ID" );
       q->defineOutput(attList);
       q->addToOutputList( "L1MT_TRIGGER_MENU_ID" );
  
       coral::ICursor& cursor = q->execute();
       if ( ! cursor.next() ) {
          msg() << "DBLoader >> No such L1 Master key exists " << l1Master << std::endl;
          throw std::runtime_error( "DBLoader >> L1MasterKey not available" );
          commitSession();
       }
     
       const coral::AttributeList& row = cursor.currentRow();
       Lvl1MenuKey = row["L1MT_TRIGGER_MENU_ID"].data<int>();
  
       commitSession();
  
    }
    catch( const std::exception& e ) {
       msg() << "DBLoader >> Standard C++ exception: " << e.what() << std::endl;
       m_session.transaction().rollback();
       throw;
    }
    return true; 
 }

◆ loadSchemaVersion()

std::tuple< unsigned int, unsigned int > DBLoader::loadSchemaVersion ( ) const

privateinherited

get DB schema version and run number

Definition at line 81 of file DBLoader.cxx.

 {
    const static auto versions = [&]() -> std::tuple<unsigned int,unsigned int> {
       bool mySession = false;
       if ( ! m_session.transaction().isActive() ) {
          m_session.transaction().start(true);
          mySession = true;
       }
  
       std::unique_ptr< coral::IQuery > q( m_session.nominalSchema().tableHandle( "TRIGGER_SCHEMA").newQuery() );
       q->setRowCacheSize( 1 );
  
       //Output data and types
       coral::AttributeList attList;
       attList.extend<int>( "TS_ID" );
       q->defineOutput(attList);
       q->addToOutputList( "TS_ID" );
  
       q->addToOrderList("TS_ID desc");
       coral::ICursor& cursor = q->execute();
  
       if ( ! cursor.next() ) {
          TRG_MSG_ERROR("Table TRIGGER_SCHEMA is not filled");
          if ( mySession ) m_session.transaction().commit();
          throw std::runtime_error( "DBLoader::loadSchemaVersion() >> Table TRIGGER_SCHEMA is not filled" );
       }
  
       const coral::AttributeList& row = cursor.currentRow();
       const unsigned int triggerDBSchemaVersion = row["TS_ID"].data<int>();
  
       TRG_MSG_INFO("TriggerDB schema version: " << triggerDBSchemaVersion);
  
       const unsigned int run = m_session.nominalSchema().existsTable( "ACTIVE_MASTERS" ) ? 2 : 1;
  
       TRG_MSG_INFO("Database has Run " << run << " schema");
       TRG_MSG_INFO("Total number of tables : " <<  m_session.nominalSchema().listTables().size());
  
       //commitSession();
       if ( mySession ) m_session.transaction().commit();
  
       return {triggerDBSchemaVersion, run};
    }();
  
    return versions;
 }

◆ msg() [1/2]

MsgStreamTC & TrigConf::TrigConfMessaging::msg ( ) const

inlineinherited

The standard message stream.

Returns a reference to the message stream May not be invoked before sysInitialize() has been invoked.

Definition at line 81 of file TrigConfMessaging.h.

   {
     MsgStreamTC* ms = m_msg_tls.get();
     if (!ms) {
       ms = new MsgStreamTC(m_name);
       m_msg_tls.reset(ms);
     }
     return *ms;
   }

◆ msg() [2/2]

MsgStreamTC & TrigConf::TrigConfMessaging::msg ( const MSGTC::Level lvl ) const

inlineinherited

The standard message stream.

Returns a reference to the default message stream May not be invoked before sysInitialize() has been invoked.

Definition at line 91 of file TrigConfMessaging.h.

   {
     return msg() << lvl;
   }

◆ msgLvl()

bool TrigConf::TrigConfMessaging::msgLvl ( const MSGTC::Level lvl ) const

inlineinherited

Test the output level.

Parameters

lvl	The message level to test against

Returns: boolean Indicting if messages at given level will be printed

Return values

true	Messages at level "lvl" will be printed

Definition at line 70 of file TrigConfMessaging.h.

   {
     if (msg().level() <= lvl) {
       msg() << lvl;
       return true;
     }
     else {
       return false;
     }
   }

◆ outputLevel()

virtual MSGTC::Level TrigConf::DBLoader::outputLevel ( ) const

inlineoverridevirtualinherited

Implements TrigConf::ILoader.

Definition at line 40 of file DBLoader.h.

40 { return msg().level(); }

◆ setLevel()

void DBLoader::setLevel ( MSGTC::Level lvl )

overridevirtualinherited

access to output stream

Implements TrigConf::ILoader.

Definition at line 60 of file DBLoader.cxx.

                                  {
    msg().setLevel(lvl);
  
    switch(lvl) {
    case MSGTC::ALWAYS: m_verbose = 5; break;
    case MSGTC::VERBOSE: m_verbose = 4; break;
    case MSGTC::DEBUG: m_verbose = 3; break;
    case MSGTC::INFO: m_verbose = 2; break;
    case MSGTC::WARNING:
    case MSGTC::ERROR:
    case MSGTC::FATAL: m_verbose = 0; break;
    default: m_verbose = 0;
    }
 }

◆ setVerbose()

virtual void TrigConf::DBLoader::setVerbose ( int v )

inlineoverridevirtualinherited

Implements TrigConf::ILoader.

Definition at line 58 of file DBLoader.h.

58 { m_verbose=v; }

◆ startSession()

void TrigConf::DBLoader::startSession ( )

inherited

start session if not already active

Definition at line 35 of file DBLoader.cxx.

 {
    if ( ! m_session.transaction().isActive() ) {
       //std::cout << "DBLoader: startSession(readonly=true)" << std::endl;
       bool readOnly = true;
       m_session.transaction().start(readOnly);
       m_sessionOwner = true;
    }
 }

◆ triggerDBSchemaVersion()

unsigned int DBLoader::triggerDBSchemaVersion ( )

inherited

Definition at line 76 of file DBLoader.cxx.

                                  {
    return std::get<0>(loadSchemaVersion());
 }

◆ verbose()

virtual int TrigConf::DBLoader::verbose ( ) const

inlineoverridevirtualinherited

Implements TrigConf::ILoader.

Definition at line 57 of file DBLoader.h.

57 { return m_verbose; }

Member Data Documentation

◆ m_msg_tls

boost::thread_specific_ptr<MsgStreamTC> TrigConf::TrigConfMessaging::m_msg_tls

mutableprivateinherited

MsgStreamTC instance (a std::cout like with print-out levels)

Definition at line 66 of file TrigConfMessaging.h.

◆ m_name

std::string TrigConf::TrigConfMessaging::m_name

privateinherited

Definition at line 67 of file TrigConfMessaging.h.

◆ m_session

coral::ISessionProxy& TrigConf::DBLoader::m_session

protectedinherited

CORAL interface to database session.

Definition at line 68 of file DBLoader.h.

◆ m_sessionOwner

bool TrigConf::DBLoader::m_sessionOwner {false}

protectedinherited

remember if the loader started the session in the first place

Definition at line 69 of file DBLoader.h.

◆ m_storageMgr

StorageMgr& TrigConf::DBLoader::m_storageMgr

protectedinherited

reference to the storage manager

Definition at line 67 of file DBLoader.h.

◆ m_verbose

int TrigConf::DBLoader::m_verbose {1}

privateinherited

Definition at line 64 of file DBLoader.h.

The documentation for this class was generated from the following files:

Public Member Functions

Protected Attributes

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ HLTPrescaleSetLoader()

◆ ~HLTPrescaleSetLoader()

Member Function Documentation

◆ commitSession()

◆ isRun1()

◆ isRun2()

◆ load()

◆ loadL1MasterKey()

◆ loadL1MenuKey()

◆ loadSchemaVersion()

◆ msg() [1/2]

◆ msg() [2/2]

◆ msgLvl()

◆ outputLevel()

◆ setLevel()

◆ setVerbose()

◆ startSession()

◆ triggerDBSchemaVersion()

◆ verbose()

Member Data Documentation

◆ m_msg_tls

◆ m_name

◆ m_session

◆ m_sessionOwner

◆ m_storageMgr

◆ m_verbose