Logo ROOT   6.18/05
Reference Guide
List of all members | Public Member Functions | Private Attributes | List of all members
TPgSQLServer Class Reference

Definition at line 28 of file TPgSQLServer.h.

Public Member Functions

 TPgSQLServer (const char *db, const char *uid, const char *pw)
 Open a connection to a PgSQL DB server. More...
 
 ~TPgSQLServer ()
 Close connection to PgSQL DB server. More...
 
void Close (Option_t *opt="")
 Close connection to PgSQL DB server. More...
 
Int_t CreateDataBase (const char *dbname)
 Create a database. Returns 0 if successful, non-zero otherwise. More...
 
Int_t DropDataBase (const char *dbname)
 Drop (i.e. More...
 
TSQLResultGetColumns (const char *dbname, const char *table, const char *wild=0)
 List all columns in specified table in the specified database. More...
 
TSQLResultGetDataBases (const char *wild=0)
 List all available databases. More...
 
TSQLTableInfoGetTableInfo (const char *tablename)
 Produce TSQLTableInfo. More...
 
TSQLResultGetTables (const char *dbname, const char *wild=0)
 List all tables in the specified database. More...
 
Bool_t HasStatement () const
 PG_VERSION_NUM conveniently only started being #defined at 8.2.3 which is the first version of libpq which explicitly supports prepared statements. More...
 
TSQLResultQuery (const char *sql)
 Execute SQL command. More...
 
Int_t Reload ()
 Reload permission tables. More...
 
Int_t SelectDataBase (const char *dbname)
 Select a database. Returns 0 if successful, non-zero otherwise. More...
 
const char * ServerInfo ()
 Return server info. More...
 
Int_t Shutdown ()
 Shutdown the database server. More...
 
TSQLStatementStatement (const char *sql, Int_t=100)
 Produce TPgSQLStatement. More...
 
- Public Member Functions inherited from TSQLServer
virtual ~TSQLServer ()
 
virtual void Close (Option_t *option="")=0
 
virtual Bool_t Commit ()
 submit "COMMIT" query to database return kTRUE, if successful More...
 
virtual Int_t CreateDataBase (const char *dbname)=0
 
virtual Int_t DropDataBase (const char *dbname)=0
 
virtual void EnableErrorOutput (Bool_t on=kTRUE)
 
virtual Bool_t Exec (const char *sql)
 Execute sql query. More...
 
virtual TSQLResultGetColumns (const char *dbname, const char *table, const char *wild=0)=0
 
virtual TSQLResultGetDataBases (const char *wild=0)=0
 
const char * GetDB () const
 
const char * GetDBMS () const
 
virtual Int_t GetErrorCode () const
 returns error code of last operation if res==0, no error Each specific implementation of TSQLServer provides its own error coding More...
 
virtual const char * GetErrorMsg () const
 returns error message of last operation if no errors, return 0 Each specific implementation of TSQLServer provides its own error messages More...
 
const char * GetHost () const
 
virtual Int_t GetMaxIdentifierLength ()
 
Int_t GetPort () const
 
virtual TSQLTableInfoGetTableInfo (const char *tablename)
 Producec TSQLTableInfo object, which contain info about table itself and each table column Object must be deleted by user. More...
 
virtual TSQLResultGetTables (const char *dbname, const char *wild=0)=0
 
virtual TListGetTablesList (const char *wild=0)
 Return list of user tables Parameter wild specifies wildcard for table names. More...
 
virtual Bool_t HasStatement () const
 
virtual Bool_t HasTable (const char *tablename)
 Tests if table of that name exists in database Return kTRUE, if table exists. More...
 
virtual Bool_t IsConnected () const
 
virtual Bool_t IsError () const
 
virtual Int_t Ping ()
 
virtual Bool_t PingVerify ()
 
virtual TSQLResultQuery (const char *sql)=0
 
virtual Int_t Reload ()=0
 
virtual Bool_t Rollback ()
 submit "ROLLBACK" query to database return kTRUE, if successful More...
 
virtual Int_t SelectDataBase (const char *dbname)=0
 
virtual const char * ServerInfo ()=0
 
virtual Int_t Shutdown ()=0
 
virtual Bool_t StartTransaction ()
 submit "START TRANSACTION" query to database return kTRUE, if successful More...
 
virtual TSQLStatementStatement (const char *, Int_t=100)
 
- Public Member Functions inherited from TObject
 TObject ()
 TObject constructor. More...
 
 TObject (const TObject &object)
 TObject copy ctor. More...
 
virtual ~TObject ()
 TObject destructor. More...
 
void AbstractMethod (const char *method) const
 Use this method to implement an "abstract" method that you don't want to leave purely abstract. More...
 
virtual void AppendPad (Option_t *option="")
 Append graphics object to current pad. More...
 
virtual void Browse (TBrowser *b)
 Browse object. May be overridden for another default action. More...
 
ULong_t CheckedHash ()
 Check and record whether this class has a consistent Hash/RecursiveRemove setup (*) and then return the regular Hash value for this object. More...
 
virtual const char * ClassName () const
 Returns name of class to which the object belongs. More...
 
virtual void Clear (Option_t *="")
 
virtual TObjectClone (const char *newname="") const
 Make a clone of an object using the Streamer facility. More...
 
virtual Int_t Compare (const TObject *obj) const
 Compare abstract method. More...
 
virtual void Copy (TObject &object) const
 Copy this to obj. More...
 
virtual void Delete (Option_t *option="")
 Delete this object. More...
 
virtual Int_t DistancetoPrimitive (Int_t px, Int_t py)
 Computes distance from point (px,py) to the object. More...
 
virtual void Draw (Option_t *option="")
 Default Draw method for all objects. More...
 
virtual void DrawClass () const
 Draw class inheritance tree of the class to which this object belongs. More...
 
virtual TObjectDrawClone (Option_t *option="") const
 Draw a clone of this object in the current selected pad for instance with: gROOT->SetSelectedPad(gPad). More...
 
virtual void Dump () const
 Dump contents of object on stdout. More...
 
virtual void Error (const char *method, const char *msgfmt,...) const
 Issue error message. More...
 
virtual void Execute (const char *method, const char *params, Int_t *error=0)
 Execute method on this object with the given parameter string, e.g. More...
 
virtual void Execute (TMethod *method, TObjArray *params, Int_t *error=0)
 Execute method on this object with parameters stored in the TObjArray. More...
 
virtual void ExecuteEvent (Int_t event, Int_t px, Int_t py)
 Execute action corresponding to an event at (px,py). More...
 
virtual void Fatal (const char *method, const char *msgfmt,...) const
 Issue fatal error message. More...
 
virtual TObjectFindObject (const char *name) const
 Must be redefined in derived classes. More...
 
virtual TObjectFindObject (const TObject *obj) const
 Must be redefined in derived classes. More...
 
virtual Option_tGetDrawOption () const
 Get option used by the graphics system to draw this object. More...
 
virtual const char * GetIconName () const
 Returns mime type name of object. More...
 
virtual const char * GetName () const
 Returns name of object. More...
 
virtual char * GetObjectInfo (Int_t px, Int_t py) const
 Returns string containing info about the object at position (px,py). More...
 
virtual Option_tGetOption () const
 
virtual const char * GetTitle () const
 Returns title of object. More...
 
virtual UInt_t GetUniqueID () const
 Return the unique object id. More...
 
virtual Bool_t HandleTimer (TTimer *timer)
 Execute action in response of a timer timing out. More...
 
virtual ULong_t Hash () const
 Return hash value for this object. More...
 
Bool_t HasInconsistentHash () const
 Return true is the type of this object is known to have an inconsistent setup for Hash and RecursiveRemove (i.e. More...
 
virtual void Info (const char *method, const char *msgfmt,...) const
 Issue info message. More...
 
virtual Bool_t InheritsFrom (const char *classname) const
 Returns kTRUE if object inherits from class "classname". More...
 
virtual Bool_t InheritsFrom (const TClass *cl) const
 Returns kTRUE if object inherits from TClass cl. More...
 
virtual void Inspect () const
 Dump contents of this object in a graphics canvas. More...
 
void InvertBit (UInt_t f)
 
virtual Bool_t IsEqual (const TObject *obj) const
 Default equal comparison (objects are equal if they have the same address in memory). More...
 
virtual Bool_t IsFolder () const
 Returns kTRUE in case object contains browsable objects (like containers or lists of other objects). More...
 
R__ALWAYS_INLINE Bool_t IsOnHeap () const
 
virtual Bool_t IsSortable () const
 
R__ALWAYS_INLINE Bool_t IsZombie () const
 
virtual void ls (Option_t *option="") const
 The ls function lists the contents of a class on stdout. More...
 
void MayNotUse (const char *method) const
 Use this method to signal that a method (defined in a base class) may not be called in a derived class (in principle against good design since a child class should not provide less functionality than its parent, however, sometimes it is necessary). More...
 
virtual Bool_t Notify ()
 This method must be overridden to handle object notification. More...
 
void Obsolete (const char *method, const char *asOfVers, const char *removedFromVers) const
 Use this method to declare a method obsolete. More...
 
void operator delete (void *ptr)
 Operator delete. More...
 
void operator delete[] (void *ptr)
 Operator delete []. More...
 
voidoperator new (size_t sz)
 
voidoperator new (size_t sz, void *vp)
 
voidoperator new[] (size_t sz)
 
voidoperator new[] (size_t sz, void *vp)
 
TObjectoperator= (const TObject &rhs)
 TObject assignment operator. More...
 
virtual void Paint (Option_t *option="")
 This method must be overridden if a class wants to paint itself. More...
 
virtual void Pop ()
 Pop on object drawn in a pad to the top of the display list. More...
 
virtual void Print (Option_t *option="") const
 This method must be overridden when a class wants to print itself. More...
 
virtual Int_t Read (const char *name)
 Read contents of object with specified name from the current directory. More...
 
virtual void RecursiveRemove (TObject *obj)
 Recursively remove this object from a list. More...
 
void ResetBit (UInt_t f)
 
virtual void SaveAs (const char *filename="", Option_t *option="") const
 Save this object in the file specified by filename. More...
 
virtual void SavePrimitive (std::ostream &out, Option_t *option="")
 Save a primitive as a C++ statement(s) on output stream "out". More...
 
void SetBit (UInt_t f)
 
void SetBit (UInt_t f, Bool_t set)
 Set or unset the user status bits as specified in f. More...
 
virtual void SetDrawOption (Option_t *option="")
 Set drawing option for object. More...
 
virtual void SetUniqueID (UInt_t uid)
 Set the unique object id. More...
 
virtual void SysError (const char *method, const char *msgfmt,...) const
 Issue system error message. More...
 
R__ALWAYS_INLINE Bool_t TestBit (UInt_t f) const
 
Int_t TestBits (UInt_t f) const
 
virtual void UseCurrentStyle ()
 Set current style settings in this object This function is called when either TCanvas::UseCurrentStyle or TROOT::ForceStyle have been invoked. More...
 
virtual void Warning (const char *method, const char *msgfmt,...) const
 Issue warning message. More...
 
virtual Int_t Write (const char *name=0, Int_t option=0, Int_t bufsize=0)
 Write this object to the current directory. More...
 
virtual Int_t Write (const char *name=0, Int_t option=0, Int_t bufsize=0) const
 Write this object to the current directory. More...
 

Private Attributes

std::map< Int_t, std::string > fOidTypNameMap
 
PGconn * fPgSQL
 
TString fSrvInfo
 

Additional Inherited Members

- Public Types inherited from TSQLServer
enum  ESQLDataTypes {
  kSQL_NONE = -1 , kSQL_CHAR = 1 , kSQL_VARCHAR = 2 , kSQL_INTEGER = 3 ,
  kSQL_FLOAT = 4 , kSQL_DOUBLE = 5 , kSQL_NUMERIC = 6 , kSQL_BINARY = 7 ,
  kSQL_TIMESTAMP = 8
}
 printf argument for floats and doubles, either "%f" or "%e" or "%10f" and so on More...
 
- Public Types inherited from TObject
enum  {
  kIsOnHeap = 0x01000000 , kNotDeleted = 0x02000000 , kZombie = 0x04000000 , kInconsistent = 0x08000000 ,
  kBitMask = 0x00ffffff
}
 
enum  { kSingleKey = BIT(0) , kOverwrite = BIT(1) , kWriteDelete = BIT(2) }
 
enum  EDeprecatedStatusBits { kObjInCanvas = BIT(3) }
 
enum  EStatusBits {
  kCanDelete = BIT(0) , kMustCleanup = BIT(3) , kIsReferenced = BIT(4) , kHasUUID = BIT(5) ,
  kCannotPick = BIT(6) , kNoContextMenu = BIT(8) , kInvalidObject = BIT(13)
}
 
- Static Public Member Functions inherited from TSQLServer
static TSQLServerConnect (const char *db, const char *uid, const char *pw)
 The db should be of the form: <dbms>://<host>[:<port>][/<database>], e.g. More...
 
static const char * GetFloatFormat ()
 return current printf format for float/double members, default "%e" More...
 
static void SetFloatFormat (const char *fmt="%e")
 set printf format for float/double members, default "%e" More...
 
- Static Public Member Functions inherited from TObject
static Long_t GetDtorOnly ()
 Return destructor only flag. More...
 
static Bool_t GetObjectStat ()
 Get status of object stat flag. More...
 
static void SetDtorOnly (void *obj)
 Set destructor only flag. More...
 
static void SetObjectStat (Bool_t stat)
 Turn on/off tracking of objects in the TObjectTable. More...
 
- Protected Member Functions inherited from TSQLServer
 TSQLServer ()
 
void ClearError ()
 reset error fields More...
 
void SetError (Int_t code, const char *msg, const char *method=0)
 set new values for error fields if method is specified, displays error message More...
 
- Protected Member Functions inherited from TObject
virtual void DoError (int level, const char *location, const char *fmt, va_list va) const
 Interface to ErrorHandler (protected). More...
 
void MakeZombie ()
 
- Protected Attributes inherited from TSQLServer
TString fDB
 
Int_t fErrorCode
 
TString fErrorMsg
 
Bool_t fErrorOut
 
TString fHost
 
Int_t fPort
 
TString fType
 
- Static Protected Attributes inherited from TSQLServer
static const char * fgFloatFmt = "%e"
 

#include <TPgSQLServer.h>

Inheritance diagram for TPgSQLServer:
[legend]

Constructor & Destructor Documentation

◆ TPgSQLServer()

TPgSQLServer::TPgSQLServer ( const char *  db,
const char *  uid,
const char *  pw 
)

Open a connection to a PgSQL DB server.

The db arguments should be of the form "pgsql://<host>[:<port>][/<database>]", e.g.: "pgsql://pcroot.cern.ch:3456/test". The uid is the username and pw the password that should be used for the connection.

Definition at line 38 of file TPgSQLServer.cxx.

◆ ~TPgSQLServer()

TPgSQLServer::~TPgSQLServer ( )

Close connection to PgSQL DB server.

Definition at line 95 of file TPgSQLServer.cxx.

Member Function Documentation

◆ Close()

void TPgSQLServer::Close ( Option_t opt = "")
virtual

Close connection to PgSQL DB server.

Implements TSQLServer.

Definition at line 104 of file TPgSQLServer.cxx.

◆ CreateDataBase()

Int_t TPgSQLServer::CreateDataBase ( const char *  dbname)
virtual

Create a database. Returns 0 if successful, non-zero otherwise.

Implements TSQLServer.

Definition at line 260 of file TPgSQLServer.cxx.

◆ DropDataBase()

Int_t TPgSQLServer::DropDataBase ( const char *  dbname)
virtual

Drop (i.e.

delete) a database. Returns 0 if successful, non-zero otherwise.

Implements TSQLServer.

Definition at line 277 of file TPgSQLServer.cxx.

◆ GetColumns()

TSQLResult * TPgSQLServer::GetColumns ( const char *  dbname,
const char *  table,
const char *  wild = 0 
)
virtual

List all columns in specified table in the specified database.

Wild is for wildcarding "t%" list all columns starting with "t". Returns a pointer to a TSQLResult object if successful, 0 otherwise. The result object must be deleted by the user.

Implements TSQLServer.

Definition at line 228 of file TPgSQLServer.cxx.

◆ GetDataBases()

TSQLResult * TPgSQLServer::GetDataBases ( const char *  wild = 0)
virtual

List all available databases.

Wild is for wildcarding "t%" list all databases starting with "t". Returns a pointer to a TSQLResult object if successful, 0 otherwise. The result object must be deleted by the user.

Implements TSQLServer.

Definition at line 183 of file TPgSQLServer.cxx.

◆ GetTableInfo()

TSQLTableInfo * TPgSQLServer::GetTableInfo ( const char *  tablename)
virtual

Produce TSQLTableInfo.

Reimplemented from TSQLServer.

Definition at line 389 of file TPgSQLServer.cxx.

◆ GetTables()

TSQLResult * TPgSQLServer::GetTables ( const char *  dbname,
const char *  wild = 0 
)
virtual

List all tables in the specified database.

Wild is for wildcarding "t%" list all tables starting with "t". Returns a pointer to a TSQLResult object if successful, 0 otherwise. The result object must be deleted by the user.

Implements TSQLServer.

Definition at line 203 of file TPgSQLServer.cxx.

◆ HasStatement()

Bool_t TPgSQLServer::HasStatement ( ) const
virtual

PG_VERSION_NUM conveniently only started being #defined at 8.2.3 which is the first version of libpq which explicitly supports prepared statements.

Reimplemented from TSQLServer.

Definition at line 338 of file TPgSQLServer.cxx.

◆ Query()

TSQLResult * TPgSQLServer::Query ( const char *  sql)
virtual

Execute SQL command.

Result object must be deleted by the user. Returns a pointer to a TSQLResult object if successful, 0 otherwise. The result object must be deleted by the user.

Implements TSQLServer.

Definition at line 118 of file TPgSQLServer.cxx.

◆ Reload()

Int_t TPgSQLServer::Reload ( )
virtual

Reload permission tables.

Returns 0 if successful, non-zero otherwise. User must have reload permissions.

Implements TSQLServer.

Definition at line 294 of file TPgSQLServer.cxx.

◆ SelectDataBase()

Int_t TPgSQLServer::SelectDataBase ( const char *  dbname)
virtual

Select a database. Returns 0 if successful, non-zero otherwise.

Implements TSQLServer.

Definition at line 141 of file TPgSQLServer.cxx.

◆ ServerInfo()

const char * TPgSQLServer::ServerInfo ( )
virtual

Return server info.

Implements TSQLServer.

Definition at line 323 of file TPgSQLServer.cxx.

◆ Shutdown()

Int_t TPgSQLServer::Shutdown ( )
virtual

Shutdown the database server.

Returns 0 if successful, non-zero otherwise. User must have shutdown permissions.

Implements TSQLServer.

Definition at line 309 of file TPgSQLServer.cxx.

◆ Statement()

TSQLStatement * TPgSQLServer::Statement ( const char *  sql,
Int_t  = 100 
)
virtual

Produce TPgSQLStatement.

Reimplemented from TSQLServer.

Definition at line 353 of file TPgSQLServer.cxx.

Member Data Documentation

◆ fOidTypNameMap

std::map<Int_t,std::string> TPgSQLServer::fOidTypNameMap
private

Definition at line 33 of file TPgSQLServer.h.

◆ fPgSQL

PGconn* TPgSQLServer::fPgSQL
private

Definition at line 31 of file TPgSQLServer.h.

◆ fSrvInfo

TString TPgSQLServer::fSrvInfo
private

Definition at line 32 of file TPgSQLServer.h.

Libraries for TPgSQLServer:
[legend]

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