1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 #ifndef _CONNECTIVITY_MACAB_DATABASEMETADATA_HXX_ 25 #define _CONNECTIVITY_MACAB_DATABASEMETADATA_HXX_ 26 27 #include "MacabConnection.hxx" 28 #include <com/sun/star/sdbc/XDatabaseMetaData.hpp> 29 #include <cppuhelper/implbase1.hxx> 30 31 namespace connectivity 32 { 33 namespace macab 34 { 35 //************************************************************** 36 //************ Class: MacabDatabaseMetaData 37 //************************************************************** 38 39 typedef ::cppu::WeakImplHelper1< ::com::sun::star::sdbc::XDatabaseMetaData> MacabDatabaseMetaData_BASE; 40 41 class MacabDatabaseMetaData : public MacabDatabaseMetaData_BASE 42 { 43 ::com::sun::star::uno::Reference< MacabConnection > m_xConnection; 44 sal_Bool m_bUseCatalog; 45 46 public: 47 getOwnConnection() const48 inline MacabConnection* getOwnConnection() const { return m_xConnection.get(); } 49 50 MacabDatabaseMetaData(MacabConnection* _pCon); 51 virtual ~MacabDatabaseMetaData(); 52 53 // this interface is really BIG 54 // XDatabaseMetaData 55 virtual sal_Bool SAL_CALL allProceduresAreCallable( ); 56 virtual sal_Bool SAL_CALL allTablesAreSelectable( ); 57 virtual ::rtl::OUString SAL_CALL getURL( ); 58 virtual ::rtl::OUString SAL_CALL getUserName( ); 59 virtual sal_Bool SAL_CALL isReadOnly( ); 60 virtual sal_Bool SAL_CALL nullsAreSortedHigh( ); 61 virtual sal_Bool SAL_CALL nullsAreSortedLow( ); 62 virtual sal_Bool SAL_CALL nullsAreSortedAtStart( ); 63 virtual sal_Bool SAL_CALL nullsAreSortedAtEnd( ); 64 virtual ::rtl::OUString SAL_CALL getDatabaseProductName( ); 65 virtual ::rtl::OUString SAL_CALL getDatabaseProductVersion( ); 66 virtual ::rtl::OUString SAL_CALL getDriverName( ); 67 virtual ::rtl::OUString SAL_CALL getDriverVersion( ); 68 virtual sal_Int32 SAL_CALL getDriverMajorVersion( ); 69 virtual sal_Int32 SAL_CALL getDriverMinorVersion( ); 70 virtual sal_Bool SAL_CALL usesLocalFiles( ); 71 virtual sal_Bool SAL_CALL usesLocalFilePerTable( ); 72 virtual sal_Bool SAL_CALL supportsMixedCaseIdentifiers( ); 73 virtual sal_Bool SAL_CALL storesUpperCaseIdentifiers( ); 74 virtual sal_Bool SAL_CALL storesLowerCaseIdentifiers( ); 75 virtual sal_Bool SAL_CALL storesMixedCaseIdentifiers( ); 76 virtual sal_Bool SAL_CALL supportsMixedCaseQuotedIdentifiers( ); 77 virtual sal_Bool SAL_CALL storesUpperCaseQuotedIdentifiers( ); 78 virtual sal_Bool SAL_CALL storesLowerCaseQuotedIdentifiers( ); 79 virtual sal_Bool SAL_CALL storesMixedCaseQuotedIdentifiers( ); 80 virtual ::rtl::OUString SAL_CALL getIdentifierQuoteString( ); 81 virtual ::rtl::OUString SAL_CALL getSQLKeywords( ); 82 virtual ::rtl::OUString SAL_CALL getNumericFunctions( ); 83 virtual ::rtl::OUString SAL_CALL getStringFunctions( ); 84 virtual ::rtl::OUString SAL_CALL getSystemFunctions( ); 85 virtual ::rtl::OUString SAL_CALL getTimeDateFunctions( ); 86 virtual ::rtl::OUString SAL_CALL getSearchStringEscape( ); 87 virtual ::rtl::OUString SAL_CALL getExtraNameCharacters( ); 88 virtual sal_Bool SAL_CALL supportsAlterTableWithAddColumn( ); 89 virtual sal_Bool SAL_CALL supportsAlterTableWithDropColumn( ); 90 virtual sal_Bool SAL_CALL supportsColumnAliasing( ); 91 virtual sal_Bool SAL_CALL nullPlusNonNullIsNull( ); 92 virtual sal_Bool SAL_CALL supportsTypeConversion( ); 93 virtual sal_Bool SAL_CALL supportsConvert( sal_Int32 fromType, sal_Int32 toType ); 94 virtual sal_Bool SAL_CALL supportsTableCorrelationNames( ); 95 virtual sal_Bool SAL_CALL supportsDifferentTableCorrelationNames( ); 96 virtual sal_Bool SAL_CALL supportsExpressionsInOrderBy( ); 97 virtual sal_Bool SAL_CALL supportsOrderByUnrelated( ); 98 virtual sal_Bool SAL_CALL supportsGroupBy( ); 99 virtual sal_Bool SAL_CALL supportsGroupByUnrelated( ); 100 virtual sal_Bool SAL_CALL supportsGroupByBeyondSelect( ); 101 virtual sal_Bool SAL_CALL supportsLikeEscapeClause( ); 102 virtual sal_Bool SAL_CALL supportsMultipleResultSets( ); 103 virtual sal_Bool SAL_CALL supportsMultipleTransactions( ); 104 virtual sal_Bool SAL_CALL supportsNonNullableColumns( ); 105 virtual sal_Bool SAL_CALL supportsMinimumSQLGrammar( ); 106 virtual sal_Bool SAL_CALL supportsCoreSQLGrammar( ); 107 virtual sal_Bool SAL_CALL supportsExtendedSQLGrammar( ); 108 virtual sal_Bool SAL_CALL supportsANSI92EntryLevelSQL( ); 109 virtual sal_Bool SAL_CALL supportsANSI92IntermediateSQL( ); 110 virtual sal_Bool SAL_CALL supportsANSI92FullSQL( ); 111 virtual sal_Bool SAL_CALL supportsIntegrityEnhancementFacility( ); 112 virtual sal_Bool SAL_CALL supportsOuterJoins( ); 113 virtual sal_Bool SAL_CALL supportsFullOuterJoins( ); 114 virtual sal_Bool SAL_CALL supportsLimitedOuterJoins( ); 115 virtual ::rtl::OUString SAL_CALL getSchemaTerm( ); 116 virtual ::rtl::OUString SAL_CALL getProcedureTerm( ); 117 virtual ::rtl::OUString SAL_CALL getCatalogTerm( ); 118 virtual sal_Bool SAL_CALL isCatalogAtStart( ); 119 virtual ::rtl::OUString SAL_CALL getCatalogSeparator( ); 120 virtual sal_Bool SAL_CALL supportsSchemasInDataManipulation( ); 121 virtual sal_Bool SAL_CALL supportsSchemasInProcedureCalls( ); 122 virtual sal_Bool SAL_CALL supportsSchemasInTableDefinitions( ); 123 virtual sal_Bool SAL_CALL supportsSchemasInIndexDefinitions( ); 124 virtual sal_Bool SAL_CALL supportsSchemasInPrivilegeDefinitions( ); 125 virtual sal_Bool SAL_CALL supportsCatalogsInDataManipulation( ); 126 virtual sal_Bool SAL_CALL supportsCatalogsInProcedureCalls( ); 127 virtual sal_Bool SAL_CALL supportsCatalogsInTableDefinitions( ); 128 virtual sal_Bool SAL_CALL supportsCatalogsInIndexDefinitions( ); 129 virtual sal_Bool SAL_CALL supportsCatalogsInPrivilegeDefinitions( ); 130 virtual sal_Bool SAL_CALL supportsPositionedDelete( ); 131 virtual sal_Bool SAL_CALL supportsPositionedUpdate( ); 132 virtual sal_Bool SAL_CALL supportsSelectForUpdate( ); 133 virtual sal_Bool SAL_CALL supportsStoredProcedures( ); 134 virtual sal_Bool SAL_CALL supportsSubqueriesInComparisons( ); 135 virtual sal_Bool SAL_CALL supportsSubqueriesInExists( ); 136 virtual sal_Bool SAL_CALL supportsSubqueriesInIns( ); 137 virtual sal_Bool SAL_CALL supportsSubqueriesInQuantifieds( ); 138 virtual sal_Bool SAL_CALL supportsCorrelatedSubqueries( ); 139 virtual sal_Bool SAL_CALL supportsUnion( ); 140 virtual sal_Bool SAL_CALL supportsUnionAll( ); 141 virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossCommit( ); 142 virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossRollback( ); 143 virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossCommit( ); 144 virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossRollback( ); 145 virtual sal_Int32 SAL_CALL getMaxBinaryLiteralLength( ); 146 virtual sal_Int32 SAL_CALL getMaxCharLiteralLength( ); 147 virtual sal_Int32 SAL_CALL getMaxColumnNameLength( ); 148 virtual sal_Int32 SAL_CALL getMaxColumnsInGroupBy( ); 149 virtual sal_Int32 SAL_CALL getMaxColumnsInIndex( ); 150 virtual sal_Int32 SAL_CALL getMaxColumnsInOrderBy( ); 151 virtual sal_Int32 SAL_CALL getMaxColumnsInSelect( ); 152 virtual sal_Int32 SAL_CALL getMaxColumnsInTable( ); 153 virtual sal_Int32 SAL_CALL getMaxConnections( ); 154 virtual sal_Int32 SAL_CALL getMaxCursorNameLength( ); 155 virtual sal_Int32 SAL_CALL getMaxIndexLength( ); 156 virtual sal_Int32 SAL_CALL getMaxSchemaNameLength( ); 157 virtual sal_Int32 SAL_CALL getMaxProcedureNameLength( ); 158 virtual sal_Int32 SAL_CALL getMaxCatalogNameLength( ); 159 virtual sal_Int32 SAL_CALL getMaxRowSize( ); 160 virtual sal_Bool SAL_CALL doesMaxRowSizeIncludeBlobs( ); 161 virtual sal_Int32 SAL_CALL getMaxStatementLength( ); 162 virtual sal_Int32 SAL_CALL getMaxStatements( ); 163 virtual sal_Int32 SAL_CALL getMaxTableNameLength( ); 164 virtual sal_Int32 SAL_CALL getMaxTablesInSelect( ); 165 virtual sal_Int32 SAL_CALL getMaxUserNameLength( ); 166 virtual sal_Int32 SAL_CALL getDefaultTransactionIsolation( ); 167 virtual sal_Bool SAL_CALL supportsTransactions( ); 168 virtual sal_Bool SAL_CALL supportsTransactionIsolationLevel( sal_Int32 level ); 169 virtual sal_Bool SAL_CALL supportsDataDefinitionAndDataManipulationTransactions( ); 170 virtual sal_Bool SAL_CALL supportsDataManipulationTransactionsOnly( ); 171 virtual sal_Bool SAL_CALL dataDefinitionCausesTransactionCommit( ); 172 virtual sal_Bool SAL_CALL dataDefinitionIgnoredInTransactions( ); 173 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getProcedures( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& procedureNamePattern ); 174 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getProcedureColumns( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& procedureNamePattern, const ::rtl::OUString& columnNamePattern ); 175 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTables( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern, const ::com::sun::star::uno::Sequence< ::rtl::OUString >& types ); 176 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getSchemas( ); 177 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getCatalogs( ); 178 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTableTypes( ); 179 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getColumns( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern, const ::rtl::OUString& columnNamePattern ); 180 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getColumnPrivileges( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table, const ::rtl::OUString& columnNamePattern ); 181 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTablePrivileges( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern ); 182 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getBestRowIdentifier( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table, sal_Int32 scope, sal_Bool nullable ); 183 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getVersionColumns( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ); 184 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getPrimaryKeys( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ); 185 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getImportedKeys( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ); 186 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getExportedKeys( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ); 187 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getCrossReference( const ::com::sun::star::uno::Any& primaryCatalog, const ::rtl::OUString& primarySchema, const ::rtl::OUString& primaryTable, const ::com::sun::star::uno::Any& foreignCatalog, const ::rtl::OUString& foreignSchema, const ::rtl::OUString& foreignTable ); 188 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTypeInfo( ); 189 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getIndexInfo( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table, sal_Bool unique, sal_Bool approximate ); 190 virtual sal_Bool SAL_CALL supportsResultSetType( sal_Int32 setType ); 191 virtual sal_Bool SAL_CALL supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 concurrency ); 192 virtual sal_Bool SAL_CALL ownUpdatesAreVisible( sal_Int32 setType ); 193 virtual sal_Bool SAL_CALL ownDeletesAreVisible( sal_Int32 setType ); 194 virtual sal_Bool SAL_CALL ownInsertsAreVisible( sal_Int32 setType ); 195 virtual sal_Bool SAL_CALL othersUpdatesAreVisible( sal_Int32 setType ); 196 virtual sal_Bool SAL_CALL othersDeletesAreVisible( sal_Int32 setType ); 197 virtual sal_Bool SAL_CALL othersInsertsAreVisible( sal_Int32 setType ); 198 virtual sal_Bool SAL_CALL updatesAreDetected( sal_Int32 setType ); 199 virtual sal_Bool SAL_CALL deletesAreDetected( sal_Int32 setType ); 200 virtual sal_Bool SAL_CALL insertsAreDetected( sal_Int32 setType ); 201 virtual sal_Bool SAL_CALL supportsBatchUpdates( ); 202 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getUDTs( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& typeNamePattern, const ::com::sun::star::uno::Sequence< sal_Int32 >& types ); 203 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > SAL_CALL getConnection( ); 204 }; 205 } 206 } 207 208 #endif // _CONNECTIVITY_MACAB_DATABASEMETADATA_HXX_ 209