TProofMonSender implementation for the SQL writers.

Definition at line 30 of file TProofMonSenderSQL.h.

Public Member Functions
	TProofMonSenderSQL (const char serv, const char user, const char pass, const char table="proof.proofquerylog", const char dstab=0, const char filestab=0)
	Main constructor. More...

virtual	~TProofMonSenderSQL ()
	Destructor. More...

Int_t	SendDataSetInfo (TDSet , TList , const char , const char )
	Post information about the processed dataset(s). More...

Int_t	SendFileInfo (TDSet , TList , const char , const char )
	Post information about the requested files. More...

Int_t	SendSummary (TList , const char )
	Send 'summary' record for the table 'proofquerylog'. More...

Public Member Functions inherited from TProofMonSender
	TProofMonSender (const char n="Abstract", const char t="ProofMonSender")

virtual	~TProofMonSender ()

Bool_t	IsValid () const

virtual Int_t	SendDataSetInfo (TDSet , TList , const char , const char )=0

virtual Int_t	SendFileInfo (TDSet , TList , const char , const char )=0

virtual Int_t	SendSummary (TList , const char )=0

Int_t	SetSendOptions (const char *)
	Parse send options from string 'sendopts'. More...

Public Member Functions inherited from TNamed
	TNamed ()

	TNamed (const char name, const char title)

	TNamed (const TNamed &named)
	TNamed copy ctor. More...

	TNamed (const TString &name, const TString &title)

virtual	~TNamed ()
	TNamed destructor. More...

virtual void	Clear (Option_t *option="")
	Set name and title to empty strings (""). More...

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 two TNamed objects. More...

virtual void	Copy (TObject &named) const
	Copy this to obj. More...

virtual void	FillBuffer (char *&buffer)
	Encode TNamed into output buffer. More...

virtual const char *	GetName () const
	Returns name of object. More...

virtual const char *	GetTitle () const
	Returns title of object. More...

virtual ULong_t	Hash () const
	Return hash value for this object. More...

virtual Bool_t	IsSortable () const

virtual void	ls (Option_t *option="") const
	List TNamed name and title. More...

TNamed &	operator= (const TNamed &rhs)
	TNamed assignment operator. More...

virtual void	Print (Option_t *option="") const
	Print TNamed name and title. More...

virtual void	SetName (const char *name)
	Set the name of the TNamed. More...

virtual void	SetNameTitle (const char name, const char title)
	Set all the TNamed parameters (name and title). More...

virtual void	SetTitle (const char *title="")
	Set the title of the TNamed. More...

virtual Int_t	Sizeof () const
	Return size of the TNamed part of the TObject. More...

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 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
TString	fDSetSendOpts

TString	fFilesSendOpts

TVirtualMonitoringWriter *	fWriter

Additional Inherited Members
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 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 Types inherited from TProofMonSender
enum	EConfigBits { kSendSummary = BIT(15) , kSendDataSetInfo = BIT(16) , kSendFileInfo = BIT(17) }

Protected Types inherited from TObject
enum	{ kOnlyPrepStep = BIT(3) }

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 TProofMonSender
Int_t	fDataSetInfoVrs

Int_t	fFileInfoVrs

Int_t	fSummaryVrs

Protected Attributes inherited from TNamed
TString	fName

TString	fTitle

#include <TProofMonSenderSQL.h>

Inheritance diagram for TProofMonSenderSQL:

[legend]

Constructor & Destructor Documentation

◆ TProofMonSenderSQL()

TProofMonSenderSQL::TProofMonSenderSQL	(	const char *	serv,
		const char *	user,
		const char *	pass,
		const char *	table = `"proof.proofquerylog"`,
		const char *	dstab = `0`,
		const char *	filestab = `0`
	)

Main constructor.

Definition at line 36 of file TProofMonSenderSQL.cxx.

◆ ~TProofMonSenderSQL()

TProofMonSenderSQL::~TProofMonSenderSQL ( )

virtual

Destructor.

Definition at line 74 of file TProofMonSenderSQL.cxx.

Member Function Documentation

◆ SendDataSetInfo()

Int_t TProofMonSenderSQL::SendDataSetInfo	(	TDSet *	dset,
		TList *	missing,
		const char *	begin,
		const char *	qid
	)

virtual

Post information about the processed dataset(s).

The information is taken from the TDSet object 'dset' and integrated with the missing files information in the list 'missing'. The string 'qid' is the uninque ID of the query; 'begin' the starting time.

The record is formatted for the table 'proofquerydsets'.

There are two versions of this record, with or without the starting time. The starting time could be looked up from the summary record, if available.

The default version 1 corresponds to the table created with the following command:

CREATE TABLE proofquerydsets ( id int(11) NOT NULL auto_increment, dsn varchar(512) NOT NULL, querytag varchar(64) NOT NULL, querybegin datetime default NULL, numfiles int(11) default NULL, missfiles int(11) default NULL, PRIMARY KEY (id), KEY ix_querytag (querytag) );

Version 0 corresponds to the table created with the following command: (no 'querybegin')

CREATE TABLE proofquerydsets ( id int(11) NOT NULL auto_increment, dsn varchar(512) NOT NULL, querytag varchar(64) NOT NULL, numfiles int(11) default NULL, missfiles int(11) default NULL, PRIMARY KEY (id), KEY ix_querytag (querytag) );

The information is posted with a bulk insert.

Returns 0 on success, -1 on failure.

Implements TProofMonSender.

Definition at line 254 of file TProofMonSenderSQL.cxx.

◆ SendFileInfo()

Int_t TProofMonSenderSQL::SendFileInfo	(	TDSet *	dset,
		TList *	missing,
		const char *	begin,
		const char *	qid
	)

virtual

Post information about the requested files.

The information is taken from the TDSet object 'dset' and integrated with the missing files information in the list 'missing'. The string 'qid' is the unique ID of the query; 'begin' the starting time.

The record is formatted for the table 'proofqueryfiles'.

There are two versions of this record, with or without the starting time. The starting time could be looked up from the summary record, if available.

The default version 1 corresponds to the table created with the following command:

CREATE TABLE proofqueryfiles ( id int(11) NOT NULL auto_increment, lfn varchar(255) NOT NULL, path varchar(2048) NOT NULL, querytag varchar(64) NOT NULL, querybegin datetime default NULL, status enum('Ok','Failed') NOT NULL default 'Ok', PRIMARY KEY (id), KEY ix_querytag (querytag) );

Version 0 corresponds to the table created with the following command: (no 'querybegin')

CREATE TABLE proofqueryfiles ( id int(11) NOT NULL auto_increment, lfn varchar(255) NOT NULL, path varchar(2048) NOT NULL, querytag varchar(64) NOT NULL, status enum('Ok','Failed') NOT NULL default 'Ok', PRIMARY KEY (id), KEY ix_querytag (querytag) );

The information is posted with a bulk insert.

Returns 0 on success, -1 on failure.

Implements TProofMonSender.

Definition at line 415 of file TProofMonSenderSQL.cxx.

◆ SendSummary()

Int_t TProofMonSenderSQL::SendSummary	(	TList *	recs,
		const char *	dumid
	)

virtual

Send 'summary' record for the table 'proofquerylog'.

There are three versions of this record, corresponding the evolution in time of the monitoring requirements.

The default version 2 corresponds to the table created with the following command:

CREATE TABLE proofquerylog ( id int(11) NOT NULL auto_increment, proofuser varchar(32) NOT NULL, proofgroup varchar(32) default NULL, querybegin datetime default NULL, queryend datetime default NULL, walltime int(11) default NULL, cputime float default NULL, bytesread bigint(20) default NULL, events bigint(20) default NULL, totevents bigint(20) default NULL, workers int(11) default NULL, querytag varchar(64) NOT NULL, vmemmxw bigint(20) default NULL, rmemmxw bigint(20) default NULL, vmemmxm bigint(20) default NULL, rmemmxm bigint(20) default NULL, numfiles int(11) default NULL, missfiles int(11) default NULL, status int(11) default NULL, rootver varchar(32) NOT NULL, PRIMARY KEY (id) );

Version 1 corresponds to the table created with the following command: ('user','begin','end' instead of 'proofuser', 'querybegin', 'queryend'; no 'status', 'missfiles', 'rootver'; 'dataset' field with name(s) of processed dataset(s))

CREATE TABLE proofquerylog ( id int(11) NOT NULL auto_increment, user varchar(32) NOT NULL, proofgroup varchar(32) default NULL, begin datetime default NULL, end datetime default NULL, walltime int(11) default NULL, cputime float default NULL, bytesread bigint(20) default NULL, events bigint(20) default NULL, totevents bigint(20) default NULL, workers int(11) default NULL, querytag varchar(64) NOT NULL, vmemmxw bigint(20) default NULL, rmemmxw bigint(20) default NULL, vmemmxm bigint(20) default NULL, rmemmxm bigint(20) default NULL, numfiles int(11) default NULL, dataset varchar(512) NOT NULL, PRIMARY KEY (id) );

Implements TProofMonSender.

Definition at line 136 of file TProofMonSenderSQL.cxx.

Member Data Documentation

◆ fDSetSendOpts

TString TProofMonSenderSQL::fDSetSendOpts

private

Definition at line 34 of file TProofMonSenderSQL.h.

◆ fFilesSendOpts

TString TProofMonSenderSQL::fFilesSendOpts

private

Definition at line 35 of file TProofMonSenderSQL.h.

◆ fWriter

TVirtualMonitoringWriter* TProofMonSenderSQL::fWriter

private

Definition at line 33 of file TProofMonSenderSQL.h.

Libraries for TProofMonSenderSQL:

[legend]

Public Member Functions

Private Attributes

Additional Inherited Members

Constructor & Destructor Documentation

◆ TProofMonSenderSQL()

◆ ~TProofMonSenderSQL()

Member Function Documentation

◆ SendDataSetInfo()

◆ SendFileInfo()

◆ SendSummary()

Member Data Documentation

◆ fDSetSendOpts

◆ fFilesSendOpts

◆ fWriter