Definition at line 22 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="") final |
Close connection to PgSQL DB server. More... | |
Int_t | CreateDataBase (const char *dbname) final |
Create a database. Returns 0 if successful, non-zero otherwise. More... | |
Int_t | DropDataBase (const char *dbname) final |
Drop (i.e. More... | |
TSQLResult * | GetColumns (const char *dbname, const char *table, const char *wild=nullptr) final |
List all columns in specified table in the specified database. More... | |
TSQLResult * | GetDataBases (const char *wild=nullptr) final |
List all available databases. More... | |
TSQLTableInfo * | GetTableInfo (const char *tablename) final |
Produce TSQLTableInfo. More... | |
TSQLResult * | GetTables (const char *dbname, const char *wild=nullptr) final |
List all tables in the specified database. More... | |
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. More... | |
TSQLResult * | Query (const char *sql) final |
Execute SQL command. More... | |
Int_t | Reload () final |
Reload permission tables. More... | |
Int_t | SelectDataBase (const char *dbname) final |
Select a database. Returns 0 if successful, non-zero otherwise. More... | |
const char * | ServerInfo () final |
Return server info. More... | |
Int_t | Shutdown () final |
Shutdown the database server. More... | |
TSQLStatement * | Statement (const char *sql, Int_t=100) final |
Produce TPgSQLStatement. More... | |
![]() | |
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 TSQLResult * | GetColumns (const char *dbname, const char *table, const char *wild=nullptr)=0 |
virtual TSQLResult * | GetDataBases (const char *wild=nullptr)=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 TSQLTableInfo * | GetTableInfo (const char *tablename) |
Produce TSQLTableInfo object, which contain info about table itself and each table column Object must be deleted by user. More... | |
virtual TSQLResult * | GetTables (const char *dbname, const char *wild=nullptr)=0 |
virtual TList * | GetTablesList (const char *wild=nullptr) |
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 TSQLResult * | Query (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 TSQLStatement * | Statement (const char *, Int_t=100) |
![]() | |
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 TObject * | Clone (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 TObject * | DrawClone (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 TObject * | FindObject (const char *name) const |
Must be redefined in derived classes. More... | |
virtual TObject * | FindObject (const TObject *obj) const |
Must be redefined in derived classes. More... | |
virtual Option_t * | GetDrawOption () 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_t * | GetOption () 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... | |
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) |
TObject & | operator= (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 {nullptr} |
TString | fSrvInfo |
Additional Inherited Members | |
![]() | |
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... | |
![]() | |
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 TSQLServer * | Connect (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 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... | |
![]() | |
enum | { kOnlyPrepStep = BIT(3) } |
![]() | |
TSQLServer () | |
void | ClearError () |
reset error fields More... | |
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 More... | |
![]() | |
virtual void | DoError (int level, const char *location, const char *fmt, va_list va) const |
Interface to ErrorHandler (protected). More... | |
void | MakeZombie () |
![]() | |
TString | fDB |
Int_t | fErrorCode {0} |
TString | fErrorMsg |
Bool_t | fErrorOut {kTRUE} |
TString | fHost |
Int_t | fPort {-1} |
TString | fType |
![]() | |
static const char * | fgFloatFmt = "%e" |
#include <TPgSQLServer.h>
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 43 of file TPgSQLServer.cxx.
TPgSQLServer::~TPgSQLServer | ( | ) |
Close connection to PgSQL DB server.
Definition at line 100 of file TPgSQLServer.cxx.
Close connection to PgSQL DB server.
Implements TSQLServer.
Definition at line 109 of file TPgSQLServer.cxx.
|
finalvirtual |
Create a database. Returns 0 if successful, non-zero otherwise.
Implements TSQLServer.
Definition at line 265 of file TPgSQLServer.cxx.
|
finalvirtual |
Drop (i.e.
delete) a database. Returns 0 if successful, non-zero otherwise.
Implements TSQLServer.
Definition at line 282 of file TPgSQLServer.cxx.
|
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 233 of file TPgSQLServer.cxx.
|
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 188 of file TPgSQLServer.cxx.
|
finalvirtual |
Produce TSQLTableInfo.
Reimplemented from TSQLServer.
Definition at line 394 of file TPgSQLServer.cxx.
|
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 208 of file TPgSQLServer.cxx.
|
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 343 of file TPgSQLServer.cxx.
|
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 123 of file TPgSQLServer.cxx.
|
finalvirtual |
Reload permission tables.
Returns 0 if successful, non-zero otherwise. User must have reload permissions.
Implements TSQLServer.
Definition at line 299 of file TPgSQLServer.cxx.
|
finalvirtual |
Select a database. Returns 0 if successful, non-zero otherwise.
Implements TSQLServer.
Definition at line 146 of file TPgSQLServer.cxx.
|
finalvirtual |
|
finalvirtual |
Shutdown the database server.
Returns 0 if successful, non-zero otherwise. User must have shutdown permissions.
Implements TSQLServer.
Definition at line 314 of file TPgSQLServer.cxx.
|
finalvirtual |
Produce TPgSQLStatement.
Reimplemented from TSQLServer.
Definition at line 358 of file TPgSQLServer.cxx.
|
private |
Definition at line 27 of file TPgSQLServer.h.
|
private |
Definition at line 25 of file TPgSQLServer.h.
|
private |
Definition at line 26 of file TPgSQLServer.h.