class TPgSQLServer: public TSQLServer

Function Members (Methods)

public:

	TPgSQLServer(const TPgSQLServer&)
	TPgSQLServer(const char* db, const char* uid, const char* pw)
virtual	~TPgSQLServer()
void	TObject::AbstractMethod(const char* method) const
virtual void	TObject::AppendPad(Option_t* option = "")
virtual void	TObject::Browse(TBrowser* b)
static TClass*	Class()
virtual const char*	TObject::ClassName() const
virtual void	TObject::Clear(Option_t* = "")
virtual TObject*	TObject::Clone(const char* newname = "") const
virtual void	Close(Option_t* opt = "")
virtual Bool_t	TSQLServer::Commit()
virtual Int_t	TObject::Compare(const TObject* obj) const
static TSQLServer*	TSQLServer::Connect(const char* db, const char* uid, const char* pw)
virtual void	TObject::Copy(TObject& object) const
virtual Int_t	CreateDataBase(const char* dbname)
virtual void	TObject::Delete(Option_t* option = "")MENU
virtual Int_t	TObject::DistancetoPrimitive(Int_t px, Int_t py)
virtual void	TObject::Draw(Option_t* option = "")
virtual void	TObject::DrawClass() constMENU
virtual TObject*	TObject::DrawClone(Option_t* option = "") constMENU
virtual Int_t	DropDataBase(const char* dbname)
virtual void	TObject::Dump() constMENU
virtual void	TSQLServer::EnableErrorOutput(Bool_t on = kTRUE)
virtual void	TObject::Error(const char* method, const char* msgfmt) const
virtual Bool_t	TSQLServer::Exec(const char* sql)
virtual void	TObject::Execute(const char* method, const char* params, Int_t* error = 0)
virtual void	TObject::Execute(TMethod* method, TObjArray* params, Int_t* error = 0)
virtual void	TObject::ExecuteEvent(Int_t event, Int_t px, Int_t py)
virtual void	TObject::Fatal(const char* method, const char* msgfmt) const
virtual TObject*	TObject::FindObject(const char* name) const
virtual TObject*	TObject::FindObject(const TObject* obj) const
virtual TSQLResult*	GetColumns(const char* dbname, const char* table, const char* wild = 0)
virtual TSQLResult*	GetDataBases(const char* wild = 0)
const char*	TSQLServer::GetDB() const
const char*	TSQLServer::GetDBMS() const
virtual Option_t*	TObject::GetDrawOption() const
static Long_t	TObject::GetDtorOnly()
virtual Int_t	TSQLServer::GetErrorCode() const
virtual const char*	TSQLServer::GetErrorMsg() const
static const char*	TSQLServer::GetFloatFormat()
const char*	TSQLServer::GetHost() const
virtual const char*	TObject::GetIconName() const
virtual Int_t	TSQLServer::GetMaxIdentifierLength()
virtual const char*	TObject::GetName() const
virtual char*	TObject::GetObjectInfo(Int_t px, Int_t py) const
static Bool_t	TObject::GetObjectStat()
virtual Option_t*	TObject::GetOption() const
Int_t	TSQLServer::GetPort() const
virtual TSQLTableInfo*	GetTableInfo(const char* tablename)
virtual TSQLResult*	GetTables(const char* dbname, const char* wild = 0)
virtual TList*	TSQLServer::GetTablesList(const char* wild = 0)
virtual const char*	TObject::GetTitle() const
virtual UInt_t	TObject::GetUniqueID() const
virtual Bool_t	TObject::HandleTimer(TTimer* timer)
virtual ULong_t	TObject::Hash() const
virtual Bool_t	HasStatement() const
virtual Bool_t	TSQLServer::HasTable(const char* tablename)
virtual void	TObject::Info(const char* method, const char* msgfmt) const
virtual Bool_t	TObject::InheritsFrom(const char* classname) const
virtual Bool_t	TObject::InheritsFrom(const TClass* cl) const
virtual void	TObject::Inspect() constMENU
void	TObject::InvertBit(UInt_t f)
virtual TClass*	IsA() const
virtual Bool_t	TSQLServer::IsConnected() const
virtual Bool_t	TObject::IsEqual(const TObject* obj) const
virtual Bool_t	TSQLServer::IsError() const
virtual Bool_t	TObject::IsFolder() const
Bool_t	TObject::IsOnHeap() const
virtual Bool_t	TObject::IsSortable() const
Bool_t	TObject::IsZombie() const
virtual void	TObject::ls(Option_t* option = "") const
void	TObject::MayNotUse(const char* method) const
virtual Bool_t	TObject::Notify()
void	TObject::Obsolete(const char* method, const char* asOfVers, const char* removedFromVers) const
static void	TObject::operator delete(void* ptr)
static void	TObject::operator delete(void* ptr, void* vp)
static void	TObject::operator delete[](void* ptr)
static void	TObject::operator delete[](void* ptr, void* vp)
void*	TObject::operator new(size_t sz)
void*	TObject::operator new(size_t sz, void* vp)
void*	TObject::operator new[](size_t sz)
void*	TObject::operator new[](size_t sz, void* vp)
TPgSQLServer&	operator=(const TPgSQLServer&)
virtual void	TObject::Paint(Option_t* option = "")
virtual Int_t	TSQLServer::Ping()
virtual Bool_t	TSQLServer::PingVerify()
virtual void	TObject::Pop()
virtual void	TObject::Print(Option_t* option = "") const
virtual TSQLResult*	Query(const char* sql)
virtual Int_t	TObject::Read(const char* name)
virtual void	TObject::RecursiveRemove(TObject* obj)
virtual Int_t	Reload()
void	TObject::ResetBit(UInt_t f)
virtual Bool_t	TSQLServer::Rollback()
virtual void	TObject::SaveAs(const char* filename = "", Option_t* option = "") constMENU
virtual void	TObject::SavePrimitive(basic_ostream<char,char_traits<char> >& out, Option_t* option = "")
virtual Int_t	SelectDataBase(const char* dbname)
virtual const char*	ServerInfo()
void	TObject::SetBit(UInt_t f)
void	TObject::SetBit(UInt_t f, Bool_t set)
virtual void	TObject::SetDrawOption(Option_t* option = "")MENU
static void	TObject::SetDtorOnly(void* obj)
static void	TSQLServer::SetFloatFormat(const char* fmt = "%e")
static void	TObject::SetObjectStat(Bool_t stat)
virtual void	TObject::SetUniqueID(UInt_t uid)
virtual void	ShowMembers(TMemberInspector&)
virtual Int_t	Shutdown()
virtual Bool_t	TSQLServer::StartTransaction()
virtual TSQLStatement*	Statement(const char* sql, Int_t = 100)
virtual void	Streamer(TBuffer&)
void	StreamerNVirtual(TBuffer& ClassDef_StreamerNVirtual_b)
virtual void	TObject::SysError(const char* method, const char* msgfmt) const
Bool_t	TObject::TestBit(UInt_t f) const
Int_t	TObject::TestBits(UInt_t f) const
virtual void	TObject::UseCurrentStyle()
virtual void	TObject::Warning(const char* method, const char* msgfmt) const
virtual Int_t	TObject::Write(const char* name = 0, Int_t option = 0, Int_t bufsize = 0)
virtual Int_t	TObject::Write(const char* name = 0, Int_t option = 0, Int_t bufsize = 0) const

protected:

void	TSQLServer::ClearError()
virtual void	TObject::DoError(int level, const char* location, const char* fmt, va_list va) const
void	TObject::MakeZombie()
void	TSQLServer::SetError(Int_t code, const char* msg, const char* method = 0)

Data Members

public:

enum TSQLServer::ESQLDataTypes {	kSQL_NONE
	kSQL_CHAR
	kSQL_VARCHAR
	kSQL_INTEGER
	kSQL_FLOAT
	kSQL_DOUBLE
	kSQL_NUMERIC
	kSQL_BINARY
	kSQL_TIMESTAMP
};
enum TObject::EStatusBits {	kCanDelete
	kMustCleanup
	kObjInCanvas
	kIsReferenced
	kHasUUID
	kCannotPick
	kNoContextMenu
	kInvalidObject
};
enum TObject::[unnamed] {	kIsOnHeap
	kNotDeleted
	kZombie
	kBitMask
	kSingleKey
	kOverwrite
	kWriteDelete
};

protected:

TString	TSQLServer::fDB	currently selected DB
Int_t	TSQLServer::fErrorCode	error code of last operation
TString	TSQLServer::fErrorMsg	error message of last operation
Bool_t	TSQLServer::fErrorOut	enable error output
TString	TSQLServer::fHost	host to which we are connected
Int_t	TSQLServer::fPort	port to which we are connected
TString	TSQLServer::fType	type of DBMS (MySQL, Oracle, SysBase, ...)
static const char*	TSQLServer::fgFloatFmt	! printf argument for floats and doubles, either "%f" or "%e" or "%10f" and so on

private:

map<Int_t,std::string>	fOidTypNameMap	Map of oid to typname, used in GetTableInfo()
PGconn*	fPgSQL	connection to PgSQL server
TString	fSrvInfo	Server info

Class Charts

Inheritance Inherited Members Includes Libraries

Function documentation

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.

~TPgSQLServer()

 Close connection to PgSQL DB server.

void Close(Option_t* opt = "")

 Close connection to PgSQL DB server.

TSQLResult * Query(const char* sql)

 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.

Int_t SelectDataBase(const char* dbname)

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

TSQLResult * GetDataBases(const char* wild = 0)

 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.

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

 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.

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

 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.

Int_t CreateDataBase(const char* dbname)

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

Int_t DropDataBase(const char* dbname)

 Drop (i.e. delete) a database. Returns 0 if successful, non-zero
 otherwise.

Int_t Reload()

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

Int_t Shutdown()

 Shutdown the database server. Returns 0 if successful, non-zero
 otherwise. User must have shutdown permissions.

const char * ServerInfo()

 Return server info.

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

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

 Produce TPgSQLStatement.

TSQLTableInfo * GetTableInfo(const char* tablename)

 Produce TSQLTableInfo.

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