svx/source/cui/dbregisterednamesconfig.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: dbregisterednamesconfig.cxx,v $
  10  * $Revision: 1.10 $
  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 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_svx.hxx"
  33
  34 #ifdef SVX_DLLIMPLEMENTATION
  35 #undef SVX_DLLIMPLEMENTATION
  36 #endif
  37
  38 #include "dbregisterednamesconfig.hxx"
  39
  40
  41 #include <svtools/itemset.hxx>
  42 #include <tools/diagnose_ex.h>
  43
  44 #include <svx/svxids.hrc>
  45 #include <unotools/confignode.hxx>
  46 #include <comphelper/extract.hxx>
  47 #include <com/sun/star/container/XNameAccess.hpp>
  48 #include <com/sun/star/uno/XNamingService.hpp>
  49 #include <svtools/eitem.hxx>
  50 #include <comphelper/processfactory.hxx>
  51 #include <svtools/pathoptions.hxx>
  52 #include "dbregistersettings.hxx"
  53 #include "connpooloptions.hxx"
  54
  55 //........................................................................
  56 namespace svx
  57 {
  58 //........................................................................
  59
  60     using namespace ::utl;
  61     using namespace ::com::sun::star::uno;
  62     using namespace ::com::sun::star::container;
  63
  64     //--------------------------------------------------------------------
  65     static const ::rtl::OUString& getDbRegisteredNamesNodeName()
  66     {
  67         static ::rtl::OUString s_sNodeName = ::rtl::OUString::createFromAscii("org.openoffice.Office.DataAccess/RegisteredNames");
  68         return s_sNodeName;
  69     }
  70
  71     //--------------------------------------------------------------------
  72     static const ::rtl::OUString& getDbNameNodeName()
  73     {
  74         static ::rtl::OUString s_sNodeName = ::rtl::OUString::createFromAscii("Name");
  75         return s_sNodeName;
  76     }
  77
  78     //--------------------------------------------------------------------
  79     static const ::rtl::OUString& getDbLocationNodeName()
  80     {
  81         static ::rtl::OUString s_sNodeName = ::rtl::OUString::createFromAscii("Location");
  82         return s_sNodeName;
  83     }
  84
  85     //====================================================================
  86     //= DbRegisteredNamesConfig
  87     //====================================================================
  88     //--------------------------------------------------------------------
  89     void DbRegisteredNamesConfig::GetOptions(SfxItemSet& _rFillItems)
  90     {
  91         // the config node where all pooling relevant info are stored under
  92         OConfigurationTreeRoot aDbRegisteredNamesRoot = OConfigurationTreeRoot::createWithServiceFactory(
  93             ::comphelper::getProcessServiceFactory(), getDbRegisteredNamesNodeName(), -1, OConfigurationTreeRoot::CM_READONLY);
  94
  95         TNameLocationMap aSettings;
  96
  97         // then look for which of them settings are stored in the configuration
  98         Sequence< ::rtl::OUString > aDriverKeys = aDbRegisteredNamesRoot.getNodeNames();
  99         const ::rtl::OUString* pDriverKeys = aDriverKeys.getConstArray();
 100         const ::rtl::OUString* pDriverKeysEnd = pDriverKeys + aDriverKeys.getLength();
 101         for (;pDriverKeys != pDriverKeysEnd; ++pDriverKeys)
 102         {
 103             // the name of the driver in this round
 104             OConfigurationNode aThisDriverSettings = aDbRegisteredNamesRoot.openNode(*pDriverKeys);
 105             ::rtl::OUString sName, sLocation;
 106             aThisDriverSettings.getNodeValue(getDbNameNodeName()) >>= sName;
 107             aThisDriverSettings.getNodeValue(getDbLocationNodeName()) >>= sLocation;
 108             sLocation = SvtPathOptions().SubstituteVariable(sLocation);
 109
 110             aSettings.insert(TNameLocationMap::value_type(sName,sLocation));
 111         }
 112
 113         _rFillItems.Put(DatabaseMapItem(SID_SB_DB_REGISTER, aSettings));
 114     }
 115
 116     //--------------------------------------------------------------------
 117     void DbRegisteredNamesConfig::SetOptions(const SfxItemSet& _rSourceItems)
 118     {
 119         // the config node where all pooling relevant info are stored under
 120         OConfigurationTreeRoot aDbRegisteredNamesRoot = OConfigurationTreeRoot::createWithServiceFactory(
 121             ::comphelper::getProcessServiceFactory(), getDbRegisteredNamesNodeName(), -1, OConfigurationTreeRoot::CM_UPDATABLE);
 122
 123         if (!aDbRegisteredNamesRoot.isValid())
 124             // already asserted by the OConfigurationTreeRoot
 125             return;
 126
 127         sal_Bool bNeedCommit = sal_False;
 128
 129
 130         // the settings for the single drivers
 131         SFX_ITEMSET_GET( _rSourceItems, pDriverSettings, DatabaseMapItem, SID_SB_DB_REGISTER, sal_True );
 132         if (pDriverSettings)
 133         {
 134             Reference< XNameAccess > xDatabaseContext = Reference< XNameAccess >(::comphelper::getProcessServiceFactory()->createInstance(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.sdb.DatabaseContext"))), UNO_QUERY);
 135             Reference< XNamingService> xNamingService(xDatabaseContext,UNO_QUERY);
 136             ::rtl::OUString sName, sLocation;
 137             OConfigurationNode aThisDriverSettings;
 138
 139             const TNameLocationMap& rNewSettings = pDriverSettings->getSettings();
 140             TNameLocationMap::const_iterator aEnd = rNewSettings.end();
 141             for (       TNameLocationMap::const_iterator aLoop = rNewSettings.begin();
 142                     aLoop != aEnd;
 143                     ++aLoop
 144                 )
 145             {
 146                 // need the name as ::rtl::OUString
 147                 sName = aLoop->first;
 148
 149                 // the sub-node for this driver
 150                 if (aDbRegisteredNamesRoot.hasByName(sName))
 151                 {
 152                     aThisDriverSettings = aDbRegisteredNamesRoot.openNode(sName);
 153                     // set the values
 154                     aThisDriverSettings.setNodeValue(getDbNameNodeName(), makeAny(sName));
 155                     aThisDriverSettings.setNodeValue(getDbLocationNodeName(), makeAny(aLoop->second));
 156                     bNeedCommit = sal_True;
 157                 }
 158                 else
 159                 {
 160                     try
 161                     {
 162                         xNamingService->registerObject(sName,Reference< ::com::sun::star::uno::XInterface >(xDatabaseContext->getByName(aLoop->second),UNO_QUERY));
 163                     }
 164                     catch( const Exception& )
 165                     {
 166                         //DBG_UNHANDLED_EXCEPTION();
 167                     }
 168                 }
 169             }
 170             if (bNeedCommit)
 171                 aDbRegisteredNamesRoot.commit();
 172
 173             // delete unused entry
 174             Sequence< ::rtl::OUString > aDriverKeys = xDatabaseContext->getElementNames();
 175             const ::rtl::OUString* pDriverKeys = aDriverKeys.getConstArray();
 176             const ::rtl::OUString* pDriverKeysEnd = pDriverKeys + aDriverKeys.getLength();
 177             for (;pDriverKeys != pDriverKeysEnd; ++pDriverKeys)
 178             {
 179                 if ( rNewSettings.find(*pDriverKeys) == rNewSettings.end() )
 180                 {
 181                     try
 182                     {
 183                         xNamingService->revokeObject(*pDriverKeys);
 184                     }
 185                     catch( const Exception& )
 186                     {
 187                         //DBG_UNHANDLED_EXCEPTION();
 188                     }
 189                 }
 190             }
 191         }
 192     }
 193
 194 //........................................................................
 195 }       // namespace svx
 196 //........................................................................