?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Version 5.4.3.2, tag libreoffice-5.4.3.2
[LibreOffice.git] / svx / source / fmcomp / dbaexchange.cxx
blobe8c422914628bb94658874efdd43bd951648cb4d
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3 * This file is part of the LibreOffice project.
4 *
5 * This Source Code Form is subject to the terms of the Mozilla Public
6 * License, v. 2.0. If a copy of the MPL was not distributed with this
7 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 *
9 * This file incorporates work covered by the following license notice:
10 *
11 * Licensed to the Apache Software Foundation (ASF) under one or more
12 * contributor license agreements. See the NOTICE file distributed
13 * with this work for additional information regarding copyright
14 * ownership. The ASF licenses this file to you under the Apache
15 * License, Version 2.0 (the "License"); you may not use this file
16 * except in compliance with the License. You may obtain a copy of
17 * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 */
19
20 #include <svx/dbaexchange.hxx>
21 #include <osl/diagnose.h>
22 #include <com/sun/star/sdb/CommandType.hpp>
23 #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
24 #include <com/sun/star/sdb/XSQLQueryComposerFactory.hpp>
25 #include "fmprop.hrc"
26 #include <comphelper/extract.hxx>
27 #include <sot/formats.hxx>
28 #include <sot/exchange.hxx>
29 #include <comphelper/propertysetinfo.hxx>
30
31
32 namespace svx
33 {
34
35
36 using namespace ::com::sun::star::uno;
37 using namespace ::com::sun::star::beans;
38 using namespace ::com::sun::star::sdb;
39 using namespace ::com::sun::star::sdbc;
40 using namespace ::com::sun::star::lang;
41 using namespace ::com::sun::star::sdbcx;
42 using namespace ::com::sun::star::container;
43 using namespace ::com::sun::star::datatransfer;
44 using namespace ::comphelper;
45
46 OColumnTransferable::OColumnTransferable(const OUString& _rDatasource
47 ,const OUString& _rCommand
48 ,const OUString& _rFieldName
49 ,ColumnTransferFormatFlags _nFormats)
50 :m_nFormatFlags(_nFormats)
51 {
52 implConstruct(_rDatasource,OUString(), css::sdb::CommandType::TABLE, _rCommand, _rFieldName);
53 }
54
55
56 OColumnTransferable::OColumnTransferable(const ODataAccessDescriptor& _rDescriptor, ColumnTransferFormatFlags _nFormats )
57 :m_nFormatFlags(_nFormats)
58 {
59 OUString sDataSource, sDatabaseLocation, sConnectionResource, sCommand, sFieldName;
60 if ( _rDescriptor.has( DataAccessDescriptorProperty::DataSource ) ) _rDescriptor[ DataAccessDescriptorProperty::DataSource ] >>= sDataSource;
61 if ( _rDescriptor.has( DataAccessDescriptorProperty::DatabaseLocation ) ) _rDescriptor[ DataAccessDescriptorProperty::DatabaseLocation ] >>= sDatabaseLocation;
62 if ( _rDescriptor.has( DataAccessDescriptorProperty::ConnectionResource ) ) _rDescriptor[ DataAccessDescriptorProperty::ConnectionResource ] >>= sConnectionResource;
63 if ( _rDescriptor.has( DataAccessDescriptorProperty::Command ) ) _rDescriptor[ DataAccessDescriptorProperty::Command ] >>= sCommand;
64 if ( _rDescriptor.has( DataAccessDescriptorProperty::ColumnName ) ) _rDescriptor[ DataAccessDescriptorProperty::ColumnName ] >>= sFieldName;
65
66 sal_Int32 nCommandType = CommandType::TABLE;
67 OSL_VERIFY( _rDescriptor[ DataAccessDescriptorProperty::CommandType ] >>= nCommandType );
68
69
70 implConstruct(
71 sDataSource.isEmpty() ? sDatabaseLocation : sDataSource,
72 sConnectionResource, nCommandType, sCommand, sFieldName );
73
74 if ( m_nFormatFlags & ColumnTransferFormatFlags::COLUMN_DESCRIPTOR )
75 {
76 if ( _rDescriptor.has( DataAccessDescriptorProperty::Connection ) )
77 m_aDescriptor[ DataAccessDescriptorProperty::Connection ] = _rDescriptor[ DataAccessDescriptorProperty::Connection ];
78 if ( _rDescriptor.has( DataAccessDescriptorProperty::ColumnObject ) )
79 m_aDescriptor[ DataAccessDescriptorProperty::ColumnObject ] = _rDescriptor[ DataAccessDescriptorProperty::ColumnObject ];
80 }
81 }
82
83
84 OColumnTransferable::OColumnTransferable(const Reference< XPropertySet >& _rxForm,
85 const OUString& _rFieldName, const Reference< XPropertySet >& _rxColumn,
86 const Reference< XConnection >& _rxConnection, ColumnTransferFormatFlags _nFormats)
87 :m_nFormatFlags(_nFormats)
88 {
89 OSL_ENSURE(_rxForm.is(), "OColumnTransferable::OColumnTransferable: invalid form!");
90 // collect the necessary information from the form
91 OUString sCommand;
92 sal_Int32 nCommandType = CommandType::TABLE;
93 OUString sDatasource,sURL;
94
95 bool bTryToParse = true;
96 try
97 {
98 _rxForm->getPropertyValue(FM_PROP_COMMANDTYPE) >>= nCommandType;
99 _rxForm->getPropertyValue(FM_PROP_COMMAND) >>= sCommand;
100 _rxForm->getPropertyValue(FM_PROP_DATASOURCE) >>= sDatasource;
101 _rxForm->getPropertyValue(FM_PROP_URL) >>= sURL;
102 bTryToParse = ::cppu::any2bool(_rxForm->getPropertyValue(FM_PROP_ESCAPE_PROCESSING));
103 }
104 catch(Exception&)
105 {
106 OSL_FAIL("OColumnTransferable::OColumnTransferable: could not collect essential data source attributes !");
107 }
108
109 // If the data source is an SQL-statement and simple enough (means "select <field list> from <table> where ....")
110 // we are able to fake the drag information we are about to create.
111 if (bTryToParse && (CommandType::COMMAND == nCommandType))
112 {
113 try
114 {
115 Reference< XTablesSupplier > xSupTab;
116 _rxForm->getPropertyValue("SingleSelectQueryComposer") >>= xSupTab;
117
118 if(xSupTab.is())
119 {
120 Reference< XNameAccess > xNames = xSupTab->getTables();
121 if (xNames.is())
122 {
123 Sequence< OUString > aTables = xNames->getElementNames();
124 if (1 == aTables.getLength())
125 {
126 sCommand = aTables[0];
127 nCommandType = CommandType::TABLE;
128 }
129 }
130 }
131 }
132 catch(Exception&)
133 {
134 OSL_FAIL("OColumnTransferable::OColumnTransferable: could not collect essential data source attributes (part two) !");
135 }
136 }
137
138 implConstruct(sDatasource, sURL,nCommandType, sCommand, _rFieldName);
139
140 if ((m_nFormatFlags & ColumnTransferFormatFlags::COLUMN_DESCRIPTOR) == ColumnTransferFormatFlags::COLUMN_DESCRIPTOR)
141 {
142 if (_rxColumn.is())
143 m_aDescriptor[DataAccessDescriptorProperty::ColumnObject] <<= _rxColumn;
144 if (_rxConnection.is())
145 m_aDescriptor[DataAccessDescriptorProperty::Connection] <<= _rxConnection;
146 }
147 }
148
149
150 SotClipboardFormatId OColumnTransferable::getDescriptorFormatId()
151 {
152 static SotClipboardFormatId s_nFormat = static_cast<SotClipboardFormatId>(-1);
153 if (static_cast<SotClipboardFormatId>(-1) == s_nFormat)
154 {
155 s_nFormat = SotExchange::RegisterFormatName("application/x-openoffice;windows_formatname=\"dbaccess.ColumnDescriptorTransfer\"");
156 OSL_ENSURE(static_cast<SotClipboardFormatId>(-1) != s_nFormat, "OColumnTransferable::getDescriptorFormatId: bad exchange id!");
157 }
158 return s_nFormat;
159 }
160
161
162 void OColumnTransferable::implConstruct( const OUString& _rDatasource
163 ,const OUString& _rConnectionResource
164 ,const sal_Int32 _nCommandType
165 ,const OUString& _rCommand
166 , const OUString& _rFieldName)
167 {
168 const sal_Unicode cSeparator = u'\x000B';
169 const OUString sSeparator(&cSeparator, 1);
170
171 m_sCompatibleFormat.clear();
172 m_sCompatibleFormat += _rDatasource;
173 m_sCompatibleFormat += sSeparator;
174 m_sCompatibleFormat += _rCommand;
175 m_sCompatibleFormat += sSeparator;
176
177 sal_Unicode cCommandType;
178 switch (_nCommandType)
179 {
180 case CommandType::TABLE:
181 cCommandType = '0';
182 break;
183 case CommandType::QUERY:
184 cCommandType = '1';
185 break;
186 default:
187 cCommandType = '2';
188 break;
189 }
190 m_sCompatibleFormat += OUString(&cCommandType, 1);
191 m_sCompatibleFormat += sSeparator;
192 m_sCompatibleFormat += _rFieldName;
193
194 m_aDescriptor.clear();
195 if ((m_nFormatFlags & ColumnTransferFormatFlags::COLUMN_DESCRIPTOR) == ColumnTransferFormatFlags::COLUMN_DESCRIPTOR)
196 {
197 m_aDescriptor.setDataSource(_rDatasource);
198 if ( !_rConnectionResource.isEmpty() )
199 m_aDescriptor[DataAccessDescriptorProperty::ConnectionResource] <<= _rConnectionResource;
200
201 m_aDescriptor[DataAccessDescriptorProperty::Command] <<= _rCommand;
202 m_aDescriptor[DataAccessDescriptorProperty::CommandType] <<= _nCommandType;
203 m_aDescriptor[DataAccessDescriptorProperty::ColumnName] <<= _rFieldName;
204 }
205 }
206
207
208 void OColumnTransferable::AddSupportedFormats()
209 {
210 if (ColumnTransferFormatFlags::CONTROL_EXCHANGE & m_nFormatFlags)
211 AddFormat(SotClipboardFormatId::SBA_CTRLDATAEXCHANGE);
212
213 if (ColumnTransferFormatFlags::FIELD_DESCRIPTOR & m_nFormatFlags)
214 AddFormat(SotClipboardFormatId::SBA_FIELDDATAEXCHANGE);
215
216 if (ColumnTransferFormatFlags::COLUMN_DESCRIPTOR & m_nFormatFlags)
217 AddFormat(getDescriptorFormatId());
218 }
219
220
221 bool OColumnTransferable::GetData( const DataFlavor& _rFlavor, const OUString& /*rDestDoc*/ )
222 {
223 const SotClipboardFormatId nFormatId = SotExchange::GetFormat(_rFlavor);
224 switch (nFormatId)
225 {
226 case SotClipboardFormatId::SBA_FIELDDATAEXCHANGE:
227 case SotClipboardFormatId::SBA_CTRLDATAEXCHANGE:
228 return SetString(m_sCompatibleFormat, _rFlavor);
229 default: break;
230 }
231 if (nFormatId == getDescriptorFormatId())
232 return SetAny( makeAny( m_aDescriptor.createPropertyValueSequence() ) );
233
234 return false;
235 }
236
237
238 bool OColumnTransferable::canExtractColumnDescriptor(const DataFlavorExVector& _rFlavors, ColumnTransferFormatFlags _nFormats)
239 {
240 bool bFieldFormat = bool(_nFormats & ColumnTransferFormatFlags::FIELD_DESCRIPTOR);
241 bool bControlFormat = bool(_nFormats & ColumnTransferFormatFlags::CONTROL_EXCHANGE);
242 bool bDescriptorFormat = bool(_nFormats & ColumnTransferFormatFlags::COLUMN_DESCRIPTOR);
243 for ( DataFlavorExVector::const_iterator aCheck = _rFlavors.begin();
244 aCheck != _rFlavors.end();
245 ++aCheck
246 )
247 {
248 if (bFieldFormat && (SotClipboardFormatId::SBA_FIELDDATAEXCHANGE == aCheck->mnSotId))
249 return true;
250 if (bControlFormat && (SotClipboardFormatId::SBA_CTRLDATAEXCHANGE == aCheck->mnSotId))
251 return true;
252 if (bDescriptorFormat && (getDescriptorFormatId() == aCheck->mnSotId))
253 return true;
254 }
255
256 return false;
257 }
258
259
260 ODataAccessDescriptor OColumnTransferable::extractColumnDescriptor(const TransferableDataHelper& _rData)
261 {
262 if (_rData.HasFormat(getDescriptorFormatId()))
263 {
264 // the object has a real descriptor object (not just the old compatible format)
265
266 // extract the any from the transferable
267 DataFlavor aFlavor;
268 bool bSuccess =
269 SotExchange::GetFormatDataFlavor(getDescriptorFormatId(), aFlavor);
270 OSL_ENSURE(bSuccess, "OColumnTransferable::extractColumnDescriptor: invalid data format (no flavor)!");
271
272 Any aDescriptor = _rData.GetAny(aFlavor, OUString());
273
274 // extract the property value sequence
275 Sequence< PropertyValue > aDescriptorProps;
276 bSuccess = aDescriptor >>= aDescriptorProps;
277 OSL_ENSURE(bSuccess, "OColumnTransferable::extractColumnDescriptor: invalid clipboard format!");
278
279 // build the real descriptor
280 return ODataAccessDescriptor(aDescriptorProps);
281 }
282
283 // only the old (compatible) format exists -> use the other extract method ...
284 OUString sDatasource, sCommand, sFieldName,sDatabaseLocation,sConnectionResource;
285 sal_Int32 nCommandType = CommandType::COMMAND;
286
287 ODataAccessDescriptor aDescriptor;
288 if (extractColumnDescriptor(_rData, sDatasource, sDatabaseLocation,sConnectionResource,nCommandType, sCommand, sFieldName))
289 {
290 // and build an own descriptor
291 if ( !sDatasource.isEmpty() )
292 aDescriptor[DataAccessDescriptorProperty::DataSource] <<= sDatasource;
293 if ( !sDatabaseLocation.isEmpty() )
294 aDescriptor[DataAccessDescriptorProperty::DatabaseLocation] <<= sDatabaseLocation;
295 if ( !sConnectionResource.isEmpty() )
296 aDescriptor[DataAccessDescriptorProperty::ConnectionResource] <<= sConnectionResource;
297
298 aDescriptor[DataAccessDescriptorProperty::Command] <<= sCommand;
299 aDescriptor[DataAccessDescriptorProperty::CommandType] <<= nCommandType;
300 aDescriptor[DataAccessDescriptorProperty::ColumnName] <<= sFieldName;
301 }
302 return aDescriptor;
303 }
304
305
306 bool OColumnTransferable::extractColumnDescriptor(const TransferableDataHelper& _rData
307 ,OUString& _rDatasource
308 ,OUString& _rDatabaseLocation
309 ,OUString& _rConnectionResource
310 ,sal_Int32& _nCommandType
311 ,OUString& _rCommand
312 ,OUString& _rFieldName)
313 {
314 if ( _rData.HasFormat(getDescriptorFormatId()) )
315 {
316 ODataAccessDescriptor aDescriptor = extractColumnDescriptor(_rData);
317 if ( aDescriptor.has(DataAccessDescriptorProperty::DataSource) )
318 aDescriptor[DataAccessDescriptorProperty::DataSource] >>= _rDatasource;
319 if ( aDescriptor.has(DataAccessDescriptorProperty::DatabaseLocation) )
320 aDescriptor[DataAccessDescriptorProperty::DatabaseLocation] >>= _rDatabaseLocation;
321 if ( aDescriptor.has(DataAccessDescriptorProperty::ConnectionResource) )
322 aDescriptor[DataAccessDescriptorProperty::ConnectionResource] >>= _rConnectionResource;
323
324 aDescriptor[DataAccessDescriptorProperty::Command] >>= _rCommand;
325 aDescriptor[DataAccessDescriptorProperty::CommandType] >>= _nCommandType;
326 aDescriptor[DataAccessDescriptorProperty::ColumnName] >>= _rFieldName;
327 return true;
328 }
329
330 // check if we have a (string) format we can use ....
331 SotClipboardFormatId nRecognizedFormat = SotClipboardFormatId::NONE;
332 if (_rData.HasFormat(SotClipboardFormatId::SBA_FIELDDATAEXCHANGE))
333 nRecognizedFormat = SotClipboardFormatId::SBA_FIELDDATAEXCHANGE;
334 if (_rData.HasFormat(SotClipboardFormatId::SBA_CTRLDATAEXCHANGE))
335 nRecognizedFormat = SotClipboardFormatId::SBA_CTRLDATAEXCHANGE;
336 if (nRecognizedFormat == SotClipboardFormatId::NONE)
337 return false;
338
339 OUString sFieldDescription;
340 (void)const_cast<TransferableDataHelper&>(_rData).GetString(nRecognizedFormat, sFieldDescription);
341
342 const sal_Unicode cSeparator = u'\x000B';
343 _rDatasource = sFieldDescription.getToken(0, cSeparator);
344 _rCommand = sFieldDescription.getToken(1, cSeparator);
345 _nCommandType = sFieldDescription.getToken(2, cSeparator).toInt32();
346 _rFieldName = sFieldDescription.getToken(3, cSeparator);
347
348 return true;
349 }
350
351
352 void OColumnTransferable::addDataToContainer( TransferDataContainer* _pContainer )
353 {
354 OSL_ENSURE( _pContainer, "OColumnTransferable::addDataToContainer: invalid container!" );
355 if ( _pContainer )
356 {
357 if ( m_nFormatFlags & ColumnTransferFormatFlags::FIELD_DESCRIPTOR )
358 _pContainer->CopyAny( SotClipboardFormatId::SBA_FIELDDATAEXCHANGE, makeAny( m_sCompatibleFormat ) );
359
360 if ( m_nFormatFlags & ColumnTransferFormatFlags::CONTROL_EXCHANGE )
361 _pContainer->CopyAny( SotClipboardFormatId::SBA_CTRLDATAEXCHANGE, makeAny( m_sCompatibleFormat ) );
362
363 if ( m_nFormatFlags & ColumnTransferFormatFlags::COLUMN_DESCRIPTOR )
364 {
365 Any aContent = makeAny( m_aDescriptor.createPropertyValueSequence() );
366 _pContainer->CopyAny( getDescriptorFormatId(), aContent );
367 }
368 }
369 }
370
371 ODataAccessObjectTransferable::ODataAccessObjectTransferable(
372 const OUString& _rDatasource
373 ,const sal_Int32 _nCommandType
374 ,const OUString& _rCommand
375 )
376 {
377 construct(_rDatasource,OUString(),_nCommandType,_rCommand,nullptr,(CommandType::COMMAND == _nCommandType),_rCommand);
378 }
379
380 ODataAccessObjectTransferable::ODataAccessObjectTransferable(
381 const OUString& _rDatasource
382 ,const sal_Int32 _nCommandType
383 ,const OUString& _rCommand
384 ,const Reference< XConnection >& _rxConnection)
385 {
386 OSL_ENSURE(_rxConnection.is(),"Wrong ctor used.!");
387 construct(_rDatasource,OUString(),_nCommandType,_rCommand,_rxConnection,(CommandType::COMMAND == _nCommandType),_rCommand);
388 }
389
390
391 ODataAccessObjectTransferable::ODataAccessObjectTransferable(const Reference< XPropertySet >& _rxLivingForm)
392 {
393 // collect some properties of the form
394 OUString sDatasourceName,sConnectionResource;
395 sal_Int32 nObjectType = CommandType::COMMAND;
396 OUString sObjectName;
397 Reference< XConnection > xConnection;
398 try
399 {
400 _rxLivingForm->getPropertyValue(FM_PROP_COMMANDTYPE) >>= nObjectType;
401 _rxLivingForm->getPropertyValue(FM_PROP_COMMAND) >>= sObjectName;
402 _rxLivingForm->getPropertyValue(FM_PROP_DATASOURCE) >>= sDatasourceName;
403 _rxLivingForm->getPropertyValue(FM_PROP_URL) >>= sConnectionResource;
404 _rxLivingForm->getPropertyValue(FM_PROP_ACTIVE_CONNECTION) >>= xConnection;
405 }
406 catch(Exception&)
407 {
408 OSL_FAIL("ODataAccessObjectTransferable::ODataAccessObjectTransferable: could not collect essential form attributes !");
409 return;
410 }
411
412 // check if the SQL-statement is modified
413 OUString sCompleteStatement;
414 try
415 {
416 _rxLivingForm->getPropertyValue(FM_PROP_ACTIVECOMMAND) >>= sCompleteStatement;
417 }
418 catch (const Exception&)
419 {
420 OSL_FAIL("ODataAccessObjectTransferable::ODataAccessObjectTransferable: could not collect essential form attributes (part two) !");
421 return;
422 }
423
424 construct( sDatasourceName
425 ,sConnectionResource
426 ,nObjectType
427 ,sObjectName,xConnection
428 ,!((CommandType::QUERY == nObjectType))
429 ,sCompleteStatement);
430 }
431
432
433 void ODataAccessObjectTransferable::AddSupportedFormats()
434 {
435 sal_Int32 nObjectType = CommandType::COMMAND;
436 m_aDescriptor[DataAccessDescriptorProperty::CommandType] >>= nObjectType;
437 switch (nObjectType)
438 {
439 case CommandType::TABLE:
440 AddFormat(SotClipboardFormatId::DBACCESS_TABLE);
441 break;
442 case CommandType::QUERY:
443 AddFormat(SotClipboardFormatId::DBACCESS_QUERY);
444 break;
445 case CommandType::COMMAND:
446 AddFormat(SotClipboardFormatId::DBACCESS_COMMAND);
447 break;
448 }
449
450 if (!m_sCompatibleObjectDescription.isEmpty())
451 AddFormat(SotClipboardFormatId::SBA_DATAEXCHANGE);
452 }
453
454
455 bool ODataAccessObjectTransferable::GetData( const DataFlavor& rFlavor, const OUString& /*rDestDoc*/ )
456 {
457 SotClipboardFormatId nFormat = SotExchange::GetFormat(rFlavor);
458 switch (nFormat)
459 {
460 case SotClipboardFormatId::DBACCESS_TABLE:
461 case SotClipboardFormatId::DBACCESS_QUERY:
462 case SotClipboardFormatId::DBACCESS_COMMAND:
463 return SetAny( makeAny(m_aDescriptor.createPropertyValueSequence()) );
464
465 case SotClipboardFormatId::SBA_DATAEXCHANGE:
466 return SetString(m_sCompatibleObjectDescription, rFlavor);
467 default: break;
468 }
469 return false;
470 }
471
472
473 bool ODataAccessObjectTransferable::canExtractObjectDescriptor(const DataFlavorExVector& _rFlavors)
474 {
475 for ( DataFlavorExVector::const_iterator aCheck = _rFlavors.begin();
476 aCheck != _rFlavors.end();
477 ++aCheck
478 )
479 {
480 if (SotClipboardFormatId::DBACCESS_TABLE == aCheck->mnSotId)
481 return true;
482 if (SotClipboardFormatId::DBACCESS_QUERY == aCheck->mnSotId)
483 return true;
484 if (SotClipboardFormatId::DBACCESS_COMMAND == aCheck->mnSotId)
485 return true;
486 }
487 return false;
488 }
489
490
491 ODataAccessDescriptor ODataAccessObjectTransferable::extractObjectDescriptor(const TransferableDataHelper& _rData)
492 {
493 SotClipboardFormatId nKnownFormatId = SotClipboardFormatId::NONE;
494 if ( _rData.HasFormat( SotClipboardFormatId::DBACCESS_TABLE ) )
495 nKnownFormatId = SotClipboardFormatId::DBACCESS_TABLE;
496 if ( _rData.HasFormat( SotClipboardFormatId::DBACCESS_QUERY ) )
497 nKnownFormatId = SotClipboardFormatId::DBACCESS_QUERY;
498 if ( _rData.HasFormat( SotClipboardFormatId::DBACCESS_COMMAND ) )
499 nKnownFormatId = SotClipboardFormatId::DBACCESS_COMMAND;
500
501 if (SotClipboardFormatId::NONE != nKnownFormatId)
502 {
503 // extract the any from the transferable
504 DataFlavor aFlavor;
505 bool bSuccess =
506 SotExchange::GetFormatDataFlavor(nKnownFormatId, aFlavor);
507 OSL_ENSURE(bSuccess, "OColumnTransferable::extractColumnDescriptor: invalid data format (no flavor)!");
508
509 Any aDescriptor = _rData.GetAny(aFlavor, OUString());
510
511 // extract the property value sequence
512 Sequence< PropertyValue > aDescriptorProps;
513 bSuccess = aDescriptor >>= aDescriptorProps;
514 OSL_ENSURE(bSuccess, "OColumnTransferable::extractColumnDescriptor: invalid clipboard format!");
515
516 // build the real descriptor
517 return ODataAccessDescriptor(aDescriptorProps);
518 }
519
520 OSL_FAIL( "OColumnTransferable::extractColumnDescriptor: unsupported formats only!" );
521 return ODataAccessDescriptor();
522 }
523
524
525 void ODataAccessObjectTransferable::addCompatibleSelectionDescription( const Sequence< Any >& _rSelRows )
526 {
527 const sal_Unicode cSeparator(11);
528 const OUString sSeparator(&cSeparator, 1);
529
530 const Any* pSelRows = _rSelRows.getConstArray();
531 const Any* pSelRowsEnd = pSelRows + _rSelRows.getLength();
532 for ( ; pSelRows < pSelRowsEnd; ++pSelRows )
533 {
534 sal_Int32 nSelectedRow( 0 );
535 OSL_VERIFY( *pSelRows >>= nSelectedRow );
536
537 m_sCompatibleObjectDescription += OUString::number(nSelectedRow);
538 m_sCompatibleObjectDescription += sSeparator;
539 }
540 }
541
542
543 void ODataAccessObjectTransferable::ObjectReleased()
544 {
545 m_aDescriptor.clear();
546 }
547
548 void ODataAccessObjectTransferable::construct( const OUString& _rDatasource
549 ,const OUString& _rConnectionResource
550 ,const sal_Int32 _nCommandType
551 ,const OUString& _rCommand
552 ,const Reference< XConnection >& _rxConnection
553 ,bool _bAddCommand
554 ,const OUString& _sActiveCommand)
555 {
556 m_aDescriptor.setDataSource(_rDatasource);
557 // build the descriptor (the property sequence)
558 if ( !_rConnectionResource.isEmpty() )
559 m_aDescriptor[DataAccessDescriptorProperty::ConnectionResource] <<= _rConnectionResource;
560 if ( _rxConnection.is() )
561 m_aDescriptor[DataAccessDescriptorProperty::Connection] <<= _rxConnection;
562 m_aDescriptor[DataAccessDescriptorProperty::Command] <<= _rCommand;
563 m_aDescriptor[DataAccessDescriptorProperty::CommandType] <<= _nCommandType;
564
565 // extract the single values from the sequence
566
567 OUString sObjectName;
568 sObjectName = _rCommand;
569
570 // for compatibility: create a string which can be used for the SotClipboardFormatId::SBA_DATAEXCHANGE format
571
572 bool bTreatAsStatement = (CommandType::COMMAND == _nCommandType);
573 // statements are - in this old and ugly format - described as queries
574
575 const sal_Unicode cSeparator = u'\x000B';
576 const OUString sSeparator(&cSeparator, 1);
577
578 const sal_Unicode cTableMark = '1';
579 const sal_Unicode cQueryMark = '0';
580
581 // build the descriptor string
582 m_sCompatibleObjectDescription += _rDatasource;
583 m_sCompatibleObjectDescription += sSeparator;
584 m_sCompatibleObjectDescription += bTreatAsStatement ? OUString() : sObjectName;
585 m_sCompatibleObjectDescription += sSeparator;
586 switch (_nCommandType)
587 {
588 case CommandType::TABLE:
589 m_sCompatibleObjectDescription += OUString(&cTableMark, 1);
590 break;
591 case CommandType::QUERY:
592 m_sCompatibleObjectDescription += OUString(&cQueryMark, 1);
593 break;
594 case CommandType::COMMAND:
595 m_sCompatibleObjectDescription += OUString(&cQueryMark, 1);
596 // think of it as a query
597 break;
598 }
599 m_sCompatibleObjectDescription += sSeparator;
600 m_sCompatibleObjectDescription += _bAddCommand ? _sActiveCommand : OUString();
601 m_sCompatibleObjectDescription += sSeparator;
602 }
603
604
605 OMultiColumnTransferable::OMultiColumnTransferable(const Sequence< PropertyValue >& _aDescriptors) : m_aDescriptors(_aDescriptors)
606 {
607 }
608
609 SotClipboardFormatId OMultiColumnTransferable::getDescriptorFormatId()
610 {
611 static SotClipboardFormatId s_nFormat = static_cast<SotClipboardFormatId>(-1);
612 if (static_cast<SotClipboardFormatId>(-1) == s_nFormat)
613 {
614 s_nFormat = SotExchange::RegisterFormatName("application/x-openoffice;windows_formatname=\"dbaccess.MultipleColumnDescriptorTransfer\"");
615 OSL_ENSURE(static_cast<SotClipboardFormatId>(-1) != s_nFormat, "OColumnTransferable::getDescriptorFormatId: bad exchange id!");
616 }
617 return s_nFormat;
618 }
619
620 void OMultiColumnTransferable::AddSupportedFormats()
621 {
622 AddFormat(getDescriptorFormatId());
623 }
624
625 bool OMultiColumnTransferable::GetData( const DataFlavor& _rFlavor, const OUString& /*rDestDoc*/ )
626 {
627 const SotClipboardFormatId nFormatId = SotExchange::GetFormat(_rFlavor);
628 if (nFormatId == getDescriptorFormatId())
629 {
630 return SetAny( makeAny( m_aDescriptors ) );
631 }
632
633 return false;
634 }
635
636
637 bool OMultiColumnTransferable::canExtractDescriptor(const DataFlavorExVector& _rFlavors)
638 {
639 DataFlavorExVector::const_iterator aCheck = _rFlavors.begin();
640 for ( ;
641 aCheck != _rFlavors.end() && getDescriptorFormatId() == aCheck->mnSotId;
642 ++aCheck
643 )
644 ;
645
646 return aCheck == _rFlavors.end();
647 }
648
649
650 Sequence< PropertyValue > OMultiColumnTransferable::extractDescriptor(const TransferableDataHelper& _rData)
651 {
652 Sequence< PropertyValue > aList;
653 if (_rData.HasFormat(getDescriptorFormatId()))
654 {
655 // extract the any from the transferable
656 DataFlavor aFlavor;
657 bool bSuccess =
658 SotExchange::GetFormatDataFlavor(getDescriptorFormatId(), aFlavor);
659 OSL_ENSURE(bSuccess, "OColumnTransferable::extractColumnDescriptor: invalid data format (no flavor)!");
660
661 _rData.GetAny(aFlavor, OUString()) >>= aList;
662 } // if (_rData.HasFormat(getDescriptorFormatId()))
663 return aList;
664 }
665
666 void OMultiColumnTransferable::ObjectReleased()
667 {
668 m_aDescriptors.realloc(0);
669 }
670
671
672 }
673
674
675 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
FREE OFFICE SUITE