FabPlnInstall.cxx

Go to the documentation of this file.

// $Id: FabPlnInstall.cxx,v 1.12 2008/03/04 21:44:34 rhatcher Exp $
//
// FabPlnInstall
//
// Package: Fabrication
//
// R. Hatcher  2002-11-06
//
// Concept: DBI table to record when planes were installed/commissioned
//          in the detector and what components went into them.
//   
// Purpose:
//

#include "Fabrication/FabPlnInstall.h"
#include "MessageService/MsgService.h"
#include "DatabaseInterface/DbiOutRowStream.h"
#include "DatabaseInterface/DbiResultSet.h"
#include "DatabaseInterface/DbiValidityRec.h"

//#include "UgliGeometry/UgliDbiTableDescr.h"

#include <cassert>
#include <string.h>

using std::string;
using std::vector;

ClassImp(FabPlnInstall)

//   Definition of static data members
//   *********************************

CVSID("$Id: FabPlnInstall.cxx,v 1.12 2008/03/04 21:44:34 rhatcher Exp $ CVSID_DBIRESULTPTR ");
Bool_t FabPlnInstall::fgDefensiveUnpkg = kFALSE;

//  Instantiate associated Result Pointer class.
//  *******************************************

#include "DatabaseInterface/DbiResultPtr.tpl"
template class  DbiResultPtr<FabPlnInstall>;

#include "DatabaseInterface/DbiWriter.tpl"
template class  DbiWriter<FabPlnInstall>;

// Definition of member functions (alphabetical order)
// ***************************************************


//.....................................................................

void FabPlnInstall::Fill(DbiResultSet& rs,
                                      const DbiValidityRec* vrec) {
//
//
//  Purpose:  Fill object from Result Set
//
//  Arguments: 
//    rs           in    Result Set used to fill object
//    vrec         in    Associated validity record (or 0 if filling
//                                                    DbiValidityRec)
//
//  Return:    
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//
//  o Fill object from current row of Result Set.

//  Program Notes:-
//  =============

//  None.


   UShort_t ipln = 1023;

   if (fgDefensiveUnpkg) {

      // unpack allowing for various column names and ordering

      Int_t numCol = rs.NumCols();
      //  The first column (SeqNo) has already been processed.
      for (Int_t curCol = rs.HasRowCounter() ? 3 : 2; curCol <= numCol; ++curCol) {
         string colName = rs.CurColName();
         if (      colName == "INSTALLDATE"  ) rs >> fInstallDate;

         else if ( colName == "MODULEID1")     rs >> fScintMdlMfgId[0];
         else if ( colName == "MODULEID2")     rs >> fScintMdlMfgId[1];
         else if ( colName == "MODULEID3")     rs >> fScintMdlMfgId[2];
         else if ( colName == "MODULEID4")     rs >> fScintMdlMfgId[3];
         else if ( colName == "MODULEID5")     rs >> fScintMdlMfgId[4];
         else if ( colName == "MODULEID6")     rs >> fScintMdlMfgId[5];
         else if ( colName == "MODULEID7")     rs >> fScintMdlMfgId[6];
         else if ( colName == "MODULEID8")     rs >> fScintMdlMfgId[7];

         else if ( colName == "STEELID1")      rs >> fSteelSlabMfgId[0];
         else if ( colName == "STEELID2")      rs >> fSteelSlabMfgId[1];
         else if ( colName == "STEELID3")      rs >> fSteelSlabMfgId[2];
         else if ( colName == "STEELID4")      rs >> fSteelSlabMfgId[3];
         else if ( colName == "STEELID5")      rs >> fSteelSlabMfgId[4];
         else if ( colName == "STEELID6")      rs >> fSteelSlabMfgId[5];
         else if ( colName == "STEELID7")      rs >> fSteelSlabMfgId[6];
         else if ( colName == "STEELID8")      rs >> fSteelSlabMfgId[7];

         else if ( colName == "PLANENUM")      rs >> ipln;
         else {
            static int nmsg = 25;
            if (nmsg-- > 0) MSG("Fab",Msg::kWarning) 
               << "Ignoring column " << rs.CurColNum() 
               << " (of " << rs.NumCols() << ")"
               << " \""<< colName << "\"; not part of "
               << ClassName() << endl;
            rs.IncrementCurCol();
         }
      }
   } // end defensive unpacking
   else {
      rs >> fInstallDate
         >> fScintMdlMfgId[0]
         >> fScintMdlMfgId[1]
         >> fScintMdlMfgId[2]
         >> fScintMdlMfgId[3]
         >> fScintMdlMfgId[4]
         >> fScintMdlMfgId[5]
         >> fScintMdlMfgId[6]
         >> fScintMdlMfgId[7]
         >> fSteelSlabMfgId[0]
         >> fSteelSlabMfgId[1]
         >> fSteelSlabMfgId[2]
         >> fSteelSlabMfgId[3]
         >> fSteelSlabMfgId[4]
         >> fSteelSlabMfgId[5]
         >> fSteelSlabMfgId[6]
         >> fSteelSlabMfgId[7]
         >> ipln;
    }

    // trim off lead/trailing blanks
    for (UInt_t i=0; i < 8; ++i ) {
      fScintMdlMfgId[i]  = 
        ToUpper(fScintMdlMfgId[i]).Strip(TString::kBoth).Data();
      fSteelSlabMfgId[i] = 
        ToUpper(fSteelSlabMfgId[i]).Strip(TString::kBoth).Data();
    }

    Detector::Detector_t det =
      (Detector::Detector_t) 
      ((vrec) ? vrec->GetVldRange().GetDetectorMask() : 0);

    fPlaneId = PlexPlaneId(det,ipln,kTRUE); // steel can be uninstrumented

}

//.....................................................................

void FabPlnInstall::Store(DbiOutRowStream& ors,
                          const DbiValidityRec* /* vrec */) const {
//
//
//  Purpose:  Stream object to output row stream
//
//  Arguments: 
//    ors          in     Output row stream.
//    vrec         in     Associated validity record (or 0 if filling
//                                                    DbiValidityRec)
//
//  Return:    
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//
//  o  Stream object to output row stream.

//  Program Notes:-
//  =============

//  None.

  //const char* tabledescr = GetTableDescr();
   //   vector< pair<string,string> > components = 
   //      UgliDbiTableDescr::ParseTableDescr(tabledescr);
   //   int n = components.size();
   vector< pair<string,string> > components;
   components.push_back(pair<string,string>("SEQNO","int"));
   components.push_back(pair<string,string>("INSTALLDATE","datetime"));
   components.push_back(pair<string,string>("MODULEID1","tinytext"));
   components.push_back(pair<string,string>("MODULEID2","tinytext"));
   components.push_back(pair<string,string>("MODULEID3","tinytext"));
   components.push_back(pair<string,string>("MODULEID4","tinytext"));
   components.push_back(pair<string,string>("MODULEID5","tinytext"));
   components.push_back(pair<string,string>("MODULEID6","tinytext"));
   components.push_back(pair<string,string>("MODULEID7","tinytext"));
   components.push_back(pair<string,string>("MODULEID8","tinytext"));
   components.push_back(pair<string,string>("STEELID1","tinytext"));
   components.push_back(pair<string,string>("STEELID2","tinytext"));
   components.push_back(pair<string,string>("STEELID3","tinytext"));
   components.push_back(pair<string,string>("STEELID4","tinytext"));
   components.push_back(pair<string,string>("STEELID5","tinytext"));
   components.push_back(pair<string,string>("STEELID6","tinytext"));
   components.push_back(pair<string,string>("STEELID7","tinytext"));
   components.push_back(pair<string,string>("STEELID8","tinytext"));
   components.push_back(pair<string,string>("PLANENUM","int"));
   int n = components.size();

   for (int i=0; i<n; i++) {
      pair<string,string> colPair = components[i];
      string colName = colPair.first;
      if (      colName == "INSTALLDATE") ors << fInstallDate;

      // note! indexing uses zero-based, but naming is 1..8
      else if ( colName == "MODULEID1")   ors << fScintMdlMfgId[0];
      else if ( colName == "MODULEID2")   ors << fScintMdlMfgId[1];
      else if ( colName == "MODULEID3")   ors << fScintMdlMfgId[2];
      else if ( colName == "MODULEID4")   ors << fScintMdlMfgId[3];
      else if ( colName == "MODULEID5")   ors << fScintMdlMfgId[4];
      else if ( colName == "MODULEID6")   ors << fScintMdlMfgId[5];
      else if ( colName == "MODULEID7")   ors << fScintMdlMfgId[6];
      else if ( colName == "MODULEID8")   ors << fScintMdlMfgId[7];

      else if ( colName == "STEELID1")    ors << fSteelSlabMfgId[0];
      else if ( colName == "STEELID2")    ors << fSteelSlabMfgId[1];
      else if ( colName == "STEELID3")    ors << fSteelSlabMfgId[2];
      else if ( colName == "STEELID4")    ors << fSteelSlabMfgId[3];
      else if ( colName == "STEELID5")    ors << fSteelSlabMfgId[4];
      else if ( colName == "STEELID6")    ors << fSteelSlabMfgId[5];
      else if ( colName == "STEELID7")    ors << fSteelSlabMfgId[6];
      else if ( colName == "STEELID8")    ors << fSteelSlabMfgId[7];

      else if ( colName == "PLANENO")     ors << fPlaneId.GetPlane();

      else if ( colName == "ROW_COUNTER"     ) {;}
      else if ( colName == "SEQNO"           ) {;}
      else {
         MSG("Fab",Msg::kFatal)
            << "Column name '" << colName << "' not correctly handled" << endl;
         assert(0);
      }
   }
}

//.....................................................................
string FabPlnInstall::GetScintMdlMfgId(UShort_t indx) const
{ 
  if (indx > fScintMdlMfgId.size()) return "no-scint-id";
  return fScintMdlMfgId[indx];
}

//.....................................................................
string FabPlnInstall::GetSteelSlabMfgId(UShort_t indx) const
{ 
  if (indx > fSteelSlabMfgId.size()) return "no-slab-id";
  return fSteelSlabMfgId[indx];
}

//.....................................................................
Int_t FabPlnInstall::GetAggregateNo() const
{ 
  //return (int)fPlaneId.GetDetector()*100000000 + fPlaneId.GetPlane();
  return fPlaneId.GetPlane();
}

//.....................................................................
UInt_t FabPlnInstall::GetIndex(UInt_t /* defIndex */) const
{ 
  return fPlaneId.GetPlane();
}

//.....................................................................
std::ostream& operator<<(std::ostream& os, const FabPlnInstall& pi)
{ return pi.FormatToOStream(os); }

//.....................................................................
void FabPlnInstall::Print(Option_t *option) const
{ FormatToOStream(cout,option); }

//.....................................................................
std::ostream& FabPlnInstall::FormatToOStream(std::ostream& os,
                                             Option_t * /* option */) const
{
  os << GetName() << " " 
     << fPlaneId.AsString("c") << " "
     << fInstallDate.AsString("sql") << endl;
  for (int i=0; i<8; ++i) {
    os << "  [" << i << "]  ";
    // left justification doesn't work consistently
    // not on std::strings and for some reason sometimes not at all
    // (but breaking it up like this seems to work sometimes)
    os.fill(' ');
    os << setw(16);
    os.setf(ios::left);  
    os << fScintMdlMfgId[i].c_str();
    os << " ";
    os.fill(' ');
    os << setw(16);
    os.setf(ios::left);  
    os << fSteelSlabMfgId[i].c_str();
    os << endl;
  }
  os.setf(ios::right);
  return os;
}

//.....................................................................

const char* FabPlnInstall::GetTableDescr()
{
//
//
//  Purpose:  Return a string describing rows in the table
//            Used in creating temporary tables
//
//  Return:   const char* to parenthesized comma separated list
//            of column name and type pairs
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//

//  Program Notes:-
//  =============

//  None.

   const char* const_tabledescr = "(\
       SEQNO             int,      \
       ROW_COUNTER       int,      \
       INSTALLDATE       datetime, \
       MODULEID1         tinytext, \
       MODULEID2         tinytext, \
       MODULEID3         tinytext, \
       MODULEID4         tinytext, \
       MODULEID5         tinytext, \
       MODULEID6         tinytext, \
       MODULEID7         tinytext, \
       MODULEID8         tinytext, \
       STEELID1          tinytext, \
       STEELID2          tinytext, \
       STEELID3          tinytext, \
       STEELID4          tinytext, \
       STEELID5          tinytext, \
       STEELID6          tinytext, \
       STEELID7          tinytext, \
       STEELID8          tinytext, \
       PLANENUM          int,      \
       primary key (SEQNO,ROW_COUNTER) \
       )";

   return const_tabledescr;
}

/*    Template for New Member Function

//.....................................................................

FabPlnInstall:: {
//
//
//  Purpose:  
//
//  Arguments: 
//    xxxxxxxxx    in    yyyyyy
//
//  Return:    
//
//  Contact:   R. Hatcher
//
//  Specification:-
//  =============
//
//  o 

//  Program Notes:-
//  =============

//  None.


}

*/

---