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