DbiDemoData3.cxx

Go to the documentation of this file.

// $Id: DbiDemoData3.cxx,v 1.24 2008/03/05 06:59:21 west Exp $
//
// DbiDemoData3
//
// Package: Dbi (Database Interface).

// Begin_Html<img src="../../pedestrians.gif" align=center>
// <a href="../source_warning.html">Warning for beginners</a>.<br>
// Also see <a href="../../root_crib/index.html">The ROOT Crib</a> and
// <a href="../index.html">The MINOS Class User Guide</a>End_Html
//
// N. West 02/2001
//
// Concept: A concrete data type corresponding to a single row in a
//          database table of non-aggregated data with string data.
//   
// Purpose: Example type for test and demonstration purposes.
//

#include "TObject.h"    //Prevent hiding of TObject Compare

#include "DatabaseInterface/test/DbiDemoData3.h"
#include "MessageService/MsgService.h"
#include "DatabaseInterface/DbiResultSet.h"
#include "DatabaseInterface/DbiOutRowStream.h"
#include "DatabaseInterface/DbiValidityRec.h"
#include <cmath>

ClassImp(DbiDemoData3)

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

CVSID("$Id: DbiDemoData3.cxx,v 1.24 2008/03/05 06:59:21 west Exp $\n  \
      CVSID_DBIRESULTPTR ");

//   Definition of static  members functions
//   ***************************************

string DbiDemoData3::GetTableDescr(const char* alternateName /*= 0*/) {
//
//
//  Purpose:  Return string "create table {DBIDEMODATA3|alternateName}(....)" to make table.
//

  string sql("create table ");
  if ( alternateName ) sql += alternateName;
  else                 sql += "DBIDEMODATA3";
  sql += "( SEQNO          INT NOT NULL,";
  sql += "  ROW_COUNTER    INT NOT NULL,";
  sql += "  MYBOOL_1       CHAR,";
  sql += "  MYBOOL_2       CHAR,";
  sql += "  MYCHAR         CHAR,";
  sql += "  MYSTRING       TEXT,";
  sql += "  MYCHARS        CHAR(20),";
  sql += "  MYCHARS2       CHAR(2),";
  sql += "  MY_SS_TINY_1   TINYINT,";
  sql += "  MY_SS_TINY_2   TINYINT,";
  sql += "  MY_SS_TINY_3   TINYINT,";
  sql += "  MY_SS_TINY_4   TINYINT,";
  sql += "  MY_UU_TINY_1   TINYINT UNSIGNED,";
  sql += "  MY_UU_TINY_2   TINYINT UNSIGNED,";
  sql += "  MY_UU_TINY_3   TINYINT UNSIGNED,";
  sql += "  MY_UU_TINY_4   TINYINT UNSIGNED,";
  sql += "  MY_US_TINY_1   TINYINT,";
  sql += "  MY_US_TINY_2   TINYINT,";
  sql += "  MY_US_TINY_3   TINYINT,";
  sql += "  MY_US_TINY_4   TINYINT,";
  sql += "  MY_SS_SHORT_1  SMALLINT,";
  sql += "  MY_SS_SHORT_2  SMALLINT,";
  sql += "  MY_SS_SHORT_3  SMALLINT,";
  sql += "  MY_SS_SHORT_4  SMALLINT,";
  sql += "  MY_UU_SHORT_1  SMALLINT UNSIGNED,";
  sql += "  MY_UU_SHORT_2  SMALLINT UNSIGNED,";
  sql += "  MY_UU_SHORT_3  SMALLINT UNSIGNED,";
  sql += "  MY_UU_SHORT_4  SMALLINT UNSIGNED,";
  sql += "  MY_US_SHORT_1  SMALLINT,";
  sql += "  MY_US_SHORT_2  SMALLINT,";
  sql += "  MY_US_SHORT_3  SMALLINT,";
  sql += "  MY_US_SHORT_4  SMALLINT,";
  sql += "  MY_SS_INT_1    INT,";
  sql += "  MY_SS_INT_2    INT,";
  sql += "  MY_SS_INT_3    INT,";
  sql += "  MY_SS_INT_4    INT,";
  sql += "  MY_US_INT_1    INT,";
  sql += "  MY_US_INT_2    INT,";
  sql += "  MY_US_INT_3    INT,";
  sql += "  MY_US_INT_4    INT,";
  sql += "  MYFLOAT_1      FLOAT,";
  sql += "  MYFLOAT_2      FLOAT,";
  sql += "  MYDOUBLE_1     DOUBLE,";
  sql += "  MYDOUBLE_2     DOUBLE,";
  sql += "  primary key(SEQNO,ROW_COUNTER))";
  return sql;
}

//  Instantiate associated Result Pointer and Writer classes.
//  ********************************************************

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

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

// Apparently (Stroustrup 3rd edition) - 'static' is deprecated for
// limiting function scope to file - unnamed namespace is better.

namespace {

// Helper function for Compare

  template<class T> void CompareValue(const T& thisValue, 
                                const T& thatValue,
                                const char* name,
                                bool  printDiff,
                                bool& matchedSofar) {
  
    if ( thisValue == thatValue ) return;
    if ( printDiff ) {
      if ( matchedSofar ) 
          MSG("Dbi",Msg::kInfo) << "Mismatch between DbiDemoData3 objects:-\n";
      MSG("Dbi",Msg::kInfo) << "   member " << name  << " this: " << thisValue << endl;
      MSG("Dbi",Msg::kInfo) << "   member " << name  << " that: " << thatValue << endl;
  
    }
    matchedSofar = false;
  }
  template<class T> void CompareValuewithTol(const T& thisValue, 
                                const T& thatValue,
                                const char* name,
                                bool  printDiff,
                                           bool& matchedSofar,
                                float tol) {

    float diff =  fabs(thisValue - thatValue)
                 /(fabs(thisValue) + fabs(thatValue));  
    if ( diff <= tol ) return;
    if ( printDiff ) {
      if ( matchedSofar ) 
        MSG("Dbi",Msg::kInfo) << "Mismatch between DbiDemoData3 objects:-\n" << setprecision(22);
      MSG("Dbi",Msg::kInfo) << "   member " << name  << " this: " << thisValue << endl;
      MSG("Dbi",Msg::kInfo) << "   member " << name  << " that: " << thatValue 
                          << " % difference: " << diff << endl;
    }
    matchedSofar = false;
  }
}  // End of unnamed namespace


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


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

DbiDemoData3::DbiDemoData3():
fBool_1(1 == 1),
fBool_2(1 != 1),
fChar('a'),
fString("Check special chars: backslash: \\ tab: \t newline: \n single quote: \' double quote:\""),
fChars("abcdefgh"),
fChars2("yz"),
fSS_Tiny_1(0x0000),
fSS_Tiny_2(0x007f),
fSS_Tiny_3(-128),   //For some reason gcc 4.1 objects to 0xff80
fSS_Tiny_4(-1),     //  "   "    "     "   "    "      " 0xffff
fUU_Tiny_1(0x0000),
fUU_Tiny_2(0x007f),
fUU_Tiny_3(0x0080),
fUU_Tiny_4(0x00ff),
fUS_Tiny_1(0x0000),
fUS_Tiny_2(0x007f),
fUS_Tiny_3(0x0080),
fUS_Tiny_4(0x00ff),
fSS_Short_1(0x0000),
fSS_Short_2(0x7fff),
fSS_Short_3(0x8000),
fSS_Short_4(0xffff),
fUU_Short_1(0x0000),
fUU_Short_2(0x7fff),
fUU_Short_3(0x8000),
fUU_Short_4(0xffff),
fUS_Short_1(0x0000),
fUS_Short_2(0x7fff),
fUS_Short_3(0x8000),
fUS_Short_4(0xffff),
fSS_Int_1(0x00000000),
fSS_Int_2(0x7fffffff),
fSS_Int_3(0x80000001),
fSS_Int_4(0xffffffff),
fUS_Int_1(0x00000000),
fUS_Int_2(0x7fffffff),
fUS_Int_3(0x80000001),
fUS_Int_4(0xffffffff),
fFloat_1(14511.7998),
fFloat_2(12345.550e+16),
fDouble_1(-1.234567890123456789012345e+100),
fDouble_2( 1.234567890123456789012345e-100)
{ 

//  The default ctor.

 LEA_CTOR; 

 // Aug 2006: Testing using the new ROOT SQL interface there is a problem
 //           reading MySQL unsigned data if top bit set.  As we have no
 //           such data (and never will have as unsigned is now banned)
 //           just reset the values that cause problems.

 fUU_Tiny_3  = fUU_Tiny_4  = fUU_Tiny_1;
 fUU_Short_3 = fUU_Short_4 = fUU_Short_1;
}

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

Bool_t DbiDemoData3::Compare(const DbiDemoData3* that, 
                             Bool_t printDiff /*= true*/) const {
//
//
//  Purpose:  Compare to 'that' and optionally print differences
//
//  Return:   true if match.

  bool compare = true;

  if ( ! that ) {
    if ( printDiff )  MSG("Dbi",Msg::kInfo) << "Cannot compare DbiDemoData3 object; null pointer passed\n" << endl;
    return false;
  }

  float tol_double = 2.e-16;
  float tol_single = 0.;

  CompareValue(this->fBool_1,that->fBool_1,"fBool_1",printDiff,compare);
  CompareValue(this->fBool_2,that->fBool_2,"fBool_2",printDiff,compare);
  CompareValue(this->fChar,that->fChar,"fChar",printDiff,compare);
  CompareValue(this->fString,that->fString,"fString",printDiff,compare);
  CompareValue(this->fChars,that->fChars,"fChars",printDiff,compare);
  CompareValue(this->fChars2,that->fChars2,"fChars2",printDiff,compare);
  CompareValue(this->fSS_Tiny_1,that->fSS_Tiny_1,"fSS_Tiny_1",printDiff,compare);
  CompareValue(this->fSS_Tiny_2,that->fSS_Tiny_2,"fSS_Tiny_2",printDiff,compare);
  CompareValue(this->fSS_Tiny_3,that->fSS_Tiny_3,"fSS_Tiny_3",printDiff,compare);
  CompareValue(this->fSS_Tiny_4,that->fSS_Tiny_4,"fSS_Tiny_4",printDiff,compare);
  CompareValue(this->fUU_Tiny_1,that->fUU_Tiny_1,"fUU_Tiny_1",printDiff,compare);
  CompareValue(this->fUU_Tiny_2,that->fUU_Tiny_2,"fUU_Tiny_2",printDiff,compare);
  CompareValue(this->fUU_Tiny_3,that->fUU_Tiny_3,"fUU_Tiny_3",printDiff,compare);
  CompareValue(this->fUU_Tiny_4,that->fUU_Tiny_4,"fUU_Tiny_4",printDiff,compare);
  CompareValue(this->fUS_Tiny_1,that->fUS_Tiny_1,"fUS_Tiny_1",printDiff,compare);
  CompareValue(this->fUS_Tiny_2,that->fUS_Tiny_2,"fUS_Tiny_2",printDiff,compare);
  CompareValue(this->fUS_Tiny_3,that->fUS_Tiny_3,"fUS_Tiny_3",printDiff,compare);
  CompareValue(this->fUS_Tiny_4,that->fUS_Tiny_4,"fUS_Tiny_4",printDiff,compare);
  CompareValue(this->fSS_Short_1,that->fSS_Short_1,"fSS_Short_1",printDiff,compare);
  CompareValue(this->fSS_Short_2,that->fSS_Short_2,"fSS_Short_2",printDiff,compare);
  CompareValue(this->fSS_Short_3,that->fSS_Short_3,"fSS_Short_3",printDiff,compare);
  CompareValue(this->fSS_Short_4,that->fSS_Short_4,"fSS_Short_4",printDiff,compare);
  CompareValue(this->fUU_Short_1,that->fUU_Short_1,"fUU_Short_1",printDiff,compare);
  CompareValue(this->fUU_Short_2,that->fUU_Short_2,"fUU_Short_2",printDiff,compare);

//  Exclude short unsigned application to unsigned table where top bit is set.
//  Currently (as of December 2005) there is a problem with these when run in
//  a mixed (Oracle,MySQL) cascade.  Unsigned isn't support although it still
//  works with a MySQL database so skipping this test isn't a bad thing to do.

//  CompareValue(this->fUU_Short_3,that->fUU_Short_3,"fUU_Short_3",printDiff,compare);
//  CompareValue(this->fUU_Short_4,that->fUU_Short_4,"fUU_Short_4",printDiff,compare);

  CompareValue(this->fUS_Short_1,that->fSS_Short_1,"fUS_Short_1",printDiff,compare);
  CompareValue(this->fUS_Short_2,that->fUS_Short_2,"fUS_Short_2",printDiff,compare);
  CompareValue(this->fUS_Short_3,that->fUS_Short_3,"fUS_Short_3",printDiff,compare);
  CompareValue(this->fUS_Short_4,that->fUS_Short_4,"fUS_Short_4",printDiff,compare);
  CompareValue(this->fSS_Int_1,that->fSS_Int_1,"fSS_Int_1",printDiff,compare);
  CompareValue(this->fSS_Int_2,that->fSS_Int_2,"fSS_Int_2",printDiff,compare);
  CompareValue(this->fSS_Int_3,that->fSS_Int_3,"fSS_Int_3",printDiff,compare);
  CompareValue(this->fSS_Int_4,that->fSS_Int_4,"fSS_Int_4",printDiff,compare);
  CompareValue(this->fUS_Int_1,that->fUS_Int_1,"fUS_Int_1",printDiff,compare);
  CompareValue(this->fUS_Int_2,that->fUS_Int_2,"fUS_Int_2",printDiff,compare);
  CompareValue(this->fUS_Int_3,that->fUS_Int_3,"fUS_Int_3",printDiff,compare);
  CompareValue(this->fUS_Int_4,that->fUS_Int_4,"fUS_Int_4",printDiff,compare);
  CompareValuewithTol(this->fFloat_1,that->fFloat_1,"fFloat_1",printDiff,compare,tol_single);
  CompareValuewithTol(this->fFloat_2,that->fFloat_2,"fFloat_2",printDiff,compare,tol_single);
  CompareValuewithTol(this->fDouble_1,that->fDouble_1,"fDouble_1",printDiff,compare,tol_double);
  CompareValuewithTol(this->fDouble_2,that->fDouble_2,"fDouble_2",printDiff,compare,tol_double);
  return compare;

}


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

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

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

//  None.

  this->JunkFill();
  rs >> fBool_1     >> fBool_2   >> fChar >> fString >> fChars >> fChars2
     >> fSS_Tiny_1  >> fSS_Tiny_2  >> fSS_Tiny_3  >> fSS_Tiny_4 
     >> fUU_Tiny_1  >> fUU_Tiny_2  >> fUU_Tiny_3  >> fUU_Tiny_4
     >> fUS_Tiny_1  >> fUS_Tiny_2  >> fUS_Tiny_3  >> fUS_Tiny_4
     >> fSS_Short_1 >> fSS_Short_2 >> fSS_Short_3 >> fSS_Short_4 
     >> fUU_Short_1 >> fUU_Short_2 >> fUU_Short_3 >> fUU_Short_4
     >> fUS_Short_1 >> fUS_Short_2 >> fUS_Short_3 >> fUS_Short_4
     >> fSS_Int_1   >> fSS_Int_2   >> fSS_Int_3   >> fSS_Int_4 
     >> fUS_Int_1   >> fUS_Int_2   >> fUS_Int_3   >> fUS_Int_4
     >> fFloat_1    >> fFloat_2    >> fDouble_1   >> fDouble_2 ;

}

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

void DbiDemoData3::JunkFill() {
//
//
//  Purpose:  Fill oject with junk (to ensure a subsequent positive fill test is genuine)
//

 fBool_1 = 0;
 fBool_2 = 1;
 fChar = 'z';
 fString = "";
 fChars = "";
 fChars2 = "";
 fSS_Tiny_1  = fSS_Tiny_2  = fSS_Tiny_3  = fSS_Tiny_4 = 999;
 fUU_Tiny_1  = fUU_Tiny_2  = fUU_Tiny_3  = fUU_Tiny_4 = 999;
 fUS_Tiny_1  = fUS_Tiny_2  = fUS_Tiny_3  = fUS_Tiny_4 = 999;
 fSS_Short_1 = fSS_Short_2 = fSS_Short_3 = fSS_Short_4 = 999;
 fUU_Short_1 = fUU_Short_2 = fUU_Short_3 = fUU_Short_4 = 999;
 fUS_Short_1 = fUS_Short_2 = fUS_Short_3 = fUS_Short_4 = 999;
 fSS_Int_1   = fSS_Int_2   = fSS_Int_3   = fSS_Int_4   = 999;
 fUS_Int_1   = fUS_Int_2   = fUS_Int_3   = fUS_Int_4   = 999;
 fFloat_1    = fFloat_2    = fDouble_1   = fDouble_2   = 999.999;
   
}

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

void DbiDemoData3::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:   N. West
//
//  Specification:-
//  =============
//
//  o  Stream object to output row stream.

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

//  None.

  const Char_t*  pChars = fChars.c_str();  // Test char* output

  ors << fBool_1     << fBool_2   << fChar << fString << pChars << fChars2
      << fSS_Tiny_1  << fSS_Tiny_2  << fSS_Tiny_3  << fSS_Tiny_4 
      << fUU_Tiny_1  << fUU_Tiny_2  << fUU_Tiny_3  << fUU_Tiny_4
      << fUS_Tiny_1  << fUS_Tiny_2  << fUS_Tiny_3  << fUS_Tiny_4
      << fSS_Short_1 << fSS_Short_2 << fSS_Short_3 << fSS_Short_4 
      << fUU_Short_1 << fUU_Short_2 << fUU_Short_3 << fUU_Short_4
      << fUS_Short_1 << fUS_Short_2 << fUS_Short_3 << fUS_Short_4
      << fSS_Int_1   << fSS_Int_2   << fSS_Int_3   << fSS_Int_4 
      << fUS_Int_1   << fUS_Int_2   << fUS_Int_3   << fUS_Int_4
      << fFloat_1    << fFloat_2    << fDouble_1   << fDouble_2 ;
   
}

/*    Template for New Member Function

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

DbiDemoData3:: {
//
//
//  Purpose:  
//
//  Arguments: 
//    xxxxxxxxx    in    yyyyyy
//
//  Return:    
//
//  Contact:   N. West
//
//  Specification:-
//  =============
//
//  o 

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

//  None.


}

*/

---