icarusDB::ChannelMapSQLite Class Reference

ChannelMapSQLite class definiton. More...

Inheritance diagram for icarusDB::ChannelMapSQLite:

Public Member Functions
	ChannelMapSQLite (fhicl::ParameterSet const &pset)
	Constructor. More...
	~ChannelMapSQLite ()
	Destructor. More...
virtual int	BuildTPCFragmentIDToReadoutIDMap (TPCFragmentIDToReadoutIDMap &) const override
	Define the returned data structures for a mapping between TPC Fragment IDs and the related crate and readout information. Then define the function interface to fill these data structures. More...
virtual int	BuildTPCReadoutBoardToChannelMap (TPCReadoutBoardToChannelMap &) const override
	Define the returned data structures for a mapping between TPC readout boards and the channel information Then define the function interface to fill these data structures. More...
virtual int	BuildFragmentToDigitizerChannelMap (FragmentToDigitizerChannelMap &) const override
	Define the returned data structures for a mapping between PMT Fragment IDs and the related crate and readout information. Then define the function interface to fill these data structures. More...
virtual int	BuildCRTChannelIDToHWtoSimMacAddressPairMap (CRTChannelIDToHWtoSimMacAddressPairMap &) const override
	Define the returned data structures for a mapping between CRT hardware mac_address to the simulated mac_address. Then define the function interface to fill these data structures. More...
virtual int	BuildTopCRTHWtoSimMacAddressPairMap (TopCRTHWtoSimMacAddressPairMap &) const override
virtual int	BuildSideCRTCalibrationMap (SideCRTChannelToCalibrationMap &) const override
Public Member Functions inherited from icarusDB::IChannelMapping
virtual	~IChannelMapping () noexcept=default
	Virtual Destructor. More...

Private Member Functions
int	GetDataset (const std::string &, int func(void *, int, char **, char **), void *) const

Private Attributes
std::string	fDBFileName
std::string	fCalibDBFileName
std::string	fTag

Additional Inherited Members
Public Types inherited from icarusDB::IChannelMapping
using	ReadoutIDVec = std::vector< unsigned int >
	Define the returned data structures for a mapping between TPC Fragment IDs and the related crate and readout information. Then define the function interface to fill these data structures. More...
using	CrateNameReadoutIDPair = std::pair< std::string, ReadoutIDVec >
using	TPCFragmentIDToReadoutIDMap = std::map< unsigned int, CrateNameReadoutIDPair >
using	ChannelPlanePair = std::pair< unsigned int, unsigned int >
	Define the returned data structures for a mapping between TPC readout boards and the channel information Then define the function interface to fill these data structures. More...
using	ChannelPlanePairVec = std::vector< ChannelPlanePair >
using	SlotChannelVecPair = std::pair< unsigned int, ChannelPlanePairVec >
using	TPCReadoutBoardToChannelMap = std::map< unsigned int, SlotChannelVecPair >
using	DigitizerChannelChannelIDPair = std::pair< size_t, size_t >
	Define the returned data structures for a mapping between PMT Fragment IDs and the related crate and readout information. Then define the function interface to fill these data structures. More...
using	DigitizerChannelChannelIDPairVec = std::vector< DigitizerChannelChannelIDPair >
using	FragmentToDigitizerChannelMap = std::map< size_t, DigitizerChannelChannelIDPairVec >
using	CRTHWtoSimMacAddressPair = std::pair< unsigned int, unsigned int >
	Define the returned data structures for a mapping between CRT hardware mac_address to the simulated mac_address. Then define the function interface to fill these data structures. More...
using	CRTChannelIDToHWtoSimMacAddressPairMap = std::map< unsigned int, CRTHWtoSimMacAddressPair >
using	TopCRTHWtoSimMacAddressPairMap = std::map< unsigned int, unsigned int >
using	SideCRTMac5ToChannelPair = std::pair< unsigned int, unsigned int >
using	SideCRTGainToPedPair = std::pair< double, double >
using	SideCRTChannelToCalibrationMap = std::map< SideCRTMac5ToChannelPair, SideCRTGainToPedPair >

Detailed Description

ChannelMapSQLite class definiton.

Definition at line 37 of file ChannelMapSQLite_tool.cc.

Constructor & Destructor Documentation

icarusDB::ChannelMapSQLite::ChannelMapSQLite ( fhicl::ParameterSet const &  pset )

explicit

Constructor.

Parameters

pset

Definition at line 94 of file ChannelMapSQLite_tool.cc.

{
    fDBFileName      = pset.get<std::string>("DBFileName");
    fCalibDBFileName = pset.get<std::string>("CalibDBFileName");
    fTag             = pset.get<std::string>("Tag");

    return;
}

icarusDB::ChannelMapSQLite::~ChannelMapSQLite

(

)

Destructor.

Definition at line 105 of file ChannelMapSQLite_tool.cc.

{
}

Member Function Documentation

int icarusDB::ChannelMapSQLite::BuildCRTChannelIDToHWtoSimMacAddressPairMap ( CRTChannelIDToHWtoSimMacAddressPairMap &  crtChannelIDToHWtoSimMacAddressPairMap ) const

overridevirtual

Define the returned data structures for a mapping between CRT hardware mac_address to the simulated mac_address. Then define the function interface to fill these data structures.

Implements icarusDB::IChannelMapping.

Definition at line 433 of file ChannelMapSQLite_tool.cc.

  {
    // clearing is cleansing
    crtChannelIDToHWtoSimMacAddressPairMap.clear();
    // Recover the information from the database on the mapping
    const std::string  dataType("feb_channels");
    
    // Recover the data from the database
    int error = GetDataset(dataType,buildCRTChannelIDToHWtoSimMacAddressPairMap_callback,&crtChannelIDToHWtoSimMacAddressPairMap);
    
    // If there was an error the function above would have printed a message so bail out
    if (error)
      throw cet::exception("ChannelMapSQLite::BuildCRTChannelIDToHWtoSimMacAddressPairMap") << "Encountered error in reading the database: '" << error << "'\n";
    
    return error;
  }

int icarusDB::ChannelMapSQLite::BuildFragmentToDigitizerChannelMap ( FragmentToDigitizerChannelMap &  fragmentToDigitizerChannelMap ) const

overridevirtual

Define the returned data structures for a mapping between PMT Fragment IDs and the related crate and readout information. Then define the function interface to fill these data structures.

Implements icarusDB::IChannelMapping.

Definition at line 392 of file ChannelMapSQLite_tool.cc.

  {
    // clearing is cleansing
    fragmentToDigitizerChannelMap.clear();
    // Recover the information from the database on the mapping 
    const std::string  dataType("pmt_placements");
    
    // Recover the data from the database
    int error = GetDataset(dataType,buildFragmentToDigitizerChannelMap_callback,&fragmentToDigitizerChannelMap);
    
    // If there was an error the function above would have printed a message so bail out
    if (error)
      throw cet::exception("ChannelMapSQLite::BuildFragmentToDigitizerChannelMap") << "Encountered error in reading the database: '" << error << "'\n";
    
    return error;
  }

int icarusDB::ChannelMapSQLite::BuildSideCRTCalibrationMap ( SideCRTChannelToCalibrationMap &  sideCRTChannelToCalibrationMap ) const

overridevirtual

Implements icarusDB::IChannelMapping.

Definition at line 486 of file ChannelMapSQLite_tool.cc.

  {
    // clearing is cleansing
    sideCRTChannelToCalibrationMap.clear();
        
    std::string fullFileName;
    cet::search_path searchPath("FW_SEARCH_PATH");

    
    if (!searchPath.find_file(fCalibDBFileName+".db", fullFileName)){
      std::cout << "******* Succesfully found calibration input file:  " << fCalibDBFileName <<  std::endl;
      throw cet::exception("ChannelMapSQLite::GetDataset") << "Can't find calibration input file: '" << fCalibDBFileName << "'\n";
    }
    
    lariov::DBFolder database(fCalibDBFileName, "", "", fTag, true, false);
    
    database.UpdateData(1638918271*1e9);
    
    std::vector<unsigned int> channels;
    database.GetChannelList(channels);
    
    for (auto it = channels.begin(); it != channels.end(); ++it) {
      
      long mac5, chan;
      double  gain, ped;
      
      // Start extracting info
      database.GetNamedChannelData(*it, "mac5", mac5);
      database.GetNamedChannelData(*it, "localchannel", chan);
      database.GetNamedChannelData(*it, "gain", gain);
      database.GetNamedChannelData(*it, "pedestal", ped);
      
      // Fill the map
      sideCRTChannelToCalibrationMap.insert(std::make_pair(std::make_pair((int)mac5,(int)chan), std::make_pair(gain,ped)));
    }

    return 0;
  }

int icarusDB::ChannelMapSQLite::BuildTopCRTHWtoSimMacAddressPairMap ( TopCRTHWtoSimMacAddressPairMap &  topcrtHWtoSimMacAddressPairMap ) const

overridevirtual

Implements icarusDB::IChannelMapping.

Definition at line 466 of file ChannelMapSQLite_tool.cc.

  {
    // clearing is cleansing
    topcrtHWtoSimMacAddressPairMap.clear();
    // Recover the information from the database on the mapping
    const std::string  dataType("crtfeb");
    
    // Recover the data from the database
    int error = GetDataset(dataType,buildTopCRTHWtoSimMacAddressPairMap_callback,&topcrtHWtoSimMacAddressPairMap);
    
    // If there was an error the function above would have printed a message so bail out
    if (error)
      throw cet::exception("ChannelMapSQLite::BuildTopCRTHWtoSimMacAddressPairMap") << "Encountered error in reading the database: '" << error << "'\n";
    
    return error;
  }

int icarusDB::ChannelMapSQLite::BuildTPCFragmentIDToReadoutIDMap ( TPCFragmentIDToReadoutIDMap &  fragmentBoardMap ) const

overridevirtual

Define the returned data structures for a mapping between TPC Fragment IDs and the related crate and readout information. Then define the function interface to fill these data structures.

Implements icarusDB::IChannelMapping.

Definition at line 304 of file ChannelMapSQLite_tool.cc.

  {
    const std::string dataType("readout_boards");
    
    // Recover the data from the database
    int error = GetDataset(dataType,buildTPCFragmentIDToReadoutIDMap_callback,&fragmentBoardMap);
    
    // If there was an error the function above would have printed a message so bail out
    if (error)
      throw cet::exception("ChannelMapSQLite::BuildTPCFragmentIDToReadoutIDMap") << "Encountered error in reading the database: '" << error << "'\n";
    
    return error;
  }

int icarusDB::ChannelMapSQLite::BuildTPCReadoutBoardToChannelMap ( TPCReadoutBoardToChannelMap &  rbChanMap ) const

overridevirtual

Define the returned data structures for a mapping between TPC readout boards and the channel information Then define the function interface to fill these data structures.

Implements icarusDB::IChannelMapping.

Definition at line 361 of file ChannelMapSQLite_tool.cc.

  {
    const std::string  dataType("daq_channels");
    
    // Recover the data from the database
    int error = GetDataset(dataType,buildTPCReadoutBoardToChannelMap_callback,&rbChanMap);
    
    // If there was an error the function above would have printed a message so bail out
    if (error)
      throw cet::exception("ChannelMapSQLite::BuildTPCReadoutBoardToChannelMap") << "Encountered error in reading the database: '" << error << "'\n";
    
    return error;
  }

int icarusDB::ChannelMapSQLite::GetDataset ( const std::string &  table, int   funcvoid *, int, char **, char **, void *  data  ) const

private

Definition at line 131 of file ChannelMapSQLite_tool.cc.

  {
    std::string fullFileName;
    cet::search_path searchPath("FW_SEARCH_PATH");
    
    if (!searchPath.find_file(fDBFileName, fullFileName))
      throw cet::exception("ChannelMapSQLite::GetDataset") << "Can't find input file: '" << fDBFileName << "'\n";
    
    // Set up to open the database
    sqlite3* database;
    
    int rc = sqlite3_open(fullFileName.c_str(), &database);
    
    if (rc)
      throw cet::exception("ChannelMapSQLite::GetDataset") << "Can't open the database, return code:" << sqlite3_errmsg(database) << "'\n";
    
    // Test reading the database
    std::string select = "SELECT * FROM " + table;
    
    char*       zErrMsg = 0;
    
    rc = sqlite3_exec(database, select.c_str(), func, data, &zErrMsg);
    
    if( rc != SQLITE_OK ) 
      {
        std::cout << "ChannelMapSQLite::GetDataset: SQL error: " << zErrMsg << std::endl;
        sqlite3_free(zErrMsg);
      } 
    else 
      {
        std::cout << "ChannelMapSQLite::GetDataset: Successfully read database" << std::endl;
      }
    
    sqlite3_close(database);
    
    return 0;
  }

Member Data Documentation

std::string icarusDB::ChannelMapSQLite::fCalibDBFileName

private

Definition at line 90 of file ChannelMapSQLite_tool.cc.

std::string icarusDB::ChannelMapSQLite::fDBFileName

private

Definition at line 89 of file ChannelMapSQLite_tool.cc.

std::string icarusDB::ChannelMapSQLite::fTag

private

Definition at line 91 of file ChannelMapSQLite_tool.cc.

---

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

• ChannelMapSQLite_tool.cc