Logo ROOT  
Reference Guide
 
Loading...
Searching...
No Matches
TPgSQLServer Class Reference

Definition at line 23 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.
 
 ~TPgSQLServer ()
 Close connection to PgSQL DB server.
 
void Close (Option_t *opt="") final
 Close connection to PgSQL DB server.
 
Int_t CreateDataBase (const char *dbname) final
 Create a database. Returns 0 if successful, non-zero otherwise.
 
Int_t DropDataBase (const char *dbname) final
 Drop (i.e.
 
TSQLResultGetColumns (const char *dbname, const char *table, const char *wild=nullptr) final
 List all columns in specified table in the specified database.
 
TSQLResultGetDataBases (const char *wild=nullptr) final
 List all available databases.
 
TSQLTableInfoGetTableInfo (const char *tablename) final
 Produce TSQLTableInfo.
 
TSQLResultGetTables (const char *dbname, const char *wild=nullptr) final
 List all tables in the specified database.
 
Bool_t HasStatement () const final
 PG_VERSION_NUM conveniently only started being #defined at 8.2.3 which is the first version of libpq which explicitly supports prepared statements.
 
TSQLResultQuery (const char *sql) final
 Execute SQL command.
 
Int_t Reload () final
 Reload permission tables.
 
Int_t SelectDataBase (const char *dbname) final
 Select a database. Returns 0 if successful, non-zero otherwise.
 
const char * ServerInfo () final
 Return server info.
 
Int_t Shutdown () final
 Shutdown the database server.
 
TSQLStatementStatement (const char *sql, Int_t=100) final
 Produce TPgSQLStatement.
 
- Public Member Functions inherited from TSQLServer
virtual ~TSQLServer ()
 
virtual Bool_t Commit ()
 submit "COMMIT" query to database return kTRUE, if successful
 
virtual void EnableErrorOutput (Bool_t on=kTRUE)
 
virtual Bool_t Exec (const char *sql)
 Execute sql query.
 
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
 
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
 
const char * GetHost () const
 
virtual Int_t GetMaxIdentifierLength ()
 
Int_t GetPort () const
 
virtual TListGetTablesList (const char *wild=nullptr)
 Return list of user tables Parameter wild specifies wildcard for table names.
 
virtual Bool_t HasTable (const char *tablename)
 Tests if table of that name exists in database Return kTRUE, if table exists.
 
virtual Bool_t HasTransactionInFlight ()
 returns kTRUE when transaction is running Must be implemented in derived classes
 
TClassIsA () const override
 
virtual Bool_t IsConnected () const
 
virtual Bool_t IsError () const
 
virtual Int_t Ping ()
 
virtual Bool_t PingVerify ()
 
virtual Bool_t Rollback ()
 submit "ROLLBACK" query to database return kTRUE, if successful
 
virtual Bool_t StartTransaction ()
 submit "START TRANSACTION" query to database return kTRUE, if successful
 
void Streamer (TBuffer &) override
 Stream an object of class TObject.
 
void StreamerNVirtual (TBuffer &ClassDef_StreamerNVirtual_b)
 
- Public Member Functions inherited from TObject
 TObject ()
 TObject constructor.
 
 TObject (const TObject &object)
 TObject copy ctor.
 
virtual ~TObject ()
 TObject destructor.
 
void AbstractMethod (const char *method) const
 Use this method to implement an "abstract" method that you don't want to leave purely abstract.
 
virtual void AppendPad (Option_t *option="")
 Append graphics object to current pad.
 
virtual void Browse (TBrowser *b)
 Browse object. May be overridden for another default action.
 
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.
 
virtual const char * ClassName () const
 Returns name of class to which the object belongs.
 
virtual void Clear (Option_t *="")
 
virtual TObjectClone (const char *newname="") const
 Make a clone of an object using the Streamer facility.
 
virtual Int_t Compare (const TObject *obj) const
 Compare abstract method.
 
virtual void Copy (TObject &object) const
 Copy this to obj.
 
virtual void Delete (Option_t *option="")
 Delete this object.
 
virtual Int_t DistancetoPrimitive (Int_t px, Int_t py)
 Computes distance from point (px,py) to the object.
 
virtual void Draw (Option_t *option="")
 Default Draw method for all objects.
 
virtual void DrawClass () const
 Draw class inheritance tree of the class to which this object belongs.
 
virtual TObjectDrawClone (Option_t *option="") const
 Draw a clone of this object in the current selected pad with: gROOT->SetSelectedPad(c1).
 
virtual void Dump () const
 Dump contents of object on stdout.
 
virtual void Error (const char *method, const char *msgfmt,...) const
 Issue error message.
 
virtual void Execute (const char *method, const char *params, Int_t *error=nullptr)
 Execute method on this object with the given parameter string, e.g.
 
virtual void Execute (TMethod *method, TObjArray *params, Int_t *error=nullptr)
 Execute method on this object with parameters stored in the TObjArray.
 
virtual void ExecuteEvent (Int_t event, Int_t px, Int_t py)
 Execute action corresponding to an event at (px,py).
 
virtual void Fatal (const char *method, const char *msgfmt,...) const
 Issue fatal error message.
 
virtual TObjectFindObject (const char *name) const
 Must be redefined in derived classes.
 
virtual TObjectFindObject (const TObject *obj) const
 Must be redefined in derived classes.
 
virtual Option_tGetDrawOption () const
 Get option used by the graphics system to draw this object.
 
virtual const char * GetIconName () const
 Returns mime type name of object.
 
virtual const char * GetName () const
 Returns name of object.
 
virtual char * GetObjectInfo (Int_t px, Int_t py) const
 Returns string containing info about the object at position (px,py).
 
virtual Option_tGetOption () const
 
virtual const char * GetTitle () const
 Returns title of object.
 
virtual UInt_t GetUniqueID () const
 Return the unique object id.
 
virtual Bool_t HandleTimer (TTimer *timer)
 Execute action in response of a timer timing out.
 
virtual ULong_t Hash () const
 Return hash value for this object.
 
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.
 
virtual void Info (const char *method, const char *msgfmt,...) const
 Issue info message.
 
virtual Bool_t InheritsFrom (const char *classname) const
 Returns kTRUE if object inherits from class "classname".
 
virtual Bool_t InheritsFrom (const TClass *cl) const
 Returns kTRUE if object inherits from TClass cl.
 
virtual void Inspect () const
 Dump contents of this object in a graphics canvas.
 
void InvertBit (UInt_t f)
 
Bool_t IsDestructed () const
 IsDestructed.
 
virtual Bool_t IsEqual (const TObject *obj) const
 Default equal comparison (objects are equal if they have the same address in memory).
 
virtual Bool_t IsFolder () const
 Returns kTRUE in case object contains browsable objects (like containers or lists of other objects).
 
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.
 
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).
 
virtual Bool_t Notify ()
 This method must be overridden to handle object notification (the base implementation is no-op).
 
void Obsolete (const char *method, const char *asOfVers, const char *removedFromVers) const
 Use this method to declare a method obsolete.
 
void operator delete (void *ptr)
 Operator delete.
 
void operator delete (void *ptr, void *vp)
 Only called by placement new when throwing an exception.
 
void operator delete[] (void *ptr)
 Operator delete [].
 
void operator delete[] (void *ptr, void *vp)
 Only called by placement new[] when throwing an exception.
 
void * operator new (size_t sz)
 
void * operator new (size_t sz, void *vp)
 
void * operator new[] (size_t sz)
 
void * operator new[] (size_t sz, void *vp)
 
TObjectoperator= (const TObject &rhs)
 TObject assignment operator.
 
virtual void Paint (Option_t *option="")
 This method must be overridden if a class wants to paint itself.
 
virtual void Pop ()
 Pop on object drawn in a pad to the top of the display list.
 
virtual void Print (Option_t *option="") const
 This method must be overridden when a class wants to print itself.
 
virtual Int_t Read (const char *name)
 Read contents of object with specified name from the current directory.
 
virtual void RecursiveRemove (TObject *obj)
 Recursively remove this object from a list.
 
void ResetBit (UInt_t f)
 
virtual void SaveAs (const char *filename="", Option_t *option="") const
 Save this object in the file specified by filename.
 
virtual void SavePrimitive (std::ostream &out, Option_t *option="")
 Save a primitive as a C++ statement(s) on output stream "out".
 
void SetBit (UInt_t f)
 
void SetBit (UInt_t f, Bool_t set)
 Set or unset the user status bits as specified in f.
 
virtual void SetDrawOption (Option_t *option="")
 Set drawing option for object.
 
virtual void SetUniqueID (UInt_t uid)
 Set the unique object id.
 
void StreamerNVirtual (TBuffer &ClassDef_StreamerNVirtual_b)
 
virtual void SysError (const char *method, const char *msgfmt,...) const
 Issue system error message.
 
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.
 
virtual void Warning (const char *method, const char *msgfmt,...) const
 Issue warning message.
 
virtual Int_t Write (const char *name=nullptr, Int_t option=0, Int_t bufsize=0)
 Write this object to the current directory.
 
virtual Int_t Write (const char *name=nullptr, Int_t option=0, Int_t bufsize=0) const
 Write this object to the current directory.
 

Private Attributes

std::map< Int_t, std::string > fOidTypNameMap
 
PGconnfPgSQL {nullptr}
 
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 = (1ULL << ( 0 )) , kOverwrite = (1ULL << ( 1 )) , kWriteDelete = (1ULL << ( 2 )) }
 
enum  EDeprecatedStatusBits { kObjInCanvas = (1ULL << ( 3 )) }
 
enum  EStatusBits {
  kCanDelete = (1ULL << ( 0 )) , kMustCleanup = (1ULL << ( 3 )) , kIsReferenced = (1ULL << ( 4 )) , kHasUUID = (1ULL << ( 5 )) ,
  kCannotPick = (1ULL << ( 6 )) , kNoContextMenu = (1ULL << ( 8 )) , kInvalidObject = (1ULL << ( 13 ))
}
 
- Static Public Member Functions inherited from TSQLServer
static TClassClass ()
 
static const char * Class_Name ()
 
static constexpr Version_t Class_Version ()
 
static TSQLServerConnect (const char *db, const char *uid, const char *pw)
 The db should be of the form: <dbms>://<host>[:<port>][/<database>], e.g.: mysql://pcroot.cern.ch:3456/test, oracle://srv1.cern.ch/main, pgsql://... or sqlite://<database>... The uid is the username and pw the password that should be used for the connection.
 
static const char * DeclFileName ()
 
static const char * GetFloatFormat ()
 return current printf format for float/double members, default "%e"
 
static void SetFloatFormat (const char *fmt="%e")
 set printf format for float/double members, default "%e"
 
- Static Public Member Functions inherited from TObject
static TClassClass ()
 
static const char * Class_Name ()
 
static constexpr Version_t Class_Version ()
 
static const char * DeclFileName ()
 
static Longptr_t GetDtorOnly ()
 Return destructor only flag.
 
static Bool_t GetObjectStat ()
 Get status of object stat flag.
 
static void SetDtorOnly (void *obj)
 Set destructor only flag.
 
static void SetObjectStat (Bool_t stat)
 Turn on/off tracking of objects in the TObjectTable.
 
- Protected Types inherited from TObject
enum  { kOnlyPrepStep = (1ULL << ( 3 )) }
 
- Protected Member Functions inherited from TSQLServer
 TSQLServer ()
 
void ClearError ()
 reset error fields
 
void SetError (Int_t code, const char *msg, const char *method=nullptr)
 set new values for error fields if method is specified, displays error message
 
- 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).
 
void MakeZombie ()
 
- Protected Attributes inherited from TSQLServer
TString fDB
 
Int_t fErrorCode {0}
 
TString fErrorMsg
 
Bool_t fErrorOut {kTRUE}
 
TString fHost
 
Int_t fPort {-1}
 
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 46 of file TPgSQLServer.cxx.

◆ ~TPgSQLServer()

TPgSQLServer::~TPgSQLServer ( )

Close connection to PgSQL DB server.

Definition at line 103 of file TPgSQLServer.cxx.

Member Function Documentation

◆ Close()

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

Close connection to PgSQL DB server.

Implements TSQLServer.

Definition at line 112 of file TPgSQLServer.cxx.

◆ CreateDataBase()

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

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

Implements TSQLServer.

Definition at line 267 of file TPgSQLServer.cxx.

◆ DropDataBase()

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

Drop (i.e.

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

Implements TSQLServer.

Definition at line 284 of file TPgSQLServer.cxx.

◆ GetColumns()

TSQLResult * TPgSQLServer::GetColumns ( const char *  dbname,
const char *  table,
const char *  wild = nullptr 
)
finalvirtual

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 235 of file TPgSQLServer.cxx.

◆ GetDataBases()

TSQLResult * TPgSQLServer::GetDataBases ( const char *  wild = nullptr)
finalvirtual

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 190 of file TPgSQLServer.cxx.

◆ GetTableInfo()

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

Produce TSQLTableInfo.

Reimplemented from TSQLServer.

Definition at line 396 of file TPgSQLServer.cxx.

◆ GetTables()

TSQLResult * TPgSQLServer::GetTables ( const char *  dbname,
const char *  wild = nullptr 
)
finalvirtual

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 210 of file TPgSQLServer.cxx.

◆ HasStatement()

Bool_t TPgSQLServer::HasStatement ( ) const
finalvirtual

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 345 of file TPgSQLServer.cxx.

◆ Query()

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

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 126 of file TPgSQLServer.cxx.

◆ Reload()

Int_t TPgSQLServer::Reload ( )
finalvirtual

Reload permission tables.

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

Implements TSQLServer.

Definition at line 301 of file TPgSQLServer.cxx.

◆ SelectDataBase()

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

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

Implements TSQLServer.

Definition at line 148 of file TPgSQLServer.cxx.

◆ ServerInfo()

const char * TPgSQLServer::ServerInfo ( )
finalvirtual

Return server info.

Implements TSQLServer.

Definition at line 330 of file TPgSQLServer.cxx.

◆ Shutdown()

Int_t TPgSQLServer::Shutdown ( )
finalvirtual

Shutdown the database server.

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

Implements TSQLServer.

Definition at line 316 of file TPgSQLServer.cxx.

◆ Statement()

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

Produce TPgSQLStatement.

Reimplemented from TSQLServer.

Definition at line 360 of file TPgSQLServer.cxx.

Member Data Documentation

◆ fOidTypNameMap

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

Definition at line 28 of file TPgSQLServer.h.

◆ fPgSQL

PGconn* TPgSQLServer::fPgSQL {nullptr}
private

Definition at line 26 of file TPgSQLServer.h.

◆ fSrvInfo

TString TPgSQLServer::fSrvInfo
private

Definition at line 27 of file TPgSQLServer.h.

Libraries for TPgSQLServer:

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