![]() |
ROOT 6.12/07 Reference Guide |
Access an SQL db via the TFile interface.
The main motivation for the TSQLFile development is to have "transparent" access to SQL data base via standard TFile interface. The main approach that each class (but not each object) has one or two tables with names like _ver6-12 and _raw6-12 For example: TAxis_ver8 or TList_raw5 Second kind of tables appears, when some of class members can not be converted to normalized form or when class has custom streamer. For instance, for TH1 class two tables are required: TH1_ver4 and TH1_raw4 Most of members are stored in TH1_ver4 table column-wise, and only member: Double_t* fBuffer; //[fBufferSize] can not be represented as column while size of array is not fixed. Therefore, fBuffer will be written as list of values in TH1_raw4 table. All objects, stored in the DB, will be registered in table "ObjectsTable". In this there are following columns:
Name | Description |
---|---|
"key:id" | key identifier to which belong object |
"obj:id" | object identifier |
"Class" | object class name |
"Version" | object class version |
Data in each "ObjectsTable" row uniquely identify, in which table and which column object is stored.
In normal situation all class data should be sorted column-wise. Up to now following member are supported:
All conversion to SQL statements are done with help of TSQLStructure class. This is special hierarchical structure wich internally is very similar to XML structures. TBufferSQL2 creates these structures, when object data is streamed by ROOT and only afterwards all SQL statements will be produced and applied all together. When data is reading, TBufferSQL2 will produce requests to database during unstreaming of object data. Optionally (default this options on) name of column includes suffix which indicates type of column. For instance:
Name | Description |
---|---|
*:parent | parent class, column contain class version |
*:object | other object, column contain object id |
*:rawdata | raw data, column contains id of raw data from streamer table |
*:Int_t | column with integer value |
Use TSQLFile::SetUseSuffixes(kFALSE) to disable suffixes usage. This and several other options can be changed only when TSQLFile created with options "CREATE" or "RECREATE" and only before first write operation. These options are:
Name | Description |
---|---|
SetUseSuffixes() | suffix usage in column names (default - on) |
SetArrayLimit() | defines maximum array size, which can has column for each element (default 21) |
SetTablesType() | table type name in MySQL database (default "InnoDB") |
SetUseIndexes() | usage of indexes in database (default kIndexesBasic) |
Normally these functions should be called immediately after TSQLFile constructor. When objects data written to database, by default START TRANSACTION/COMMIT SQL commands are used before and after data storage. If TSQLFile detects any problems, ROLLBACK command will be used to restore previous state of data base. If transactions not supported by SQL server, they can be disabled by SetUseTransactions(kTransactionsOff). Or user can take responsibility to use transactions function himself. By default only indexes for basic tables are created. In most cases usage of indexes increase performance to data reading, but it also can increase time of writing data to database. There are several modes of index usage available in SetUseIndexes() method There is MakeSelectQuery(TClass*) method, which produces SELECT statement to get objects data of specified class. Difference from simple statement like: mysql> SELECT * FROM TH1I_ver1 that not only data for that class, but also data from parent classes will be extracted from other tables and combined in single result table. Such select query can be useful for external access to objects data.
Up to now MySQL 4.1 and Oracle 9i were tested. Some extra work is required for other SQL databases. Hopefully, this should be straightforward.
Known problems and open questions.
#### A session saving data to a SQL data base
#### A session read data from SQL data base
The "SQL I/O" package is currently under development. Any bug reports and suggestions are welcome. Author: S.Linev, GSI Darmstadt, S.Lin ev@g si.de
Definition at line 30 of file TSQLFile.h.
Public Types | |
enum | EIndexesKinds { kIndexesNone = 0, kIndexesBasic = 1, kIndexesClass = 2, kIndexesAll = 3 } |
enum | ETransactionKinds { kTransactionsOff = 0, kTransactionsAuto = 1, kTransactionsUser = 2 } |
![]() | |
enum | { kStartBigFile = 2000000000 } |
enum | EAsyncOpenStatus { kAOSNotAsync = -1, kAOSFailure = 0, kAOSInProgress = 1, kAOSSuccess = 2 } |
Asynchronous open request status. More... | |
enum | ECacheAction { kDisconnect = 0, kDoNotDisconnect = 1 } |
TTreeCache flushing semantics. More... | |
enum | EFileType { kDefault = 0, kLocal = 1, kNet = 2, kWeb = 3, kFile = 4, kMerge = 5 } |
File type. More... | |
enum | EOpenTimeOut { kInstantTimeout = 0, kEternalTimeout = 999999999 } |
Open timeout constants. More... | |
enum | ERelativeTo { kBeg = 0, kCur = 1, kEnd = 2 } |
enum | EStatusBits { kRecovered = BIT(10), kHasReferences = BIT(11), kDevNull = BIT(12), kWriteError = BIT(14), kBinaryFile = BIT(15), kRedirected = BIT(16) } |
TFile status bits. BIT(13) is taken up by TObject. More... | |
![]() | |
enum | { kCloseDirectory = BIT(7) } |
![]() | |
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) } |
Public Member Functions | |||||||||||
TSQLFile () | |||||||||||
default TSQLFile constructor More... | |||||||||||
TSQLFile (const char *dbname, Option_t *option="read", const char *user="user", const char *pass="pass") | |||||||||||
Connects to SQL server with provided arguments. More... | |||||||||||
virtual | ~TSQLFile () | ||||||||||
destructor of TSQLFile object More... | |||||||||||
virtual void | Close (Option_t *option="") | ||||||||||
Close a SQL file For more comments see TFile::Close() function. More... | |||||||||||
Bool_t | Commit () | ||||||||||
Commit transaction, started by StartTransaction() call. More... | |||||||||||
virtual TKey * | CreateKey (TDirectory *mother, const TObject *obj, const char *name, Int_t bufsize) | ||||||||||
create SQL key, which will store object in data base More... | |||||||||||
virtual TKey * | CreateKey (TDirectory *mother, const void *obj, const TClass *cl, const char *name, Int_t bufsize) | ||||||||||
create SQL key, which will store object in data base More... | |||||||||||
virtual void | DrawMap (const char *="*", Option_t *="") | ||||||||||
Draw map of objects in this file. More... | |||||||||||
virtual void | FillBuffer (char *&) | ||||||||||
Encode file output buffer. More... | |||||||||||
virtual void | Flush () | ||||||||||
Synchronize a file's in-memory and on-disk states. More... | |||||||||||
Int_t | GetArrayLimit () const | ||||||||||
const char * | GetDataBaseName () const | ||||||||||
Return name of data base on the host For Oracle always return 0. More... | |||||||||||
virtual Long64_t | GetEND () const | ||||||||||
virtual Int_t | GetErrno () const | ||||||||||
Method returning errno. Is overriden in TRFIOFile. More... | |||||||||||
virtual Int_t | GetNbytesFree () const | ||||||||||
virtual Int_t | GetNbytesInfo () const | ||||||||||
virtual Int_t | GetNfree () const | ||||||||||
Int_t | GetQuerisCounter () const | ||||||||||
virtual Long64_t | GetSeekFree () const | ||||||||||
virtual Long64_t | GetSeekInfo () const | ||||||||||
virtual Long64_t | GetSize () const | ||||||||||
Returns the current file size. More... | |||||||||||
virtual TList * | GetStreamerInfoList () | ||||||||||
Read back streamer infos from database List of streamer infos is always stored with key:id 0, which is not shown in normal keys list. More... | |||||||||||
const char * | GetTablesType () const | ||||||||||
Int_t | GetUseIndexes () const | ||||||||||
Bool_t | GetUseSuffixes () const | ||||||||||
Int_t | GetUseTransactions () const | ||||||||||
Bool_t | IsMySQL () const | ||||||||||
checks, if MySQL database More... | |||||||||||
Bool_t | IsODBC () const | ||||||||||
checks, if ODBC driver used for database connection More... | |||||||||||
virtual Bool_t | IsOpen () const | ||||||||||
return kTRUE if file is opened and can be accessed More... | |||||||||||
Bool_t | IsOracle () const | ||||||||||
checks, if Oracle database More... | |||||||||||
virtual void | MakeFree (Long64_t, Long64_t) | ||||||||||
Mark unused bytes on the file. More... | |||||||||||
virtual void | MakeProject (const char *, const char *="*", Option_t *="new") | ||||||||||
Generate source code necessary to access the objects stored in the file. More... | |||||||||||
TString | MakeSelectQuery (TClass *cl) | ||||||||||
Produce SELECT statement which can be used to get all data of class cl in one SELECT statement. More... | |||||||||||
virtual void | Map (Option_t *) | ||||||||||
List the contents of a file sequentially. More... | |||||||||||
virtual void | Map () | ||||||||||
virtual void | Paint (Option_t *="") | ||||||||||
Paint all objects in the file. More... | |||||||||||
virtual void | Print (Option_t *="") const | ||||||||||
Print all objects in the file. More... | |||||||||||
virtual Bool_t | ReadBuffer (char *, Int_t) | ||||||||||
Read a buffer from the file. More... | |||||||||||
virtual Bool_t | ReadBuffer (char *, Long64_t, Int_t) | ||||||||||
Read a buffer from the file at the offset 'pos' in the file. More... | |||||||||||
virtual void | ReadFree () | ||||||||||
Read the FREE linked list. More... | |||||||||||
virtual Int_t | Recover () | ||||||||||
Attempt to recover file if not correctly closed. More... | |||||||||||
virtual Int_t | ReOpen (Option_t *mode) | ||||||||||
Reopen a file with a different access mode, like from READ to See TFile::Open() for details. More... | |||||||||||
virtual void | ResetErrno () const | ||||||||||
Method resetting the errno. Is overridden in TRFIOFile. More... | |||||||||||
Bool_t | Rollback () | ||||||||||
Rollback all operations, done after StartTransaction() call. More... | |||||||||||
virtual void | Seek (Long64_t, ERelativeTo=kBeg) | ||||||||||
Seek to a specific position in the file. Pos it either kBeg, kCur or kEnd. More... | |||||||||||
void | SetArrayLimit (Int_t limit=20) | ||||||||||
Defines maximum number of columns for array representation If array size bigger than limit, array data will be converted to raw format This is usefull to prevent tables with very big number of columns If limit==0, all arrays will be stored in raw format If limit<0, all array values will be stored in column form Default value is 21. More... | |||||||||||
virtual void | SetEND (Long64_t) | ||||||||||
void | SetTablesType (const char *table_type) | ||||||||||
Defines tables type, which is used in CREATE TABLE statements Now is only used for MySQL database, where following types are supported: "BDB", "HEAP", "ISAM", "InnoDB", "MERGE", "MRG_MYISAM", "MYISAM" Default for TSQLFile is "InnoDB". More... | |||||||||||
void | SetUseIndexes (Int_t use_type=kIndexesBasic) | ||||||||||
Specify usage of indexes for data tables
| |||||||||||
void | SetUseSuffixes (Bool_t on=kTRUE) | ||||||||||
enable/disable uasge of suffixes in columns names can be changed before first object is saved into file More... | |||||||||||
void | SetUseTransactions (Int_t mode=kTransactionsAuto) | ||||||||||
Defines usage of transactions statements for writing objects data to database. More... | |||||||||||
virtual Int_t | Sizeof () const | ||||||||||
Return the size in bytes of the file header. More... | |||||||||||
void | SkipArrayLimit () | ||||||||||
void | StartLogFile (const char *fname) | ||||||||||
start logging of all SQL statements in specified file More... | |||||||||||
Bool_t | StartTransaction () | ||||||||||
Start user transaction. More... | |||||||||||
void | StopLogFile () | ||||||||||
close logging file More... | |||||||||||
virtual Int_t | Write (const char *=0, Int_t=0, Int_t=0) | ||||||||||
Write memory objects to this file. More... | |||||||||||
virtual Int_t | Write (const char *=0, Int_t=0, Int_t=0) const | ||||||||||
One can not save a const TDirectory object. More... | |||||||||||
virtual Bool_t | WriteBuffer (const char *, Int_t) | ||||||||||
Write a buffer to the file. More... | |||||||||||
virtual void | WriteFree () | ||||||||||
Write FREE linked list on the file. More... | |||||||||||
virtual void | WriteHeader () | ||||||||||
Write file info like configurations, title, UUID and other. More... | |||||||||||
virtual void | WriteStreamerInfo () | ||||||||||
Store all TVirtualStreamerInfo, used in file, in sql database. More... | |||||||||||
![]() | |||||||||||
TFile () | |||||||||||
File default Constructor. More... | |||||||||||
TFile (const char *fname, Option_t *option="", const char *ftitle="", Int_t compress=1) | |||||||||||
Opens or creates a local ROOT file. More... | |||||||||||
virtual | ~TFile () | ||||||||||
File destructor. More... | |||||||||||
virtual void | Copy (TObject &) const | ||||||||||
Copy this to obj. More... | |||||||||||
virtual Bool_t | Cp (const char *dst, Bool_t progressbar=kTRUE, UInt_t buffersize=1000000) | ||||||||||
Allows to copy this file to the dst URL. More... | |||||||||||
virtual void | Delete (const char *namecycle="") | ||||||||||
Delete object namecycle. More... | |||||||||||
virtual void | Draw (Option_t *option="") | ||||||||||
Fill Graphics Structure and Paint. More... | |||||||||||
TArchiveFile * | GetArchive () const | ||||||||||
Long64_t | GetArchiveOffset () const | ||||||||||
Int_t | GetBestBuffer () const | ||||||||||
Return the best buffer size of objects on this file. More... | |||||||||||
virtual Long64_t | GetBytesRead () const | ||||||||||
virtual Long64_t | GetBytesReadExtra () const | ||||||||||
virtual Int_t | GetBytesToPrefetch () const | ||||||||||
Max number of bytes to prefetch. More... | |||||||||||
virtual Long64_t | GetBytesWritten () const | ||||||||||
Return the total number of bytes written so far to the file. More... | |||||||||||
TFileCacheRead * | GetCacheRead (TObject *tree=0) const | ||||||||||
Return a pointer to the current read cache. More... | |||||||||||
TFileCacheWrite * | GetCacheWrite () const | ||||||||||
Return a pointer to the current write cache. More... | |||||||||||
TArrayC * | GetClassIndex () const | ||||||||||
Int_t | GetCompressionAlgorithm () const | ||||||||||
Float_t | GetCompressionFactor () | ||||||||||
Return the file compression factor. More... | |||||||||||
Int_t | GetCompressionLevel () const | ||||||||||
Int_t | GetCompressionSettings () const | ||||||||||
virtual const TUrl * | GetEndpointUrl () const | ||||||||||
Int_t | GetFd () const | ||||||||||
TList * | GetListOfFree () const | ||||||||||
TObjArray * | GetListOfProcessIDs () const | ||||||||||
virtual TString | GetNewUrl () | ||||||||||
virtual Int_t | GetNProcessIDs () const | ||||||||||
Option_t * | GetOption () const | ||||||||||
virtual Int_t | GetReadCalls () const | ||||||||||
Int_t | GetRecordHeader (char *buf, Long64_t first, Int_t maxbytes, Int_t &nbytes, Int_t &objlen, Int_t &keylen) | ||||||||||
Read the logical record header starting at a certain postion. More... | |||||||||||
Long64_t | GetRelOffset () const | ||||||||||
const TList * | GetStreamerInfoCache () | ||||||||||
Returns the cached list of StreamerInfos used in this file. More... | |||||||||||
Int_t | GetVersion () const | ||||||||||
virtual void | IncrementProcessIDs () | ||||||||||
virtual Bool_t | IsArchive () const | ||||||||||
Bool_t | IsBinary () const | ||||||||||
Bool_t | IsRaw () const | ||||||||||
virtual void | ls (Option_t *option="") const | ||||||||||
List file contents. More... | |||||||||||
virtual Bool_t | Matches (const char *name) | ||||||||||
Return kTRUE if 'url' matches the coordinates of this file. More... | |||||||||||
virtual Bool_t | MustFlush () const | ||||||||||
virtual Bool_t | ReadBufferAsync (Long64_t offs, Int_t len) | ||||||||||
virtual Bool_t | ReadBuffers (char *buf, Long64_t *pos, Int_t *len, Int_t nbuf) | ||||||||||
Read the nbuf blocks described in arrays pos and len. More... | |||||||||||
virtual TProcessID * | ReadProcessID (UShort_t pidf) | ||||||||||
The TProcessID with number pidf is read from this file. More... | |||||||||||
virtual void | ReadStreamerInfo () | ||||||||||
Read the list of StreamerInfo from this file. More... | |||||||||||
virtual void | SetCacheRead (TFileCacheRead *cache, TObject *tree=0, ECacheAction action=kDisconnect) | ||||||||||
Set a pointer to the read cache. More... | |||||||||||
virtual void | SetCacheWrite (TFileCacheWrite *cache) | ||||||||||
Set a pointer to the write cache. More... | |||||||||||
virtual void | SetCompressionAlgorithm (Int_t algorithm=0) | ||||||||||
See comments for function SetCompressionSettings. More... | |||||||||||
virtual void | SetCompressionLevel (Int_t level=1) | ||||||||||
See comments for function SetCompressionSettings. More... | |||||||||||
virtual void | SetCompressionSettings (Int_t settings=1) | ||||||||||
Used to specify the compression level and algorithm. More... | |||||||||||
virtual void | SetOffset (Long64_t offset, ERelativeTo pos=kBeg) | ||||||||||
Set position from where to start reading. More... | |||||||||||
virtual void | SetOption (Option_t *option=">") | ||||||||||
virtual void | SetReadCalls (Int_t readcalls=0) | ||||||||||
virtual void | ShowStreamerInfo () | ||||||||||
Show the StreamerInfo of all classes written to this file. More... | |||||||||||
void | SumBuffer (Int_t bufsize) | ||||||||||
Increment statistics for buffer sizes of objects in this file. More... | |||||||||||
virtual UShort_t | WriteProcessID (TProcessID *pid) | ||||||||||
Check if the ProcessID pidd is already in the file, if not, add it and return the index number in the local file list. More... | |||||||||||
![]() | |||||||||||
TDirectoryFile () | |||||||||||
Default Constructor. More... | |||||||||||
TDirectoryFile (const char *name, const char *title, Option_t *option="", TDirectory *motherDir=0) | |||||||||||
Create a new TDirectoryFile. More... | |||||||||||
virtual | ~TDirectoryFile () | ||||||||||
Destructor. More... | |||||||||||
void | Add (TObject *obj, Bool_t replace=kFALSE) | ||||||||||
virtual void | Append (TObject *obj, Bool_t replace=kFALSE) | ||||||||||
Append object to this directory. More... | |||||||||||
Int_t | AppendKey (TKey *key) | ||||||||||
Insert key in the linked list of keys of this directory. More... | |||||||||||
virtual void | Browse (TBrowser *b) | ||||||||||
Browse the content of the directory. More... | |||||||||||
void | Build (TFile *motherFile=0, TDirectory *motherDir=0) | ||||||||||
Initialise directory to defaults. More... | |||||||||||
virtual Bool_t | cd (const char *path=0) | ||||||||||
Change current directory to "this" directory. More... | |||||||||||
virtual TObject * | CloneObject (const TObject *obj, Bool_t autoadd=kTRUE) | ||||||||||
Make a clone of an object using the Streamer facility. More... | |||||||||||
virtual TKey * | FindKey (const char *keyname) const | ||||||||||
Find key with name keyname in the current directory. More... | |||||||||||
virtual TKey * | FindKeyAny (const char *keyname) const | ||||||||||
Find key with name keyname in the current directory or its subdirectories. More... | |||||||||||
virtual TObject * | FindObjectAny (const char *name) const | ||||||||||
Find object by name in the list of memory objects of the current directory or its sub-directories. More... | |||||||||||
virtual TObject * | FindObjectAnyFile (const char *name) const | ||||||||||
Scan the memory lists of all files for an object with name. More... | |||||||||||
virtual TObject * | Get (const char *namecycle) | ||||||||||
Return pointer to object identified by namecycle. More... | |||||||||||
virtual Int_t | GetBufferSize () const | ||||||||||
Return the buffer size to create new TKeys. More... | |||||||||||
const TDatime & | GetCreationDate () const | ||||||||||
virtual TDirectory * | GetDirectory (const char *apath, Bool_t printError=false, const char *funcname="GetDirectory") | ||||||||||
Find a directory named "apath". More... | |||||||||||
virtual TFile * | GetFile () const | ||||||||||
virtual TKey * | GetKey (const char *name, Short_t cycle=9999) const | ||||||||||
Return pointer to key with name,cycle. More... | |||||||||||
virtual TList * | GetListOfKeys () const | ||||||||||
const TDatime & | GetModificationDate () const | ||||||||||
virtual Int_t | GetNbytesKeys () const | ||||||||||
virtual Int_t | GetNkeys () const | ||||||||||
template<class T > | |||||||||||
void | GetObject (const char *namecycle, T *&ptr) | ||||||||||
virtual void * | GetObjectChecked (const char *namecycle, const char *classname) | ||||||||||
See documentation of TDirectoryFile::GetObjectCheck(const char *namecycle, const TClass *cl) More... | |||||||||||
virtual void * | GetObjectChecked (const char *namecycle, const TClass *cl) | ||||||||||
Return pointer to object identified by namecycle if and only if the actual object is a type suitable to be stored as a pointer to a "expectedClass" If expectedClass is null, no check is performed. More... | |||||||||||
virtual void * | GetObjectUnchecked (const char *namecycle) | ||||||||||
Return pointer to object identified by namecycle. More... | |||||||||||
virtual Long64_t | GetSeekDir () const | ||||||||||
virtual Long64_t | GetSeekKeys () const | ||||||||||
virtual Long64_t | GetSeekParent () const | ||||||||||
Bool_t | IsModified () const | ||||||||||
Bool_t | IsWritable () const | ||||||||||
virtual TDirectory * | mkdir (const char *name, const char *title="") | ||||||||||
Create a sub-directory "a" or a hierarchy of sub-directories "a/b/c/...". More... | |||||||||||
virtual TFile * | OpenFile (const char *name, Option_t *option="", const char *ftitle="", Int_t compress=1, Int_t netopt=0) | ||||||||||
Interface to TFile::Open. More... | |||||||||||
virtual void | Purge (Short_t nkeep=1) | ||||||||||
Purge lowest key cycles in a directory. More... | |||||||||||
virtual void | ReadAll (Option_t *option="") | ||||||||||
Read objects from a ROOT file directory into memory. More... | |||||||||||
virtual Int_t | ReadKeys (Bool_t forceRead=kTRUE) | ||||||||||
Read the linked list of keys. More... | |||||||||||
virtual Int_t | ReadTObject (TObject *obj, const char *keyname) | ||||||||||
Read object with keyname from the current directory. More... | |||||||||||
virtual void | ResetAfterMerge (TFileMergeInfo *) | ||||||||||
Reset the TDirectory after its content has been merged into another Directory. More... | |||||||||||
virtual void | rmdir (const char *name) | ||||||||||
Removes subdirectory from the directory. More... | |||||||||||
virtual void | Save () | ||||||||||
Save recursively all directory keys and headers. More... | |||||||||||
virtual Int_t | SaveObjectAs (const TObject *obj, const char *filename="", Option_t *option="") const | ||||||||||
Save object in filename. More... | |||||||||||
virtual void | SaveSelf (Bool_t force=kFALSE) | ||||||||||
Save Directory keys and header. More... | |||||||||||
virtual void | SetBufferSize (Int_t bufsize) | ||||||||||
Set the default buffer size when creating new TKeys. More... | |||||||||||
void | SetModified () | ||||||||||
void | SetSeekDir (Long64_t v) | ||||||||||
virtual void | SetTRefAction (TObject *ref, TObject *parent) | ||||||||||
Find the action to be executed in the dictionary of the parent class and store the corresponding exec number into fBits. More... | |||||||||||
void | SetWritable (Bool_t writable=kTRUE) | ||||||||||
Set the new value of fWritable recursively. More... | |||||||||||
virtual void | WriteDirHeader () | ||||||||||
Overwrite the Directory header record. More... | |||||||||||
virtual void | WriteKeys () | ||||||||||
Write Keys linked list on the file. More... | |||||||||||
virtual Int_t | WriteObjectAny (const void *obj, const char *classname, const char *name, Option_t *option="", Int_t bufsize=0) | ||||||||||
Write object from pointer of class classname in this directory. More... | |||||||||||
virtual Int_t | WriteObjectAny (const void *obj, const TClass *cl, const char *name, Option_t *option="", Int_t bufsize=0) | ||||||||||
Write object of class with dictionary cl in this directory. More... | |||||||||||
virtual Int_t | WriteTObject (const TObject *obj, const char *name=0, Option_t *option="", Int_t bufsize=0) | ||||||||||
Write object obj to this directory. More... | |||||||||||
![]() | |||||||||||
TDirectory () | |||||||||||
Directory default constructor. More... | |||||||||||
TDirectory (const char *name, const char *title, Option_t *option="", TDirectory *motherDir=0) | |||||||||||
Create a new Directory. More... | |||||||||||
virtual | ~TDirectory () | ||||||||||
Destructor. More... | |||||||||||
virtual void | Clear (Option_t *option="") | ||||||||||
Delete all objects from a Directory list. More... | |||||||||||
virtual void | DeleteAll (Option_t *option="") | ||||||||||
Delete all objects from memory. More... | |||||||||||
virtual TObject * | FindObject (const char *name) const | ||||||||||
Find object by name in the list of memory objects. More... | |||||||||||
virtual TObject * | FindObject (const TObject *obj) const | ||||||||||
Find object in the list of memory objects. More... | |||||||||||
virtual TList * | GetList () const | ||||||||||
virtual TObject * | GetMother () const | ||||||||||
virtual TDirectory * | GetMotherDir () const | ||||||||||
template<class T > | |||||||||||
void | GetObject (const char *namecycle, T *&ptr) | ||||||||||
virtual const char * | GetPath () const | ||||||||||
Returns the full path of the directory. More... | |||||||||||
virtual const char * | GetPathStatic () const | ||||||||||
Returns the full path of the directory. More... | |||||||||||
TUUID | GetUUID () const | ||||||||||
virtual Bool_t | IsFolder () const | ||||||||||
Returns kTRUE in case object contains browsable objects (like containers or lists of other objects). More... | |||||||||||
virtual void | pwd () const | ||||||||||
Print the path of the directory. More... | |||||||||||
virtual void | RecursiveRemove (TObject *obj) | ||||||||||
Recursively remove object from a Directory. More... | |||||||||||
virtual TObject * | Remove (TObject *) | ||||||||||
Remove an object from the in-memory list. More... | |||||||||||
virtual void | SetMother (TObject *mother) | ||||||||||
virtual void | SetName (const char *newname) | ||||||||||
Set the name for directory If the directory name is changed after the directory was written once, ROOT currently would NOT change the name of correspondent key in the mother directory. More... | |||||||||||
template<class T > | |||||||||||
Int_t | WriteObject (const T *obj, const char *name, Option_t *option="", Int_t bufsize=0) | ||||||||||
![]() | |||||||||||
TNamed () | |||||||||||
TNamed (const char *name, const char *title) | |||||||||||
TNamed (const TString &name, const TString &title) | |||||||||||
TNamed (const TNamed &named) | |||||||||||
TNamed copy ctor. More... | |||||||||||
virtual | ~TNamed () | ||||||||||
TNamed destructor. 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 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 | ||||||||||
TNamed & | operator= (const TNamed &rhs) | ||||||||||
TNamed assignment operator. 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... | |||||||||||
![]() | |||||||||||
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... | |||||||||||
ULong_t | CheckedHash () | ||||||||||
Checked and record whether for 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 Int_t | DistancetoPrimitive (Int_t px, Int_t py) | ||||||||||
Computes distance from point (px,py) to the object. 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 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 char * | GetObjectInfo (Int_t px, Int_t py) const | ||||||||||
Returns string containing info about the object at position (px,py). 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... | |||||||||||
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... | |||||||||||
R__ALWAYS_INLINE Bool_t | IsOnHeap () const | ||||||||||
R__ALWAYS_INLINE Bool_t | IsZombie () const | ||||||||||
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 | Pop () | ||||||||||
Pop on object drawn in a pad to the top of the display list. More... | |||||||||||
virtual Int_t | Read (const char *name) | ||||||||||
Read contents of object with specified name from the current directory. 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, Bool_t set) | ||||||||||
Set or unset the user status bits as specified in f. More... | |||||||||||
void | SetBit (UInt_t f) | ||||||||||
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... | |||||||||||
Protected Types | |
enum | ELockingKinds { kLockFree = 0, kLockBusy = 1 } |
Protected Member Functions | |
void | AddIdEntry (Long64_t tableid, Int_t subid, Int_t type, const char *name, const char *sqlname, const char *info) |
Add entry into IdsTable, where all tables names and columns names are listed. More... | |
TString | CodeLongString (Long64_t objid, Int_t strid) |
Produces id which will be placed in column instead of string itself. More... | |
void | CreateBasicTables () |
Creates initial tables in database This is table with configurations and table with keys Function called once when first object is stored to the file. More... | |
Bool_t | CreateClassTable (TSQLClassInfo *sqlinfo, TObjArray *colinfos) |
Create normal class table if required. More... | |
Bool_t | CreateRawTable (TSQLClassInfo *sqlinfo) |
Create the raw table. More... | |
Long64_t | DefineNextKeyId () |
Returns next possible key identifier. More... | |
TString | DefineTableName (const char *clname, Int_t version, Bool_t rawtable) |
Proposes table name for class. More... | |
void | DeleteKeyFromDB (Long64_t keyid) |
Remove key with specified id from keys table also removes all objects data, related to this table. More... | |
virtual Long64_t | DirCreateEntry (TDirectory *) |
Create entry for directory in database. More... | |
virtual Int_t | DirReadKeys (TDirectory *) |
Read directory list of keys from database. More... | |
virtual void | DirWriteHeader (TDirectory *) |
Update dir header in the file. More... | |
virtual void | DirWriteKeys (TDirectory *) |
Write directory keys list to database. More... | |
TSQLClassInfo * | FindSQLClassInfo (const char *clname, Int_t version) |
Return (if exists) TSQLClassInfo for specified class name and version. More... | |
TSQLClassInfo * | FindSQLClassInfo (const TClass *cl) |
return (if exists) TSQLClassInfo for specified class More... | |
TKeySQL * | FindSQLKey (TDirectory *dir, Long64_t keyid) |
Search for TKeySQL object with specified keyid. More... | |
TSQLResult * | GetBlobClassData (Long64_t objid, TSQLClassInfo *sqlinfo) |
Method return request results for specified objid from streamer classtable. More... | |
TSQLStatement * | GetBlobClassDataStmt (Long64_t objid, TSQLClassInfo *sqlinfo) |
Method return request results for specified objid from streamer classtable Data returned in form of statement, where direct access to values are possible. More... | |
Int_t | GetLocking () |
Return current locking mode for that file. More... | |
Bool_t | GetLongString (Long64_t objid, Int_t strid, TString &value) |
Returns value of string, extracted from special table, where long strings are stored. More... | |
TSQLResult * | GetNormalClassData (Long64_t objid, TSQLClassInfo *sqlinfo) |
Method return request result for specified objid from normal classtable. More... | |
TSQLResult * | GetNormalClassDataAll (Long64_t minobjid, Long64_t maxobjid, TSQLClassInfo *sqlinfo) |
Return data for several objects from the range from normal class table. More... | |
Bool_t | HasTable (const char *name) |
Test if table name exists. More... | |
void | IncrementModifyCounter () |
Update value of modify counter in config table Modify counter used to indicate that something was changed in database. More... | |
void | InitSqlDatabase (Bool_t create) |
initialize sql database and correspondent structures identical to TFile::Init() function More... | |
Int_t | IsLongStringCode (Long64_t objid, const char *value) |
Checks if this is long string code returns 0, if not or string id. More... | |
Bool_t | IsReadAccess () |
dummy, in future should check about read access to database More... | |
Bool_t | IsTablesExists () |
Checks if main keys table is existing. More... | |
Bool_t | IsWriteAccess () |
Checkis, if lock is free in configuration tables. More... | |
Bool_t | ProduceClassSelectQuery (TVirtualStreamerInfo *info, TSQLClassInfo *sqlinfo, TString &columns, TString &tables, Int_t &tablecnt) |
used by MakeClassSelectQuery method to add columns from table of class, specified by TVirtualStreamerInfo structure More... | |
Bool_t | ReadConfigurations () |
read table configurations as special table More... | |
TObject * | ReadSpecialObject (Long64_t keyid, TObject *obj=0) |
Read data of special kind of objects. More... | |
void | ReadSQLClassInfos () |
Read all class infos from IdsTable. More... | |
TSQLClassInfo * | RequestSQLClassInfo (const char *clname, Int_t version) |
Search in database tables for specified class and return TSQLClassInfo object. More... | |
TSQLClassInfo * | RequestSQLClassInfo (const TClass *cl) |
Search in database tables for specified class and return TSQLClassInfo object. More... | |
void | SaveToDatabase () |
save data which is not yet in Database Typically this is streamerinfos structures or More... | |
void | SetLocking (Int_t mode) |
Set locking mode for current database. More... | |
Bool_t | SQLApplyCommands (TObjArray *cmds) |
supplies set of commands to server Commands is stored as array of TObjString More... | |
const char * | SQLBigTextType () const |
Bool_t | SQLCanStatement () |
Test if DB support statement and number of open statements is not exceeded. More... | |
Bool_t | SQLCommit () |
Commit SQL transaction. More... | |
const char * | SQLCompatibleType (Int_t typ) const |
Returns sql type name which is most closer to ROOT basic type. More... | |
const char * | SQLDatetimeType () const |
const char * | SQLDefaultTableType () const |
void | SQLDeleteAllTables () |
Delete all tables in database. More... | |
void | SQLDeleteStatement (TSQLStatement *stmt) |
delete statement and decrease counter More... | |
const char * | SQLDirIdColumn () const |
const char * | SQLIdentifierQuote () const |
const char * | SQLIntType () const |
return SQL integer type More... | |
const char * | SQLKeyIdColumn () const |
Int_t | SQLMaxIdentifierLength () |
returns maximum allowed length of identifiers More... | |
Long64_t | SQLMaximumValue (const char *tablename, const char *columnname) |
Returns maximum value, found in specified columnname of table tablename Column type should be numeric. More... | |
const char * | SQLNameSeparator () const |
const char * | SQLObjectIdColumn () const |
Bool_t | SQLObjectInfo (Long64_t objid, TString &clname, Version_t &version) |
Read from objects table data for specified objectid. More... | |
TObjArray * | SQLObjectsInfo (Long64_t keyid) |
Produce array of TSQLObjectInfo objects for all objects, belong to that key Array should be deleted by calling function afterwards. More... | |
TSQLResult * | SQLQuery (const char *cmd, Int_t flag=0, Bool_t *res=0) |
Submits query to SQL server. More... | |
const char * | SQLRawIdColumn () const |
Bool_t | SQLRollback () |
Rollback all SQL operations, done after start transaction. More... | |
const char * | SQLSmallTextType () const |
Int_t | SQLSmallTextTypeLimit () const |
Bool_t | SQLStartTransaction () |
Start SQL transaction. More... | |
TSQLStatement * | SQLStatement (const char *cmd, Int_t bufsize=1000) |
Produces SQL statement for currently conected DB server. More... | |
const char * | SQLStrIdColumn () const |
Bool_t | SQLTestTable (const char *tablename) |
Test, if table of specified name exists. More... | |
const char * | SQLValueQuote () const |
Long64_t | StoreObjectInTables (Long64_t keyid, const void *obj, const TClass *cl) |
Store object in database. Return stored object id or -1 if error. More... | |
Int_t | StreamKeysForDirectory (TDirectory *dir, Bool_t doupdate, Long64_t specialkeyid=-1, TKeySQL **specialkey=0) |
read keys for specified directory (when update == kFALSE) or update value for modified keys when update == kTRUE Returns number of successfully read keys or -1 if error More... | |
virtual Int_t | SysClose (Int_t) |
Interface to system close. All arguments like in POSIX close(). More... | |
virtual Int_t | SysOpen (const char *, Int_t, UInt_t) |
Interface to system open. All arguments like in POSIX open(). More... | |
virtual Int_t | SysRead (Int_t, void *, Int_t) |
Interface to system read. All arguments like in POSIX read(). More... | |
virtual Long64_t | SysSeek (Int_t, Long64_t, Int_t) |
Interface to system lseek. More... | |
virtual Int_t | SysStat (Int_t, Long_t *, Long64_t *, Long_t *, Long_t *) |
Return file stat information. More... | |
virtual Int_t | SysSync (Int_t) |
Interface to system fsync. All arguments like in POSIX fsync(). More... | |
virtual Int_t | SysWrite (Int_t, const void *, Int_t) |
Interface to system write. All arguments like in POSIX write(). More... | |
Bool_t | UpdateKeyData (TKeySQL *key) |
Updates (overwrites) key data in KeysTable. More... | |
Bool_t | VerifyLongStringTable () |
Checks that table for big strings is exists If not, will be created. More... | |
Long64_t | VerifyObjectTable () |
Checks that objects table is exists If not, table will be created Returns maximum value for existing objects id. More... | |
Bool_t | WriteKeyData (TKeySQL *key) |
Add entry into keys table. More... | |
Bool_t | WriteSpecialObject (Long64_t keyid, TObject *obj, const char *name, const char *title) |
write special kind of object like streamer infos or file itself keys for that objects should exist in tables but not indicated in list of keys, therefore users can not get them with TDirectoryFile::Get() method More... | |
![]() | |
Bool_t | FlushWriteCache () |
Flush the write cache if active. More... | |
virtual EAsyncOpenStatus | GetAsyncOpenStatus () |
virtual void | Init (Bool_t create) |
Initialize a TFile object. More... | |
Int_t | MakeProjectParMake (const char *packname, const char *filename) |
Create makefile at 'filemake' for PAR package 'pack'. More... | |
Int_t | MakeProjectParProofInf (const char *packname, const char *proofinfdir) |
Create BUILD.sh and SETUP.C under 'proofinf' for PAR package 'pack'. More... | |
Int_t | ReadBufferViaCache (char *buf, Int_t len) |
Read buffer via cache. More... | |
Int_t | WriteBufferViaCache (const char *buf, Int_t len) |
Write buffer via cache. More... | |
![]() | |
virtual void | CleanTargets () |
Clean the pointers to this object (gDirectory, TContext, etc.) More... | |
void | Init (TClass *cl=0) |
Initialize the key associated with this directory (and the related data members. More... | |
![]() | |
TDirectory (const TDirectory &directory) | |
Copy constructor. More... | |
Bool_t | cd1 (const char *path) |
flag to add histograms, graphs,etc to the directory More... | |
void | FillFullPath (TString &buf) const |
Recursive method to fill full path for directory. More... | |
void | operator= (const TDirectory &) |
void | RegisterContext (TContext *ctxt) |
Register a TContext pointing to this TDirectory object. More... | |
void | UnregisterContext (TContext *ctxt) |
UnRegister a TContext pointing to this TDirectory object. More... | |
![]() | |
virtual void | DoError (int level, const char *location, const char *fmt, va_list va) const |
Interface to ErrorHandler (protected). More... | |
void | MakeZombie () |
Protected Attributes | |
Int_t | fArrayLimit |
! limit for array size. when array bigger, its content converted to raw format More... | |
const char ** | fBasicTypes |
! pointer on list of basic types specific for currently connected SQL server More... | |
Bool_t | fCanChangeConfig |
! variable indicates can be basic configuration changed or not More... | |
Bool_t | fIdsTableExists |
! indicate if IdsTable exists More... | |
std::ofstream * | fLogFile |
! log file with SQL statements More... | |
Int_t | fModifyCounter |
! indicates how many changes was done with database tables More... | |
const char ** | fOtherTypes |
! pointer on list of other SQL types like TEXT or blob More... | |
Int_t | fQuerisCounter |
! how many query was applied More... | |
TSQLServer * | fSQL |
! interface to SQL database More... | |
TList * | fSQLClassInfos |
! list of SQL class infos More... | |
Int_t | fSQLIOversion |
! version of SQL I/O which is stored in configurations More... | |
Int_t | fStmtCounter |
! count numbers of active statements More... | |
TString | fTablesType |
! type, used in CREATE TABLE statements More... | |
Int_t | fUseIndexes |
! use indexes for tables: 0 - off, 1 - only for basic tables, 2 + normal class tables, 3 - all tables More... | |
TString | fUserName |
! user name, used to access objects from database More... | |
Bool_t | fUseSuffixes |
! use suffixes in column names like fValue:Int_t or fObject:pointer More... | |
Int_t | fUseTransactions |
! use transaction statements for writing data into the tables More... | |
![]() | |
TArchiveFile * | fArchive |
!Archive file from which we read this file More... | |
Long64_t | fArchiveOffset |
!Offset at which file starts in archive More... | |
TFileOpenHandle * | fAsyncHandle |
!For proper automatic cleanup More... | |
EAsyncOpenStatus | fAsyncOpenStatus |
!Status of an asynchronous open request More... | |
Long64_t | fBEGIN |
First used byte in file. More... | |
Long64_t | fBytesRead |
Number of bytes read from this file. More... | |
Long64_t | fBytesReadExtra |
Number of extra bytes (overhead) read by the readahead buffer. More... | |
Long64_t | fBytesWrite |
Number of bytes written to this file. More... | |
TFileCacheRead * | fCacheRead |
!Pointer to the read cache (if any) More... | |
TMap * | fCacheReadMap |
!Pointer to the read cache (if any) More... | |
TFileCacheWrite * | fCacheWrite |
!Pointer to the write cache (if any) More... | |
TArrayC * | fClassIndex |
!Index of TStreamerInfo classes written to this file More... | |
Int_t | fCompress |
Compression level and algorithm. More... | |
Int_t | fD |
File descriptor. More... | |
Long64_t | fEND |
Last used byte in file. More... | |
TList * | fFree |
Free segments linked list table. More... | |
TList * | fInfoCache |
!Cached list of the streamer infos in this file More... | |
Bool_t | fInitDone: 1 |
!True if the file has been initialized More... | |
Bool_t | fIsArchive: 1 |
!True if this is a pure archive file More... | |
Bool_t | fIsPcmFile: 1 |
!True if the file is a ROOT pcm file. More... | |
Bool_t | fIsRootFile: 1 |
!True is this is a ROOT file, raw file otherwise More... | |
Bool_t | fMustFlush: 1 |
!True if the file buffers must be flushed More... | |
Int_t | fNbytesFree |
Number of bytes for free segments structure. More... | |
Int_t | fNbytesInfo |
Number of bytes for StreamerInfo record. More... | |
Bool_t | fNoAnchorInName: 1 |
!True if we don't want to force the anchor to be appended to the file name More... | |
Int_t | fNProcessIDs |
Number of TProcessID written to this file. More... | |
Long64_t | fOffset |
!Seek offset cache More... | |
TList * | fOpenPhases |
!Time info about open phases More... | |
TString | fOption |
File options. More... | |
TObjArray * | fProcessIDs |
!Array of pointers to TProcessIDs More... | |
Int_t | fReadCalls |
Number of read calls ( not counting the cache calls ) More... | |
TString | fRealName |
Effective real file name (not original url) More... | |
Long64_t | fSeekFree |
Location on disk of free segments structure. More... | |
Long64_t | fSeekInfo |
Location on disk of StreamerInfo record. More... | |
Double_t | fSum2Buffer |
Sum of squares of buffer sizes of objects written so far. More... | |
Double_t | fSumBuffer |
Sum of buffer sizes of objects written so far. More... | |
Char_t | fUnits |
Number of bytes for file pointers. More... | |
TUrl | fUrl |
!URL of file More... | |
Int_t | fVersion |
File format version. More... | |
std::mutex | fWriteMutex |
!Lock for writing baskets / keys into the file. More... | |
Int_t | fWritten |
Number of objects written so far. More... | |
![]() | |
Int_t | fBufferSize |
Default buffer size to create new TKeys. More... | |
TDatime | fDatimeC |
Date and time when directory is created. More... | |
TDatime | fDatimeM |
Date and time of last modification. More... | |
TFile * | fFile |
Pointer to current file in memory. More... | |
TList * | fKeys |
Pointer to keys list in memory. More... | |
Bool_t | fModified |
True if directory has been modified. More... | |
Int_t | fNbytesKeys |
Number of bytes for the keys. More... | |
Int_t | fNbytesName |
Number of bytes in TNamed at creation time. More... | |
Long64_t | fSeekDir |
Location of directory on file. More... | |
Long64_t | fSeekKeys |
Location of Keys record on file. More... | |
Long64_t | fSeekParent |
Location of parent directory on file. More... | |
Bool_t | fWritable |
True if directory is writable. More... | |
![]() | |
TContext * | fContext |
Buffer for GetPath() function. More... | |
std::atomic< size_t > | fContextPeg |
Pointer to a list of TContext object pointing to this TDirectory. More... | |
TList * | fList |
TObject * | fMother |
TString | fPathBuffer |
std::atomic_flag | fSpinLock |
Counter delaying the TDirectory destructor from finishing. More... | |
TUUID | fUUID |
![]() | |
TString | fName |
TString | fTitle |
Private Member Functions | |
void | operator= (const TSQLFile &) |
make private to exclude copy operator More... | |
Friends | |
class | TBufferSQL2 |
class | TKeySQL |
class | TSqlCmdsBuffer |
class | TSqlRawBuffer |
class | TSqlRegistry |
class | TSQLStructure |
class | TSQLTableData |
Additional Inherited Members | |
![]() | |
static TFileOpenHandle * | AsyncOpen (const char *name, Option_t *option="", const char *ftitle="", Int_t compress=1, Int_t netopt=0) |
Submit an asynchronous open request. More... | |
static Bool_t | Cp (const char *src, const char *dst, Bool_t progressbar=kTRUE, UInt_t buffersize=1000000) |
Allows to copy file from src to dst URL. More... | |
static TFile *& | CurrentFile () |
Return the current ROOT file if any. More... | |
static EAsyncOpenStatus | GetAsyncOpenStatus (const char *name) |
Get status of the async open request related to 'name'. More... | |
static EAsyncOpenStatus | GetAsyncOpenStatus (TFileOpenHandle *handle) |
Get status of the async open request related to 'handle'. More... | |
static const char * | GetCacheFileDir () |
Get the directory where to locally stage/cache remote files. More... | |
static const TUrl * | GetEndpointUrl (const char *name) |
Get final URL for file being opened asynchronously. More... | |
static Long64_t | GetFileBytesRead () |
Static function returning the total number of bytes read from all files. More... | |
static Long64_t | GetFileBytesWritten () |
Static function returning the total number of bytes written to all files. More... | |
static Long64_t | GetFileCounter () |
static Int_t | GetFileReadCalls () |
Static function returning the total number of read calls from all files. More... | |
static Bool_t | GetOnlyStaged () |
Returns staged only flag. More... | |
static UInt_t | GetOpenTimeout () |
Returns open timeout (in ms). More... | |
static Int_t | GetReadaheadSize () |
Static function returning the readahead buffer size. More... | |
static Bool_t | GetReadStreamerInfo () |
If the streamerinfos are to be read at file opening. More... | |
static EFileType | GetType (const char *name, Option_t *option="", TString *prefix=0) |
Resolve the file type as a function of the protocol field in 'name'. More... | |
static void | IncrementFileCounter () |
static TFile * | Open (const char *name, Option_t *option="", const char *ftitle="", Int_t compress=1, Int_t netopt=0) |
Create / open a file. More... | |
static TFile * | Open (TFileOpenHandle *handle) |
Waits for the completion of an asynchronous open request. More... | |
static Bool_t | SetCacheFileDir (ROOT::Internal::TStringView cacheDir, Bool_t operateDisconnected=kTRUE, Bool_t forceCacheread=kFALSE) |
static Bool_t | SetCacheFileDir (std::string_view cacheDir, Bool_t operateDisconnected=kTRUE, Bool_t forceCacheread=kFALSE) |
Sets the directory where to locally stage/cache remote files. More... | |
static void | SetFileBytesRead (Long64_t bytes=0) |
static void | SetFileBytesWritten (Long64_t bytes=0) |
static void | SetFileReadCalls (Int_t readcalls=0) |
static Bool_t | SetOnlyStaged (Bool_t onlystaged) |
Sets only staged flag. More... | |
static UInt_t | SetOpenTimeout (UInt_t timeout) |
Sets open timeout time (in ms). Returns previous timeout value. More... | |
static void | SetReadaheadSize (Int_t bufsize=256000) |
static void | SetReadStreamerInfo (Bool_t readinfo=kTRUE) |
Specify if the streamerinfos must be read at file opening. More... | |
static Bool_t | ShrinkCacheFileDir (Long64_t shrinkSize, Long_t cleanupInteval=0) |
Try to shrink the cache to the desired size. More... | |
![]() | |
static void | AddDirectory (Bool_t add=kTRUE) |
Sets the flag controlling the automatic add objects like histograms, TGraph2D, etc in memory. More... | |
static Bool_t | AddDirectoryStatus () |
Static function: see TDirectory::AddDirectory for more comments. More... | |
static Bool_t | Cd (const char *path) |
Change current directory to "path". More... | |
static TDirectory *& | CurrentDirectory () |
Return the current directory for the current thread. More... | |
static void | DecodeNameCycle (const char *namecycle, char *name, Short_t &cycle, const size_t namesize=0) |
Decode a namecycle "aap;2" into name "aap" and cycle "2". More... | |
static void | EncodeNameCycle (char *buffer, const char *name, Short_t cycle) |
Encode the name and cycle into buffer like: "aap;2". 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... | |
![]() | |
static Bool_t | Cd1 (const char *path) |
Change current directory to "path". More... | |
![]() | |
static TList * | fgAsyncOpenRequests = 0 |
static std::atomic< Long64_t > | fgBytesRead {0} |
Number of bytes read by all TFile objects. More... | |
static std::atomic< Long64_t > | fgBytesWrite {0} |
Number of bytes written by all TFile objects. More... | |
static TString | fgCacheFileDir |
Directory where to locally stage files. More... | |
static Bool_t | fgCacheFileDisconnected = kTRUE |
Indicates, we trust in the files in the cache dir without stat on the cached file. More... | |
static Bool_t | fgCacheFileForce = kFALSE |
Indicates, to force all READ to CACHEREAD. More... | |
static std::atomic< Long64_t > | fgFileCounter {0} |
Counter for all opened files. More... | |
static Bool_t | fgOnlyStaged = 0 |
Before the file is opened, it is checked, that the file is staged, if not, the open fails. More... | |
static UInt_t | fgOpenTimeout = TFile::kEternalTimeout |
Timeout for open operations in ms - 0 corresponds to blocking i/o. More... | |
static Int_t | fgReadaheadSize = 256000 |
Readahead buffer size. More... | |
static std::atomic< Int_t > | fgReadCalls {0} |
Number of bytes read from all TFile objects. More... | |
static Bool_t | fgReadInfo = kTRUE |
if true (default) ReadStreamerInfo is called when opening a file More... | |
static ROOT::TRWSpinLock | fgRwLock |
!Read-write lock to protect global PID list More... | |
![]() | |
static Bool_t | fgAddDirectory = kTRUE |
MSVC doesn't support = ATOMIC_FLAG_INIT;. More... | |
#include <TSQLFile.h>
Enumerator | |
---|---|
kIndexesNone | |
kIndexesBasic | |
kIndexesClass | |
kIndexesAll |
Definition at line 177 of file TSQLFile.h.
|
protected |
Enumerator | |
---|---|
kLockFree | |
kLockBusy |
Definition at line 41 of file TSQLFile.h.
Enumerator | |
---|---|
kTransactionsOff | |
kTransactionsAuto | |
kTransactionsUser |
Definition at line 175 of file TSQLFile.h.
TSQLFile::TSQLFile | ( | ) |
default TSQLFile constructor
Definition at line 274 of file TSQLFile.cxx.
TSQLFile::TSQLFile | ( | const char * | dbname, |
Option_t * | option = "read" , |
||
const char * | user = "user" , |
||
const char * | pass = "pass" |
||
) |
Connects to SQL server with provided arguments.
If the constructor fails in any way IsZombie() will return true. Use IsOpen() to check if the file is (still) open.
Option | Description |
---|---|
NEW or CREATE | Create a ROOT tables in database if the tables already exists connection is not opened. |
RECREATE | Create completely new tables. Any existing table will be deleted. |
UPDATE | Open an existing database for writing. If data base open by other TSQLFile instance for writing, |
write access will be rejected.| | BREAKLOCK | Special case when lock was not correctly released by TSQLFile instance. This may happen if program crashed when TSQLFile was open with write access mode.| | READ / OPEN | Open an existing data base for reading.|
For more details see comments for TFile::TFile() constructor. For a moment TSQLFile does not support TTree objects and subdirectories.
Definition at line 300 of file TSQLFile.cxx.
|
virtual |
destructor of TSQLFile object
Definition at line 693 of file TSQLFile.cxx.
|
protected |
Add entry into IdsTable, where all tables names and columns names are listed.
Definition at line 2027 of file TSQLFile.cxx.
Close a SQL file For more comments see TFile::Close() function.
Reimplemented from TFile.
Definition at line 645 of file TSQLFile.cxx.
Produces id which will be placed in column instead of string itself.
Definition at line 2223 of file TSQLFile.cxx.
Bool_t TSQLFile::Commit | ( | ) |
Commit transaction, started by StartTransaction() call.
Only after that call data will be written and visible on database side.
Definition at line 583 of file TSQLFile.cxx.
|
protected |
Creates initial tables in database This is table with configurations and table with keys Function called once when first object is stored to the file.
Definition at line 1122 of file TSQLFile.cxx.
|
protected |
Create normal class table if required.
Definition at line 2068 of file TSQLFile.cxx.
|
virtual |
create SQL key, which will store object in data base
Reimplemented from TFile.
Definition at line 776 of file TSQLFile.cxx.
|
virtual |
create SQL key, which will store object in data base
Reimplemented from TFile.
Definition at line 784 of file TSQLFile.cxx.
|
protected |
Create the raw table.
Definition at line 2150 of file TSQLFile.cxx.
|
protected |
Returns next possible key identifier.
Definition at line 1765 of file TSQLFile.cxx.
Proposes table name for class.
Definition at line 1843 of file TSQLFile.cxx.
Remove key with specified id from keys table also removes all objects data, related to this table.
Definition at line 1619 of file TSQLFile.cxx.
|
protectedvirtual |
Create entry for directory in database.
Reimplemented from TFile.
Definition at line 2589 of file TSQLFile.cxx.
|
protectedvirtual |
Read directory list of keys from database.
Reimplemented from TFile.
Definition at line 2604 of file TSQLFile.cxx.
|
protectedvirtual |
Update dir header in the file.
Reimplemented from TFile.
Definition at line 2626 of file TSQLFile.cxx.
|
protectedvirtual |
Write directory keys list to database.
Reimplemented from TFile.
Definition at line 2618 of file TSQLFile.cxx.
Draw map of objects in this file.
Reimplemented from TFile.
Definition at line 209 of file TSQLFile.h.
|
inlinevirtual |
Encode file output buffer.
The file output buffer contains only the FREE data record.
Reimplemented from TFile.
Definition at line 210 of file TSQLFile.h.
|
protected |
Return (if exists) TSQLClassInfo for specified class name and version.
Definition at line 1781 of file TSQLFile.cxx.
|
protected |
return (if exists) TSQLClassInfo for specified class
Definition at line 1800 of file TSQLFile.cxx.
|
protected |
Search for TKeySQL object with specified keyid.
Definition at line 1678 of file TSQLFile.cxx.
|
inlinevirtual |
Synchronize a file's in-memory and on-disk states.
Reimplemented from TFile.
Definition at line 211 of file TSQLFile.h.
|
inline |
Definition at line 186 of file TSQLFile.h.
|
protected |
Method return request results for specified objid from streamer classtable.
Definition at line 2473 of file TSQLFile.cxx.
|
protected |
Method return request results for specified objid from streamer classtable Data returned in form of statement, where direct access to values are possible.
Definition at line 2489 of file TSQLFile.cxx.
const char * TSQLFile::GetDataBaseName | ( | ) | const |
Return name of data base on the host For Oracle always return 0.
Definition at line 631 of file TSQLFile.cxx.
|
inlinevirtual |
Reimplemented from TFile.
Definition at line 213 of file TSQLFile.h.
|
inlinevirtual |
Method returning errno. Is overriden in TRFIOFile.
Reimplemented from TFile.
Definition at line 214 of file TSQLFile.h.
|
protected |
Return current locking mode for that file.
Definition at line 1354 of file TSQLFile.cxx.
Returns value of string, extracted from special table, where long strings are stored.
Definition at line 2283 of file TSQLFile.cxx.
|
inlinevirtual |
Reimplemented from TFile.
Definition at line 220 of file TSQLFile.h.
|
inlinevirtual |
Reimplemented from TFile.
Definition at line 219 of file TSQLFile.h.
|
inlinevirtual |
Reimplemented from TFile.
Definition at line 218 of file TSQLFile.h.
|
protected |
Method return request result for specified objid from normal classtable.
Definition at line 2444 of file TSQLFile.cxx.
|
protected |
Return data for several objects from the range from normal class table.
Definition at line 2458 of file TSQLFile.cxx.
|
inline |
Definition at line 195 of file TSQLFile.h.
|
inlinevirtual |
Reimplemented from TFile.
Definition at line 221 of file TSQLFile.h.
|
inlinevirtual |
Reimplemented from TFile.
Definition at line 222 of file TSQLFile.h.
|
inlinevirtual |
Returns the current file size.
Returns -1 in case the file could not be stat'ed.
Reimplemented from TFile.
Definition at line 223 of file TSQLFile.h.
|
virtual |
Read back streamer infos from database List of streamer infos is always stored with key:id 0, which is not shown in normal keys list.
Reimplemented from TFile.
Definition at line 890 of file TSQLFile.cxx.
|
inline |
Definition at line 190 of file TSQLFile.h.
|
inline |
Definition at line 194 of file TSQLFile.h.
|
inline |
Definition at line 184 of file TSQLFile.h.
|
inline |
Definition at line 192 of file TSQLFile.h.
|
protected |
Test if table name exists.
Definition at line 1892 of file TSQLFile.cxx.
|
protected |
Update value of modify counter in config table Modify counter used to indicate that something was changed in database.
It will be used when multiple instances of TSQLFile for the same data base will be connected.
Definition at line 1194 of file TSQLFile.cxx.
initialize sql database and correspondent structures identical to TFile::Init() function
Definition at line 1004 of file TSQLFile.cxx.
Checks if this is long string code returns 0, if not or string id.
Definition at line 2234 of file TSQLFile.cxx.
Bool_t TSQLFile::IsMySQL | ( | ) | const |
checks, if MySQL database
Definition at line 471 of file TSQLFile.cxx.
Bool_t TSQLFile::IsODBC | ( | ) | const |
checks, if ODBC driver used for database connection
Definition at line 491 of file TSQLFile.cxx.
|
virtual |
return kTRUE if file is opened and can be accessed
Reimplemented from TFile.
Definition at line 720 of file TSQLFile.cxx.
Bool_t TSQLFile::IsOracle | ( | ) | const |
checks, if Oracle database
Definition at line 481 of file TSQLFile.cxx.
|
protected |
dummy, in future should check about read access to database
Definition at line 1378 of file TSQLFile.cxx.
|
protected |
Checks if main keys table is existing.
Definition at line 1324 of file TSQLFile.cxx.
|
protected |
Checkis, if lock is free in configuration tables.
Definition at line 1332 of file TSQLFile.cxx.
Mark unused bytes on the file.
The list of free segments is in the fFree linked list. When an object is deleted from the file, the freed space is added into the FREE linked list (fFree). The FREE list consists of a chain of consecutive free segments on the file. At the same time, the first 4 bytes of the freed record on the file are overwritten by GAPSIZE where GAPSIZE = -(Number of bytes occupied by the record).
Reimplemented from TFile.
Definition at line 231 of file TSQLFile.h.
|
inlinevirtual |
Generate source code necessary to access the objects stored in the file.
Generate code in directory dirname for all classes specified in argument classes If classes = "*" (default and currently the only supported value), the function generates an include file for each class in the StreamerInfo list for which a TClass object does not exist.
The code generated includes:
In the generated classes, map, multimap when the first template parameter is a class are replaced by a vector of pair. set and multiset when the tempalte parameter is a class are replaced by a vector. This is required since we do not have the code needed to order and/or compare the object of the classes. This is a quick explanation of the options available:
Option | Details |
---|---|
new (default) | A new directory dirname is created. If dirname already exist, an error message is printed and the function returns. |
recreate | If dirname does not exist, it is created (like in "new"). If dirname already exist, all existing files in dirname are deleted before creating the new files. |
update | New classes are added to the existing directory. Existing classes with the same name are replaced by the new definition. If the directory dirname doest not exist, same effect as "new". |
genreflex | Use genreflex rather than rootcint to generate the dictionary. |
par | Create a PAR file with the minimal set of code needed to read the content of the ROOT file. The name of the PAR file is basename(dirname), with extension '.par' enforced; the PAR file will be created at dirname(dirname). |
If, in addition to one of the 3 above options, the option "+" is specified, the function will generate:
gSystem->load("demo/demo.so");
The following feature is not yet enabled: One can restrict the list of classes to be generated by using expressions like:
classes = "Ali*" generate code only for classes starting with Ali classes = "myClass" generate code for class MyClass only.
Reimplemented from TFile.
Definition at line 232 of file TSQLFile.h.
Produce SELECT statement which can be used to get all data of class cl in one SELECT statement.
This statement also can be used to create VIEW by command like mysql> CREATE VIEW TH1I_view AS $CLASSSELECT$ Where $CLASSSELECT$ argument should be produced by call f->MakeSelectQuery(TH1I::Class()); VIEWs supported by latest MySQL 5 and Oracle
Definition at line 1221 of file TSQLFile.cxx.
List the contents of a file sequentially.
For each logical record found, it prints:
Date/Time Record_Adress Logical_Record_Length ClassName CompressionFactor
Example of output
20010404/150437 At:64 N=150 TFile 20010404/150440 At:214 N=28326 TBasket CX = 1.13 20010404/150440 At:28540 N=29616 TBasket CX = 1.08 20010404/150440 At:58156 N=29640 TBasket CX = 1.08 20010404/150440 At:87796 N=29076 TBasket CX = 1.10 20010404/150440 At:116872 N=10151 TBasket CX = 3.15 20010404/150441 At:127023 N=28341 TBasket CX = 1.13 20010404/150441 At:155364 N=29594 TBasket CX = 1.08 20010404/150441 At:184958 N=29616 TBasket CX = 1.08 20010404/150441 At:214574 N=29075 TBasket CX = 1.10 20010404/150441 At:243649 N=9583 TBasket CX = 3.34 20010404/150442 At:253232 N=28324 TBasket CX = 1.13 20010404/150442 At:281556 N=29641 TBasket CX = 1.08 20010404/150442 At:311197 N=29633 TBasket CX = 1.08 20010404/150442 At:340830 N=29091 TBasket CX = 1.10 20010404/150442 At:369921 N=10341 TBasket CX = 3.09 20010404/150442 At:380262 N=509 TH1F CX = 1.93 20010404/150442 At:380771 N=1769 TH2F CX = 4.32 20010404/150442 At:382540 N=1849 TProfile CX = 1.65 20010404/150442 At:384389 N=18434 TNtuple CX = 4.51 20010404/150442 At:402823 N=307 KeysList 20010404/150443 At:403130 N=4548 StreamerInfo CX = 3.65 20010404/150443 At:407678 N=86 FreeSegments 20010404/150443 At:407764 N=1 END
If the parameter opt contains "forComp", the Date/Time is ommitted and the decompressed size is also printed.
Record_Adress Logical_Record_Length Key_Length Object_Record_Length ClassName CompressionFactor
Example of output
Reimplemented from TFile.
Definition at line 233 of file TSQLFile.h.
|
inlinevirtual |
Reimplemented from TFile.
Definition at line 234 of file TSQLFile.h.
make private to exclude copy operator
Definition at line 713 of file TSQLFile.cxx.
|
protected |
used by MakeClassSelectQuery method to add columns from table of class, specified by TVirtualStreamerInfo structure
Definition at line 1243 of file TSQLFile.cxx.
Read a buffer from the file.
This is the basic low level read operation. Returns kTRUE in case of failure.
Reimplemented from TFile.
Definition at line 237 of file TSQLFile.h.
Read a buffer from the file at the offset 'pos' in the file.
Returns kTRUE in case of failure. Compared to ReadBuffer(char*, Int_t), this routine does not change the cursor on the physical file representation (fD) if the data is in this TFile's cache.
Reimplemented from TFile.
Definition at line 238 of file TSQLFile.h.
|
protected |
read table configurations as special table
Definition at line 1060 of file TSQLFile.cxx.
|
inlinevirtual |
Read the FREE linked list.
Every file has a linked list (fFree) of free segments. This linked list has been written on the file via WriteFree as a single data record.
Reimplemented from TFile.
Definition at line 239 of file TSQLFile.h.
Read data of special kind of objects.
Definition at line 861 of file TSQLFile.cxx.
|
protected |
Read all class infos from IdsTable.
Definition at line 1920 of file TSQLFile.cxx.
|
inlinevirtual |
Attempt to recover file if not correctly closed.
The function returns the number of keys that have been recovered. If no keys can be recovered, the file will be declared Zombie by the calling function. This function is automatically called when opening a file. If the file is open in read only mode, the file is not modified. If open in update mode and the function finds something to recover, a new directory header is written to the file. When opening the file gain no message from Recover will be reported. If keys have been recovered, the file is usable and you can safely read the corresponding objects. If the file is not usable (a zombie), you can test for this case with code like:
If the file has been recovered, the bit kRecovered is set in the TFile object in memory. You can test if the file has been recovered with
if (f.TestBit(TFile::kRecovered)) {... the file has been recovered}
When writing TTrees to a file, it is important to save the Tree header at regular intervals (see TTree::AutoSave). If a file containing a Tree is recovered, the last Tree header written to the file will be used. In this case all the entries in all the branches written before writing the header are valid entries. One can disable the automatic recovery procedure by setting
TFile.Recover 0
in the system.rootrc file.
Reimplemented from TFile.
Definition at line 240 of file TSQLFile.h.
Reopen a file with a different access mode, like from READ to See TFile::Open() for details.
Reimplemented from TFile.
Definition at line 729 of file TSQLFile.cxx.
|
protected |
Search in database tables for specified class and return TSQLClassInfo object.
Definition at line 1808 of file TSQLFile.cxx.
|
protected |
Search in database tables for specified class and return TSQLClassInfo object.
Definition at line 1912 of file TSQLFile.cxx.
|
inlinevirtual |
Method resetting the errno. Is overridden in TRFIOFile.
Reimplemented from TFile.
Definition at line 215 of file TSQLFile.h.
Bool_t TSQLFile::Rollback | ( | ) |
Rollback all operations, done after StartTransaction() call.
Database should return to initial state.
Definition at line 597 of file TSQLFile.cxx.
|
protected |
save data which is not yet in Database Typically this is streamerinfos structures or
Definition at line 912 of file TSQLFile.cxx.
|
inlinevirtual |
Seek to a specific position in the file. Pos it either kBeg, kCur or kEnd.
Reimplemented from TFile.
Definition at line 242 of file TSQLFile.h.
Defines maximum number of columns for array representation If array size bigger than limit, array data will be converted to raw format This is usefull to prevent tables with very big number of columns If limit==0, all arrays will be stored in raw format If limit<0, all array values will be stored in column form Default value is 21.
Definition at line 518 of file TSQLFile.cxx.
Reimplemented from TFile.
Definition at line 244 of file TSQLFile.h.
Set locking mode for current database.
Definition at line 1340 of file TSQLFile.cxx.
void TSQLFile::SetTablesType | ( | const char * | tables_type | ) |
Defines tables type, which is used in CREATE TABLE statements Now is only used for MySQL database, where following types are supported: "BDB", "HEAP", "ISAM", "InnoDB", "MERGE", "MRG_MYISAM", "MYISAM" Default for TSQLFile is "InnoDB".
For more detailes see MySQL docs.
Definition at line 532 of file TSQLFile.cxx.
void TSQLFile::SetUseIndexes | ( | Int_t | use_type = kIndexesBasic | ) |
Specify usage of indexes for data tables
Index | Description |
---|---|
kIndexesNone = 0 | no indexes are used |
kIndexesBasic = 1 | indexes used only for keys list and objects list tables (default) |
kIndexesClass = 2 | index also created for every normal class table |
kIndexesAll = 3 | index created for every table, including streamer tables |
Indexes in general should increase speed of access to objects data, but they required more operations and more disk space on server side
Definition at line 619 of file TSQLFile.cxx.
enable/disable uasge of suffixes in columns names can be changed before first object is saved into file
Definition at line 502 of file TSQLFile.cxx.
void TSQLFile::SetUseTransactions | ( | Int_t | mode = kTransactionsAuto | ) |
Defines usage of transactions statements for writing objects data to database.
| Index | Description | |----—|----------—| | kTransactionsOff=0 - no transaction operation are allowed | | kTransactionsAuto=1 - automatic mode. Each write operation, produced by TSQLFile, will be supplied by START TRANSACTION and COMMIT calls. If any error happen, ROLLBACK will returns database to previous state | | kTransactionsUser=2 - transactions are delegated to user. Methods StartTransaction(), Commit() and Rollback() should be called by user. |
Default UseTransactions option is kTransactionsAuto
Definition at line 552 of file TSQLFile.cxx.
|
inlinevirtual |
Return the size in bytes of the file header.
Reimplemented from TFile.
Definition at line 245 of file TSQLFile.h.
|
inline |
Definition at line 188 of file TSQLFile.h.
supplies set of commands to server Commands is stored as array of TObjString
Definition at line 1479 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 132 of file TSQLFile.h.
|
protected |
Test if DB support statement and number of open statements is not exceeded.
Definition at line 1431 of file TSQLFile.cxx.
|
protected |
Commit SQL transaction.
Definition at line 1588 of file TSQLFile.cxx.
|
protected |
Returns sql type name which is most closer to ROOT basic type.
typ should be from TVirtualStreamerInfo:: constansts like TVirtualStreamerInfo::kInt
Definition at line 2573 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 133 of file TSQLFile.h.
|
inlineprotected |
Definition at line 142 of file TSQLFile.h.
|
protected |
Delete all tables in database.
Definition at line 1556 of file TSQLFile.cxx.
|
protected |
delete statement and decrease counter
Definition at line 1465 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 135 of file TSQLFile.h.
|
inlineprotected |
Definition at line 134 of file TSQLFile.h.
|
protected |
return SQL integer type
Definition at line 2581 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 136 of file TSQLFile.h.
|
protected |
returns maximum allowed length of identifiers
Definition at line 1604 of file TSQLFile.cxx.
|
protected |
Returns maximum value, found in specified columnname of table tablename Column type should be numeric.
Definition at line 1519 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 140 of file TSQLFile.h.
|
inlineprotected |
Definition at line 137 of file TSQLFile.h.
Read from objects table data for specified objectid.
Definition at line 2353 of file TSQLFile.cxx.
Produce array of TSQLObjectInfo objects for all objects, belong to that key Array should be deleted by calling function afterwards.
Definition at line 2380 of file TSQLFile.cxx.
|
protected |
Submits query to SQL server.
Flag Value | Effect |
---|---|
0 | result is not interesting and will be deleted |
1 | return result of submitted query |
2 | results is may be necessary for long time Oracle plugin do not support working with several TSQLResult |
objects, therefore explicit deep copy will be produced|
If ok!=0, it will contains kTRUE is Query was successfull, otherwise kFALSE
Definition at line 1395 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 138 of file TSQLFile.h.
|
protected |
Rollback all SQL operations, done after start transaction.
Definition at line 1596 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 130 of file TSQLFile.h.
|
inlineprotected |
Definition at line 131 of file TSQLFile.h.
|
protected |
Start SQL transaction.
Definition at line 1580 of file TSQLFile.cxx.
|
protected |
Produces SQL statement for currently conected DB server.
Definition at line 1445 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 139 of file TSQLFile.h.
|
protected |
Test, if table of specified name exists.
Definition at line 1499 of file TSQLFile.cxx.
|
inlineprotected |
Definition at line 141 of file TSQLFile.h.
void TSQLFile::StartLogFile | ( | const char * | fname | ) |
start logging of all SQL statements in specified file
Definition at line 451 of file TSQLFile.cxx.
Bool_t TSQLFile::StartTransaction | ( | ) |
Start user transaction.
This can be usesful, when big number of objects should be stored in data base and commitment required only if all operations were successful. In that case in the end of all operations method Commit() should be called. If operation on user-level is looks like not successful, method Rollback() will return database data and TSQLFile instance to previous state. In MySQL not all tables types support transaction mode of operation. See SetTablesType() method for details .
Definition at line 569 of file TSQLFile.cxx.
void TSQLFile::StopLogFile | ( | ) |
close logging file
Definition at line 460 of file TSQLFile.cxx.
|
protected |
Store object in database. Return stored object id or -1 if error.
Definition at line 2520 of file TSQLFile.cxx.
|
protected |
read keys for specified directory (when update == kFALSE) or update value for modified keys when update == kTRUE Returns number of successfully read keys or -1 if error
Definition at line 926 of file TSQLFile.cxx.
Interface to system close. All arguments like in POSIX close().
Reimplemented from TFile.
Definition at line 45 of file TSQLFile.h.
|
inlineprotectedvirtual |
Interface to system open. All arguments like in POSIX open().
Reimplemented from TFile.
Definition at line 44 of file TSQLFile.h.
Interface to system read. All arguments like in POSIX read().
Reimplemented from TFile.
Definition at line 46 of file TSQLFile.h.
|
inlineprotectedvirtual |
Interface to system lseek.
All arguments like in POSIX lseek() except that the offset and return value are of a type which are able to handle 64 bit file systems.
Reimplemented from TFile.
Definition at line 48 of file TSQLFile.h.
|
inlineprotectedvirtual |
Return file stat information.
The interface and return value is identical to TSystem::GetPathInfo(). The function returns 0 in case of success and 1 if the file could not be stat'ed.
Reimplemented from TFile.
Definition at line 49 of file TSQLFile.h.
Interface to system fsync. All arguments like in POSIX fsync().
Reimplemented from TFile.
Definition at line 50 of file TSQLFile.h.
Interface to system write. All arguments like in POSIX write().
Reimplemented from TFile.
Definition at line 47 of file TSQLFile.h.
Updates (overwrites) key data in KeysTable.
Definition at line 1730 of file TSQLFile.cxx.
|
protected |
Checks that table for big strings is exists If not, will be created.
Definition at line 2196 of file TSQLFile.cxx.
|
protected |
Checks that objects table is exists If not, table will be created Returns maximum value for existing objects id.
Definition at line 2314 of file TSQLFile.cxx.
|
inlinevirtual |
Write memory objects to this file.
Loop on all objects in memory (including subdirectories). A new key is created in the KEYS linked list for each object. The list of keys is then saved on the file (via WriteKeys) as a single data record. For values of opt see TObject::Write(). The directory header info is rewritten on the directory header record. The linked list of FREE segments is written. The file header is written (bytes 1->fBEGIN).
Reimplemented from TFile.
Definition at line 248 of file TSQLFile.h.
|
inlinevirtual |
One can not save a const TDirectory object.
Reimplemented from TFile.
Definition at line 249 of file TSQLFile.h.
Write a buffer to the file.
This is the basic low level write operation. Returns kTRUE in case of failure.
Reimplemented from TFile.
Definition at line 247 of file TSQLFile.h.
|
inlinevirtual |
Write FREE linked list on the file.
The linked list of FREE segments (fFree) is written as a single data record.
Reimplemented from TFile.
Definition at line 250 of file TSQLFile.h.
|
virtual |
Write file info like configurations, title, UUID and other.
Reimplemented from TFile.
Definition at line 792 of file TSQLFile.cxx.
Add entry into keys table.
Definition at line 1699 of file TSQLFile.cxx.
|
protected |
write special kind of object like streamer infos or file itself keys for that objects should exist in tables but not indicated in list of keys, therefore users can not get them with TDirectoryFile::Get() method
Definition at line 839 of file TSQLFile.cxx.
|
virtual |
Store all TVirtualStreamerInfo, used in file, in sql database.
Reimplemented from TFile.
Definition at line 800 of file TSQLFile.cxx.
|
friend |
Definition at line 32 of file TSQLFile.h.
|
friend |
Definition at line 33 of file TSQLFile.h.
|
friend |
Definition at line 38 of file TSQLFile.h.
|
friend |
Definition at line 37 of file TSQLFile.h.
|
friend |
Definition at line 36 of file TSQLFile.h.
|
friend |
Definition at line 34 of file TSQLFile.h.
|
friend |
Definition at line 35 of file TSQLFile.h.
|
protected |
! limit for array size. when array bigger, its content converted to raw format
Definition at line 150 of file TSQLFile.h.
|
protected |
! pointer on list of basic types specific for currently connected SQL server
Definition at line 159 of file TSQLFile.h.
|
protected |
! variable indicates can be basic configuration changed or not
Definition at line 151 of file TSQLFile.h.
|
protected |
! indicate if IdsTable exists
Definition at line 166 of file TSQLFile.h.
|
protected |
! log file with SQL statements
Definition at line 164 of file TSQLFile.h.
|
protected |
! indicates how many changes was done with database tables
Definition at line 156 of file TSQLFile.h.
|
protected |
! pointer on list of other SQL types like TEXT or blob
Definition at line 160 of file TSQLFile.h.
|
protected |
! how many query was applied
Definition at line 157 of file TSQLFile.h.
|
protected |
! interface to SQL database
Definition at line 144 of file TSQLFile.h.
|
protected |
! list of SQL class infos
Definition at line 146 of file TSQLFile.h.
|
protected |
! version of SQL I/O which is stored in configurations
Definition at line 149 of file TSQLFile.h.
|
protected |
! count numbers of active statements
Definition at line 167 of file TSQLFile.h.
|
protected |
! type, used in CREATE TABLE statements
Definition at line 152 of file TSQLFile.h.
|
protected |
! use indexes for tables: 0 - off, 1 - only for basic tables, 2 + normal class tables, 3 - all tables
Definition at line 154 of file TSQLFile.h.
|
protected |
! user name, used to access objects from database
Definition at line 162 of file TSQLFile.h.
|
protected |
! use suffixes in column names like fValue:Int_t or fObject:pointer
Definition at line 148 of file TSQLFile.h.
|
protected |
! use transaction statements for writing data into the tables
Definition at line 153 of file TSQLFile.h.