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_ADO_ADATABASEMETADATA_HXX_ 25 #define _CONNECTIVITY_ADO_ADATABASEMETADATA_HXX_ 26 27 #include "TDatabaseMetaDataBase.hxx" 28 #ifndef _MAP_ 29 #include <map> 30 #endif 31 32 33 namespace connectivity 34 { 35 namespace ado 36 { 37 class WpADOConnection; 38 class OConnection; 39 //************************************************************** 40 //************ Class: ODatabaseMetaData 41 //************************************************************** 42 43 class ODatabaseMetaData : public ODatabaseMetaDataBase 44 { 45 typedef struct _LiteralInfo 46 { 47 ::rtl::OUString pwszLiteralValue; 48 sal_uInt32 cchMaxLen; 49 sal_Bool fSupported; 50 } LiteralInfo; 51 52 ::std::map<sal_uInt32,LiteralInfo> m_aLiteralInfo; 53 WpADOConnection* m_pADOConnection; 54 OConnection* m_pConnection; 55 56 void fillLiterals(); 57 // get information out of rowset 58 sal_Int32 getMaxSize(sal_uInt32 _nId); 59 sal_Bool isCapable(sal_uInt32 _nId); 60 ::rtl::OUString getLiteral(sal_uInt32 _nProperty); 61 62 // get info out of propertyst 63 ::rtl::OUString getStringProperty(const ::rtl::OUString& _aProperty); 64 sal_Int32 getInt32Property(const ::rtl::OUString& _aProperty); 65 sal_Bool getBoolProperty(const ::rtl::OUString& _aProperty); 66 67 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > impl_getTypeInfo_throw(); 68 // cached database information 69 virtual ::rtl::OUString impl_getIdentifierQuoteString_throw( ); 70 virtual sal_Bool impl_isCatalogAtStart_throw( ); 71 virtual ::rtl::OUString impl_getCatalogSeparator_throw( ); 72 virtual sal_Bool impl_supportsCatalogsInTableDefinitions_throw( ); 73 virtual sal_Bool impl_supportsSchemasInTableDefinitions_throw( ) ; 74 virtual sal_Bool impl_supportsCatalogsInDataManipulation_throw( ); 75 virtual sal_Bool impl_supportsSchemasInDataManipulation_throw( ) ; 76 virtual sal_Bool impl_supportsMixedCaseQuotedIdentifiers_throw( ); 77 virtual sal_Bool impl_supportsAlterTableWithAddColumn_throw( ); 78 virtual sal_Bool impl_supportsAlterTableWithDropColumn_throw( ); 79 virtual sal_Int32 impl_getMaxStatements_throw( ); 80 virtual sal_Int32 impl_getMaxTablesInSelect_throw( ); 81 virtual sal_Bool impl_storesMixedCaseQuotedIdentifiers_throw( ); 82 public: 83 84 ODatabaseMetaData(OConnection* _pCon); 85 86 // XDatabaseMetaData 87 virtual sal_Bool SAL_CALL allProceduresAreCallable( ); 88 virtual sal_Bool SAL_CALL allTablesAreSelectable( ); 89 virtual ::rtl::OUString SAL_CALL getURL( ); 90 virtual ::rtl::OUString SAL_CALL getUserName( ); 91 virtual sal_Bool SAL_CALL isReadOnly( ); 92 virtual sal_Bool SAL_CALL nullsAreSortedHigh( ); 93 virtual sal_Bool SAL_CALL nullsAreSortedLow( ); 94 virtual sal_Bool SAL_CALL nullsAreSortedAtStart( ); 95 virtual sal_Bool SAL_CALL nullsAreSortedAtEnd( ); 96 virtual ::rtl::OUString SAL_CALL getDatabaseProductName( ); 97 virtual ::rtl::OUString SAL_CALL getDatabaseProductVersion( ); 98 virtual ::rtl::OUString SAL_CALL getDriverName( ); 99 virtual ::rtl::OUString SAL_CALL getDriverVersion( ); 100 virtual sal_Int32 SAL_CALL getDriverMajorVersion( ); 101 virtual sal_Int32 SAL_CALL getDriverMinorVersion( ); 102 virtual sal_Bool SAL_CALL usesLocalFiles( ); 103 virtual sal_Bool SAL_CALL usesLocalFilePerTable( ); 104 virtual sal_Bool SAL_CALL supportsMixedCaseIdentifiers( ); 105 virtual sal_Bool SAL_CALL storesUpperCaseIdentifiers( ); 106 virtual sal_Bool SAL_CALL storesLowerCaseIdentifiers( ); 107 virtual sal_Bool SAL_CALL storesMixedCaseIdentifiers( ); 108 109 virtual sal_Bool SAL_CALL storesUpperCaseQuotedIdentifiers( ); 110 virtual sal_Bool SAL_CALL storesLowerCaseQuotedIdentifiers( ); 111 112 virtual ::rtl::OUString SAL_CALL getSQLKeywords( ); 113 virtual ::rtl::OUString SAL_CALL getNumericFunctions( ); 114 virtual ::rtl::OUString SAL_CALL getStringFunctions( ); 115 virtual ::rtl::OUString SAL_CALL getSystemFunctions( ); 116 virtual ::rtl::OUString SAL_CALL getTimeDateFunctions( ); 117 virtual ::rtl::OUString SAL_CALL getSearchStringEscape( ); 118 virtual ::rtl::OUString SAL_CALL getExtraNameCharacters( ); 119 virtual sal_Bool SAL_CALL supportsColumnAliasing( ); 120 virtual sal_Bool SAL_CALL nullPlusNonNullIsNull( ); 121 virtual sal_Bool SAL_CALL supportsTypeConversion( ); 122 virtual sal_Bool SAL_CALL supportsConvert( sal_Int32 fromType, sal_Int32 toType ); 123 virtual sal_Bool SAL_CALL supportsTableCorrelationNames( ); 124 virtual sal_Bool SAL_CALL supportsDifferentTableCorrelationNames( ); 125 virtual sal_Bool SAL_CALL supportsExpressionsInOrderBy( ); 126 virtual sal_Bool SAL_CALL supportsOrderByUnrelated( ); 127 virtual sal_Bool SAL_CALL supportsGroupBy( ); 128 virtual sal_Bool SAL_CALL supportsGroupByUnrelated( ); 129 virtual sal_Bool SAL_CALL supportsGroupByBeyondSelect( ); 130 virtual sal_Bool SAL_CALL supportsLikeEscapeClause( ); 131 virtual sal_Bool SAL_CALL supportsMultipleResultSets( ); 132 virtual sal_Bool SAL_CALL supportsMultipleTransactions( ); 133 virtual sal_Bool SAL_CALL supportsNonNullableColumns( ); 134 virtual sal_Bool SAL_CALL supportsMinimumSQLGrammar( ); 135 virtual sal_Bool SAL_CALL supportsCoreSQLGrammar( ); 136 virtual sal_Bool SAL_CALL supportsExtendedSQLGrammar( ); 137 virtual sal_Bool SAL_CALL supportsANSI92EntryLevelSQL( ); 138 virtual sal_Bool SAL_CALL supportsANSI92IntermediateSQL( ); 139 virtual sal_Bool SAL_CALL supportsANSI92FullSQL( ); 140 virtual sal_Bool SAL_CALL supportsIntegrityEnhancementFacility( ); 141 virtual sal_Bool SAL_CALL supportsOuterJoins( ); 142 virtual sal_Bool SAL_CALL supportsFullOuterJoins( ); 143 virtual sal_Bool SAL_CALL supportsLimitedOuterJoins( ); 144 virtual ::rtl::OUString SAL_CALL getSchemaTerm( ); 145 virtual ::rtl::OUString SAL_CALL getProcedureTerm( ); 146 virtual ::rtl::OUString SAL_CALL getCatalogTerm( ); 147 virtual sal_Bool SAL_CALL supportsSchemasInProcedureCalls( ); 148 virtual sal_Bool SAL_CALL supportsSchemasInIndexDefinitions( ); 149 virtual sal_Bool SAL_CALL supportsSchemasInPrivilegeDefinitions( ); 150 virtual sal_Bool SAL_CALL supportsCatalogsInProcedureCalls( ); 151 virtual sal_Bool SAL_CALL supportsCatalogsInIndexDefinitions( ); 152 virtual sal_Bool SAL_CALL supportsCatalogsInPrivilegeDefinitions( ); 153 virtual sal_Bool SAL_CALL supportsPositionedDelete( ); 154 virtual sal_Bool SAL_CALL supportsPositionedUpdate( ); 155 virtual sal_Bool SAL_CALL supportsSelectForUpdate( ); 156 virtual sal_Bool SAL_CALL supportsStoredProcedures( ); 157 virtual sal_Bool SAL_CALL supportsSubqueriesInComparisons( ); 158 virtual sal_Bool SAL_CALL supportsSubqueriesInExists( ); 159 virtual sal_Bool SAL_CALL supportsSubqueriesInIns( ); 160 virtual sal_Bool SAL_CALL supportsSubqueriesInQuantifieds( ); 161 virtual sal_Bool SAL_CALL supportsCorrelatedSubqueries( ); 162 virtual sal_Bool SAL_CALL supportsUnion( ); 163 virtual sal_Bool SAL_CALL supportsUnionAll( ); 164 virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossCommit( ); 165 virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossRollback( ); 166 virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossCommit( ); 167 virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossRollback( ); 168 virtual sal_Int32 SAL_CALL getMaxBinaryLiteralLength( ); 169 virtual sal_Int32 SAL_CALL getMaxCharLiteralLength( ); 170 virtual sal_Int32 SAL_CALL getMaxColumnNameLength( ); 171 virtual sal_Int32 SAL_CALL getMaxColumnsInGroupBy( ); 172 virtual sal_Int32 SAL_CALL getMaxColumnsInIndex( ); 173 virtual sal_Int32 SAL_CALL getMaxColumnsInOrderBy( ); 174 virtual sal_Int32 SAL_CALL getMaxColumnsInSelect( ); 175 virtual sal_Int32 SAL_CALL getMaxColumnsInTable( ); 176 virtual sal_Int32 SAL_CALL getMaxConnections( ); 177 virtual sal_Int32 SAL_CALL getMaxCursorNameLength( ); 178 virtual sal_Int32 SAL_CALL getMaxIndexLength( ); 179 virtual sal_Int32 SAL_CALL getMaxSchemaNameLength( ); 180 virtual sal_Int32 SAL_CALL getMaxProcedureNameLength( ); 181 virtual sal_Int32 SAL_CALL getMaxCatalogNameLength( ); 182 virtual sal_Int32 SAL_CALL getMaxRowSize( ); 183 virtual sal_Bool SAL_CALL doesMaxRowSizeIncludeBlobs( ); 184 virtual sal_Int32 SAL_CALL getMaxStatementLength( ); 185 virtual sal_Int32 SAL_CALL getMaxTableNameLength( ); 186 virtual sal_Int32 SAL_CALL getMaxUserNameLength( ); 187 virtual sal_Int32 SAL_CALL getDefaultTransactionIsolation( ); 188 virtual sal_Bool SAL_CALL supportsTransactions( ); 189 virtual sal_Bool SAL_CALL supportsTransactionIsolationLevel( sal_Int32 level ); 190 virtual sal_Bool SAL_CALL supportsDataDefinitionAndDataManipulationTransactions( ); 191 virtual sal_Bool SAL_CALL supportsDataManipulationTransactionsOnly( ); 192 virtual sal_Bool SAL_CALL dataDefinitionCausesTransactionCommit( ); 193 virtual sal_Bool SAL_CALL dataDefinitionIgnoredInTransactions( ); 194 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 ); 195 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 ); 196 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 ); 197 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getSchemas( ); 198 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getCatalogs( ); 199 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTableTypes( ); 200 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 ); 201 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 ); 202 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 ); 203 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 ); 204 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 ); 205 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 ); 206 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 ); 207 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 ); 208 virtual sal_Bool SAL_CALL supportsResultSetType( sal_Int32 setType ); 209 virtual sal_Bool SAL_CALL supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 concurrency ); 210 virtual sal_Bool SAL_CALL ownUpdatesAreVisible( sal_Int32 setType ); 211 virtual sal_Bool SAL_CALL ownDeletesAreVisible( sal_Int32 setType ); 212 virtual sal_Bool SAL_CALL ownInsertsAreVisible( sal_Int32 setType ); 213 virtual sal_Bool SAL_CALL othersUpdatesAreVisible( sal_Int32 setType ); 214 virtual sal_Bool SAL_CALL othersDeletesAreVisible( sal_Int32 setType ); 215 virtual sal_Bool SAL_CALL othersInsertsAreVisible( sal_Int32 setType ); 216 virtual sal_Bool SAL_CALL updatesAreDetected( sal_Int32 setType ); 217 virtual sal_Bool SAL_CALL deletesAreDetected( sal_Int32 setType ); 218 virtual sal_Bool SAL_CALL insertsAreDetected( sal_Int32 setType ); 219 virtual sal_Bool SAL_CALL supportsBatchUpdates( ); 220 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 ); 221 }; 222 } 223 } 224 #endif // _CONNECTIVITY_ADO_ADATABASEMETADATA_HXX_ 225