1 /**************************************************************
2 *
3 * Licensed to the Apache Software Foundation (ASF) under one
4 * or more contributor license agreements. See the NOTICE file
5 * distributed with this work for additional information
6 * regarding copyright ownership. The ASF licenses this file
7 * to you under the Apache License, Version 2.0 (the
8 * "License"); you may not use this file except in compliance
9 * with the License. You may obtain a copy of the License at
10 *
11 * http://www.apache.org/licenses/LICENSE-2.0
12 *
13 * Unless required by applicable law or agreed to in writing,
14 * software distributed under the License is distributed on an
15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16 * KIND, either express or implied. See the License for the
17 * specific language governing permissions and limitations
18 * under the License.
19 *
20 *************************************************************/
21
22
23
24 // MARKER(update_precomp.py): autogen include statement, do not remove
25 #include "precompiled_dbaccess.hxx"
26
27 #include "dsntypes.hxx"
28 #include "dbamiscres.hrc"
29 #include <unotools/confignode.hxx>
30 #include <tools/debug.hxx>
31 #include <tools/wldcrd.hxx>
32 #include <osl/file.hxx>
33 #include "dbastrings.hrc"
34 #include "core_resource.hxx"
35 #include "core_resource.hrc"
36 #include <comphelper/documentconstants.hxx>
37
38 //.........................................................................
39 namespace dbaccess
40 {
41 //.........................................................................
42
43 using namespace ::com::sun::star;
44 using namespace ::com::sun::star::uno;
45 using namespace ::com::sun::star::beans;
46 using namespace ::com::sun::star::lang;
47 //using namespace ::com::sun::star::sdbc;
48
49 namespace
50 {
lcl_extractHostAndPort(const String & _sUrl,String & _sHostname,sal_Int32 & _nPortNumber)51 void lcl_extractHostAndPort(const String& _sUrl,String& _sHostname,sal_Int32& _nPortNumber)
52 {
53 if ( _sUrl.GetTokenCount(':') >= 2 )
54 {
55 _sHostname = _sUrl.GetToken(0,':');
56 _nPortNumber = _sUrl.GetToken(1,':').ToInt32();
57 }
58 }
59 }
60 //=========================================================================
61 //= ODsnTypeCollection
62 //=========================================================================
DBG_NAME(ODsnTypeCollection)63 DBG_NAME(ODsnTypeCollection)
64 //-------------------------------------------------------------------------
65 ODsnTypeCollection::ODsnTypeCollection(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _xFactory)
66 :m_aDriverConfig(_xFactory)
67 ,m_xFactory(_xFactory)
68 #ifdef DBG_UTIL
69 ,m_nLivingIterators(0)
70 #endif
71 {
72 DBG_CTOR(ODsnTypeCollection,NULL);
73 const uno::Sequence< ::rtl::OUString > aURLs = m_aDriverConfig.getURLs();
74 const ::rtl::OUString* pIter = aURLs.getConstArray();
75 const ::rtl::OUString* pEnd = pIter + aURLs.getLength();
76 for(;pIter != pEnd;++pIter )
77 {
78 m_aDsnPrefixes.push_back(*pIter);
79 m_aDsnTypesDisplayNames.push_back(m_aDriverConfig.getDriverTypeDisplayName(*pIter));
80 }
81
82 DBG_ASSERT(m_aDsnTypesDisplayNames.size() == m_aDsnPrefixes.size(),
83 "ODsnTypeCollection::ODsnTypeCollection : invalid resources !");
84 }
85
86 //-------------------------------------------------------------------------
~ODsnTypeCollection()87 ODsnTypeCollection::~ODsnTypeCollection()
88 {
89 DBG_DTOR(ODsnTypeCollection,NULL);
90 DBG_ASSERT(0 == m_nLivingIterators, "ODsnTypeCollection::~ODsnTypeCollection : there are still living iterator objects!");
91 }
92 //-------------------------------------------------------------------------
getTypeDisplayName(const::rtl::OUString & _sURL) const93 String ODsnTypeCollection::getTypeDisplayName(const ::rtl::OUString& _sURL) const
94 {
95 return m_aDriverConfig.getDriverTypeDisplayName(_sURL);
96 }
97 //-------------------------------------------------------------------------
cutPrefix(const::rtl::OUString & _sURL) const98 String ODsnTypeCollection::cutPrefix(const ::rtl::OUString& _sURL) const
99 {
100 String sURL( _sURL);
101 String sRet;
102 String sOldPattern;
103 StringVector::const_iterator aIter = m_aDsnPrefixes.begin();
104 StringVector::const_iterator aEnd = m_aDsnPrefixes.end();
105 for(;aIter != aEnd;++aIter)
106 {
107 WildCard aWildCard(*aIter);
108 if ( sOldPattern.Len() < aIter->Len() && aWildCard.Matches(_sURL) )
109 {
110 if ( aIter->Len() < sURL.Len() )
111 sRet = sURL.Copy(sURL.Match(*aIter));
112 else
113 sRet = sURL.Copy(aIter->Match(sURL));
114 sOldPattern = *aIter;
115 }
116 }
117
118 return sRet;
119 }
120
121 //-------------------------------------------------------------------------
getPrefix(const::rtl::OUString & _sURL) const122 String ODsnTypeCollection::getPrefix(const ::rtl::OUString& _sURL) const
123 {
124 String sURL( _sURL);
125 String sRet;
126 String sOldPattern;
127 StringVector::const_iterator aIter = m_aDsnPrefixes.begin();
128 StringVector::const_iterator aEnd = m_aDsnPrefixes.end();
129 for(;aIter != aEnd;++aIter)
130 {
131 WildCard aWildCard(*aIter);
132 if ( sOldPattern.Len() < aIter->Len() && aWildCard.Matches(sURL) )
133 {
134 if ( aIter->Len() < sURL.Len() )
135 sRet = aIter->Copy(0,sURL.Match(*aIter));
136 else
137 sRet = sURL.Copy(0,aIter->Match(sURL));
138 sRet.EraseTrailingChars('*');
139 sOldPattern = *aIter;
140 }
141 }
142
143 return sRet;
144 }
145
146 //-------------------------------------------------------------------------
hasDriver(const sal_Char * _pAsciiPattern) const147 bool ODsnTypeCollection::hasDriver( const sal_Char* _pAsciiPattern ) const
148 {
149 String sPrefix( getPrefix( ::rtl::OUString::createFromAscii( _pAsciiPattern ) ) );
150 return ( sPrefix.Len() > 0 );
151 }
152
153 // -----------------------------------------------------------------------------
isConnectionUrlRequired(const::rtl::OUString & _sURL) const154 bool ODsnTypeCollection::isConnectionUrlRequired(const ::rtl::OUString& _sURL) const
155 {
156 String sURL( _sURL);
157 String sRet;
158 String sOldPattern;
159 StringVector::const_iterator aIter = m_aDsnPrefixes.begin();
160 StringVector::const_iterator aEnd = m_aDsnPrefixes.end();
161 for(;aIter != aEnd;++aIter)
162 {
163 WildCard aWildCard(*aIter);
164 if ( sOldPattern.Len() < aIter->Len() && aWildCard.Matches(sURL) )
165 {
166 sRet = *aIter;
167 sOldPattern = *aIter;
168 }
169 } // for(;aIter != aEnd;++aIter)
170 return sRet.GetChar(sRet.Len()-1) == '*';
171 }
172 // -----------------------------------------------------------------------------
getMediaType(const::rtl::OUString & _sURL) const173 String ODsnTypeCollection::getMediaType(const ::rtl::OUString& _sURL) const
174 {
175 const ::comphelper::NamedValueCollection& aFeatures = m_aDriverConfig.getMetaData(_sURL);
176 return aFeatures.getOrDefault("MediaType",::rtl::OUString());
177 }
178 // -----------------------------------------------------------------------------
getDatasourcePrefixFromMediaType(const::rtl::OUString & _sMediaType,const::rtl::OUString & _sExtension)179 String ODsnTypeCollection::getDatasourcePrefixFromMediaType(const ::rtl::OUString& _sMediaType,const ::rtl::OUString& _sExtension)
180 {
181 String sURL, sFallbackURL;
182 const uno::Sequence< ::rtl::OUString > aURLs = m_aDriverConfig.getURLs();
183 const ::rtl::OUString* pIter = aURLs.getConstArray();
184 const ::rtl::OUString* pEnd = pIter + aURLs.getLength();
185 for(;pIter != pEnd;++pIter )
186 {
187 const ::comphelper::NamedValueCollection& aFeatures = m_aDriverConfig.getMetaData(*pIter);
188 if ( aFeatures.getOrDefault("MediaType",::rtl::OUString()) == _sMediaType )
189 {
190 const ::rtl::OUString sFileExtension = aFeatures.getOrDefault("Extension",::rtl::OUString());
191 if ( _sExtension == sFileExtension )
192 {
193 sURL = *pIter;
194 break;
195 }
196 if ( !sFileExtension.getLength() && _sExtension.getLength() )
197 sFallbackURL = *pIter;
198 }
199 } // for(;pIter != pEnd;++pIter )
200
201 if ( !sURL.Len() && sFallbackURL.Len() )
202 sURL = sFallbackURL;
203
204 sURL.EraseTrailingChars('*');
205 return sURL;
206 }
207 // -----------------------------------------------------------------------------
isShowPropertiesEnabled(const::rtl::OUString & _sURL) const208 bool ODsnTypeCollection::isShowPropertiesEnabled( const ::rtl::OUString& _sURL ) const
209 {
210 return !( _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:embedded:hsqldb",sizeof("sdbc:embedded:hsqldb")-1)
211 || _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:address:outlook",sizeof("sdbc:address:outlook")-1)
212 || _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:address:outlookexp",sizeof("sdbc:address:outlookexp")-1)
213 || _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:address:mozilla:",sizeof("sdbc:address:mozilla:")-1)
214 || _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:address:kab",sizeof("sdbc:address:kab")-1)
215 || _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:address:evolution:local",sizeof("sdbc:address:evolution:local")-1)
216 || _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:address:evolution:groupwise",sizeof("sdbc:address:evolution:groupwise")-1)
217 || _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:address:evolution:ldap",sizeof("sdbc:address:evolution:ldap")-1)
218 || _sURL.matchIgnoreAsciiCaseAsciiL("sdbc:address:macab",sizeof("sdbc:address:macab")-1) );
219 }
220 // -----------------------------------------------------------------------------
extractHostNamePort(const::rtl::OUString & _rDsn,String & _sDatabaseName,String & _rsHostname,sal_Int32 & _nPortNumber) const221 void ODsnTypeCollection::extractHostNamePort(const ::rtl::OUString& _rDsn,String& _sDatabaseName,String& _rsHostname,sal_Int32& _nPortNumber) const
222 {
223 String sUrl = cutPrefix(_rDsn);
224 if ( _rDsn.matchIgnoreAsciiCaseAsciiL("jdbc:oracle:thin:",sizeof("jdbc:oracle:thin:")-1) )
225 {
226 lcl_extractHostAndPort(sUrl,_rsHostname,_nPortNumber);
227 if ( !_rsHostname.Len() && sUrl.GetTokenCount(':') == 2 )
228 {
229 _nPortNumber = -1;
230 _rsHostname = sUrl.GetToken(0,':');
231 }
232 if ( _rsHostname.Len() )
233 _rsHostname = _rsHostname.GetToken(_rsHostname.GetTokenCount('@') - 1,'@');
234 _sDatabaseName = sUrl.GetToken(sUrl.GetTokenCount(':') - 1,':');
235 } // if ( _rDsn.matchIgnoreAsciiCaseAsciiL("jdbc:oracle:thin:",sizeof("jdbc:oracle:thin:")-1) )
236 else if ( _rDsn.matchIgnoreAsciiCaseAsciiL("sdbc:address:ldap:",sizeof("sdbc:address:ldap:")-1) )
237 {
238 lcl_extractHostAndPort(sUrl,_sDatabaseName,_nPortNumber);
239 }
240 else if ( _rDsn.matchIgnoreAsciiCaseAsciiL("sdbc:adabas:",sizeof("sdbc:adabas:")-1) )
241 {
242 if ( sUrl.GetTokenCount(':') == 2 )
243 _rsHostname = sUrl.GetToken(0,':');
244 _sDatabaseName = sUrl.GetToken(sUrl.GetTokenCount(':') - 1,':');
245 }
246 else if ( _rDsn.matchIgnoreAsciiCaseAsciiL("sdbc:mysql:mysqlc:",sizeof("sdbc:mysql:mysqlc:")-1) || _rDsn.matchIgnoreAsciiCaseAsciiL("sdbc:mysql:jdbc:",sizeof("sdbc:mysql:jdbc:")-1) )
247 {
248 lcl_extractHostAndPort(sUrl,_rsHostname,_nPortNumber);
249
250 if ( _nPortNumber == -1 && !_rsHostname.Len() && sUrl.GetTokenCount('/') == 2 )
251 _rsHostname = sUrl.GetToken(0,'/');
252 _sDatabaseName = sUrl.GetToken(sUrl.GetTokenCount('/') - 1,'/');
253 }
254 else if ( _rDsn.matchIgnoreAsciiCaseAsciiL("sdbc:ado:access:Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=",sizeof("sdbc:ado:access:Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=")-1)
255 || _rDsn.matchIgnoreAsciiCaseAsciiL("sdbc:ado:access:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=",sizeof("sdbc:ado:access:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=")-1))
256 {
257 ::rtl::OUString sNewFileName;
258 if ( ::osl::FileBase::getFileURLFromSystemPath( sUrl, sNewFileName ) == ::osl::FileBase::E_None )
259 {
260 _sDatabaseName = sNewFileName;
261 }
262 }
263 }
264 // -----------------------------------------------------------------------------
getJavaDriverClass(const::rtl::OUString & _sURL) const265 String ODsnTypeCollection::getJavaDriverClass(const ::rtl::OUString& _sURL) const
266 {
267 const ::comphelper::NamedValueCollection& aFeatures = m_aDriverConfig.getProperties(_sURL);
268 return aFeatures.getOrDefault("JavaDriverClass",::rtl::OUString());
269 }
270 //-------------------------------------------------------------------------
isFileSystemBased(const::rtl::OUString & _sURL) const271 sal_Bool ODsnTypeCollection::isFileSystemBased(const ::rtl::OUString& _sURL) const
272 {
273 const ::comphelper::NamedValueCollection& aFeatures = m_aDriverConfig.getMetaData(_sURL);
274 return aFeatures.getOrDefault("FileSystemBased",sal_False);
275 }
276 // -----------------------------------------------------------------------------
supportsTableCreation(const::rtl::OUString & _sURL) const277 sal_Bool ODsnTypeCollection::supportsTableCreation(const ::rtl::OUString& _sURL) const
278 {
279 const ::comphelper::NamedValueCollection& aFeatures = m_aDriverConfig.getMetaData(_sURL);
280 return aFeatures.getOrDefault("SupportsTableCreation",sal_False);
281 }
282 // -----------------------------------------------------------------------------
supportsColumnDescription(const::rtl::OUString & _sURL) const283 sal_Bool ODsnTypeCollection::supportsColumnDescription(const ::rtl::OUString& _sURL) const
284 {
285 const ::comphelper::NamedValueCollection& aFeatures = m_aDriverConfig.getMetaData(_sURL);
286 return aFeatures.getOrDefault("SupportsColumnDescription",sal_False);
287 }
288 // -----------------------------------------------------------------------------
supportsBrowsing(const::rtl::OUString & _sURL) const289 sal_Bool ODsnTypeCollection::supportsBrowsing(const ::rtl::OUString& _sURL) const
290 {
291 const ::comphelper::NamedValueCollection& aFeatures = m_aDriverConfig.getMetaData(_sURL);
292 return aFeatures.getOrDefault("SupportsBrowsing",sal_False);
293 }
294 // -----------------------------------------------------------------------------
needsJVM(const String & _sURL) const295 bool ODsnTypeCollection::needsJVM(const String& _sURL) const
296 {
297 const ::comphelper::NamedValueCollection& aFeatures = m_aDriverConfig.getMetaData(_sURL);
298 return aFeatures.getOrDefault("UseJava",sal_False);
299 }
300 // -----------------------------------------------------------------------------
getDefaultDBSettings(const::rtl::OUString & _sURL) const301 Sequence<PropertyValue> ODsnTypeCollection::getDefaultDBSettings( const ::rtl::OUString& _sURL ) const
302 {
303 const ::comphelper::NamedValueCollection& aProperties = m_aDriverConfig.getProperties(_sURL);
304 return aProperties.getPropertyValues();
305 }
306
307 //-------------------------------------------------------------------------
isEmbeddedDatabase(const::rtl::OUString & _sURL) const308 bool ODsnTypeCollection::isEmbeddedDatabase( const ::rtl::OUString& _sURL ) const
309 {
310 const ::rtl::OUString sEmbeddedDatabaseURL = getEmbeddedDatabase();
311 WildCard aWildCard(sEmbeddedDatabaseURL);
312 return aWildCard.Matches(_sURL);
313 }
314 // -----------------------------------------------------------------------------
getEmbeddedDatabase() const315 ::rtl::OUString ODsnTypeCollection::getEmbeddedDatabase() const
316 {
317 ::rtl::OUString sEmbeddedDatabaseURL;
318 static const ::rtl::OUString s_sNodeName(RTL_CONSTASCII_USTRINGPARAM("org.openoffice.Office.DataAccess")); ///Installed
319 const ::utl::OConfigurationTreeRoot aInstalled = ::utl::OConfigurationTreeRoot::createWithServiceFactory(m_xFactory, s_sNodeName, -1, ::utl::OConfigurationTreeRoot::CM_READONLY);
320 if ( aInstalled.isValid() )
321 {
322 if ( aInstalled.hasByName("EmbeddedDatabases/DefaultEmbeddedDatabase/Value") )
323 {
324 static const ::rtl::OUString s_sValue(RTL_CONSTASCII_USTRINGPARAM("EmbeddedDatabases/DefaultEmbeddedDatabase/Value"));
325
326 aInstalled.getNodeValue(s_sValue) >>= sEmbeddedDatabaseURL;
327 if ( sEmbeddedDatabaseURL.getLength() )
328 aInstalled.getNodeValue(s_sValue + ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("/")) + sEmbeddedDatabaseURL + ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("/URL"))) >>= sEmbeddedDatabaseURL;
329 }
330 } // if ( aInstalled.isValid() )
331 if ( !sEmbeddedDatabaseURL.getLength() )
332 sEmbeddedDatabaseURL = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("sdbc:embedded:hsqldb"));
333 return sEmbeddedDatabaseURL;
334 }
335 //-------------------------------------------------------------------------
begin() const336 ODsnTypeCollection::TypeIterator ODsnTypeCollection::begin() const
337 {
338 return TypeIterator(this, 0);
339 }
340
341 //-------------------------------------------------------------------------
end() const342 ODsnTypeCollection::TypeIterator ODsnTypeCollection::end() const
343 {
344 return TypeIterator(this, m_aDsnTypesDisplayNames.size());
345 }
346 //-------------------------------------------------------------------------
determineType(const String & _rDsn) const347 DATASOURCE_TYPE ODsnTypeCollection::determineType(const String& _rDsn) const
348 {
349 String sDsn(_rDsn);
350 sDsn.EraseTrailingChars('*');
351 sal_uInt16 nSeparator = sDsn.Search((sal_Unicode)':');
352 if (STRING_NOTFOUND == nSeparator)
353 {
354 // there should be at least one such separator
355 DBG_ERROR("ODsnTypeCollection::implDetermineType : missing the colon !");
356 return DST_UNKNOWN;
357 }
358 // find first :
359 sal_uInt16 nOracleSeparator = sDsn.Search((sal_Unicode)':', nSeparator + 1);
360 if ( nOracleSeparator != STRING_NOTFOUND )
361 {
362 nOracleSeparator = sDsn.Search((sal_Unicode)':', nOracleSeparator + 1);
363 if (nOracleSeparator != STRING_NOTFOUND && sDsn.EqualsIgnoreCaseAscii("jdbc:oracle:thin", 0, nOracleSeparator))
364 return DST_ORACLE_JDBC;
365 }
366
367 if (sDsn.EqualsIgnoreCaseAscii("jdbc", 0, nSeparator))
368 return DST_JDBC;
369
370 if (sDsn.EqualsIgnoreCaseAscii("sdbc:embedded:hsqldb", 0, sDsn.Len()))
371 return DST_EMBEDDED_HSQLDB;
372
373 // find second :
374 nSeparator = sDsn.Search((sal_Unicode)':', nSeparator + 1);
375 if (STRING_NOTFOUND == nSeparator)
376 {
377 // at the moment only jdbc is allowed to have just one separator
378 DBG_ERROR("ODsnTypeCollection::implDetermineType : missing the second colon !");
379 return DST_UNKNOWN;
380 }
381
382 if (sDsn.EqualsIgnoreCaseAscii("sdbc:ado:", 0, nSeparator))
383 {
384 nSeparator = sDsn.Search((sal_Unicode)':', nSeparator + 1);
385 if (STRING_NOTFOUND != nSeparator && sDsn.EqualsIgnoreCaseAscii("sdbc:ado:access",0, nSeparator) )
386 {
387 nSeparator = sDsn.Search((sal_Unicode)';', nSeparator + 1);
388 if (STRING_NOTFOUND != nSeparator && sDsn.EqualsIgnoreCaseAscii("sdbc:ado:access:Provider=Microsoft.ACE.OLEDB.12.0",0, nSeparator) )
389 return DST_MSACCESS_2007;
390
391 return DST_MSACCESS;
392 }
393 return DST_ADO;
394 }
395
396 struct KnownPrefix
397 {
398 const sal_Char* pAsciiPrefix;
399 const DATASOURCE_TYPE eType;
400 const bool bMatchComplete;
401
402 KnownPrefix()
403 :pAsciiPrefix( NULL )
404 ,eType( DST_UNKNOWN )
405 ,bMatchComplete( false )
406 {
407 }
408 KnownPrefix( const sal_Char* _p, const DATASOURCE_TYPE _t, const bool _m )
409 :pAsciiPrefix( _p )
410 ,eType ( _t )
411 ,bMatchComplete( _m )
412 {
413 }
414 };
415 KnownPrefix aKnowPrefixes[] =
416 {
417 KnownPrefix( "sdbc:calc:", DST_CALC, false ),
418 KnownPrefix( "sdbc:flat:", DST_FLAT, false ),
419 KnownPrefix( "sdbc:adabas:", DST_ADABAS, false ),
420 KnownPrefix( "sdbc:odbc:", DST_ODBC, false ),
421 KnownPrefix( "sdbc:dbase:", DST_DBASE, false ),
422 KnownPrefix( "sdbc:mysql:odbc:", DST_MYSQL_ODBC, false ),
423 KnownPrefix( "sdbc:mysql:jdbc:", DST_MYSQL_JDBC, false ),
424 KnownPrefix( "sdbc:mysql:mysqlc:", DST_MYSQL_NATIVE, false ),
425 KnownPrefix( "sdbc:mysqlc:", DST_MYSQL_NATIVE_DIRECT,false ),
426 KnownPrefix( "sdbc:postgresql:jdbc:",DST_POSTGRESQL_JDBC, false ),
427
428 KnownPrefix( "sdbc:address:mozilla:", DST_MOZILLA, true ),
429 KnownPrefix( "sdbc:address:thunderbird:", DST_THUNDERBIRD, true ),
430 KnownPrefix( "sdbc:address:ldap:", DST_LDAP, true ),
431 KnownPrefix( "sdbc:address:outlook", DST_OUTLOOK, true ),
432 KnownPrefix( "sdbc:address:outlookexp", DST_OUTLOOKEXP, true ),
433 KnownPrefix( "sdbc:address:evolution:ldap", DST_EVOLUTION_LDAP, true ),
434 KnownPrefix( "sdbc:address:evolution:groupwise",DST_EVOLUTION_GROUPWISE,true ),
435 KnownPrefix( "sdbc:address:evolution:local", DST_EVOLUTION, true ),
436 KnownPrefix( "sdbc:address:kab", DST_KAB, true ),
437 KnownPrefix( "sdbc:address:macab", DST_MACAB, true )
438 };
439
440 for ( size_t i=0; i < sizeof( aKnowPrefixes ) / sizeof( aKnowPrefixes[0] ); ++i )
441 {
442 sal_uInt16 nMatchLen = aKnowPrefixes[i].bMatchComplete ? sDsn.Len() : (sal_uInt16)rtl_str_getLength( aKnowPrefixes[i].pAsciiPrefix );
443 if ( sDsn.EqualsIgnoreCaseAscii( aKnowPrefixes[i].pAsciiPrefix, 0, nMatchLen ) )
444 return aKnowPrefixes[i].eType;
445 }
446
447 return DST_UNKNOWN;
448 }
449 // -----------------------------------------------------------------------------
fillPageIds(const::rtl::OUString & _sURL,::std::vector<sal_Int16> & _rOutPathIds) const450 void ODsnTypeCollection::fillPageIds(const ::rtl::OUString& _sURL,::std::vector<sal_Int16>& _rOutPathIds) const
451 {
452 DATASOURCE_TYPE eType = determineType(_sURL);
453 switch(eType)
454 {
455 case DST_ADO:
456 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_ADO);
457 break;
458 case DST_DBASE:
459 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_DBASE);
460 break;
461 case DST_FLAT:
462 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_TEXT);
463 break;
464 case DST_CALC:
465 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_SPREADSHEET);
466 break;
467 case DST_ODBC:
468 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_ODBC);
469 break;
470 case DST_JDBC:
471 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_JDBC);
472 break;
473 case DST_MYSQL_ODBC:
474 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_MYSQL_INTRO);
475 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_MYSQL_ODBC);
476 break;
477 case DST_MYSQL_JDBC:
478 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_MYSQL_INTRO);
479 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_MYSQL_JDBC);
480 break;
481 case DST_MYSQL_NATIVE:
482 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_MYSQL_INTRO);
483 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_MYSQL_NATIVE);
484 break;
485 case DST_ORACLE_JDBC:
486 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_ORACLE);
487 break;
488 case DST_ADABAS:
489 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_ADABAS);
490 break;
491 case DST_LDAP:
492 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_LDAP);
493 break;
494 case DST_MSACCESS:
495 case DST_MSACCESS_2007:
496 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_MSACCESS);
497 break;
498 case DST_OUTLOOKEXP:
499 case DST_OUTLOOK:
500 case DST_MOZILLA:
501 case DST_THUNDERBIRD:
502 case DST_EVOLUTION:
503 case DST_EVOLUTION_GROUPWISE:
504 case DST_EVOLUTION_LDAP:
505 case DST_KAB:
506 case DST_MACAB:
507 case DST_EMBEDDED_HSQLDB:
508 break;
509 default:
510 _rOutPathIds.push_back(PAGE_DBSETUPWIZARD_USERDEFINED);
511 break;
512 }
513 }
514 // -----------------------------------------------------------------------------
getType(const::rtl::OUString & _sURL) const515 ::rtl::OUString ODsnTypeCollection::getType(const ::rtl::OUString& _sURL) const
516 {
517 ::rtl::OUString sOldPattern;
518 StringVector::const_iterator aIter = m_aDsnPrefixes.begin();
519 StringVector::const_iterator aEnd = m_aDsnPrefixes.end();
520 for(;aIter != aEnd;++aIter)
521 {
522 WildCard aWildCard(*aIter);
523 if ( sOldPattern.getLength() < aIter->Len() && aWildCard.Matches(_sURL) )
524 {
525 sOldPattern = *aIter;
526 }
527 } // for(sal_Int32 i = 0;aIter != aEnd;++aIter,++i)
528 return sOldPattern;
529 }
530 // -----------------------------------------------------------------------------
getIndexOf(const::rtl::OUString & _sURL) const531 sal_Int32 ODsnTypeCollection::getIndexOf(const ::rtl::OUString& _sURL) const
532 {
533 sal_Int32 nRet = -1;
534 String sURL( _sURL);
535 String sOldPattern;
536 StringVector::const_iterator aIter = m_aDsnPrefixes.begin();
537 StringVector::const_iterator aEnd = m_aDsnPrefixes.end();
538 for(sal_Int32 i = 0;aIter != aEnd;++aIter,++i)
539 {
540 WildCard aWildCard(*aIter);
541 if ( sOldPattern.Len() < aIter->Len() && aWildCard.Matches(sURL) )
542 {
543 nRet = i;
544 sOldPattern = *aIter;
545 }
546 }
547
548 return nRet;
549 }
550 // -----------------------------------------------------------------------------
size() const551 sal_Int32 ODsnTypeCollection::size() const
552 {
553 return m_aDsnPrefixes.size();
554 }
555 //=========================================================================
556 //= ODsnTypeCollection::TypeIterator
557 //=========================================================================
558 //-------------------------------------------------------------------------
TypeIterator(const ODsnTypeCollection * _pContainer,sal_Int32 _nInitialPos)559 ODsnTypeCollection::TypeIterator::TypeIterator(const ODsnTypeCollection* _pContainer, sal_Int32 _nInitialPos)
560 :m_pContainer(_pContainer)
561 ,m_nPosition(_nInitialPos)
562 {
563 DBG_ASSERT(m_pContainer, "ODsnTypeCollection::TypeIterator::TypeIterator : invalid container!");
564 #ifdef DBG_UTIL
565 ++const_cast<ODsnTypeCollection*>(m_pContainer)->m_nLivingIterators;
566 #endif
567 }
568
569 //-------------------------------------------------------------------------
TypeIterator(const TypeIterator & _rSource)570 ODsnTypeCollection::TypeIterator::TypeIterator(const TypeIterator& _rSource)
571 :m_pContainer(_rSource.m_pContainer)
572 ,m_nPosition(_rSource.m_nPosition)
573 {
574 #ifdef DBG_UTIL
575 ++const_cast<ODsnTypeCollection*>(m_pContainer)->m_nLivingIterators;
576 #endif
577 }
578
579 //-------------------------------------------------------------------------
~TypeIterator()580 ODsnTypeCollection::TypeIterator::~TypeIterator()
581 {
582 #ifdef DBG_UTIL
583 --const_cast<ODsnTypeCollection*>(m_pContainer)->m_nLivingIterators;
584 #endif
585 }
586
587 //-------------------------------------------------------------------------
getDisplayName() const588 String ODsnTypeCollection::TypeIterator::getDisplayName() const
589 {
590 DBG_ASSERT(m_nPosition < (sal_Int32)m_pContainer->m_aDsnTypesDisplayNames.size(), "ODsnTypeCollection::TypeIterator::getDisplayName : invalid position!");
591 return m_pContainer->m_aDsnTypesDisplayNames[m_nPosition];
592 }
593 // -----------------------------------------------------------------------------
getURLPrefix() const594 ::rtl::OUString ODsnTypeCollection::TypeIterator::getURLPrefix() const
595 {
596 DBG_ASSERT(m_nPosition < (sal_Int32)m_pContainer->m_aDsnPrefixes.size(), "ODsnTypeCollection::TypeIterator::getDisplayName : invalid position!");
597 return m_pContainer->m_aDsnPrefixes[m_nPosition];
598 }
599 //-------------------------------------------------------------------------
operator ++()600 const ODsnTypeCollection::TypeIterator& ODsnTypeCollection::TypeIterator::operator++()
601 {
602 DBG_ASSERT(m_nPosition < (sal_Int32)m_pContainer->m_aDsnTypesDisplayNames.size(), "ODsnTypeCollection::TypeIterator::operator++ : invalid position!");
603 if (m_nPosition < (sal_Int32)m_pContainer->m_aDsnTypesDisplayNames.size())
604 ++m_nPosition;
605 return *this;
606 }
607
608 //-------------------------------------------------------------------------
operator --()609 const ODsnTypeCollection::TypeIterator& ODsnTypeCollection::TypeIterator::operator--()
610 {
611 DBG_ASSERT(m_nPosition >= 0, "ODsnTypeCollection::TypeIterator::operator-- : invalid position!");
612 if (m_nPosition >= 0)
613 --m_nPosition;
614 return *this;
615 }
616
617 //-------------------------------------------------------------------------
operator ==(const ODsnTypeCollection::TypeIterator & lhs,const ODsnTypeCollection::TypeIterator & rhs)618 bool operator==(const ODsnTypeCollection::TypeIterator& lhs, const ODsnTypeCollection::TypeIterator& rhs)
619 {
620 return (lhs.m_pContainer == rhs.m_pContainer) && (lhs.m_nPosition == rhs.m_nPosition);
621 }
622
623 //.........................................................................
624 } // namespace dbaccess
625 //.........................................................................
626
627