Analysis Software
Documentation for sPHENIX simulation software
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
ODBCDatabaseMetaData.h
Go to the documentation of this file. Or view the newest version in sPHENIX GitHub for file ODBCDatabaseMetaData.h
1 // $Id: ODBCDatabaseMetaData.h,v 1.1.1.1 2004/02/18 20:58:02 dave Exp $
2 
3 #ifndef RDBC_ODBCDatabaseMetaData_h
4 #define RDBC_ODBCDatabaseMetaData_h
5 
6 //
7 // Provides several tons of information about a data source
8 //
9 
10 #ifndef RDBC_TSQLDatabaseMetaData_h
12 #endif
13 
16 {
17 friend class ODBCConnection;
18 
19 protected:
20 
21  ODBCDatabaseMetaData( TSQLConnection* connection,void* imp=0 );
22  virtual ~ODBCDatabaseMetaData();
23 
24 public:
25  Bool_t AllProceduresAreCallable();
26  Bool_t AllTablesAreSelectable();
27  TString GetUserName();
28  Bool_t IsReadOnly();
29  Bool_t NullsAreSortedHigh();
30  Bool_t NullsAreSortedLow();
31  Bool_t NullsAreSortedAtStart();
32  Bool_t NullsAreSortedAtEnd();
33  TString GetDatabaseProductName();
34  TString GetDatabaseProductVersion();
35  TString GetDriverName();
36  TString GetDriverVersion();
37  Int_t GetDriverMajorVersion();
38  Int_t GetDriverMinorVersion();
39  Bool_t UsesLocalFiles();
40  Bool_t UsesLocalFilePerTable();
49  TString GetIdentifierQuoteString();
50  TString GetSQLKeywords();
51  TString GetNumericFunctions();
52  TString GetStringFunctions();
53  TString GetSystemFunctions();
54  TString GetTimeDateFunctions();
55  TString GetSearchStringEscape();
56  TString GetExtraNameCharacters();
59  Bool_t SupportsColumnAliasing();
60  Bool_t NullPlusNonNullIsNull();
61  Bool_t SupportsConvert();
62  Bool_t SupportsConvert(Int_t fromType,Int_t toType);
66  Bool_t SupportsOrderByUnrelated();
67  Bool_t SupportsGroupBy();
68  Bool_t SupportsGroupByUnrelated();
70  Bool_t SupportsLikeEscapeClause();
75  Bool_t SupportsCoreSQLGrammar();
79  Bool_t SupportsANSI92FullSQL();
81  Bool_t SupportsOuterJoins();
82  Bool_t SupportsFullOuterJoins();
84  TString GetSchemaTerm();
85  TString GetTableTerm();
86  TString GetProcedureTerm();
87  TString GetCatalogTerm();
88  Bool_t IsCatalogAtStart();
89  TString GetCatalogSeparator();
100  Bool_t SupportsPositionedDelete();
101  Bool_t SupportsPositionedUpdate();
102  Bool_t SupportsSelectForUpdate();
103  Bool_t SupportsStoredProcedures();
106  Bool_t SupportsSubqueriesInIns();
109  Bool_t SupportsUnion();
110  Bool_t SupportsUnionAll();
116  Int_t GetMaxCharLiteralLength();
117  Int_t GetMaxColumnNameLength();
118  Int_t GetMaxColumnsInGroupBy();
119  Int_t GetMaxColumnsInIndex();
120  Int_t GetMaxColumnsInOrderBy();
121  Int_t GetMaxColumnsInSelect();
122  Int_t GetMaxColumnsInTable();
123  Int_t GetMaxConnections();
124  Int_t GetMaxCursorNameLength();
125  Int_t GetMaxIndexLength();
126  Int_t GetMaxSchemaNameLength();
128  Int_t GetMaxCatalogNameLength();
129  Int_t GetMaxRowSize();
131  Int_t GetMaxStatementLength();
132  Int_t GetMaxStatements();
133  Int_t GetMaxTableNameLength();
134  Int_t GetMaxTablesInSelect();
135  Int_t GetMaxUserNameLength();
137  Bool_t SupportsTransactions();
143  TSQLResultSet* GetProcedures( const TString& catalog,
144  const TString& schemaPattern,
145  const TString& procedureNamePattern );
146  TSQLResultSet* GetProcedureColumns( const TString& catalog,
147  const TString& schemaPattern,
148  const TString& procedureNamePattern,
149  const TString& columnNamePattern );
150  TSQLResultSet* GetTables( const TString& catalog,
151  const TString& schemaPattern,
152  const TString& tableNamePattern,
153  const TString& types );
157  TSQLResultSet* GetColumns( const TString& catalog,
158  const TString& schemaPattern,
159  const TString& tableNamePattern,
160  const TString& columnNamePattern );
161  TSQLResultSet* GetColumnPrivileges( const TString& catalog,
162  const TString& schema,
163  const TString& table,
164  const TString& columnNamePattern );
165  TSQLResultSet* GetTablePrivileges( const TString& catalog,
166  const TString& schemaPattern,
167  const TString& tableNamePattern );
168  TSQLResultSet* GetBestRowIdentifier( const TString& catalog,
169  const TString& schema,
170  const TString& table,
171  Int_t scope,
172  Bool_t nullable );
173  TSQLResultSet* GetVersionColumns( const TString& catalog,
174  const TString& schema,
175  const TString& table );
176  TSQLResultSet* GetPrimaryKeys( const TString& catalog,
177  const TString& schema,
178  const TString& table);
179  TSQLResultSet* GetImportedKeys( const TString& catalog,
180  const TString& schema,
181  const TString& table );
182  TSQLResultSet* GetExportedKeys( const TString& catalog,
183  const TString& schema,
184  const TString& table );
185  TSQLResultSet* GetCrossReference( const TString& primaryCatalog,
186  const TString& primarySchema,
187  const TString& primaryTable,
188  const TString& foreignCatalog,
189  const TString& foreignSchema,
190  const TString& foreignTable );
192  TSQLResultSet* GetIndexInfo( const TString& catalog,
193  const TString& schema,
194  const TString& table,
195  Bool_t unique,
196  Bool_t approximate );
197  Bool_t SupportsResultSetType(Int_t type);
198  Bool_t SupportsResultSetConcurrency( Int_t type,Int_t concurrency );
199  Bool_t OwnUpdatesAreVisible(Int_t type);
200  Bool_t OwnDeletesAreVisible(Int_t type);
201  Bool_t OwnInsertsAreVisible(Int_t type);
202  Bool_t OthersUpdatesAreVisible(Int_t type);
203  Bool_t OthersDeletesAreVisible(Int_t type);
204  Bool_t OthersInsertsAreVisible(Int_t type);
205  Bool_t UpdatesAreDetected(Int_t type);
206  Bool_t DeletesAreDetected(Int_t type);
207  Bool_t InsertsAreDetected(Int_t type);
208  Bool_t SupportsBatchUpdates();
209 
210 ClassDef(ODBCDatabaseMetaData,0) // Provides information about the database as a whole
211 };
212 
213 #endif // RDBC_ODBCDatabaseMetaData_h