TOracleRow Class Reference

#include <TOracleRow.h>

Inheritance diagram for TOracleRow:

Collaboration diagram for TOracleRow:

Public Member Functions
void	Close (Option_t *opt="")
const char *	GetField (Int_t field)
ULong_t	GetFieldLength (Int_t field)
	TOracleRow (ResultSet *rs, std::vector< MetaData > *fieldMetaData)
	TOracleRow (UInt_t updateCount)
	~TOracleRow ()

Protected Member Functions
int	GetRowData ()
int	GetRowData2 ()

Private Member Functions
Bool_t	IsValid (Int_t field)

Private Attributes
UInt_t	fFieldCount
std::vector< MetaData > *	fFieldInfo
std::vector< std::string > *	fFields
ResultSet *	fResult
Int_t	fResultType
UInt_t	fUpdateCount

Constructor & Destructor Documentation

TOracleRow() [1/2]

TOracleRow::TOracleRow	(	ResultSet *	rs,
		std::vector< MetaData > *	fieldMetaData
	)

TOracleRow() [2/2]

TOracleRow::TOracleRow

(

UInt_t

updateCount

)

{
   fUpdateCount = updateCount;
   fFieldCount  = 0;
   fFields      = 0;
   fResultType  = 0;
}

~TOracleRow()

TOracleRow::~TOracleRow

(

)

{
   // Destroy row object.
 
   if (fResultType >= 0) {
      Close();
   }
}

Member Function Documentation

Close()

void TOracleRow::Close

(

Option_t *

opt = ""

)

{
   // Close row.
 
   if (fResultType == -1)
      return;
 
   fFieldInfo   = 0;
   fFieldCount  = 0;
   fResult      = 0;
   fResultType  = 0;
   if (fFields)
      delete fFields;
}

GetField()

const char * TOracleRow::GetField

(

Int_t

field

)

{
   if (!IsValid(field) || !fResult || !fFields) {
      Error("TOracleRow","GetField(): out-of-range or No RowData/ResultSet/MetaData");
      return 0;
   }
   return (*fFields)[field].c_str();
}

GetFieldLength()

ULong_t TOracleRow::GetFieldLength

(

Int_t

field

)

{
   // Get length in bytes of specified field.
 
   if (!IsValid(field) || fFieldInfo->size() <= 0)
      return 0;
 
   MetaData fieldMD = (*fFieldInfo)[field];
 
   return fieldMD.getInt(MetaData::ATTR_DATA_SIZE);
}

GetRowData()

int TOracleRow::GetRowData ( )

protected

{
   // Fetch a row from current resultset into fFields vector as ASCII
   // supported Oracle internal types conversion:
   // NUMBER -> int, float, double -> (char *)
   // CHAR   -> (char *)
   // VARCHAR2 -> (char *)
   // TIMESTAMP -> Timestamp -> (char *)
   // DATE -> (char *)
   // NOTE: above types are tested to work and this is the default impl.
 
   if (!fFields || !fResult || !fFieldInfo) {
      Error("GetRowData()", "Empty row, resultset or MetaData");
      return 0;
   }
   int fDataType, fDataSize, fPrecision, fScale;
   char str_number[1024];
   int int_val; double double_val; float float_val;
   try {
      for (UInt_t i=0; i<fFieldCount; i++) {
         if (fResult->isNull(i+1)) {
            (*fFields)[i] = "";
         } else {
            fDataType = (*fFieldInfo)[i].getInt(MetaData::ATTR_DATA_TYPE);
            fDataSize = (*fFieldInfo)[i].getInt(MetaData::ATTR_DATA_SIZE);
            fPrecision = (*fFieldInfo)[i].getInt(MetaData::ATTR_PRECISION);
            fScale = (*fFieldInfo)[i].getInt(MetaData::ATTR_SCALE);
            switch (fDataType) {
               case 2: //NUMBER
                  if (fScale == 0 || fPrecision == 0) {
                     int_val = fResult->getInt(i+1);
                     sprintf(str_number, "%d", int_val);
                  } else if (fPrecision != 0 && fScale == -127) {
                     double_val = fResult->getDouble(i+1);
                     sprintf(str_number, "%lf", double_val);
                  } else if (fScale > 0) {
                     float_val = fResult->getFloat(i+1);
                     sprintf(str_number, "%f", float_val);
                  }
                  (*fFields)[i] = str_number;
                  break;
               case 96:  // CHAR
               case 1:   // VARCHAR2
                  (*fFields)[i] = fResult->getString(i+1);
                  break;
               case 187: // TIMESTAMP
               case 232: // TIMESTAMP WITH LOCAL TIMEZONE
               case 188: // TIMESTAMP WITH TIMEZONE
                  (*fFields)[i] = (fResult->getTimestamp(i+1)).toText("MM/DD/YYYY, HH24:MI:SS",0);
                  break;
               case 12: // DATE
                  //to fetch DATE, getDate() does NOT work in occi
                  (*fFields)[i] = fResult->getString(i+1);
                  break;
               default:
                  Error("GetRowData()","Oracle type %d not supported.", fDataType);
                  return 0;
            }
         }
      }
      return 1;
   } catch (SQLException &oraex) {
      Error("GetRowData()", (oraex.getMessage()).c_str());
      return 0;
   }
}

GetRowData2()

int TOracleRow::GetRowData2 ( )

protected

{
   // Fetch a row from current resultset into fFields vector as ASCII.
   // This impl only use getString() to fetch column value.
   // Pro: support all type conversions, indicated by OCCI API doc
   // Con: not tested for each Oracle internal type. it has problem on
   //      Timestamp or Date type conversion.
   // NOTE: This is supposed to be the easiest and direct implemention.
 
   if (!fFields || !fResult || !fFieldInfo) {
      Error("GetRowData2()", "Empty row, resultset or MetaData");
      return 0;
   }
 
   try {
      for (UInt_t i=0; i<fFieldCount; i++) {
         if (fResult->isNull(i+1)) {
            (*fFields)[i] = "";
         } else {
            (*fFields)[i] = fResult->getString(i+1);
         }
      }
      return 1;
   } catch (SQLException &oraex) {
      Error("GetRowData2()", (oraex.getMessage()).c_str());
      return 0;
   }
}

IsValid()

Bool_t TOracleRow::IsValid ( Int_t  field )

private

{
   // Check if row is open and field index within range.
 
   if (!fResult) {
      Error("IsValid", "row closed");
      return kFALSE;
   }
   if (field < 0 || field >= (Int_t)fFieldInfo->size()) {
      Error("IsValid", "field index out of bounds");
      return kFALSE;
   }
   return kTRUE;
}

Member Data Documentation

fFieldCount

UInt_t TOracleRow::fFieldCount

private

fFieldInfo

std::vector<MetaData>* TOracleRow::fFieldInfo

private

fFields

std::vector<std::string>* TOracleRow::fFields

private

fResult

ResultSet* TOracleRow::fResult

private

fResultType

Int_t TOracleRow::fResultType

private

fUpdateCount

UInt_t TOracleRow::fUpdateCount

private

---

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

• src/libEOracle/TOracleRow.h
• src/libEOracle/TOracleRow.cxx