Logo ROOT   6.18/05
Reference Guide
TSQLFile.h
Go to the documentation of this file.
1// @(#)root/sql:$Id$
2// Author: Sergey Linev 20/11/2005
3
4/*************************************************************************
5 * Copyright (C) 1995-2005, Rene Brun and Fons Rademakers. *
6 * All rights reserved. *
7 * *
8 * For the licensing terms see $ROOTSYS/LICENSE. *
9 * For the list of contributors see $ROOTSYS/README/CREDITS. *
10 *************************************************************************/
11
12#ifndef ROOT_TSQLFile
13#define ROOT_TSQLFile
14
15#include "TFile.h"
16#include <stdlib.h>
17
18class TList;
21
22class TSQLServer;
23class TSQLStatement;
24class TSQLResult;
25class TSQLRow;
26class TKeySQL;
27class TBufferSQL2;
28class TSQLClassInfo;
29
30class TSQLFile : public TFile {
31
32 friend class TBufferSQL2;
33 friend class TKeySQL;
34 friend class TSQLStructure;
35 friend class TSQLTableData;
36 friend class TSqlRegistry;
37 friend class TSqlRawBuffer;
38 friend class TSqlCmdsBuffer;
39
40protected:
42
43 // Interface to basic system I/O routines, suppressed
44 virtual Int_t SysOpen(const char *, Int_t, UInt_t) { return 0; }
45 virtual Int_t SysClose(Int_t) { return 0; }
46 virtual Int_t SysRead(Int_t, void *, Int_t) { return 0; }
47 virtual Int_t SysWrite(Int_t, const void *, Int_t) { return 0; }
48 virtual Long64_t SysSeek(Int_t, Long64_t, Int_t) { return 0; }
49 virtual Int_t SysStat(Int_t, Long_t *, Long64_t *, Long_t *, Long_t *) { return 0; }
50 virtual Int_t SysSync(Int_t) { return 0; }
51
52 // Overwrite methods for directory I/O
54 virtual Int_t DirReadKeys(TDirectory *);
55 virtual void DirWriteKeys(TDirectory *);
56 virtual void DirWriteHeader(TDirectory *);
57
58 InfoListRet GetStreamerInfoListImpl(bool lookupSICache);
59
60 // functions to manipulate basic tables (Configurations, Objects, Keys) in database
61 void SaveToDatabase();
64 void InitSqlDatabase(Bool_t create);
65 void CreateBasicTables();
67 void SetLocking(Int_t mode);
69
70 // function for read/write access infos
73
74 // generic sql functions
75 TSQLResult *SQLQuery(const char *cmd, Int_t flag = 0, Bool_t *res = 0);
77 TSQLStatement *SQLStatement(const char *cmd, Int_t bufsize = 1000);
80 Bool_t SQLTestTable(const char *tablename);
81 Long64_t SQLMaximumValue(const char *tablename, const char *columnname);
82 void SQLDeleteAllTables();
87
88 // operation with keys structures in database
89 void DeleteKeyFromDB(Long64_t keyid);
94 Int_t StreamKeysForDirectory(TDirectory *dir, Bool_t doupdate, Long64_t specialkeyid = -1, TKeySQL **specialkey = 0);
95
96 // handling SQL class info structures
97 TSQLClassInfo *FindSQLClassInfo(const char *clname, Int_t version);
99 TSQLClassInfo *RequestSQLClassInfo(const char *clname, Int_t version);
101 Bool_t CreateClassTable(TSQLClassInfo *sqlinfo, TObjArray *colinfos);
103
105 Int_t &tablecnt);
106 void AddIdEntry(Long64_t tableid, Int_t subid, Int_t type, const char *name, const char *sqlname, const char *info);
107 void ReadSQLClassInfos();
108 TString DefineTableName(const char *clname, Int_t version, Bool_t rawtable);
109 Bool_t HasTable(const char *name);
110
111 // operations with long string table
112 TString CodeLongString(Long64_t objid, Int_t strid);
113 Int_t IsLongStringCode(Long64_t objid, const char *value);
115 Bool_t GetLongString(Long64_t objid, Int_t strid, TString &value);
116
117 // operation with object tables in database
119 Bool_t SQLObjectInfo(Long64_t objid, TString &clname, Version_t &version);
122 TSQLResult *GetNormalClassDataAll(Long64_t minobjid, Long64_t maxobjid, TSQLClassInfo *sqlinfo);
125 Long64_t StoreObjectInTables(Long64_t keyid, const void *obj, const TClass *cl);
126 Bool_t WriteSpecialObject(Long64_t keyid, TObject *obj, const char *name, const char *title);
127 TObject *ReadSpecialObject(Long64_t keyid, TObject *obj = 0);
128
129 // sql specific types
130 const char *SQLCompatibleType(Int_t typ) const;
131 const char *SQLIntType() const;
132 const char *SQLSmallTextType() const { return fOtherTypes[0]; }
133 Int_t SQLSmallTextTypeLimit() const { return atoi(fOtherTypes[1]); }
134 const char *SQLBigTextType() const { return fOtherTypes[2]; }
135 const char *SQLDatetimeType() const { return fOtherTypes[3]; }
136 const char *SQLIdentifierQuote() const { return fOtherTypes[4]; }
137 const char *SQLDirIdColumn() const { return fOtherTypes[5]; }
138 const char *SQLKeyIdColumn() const { return fOtherTypes[6]; }
139 const char *SQLObjectIdColumn() const { return fOtherTypes[7]; }
140 const char *SQLRawIdColumn() const { return fOtherTypes[8]; }
141 const char *SQLStrIdColumn() const { return fOtherTypes[9]; }
142 const char *SQLNameSeparator() const { return fOtherTypes[10]; }
143 const char *SQLValueQuote() const { return fOtherTypes[11]; }
144 const char *SQLDefaultTableType() const { return fOtherTypes[12]; }
145
146 TSQLServer *fSQL; ///<! interface to SQL database
147
148 TList *fSQLClassInfos; ///<! list of SQL class infos
149
150 Bool_t fUseSuffixes; ///<! use suffixes in column names like fValue:Int_t or fObject:pointer
151 Int_t fSQLIOversion; ///<! version of SQL I/O which is stored in configurations
152 Int_t fArrayLimit; ///<! limit for array size. when array bigger, its content converted to raw format
153 Bool_t fCanChangeConfig; ///<! variable indicates can be basic configuration changed or not
154 TString fTablesType; ///<! type, used in CREATE TABLE statements
155 Int_t fUseTransactions; ///<! use transaction statements for writing data into the tables
156 Int_t fUseIndexes; ///<! use indexes for tables: 0 - off, 1 - only for basic tables, 2 + normal class tables, 3 -
157 ///all tables
158 Int_t fModifyCounter; ///<! indicates how many changes was done with database tables
159 Int_t fQuerisCounter; ///<! how many query was applied
160
161 const char **fBasicTypes; ///<! pointer on list of basic types specific for currently connected SQL server
162 const char **fOtherTypes; ///<! pointer on list of other SQL types like TEXT or blob
163
164 TString fUserName; ///<! user name, used to access objects from database
165
166 std::ofstream *fLogFile; ///<! log file with SQL statements
167
168 Bool_t fIdsTableExists; ///<! indicate if IdsTable exists
169 Int_t fStmtCounter; ///<! count numbers of active statements
170
171private:
172 // let the compiler do the job. gcc complains when the following line is activated
173 // TSQLFile(const TSQLFile &) {} //Files cannot be copied
174 void operator=(const TSQLFile &);
175
176public:
178
180
181 TSQLFile();
182 TSQLFile(const char *dbname, Option_t *option = "read", const char *user = "user", const char *pass = "pass");
183 virtual ~TSQLFile();
184
185 // configuration of SQL
187 void SetUseSuffixes(Bool_t on = kTRUE);
188 Int_t GetArrayLimit() const { return fArrayLimit; }
189 void SetArrayLimit(Int_t limit = 20);
191 void SetTablesType(const char *table_type);
192 const char *GetTablesType() const { return fTablesType.Data(); }
195 void SetUseIndexes(Int_t use_type = kIndexesBasic);
196 Int_t GetUseIndexes() const { return fUseIndexes; }
198 Int_t GetIOVersion() const { return fSQLIOversion; }
199
202 Bool_t Commit();
204
205 // log file for SQL statements
206 void StartLogFile(const char *fname); // *MENU*
207 void StopLogFile(); // *MENU*
208
209 virtual void Close(Option_t *option = ""); // *MENU*
210 virtual TKey *CreateKey(TDirectory *mother, const TObject *obj, const char *name, Int_t bufsize);
211 virtual TKey *CreateKey(TDirectory *mother, const void *obj, const TClass *cl, const char *name, Int_t bufsize);
212 virtual void DrawMap(const char * = "*", Option_t * = "") {}
213 virtual void FillBuffer(char *&) {}
214 virtual void Flush() {}
215
216 virtual Long64_t GetEND() const { return 0; }
217 virtual Int_t GetErrno() const { return 0; }
218 virtual void ResetErrno() const {}
219
220 const char *GetDataBaseName() const;
221 virtual Int_t GetNfree() const { return 0; }
222 virtual Int_t GetNbytesInfo() const { return 0; }
223 virtual Int_t GetNbytesFree() const { return 0; }
224 virtual Long64_t GetSeekFree() const { return 0; }
225 virtual Long64_t GetSeekInfo() const { return 0; }
226 virtual Long64_t GetSize() const { return 0; }
227
228 Bool_t IsMySQL() const;
229 virtual Bool_t IsOpen() const;
230 Bool_t IsOracle() const;
231 Bool_t IsODBC() const;
232
233 virtual void MakeFree(Long64_t, Long64_t) {}
234 virtual void MakeProject(const char *, const char * = "*", Option_t * = "new") {} // *MENU*
235 virtual void Map(Option_t *) {} //
236 virtual void Map() {} //
237 virtual void Paint(Option_t * = "") {}
238 virtual void Print(Option_t * = "") const {}
239 virtual Bool_t ReadBuffer(char *, Int_t) { return kFALSE; }
240 virtual Bool_t ReadBuffer(char *, Long64_t, Int_t) { return kFALSE; }
241 virtual void ReadFree() {}
242 virtual Int_t Recover() { return 0; }
243 virtual Int_t ReOpen(Option_t *mode);
244 virtual void Seek(Long64_t, ERelativeTo = kBeg) {}
245
246 virtual void SetEND(Long64_t) {}
247 virtual Int_t Sizeof() const { return 0; }
248
249 virtual Bool_t WriteBuffer(const char *, Int_t) { return kFALSE; }
250 virtual Int_t Write(const char * = 0, Int_t = 0, Int_t = 0) { return 0; }
251 virtual Int_t Write(const char * = 0, Int_t = 0, Int_t = 0) const { return 0; }
252 virtual void WriteFree() {}
253 virtual void WriteHeader();
254 virtual void WriteStreamerInfo();
255
256 ClassDef(TSQLFile, 1) // ROOT TFile interface to SQL database
257};
258
259#endif
int Int_t
Definition: RtypesCore.h:41
short Version_t
Definition: RtypesCore.h:61
unsigned int UInt_t
Definition: RtypesCore.h:42
const Bool_t kFALSE
Definition: RtypesCore.h:88
long Long_t
Definition: RtypesCore.h:50
bool Bool_t
Definition: RtypesCore.h:59
long long Long64_t
Definition: RtypesCore.h:69
const Bool_t kTRUE
Definition: RtypesCore.h:87
const char Option_t
Definition: RtypesCore.h:62
#define ClassDef(name, id)
Definition: Rtypes.h:326
char name[80]
Definition: TGX11.cxx:109
int type
Definition: TGX11.cxx:120
Converts data to SQL statements or read data from SQL tables.
Definition: TBufferSQL2.h:29
TClass instances represent classes, structs and namespaces in the ROOT type system.
Definition: TClass.h:75
Describe directory structure in memory.
Definition: TDirectory.h:34
A ROOT file is a suite of consecutive data records (TKey instances) with a well defined format.
Definition: TFile.h:48
ERelativeTo
Definition: TFile.h:184
@ kBeg
Definition: TFile.h:184
TKeySQL represents meta-inforamtion about object, which was written to SQL database.
Definition: TKeySQL.h:19
Book space in a file, create I/O buffers, to fill them, (un)compress them.
Definition: TKey.h:24
A doubly linked list.
Definition: TList.h:44
An array of TObjects.
Definition: TObjArray.h:37
Mother of all ROOT objects.
Definition: TObject.h:37
Contains information about tables specific to one class and version.
Definition: TSQLClassInfo.h:42
Access an SQL db via the TFile interface.
Definition: TSQLFile.h:30
Bool_t CreateClassTable(TSQLClassInfo *sqlinfo, TObjArray *colinfos)
Create normal class table if required.
Definition: TSQLFile.cxx:2072
TString MakeSelectQuery(TClass *cl)
Produce SELECT statement which can be used to get all data of class cl in one SELECT statement.
Definition: TSQLFile.cxx:1225
const char * SQLIdentifierQuote() const
Definition: TSQLFile.h:136
Long64_t VerifyObjectTable()
Checks that objects table is exists If not, table will be created Returns maximum value for existing ...
Definition: TSQLFile.cxx:2318
ELockingKinds
Definition: TSQLFile.h:41
@ kLockBusy
Definition: TSQLFile.h:41
@ kLockFree
Definition: TSQLFile.h:41
void SkipArrayLimit()
Definition: TSQLFile.h:190
TSQLResult * GetNormalClassData(Long64_t objid, TSQLClassInfo *sqlinfo)
Method return request result for specified objid from normal classtable.
Definition: TSQLFile.cxx:2448
TObject * ReadSpecialObject(Long64_t keyid, TObject *obj=0)
Read data of special kind of objects.
Definition: TSQLFile.cxx:861
Int_t GetIOVersion() const
Definition: TSQLFile.h:198
TSQLFile()
default TSQLFile constructor
Definition: TSQLFile.cxx:274
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...
Definition: TSQLFile.cxx:839
void StartLogFile(const char *fname)
start logging of all SQL statements in specified file
Definition: TSQLFile.cxx:451
Bool_t fUseSuffixes
! use suffixes in column names like fValue:Int_t or fObject:pointer
Definition: TSQLFile.h:150
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.
Definition: TSQLFile.cxx:2031
Bool_t ReadConfigurations()
read table configurations as special table
Definition: TSQLFile.cxx:1064
const char * GetTablesType() const
Definition: TSQLFile.h:192
virtual Int_t GetNbytesInfo() const
Definition: TSQLFile.h:222
virtual void WriteStreamerInfo()
Store all TVirtualStreamerInfo, used in file, in sql database.
Definition: TSQLFile.cxx:800
Int_t IsLongStringCode(Long64_t objid, const char *value)
Checks if this is long string code returns 0, if not or string id.
Definition: TSQLFile.cxx:2238
virtual void WriteFree()
Write FREE linked list on the file.
Definition: TSQLFile.h:252
void CreateBasicTables()
Creates initial tables in database This is table with configurations and table with keys Function cal...
Definition: TSQLFile.cxx:1126
Int_t GetUseTransactions() const
Definition: TSQLFile.h:194
virtual Bool_t ReadBuffer(char *, Int_t)
Read a buffer from the file.
Definition: TSQLFile.h:239
TSQLClassInfo * FindSQLClassInfo(const char *clname, Int_t version)
Return (if exists) TSQLClassInfo for specified class name and version.
Definition: TSQLFile.cxx:1785
const char * SQLDatetimeType() const
Definition: TSQLFile.h:135
friend class TSqlRegistry
Definition: TSQLFile.h:36
void ReadSQLClassInfos()
Read all class infos from IdsTable.
Definition: TSQLFile.cxx:1924
EIndexesKinds
Definition: TSQLFile.h:179
@ kIndexesNone
Definition: TSQLFile.h:179
@ kIndexesAll
Definition: TSQLFile.h:179
@ kIndexesBasic
Definition: TSQLFile.h:179
@ kIndexesClass
Definition: TSQLFile.h:179
virtual Int_t SysSync(Int_t)
Interface to system fsync. All arguments like in POSIX fsync().
Definition: TSQLFile.h:50
Bool_t Commit()
Commit transaction, started by StartTransaction() call.
Definition: TSQLFile.cxx:583
void IncrementModifyCounter()
Update value of modify counter in config table Modify counter used to indicate that something was cha...
Definition: TSQLFile.cxx:1198
Int_t fArrayLimit
! limit for array size. when array bigger, its content converted to raw format
Definition: TSQLFile.h:152
virtual Int_t SysClose(Int_t)
Interface to system close. All arguments like in POSIX close().
Definition: TSQLFile.h:45
void SetLocking(Int_t mode)
Set locking mode for current database.
Definition: TSQLFile.cxx:1344
virtual Int_t SysWrite(Int_t, const void *, Int_t)
Interface to system write. All arguments like in POSIX write().
Definition: TSQLFile.h:47
ETransactionKinds
Definition: TSQLFile.h:177
@ kTransactionsUser
Definition: TSQLFile.h:177
@ kTransactionsAuto
Definition: TSQLFile.h:177
@ kTransactionsOff
Definition: TSQLFile.h:177
virtual void SetEND(Long64_t)
Definition: TSQLFile.h:246
Bool_t SQLRollback()
Rollback all SQL operations, done after start transaction.
Definition: TSQLFile.cxx:1600
TObjArray * SQLObjectsInfo(Long64_t keyid)
Produce array of TSQLObjectInfo objects for all objects, belong to that key Array should be deleted b...
Definition: TSQLFile.cxx:2384
Bool_t GetUseSuffixes() const
Definition: TSQLFile.h:186
Bool_t SQLCanStatement()
Test if DB support statement and number of open statements is not exceeded.
Definition: TSQLFile.cxx:1435
Bool_t CreateRawTable(TSQLClassInfo *sqlinfo)
Create the raw table.
Definition: TSQLFile.cxx:2154
Long64_t StoreObjectInTables(Long64_t keyid, const void *obj, const TClass *cl)
Store object in database. Return stored object id or -1 if error.
Definition: TSQLFile.cxx:2524
void InitSqlDatabase(Bool_t create)
initialize sql database and correspondent structures identical to TFile::Init() function
Definition: TSQLFile.cxx:1008
const char * SQLStrIdColumn() const
Definition: TSQLFile.h:141
virtual Int_t Recover()
Attempt to recover file if not correctly closed.
Definition: TSQLFile.h:242
Bool_t SQLObjectInfo(Long64_t objid, TString &clname, Version_t &version)
Read from objects table data for specified objectid.
Definition: TSQLFile.cxx:2357
virtual Long64_t SysSeek(Int_t, Long64_t, Int_t)
Interface to system lseek.
Definition: TSQLFile.h:48
Int_t fQuerisCounter
! how many query was applied
Definition: TSQLFile.h:159
const char * SQLValueQuote() const
Definition: TSQLFile.h:143
friend class TSqlCmdsBuffer
Definition: TSQLFile.h:38
const char * SQLBigTextType() const
Definition: TSQLFile.h:134
virtual void Map(Option_t *)
List the contents of a file sequentially.
Definition: TSQLFile.h:235
Int_t GetLocking()
Return current locking mode for that file.
Definition: TSQLFile.cxx:1358
Bool_t HasTable(const char *name)
Test if table name exists.
Definition: TSQLFile.cxx:1896
TKeySQL * FindSQLKey(TDirectory *dir, Long64_t keyid)
Search for TKeySQL object with specified keyid.
Definition: TSQLFile.cxx:1682
const char * SQLDefaultTableType() const
Definition: TSQLFile.h:144
Bool_t Rollback()
Rollback all operations, done after StartTransaction() call.
Definition: TSQLFile.cxx:597
Bool_t IsWriteAccess()
Checkis, if lock is free in configuration tables.
Definition: TSQLFile.cxx:1336
virtual void Seek(Long64_t, ERelativeTo=kBeg)
Seek to a specific position in the file. Pos it either kBeg, kCur or kEnd.
Definition: TSQLFile.h:244
void operator=(const TSQLFile &)
make private to exclude copy operator
Definition: TSQLFile.cxx:713
Bool_t IsMySQL() const
checks, if MySQL database
Definition: TSQLFile.cxx:471
void SQLDeleteAllTables()
Delete all tables in database.
Definition: TSQLFile.cxx:1560
Bool_t IsOracle() const
checks, if Oracle database
Definition: TSQLFile.cxx:481
virtual Bool_t WriteBuffer(const char *, Int_t)
Write a buffer to the file.
Definition: TSQLFile.h:249
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 upda...
Definition: TSQLFile.cxx:930
virtual Long64_t DirCreateEntry(TDirectory *)
Create entry for directory in database.
Definition: TSQLFile.cxx:2595
const char * SQLNameSeparator() const
Definition: TSQLFile.h:142
void SetTablesType(const char *table_type)
Defines tables type, which is used in CREATE TABLE statements Now is only used for MySQL database,...
Definition: TSQLFile.cxx:532
Int_t SQLSmallTextTypeLimit() const
Definition: TSQLFile.h:133
const char * SQLKeyIdColumn() const
Definition: TSQLFile.h:138
virtual Bool_t ReadBuffer(char *, Long64_t, Int_t)
Read a buffer from the file at the offset 'pos' in the file.
Definition: TSQLFile.h:240
Bool_t WriteKeyData(TKeySQL *key)
Add entry into keys table.
Definition: TSQLFile.cxx:1703
virtual void Paint(Option_t *="")
Paint all objects in the file.
Definition: TSQLFile.h:237
void SetUseTransactions(Int_t mode=kTransactionsAuto)
Defines usage of transactions statements for writing objects data to database.
Definition: TSQLFile.cxx:552
virtual void DrawMap(const char *="*", Option_t *="")
Draw map of objects in this file.
Definition: TSQLFile.h:212
Int_t fStmtCounter
! count numbers of active statements
Definition: TSQLFile.h:169
virtual Long64_t GetEND() const
Definition: TSQLFile.h:216
Bool_t fCanChangeConfig
! variable indicates can be basic configuration changed or not
Definition: TSQLFile.h:153
TString CodeLongString(Long64_t objid, Int_t strid)
Produces id which will be placed in column instead of string itself.
Definition: TSQLFile.cxx:2227
const char * SQLObjectIdColumn() const
Definition: TSQLFile.h:139
virtual ~TSQLFile()
destructor of TSQLFile object
Definition: TSQLFile.cxx:693
const char ** fOtherTypes
! pointer on list of other SQL types like TEXT or blob
Definition: TSQLFile.h:162
Bool_t fIdsTableExists
! indicate if IdsTable exists
Definition: TSQLFile.h:168
TSQLStatement * GetBlobClassDataStmt(Long64_t objid, TSQLClassInfo *sqlinfo)
Method return request results for specified objid from streamer classtable Data returned in form of s...
Definition: TSQLFile.cxx:2493
TSQLResult * GetBlobClassData(Long64_t objid, TSQLClassInfo *sqlinfo)
Method return request results for specified objid from streamer classtable.
Definition: TSQLFile.cxx:2477
virtual Int_t DirReadKeys(TDirectory *)
Read directory list of keys from database.
Definition: TSQLFile.cxx:2610
virtual void FillBuffer(char *&)
Encode file output buffer.
Definition: TSQLFile.h:213
void DeleteKeyFromDB(Long64_t keyid)
Remove key with specified id from keys table also removes all objects data, related to this table.
Definition: TSQLFile.cxx:1623
Bool_t SQLTestTable(const char *tablename)
Test, if table of specified name exists.
Definition: TSQLFile.cxx:1503
virtual Int_t GetNbytesFree() const
Definition: TSQLFile.h:223
const char * SQLIntType() const
return SQL integer type
Definition: TSQLFile.cxx:2587
TSQLStatement * SQLStatement(const char *cmd, Int_t bufsize=1000)
Produces SQL statement for currently conected DB server.
Definition: TSQLFile.cxx:1449
void SQLDeleteStatement(TSQLStatement *stmt)
delete statement and decrease counter
Definition: TSQLFile.cxx:1469
virtual void Print(Option_t *="") const
Print all objects in the file.
Definition: TSQLFile.h:238
virtual Long64_t GetSize() const
Returns the current file size.
Definition: TSQLFile.h:226
virtual void DirWriteHeader(TDirectory *)
Update dir header in the file.
Definition: TSQLFile.cxx:2632
TSQLResult * SQLQuery(const char *cmd, Int_t flag=0, Bool_t *res=0)
Submits query to SQL server.
Definition: TSQLFile.cxx:1399
TList * fSQLClassInfos
! list of SQL class infos
Definition: TSQLFile.h:148
virtual Int_t SysOpen(const char *, Int_t, UInt_t)
Interface to system open. All arguments like in POSIX open().
Definition: TSQLFile.h:44
std::ofstream * fLogFile
! log file with SQL statements
Definition: TSQLFile.h:166
Long64_t DefineNextKeyId()
Returns next possible key identifier.
Definition: TSQLFile.cxx:1769
virtual Int_t Write(const char *=0, Int_t=0, Int_t=0) const
One can not save a const TDirectory object.
Definition: TSQLFile.h:251
TSQLResult * GetNormalClassDataAll(Long64_t minobjid, Long64_t maxobjid, TSQLClassInfo *sqlinfo)
Return data for several objects from the range from normal class table.
Definition: TSQLFile.cxx:2462
virtual TKey * CreateKey(TDirectory *mother, const TObject *obj, const char *name, Int_t bufsize)
create SQL key, which will store object in data base
Definition: TSQLFile.cxx:776
Int_t GetUseIndexes() const
Definition: TSQLFile.h:196
friend class TSqlRawBuffer
Definition: TSQLFile.h:37
void SaveToDatabase()
save data which is not yet in Database Typically this is streamerinfos structures or
Definition: TSQLFile.cxx:916
virtual Int_t ReOpen(Option_t *mode)
Reopen a file with a different access mode, like from READ to See TFile::Open() for details.
Definition: TSQLFile.cxx:729
Bool_t SQLApplyCommands(TObjArray *cmds)
supplies set of commands to server Commands is stored as array of TObjString
Definition: TSQLFile.cxx:1483
Int_t GetQuerisCounter() const
Definition: TSQLFile.h:197
virtual Long64_t GetSeekFree() const
Definition: TSQLFile.h:224
const char ** fBasicTypes
! pointer on list of basic types specific for currently connected SQL server
Definition: TSQLFile.h:161
Bool_t IsReadAccess()
dummy, in future should check about read access to database
Definition: TSQLFile.cxx:1382
virtual void ReadFree()
Read the FREE linked list.
Definition: TSQLFile.h:241
InfoListRet GetStreamerInfoListImpl(bool lookupSICache)
Read back streamer infos from database List of streamer infos is always stored with key:id 0,...
Definition: TSQLFile.cxx:892
Int_t SQLMaxIdentifierLength()
returns maximum allowed length of identifiers
Definition: TSQLFile.cxx:1608
Bool_t GetLongString(Long64_t objid, Int_t strid, TString &value)
Returns value of string, extracted from special table, where long strings are stored.
Definition: TSQLFile.cxx:2287
virtual void Map()
Definition: TSQLFile.h:236
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 TVirtualStreamer...
Definition: TSQLFile.cxx:1247
Bool_t SQLCommit()
Commit SQL transaction.
Definition: TSQLFile.cxx:1592
const char * SQLRawIdColumn() const
Definition: TSQLFile.h:140
Bool_t UpdateKeyData(TKeySQL *key)
Updates (overwrites) key data in KeysTable.
Definition: TSQLFile.cxx:1734
TString fUserName
! user name, used to access objects from database
Definition: TSQLFile.h:164
virtual void ResetErrno() const
Method resetting the errno.
Definition: TSQLFile.h:218
Int_t fUseIndexes
! use indexes for tables: 0 - off, 1 - only for basic tables, 2 + normal class tables,...
Definition: TSQLFile.h:156
const char * GetDataBaseName() const
Return name of data base on the host For Oracle always return 0.
Definition: TSQLFile.cxx:631
void SetUseSuffixes(Bool_t on=kTRUE)
enable/disable uasge of suffixes in columns names can be changed before first object is saved into fi...
Definition: TSQLFile.cxx:502
virtual Int_t Write(const char *=0, Int_t=0, Int_t=0)
Write memory objects to this file.
Definition: TSQLFile.h:250
virtual Long64_t GetSeekInfo() const
Definition: TSQLFile.h:225
Int_t fUseTransactions
! use transaction statements for writing data into the tables
Definition: TSQLFile.h:155
virtual Int_t SysStat(Int_t, Long_t *, Long64_t *, Long_t *, Long_t *)
Return file stat information.
Definition: TSQLFile.h:49
TString DefineTableName(const char *clname, Int_t version, Bool_t rawtable)
Proposes table name for class.
Definition: TSQLFile.cxx:1847
Bool_t IsTablesExists()
Checks if main keys table is existing.
Definition: TSQLFile.cxx:1328
void StopLogFile()
close logging file
Definition: TSQLFile.cxx:460
void SetArrayLimit(Int_t limit=20)
Defines maximum number of columns for array representation If array size bigger than limit,...
Definition: TSQLFile.cxx:518
Long64_t SQLMaximumValue(const char *tablename, const char *columnname)
Returns maximum value, found in specified columnname of table tablename Column type should be numeric...
Definition: TSQLFile.cxx:1523
TSQLServer * fSQL
! interface to SQL database
Definition: TSQLFile.h:146
TString fTablesType
! type, used in CREATE TABLE statements
Definition: TSQLFile.h:154
virtual void WriteHeader()
Write file info like configurations, title, UUID and other.
Definition: TSQLFile.cxx:792
TSQLClassInfo * RequestSQLClassInfo(const char *clname, Int_t version)
Search in database tables for specified class and return TSQLClassInfo object.
Definition: TSQLFile.cxx:1812
Int_t GetArrayLimit() const
Definition: TSQLFile.h:188
Bool_t IsODBC() const
checks, if ODBC driver used for database connection
Definition: TSQLFile.cxx:491
virtual void MakeProject(const char *, const char *="*", Option_t *="new")
Generate source code necessary to access the objects stored in the file.
Definition: TSQLFile.h:234
Int_t fModifyCounter
! indicates how many changes was done with database tables
Definition: TSQLFile.h:158
virtual Int_t SysRead(Int_t, void *, Int_t)
Interface to system read. All arguments like in POSIX read().
Definition: TSQLFile.h:46
virtual Int_t GetNfree() const
Definition: TSQLFile.h:221
virtual Int_t GetErrno() const
Method returning errno.
Definition: TSQLFile.h:217
virtual Bool_t IsOpen() const
return kTRUE if file is opened and can be accessed
Definition: TSQLFile.cxx:720
const char * SQLDirIdColumn() const
Definition: TSQLFile.h:137
Int_t fSQLIOversion
! version of SQL I/O which is stored in configurations
Definition: TSQLFile.h:151
virtual void DirWriteKeys(TDirectory *)
Write directory keys list to database.
Definition: TSQLFile.cxx:2624
Bool_t StartTransaction()
Start user transaction.
Definition: TSQLFile.cxx:569
const char * SQLSmallTextType() const
Definition: TSQLFile.h:132
void SetUseIndexes(Int_t use_type=kIndexesBasic)
Specify usage of indexes for data tables.
Definition: TSQLFile.cxx:619
const char * SQLCompatibleType(Int_t typ) const
Returns sql type name which is most closer to ROOT basic type.
Definition: TSQLFile.cxx:2579
virtual void Flush()
Synchronize a file's in-memory and on-disk states.
Definition: TSQLFile.h:214
virtual void MakeFree(Long64_t, Long64_t)
Mark unused bytes on the file.
Definition: TSQLFile.h:233
virtual Int_t Sizeof() const
Return the size in bytes of the file header.
Definition: TSQLFile.h:247
Bool_t VerifyLongStringTable()
Checks that table for big strings is exists If not, will be created.
Definition: TSQLFile.cxx:2200
Bool_t SQLStartTransaction()
Start SQL transaction.
Definition: TSQLFile.cxx:1584
virtual void Close(Option_t *option="")
Close a SQL file For more comments see TFile::Close() function.
Definition: TSQLFile.cxx:645
This is hierarchical structure, which is created when data is written by TBufferSQL2.
Definition: TSQLStructure.h:94
Basic string class.
Definition: TString.h:131
const char * Data() const
Definition: TString.h:364
Abstract Interface class describing Streamer information for one class.