TOracleResult Class Reference

#include <TOracleResult.h>

Inheritance diagram for TOracleResult:

Collaboration diagram for TOracleResult:

Public Member Functions
void	Close (Option_t *opt="")
Int_t	GetFieldCount ()
const char *	GetFieldName (Int_t field)
TSQLRow *	Next ()
	TOracleResult (Connection *conn, const char *tableName)
	TOracleResult (Statement *stmt)
	TOracleResult (Statement *stmt, int row_count)
	~TOracleResult ()

Protected Member Functions
void	GetMetaDataInfo ()
void	initResultSet (Statement *stmt)

Private Member Functions
Bool_t	IsValid (Int_t field)

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

Constructor & Destructor Documentation

TOracleResult() [1/3]

TOracleResult::TOracleResult

(

Statement *

stmt

)

{
   initResultSet(stmt);
}

TOracleResult() [2/3]

TOracleResult::TOracleResult	(	Statement *	stmt,
		int	row_count
	)

{
   initResultSet(stmt);
   // override fRowCount set by initResultSet()
   fRowCount = (row_count==-1)?0:row_count;
}

TOracleResult() [3/3]

TOracleResult::TOracleResult	(	Connection *	conn,
		const char *	tableName
	)

{
   if (!tableName || !conn) {
      Error("TOracleResult", "construction: empty input parameter");
      fResultType = -1;
   } else {
      MetaData connMD = conn->getMetaData(tableName, MetaData::PTYPE_TABLE);
      fFieldInfo = new vector<MetaData>(connMD.getVector(MetaData::ATTR_LIST_COLUMNS));
      fFieldCount = fFieldInfo->size();
      fRowCount = 0;
      fResult = 0;
      fUpdateCount = 0;
      fResultType = 1;
   }
}

~TOracleResult()

TOracleResult::~TOracleResult

(

)

{
   // Cleanup Oracle query result.
 
   if (fResult)
      Close();
}

Member Function Documentation

Close()

void TOracleResult::Close

(

Option_t *

opt = ""

)

{
   // Close query result.
 
   if (!fResult || !fStmt)
      return;
   fResultType = -1;
   fStmt->closeResultSet(fResult);
   fResult    = 0;
   if (fFieldInfo)
      delete fFieldInfo;
   fRowCount  = 0;
}

GetFieldCount()

Int_t TOracleResult::GetFieldCount

(

)

{
   // Get number of fields in result.
 
   return fFieldCount;
}

GetFieldName()

const char * TOracleResult::GetFieldName

(

Int_t

field

)

{
   // Get name of specified field.
 
   if (!IsValid(field))
      return 0;
   string s = (*fFieldInfo)[field].getString(MetaData::ATTR_NAME);
   return (const char *)s.c_str();
}

GetMetaDataInfo()

void TOracleResult::GetMetaDataInfo ( )

protected

initResultSet()

void TOracleResult::initResultSet ( Statement *  stmt )

protected

{
   // Oracle query result.
 
   if (!stmt) {
      Error("initResultSet()", "construction: empty statement");
      fResultType = -1;
   } else {
      try {
         fStmt = stmt;
         if (stmt->status() == Statement::RESULT_SET_AVAILABLE) {
            fResultType = 1;
            fResult    = stmt->getResultSet();
            GetMetaDataInfo();
            fUpdateCount = 0;
            //printf("type:%d columnsize:%d \n", fResultType, fFieldCount);
         } else if (stmt->status() == Statement::UPDATE_COUNT_AVAILABLE) {
            fResultType = 0;
            fResult    = 0;
            fRowCount  = 0;
            fFieldInfo = 0;
            fFieldCount= 0;
            fUpdateCount = stmt->getUpdateCount();
         } else {
            fResultType = -1;
         }
      } catch (SQLException &oraex) {
         Error("initResultSet()", (oraex.getMessage()).c_str());
         MakeZombie();
      }
   }
}

IsValid()

Bool_t TOracleResult::IsValid ( Int_t  field )

private

{
   // Check if result set is open and field index within range.
 
   if (field < 0 || field >= fFieldCount) {
      Error("IsValid", "field index out of bounds");
      return kFALSE;
   }
   return kTRUE;
}

Next()

TSQLRow * TOracleResult::Next

(

)

{
   // Get next query result row. The returned object must be
   // deleted by the user.
 
   if (fResultType == -1) {
      Error("Next", "result set closed");
      return 0;
   }
 
   if (fResultType == 0) {
      // if dml query, ...
      return new TOracleRow(fUpdateCount);
   }
 
   // if select query,
   try {
      if (fResult->next()) {
         return new TOracleRow(fResult, fFieldInfo);
      } else
         return 0;
   } catch (SQLException &oraex) {
      Error("Next()", (oraex.getMessage()).c_str());
      MakeZombie();
   }
   return 0;
}

Member Data Documentation

fFieldCount

Int_t TOracleResult::fFieldCount

private

fFieldInfo

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

private

fResult

ResultSet* TOracleResult::fResult

private

fResultType

Int_t TOracleResult::fResultType

private

fStmt

Statement* TOracleResult::fStmt

private

fUpdateCount

UInt_t TOracleResult::fUpdateCount

private

---

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

• src/libEOracle/TOracleResult.h
• src/libEOracle/TOracleResult.cxx