1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski #ifndef _CONNECTIVITY_ODATABASEMETADATABASE_HXX_ 25*b1cdbd2cSJim Jagielski #define _CONNECTIVITY_ODATABASEMETADATABASE_HXX_ 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/XDatabaseMetaData2.hpp> 28*b1cdbd2cSJim Jagielski #include <cppuhelper/implbase2.hxx> 29*b1cdbd2cSJim Jagielski #include <comphelper/broadcasthelper.hxx> 30*b1cdbd2cSJim Jagielski #include <com/sun/star/lang/XEventListener.hpp> 31*b1cdbd2cSJim Jagielski #include "FDatabaseMetaDataResultSet.hxx" 32*b1cdbd2cSJim Jagielski #include <functional> 33*b1cdbd2cSJim Jagielski #include "connectivity/dbtoolsdllapi.hxx" 34*b1cdbd2cSJim Jagielski 35*b1cdbd2cSJim Jagielski namespace connectivity 36*b1cdbd2cSJim Jagielski { 37*b1cdbd2cSJim Jagielski typedef ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any > TConditions; 38*b1cdbd2cSJim Jagielski class OOO_DLLPUBLIC_DBTOOLS ODatabaseMetaDataBase : 39*b1cdbd2cSJim Jagielski public comphelper::OBaseMutex, 40*b1cdbd2cSJim Jagielski public ::cppu::WeakImplHelper2< ::com::sun::star::sdbc::XDatabaseMetaData2, 41*b1cdbd2cSJim Jagielski ::com::sun::star::lang::XEventListener> 42*b1cdbd2cSJim Jagielski { 43*b1cdbd2cSJim Jagielski private: 44*b1cdbd2cSJim Jagielski ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue > m_aConnectionInfo; 45*b1cdbd2cSJim Jagielski ::connectivity::ODatabaseMetaDataResultSet::ORows m_aTypeInfoRows; 46*b1cdbd2cSJim Jagielski 47*b1cdbd2cSJim Jagielski // cached database information 48*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_isCatalogAtStart; 49*b1cdbd2cSJim Jagielski ::std::pair<bool,::rtl::OUString> m_sCatalogSeparator; 50*b1cdbd2cSJim Jagielski ::std::pair<bool,::rtl::OUString> m_sIdentifierQuoteString; 51*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_supportsCatalogsInTableDefinitions; 52*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_supportsSchemasInTableDefinitions; 53*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_supportsCatalogsInDataManipulation; 54*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_supportsSchemasInDataManipulation; 55*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_supportsMixedCaseQuotedIdentifiers; 56*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_supportsAlterTableWithAddColumn; 57*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_supportsAlterTableWithDropColumn; 58*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Int32> m_MaxStatements; 59*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Int32> m_MaxTablesInSelect; 60*b1cdbd2cSJim Jagielski ::std::pair<bool,sal_Bool> m_storesMixedCaseQuotedIdentifiers; 61*b1cdbd2cSJim Jagielski callImplMethod(::std::pair<bool,T> & _rCache,const::std::mem_fun_t<T,ODatabaseMetaDataBase> & _pImplMethod)62*b1cdbd2cSJim Jagielski template <typename T> T callImplMethod(::std::pair<bool,T>& _rCache,const ::std::mem_fun_t<T,ODatabaseMetaDataBase>& _pImplMethod) 63*b1cdbd2cSJim Jagielski { 64*b1cdbd2cSJim Jagielski ::osl::MutexGuard aGuard( m_aMutex ); 65*b1cdbd2cSJim Jagielski if ( !_rCache.first ) 66*b1cdbd2cSJim Jagielski { 67*b1cdbd2cSJim Jagielski _rCache.second = _pImplMethod(this); 68*b1cdbd2cSJim Jagielski _rCache.first = true; 69*b1cdbd2cSJim Jagielski } 70*b1cdbd2cSJim Jagielski return _rCache.second; 71*b1cdbd2cSJim Jagielski } 72*b1cdbd2cSJim Jagielski protected: 73*b1cdbd2cSJim Jagielski ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > m_xConnection; 74*b1cdbd2cSJim Jagielski ::com::sun::star::uno::Reference< ::com::sun::star::lang::XEventListener> m_xListenerHelper; // forward the calls from the connection to me 75*b1cdbd2cSJim Jagielski 76*b1cdbd2cSJim Jagielski virtual ~ODatabaseMetaDataBase(); 77*b1cdbd2cSJim Jagielski 78*b1cdbd2cSJim Jagielski protected: 79*b1cdbd2cSJim Jagielski virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > impl_getTypeInfo_throw() = 0; 80*b1cdbd2cSJim Jagielski // cached database information 81*b1cdbd2cSJim Jagielski virtual ::rtl::OUString impl_getIdentifierQuoteString_throw( ) = 0; 82*b1cdbd2cSJim Jagielski virtual sal_Bool impl_isCatalogAtStart_throw( ) = 0; 83*b1cdbd2cSJim Jagielski virtual ::rtl::OUString impl_getCatalogSeparator_throw( ) = 0; 84*b1cdbd2cSJim Jagielski virtual sal_Bool impl_supportsCatalogsInTableDefinitions_throw( ) = 0; 85*b1cdbd2cSJim Jagielski virtual sal_Bool impl_supportsSchemasInTableDefinitions_throw( ) = 0; 86*b1cdbd2cSJim Jagielski virtual sal_Bool impl_supportsCatalogsInDataManipulation_throw( ) = 0; 87*b1cdbd2cSJim Jagielski virtual sal_Bool impl_supportsSchemasInDataManipulation_throw( ) = 0; 88*b1cdbd2cSJim Jagielski virtual sal_Bool impl_supportsMixedCaseQuotedIdentifiers_throw( ) = 0; 89*b1cdbd2cSJim Jagielski virtual sal_Bool impl_supportsAlterTableWithAddColumn_throw( ) = 0; 90*b1cdbd2cSJim Jagielski virtual sal_Bool impl_supportsAlterTableWithDropColumn_throw( ) = 0; 91*b1cdbd2cSJim Jagielski virtual sal_Int32 impl_getMaxStatements_throw( ) = 0; 92*b1cdbd2cSJim Jagielski virtual sal_Int32 impl_getMaxTablesInSelect_throw( ) = 0; 93*b1cdbd2cSJim Jagielski virtual sal_Bool impl_storesMixedCaseQuotedIdentifiers_throw( ) = 0; 94*b1cdbd2cSJim Jagielski 95*b1cdbd2cSJim Jagielski 96*b1cdbd2cSJim Jagielski public: 97*b1cdbd2cSJim Jagielski 98*b1cdbd2cSJim Jagielski ODatabaseMetaDataBase(const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _rxConnection,const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue >& _rInfo); 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski // XDatabaseMetaData2 101*b1cdbd2cSJim Jagielski virtual ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue > SAL_CALL getConnectionInfo( ) throw (::com::sun::star::uno::RuntimeException); 102*b1cdbd2cSJim Jagielski 103*b1cdbd2cSJim Jagielski // XEventListener 104*b1cdbd2cSJim Jagielski virtual void SAL_CALL disposing( const ::com::sun::star::lang::EventObject& Source ) throw(::com::sun::star::uno::RuntimeException); 105*b1cdbd2cSJim Jagielski 106*b1cdbd2cSJim Jagielski virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTypeInfo( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 107*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 108*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 109*b1cdbd2cSJim Jagielski virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getSchemas( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 110*b1cdbd2cSJim Jagielski virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getCatalogs( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 111*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 112*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 113*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 114*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 115*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 116*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 117*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 118*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 119*b1cdbd2cSJim Jagielski 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 ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 120*b1cdbd2cSJim Jagielski 121*b1cdbd2cSJim Jagielski virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > SAL_CALL getConnection( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 122*b1cdbd2cSJim Jagielski // cached database information 123*b1cdbd2cSJim Jagielski virtual ::rtl::OUString SAL_CALL getIdentifierQuoteString( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 124*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL isCatalogAtStart( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 125*b1cdbd2cSJim Jagielski virtual ::rtl::OUString SAL_CALL getCatalogSeparator( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 126*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL supportsCatalogsInTableDefinitions( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 127*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL supportsSchemasInTableDefinitions( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 128*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL supportsCatalogsInDataManipulation( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 129*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL supportsSchemasInDataManipulation( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 130*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL supportsMixedCaseQuotedIdentifiers( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 131*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL supportsAlterTableWithAddColumn( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 132*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL supportsAlterTableWithDropColumn( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 133*b1cdbd2cSJim Jagielski virtual sal_Int32 SAL_CALL getMaxStatements( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 134*b1cdbd2cSJim Jagielski virtual sal_Int32 SAL_CALL getMaxTablesInSelect( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 135*b1cdbd2cSJim Jagielski virtual sal_Bool SAL_CALL storesMixedCaseQuotedIdentifiers( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 136*b1cdbd2cSJim Jagielski }; 137*b1cdbd2cSJim Jagielski } 138*b1cdbd2cSJim Jagielski #endif // _CONNECTIVITY_ODATABASEMETADATABASE_HXX_ 139