TPgSQLStatement Class Reference

#include <TPgSQLStatement.h>

Inheritance diagram for TPgSQLStatement:

TSQLStatement TObject TObject List of all members.

Public Member Functions

 TPgSQLStatement (PgSQL_Stmt_t *stmt, Bool_t errout=kTRUE)
virtual ~TPgSQLStatement ()
virtual void Close (Option_t *="")
virtual Int_t GetBufferLength () const
virtual Int_t GetNumParameters ()
virtual Bool_t SetNull (Int_t npar)
virtual Bool_t SetInt (Int_t npar, Int_t value)
virtual Bool_t SetUInt (Int_t npar, UInt_t value)
virtual Bool_t SetLong (Int_t npar, Long_t value)
virtual Bool_t SetLong64 (Int_t npar, Long64_t value)
virtual Bool_t SetULong64 (Int_t npar, ULong64_t value)
virtual Bool_t SetDouble (Int_t npar, Double_t value)
virtual Bool_t SetString (Int_t npar, const char *value, Int_t maxsize=256)
virtual Bool_t SetBinary (Int_t npar, void *mem, Long_t size, Long_t maxsize=0x1000)
virtual Bool_t SetDate (Int_t npar, Int_t year, Int_t month, Int_t day)
virtual Bool_t SetTime (Int_t npar, Int_t hour, Int_t min, Int_t sec)
virtual Bool_t SetDatime (Int_t npar, Int_t year, Int_t month, Int_t day, Int_t hour, Int_t min, Int_t sec)
virtual Bool_t SetTimestamp (Int_t npar, Int_t year, Int_t month, Int_t day, Int_t hour, Int_t min, Int_t sec, Int_t frac=0)
virtual Bool_t NextIteration ()
virtual Bool_t Process ()
virtual Int_t GetNumAffectedRows ()
virtual Bool_t StoreResult ()
virtual Int_t GetNumFields ()
virtual const char * GetFieldName (Int_t nfield)
virtual Bool_t NextResultRow ()
virtual Bool_t IsNull (Int_t npar)
virtual Int_t GetInt (Int_t npar)
virtual UInt_t GetUInt (Int_t npar)
virtual Long_t GetLong (Int_t npar)
virtual Long64_t GetLong64 (Int_t npar)
virtual ULong64_t GetULong64 (Int_t npar)
virtual Double_t GetDouble (Int_t npar)
virtual const char * GetString (Int_t npar)
virtual Bool_t GetBinary (Int_t npar, void *&mem, Long_t &size)
virtual Bool_t GetDate (Int_t npar, Int_t &year, Int_t &month, Int_t &day)
virtual Bool_t GetTime (Int_t npar, Int_t &hour, Int_t &min, Int_t &sec)
virtual Bool_t GetDatime (Int_t npar, Int_t &year, Int_t &month, Int_t &day, Int_t &hour, Int_t &min, Int_t &sec)
virtual Bool_t GetTimestamp (Int_t npar, Int_t &year, Int_t &month, Int_t &day, Int_t &hour, Int_t &min, Int_t &sec, Int_t &)
 ClassDef (TPgSQLStatement, 0)

Private Member Functions

Bool_t IsSetParsMode () const
Bool_t IsResultSetMode () const
Bool_t SetSQLParamType (Int_t npar, int sqltype, bool sig, int sqlsize=0)
long double ConvertToNumeric (Int_t npar)
const char * ConvertToString (Int_t npar)
void FreeBuffers ()
void SetBuffersNumber (Int_t n)

Private Attributes

PgSQL_Stmt_t * fStmt
Int_t fNumBuffers
 executed statement
char ** fBind
 number of statement parameters
char ** fFieldName
 array of data for input
Int_t fWorkingMode
 array of column names
Int_t fIterationCount
 1 - setting parameters, 2 - retrieving results
int * fParamLengths
 number of iteration
int * fParamFormats
 length of column
Int_t fNumResultRows
 data type (OID)
Int_t fNumResultCols

Detailed Description

Definition at line 46 of file TPgSQLStatement.h.

Constructor & Destructor Documentation

TPgSQLStatement::TPgSQLStatement ( PgSQL_Stmt_t *  stmt,
Bool_t  errout = kTRUE 
)

TPgSQLStatement::~TPgSQLStatement (  )  [virtual]

Definition at line 655 of file TPgSQLStatement.cxx.

Member Function Documentation

Bool_t TPgSQLStatement::IsSetParsMode (  )  const [inline, private]

Definition at line 60 of file TPgSQLStatement.h.

References fWorkingMode.

Bool_t TPgSQLStatement::IsResultSetMode (  )  const [inline, private]

Definition at line 61 of file TPgSQLStatement.h.

References fWorkingMode.

Bool_t TPgSQLStatement::SetSQLParamType ( Int_t  npar,
int  sqltype,
bool  sig,
int  sqlsize = 0 
) [private]

Definition at line 868 of file TPgSQLStatement.cxx.

References kFALSE.

long double TPgSQLStatement::ConvertToNumeric ( Int_t  npar  )  [private]

Definition at line 755 of file TPgSQLStatement.cxx.

const char * TPgSQLStatement::ConvertToString ( Int_t  npar  )  [private]

Definition at line 747 of file TPgSQLStatement.cxx.

void TPgSQLStatement::FreeBuffers (  )  [private]

Definition at line 735 of file TPgSQLStatement.cxx.

void TPgSQLStatement::SetBuffersNumber ( Int_t  n  )  [private]

Definition at line 741 of file TPgSQLStatement.cxx.

void TPgSQLStatement::Close ( Option_t *  = ""  )  [virtual]

Definition at line 661 of file TPgSQLStatement.cxx.

virtual Int_t TPgSQLStatement::GetBufferLength (  )  const [inline, virtual]

Implements TSQLStatement.

Definition at line 77 of file TPgSQLStatement.h.

Int_t TPgSQLStatement::GetNumParameters (  )  [virtual]

Implements TSQLStatement.

Definition at line 683 of file TPgSQLStatement.cxx.

Bool_t TPgSQLStatement::SetNull ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 878 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetInt ( Int_t  npar,
Int_t  value 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 892 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetUInt ( Int_t  npar,
UInt_t  value 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 900 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetLong ( Int_t  npar,
Long_t  value 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 908 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetLong64 ( Int_t  npar,
Long64_t  value 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 916 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetULong64 ( Int_t  npar,
ULong64_t  value 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 924 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetDouble ( Int_t  npar,
Double_t  value 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 932 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetString ( Int_t  npar,
const char *  value,
Int_t  maxsize = 256 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 940 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetBinary ( Int_t  npar,
void *  mem,
Long_t  size,
Long_t  maxsize = 0x1000 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 948 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetDate ( Int_t  npar,
Int_t  year,
Int_t  month,
Int_t  day 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 956 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetTime ( Int_t  npar,
Int_t  hour,
Int_t  min,
Int_t  sec 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 964 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetDatime ( Int_t  npar,
Int_t  year,
Int_t  month,
Int_t  day,
Int_t  hour,
Int_t  min,
Int_t  sec 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 972 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::SetTimestamp ( Int_t  npar,
Int_t  year,
Int_t  month,
Int_t  day,
Int_t  hour,
Int_t  min,
Int_t  sec,
Int_t  frac = 0 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 980 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::NextIteration (  )  [virtual]

Implements TSQLStatement.

Definition at line 725 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::Process (  )  [virtual]

Implements TSQLStatement.

Definition at line 667 of file TPgSQLStatement.cxx.

References kFALSE.

Int_t TPgSQLStatement::GetNumAffectedRows (  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 675 of file TPgSQLStatement.cxx.

Bool_t TPgSQLStatement::StoreResult (  )  [virtual]

Implements TSQLStatement.

Definition at line 691 of file TPgSQLStatement.cxx.

References kFALSE.

Int_t TPgSQLStatement::GetNumFields (  )  [virtual]

Implements TSQLStatement.

Definition at line 700 of file TPgSQLStatement.cxx.

const char * TPgSQLStatement::GetFieldName ( Int_t  nfield  )  [virtual]

Implements TSQLStatement.

Definition at line 708 of file TPgSQLStatement.cxx.

Bool_t TPgSQLStatement::NextResultRow (  )  [virtual]

Implements TSQLStatement.

Definition at line 716 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::IsNull ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 763 of file TPgSQLStatement.cxx.

References kTRUE.

Int_t TPgSQLStatement::GetInt ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 771 of file TPgSQLStatement.cxx.

UInt_t TPgSQLStatement::GetUInt ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 779 of file TPgSQLStatement.cxx.

Long_t TPgSQLStatement::GetLong ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 787 of file TPgSQLStatement.cxx.

Long64_t TPgSQLStatement::GetLong64 ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 795 of file TPgSQLStatement.cxx.

ULong64_t TPgSQLStatement::GetULong64 ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 803 of file TPgSQLStatement.cxx.

Double_t TPgSQLStatement::GetDouble ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 811 of file TPgSQLStatement.cxx.

const char * TPgSQLStatement::GetString ( Int_t  npar  )  [virtual]

Reimplemented from TSQLStatement.

Definition at line 819 of file TPgSQLStatement.cxx.

Bool_t TPgSQLStatement::GetBinary ( Int_t  npar,
void *&  mem,
Long_t &  size 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 827 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::GetDate ( Int_t  npar,
Int_t &  year,
Int_t &  month,
Int_t &  day 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 836 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::GetTime ( Int_t  npar,
Int_t &  hour,
Int_t &  min,
Int_t &  sec 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 844 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::GetDatime ( Int_t  npar,
Int_t &  year,
Int_t &  month,
Int_t &  day,
Int_t &  hour,
Int_t &  min,
Int_t &  sec 
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 852 of file TPgSQLStatement.cxx.

References kFALSE.

Bool_t TPgSQLStatement::GetTimestamp ( Int_t  npar,
Int_t &  year,
Int_t &  month,
Int_t &  day,
Int_t &  hour,
Int_t &  min,
Int_t &  sec,
Int_t &   
) [virtual]

Reimplemented from TSQLStatement.

Definition at line 860 of file TPgSQLStatement.cxx.

References kFALSE.

TPgSQLStatement::ClassDef ( TPgSQLStatement  ,
0   
)

Member Data Documentation

PgSQL_Stmt_t* TPgSQLStatement::fStmt [private]

Definition at line 49 of file TPgSQLStatement.h.

Int_t TPgSQLStatement::fNumBuffers [private]

executed statement

Definition at line 50 of file TPgSQLStatement.h.

char** TPgSQLStatement::fBind [private]

number of statement parameters

Definition at line 51 of file TPgSQLStatement.h.

char** TPgSQLStatement::fFieldName [private]

array of data for input

Definition at line 52 of file TPgSQLStatement.h.

Int_t TPgSQLStatement::fWorkingMode [private]

array of column names

Definition at line 53 of file TPgSQLStatement.h.

Referenced by IsResultSetMode(), and IsSetParsMode().

Int_t TPgSQLStatement::fIterationCount [private]

1 - setting parameters, 2 - retrieving results

Definition at line 54 of file TPgSQLStatement.h.

int* TPgSQLStatement::fParamLengths [private]

number of iteration

Definition at line 55 of file TPgSQLStatement.h.

int* TPgSQLStatement::fParamFormats [private]

length of column

Definition at line 56 of file TPgSQLStatement.h.

Int_t TPgSQLStatement::fNumResultRows [private]

data type (OID)

Definition at line 57 of file TPgSQLStatement.h.

Int_t TPgSQLStatement::fNumResultCols [private]

Definition at line 58 of file TPgSQLStatement.h.

The documentation for this class was generated from the following files:
Generated on Tue Jul 5 16:44:56 2011 for ROOT_528-00b_version by  doxygen 1.5.1