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 // MARKER(update_precomp.py): autogen include statement, do not remove 25*b1cdbd2cSJim Jagielski #include "precompiled_dbaccess.hxx" 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski #ifndef DBACCESS_SOURCE_SDBTOOLS_CONNECTION_OBJECTNAMES_HXX 28*b1cdbd2cSJim Jagielski #include "objectnames.hxx" 29*b1cdbd2cSJim Jagielski #endif 30*b1cdbd2cSJim Jagielski 31*b1cdbd2cSJim Jagielski #ifndef DBACCESS_MODULE_SDBT_HXX 32*b1cdbd2cSJim Jagielski #include "module_sdbt.hxx" 33*b1cdbd2cSJim Jagielski #endif 34*b1cdbd2cSJim Jagielski #ifndef DBACCESS_SDBT_RESOURCE_HRC 35*b1cdbd2cSJim Jagielski #include "sdbt_resource.hrc" 36*b1cdbd2cSJim Jagielski #endif 37*b1cdbd2cSJim Jagielski 38*b1cdbd2cSJim Jagielski /** === begin UNO includes === **/ 39*b1cdbd2cSJim Jagielski #include <com/sun/star/lang/NullPointerException.hpp> 40*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/CommandType.hpp> 41*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XTablesSupplier.hpp> 42*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/XQueriesSupplier.hpp> 43*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/ErrorCondition.hpp> 44*b1cdbd2cSJim Jagielski /** === end UNO includes === **/ 45*b1cdbd2cSJim Jagielski 46*b1cdbd2cSJim Jagielski #include <connectivity/dbmetadata.hxx> 47*b1cdbd2cSJim Jagielski #include <connectivity/dbtools.hxx> 48*b1cdbd2cSJim Jagielski #include <connectivity/sqlerror.hxx> 49*b1cdbd2cSJim Jagielski #include <cppuhelper/exc_hlp.hxx> 50*b1cdbd2cSJim Jagielski #include <rtl/ustrbuf.hxx> 51*b1cdbd2cSJim Jagielski #include <tools/string.hxx> 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski #include <boost/shared_ptr.hpp> 54*b1cdbd2cSJim Jagielski 55*b1cdbd2cSJim Jagielski //........................................................................ 56*b1cdbd2cSJim Jagielski namespace sdbtools 57*b1cdbd2cSJim Jagielski { 58*b1cdbd2cSJim Jagielski //........................................................................ 59*b1cdbd2cSJim Jagielski 60*b1cdbd2cSJim Jagielski /** === begin UNO using === **/ 61*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::Reference; 62*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::XConnection; 63*b1cdbd2cSJim Jagielski using ::com::sun::star::lang::NullPointerException; 64*b1cdbd2cSJim Jagielski using ::com::sun::star::lang::IllegalArgumentException; 65*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::RuntimeException; 66*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::SQLException; 67*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::XDatabaseMetaData; 68*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::XInterface; 69*b1cdbd2cSJim Jagielski using ::com::sun::star::container::XNameAccess; 70*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::XDatabaseMetaData; 71*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::UNO_QUERY_THROW; 72*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbcx::XTablesSupplier; 73*b1cdbd2cSJim Jagielski using ::com::sun::star::sdb::XQueriesSupplier; 74*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::Exception; 75*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::makeAny; 76*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::Any; 77*b1cdbd2cSJim Jagielski /** === end UNO using === **/ 78*b1cdbd2cSJim Jagielski 79*b1cdbd2cSJim Jagielski namespace CommandType = ::com::sun::star::sdb::CommandType; 80*b1cdbd2cSJim Jagielski namespace ErrorCondition = ::com::sun::star::sdb::ErrorCondition; 81*b1cdbd2cSJim Jagielski 82*b1cdbd2cSJim Jagielski //==================================================================== 83*b1cdbd2cSJim Jagielski //= INameValidation 84*b1cdbd2cSJim Jagielski //==================================================================== 85*b1cdbd2cSJim Jagielski class INameValidation 86*b1cdbd2cSJim Jagielski { 87*b1cdbd2cSJim Jagielski public: 88*b1cdbd2cSJim Jagielski virtual bool validateName( const ::rtl::OUString& _rName ) = 0; 89*b1cdbd2cSJim Jagielski virtual void validateName_throw( const ::rtl::OUString& _rName ) = 0; 90*b1cdbd2cSJim Jagielski ~INameValidation()91*b1cdbd2cSJim Jagielski virtual ~INameValidation() { } 92*b1cdbd2cSJim Jagielski }; 93*b1cdbd2cSJim Jagielski typedef ::boost::shared_ptr< INameValidation > PNameValidation; 94*b1cdbd2cSJim Jagielski 95*b1cdbd2cSJim Jagielski //==================================================================== 96*b1cdbd2cSJim Jagielski //= PlainExistenceCheck 97*b1cdbd2cSJim Jagielski //==================================================================== 98*b1cdbd2cSJim Jagielski class PlainExistenceCheck : public INameValidation 99*b1cdbd2cSJim Jagielski { 100*b1cdbd2cSJim Jagielski private: 101*b1cdbd2cSJim Jagielski const ::comphelper::ComponentContext m_aContext; 102*b1cdbd2cSJim Jagielski Reference< XConnection > m_xConnection; 103*b1cdbd2cSJim Jagielski Reference< XNameAccess > m_xContainer; 104*b1cdbd2cSJim Jagielski 105*b1cdbd2cSJim Jagielski public: PlainExistenceCheck(const::comphelper::ComponentContext & _rContext,const Reference<XConnection> & _rxConnection,const Reference<XNameAccess> & _rxContainer)106*b1cdbd2cSJim Jagielski PlainExistenceCheck( const ::comphelper::ComponentContext& _rContext, const Reference< XConnection >& _rxConnection, const Reference< XNameAccess >& _rxContainer ) 107*b1cdbd2cSJim Jagielski :m_aContext( _rContext ) 108*b1cdbd2cSJim Jagielski ,m_xConnection( _rxConnection ) 109*b1cdbd2cSJim Jagielski ,m_xContainer( _rxContainer ) 110*b1cdbd2cSJim Jagielski { 111*b1cdbd2cSJim Jagielski OSL_ENSURE( m_xContainer.is(), "PlainExistenceCheck::PlainExistenceCheck: this will crash!" ); 112*b1cdbd2cSJim Jagielski } 113*b1cdbd2cSJim Jagielski 114*b1cdbd2cSJim Jagielski // INameValidation validateName(const::rtl::OUString & _rName)115*b1cdbd2cSJim Jagielski virtual bool validateName( const ::rtl::OUString& _rName ) 116*b1cdbd2cSJim Jagielski { 117*b1cdbd2cSJim Jagielski return !m_xContainer->hasByName( _rName ); 118*b1cdbd2cSJim Jagielski } 119*b1cdbd2cSJim Jagielski validateName_throw(const::rtl::OUString & _rName)120*b1cdbd2cSJim Jagielski virtual void validateName_throw( const ::rtl::OUString& _rName ) 121*b1cdbd2cSJim Jagielski { 122*b1cdbd2cSJim Jagielski if ( validateName( _rName ) ) 123*b1cdbd2cSJim Jagielski return; 124*b1cdbd2cSJim Jagielski 125*b1cdbd2cSJim Jagielski ::connectivity::SQLError aErrors( m_aContext ); 126*b1cdbd2cSJim Jagielski SQLException aError( aErrors.getSQLException( ErrorCondition::DB_OBJECT_NAME_IS_USED, m_xConnection, _rName ) ); 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski ::dbtools::DatabaseMetaData aMeta( m_xConnection ); 129*b1cdbd2cSJim Jagielski if ( aMeta.supportsSubqueriesInFrom() ) 130*b1cdbd2cSJim Jagielski { 131*b1cdbd2cSJim Jagielski String sNeedDistinctNames( SdbtRes( STR_QUERY_AND_TABLE_DISTINCT_NAMES ) ); 132*b1cdbd2cSJim Jagielski aError.NextException <<= SQLException( sNeedDistinctNames, m_xConnection, ::rtl::OUString(), 0, Any() ); 133*b1cdbd2cSJim Jagielski } 134*b1cdbd2cSJim Jagielski 135*b1cdbd2cSJim Jagielski throw aError; 136*b1cdbd2cSJim Jagielski } 137*b1cdbd2cSJim Jagielski }; 138*b1cdbd2cSJim Jagielski 139*b1cdbd2cSJim Jagielski //==================================================================== 140*b1cdbd2cSJim Jagielski //= TableValidityCheck 141*b1cdbd2cSJim Jagielski //==================================================================== 142*b1cdbd2cSJim Jagielski class TableValidityCheck : public INameValidation 143*b1cdbd2cSJim Jagielski { 144*b1cdbd2cSJim Jagielski const ::comphelper::ComponentContext m_aContext; 145*b1cdbd2cSJim Jagielski const Reference< XConnection > m_xConnection; 146*b1cdbd2cSJim Jagielski 147*b1cdbd2cSJim Jagielski public: TableValidityCheck(const::comphelper::ComponentContext & _rContext,const Reference<XConnection> & _rxConnection)148*b1cdbd2cSJim Jagielski TableValidityCheck( const ::comphelper::ComponentContext& _rContext, const Reference< XConnection >& _rxConnection ) 149*b1cdbd2cSJim Jagielski :m_aContext( _rContext ) 150*b1cdbd2cSJim Jagielski ,m_xConnection( _rxConnection ) 151*b1cdbd2cSJim Jagielski { 152*b1cdbd2cSJim Jagielski } 153*b1cdbd2cSJim Jagielski validateName(const::rtl::OUString & _rName)154*b1cdbd2cSJim Jagielski virtual bool validateName( const ::rtl::OUString& _rName ) 155*b1cdbd2cSJim Jagielski { 156*b1cdbd2cSJim Jagielski ::dbtools::DatabaseMetaData aMeta( m_xConnection ); 157*b1cdbd2cSJim Jagielski if ( !aMeta.restrictIdentifiersToSQL92() ) 158*b1cdbd2cSJim Jagielski return true; 159*b1cdbd2cSJim Jagielski 160*b1cdbd2cSJim Jagielski ::rtl::OUString sCatalog, sSchema, sName; 161*b1cdbd2cSJim Jagielski ::dbtools::qualifiedNameComponents( 162*b1cdbd2cSJim Jagielski m_xConnection->getMetaData(), _rName, sCatalog, sSchema, sName, ::dbtools::eInTableDefinitions ); 163*b1cdbd2cSJim Jagielski 164*b1cdbd2cSJim Jagielski ::rtl::OUString sExtraNameCharacters( m_xConnection->getMetaData()->getExtraNameCharacters() ); 165*b1cdbd2cSJim Jagielski if ( ( sCatalog.getLength() && !::dbtools::isValidSQLName( sCatalog, sExtraNameCharacters ) ) 166*b1cdbd2cSJim Jagielski || ( sSchema.getLength() && !::dbtools::isValidSQLName( sSchema, sExtraNameCharacters ) ) 167*b1cdbd2cSJim Jagielski || ( sName.getLength() && !::dbtools::isValidSQLName( sName, sExtraNameCharacters ) ) 168*b1cdbd2cSJim Jagielski ) 169*b1cdbd2cSJim Jagielski return false; 170*b1cdbd2cSJim Jagielski 171*b1cdbd2cSJim Jagielski return true; 172*b1cdbd2cSJim Jagielski } 173*b1cdbd2cSJim Jagielski validateName_throw(const::rtl::OUString & _rName)174*b1cdbd2cSJim Jagielski virtual void validateName_throw( const ::rtl::OUString& _rName ) 175*b1cdbd2cSJim Jagielski { 176*b1cdbd2cSJim Jagielski if ( validateName( _rName ) ) 177*b1cdbd2cSJim Jagielski return; 178*b1cdbd2cSJim Jagielski 179*b1cdbd2cSJim Jagielski ::connectivity::SQLError aErrors( m_aContext ); 180*b1cdbd2cSJim Jagielski aErrors.raiseException( ErrorCondition::DB_INVALID_SQL_NAME, m_xConnection, _rName ); 181*b1cdbd2cSJim Jagielski } 182*b1cdbd2cSJim Jagielski }; 183*b1cdbd2cSJim Jagielski 184*b1cdbd2cSJim Jagielski //==================================================================== 185*b1cdbd2cSJim Jagielski //= QueryValidityCheck 186*b1cdbd2cSJim Jagielski //==================================================================== 187*b1cdbd2cSJim Jagielski class QueryValidityCheck : public INameValidation 188*b1cdbd2cSJim Jagielski { 189*b1cdbd2cSJim Jagielski const ::comphelper::ComponentContext m_aContext; 190*b1cdbd2cSJim Jagielski const Reference< XConnection > m_xConnection; 191*b1cdbd2cSJim Jagielski 192*b1cdbd2cSJim Jagielski public: QueryValidityCheck(const::comphelper::ComponentContext & _rContext,const Reference<XConnection> & _rxConnection)193*b1cdbd2cSJim Jagielski QueryValidityCheck( const ::comphelper::ComponentContext& _rContext, const Reference< XConnection >& _rxConnection ) 194*b1cdbd2cSJim Jagielski :m_aContext( _rContext ) 195*b1cdbd2cSJim Jagielski ,m_xConnection( _rxConnection ) 196*b1cdbd2cSJim Jagielski { 197*b1cdbd2cSJim Jagielski } 198*b1cdbd2cSJim Jagielski validateName_getErrorCondition(const::rtl::OUString & _rName)199*b1cdbd2cSJim Jagielski inline ::connectivity::ErrorCondition validateName_getErrorCondition( const ::rtl::OUString& _rName ) 200*b1cdbd2cSJim Jagielski { 201*b1cdbd2cSJim Jagielski if ( ( _rName.indexOf( (sal_Unicode)34 ) >= 0 ) // " 202*b1cdbd2cSJim Jagielski || ( _rName.indexOf( (sal_Unicode)39 ) >= 0 ) // ' 203*b1cdbd2cSJim Jagielski || ( _rName.indexOf( (sal_Unicode)96 ) >= 0 ) // 204*b1cdbd2cSJim Jagielski || ( _rName.indexOf( (sal_Unicode)145 ) >= 0 ) // 205*b1cdbd2cSJim Jagielski || ( _rName.indexOf( (sal_Unicode)146 ) >= 0 ) // 206*b1cdbd2cSJim Jagielski || ( _rName.indexOf( (sal_Unicode)180 ) >= 0 ) // #86621# removed unparsable chars 207*b1cdbd2cSJim Jagielski ) 208*b1cdbd2cSJim Jagielski return ErrorCondition::DB_QUERY_NAME_WITH_QUOTES; 209*b1cdbd2cSJim Jagielski 210*b1cdbd2cSJim Jagielski if ( _rName.indexOf( '/') >= 0 ) 211*b1cdbd2cSJim Jagielski return ErrorCondition::DB_OBJECT_NAME_WITH_SLASHES; 212*b1cdbd2cSJim Jagielski 213*b1cdbd2cSJim Jagielski return 0; 214*b1cdbd2cSJim Jagielski } 215*b1cdbd2cSJim Jagielski validateName(const::rtl::OUString & _rName)216*b1cdbd2cSJim Jagielski virtual bool validateName( const ::rtl::OUString& _rName ) 217*b1cdbd2cSJim Jagielski { 218*b1cdbd2cSJim Jagielski if ( validateName_getErrorCondition( _rName ) != 0 ) 219*b1cdbd2cSJim Jagielski return false; 220*b1cdbd2cSJim Jagielski return true; 221*b1cdbd2cSJim Jagielski } 222*b1cdbd2cSJim Jagielski validateName_throw(const::rtl::OUString & _rName)223*b1cdbd2cSJim Jagielski virtual void validateName_throw( const ::rtl::OUString& _rName ) 224*b1cdbd2cSJim Jagielski { 225*b1cdbd2cSJim Jagielski ::connectivity::ErrorCondition nErrorCondition = validateName_getErrorCondition( _rName ); 226*b1cdbd2cSJim Jagielski if ( nErrorCondition != 0 ) 227*b1cdbd2cSJim Jagielski { 228*b1cdbd2cSJim Jagielski ::connectivity::SQLError aErrors( m_aContext ); 229*b1cdbd2cSJim Jagielski aErrors.raiseException( nErrorCondition, m_xConnection ); 230*b1cdbd2cSJim Jagielski } 231*b1cdbd2cSJim Jagielski } 232*b1cdbd2cSJim Jagielski }; 233*b1cdbd2cSJim Jagielski 234*b1cdbd2cSJim Jagielski //==================================================================== 235*b1cdbd2cSJim Jagielski //= CombinedNameCheck 236*b1cdbd2cSJim Jagielski //==================================================================== 237*b1cdbd2cSJim Jagielski class CombinedNameCheck : public INameValidation 238*b1cdbd2cSJim Jagielski { 239*b1cdbd2cSJim Jagielski private: 240*b1cdbd2cSJim Jagielski PNameValidation m_pPrimary; 241*b1cdbd2cSJim Jagielski PNameValidation m_pSecondary; 242*b1cdbd2cSJim Jagielski 243*b1cdbd2cSJim Jagielski public: CombinedNameCheck(PNameValidation _pPrimary,PNameValidation _pSecondary)244*b1cdbd2cSJim Jagielski CombinedNameCheck( PNameValidation _pPrimary, PNameValidation _pSecondary ) 245*b1cdbd2cSJim Jagielski :m_pPrimary( _pPrimary ) 246*b1cdbd2cSJim Jagielski ,m_pSecondary( _pSecondary ) 247*b1cdbd2cSJim Jagielski { 248*b1cdbd2cSJim Jagielski OSL_ENSURE( m_pPrimary.get() && m_pSecondary.get(), "CombinedNameCheck::CombinedNameCheck: this will crash!" ); 249*b1cdbd2cSJim Jagielski } 250*b1cdbd2cSJim Jagielski 251*b1cdbd2cSJim Jagielski // INameValidation validateName(const::rtl::OUString & _rName)252*b1cdbd2cSJim Jagielski virtual bool validateName( const ::rtl::OUString& _rName ) 253*b1cdbd2cSJim Jagielski { 254*b1cdbd2cSJim Jagielski return m_pPrimary->validateName( _rName ) && m_pSecondary->validateName( _rName ); 255*b1cdbd2cSJim Jagielski } 256*b1cdbd2cSJim Jagielski validateName_throw(const::rtl::OUString & _rName)257*b1cdbd2cSJim Jagielski virtual void validateName_throw( const ::rtl::OUString& _rName ) 258*b1cdbd2cSJim Jagielski { 259*b1cdbd2cSJim Jagielski m_pPrimary->validateName_throw( _rName ); 260*b1cdbd2cSJim Jagielski m_pSecondary->validateName_throw( _rName ); 261*b1cdbd2cSJim Jagielski } 262*b1cdbd2cSJim Jagielski }; 263*b1cdbd2cSJim Jagielski 264*b1cdbd2cSJim Jagielski //==================================================================== 265*b1cdbd2cSJim Jagielski //= NameCheckFactory 266*b1cdbd2cSJim Jagielski //==================================================================== 267*b1cdbd2cSJim Jagielski class NameCheckFactory 268*b1cdbd2cSJim Jagielski { 269*b1cdbd2cSJim Jagielski public: 270*b1cdbd2cSJim Jagielski /** creates an INameValidation instance which can be used to check the existence of query or table names 271*b1cdbd2cSJim Jagielski 272*b1cdbd2cSJim Jagielski @param _rContext 273*b1cdbd2cSJim Jagielski the component's context 274*b1cdbd2cSJim Jagielski 275*b1cdbd2cSJim Jagielski @param _nCommandType 276*b1cdbd2cSJim Jagielski the type of objects (CommandType::TABLE or CommandType::QUERY) of which names shall be checked for existence 277*b1cdbd2cSJim Jagielski 278*b1cdbd2cSJim Jagielski @param _rxConnection 279*b1cdbd2cSJim Jagielski the connection relative to which the names are to be checked. Must be an SDB-level connection 280*b1cdbd2cSJim Jagielski 281*b1cdbd2cSJim Jagielski @throws IllegalArgumentException 282*b1cdbd2cSJim Jagielski if the given connection is no SDB-level connection 283*b1cdbd2cSJim Jagielski 284*b1cdbd2cSJim Jagielski @throws IllegalArgumentException 285*b1cdbd2cSJim Jagielski if the given command type is neither CommandType::TABLE or CommandType::QUERY 286*b1cdbd2cSJim Jagielski */ 287*b1cdbd2cSJim Jagielski static PNameValidation createExistenceCheck( 288*b1cdbd2cSJim Jagielski const ::comphelper::ComponentContext& _rContext, 289*b1cdbd2cSJim Jagielski sal_Int32 _nCommandType, 290*b1cdbd2cSJim Jagielski const Reference< XConnection >& _rxConnection 291*b1cdbd2cSJim Jagielski ); 292*b1cdbd2cSJim Jagielski 293*b1cdbd2cSJim Jagielski /** creates an INameValidation instance which can be used to check the validity of a query or table name 294*b1cdbd2cSJim Jagielski 295*b1cdbd2cSJim Jagielski @param _rContext 296*b1cdbd2cSJim Jagielski the component's context 297*b1cdbd2cSJim Jagielski 298*b1cdbd2cSJim Jagielski @param _nCommandType 299*b1cdbd2cSJim Jagielski the type of objects (CommandType::TABLE or CommandType::QUERY) of which names shall be validated 300*b1cdbd2cSJim Jagielski 301*b1cdbd2cSJim Jagielski @param _rxConnection 302*b1cdbd2cSJim Jagielski the connection relative to which the names are to be checked. Must be an SDB-level connection 303*b1cdbd2cSJim Jagielski 304*b1cdbd2cSJim Jagielski @throws IllegalArgumentException 305*b1cdbd2cSJim Jagielski if the given connection is no SDB-level connection 306*b1cdbd2cSJim Jagielski 307*b1cdbd2cSJim Jagielski @throws IllegalArgumentException 308*b1cdbd2cSJim Jagielski if the given command type is neither CommandType::TABLE or CommandType::QUERY 309*b1cdbd2cSJim Jagielski */ 310*b1cdbd2cSJim Jagielski static PNameValidation createValidityCheck( 311*b1cdbd2cSJim Jagielski const ::comphelper::ComponentContext& _rContext, 312*b1cdbd2cSJim Jagielski const sal_Int32 _nCommandType, 313*b1cdbd2cSJim Jagielski const Reference< XConnection >& _rxConnection 314*b1cdbd2cSJim Jagielski ); 315*b1cdbd2cSJim Jagielski 316*b1cdbd2cSJim Jagielski private: 317*b1cdbd2cSJim Jagielski NameCheckFactory(); // never implemented 318*b1cdbd2cSJim Jagielski 319*b1cdbd2cSJim Jagielski private: 320*b1cdbd2cSJim Jagielski static void verifyCommandType( sal_Int32 _nCommandType ); 321*b1cdbd2cSJim Jagielski }; 322*b1cdbd2cSJim Jagielski 323*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- verifyCommandType(sal_Int32 _nCommandType)324*b1cdbd2cSJim Jagielski void NameCheckFactory::verifyCommandType( sal_Int32 _nCommandType ) 325*b1cdbd2cSJim Jagielski { 326*b1cdbd2cSJim Jagielski if ( ( _nCommandType != CommandType::TABLE ) 327*b1cdbd2cSJim Jagielski && ( _nCommandType != CommandType::QUERY ) 328*b1cdbd2cSJim Jagielski ) 329*b1cdbd2cSJim Jagielski throw IllegalArgumentException( 330*b1cdbd2cSJim Jagielski String( SdbtRes( STR_INVALID_COMMAND_TYPE ) ), 331*b1cdbd2cSJim Jagielski NULL, 332*b1cdbd2cSJim Jagielski 0 333*b1cdbd2cSJim Jagielski ); 334*b1cdbd2cSJim Jagielski } 335*b1cdbd2cSJim Jagielski 336*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- createExistenceCheck(const::comphelper::ComponentContext & _rContext,sal_Int32 _nCommandType,const Reference<XConnection> & _rxConnection)337*b1cdbd2cSJim Jagielski PNameValidation NameCheckFactory::createExistenceCheck( const ::comphelper::ComponentContext& _rContext, sal_Int32 _nCommandType, const Reference< XConnection >& _rxConnection ) 338*b1cdbd2cSJim Jagielski { 339*b1cdbd2cSJim Jagielski verifyCommandType( _nCommandType ); 340*b1cdbd2cSJim Jagielski 341*b1cdbd2cSJim Jagielski ::dbtools::DatabaseMetaData aMeta( _rxConnection ); 342*b1cdbd2cSJim Jagielski 343*b1cdbd2cSJim Jagielski Reference< XNameAccess > xTables, xQueries; 344*b1cdbd2cSJim Jagielski try 345*b1cdbd2cSJim Jagielski { 346*b1cdbd2cSJim Jagielski Reference< XTablesSupplier > xSuppTables( _rxConnection, UNO_QUERY_THROW ); 347*b1cdbd2cSJim Jagielski Reference< XQueriesSupplier > xQueriesSupplier( _rxConnection, UNO_QUERY_THROW ); 348*b1cdbd2cSJim Jagielski xTables.set( xSuppTables->getTables(), UNO_QUERY_THROW ); 349*b1cdbd2cSJim Jagielski xQueries.set( xQueriesSupplier->getQueries(), UNO_QUERY_THROW ); 350*b1cdbd2cSJim Jagielski } 351*b1cdbd2cSJim Jagielski catch( const Exception& ) 352*b1cdbd2cSJim Jagielski { 353*b1cdbd2cSJim Jagielski throw IllegalArgumentException( 354*b1cdbd2cSJim Jagielski String( SdbtRes( STR_CONN_WITHOUT_QUERIES_OR_TABLES ) ), 355*b1cdbd2cSJim Jagielski NULL, 356*b1cdbd2cSJim Jagielski 0 357*b1cdbd2cSJim Jagielski ); 358*b1cdbd2cSJim Jagielski } 359*b1cdbd2cSJim Jagielski 360*b1cdbd2cSJim Jagielski PNameValidation pTableCheck( new PlainExistenceCheck( _rContext, _rxConnection, xTables ) ); 361*b1cdbd2cSJim Jagielski PNameValidation pQueryCheck( new PlainExistenceCheck( _rContext, _rxConnection, xQueries ) ); 362*b1cdbd2cSJim Jagielski PNameValidation pReturn; 363*b1cdbd2cSJim Jagielski 364*b1cdbd2cSJim Jagielski if ( aMeta.supportsSubqueriesInFrom() ) 365*b1cdbd2cSJim Jagielski pReturn.reset( new CombinedNameCheck( pTableCheck, pQueryCheck ) ); 366*b1cdbd2cSJim Jagielski else if ( _nCommandType == CommandType::TABLE ) 367*b1cdbd2cSJim Jagielski pReturn = pTableCheck; 368*b1cdbd2cSJim Jagielski else 369*b1cdbd2cSJim Jagielski pReturn = pQueryCheck; 370*b1cdbd2cSJim Jagielski return pReturn; 371*b1cdbd2cSJim Jagielski } 372*b1cdbd2cSJim Jagielski 373*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- createValidityCheck(const::comphelper::ComponentContext & _rContext,sal_Int32 _nCommandType,const Reference<XConnection> & _rxConnection)374*b1cdbd2cSJim Jagielski PNameValidation NameCheckFactory::createValidityCheck( const ::comphelper::ComponentContext& _rContext, sal_Int32 _nCommandType, const Reference< XConnection >& _rxConnection ) 375*b1cdbd2cSJim Jagielski { 376*b1cdbd2cSJim Jagielski verifyCommandType( _nCommandType ); 377*b1cdbd2cSJim Jagielski 378*b1cdbd2cSJim Jagielski Reference< XDatabaseMetaData > xMeta; 379*b1cdbd2cSJim Jagielski try 380*b1cdbd2cSJim Jagielski { 381*b1cdbd2cSJim Jagielski xMeta.set( _rxConnection->getMetaData(), UNO_QUERY_THROW ); 382*b1cdbd2cSJim Jagielski } 383*b1cdbd2cSJim Jagielski catch( const Exception& ) 384*b1cdbd2cSJim Jagielski { 385*b1cdbd2cSJim Jagielski throw IllegalArgumentException( 386*b1cdbd2cSJim Jagielski ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "The connection could not provide its database's meta data." ) ), 387*b1cdbd2cSJim Jagielski NULL, 388*b1cdbd2cSJim Jagielski 0 389*b1cdbd2cSJim Jagielski ); 390*b1cdbd2cSJim Jagielski } 391*b1cdbd2cSJim Jagielski 392*b1cdbd2cSJim Jagielski if ( _nCommandType == CommandType::TABLE ) 393*b1cdbd2cSJim Jagielski return PNameValidation( new TableValidityCheck( _rContext, _rxConnection ) ); 394*b1cdbd2cSJim Jagielski return PNameValidation( new QueryValidityCheck( _rContext, _rxConnection ) ); 395*b1cdbd2cSJim Jagielski } 396*b1cdbd2cSJim Jagielski 397*b1cdbd2cSJim Jagielski //==================================================================== 398*b1cdbd2cSJim Jagielski //= ObjectNames_Impl 399*b1cdbd2cSJim Jagielski //==================================================================== 400*b1cdbd2cSJim Jagielski struct ObjectNames_Impl 401*b1cdbd2cSJim Jagielski { 402*b1cdbd2cSJim Jagielski SdbtClient m_aModuleClient; // keep the module alive as long as this instance lives 403*b1cdbd2cSJim Jagielski }; 404*b1cdbd2cSJim Jagielski 405*b1cdbd2cSJim Jagielski //==================================================================== 406*b1cdbd2cSJim Jagielski //= ObjectNames 407*b1cdbd2cSJim Jagielski //==================================================================== 408*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- ObjectNames(const::comphelper::ComponentContext & _rContext,const Reference<XConnection> & _rxConnection)409*b1cdbd2cSJim Jagielski ObjectNames::ObjectNames( const ::comphelper::ComponentContext& _rContext, const Reference< XConnection >& _rxConnection ) 410*b1cdbd2cSJim Jagielski :ConnectionDependentComponent( _rContext ) 411*b1cdbd2cSJim Jagielski ,m_pImpl( new ObjectNames_Impl ) 412*b1cdbd2cSJim Jagielski { 413*b1cdbd2cSJim Jagielski if ( !_rxConnection.is() ) 414*b1cdbd2cSJim Jagielski throw NullPointerException(); 415*b1cdbd2cSJim Jagielski setWeakConnection( _rxConnection ); 416*b1cdbd2cSJim Jagielski } 417*b1cdbd2cSJim Jagielski 418*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- ~ObjectNames()419*b1cdbd2cSJim Jagielski ObjectNames::~ObjectNames() 420*b1cdbd2cSJim Jagielski { 421*b1cdbd2cSJim Jagielski } 422*b1cdbd2cSJim Jagielski 423*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- suggestName(::sal_Int32 _CommandType,const::rtl::OUString & _BaseName)424*b1cdbd2cSJim Jagielski ::rtl::OUString SAL_CALL ObjectNames::suggestName( ::sal_Int32 _CommandType, const ::rtl::OUString& _BaseName ) throw (IllegalArgumentException, RuntimeException) 425*b1cdbd2cSJim Jagielski { 426*b1cdbd2cSJim Jagielski EntryGuard aGuard( *this ); 427*b1cdbd2cSJim Jagielski 428*b1cdbd2cSJim Jagielski PNameValidation pNameCheck( NameCheckFactory::createExistenceCheck( getContext(), _CommandType, getConnection() ) ); 429*b1cdbd2cSJim Jagielski 430*b1cdbd2cSJim Jagielski String sBaseName( _BaseName ); 431*b1cdbd2cSJim Jagielski if ( sBaseName.Len() == 0 ) 432*b1cdbd2cSJim Jagielski { 433*b1cdbd2cSJim Jagielski if ( _CommandType == CommandType::TABLE ) 434*b1cdbd2cSJim Jagielski sBaseName = String( SdbtRes( STR_BASENAME_TABLE ) ); 435*b1cdbd2cSJim Jagielski else 436*b1cdbd2cSJim Jagielski sBaseName = String( SdbtRes( STR_BASENAME_QUERY ) ); 437*b1cdbd2cSJim Jagielski } 438*b1cdbd2cSJim Jagielski 439*b1cdbd2cSJim Jagielski ::rtl::OUString sName( sBaseName ); 440*b1cdbd2cSJim Jagielski sal_Int32 i = 1; 441*b1cdbd2cSJim Jagielski while ( !pNameCheck->validateName( sName ) ) 442*b1cdbd2cSJim Jagielski { 443*b1cdbd2cSJim Jagielski ::rtl::OUStringBuffer aNameBuffer; 444*b1cdbd2cSJim Jagielski aNameBuffer.append( sBaseName ); 445*b1cdbd2cSJim Jagielski aNameBuffer.appendAscii( " " ); 446*b1cdbd2cSJim Jagielski aNameBuffer.append( (sal_Int32)++i ); 447*b1cdbd2cSJim Jagielski sName = aNameBuffer.makeStringAndClear(); 448*b1cdbd2cSJim Jagielski } 449*b1cdbd2cSJim Jagielski 450*b1cdbd2cSJim Jagielski return sName; 451*b1cdbd2cSJim Jagielski } 452*b1cdbd2cSJim Jagielski 453*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- convertToSQLName(const::rtl::OUString & Name)454*b1cdbd2cSJim Jagielski ::rtl::OUString SAL_CALL ObjectNames::convertToSQLName( const ::rtl::OUString& Name ) throw (RuntimeException) 455*b1cdbd2cSJim Jagielski { 456*b1cdbd2cSJim Jagielski EntryGuard aGuard( *this ); 457*b1cdbd2cSJim Jagielski Reference< XDatabaseMetaData > xMeta( getConnection()->getMetaData(), UNO_QUERY_THROW ); 458*b1cdbd2cSJim Jagielski return ::dbtools::convertName2SQLName( Name, xMeta->getExtraNameCharacters() ); 459*b1cdbd2cSJim Jagielski } 460*b1cdbd2cSJim Jagielski 461*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- isNameUsed(::sal_Int32 _CommandType,const::rtl::OUString & _Name)462*b1cdbd2cSJim Jagielski ::sal_Bool SAL_CALL ObjectNames::isNameUsed( ::sal_Int32 _CommandType, const ::rtl::OUString& _Name ) throw (IllegalArgumentException, RuntimeException) 463*b1cdbd2cSJim Jagielski { 464*b1cdbd2cSJim Jagielski EntryGuard aGuard( *this ); 465*b1cdbd2cSJim Jagielski 466*b1cdbd2cSJim Jagielski PNameValidation pNameCheck( NameCheckFactory::createExistenceCheck( getContext(), _CommandType, getConnection()) ); 467*b1cdbd2cSJim Jagielski return !pNameCheck->validateName( _Name ); 468*b1cdbd2cSJim Jagielski } 469*b1cdbd2cSJim Jagielski 470*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- isNameValid(::sal_Int32 _CommandType,const::rtl::OUString & _Name)471*b1cdbd2cSJim Jagielski ::sal_Bool SAL_CALL ObjectNames::isNameValid( ::sal_Int32 _CommandType, const ::rtl::OUString& _Name ) throw (IllegalArgumentException, RuntimeException) 472*b1cdbd2cSJim Jagielski { 473*b1cdbd2cSJim Jagielski EntryGuard aGuard( *this ); 474*b1cdbd2cSJim Jagielski 475*b1cdbd2cSJim Jagielski PNameValidation pNameCheck( NameCheckFactory::createValidityCheck( getContext(), _CommandType, getConnection()) ); 476*b1cdbd2cSJim Jagielski return pNameCheck->validateName( _Name ); 477*b1cdbd2cSJim Jagielski } 478*b1cdbd2cSJim Jagielski 479*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- checkNameForCreate(::sal_Int32 _CommandType,const::rtl::OUString & _Name)480*b1cdbd2cSJim Jagielski void SAL_CALL ObjectNames::checkNameForCreate( ::sal_Int32 _CommandType, const ::rtl::OUString& _Name ) throw (SQLException, RuntimeException) 481*b1cdbd2cSJim Jagielski { 482*b1cdbd2cSJim Jagielski EntryGuard aGuard( *this ); 483*b1cdbd2cSJim Jagielski 484*b1cdbd2cSJim Jagielski PNameValidation pNameCheck( NameCheckFactory::createExistenceCheck( getContext(), _CommandType, getConnection() ) ); 485*b1cdbd2cSJim Jagielski pNameCheck->validateName_throw( _Name ); 486*b1cdbd2cSJim Jagielski 487*b1cdbd2cSJim Jagielski pNameCheck = NameCheckFactory::createValidityCheck( getContext(), _CommandType, getConnection() ); 488*b1cdbd2cSJim Jagielski pNameCheck->validateName_throw( _Name ); 489*b1cdbd2cSJim Jagielski } 490*b1cdbd2cSJim Jagielski 491*b1cdbd2cSJim Jagielski //........................................................................ 492*b1cdbd2cSJim Jagielski } // namespace sdbtools 493*b1cdbd2cSJim Jagielski //........................................................................ 494*b1cdbd2cSJim Jagielski 495