dbaccess/source/ui/misc/dsmeta.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: dsmeta.cxx,v $
  10  * $Revision: 1.8.8.2 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 #include "dsmeta.hxx"
  32 #include <connectivity/DriversConfig.hxx>
  33 #include "dsntypes.hxx"
  34 #include <comphelper/processfactory.hxx>
  35 /** === begin UNO includes === **/
  36 /** === end UNO includes === **/
  37
  38 #include <map>
  39
  40 //........................................................................
  41 namespace dbaui
  42 {
  43 //........................................................................
  44
  45     /** === begin UNO using === **/
  46     using namespace dbaccess;
  47     using namespace ::com::sun::star;
  48     /** === end UNO using === **/
  49
  50     struct InitAdvanced : public AdvancedSettingsSupport
  51     {
  52         enum Special { All, AllButIgnoreCurrency, None };
  53
  54         InitAdvanced( Special _eType )
  55             :AdvancedSettingsSupport()
  56         {
  57             bGeneratedValues               = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  58             bUseSQL92NamingConstraints     = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  59             bAppendTableAliasInSelect      = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  60             bUseKeywordAsBeforeAlias       = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  61             bUseBracketedOuterJoinSyntax   = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  62             bIgnoreDriverPrivileges        = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  63             bParameterNameSubstitution     = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  64             bDisplayVersionColumns         = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  65             bUseCatalogInSelect            = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  66             bUseSchemaInSelect             = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  67             bUseIndexDirectionKeyword      = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  68             bUseDOSLineEnds                = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  69             bBooleanComparisonMode         = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  70             bFormsCheckRequiredFields      = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  71             bIgnoreCurrency                = ( _eType == All );
  72             bEscapeDateTime                = ( _eType == All ) || ( _eType == AllButIgnoreCurrency );
  73         }
  74     };
  75
  76     struct FeatureSupport
  77     {
  78         // authentication mode of the data source
  79         AuthenticationMode      eAuthentication;
  80
  81         FeatureSupport()
  82             :eAuthentication( AuthUserPwd )
  83         {
  84         }
  85
  86         FeatureSupport( AuthenticationMode _Auth )
  87             :eAuthentication( _Auth )
  88         {
  89         }
  90     };
  91
  92     //====================================================================
  93     //= global tables
  94     //====================================================================
  95     //--------------------------------------------------------------------
  96     static const AdvancedSettingsSupport& getAdvancedSettingsSupport( const ::rtl::OUString& _sURL )
  97     {
  98         DECLARE_STL_USTRINGACCESS_MAP( AdvancedSettingsSupport, AdvancedSupport);
  99         static AdvancedSupport s_aSupport;
 100         if ( s_aSupport.empty() )
 101         {
 102             ::connectivity::DriversConfig aDriverConfig(::comphelper::getProcessServiceFactory());
 103             const uno::Sequence< ::rtl::OUString > aURLs = aDriverConfig.getURLs();
 104             const ::rtl::OUString* pIter = aURLs.getConstArray();
 105             const ::rtl::OUString* pEnd = pIter + aURLs.getLength();
 106             for(;pIter != pEnd;++pIter)
 107             {
 108                 InitAdvanced aInit(InitAdvanced::None);
 109                 const uno::Sequence< beans::NamedValue> aProperties = aDriverConfig.getFeatures(*pIter).getNamedValues();
 110                 const beans::NamedValue* pPropertiesIter = aProperties.getConstArray();
 111                 const beans::NamedValue* pPropertiesEnd  = pPropertiesIter + aProperties.getLength();
 112                 for (;pPropertiesIter != pPropertiesEnd ; ++pPropertiesIter)
 113                 {
 114                     if ( pPropertiesIter->Name.equalsAscii("GeneratedValues") )
 115                     {
 116                         pPropertiesIter->Value >>= aInit.bGeneratedValues;
 117                     }
 118                     else if ( pPropertiesIter->Name.equalsAscii("UseSQL92NamingConstraints") )
 119                     {
 120                         pPropertiesIter->Value >>= aInit.bUseSQL92NamingConstraints;
 121                     }
 122                     else if ( pPropertiesIter->Name.equalsAscii("AppendTableAliasInSelect") )
 123                     {
 124                         pPropertiesIter->Value >>= aInit.bAppendTableAliasInSelect;
 125                     }
 126                     else if ( pPropertiesIter->Name.equalsAscii("UseKeywordAsBeforeAlias") )
 127                     {
 128                         pPropertiesIter->Value >>= aInit.bUseKeywordAsBeforeAlias;
 129                     }
 130                     else if ( pPropertiesIter->Name.equalsAscii("UseBracketedOuterJoinSyntax") )
 131                     {
 132                         pPropertiesIter->Value >>= aInit.bUseBracketedOuterJoinSyntax;
 133                     }
 134                     else if ( pPropertiesIter->Name.equalsAscii("IgnoreDriverPrivileges") )
 135                     {
 136                         pPropertiesIter->Value >>= aInit.bIgnoreDriverPrivileges;
 137                     }
 138                     else if ( pPropertiesIter->Name.equalsAscii("ParameterNameSubstitution") )
 139                     {
 140                         pPropertiesIter->Value >>= aInit.bParameterNameSubstitution;
 141                     }
 142                     else if ( pPropertiesIter->Name.equalsAscii("DisplayVersionColumns") )
 143                     {
 144                         pPropertiesIter->Value >>= aInit.bDisplayVersionColumns;
 145                     }
 146                     else if ( pPropertiesIter->Name.equalsAscii("UseCatalogInSelect") )
 147                     {
 148                         pPropertiesIter->Value >>= aInit.bUseCatalogInSelect;
 149                     }
 150                     else if ( pPropertiesIter->Name.equalsAscii("UseSchemaInSelect") )
 151                     {
 152                         pPropertiesIter->Value >>= aInit.bUseSchemaInSelect;
 153                     }
 154                     else if ( pPropertiesIter->Name.equalsAscii("UseIndexDirectionKeyword") )
 155                     {
 156                         pPropertiesIter->Value >>= aInit.bUseIndexDirectionKeyword;
 157                     }
 158                     else if ( pPropertiesIter->Name.equalsAscii("UseDOSLineEnds") )
 159                     {
 160                         pPropertiesIter->Value >>= aInit.bUseDOSLineEnds;
 161                     }
 162                     else if ( pPropertiesIter->Name.equalsAscii("BooleanComparisonMode") )
 163                     {
 164                         pPropertiesIter->Value >>= aInit.bBooleanComparisonMode;
 165                     }
 166                     else if ( pPropertiesIter->Name.equalsAscii("FormsCheckRequiredFields") )
 167                     {
 168                         pPropertiesIter->Value >>= aInit.bFormsCheckRequiredFields;
 169                     }
 170                     else if ( pPropertiesIter->Name.equalsAscii("IgnoreCurrency") )
 171                     {
 172                         pPropertiesIter->Value >>= aInit.bIgnoreCurrency;
 173                     }
 174                     else if ( pPropertiesIter->Name.equalsAscii("EscapeDateTime") )
 175                     {
 176                         pPropertiesIter->Value >>= aInit.bEscapeDateTime;
 177                     }
 178                 } // for (;pPropertiesIter != pPropertiesEnd ; ++pPropertiesIter)
 179                 s_aSupport.insert(AdvancedSupport::value_type(*pIter,aInit));
 180             }
 181         } // if ( s_aSupport.empty() )
 182         OSL_ENSURE(s_aSupport.find(_sURL) != s_aSupport.end(),"Illegal URL!");
 183         return s_aSupport[ _sURL ];
 184     }
 185
 186     //--------------------------------------------------------------------
 187     static AuthenticationMode getAuthenticationMode( const ::rtl::OUString& _sURL )
 188     {
 189         DECLARE_STL_USTRINGACCESS_MAP( FeatureSupport, Supported);
 190         static Supported s_aSupport;
 191         if ( s_aSupport.empty() )
 192         {
 193             ::connectivity::DriversConfig aDriverConfig(::comphelper::getProcessServiceFactory());
 194             const uno::Sequence< ::rtl::OUString > aURLs = aDriverConfig.getURLs();
 195             const ::rtl::OUString* pIter = aURLs.getConstArray();
 196             const ::rtl::OUString* pEnd = pIter + aURLs.getLength();
 197             for(;pIter != pEnd;++pIter)
 198             {
 199                 FeatureSupport aInit( AuthNone );
 200                 const ::comphelper::NamedValueCollection& aMetaData = aDriverConfig.getMetaData(*pIter);
 201                 if ( aMetaData.has("Authentication") )
 202                 {
 203                     ::rtl::OUString sAuth;
 204                     aMetaData.get("Authentication") >>= sAuth;
 205                     if ( sAuth.equalsAscii("UserPassword") )
 206                         aInit = AuthUserPwd;
 207                     else if ( sAuth.equalsAscii("Password") )
 208                         aInit = AuthPwd;
 209                 }
 210                 s_aSupport.insert(Supported::value_type(*pIter,aInit));
 211             } // for(;pIter != pEnd;++pIter)
 212         } // if ( s_aSupport.empty() )
 213         OSL_ENSURE(s_aSupport.find(_sURL) != s_aSupport.end(),"Illegal URL!");
 214         return s_aSupport[ _sURL ].eAuthentication;
 215     }
 216
 217     //====================================================================
 218     //= DataSourceMetaData_Impl
 219     //====================================================================
 220     class DataSourceMetaData_Impl
 221     {
 222     public:
 223         DataSourceMetaData_Impl( const ::rtl::OUString& _sURL );
 224
 225         inline ::rtl::OUString getType() const { return m_sURL; }
 226
 227     private:
 228         const ::rtl::OUString m_sURL;
 229     };
 230
 231     //--------------------------------------------------------------------
 232     DataSourceMetaData_Impl::DataSourceMetaData_Impl( const ::rtl::OUString& _sURL )
 233         :m_sURL( _sURL )
 234     {
 235     }
 236
 237     //====================================================================
 238     //= DataSourceMetaData
 239     //====================================================================
 240     //--------------------------------------------------------------------
 241     DataSourceMetaData::DataSourceMetaData( const ::rtl::OUString& _sURL )
 242         :m_pImpl( new DataSourceMetaData_Impl( _sURL ) )
 243     {
 244     }
 245
 246     //--------------------------------------------------------------------
 247     DataSourceMetaData::~DataSourceMetaData()
 248     {
 249     }
 250
 251     //--------------------------------------------------------------------
 252     const AdvancedSettingsSupport& DataSourceMetaData::getAdvancedSettingsSupport() const
 253     {
 254         return ::dbaui::getAdvancedSettingsSupport( m_pImpl->getType() );
 255     }
 256
 257     //--------------------------------------------------------------------
 258     AuthenticationMode DataSourceMetaData::getAuthentication() const
 259     {
 260         return getAuthenticationMode( m_pImpl->getType() );
 261     }
 262
 263     //--------------------------------------------------------------------
 264     AuthenticationMode  DataSourceMetaData::getAuthentication( const ::rtl::OUString& _sURL )
 265     {
 266         return getAuthenticationMode( _sURL );
 267     }
 268
 269 //........................................................................
 270 } // namespace dbaui
 271 //........................................................................