1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#pragma once
#include <odbc/OConnection.hxx>
#include <odbc/odbcbasedllapi.hxx>
#include <TDatabaseMetaDataBase.hxx>
namespace connectivity::odbc
{
//************ Class: ODatabaseMetaData
class OOO_DLLPUBLIC_ODBCBASE ODatabaseMetaData final :
public ODatabaseMetaDataBase
{
SQLHANDLE m_aConnectionHandle;
OConnection* m_pConnection;
bool m_bUseCatalog;
// cached database information
virtual OUString impl_getIdentifierQuoteString_throw( ) override;
virtual bool impl_isCatalogAtStart_throw( ) override;
virtual OUString impl_getCatalogSeparator_throw( ) override;
virtual bool impl_supportsCatalogsInTableDefinitions_throw( ) override;
virtual bool impl_supportsSchemasInTableDefinitions_throw( ) override ;
virtual bool impl_supportsCatalogsInDataManipulation_throw( ) override;
virtual bool impl_supportsSchemasInDataManipulation_throw( ) override ;
virtual bool impl_supportsMixedCaseQuotedIdentifiers_throw( ) override ;
virtual bool impl_supportsAlterTableWithAddColumn_throw( ) override;
virtual bool impl_supportsAlterTableWithDropColumn_throw( ) override;
virtual sal_Int32 impl_getMaxStatements_throw( ) override;
virtual sal_Int32 impl_getMaxTablesInSelect_throw( ) override;
virtual bool impl_storesMixedCaseQuotedIdentifiers_throw( ) override;
OUString getURLImpl();
virtual css::uno::Reference< css::sdbc::XResultSet > impl_getTypeInfo_throw() override;
virtual ~ODatabaseMetaData() override;
public:
ODatabaseMetaData(const SQLHANDLE _pHandle,OConnection* _pCon);
// XDatabaseMetaData
virtual sal_Bool SAL_CALL allProceduresAreCallable( ) override;
virtual sal_Bool SAL_CALL allTablesAreSelectable( ) override;
virtual OUString SAL_CALL getURL( ) override;
virtual OUString SAL_CALL getUserName( ) override;
virtual sal_Bool SAL_CALL isReadOnly( ) override;
virtual sal_Bool SAL_CALL nullsAreSortedHigh( ) override;
virtual sal_Bool SAL_CALL nullsAreSortedLow( ) override;
virtual sal_Bool SAL_CALL nullsAreSortedAtStart( ) override;
virtual sal_Bool SAL_CALL nullsAreSortedAtEnd( ) override;
virtual OUString SAL_CALL getDatabaseProductName( ) override;
virtual OUString SAL_CALL getDatabaseProductVersion( ) override;
virtual OUString SAL_CALL getDriverName( ) override;
virtual OUString SAL_CALL getDriverVersion( ) override;
virtual sal_Int32 SAL_CALL getDriverMajorVersion( ) override;
virtual sal_Int32 SAL_CALL getDriverMinorVersion( ) override;
virtual sal_Bool SAL_CALL usesLocalFiles( ) override;
virtual sal_Bool SAL_CALL usesLocalFilePerTable( ) override;
virtual sal_Bool SAL_CALL supportsMixedCaseIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesUpperCaseIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesLowerCaseIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesMixedCaseIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesUpperCaseQuotedIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesLowerCaseQuotedIdentifiers( ) override;
virtual OUString SAL_CALL getSQLKeywords( ) override;
virtual OUString SAL_CALL getNumericFunctions( ) override;
virtual OUString SAL_CALL getStringFunctions( ) override;
virtual OUString SAL_CALL getSystemFunctions( ) override;
virtual OUString SAL_CALL getTimeDateFunctions( ) override;
virtual OUString SAL_CALL getSearchStringEscape( ) override;
virtual OUString SAL_CALL getExtraNameCharacters( ) override;
virtual sal_Bool SAL_CALL supportsColumnAliasing( ) override;
virtual sal_Bool SAL_CALL nullPlusNonNullIsNull( ) override;
virtual sal_Bool SAL_CALL supportsTypeConversion( ) override;
virtual sal_Bool SAL_CALL supportsConvert( sal_Int32 fromType, sal_Int32 toType ) override;
virtual sal_Bool SAL_CALL supportsTableCorrelationNames( ) override;
virtual sal_Bool SAL_CALL supportsDifferentTableCorrelationNames( ) override;
virtual sal_Bool SAL_CALL supportsExpressionsInOrderBy( ) override;
virtual sal_Bool SAL_CALL supportsOrderByUnrelated( ) override;
virtual sal_Bool SAL_CALL supportsGroupBy( ) override;
virtual sal_Bool SAL_CALL supportsGroupByUnrelated( ) override;
virtual sal_Bool SAL_CALL supportsGroupByBeyondSelect( ) override;
virtual sal_Bool SAL_CALL supportsLikeEscapeClause( ) override;
virtual sal_Bool SAL_CALL supportsMultipleResultSets( ) override;
virtual sal_Bool SAL_CALL supportsMultipleTransactions( ) override;
virtual sal_Bool SAL_CALL supportsNonNullableColumns( ) override;
virtual sal_Bool SAL_CALL supportsMinimumSQLGrammar( ) override;
virtual sal_Bool SAL_CALL supportsCoreSQLGrammar( ) override;
virtual sal_Bool SAL_CALL supportsExtendedSQLGrammar( ) override;
virtual sal_Bool SAL_CALL supportsANSI92EntryLevelSQL( ) override;
virtual sal_Bool SAL_CALL supportsANSI92IntermediateSQL( ) override;
virtual sal_Bool SAL_CALL supportsANSI92FullSQL( ) override;
virtual sal_Bool SAL_CALL supportsIntegrityEnhancementFacility( ) override;
virtual sal_Bool SAL_CALL supportsOuterJoins( ) override;
virtual sal_Bool SAL_CALL supportsFullOuterJoins( ) override;
virtual sal_Bool SAL_CALL supportsLimitedOuterJoins( ) override;
virtual OUString SAL_CALL getSchemaTerm( ) override;
virtual OUString SAL_CALL getProcedureTerm( ) override;
virtual OUString SAL_CALL getCatalogTerm( ) override;
virtual sal_Bool SAL_CALL supportsSchemasInProcedureCalls( ) override;
virtual sal_Bool SAL_CALL supportsSchemasInIndexDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsSchemasInPrivilegeDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsCatalogsInProcedureCalls( ) override;
virtual sal_Bool SAL_CALL supportsCatalogsInIndexDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsCatalogsInPrivilegeDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsPositionedDelete( ) override;
virtual sal_Bool SAL_CALL supportsPositionedUpdate( ) override;
virtual sal_Bool SAL_CALL supportsSelectForUpdate( ) override;
virtual sal_Bool SAL_CALL supportsStoredProcedures( ) override;
virtual sal_Bool SAL_CALL supportsSubqueriesInComparisons( ) override;
virtual sal_Bool SAL_CALL supportsSubqueriesInExists( ) override;
virtual sal_Bool SAL_CALL supportsSubqueriesInIns( ) override;
virtual sal_Bool SAL_CALL supportsSubqueriesInQuantifieds( ) override;
virtual sal_Bool SAL_CALL supportsCorrelatedSubqueries( ) override;
virtual sal_Bool SAL_CALL supportsUnion( ) override;
virtual sal_Bool SAL_CALL supportsUnionAll( ) override;
virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossCommit( ) override;
virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossRollback( ) override;
virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossCommit( ) override;
virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossRollback( ) override;
virtual sal_Int32 SAL_CALL getMaxBinaryLiteralLength( ) override;
virtual sal_Int32 SAL_CALL getMaxCharLiteralLength( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInGroupBy( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInIndex( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInOrderBy( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInSelect( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInTable( ) override;
virtual sal_Int32 SAL_CALL getMaxConnections( ) override;
virtual sal_Int32 SAL_CALL getMaxCursorNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxIndexLength( ) override;
virtual sal_Int32 SAL_CALL getMaxSchemaNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxProcedureNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxCatalogNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxRowSize( ) override;
virtual sal_Bool SAL_CALL doesMaxRowSizeIncludeBlobs( ) override;
virtual sal_Int32 SAL_CALL getMaxStatementLength( ) override;
virtual sal_Int32 SAL_CALL getMaxTableNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxUserNameLength( ) override;
virtual sal_Int32 SAL_CALL getDefaultTransactionIsolation( ) override;
virtual sal_Bool SAL_CALL supportsTransactions( ) override;
virtual sal_Bool SAL_CALL supportsTransactionIsolationLevel( sal_Int32 level ) override;
virtual sal_Bool SAL_CALL supportsDataDefinitionAndDataManipulationTransactions( ) override;
virtual sal_Bool SAL_CALL supportsDataManipulationTransactionsOnly( ) override;
virtual sal_Bool SAL_CALL dataDefinitionCausesTransactionCommit( ) override;
virtual sal_Bool SAL_CALL dataDefinitionIgnoredInTransactions( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getProcedures( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& procedureNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getProcedureColumns( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& procedureNamePattern, const OUString& columnNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTables( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern, const css::uno::Sequence< OUString >& types ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getSchemas( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getCatalogs( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTableTypes( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getColumns( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern, const OUString& columnNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getColumnPrivileges( const css::uno::Any& catalog, const OUString& schema, const OUString& table, const OUString& columnNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTablePrivileges( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getBestRowIdentifier( const css::uno::Any& catalog, const OUString& schema, const OUString& table, sal_Int32 scope, sal_Bool nullable ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getVersionColumns( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getPrimaryKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getImportedKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getExportedKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getCrossReference( const css::uno::Any& primaryCatalog, const OUString& primarySchema, const OUString& primaryTable, const css::uno::Any& foreignCatalog, const OUString& foreignSchema, const OUString& foreignTable ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getIndexInfo( const css::uno::Any& catalog, const OUString& schema, const OUString& table, sal_Bool unique, sal_Bool approximate ) override;
virtual sal_Bool SAL_CALL supportsResultSetType( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 concurrency ) override;
virtual sal_Bool SAL_CALL ownUpdatesAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL ownDeletesAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL ownInsertsAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL othersUpdatesAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL othersDeletesAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL othersInsertsAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL updatesAreDetected( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL deletesAreDetected( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL insertsAreDetected( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL supportsBatchUpdates( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getUDTs( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& typeNamePattern, const css::uno::Sequence< sal_Int32 >& types ) override;
};
}
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|