connectivity/source/inc/ado/ADatabaseMetaData.hxx

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