Logo ROOT   6.18/05
Reference Guide
TPgSQLStatement.h
Go to the documentation of this file.
1// @(#)root/mysql:$Id$
2// Author: Dennis Box (dbox@fnal.gov) 3/12/2007
3
4/*************************************************************************
5 * Copyright (C) 1995-2007, Rene Brun and Fons Rademakers. *
6 * All rights reserved. *
7 * *
8 * For the licensing terms see $ROOTSYS/LICENSE. *
9 * For the list of contributors see $ROOTSYS/README/CREDITS. *
10 *************************************************************************/
11
12#ifndef ROOT_TPgSQLStatement
13#define ROOT_TPgSQLStatement
14
15#include "TSQLStatement.h"
16
17#include <libpq-fe.h>
18#include <pg_config.h> // to get PG_VERSION_NUM
19
20#define pgsql_success(x) (((x) == PGRES_EMPTY_QUERY) \
21 || ((x) == PGRES_COMMAND_OK) \
22 || ((x) == PGRES_TUPLES_OK))
23
25 PGconn *fConn;
26 PGresult *fRes;
27};
28
29
31
32private:
33 PgSQL_Stmt_t *fStmt; //! executed statement
34 Int_t fNumBuffers; //! number of statement parameters
35 char **fBind; //! array of data for input
36 char **fFieldName; //! array of column names
37 Int_t fWorkingMode; //! 1 - setting parameters, 2 - retrieving results
38 Int_t fIterationCount;//! number of iteration
39 int *fParamLengths; //! length of column
40 int *fParamFormats; //! data type (OID)
43
44 Bool_t IsSetParsMode() const { return fWorkingMode==1; }
45 Bool_t IsResultSetMode() const { return fWorkingMode==2; }
46
47 Bool_t SetSQLParamType(Int_t npar, int sqltype, bool sig, int sqlsize = 0);
48
49 long double ConvertToNumeric(Int_t npar);
50 const char *ConvertToString(Int_t npar);
51
52 void FreeBuffers();
54
55 void ConvertTimeToUTC(const TString &PQvalue, Int_t& year, Int_t& month, Int_t& day, Int_t& hour, Int_t& min, Int_t& sec);
56
57public:
59 virtual ~TPgSQLStatement();
60
61 virtual void Close(Option_t * = "");
62
63 virtual Int_t GetBufferLength() const { return 1; }
64 virtual Int_t GetNumParameters();
65
66 virtual Bool_t SetNull(Int_t npar);
67 virtual Bool_t SetInt(Int_t npar, Int_t value);
68 virtual Bool_t SetUInt(Int_t npar, UInt_t value);
69 virtual Bool_t SetLong(Int_t npar, Long_t value);
70 virtual Bool_t SetLong64(Int_t npar, Long64_t value);
71 virtual Bool_t SetULong64(Int_t npar, ULong64_t value);
72 virtual Bool_t SetDouble(Int_t npar, Double_t value);
73 virtual Bool_t SetString(Int_t npar, const char* value, Int_t maxsize = 256);
74 virtual Bool_t SetBinary(Int_t npar, void* mem, Long_t size, Long_t maxsize = 0x1000);
75 virtual Bool_t SetLargeObject(Int_t npar, void* mem, Long_t size, Long_t maxsize = 0x1000);
76 virtual Bool_t SetDate(Int_t npar, Int_t year, Int_t month, Int_t day);
77 virtual Bool_t SetTime(Int_t npar, Int_t hour, Int_t min, Int_t sec);
78 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);
79 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);
80
81 virtual Bool_t NextIteration();
82
83 virtual Bool_t Process();
84 virtual Int_t GetNumAffectedRows();
85
86 virtual Bool_t StoreResult();
87 virtual Int_t GetNumFields();
88 virtual const char *GetFieldName(Int_t nfield);
89 virtual Bool_t NextResultRow();
90
91 virtual Bool_t IsNull(Int_t npar);
92 virtual Int_t GetInt(Int_t npar);
93 virtual UInt_t GetUInt(Int_t npar);
94 virtual Long_t GetLong(Int_t npar);
95 virtual Long64_t GetLong64(Int_t npar);
96 virtual ULong64_t GetULong64(Int_t npar);
97 virtual Double_t GetDouble(Int_t npar);
98 virtual const char *GetString(Int_t npar);
99 virtual Bool_t GetBinary(Int_t npar, void* &mem, Long_t& size);
100 virtual Bool_t GetLargeObject(Int_t npar, void* &mem, Long_t& size);
101 virtual Bool_t GetDate(Int_t npar, Int_t& year, Int_t& month, Int_t& day);
102 virtual Bool_t GetTime(Int_t npar, Int_t& hour, Int_t& min, Int_t& sec);
103 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);
104 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&);
105
106 ClassDef(TPgSQLStatement, 0); // SQL statement class for PgSQL DB
107};
108
109#endif
int Int_t
Definition: RtypesCore.h:41
unsigned int UInt_t
Definition: RtypesCore.h:42
long Long_t
Definition: RtypesCore.h:50
bool Bool_t
Definition: RtypesCore.h:59
double Double_t
Definition: RtypesCore.h:55
long long Long64_t
Definition: RtypesCore.h:69
unsigned long long ULong64_t
Definition: RtypesCore.h:70
const Bool_t kTRUE
Definition: RtypesCore.h:87
const char Option_t
Definition: RtypesCore.h:62
#define ClassDef(name, id)
Definition: Rtypes.h:326
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)
Set parameter value as date & time.
virtual UInt_t GetUInt(Int_t npar)
Return field value as unsigned integer.
PgSQL_Stmt_t * fStmt
virtual Int_t GetBufferLength() const
virtual Int_t GetNumParameters()
Return number of statement parameters.
virtual ULong64_t GetULong64(Int_t npar)
Return field value as unsigned 64-bit integer.
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 &)
Return field value as time stamp.
void ConvertTimeToUTC(const TString &PQvalue, Int_t &year, Int_t &month, Int_t &day, Int_t &hour, Int_t &min, Int_t &sec)
Bool_t SetSQLParamType(Int_t npar, int sqltype, bool sig, int sqlsize=0)
Set parameter type to be used as buffer.
void SetBuffersNumber(Int_t n)
Allocate buffers for statement parameters/ result fields.
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)
Return field value as date & time.
Int_t fNumResultRows
data type (OID)
virtual Bool_t SetBinary(Int_t npar, void *mem, Long_t size, Long_t maxsize=0x1000)
Set parameter value as binary data.
virtual Bool_t SetLargeObject(Int_t npar, void *mem, Long_t size, Long_t maxsize=0x1000)
Set parameter value to large object and immediately insert the large object into DB.
virtual Bool_t SetDate(Int_t npar, Int_t year, Int_t month, Int_t day)
Set parameter value as date.
virtual Bool_t NextIteration()
Increment iteration counter for statement, where parameter can be set.
virtual Bool_t GetLargeObject(Int_t npar, void *&mem, Long_t &size)
Return large object whose oid is in the given field.
long double ConvertToNumeric(Int_t npar)
Convert field to numeric value.
Bool_t IsResultSetMode() const
TPgSQLStatement(PgSQL_Stmt_t *stmt, Bool_t errout=kTRUE)
Normal constructor.
int * fParamLengths
number of iteration
virtual Int_t GetNumFields()
Return number of fields in result set.
virtual Bool_t SetInt(Int_t npar, Int_t value)
Set parameter value as integer.
virtual Bool_t StoreResult()
Store result of statement processing to access them via GetInt(), GetDouble() and so on methods.
virtual Bool_t NextResultRow()
Shift cursor to nect row in result set.
virtual Bool_t SetString(Int_t npar, const char *value, Int_t maxsize=256)
Set parameter value as string.
virtual Bool_t SetLong(Int_t npar, Long_t value)
Set parameter value as long integer.
virtual Bool_t SetTime(Int_t npar, Int_t hour, Int_t min, Int_t sec)
Set parameter value as time.
Int_t fIterationCount
1 - setting parameters, 2 - retrieving results
virtual Int_t GetNumAffectedRows()
Return number of affected rows after statement is processed.
virtual Bool_t SetUInt(Int_t npar, UInt_t value)
Set parameter value as unsigned integer.
virtual Bool_t GetDate(Int_t npar, Int_t &year, Int_t &month, Int_t &day)
Return field value as date.
virtual Int_t GetInt(Int_t npar)
Return field value as integer.
virtual Bool_t SetLong64(Int_t npar, Long64_t value)
Set parameter value as 64-bit integer.
Int_t fNumBuffers
executed statement
Int_t fWorkingMode
array of column names
Bool_t IsSetParsMode() const
virtual Bool_t GetTime(Int_t npar, Int_t &hour, Int_t &min, Int_t &sec)
Return field value as time.
virtual Double_t GetDouble(Int_t npar)
Return field value as double.
virtual Long64_t GetLong64(Int_t npar)
Return field value as 64-bit integer.
virtual const char * GetString(Int_t npar)
Return field value as string.
virtual Bool_t SetULong64(Int_t npar, ULong64_t value)
Set parameter value as unsigned 64-bit integer.
virtual Bool_t Process()
Process statement.
virtual void Close(Option_t *="")
Close statement.
virtual Bool_t GetBinary(Int_t npar, void *&mem, Long_t &size)
Return field value as binary array.
virtual const char * GetFieldName(Int_t nfield)
Returns field name in result set.
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)
Set parameter value as timestamp.
virtual Bool_t SetNull(Int_t npar)
Set NULL as parameter value.
const char * ConvertToString(Int_t npar)
Convert field value to string.
char ** fBind
number of statement parameters
void FreeBuffers()
Release all buffers, used by statement.
virtual ~TPgSQLStatement()
Destructor.
virtual Bool_t SetDouble(Int_t npar, Double_t value)
Set parameter value as double.
int * fParamFormats
length of column
char ** fFieldName
array of data for input
virtual Bool_t IsNull(Int_t npar)
Checks if field value is null.
virtual Long_t GetLong(Int_t npar)
Return field value as long integer.
Basic string class.
Definition: TString.h:131
const Int_t n
Definition: legend1.C:16
PGconn * fConn
PGresult * fRes