1*efeef26fSAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
3*efeef26fSAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
4*efeef26fSAndrew Rist  * or more contributor license agreements.  See the NOTICE file
5*efeef26fSAndrew Rist  * distributed with this work for additional information
6*efeef26fSAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
7*efeef26fSAndrew Rist  * to you under the Apache License, Version 2.0 (the
8*efeef26fSAndrew Rist  * "License"); you may not use this file except in compliance
9*efeef26fSAndrew Rist  * with the License.  You may obtain a copy of the License at
10*efeef26fSAndrew Rist  *
11*efeef26fSAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12*efeef26fSAndrew Rist  *
13*efeef26fSAndrew Rist  * Unless required by applicable law or agreed to in writing,
14*efeef26fSAndrew Rist  * software distributed under the License is distributed on an
15*efeef26fSAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*efeef26fSAndrew Rist  * KIND, either express or implied.  See the License for the
17*efeef26fSAndrew Rist  * specific language governing permissions and limitations
18*efeef26fSAndrew Rist  * under the License.
19*efeef26fSAndrew Rist  *
20*efeef26fSAndrew Rist  *************************************************************/
21*efeef26fSAndrew Rist 
22*efeef26fSAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_sw.hxx"
26cdf0e10cSrcweir #include <com/sun/star/sdbc/XConnection.hpp>
27cdf0e10cSrcweir #include <com/sun/star/util/XNumberFormatsSupplier.hpp>
28cdf0e10cSrcweir #include <com/sun/star/sdbc/XDataSource.hpp>
29cdf0e10cSrcweir #include <com/sun/star/sdb/SQLContext.hpp>
30cdf0e10cSrcweir #include <swdbtoolsclient.hxx>
31cdf0e10cSrcweir #include <osl/diagnose.h>
32cdf0e10cSrcweir #include <tools/solar.h>
33cdf0e10cSrcweir 
34cdf0e10cSrcweir //........................................................................
35cdf0e10cSrcweir 
36cdf0e10cSrcweir using namespace ::connectivity::simple;
37cdf0e10cSrcweir using namespace ::com::sun::star;
38cdf0e10cSrcweir using namespace ::com::sun::star::sdbc;
39cdf0e10cSrcweir using namespace ::com::sun::star::lang;
40cdf0e10cSrcweir using namespace ::com::sun::star::util;
41cdf0e10cSrcweir using namespace ::com::sun::star::uno;
42cdf0e10cSrcweir using namespace ::com::sun::star::beans;
43cdf0e10cSrcweir using namespace ::com::sun::star::sdb;
44cdf0e10cSrcweir 
45cdf0e10cSrcweir //====================================================================
46cdf0e10cSrcweir //= SwDbtoolsClient
47cdf0e10cSrcweir //====================================================================
48cdf0e10cSrcweir namespace
49cdf0e10cSrcweir {
50cdf0e10cSrcweir 	// -----------------------------------------------------------------------------
51cdf0e10cSrcweir 	// this namespace contains access to all static members of the class SwDbtoolsClient
52cdf0e10cSrcweir 	// to make the initialize of the dll a little bit faster
53cdf0e10cSrcweir 	// -----------------------------------------------------------------------------
getDbtoolsClientMutex()54cdf0e10cSrcweir 	::osl::Mutex& getDbtoolsClientMutex()
55cdf0e10cSrcweir 	{
56cdf0e10cSrcweir 		static  ::osl::Mutex aMutex;
57cdf0e10cSrcweir 		return aMutex;
58cdf0e10cSrcweir 	}
59cdf0e10cSrcweir 	// -----------------------------------------------------------------------------
getDbToolsClientClients()60cdf0e10cSrcweir 	sal_Int32& getDbToolsClientClients()
61cdf0e10cSrcweir 	{
62cdf0e10cSrcweir 		static  sal_Int32 nClients = 0;
63cdf0e10cSrcweir 		return nClients;
64cdf0e10cSrcweir 	}
65cdf0e10cSrcweir 	// -----------------------------------------------------------------------------
getDbToolsClientModule()66cdf0e10cSrcweir 	oslModule& getDbToolsClientModule()
67cdf0e10cSrcweir 	{
68cdf0e10cSrcweir 		static oslModule hDbtoolsModule = NULL;
69cdf0e10cSrcweir 		return hDbtoolsModule;
70cdf0e10cSrcweir 	}
71cdf0e10cSrcweir 	// -----------------------------------------------------------------------------
getDbToolsClientFactoryFunction()72cdf0e10cSrcweir 	createDataAccessToolsFactoryFunction& getDbToolsClientFactoryFunction()
73cdf0e10cSrcweir 	{
74cdf0e10cSrcweir 		static createDataAccessToolsFactoryFunction pFactoryCreationFunc = NULL;
75cdf0e10cSrcweir 		return pFactoryCreationFunc;
76cdf0e10cSrcweir 	}
77cdf0e10cSrcweir 	// -----------------------------------------------------------------------------
78cdf0e10cSrcweir }
79cdf0e10cSrcweir // -----------------------------------------------------------------------------
SwDbtoolsClient()80cdf0e10cSrcweir SwDbtoolsClient::SwDbtoolsClient()
81cdf0e10cSrcweir {
82cdf0e10cSrcweir }
83cdf0e10cSrcweir 
84cdf0e10cSrcweir //--------------------------------------------------------------------
~SwDbtoolsClient()85cdf0e10cSrcweir SwDbtoolsClient::~SwDbtoolsClient()
86cdf0e10cSrcweir {
87cdf0e10cSrcweir     if(m_xDataAccessFactory.is())
88cdf0e10cSrcweir     {
89cdf0e10cSrcweir         // clear the factory _before_ revoking the client
90cdf0e10cSrcweir         // (the revocation may unload the DBT lib)
91cdf0e10cSrcweir         m_xDataAccessFactory = NULL;
92cdf0e10cSrcweir         // revoke the client
93cdf0e10cSrcweir         revokeClient();
94cdf0e10cSrcweir     }
95cdf0e10cSrcweir }
96cdf0e10cSrcweir 
97cdf0e10cSrcweir //--------------------------------------------------------------------
thisModule()98cdf0e10cSrcweir extern "C" { static void SAL_CALL thisModule() {} }
99cdf0e10cSrcweir 
registerClient()100cdf0e10cSrcweir void SwDbtoolsClient::registerClient()
101cdf0e10cSrcweir {
102cdf0e10cSrcweir     ::osl::MutexGuard aGuard(getDbtoolsClientMutex());
103cdf0e10cSrcweir     if (1 == ++getDbToolsClientClients())
104cdf0e10cSrcweir     {
105cdf0e10cSrcweir         OSL_ENSURE(NULL == getDbToolsClientModule(), "SwDbtoolsClient::registerClient: inconsistence: already have a module!");
106cdf0e10cSrcweir         OSL_ENSURE(NULL == getDbToolsClientFactoryFunction(), "SwDbtoolsClient::registerClient: inconsistence: already have a factory function!");
107cdf0e10cSrcweir 
108cdf0e10cSrcweir         const ::rtl::OUString sModuleName = ::rtl::OUString::createFromAscii(
109cdf0e10cSrcweir             SVLIBRARY( "dbtools" )
110cdf0e10cSrcweir         );
111cdf0e10cSrcweir 
112cdf0e10cSrcweir         // load the dbtools library
113cdf0e10cSrcweir         getDbToolsClientModule() = osl_loadModuleRelative(
114cdf0e10cSrcweir             &thisModule, sModuleName.pData, 0);
115cdf0e10cSrcweir         OSL_ENSURE(NULL != getDbToolsClientModule(), "SwDbtoolsClient::registerClient: could not load the dbtools library!");
116cdf0e10cSrcweir         if (NULL != getDbToolsClientModule())
117cdf0e10cSrcweir         {
118cdf0e10cSrcweir             // get the symbol for the method creating the factory
119cdf0e10cSrcweir             const ::rtl::OUString sFactoryCreationFunc = ::rtl::OUString::createFromAscii("createDataAccessToolsFactory");
120cdf0e10cSrcweir             //  reinterpret_cast<createDataAccessToolsFactoryFunction> removed for gcc permissive
121cdf0e10cSrcweir             getDbToolsClientFactoryFunction() = reinterpret_cast< createDataAccessToolsFactoryFunction >(
122cdf0e10cSrcweir                 osl_getFunctionSymbol(getDbToolsClientModule(), sFactoryCreationFunc.pData));
123cdf0e10cSrcweir 
124cdf0e10cSrcweir             if (NULL == getDbToolsClientFactoryFunction())
125cdf0e10cSrcweir             {   // did not find the symbol
126cdf0e10cSrcweir                 OSL_ENSURE(sal_False, "SwDbtoolsClient::registerClient: could not find the symbol for creating the factory!");
127cdf0e10cSrcweir                 osl_unloadModule(getDbToolsClientModule());
128cdf0e10cSrcweir                 getDbToolsClientModule() = NULL;
129cdf0e10cSrcweir             }
130cdf0e10cSrcweir         }
131cdf0e10cSrcweir     }
132cdf0e10cSrcweir }
133cdf0e10cSrcweir 
134cdf0e10cSrcweir //--------------------------------------------------------------------
revokeClient()135cdf0e10cSrcweir void SwDbtoolsClient::revokeClient()
136cdf0e10cSrcweir {
137cdf0e10cSrcweir     ::osl::MutexGuard aGuard(getDbtoolsClientMutex());
138cdf0e10cSrcweir     if (0 == --getDbToolsClientClients())
139cdf0e10cSrcweir     {
140cdf0e10cSrcweir         getDbToolsClientFactoryFunction() = NULL;
141cdf0e10cSrcweir         if (getDbToolsClientModule())
142cdf0e10cSrcweir             osl_unloadModule(getDbToolsClientModule());
143cdf0e10cSrcweir         getDbToolsClientModule() = NULL;
144cdf0e10cSrcweir     }
145cdf0e10cSrcweir }
146cdf0e10cSrcweir /* -----------------------------30.08.2001 14:58------------------------------
147cdf0e10cSrcweir 
148cdf0e10cSrcweir  ---------------------------------------------------------------------------*/
getFactory()149cdf0e10cSrcweir void SwDbtoolsClient::getFactory()
150cdf0e10cSrcweir {
151cdf0e10cSrcweir     if(!m_xDataAccessFactory.is())
152cdf0e10cSrcweir     {
153cdf0e10cSrcweir         registerClient();
154cdf0e10cSrcweir         if(getDbToolsClientFactoryFunction())
155cdf0e10cSrcweir 		{	// loading the lib succeeded
156cdf0e10cSrcweir             void* pUntypedFactory = (*getDbToolsClientFactoryFunction())();
157cdf0e10cSrcweir 			IDataAccessToolsFactory* pDBTFactory = static_cast<IDataAccessToolsFactory*>(pUntypedFactory);
158cdf0e10cSrcweir             OSL_ENSURE(pDBTFactory, "SwDbtoolsClient::SwDbtoolsClient: no factory returned!");
159cdf0e10cSrcweir 			if (pDBTFactory)
160cdf0e10cSrcweir 			{
161cdf0e10cSrcweir 				m_xDataAccessFactory = pDBTFactory;
162cdf0e10cSrcweir 				// by definition, the factory was aquired once
163cdf0e10cSrcweir 				m_xDataAccessFactory->release();
164cdf0e10cSrcweir 			}
165cdf0e10cSrcweir 		}
166cdf0e10cSrcweir     }
167cdf0e10cSrcweir }
168cdf0e10cSrcweir /* -----------------------------30.08.2001 11:32------------------------------
169cdf0e10cSrcweir 
170cdf0e10cSrcweir  ---------------------------------------------------------------------------*/
171cdf0e10cSrcweir ::rtl::Reference< ::connectivity::simple::IDataAccessTools >
getDataAccessTools()172cdf0e10cSrcweir     SwDbtoolsClient::getDataAccessTools()
173cdf0e10cSrcweir {
174cdf0e10cSrcweir     if(!m_xDataAccessTools.is())
175cdf0e10cSrcweir     {
176cdf0e10cSrcweir         getFactory();
177cdf0e10cSrcweir         if(m_xDataAccessFactory.is())
178cdf0e10cSrcweir             m_xDataAccessTools = m_xDataAccessFactory->getDataAccessTools();
179cdf0e10cSrcweir     }
180cdf0e10cSrcweir     return m_xDataAccessTools;
181cdf0e10cSrcweir }
182cdf0e10cSrcweir /* -----------------------------30.08.2001 12:40------------------------------
183cdf0e10cSrcweir 
184cdf0e10cSrcweir  ---------------------------------------------------------------------------*/
185cdf0e10cSrcweir ::rtl::Reference< ::connectivity::simple::IDataAccessTypeConversion >
getAccessTypeConversion()186cdf0e10cSrcweir     SwDbtoolsClient::getAccessTypeConversion()
187cdf0e10cSrcweir {
188cdf0e10cSrcweir     if(!m_xAccessTypeConversion.is())
189cdf0e10cSrcweir     {
190cdf0e10cSrcweir         getFactory();
191cdf0e10cSrcweir         if(m_xDataAccessFactory.is())
192cdf0e10cSrcweir             m_xAccessTypeConversion = m_xDataAccessFactory->getTypeConversionHelper();
193cdf0e10cSrcweir     }
194cdf0e10cSrcweir     return m_xAccessTypeConversion;
195cdf0e10cSrcweir }
196cdf0e10cSrcweir 
197cdf0e10cSrcweir /* -----------------------------30.08.2001 11:37------------------------------
198cdf0e10cSrcweir 
199cdf0e10cSrcweir  ---------------------------------------------------------------------------*/
getDataSource(const::rtl::OUString & rRegisteredName,const Reference<XMultiServiceFactory> & xFactory)200cdf0e10cSrcweir Reference< XDataSource > SwDbtoolsClient::getDataSource(
201cdf0e10cSrcweir         const ::rtl::OUString& rRegisteredName,
202cdf0e10cSrcweir         const Reference< XMultiServiceFactory>& xFactory
203cdf0e10cSrcweir             )
204cdf0e10cSrcweir {
205cdf0e10cSrcweir     Reference< XDataSource > xRet;
206cdf0e10cSrcweir     ::rtl::Reference< ::connectivity::simple::IDataAccessTools >    xAccess = getDataAccessTools();
207cdf0e10cSrcweir     if(xAccess.is())
208cdf0e10cSrcweir         xRet = xAccess->getDataSource(rRegisteredName, xFactory);
209cdf0e10cSrcweir     return xRet;
210cdf0e10cSrcweir }
211cdf0e10cSrcweir /* -----------------------------30.08.2001 12:06------------------------------
212cdf0e10cSrcweir 
213cdf0e10cSrcweir  ---------------------------------------------------------------------------*/
getDefaultNumberFormat(const Reference<XPropertySet> & rxColumn,const Reference<XNumberFormatTypes> & rxTypes,const Locale & rLocale)214cdf0e10cSrcweir sal_Int32 SwDbtoolsClient::getDefaultNumberFormat(
215cdf0e10cSrcweir         const Reference< XPropertySet >& rxColumn,
216cdf0e10cSrcweir         const Reference< XNumberFormatTypes >& rxTypes,
217cdf0e10cSrcweir         const Locale& rLocale
218cdf0e10cSrcweir             )
219cdf0e10cSrcweir {
220cdf0e10cSrcweir     sal_Int32 nRet = -1;
221cdf0e10cSrcweir     ::rtl::Reference< ::connectivity::simple::IDataAccessTools >    xAccess = getDataAccessTools();
222cdf0e10cSrcweir     if(xAccess.is())
223cdf0e10cSrcweir         nRet = xAccess->getDefaultNumberFormat( rxColumn, rxTypes, rLocale);
224cdf0e10cSrcweir     return nRet;
225cdf0e10cSrcweir }
226cdf0e10cSrcweir /* -----------------------------30.08.2001 12:38------------------------------
227cdf0e10cSrcweir 
228cdf0e10cSrcweir  ---------------------------------------------------------------------------*/
getFormattedValue(const uno::Reference<beans::XPropertySet> & _rxColumn,const uno::Reference<util::XNumberFormatter> & _rxFormatter,const lang::Locale & _rLocale,const util::Date & _rNullDate)229cdf0e10cSrcweir ::rtl::OUString SwDbtoolsClient::getFormattedValue(
230cdf0e10cSrcweir         const uno::Reference< beans::XPropertySet>& _rxColumn,
231cdf0e10cSrcweir         const uno::Reference< util::XNumberFormatter>& _rxFormatter,
232cdf0e10cSrcweir         const lang::Locale& _rLocale,
233cdf0e10cSrcweir         const util::Date& _rNullDate
234cdf0e10cSrcweir             )
235cdf0e10cSrcweir 
236cdf0e10cSrcweir {
237cdf0e10cSrcweir     ::rtl::Reference< ::connectivity::simple::IDataAccessTypeConversion > xConversion =
238cdf0e10cSrcweir                     getAccessTypeConversion();
239cdf0e10cSrcweir     rtl::OUString sRet;
240cdf0e10cSrcweir     if(xConversion.is())
241cdf0e10cSrcweir         sRet = xConversion->getFormattedValue(_rxColumn, _rxFormatter, _rLocale, _rNullDate);
242cdf0e10cSrcweir     return sRet;
243cdf0e10cSrcweir }
244cdf0e10cSrcweir 
245