Line data Source code
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 : #ifndef INCLUDED_CONNECTIVITY_FVALUE_HXX
21 : #define INCLUDED_CONNECTIVITY_FVALUE_HXX
22 :
23 : #include <com/sun/star/sdbc/DataType.hpp>
24 : #include <com/sun/star/uno/Any.hxx>
25 : #include <rtl/ustring.hxx>
26 : #include <salhelper/simplereferenceobject.hxx>
27 : #include <osl/diagnose.h>
28 : #include <rtl/ref.hxx>
29 : #include <connectivity/dbtoolsdllapi.hxx>
30 : #include <connectivity/CommonTools.hxx>
31 : #include <com/sun/star/util/DateTime.hpp>
32 : #include <com/sun/star/util/Date.hpp>
33 : #include <com/sun/star/util/Time.hpp>
34 : #include <com/sun/star/uno/Sequence.hxx>
35 : #include <com/sun/star/sdbc/XRow.hpp>
36 : #include <com/sun/star/sdb/XColumn.hpp>
37 :
38 : namespace connectivity
39 : {
40 : namespace detail
41 : {
42 : class IValueSource;
43 : }
44 :
45 : class OOO_DLLPUBLIC_DBTOOLS ORowSetValue
46 : {
47 : union
48 : {
49 : bool m_bBool;
50 :
51 : sal_Int8 m_nInt8;
52 : sal_uInt8 m_uInt8;
53 :
54 : sal_Int16 m_nInt16;
55 : sal_uInt16 m_uInt16;
56 :
57 : sal_Int32 m_nInt32;
58 : sal_uInt32 m_uInt32;
59 :
60 : sal_Int64 m_nInt64;
61 : sal_uInt64 m_uInt64;
62 :
63 : float m_nFloat;
64 : double m_nDouble;
65 :
66 : rtl_uString* m_pString;
67 :
68 : void* m_pValue; // date/time/timestamp/sequence
69 : } m_aValue;
70 :
71 : sal_Int32 m_eTypeKind; // the database type
72 : bool m_bNull : 1; // value is null
73 : bool m_bBound : 1; // is bound
74 : bool m_bModified : 1; // value was changed
75 : bool m_bSigned : 1; // value is signed
76 :
77 : void free();
78 :
79 : public:
80 15407 : ORowSetValue()
81 : :m_eTypeKind(::com::sun::star::sdbc::DataType::VARCHAR)
82 : ,m_bNull(true)
83 : ,m_bBound(true)
84 : ,m_bModified(false)
85 15407 : ,m_bSigned(true)
86 : {
87 15407 : m_aValue.m_pString = NULL;
88 15407 : }
89 :
90 14138 : ORowSetValue(const ORowSetValue& _rRH)
91 : :m_eTypeKind(::com::sun::star::sdbc::DataType::VARCHAR)
92 : ,m_bNull(true)
93 : ,m_bBound(true)
94 : ,m_bModified(false)
95 14138 : ,m_bSigned(true)
96 : {
97 14138 : m_aValue.m_pString = NULL;
98 14138 : operator=(_rRH);
99 14138 : }
100 :
101 16736 : ORowSetValue(const OUString& _rRH)
102 : :m_eTypeKind(::com::sun::star::sdbc::DataType::VARCHAR)
103 : ,m_bNull(true)
104 : ,m_bBound(true)
105 : ,m_bModified(false)
106 16736 : ,m_bSigned(true)
107 : {
108 16736 : m_aValue.m_pString = NULL;
109 16736 : operator=(_rRH);
110 16736 : }
111 :
112 2 : ORowSetValue(const double& _rRH)
113 : :m_eTypeKind(::com::sun::star::sdbc::DataType::DOUBLE)
114 : ,m_bNull(true)
115 : ,m_bBound(true)
116 : ,m_bModified(false)
117 2 : ,m_bSigned(true)
118 : {
119 2 : m_aValue.m_pString = NULL;
120 2 : operator=(_rRH);
121 2 : }
122 :
123 2 : ORowSetValue(const float& _rRH)
124 : :m_eTypeKind(::com::sun::star::sdbc::DataType::FLOAT)
125 : ,m_bNull(true)
126 : ,m_bBound(true)
127 : ,m_bModified(false)
128 2 : ,m_bSigned(true)
129 : {
130 2 : m_aValue.m_pString = NULL;
131 2 : operator=(_rRH);
132 2 : }
133 :
134 2 : ORowSetValue(const sal_Int8& _rRH)
135 : :m_eTypeKind(::com::sun::star::sdbc::DataType::TINYINT)
136 : ,m_bNull(true)
137 : ,m_bBound(true)
138 : ,m_bModified(false)
139 2 : ,m_bSigned(true)
140 : {
141 2 : m_aValue.m_pString = NULL;
142 2 : operator=(_rRH);
143 2 : }
144 :
145 30 : ORowSetValue(const sal_uInt8& _rRH)
146 : :m_eTypeKind(::com::sun::star::sdbc::DataType::TINYINT)
147 : ,m_bNull(true)
148 : ,m_bBound(true)
149 : ,m_bModified(false)
150 30 : ,m_bSigned(false)
151 : {
152 30 : m_aValue.m_pString = NULL;
153 30 : operator=(_rRH);
154 30 : }
155 198 : ORowSetValue(const sal_Int16& _rRH)
156 : :m_eTypeKind(::com::sun::star::sdbc::DataType::SMALLINT)
157 : ,m_bNull(true)
158 : ,m_bBound(true)
159 : ,m_bModified(false)
160 198 : ,m_bSigned(true)
161 : {
162 198 : m_aValue.m_pString = NULL;
163 198 : operator=(_rRH);
164 198 : }
165 2 : ORowSetValue(const sal_uInt16& _rRH)
166 : :m_eTypeKind(::com::sun::star::sdbc::DataType::SMALLINT)
167 : ,m_bNull(true)
168 : ,m_bBound(true)
169 : ,m_bModified(false)
170 2 : ,m_bSigned(false)
171 : {
172 2 : m_aValue.m_pString = NULL;
173 2 : operator=(_rRH);
174 2 : }
175 9814 : ORowSetValue(const sal_Int32& _rRH)
176 : :m_eTypeKind(::com::sun::star::sdbc::DataType::INTEGER)
177 : ,m_bNull(true)
178 : ,m_bBound(true)
179 : ,m_bModified(false)
180 9814 : ,m_bSigned(true)
181 : {
182 9814 : m_aValue.m_pString = NULL;
183 9814 : operator=(_rRH);
184 9814 : }
185 2 : ORowSetValue(const sal_uInt32& _rRH)
186 : :m_eTypeKind(::com::sun::star::sdbc::DataType::INTEGER)
187 : ,m_bNull(true)
188 : ,m_bBound(true)
189 : ,m_bModified(false)
190 2 : ,m_bSigned(false)
191 : {
192 2 : m_aValue.m_pString = NULL;
193 2 : operator=(_rRH);
194 2 : }
195 2 : ORowSetValue(const sal_Int64& _rRH)
196 : :m_eTypeKind(::com::sun::star::sdbc::DataType::BIGINT)
197 : ,m_bNull(true)
198 : ,m_bBound(true)
199 : ,m_bModified(false)
200 2 : ,m_bSigned(true)
201 : {
202 2 : m_aValue.m_pString = NULL;
203 2 : operator=(_rRH);
204 2 : }
205 2 : ORowSetValue(const sal_uInt64& _rRH)
206 : :m_eTypeKind(::com::sun::star::sdbc::DataType::BIGINT)
207 : ,m_bNull(true)
208 : ,m_bBound(true)
209 : ,m_bModified(false)
210 2 : ,m_bSigned(false)
211 : {
212 2 : m_aValue.m_pString = NULL;
213 2 : operator=(_rRH);
214 2 : }
215 :
216 14 : ORowSetValue(const bool& _rRH)
217 : :m_eTypeKind(::com::sun::star::sdbc::DataType::BIT)
218 : ,m_bNull(true)
219 : ,m_bBound(true)
220 : ,m_bModified(false)
221 14 : ,m_bSigned(true)
222 : {
223 14 : m_aValue.m_pString = NULL;
224 14 : operator=(_rRH);
225 14 : }
226 :
227 108 : ORowSetValue(const ::com::sun::star::util::Date& _rRH)
228 : :m_eTypeKind(::com::sun::star::sdbc::DataType::DATE)
229 : ,m_bNull(true)
230 : ,m_bBound(true)
231 : ,m_bModified(false)
232 108 : ,m_bSigned(true)
233 : {
234 108 : m_aValue.m_pString = NULL;
235 108 : operator=(_rRH);
236 108 : }
237 :
238 0 : ORowSetValue(const ::com::sun::star::util::Time& _rRH)
239 : :m_eTypeKind(::com::sun::star::sdbc::DataType::TIME)
240 : ,m_bNull(true)
241 : ,m_bBound(true)
242 : ,m_bModified(false)
243 0 : ,m_bSigned(true)
244 : {
245 0 : m_aValue.m_pString = NULL;
246 0 : operator=(_rRH);
247 0 : }
248 :
249 0 : ORowSetValue(const ::com::sun::star::util::DateTime& _rRH)
250 : :m_eTypeKind(::com::sun::star::sdbc::DataType::TIMESTAMP)
251 : ,m_bNull(true)
252 : ,m_bBound(true)
253 : ,m_bModified(false)
254 0 : ,m_bSigned(true)
255 : {
256 0 : m_aValue.m_pString = NULL;
257 0 : operator=(_rRH);
258 0 : }
259 :
260 0 : ORowSetValue(const ::com::sun::star::uno::Sequence<sal_Int8>& _rRH)
261 : :m_eTypeKind(::com::sun::star::sdbc::DataType::LONGVARBINARY)
262 : ,m_bNull(true)
263 : ,m_bBound(true)
264 : ,m_bModified(false)
265 0 : ,m_bSigned(true)
266 : {
267 0 : m_aValue.m_pString = NULL;
268 0 : operator=(_rRH);
269 0 : }
270 :
271 56447 : ~ORowSetValue()
272 : {
273 56447 : free();
274 56447 : }
275 :
276 : inline static void * SAL_CALL operator new( size_t nSize )
277 : { return ::rtl_allocateMemory( nSize ); }
278 : inline static void * SAL_CALL operator new( size_t,void* _pHint )
279 : { return _pHint; }
280 : inline static void SAL_CALL operator delete( void * pMem )
281 : { ::rtl_freeMemory( pMem ); }
282 : inline static void SAL_CALL operator delete( void *,void* )
283 : { }
284 :
285 : ORowSetValue& operator=(const ORowSetValue& _rRH);
286 :
287 : // simple types
288 : ORowSetValue& operator=(const bool _rRH);
289 :
290 : ORowSetValue& operator=(const sal_Int8& _rRH);
291 : ORowSetValue& operator=(const sal_uInt8& _rRH);
292 :
293 : ORowSetValue& operator=(const sal_Int16& _rRH);
294 : ORowSetValue& operator=(const sal_uInt16& _rRH);
295 :
296 : ORowSetValue& operator=(const sal_Int32& _rRH);
297 : ORowSetValue& operator=(const sal_uInt32& _rRH);
298 :
299 : ORowSetValue& operator=(const sal_Int64& _rRH);
300 : ORowSetValue& operator=(const sal_uInt64& _rRH);
301 :
302 : ORowSetValue& operator=(const double& _rRH);
303 : ORowSetValue& operator=(const float& _rRH);
304 :
305 : // ADT's
306 : ORowSetValue& operator=(const ::com::sun::star::util::Date& _rRH);
307 : ORowSetValue& operator=(const ::com::sun::star::util::Time& _rRH);
308 : ORowSetValue& operator=(const ::com::sun::star::util::DateTime& _rRH);
309 :
310 : ORowSetValue& operator=(const OUString& _rRH);
311 : // the type isn't set it will be set to VARCHAR if the type is different change it
312 : ORowSetValue& operator=(const ::com::sun::star::uno::Sequence<sal_Int8>& _rRH);
313 : // we the possibility to save a any for bookmarks
314 : ORowSetValue& operator=(const ::com::sun::star::uno::Any& _rAny);
315 :
316 8 : operator bool() const { return isNull() ? false : getBool(); }
317 0 : operator sal_Int8() const { return isNull() ? static_cast<sal_Int8>(0) : getInt8(); }
318 356 : operator sal_uInt8() const { return isNull() ? static_cast<sal_uInt8>(0) : getUInt8(); }
319 :
320 176 : operator sal_Int16() const { return isNull() ? static_cast<sal_Int16>(0) : getInt16(); }
321 : operator sal_uInt16() const { return isNull() ? static_cast<sal_uInt16>(0) : getUInt16(); }
322 :
323 2878 : operator sal_Int32() const { return isNull() ? 0 : getInt32(); }
324 0 : operator sal_uInt32() const { return isNull() ? 0 : getUInt32(); }
325 :
326 0 : operator sal_Int64() const { return isNull() ? 0 : getLong(); }
327 0 : operator sal_uInt64() const { return isNull() ? 0 : getULong(); }
328 :
329 0 : operator float() const { return isNull() ? (float)0.0: getFloat(); }
330 8 : operator double() const { return isNull() ? 0.0 : getDouble(); }
331 :
332 9514 : operator OUString() const
333 : {
334 9514 : return isNull() ? OUString() : getString();
335 : }
336 :
337 112 : operator ::com::sun::star::util::Date() const
338 : {
339 112 : return isNull() ? ::com::sun::star::util::Date() : getDate();
340 : }
341 :
342 0 : operator ::com::sun::star::util::Time() const
343 : {
344 0 : return isNull() ? ::com::sun::star::util::Time() : getTime();
345 : }
346 :
347 0 : operator ::com::sun::star::util::DateTime() const
348 : {
349 0 : return isNull() ? ::com::sun::star::util::DateTime() : getDateTime();
350 : }
351 :
352 0 : operator ::com::sun::star::uno::Sequence<sal_Int8>() const
353 : {
354 0 : return isNull() ? ::com::sun::star::uno::Sequence<sal_Int8>() : getSequence();
355 : }
356 :
357 : bool operator==(const ORowSetValue& _rRH) const;
358 3060 : bool operator!=(const ORowSetValue& _rRH) const
359 : {
360 3060 : return !( *this == _rRH );
361 : }
362 :
363 28209 : bool isNull() const
364 : {
365 28209 : return m_bNull;
366 : }
367 48464 : void setNull()
368 : {
369 48464 : free();
370 48464 : m_bNull = true;
371 48464 : m_aValue.m_pString = NULL;
372 48464 : }
373 :
374 131441 : bool isBound() const { return m_bBound; }
375 21708 : void setBound(bool _bBound) { m_bBound = _bBound; }
376 :
377 50 : bool isModified() const { return m_bModified; }
378 376 : void setModified(bool _bMod=true) { m_bModified = _bMod; }
379 :
380 228 : bool isSigned() const { return m_bSigned; }
381 : void setSigned(bool _bSig=true);
382 :
383 10899 : sal_Int32 getTypeKind() const { return m_eTypeKind; }
384 : void setTypeKind(sal_Int32 _eType);
385 :
386 : // before calling one of this methods, be sure that the value is not null
387 : void* getValue() const { OSL_ENSURE(m_bBound,"Value is not bound!");return m_aValue.m_pValue; }
388 : bool getBool() const;
389 :
390 : sal_Int8 getInt8() const;
391 : sal_uInt8 getUInt8() const;
392 :
393 : sal_Int16 getInt16() const;
394 : sal_uInt16 getUInt16() const;
395 :
396 : sal_Int32 getInt32() const;
397 : sal_uInt32 getUInt32() const;
398 :
399 : sal_Int64 getLong() const;
400 : sal_uInt64 getULong() const;
401 :
402 : double getDouble() const;
403 : float getFloat() const;
404 :
405 : OUString getString() const; // makes a automatic conversion if type isn't a string
406 : ::com::sun::star::util::Date getDate() const;
407 : ::com::sun::star::util::Time getTime() const;
408 : ::com::sun::star::util::DateTime getDateTime() const;
409 : ::com::sun::star::uno::Sequence<sal_Int8> getSequence() const;
410 : // only use for anys
411 625 : ::com::sun::star::uno::Any getAny() const { return *(::com::sun::star::uno::Any*)m_aValue.m_pValue; }
412 : ::com::sun::star::uno::Any makeAny() const;
413 :
414 : /**
415 : fetches a single value out of the row
416 : @param _nPos the current column position
417 : @param _nType the type of the current column
418 : @param _xRow the row where to fetch the data from
419 : */
420 : void fill(sal_Int32 _nPos,
421 : sal_Int32 _nType,
422 : const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XRow>& _xRow);
423 :
424 : /**
425 : fetches a single value out of the row
426 : @param _nPos the current column position
427 : @param _nType the type of the current column
428 : @param _bNullable if true then it will be checked if the result could be NULL, otherwise not.
429 : @param _xRow the row where to fetch the data from
430 : */
431 : void fill(sal_Int32 _nPos,
432 : sal_Int32 _nType,
433 : bool _bNullable,
434 : const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XRow>& _xRow);
435 :
436 : void fill(const ::com::sun::star::uno::Any& _rValue);
437 :
438 : void fill( const sal_Int32 _nType,
439 : const ::com::sun::star::uno::Reference< ::com::sun::star::sdb::XColumn >& _rxColumn );
440 :
441 : private:
442 : void impl_fill( const sal_Int32 _nType, bool _bNullable, const detail::IValueSource& _rValueSource );
443 : };
444 :
445 : /// ORowSetValueDecorator decorates a ORowSetValue so the value is "refcounted"
446 18600 : class OOO_DLLPUBLIC_DBTOOLS ORowSetValueDecorator : public ::salhelper::SimpleReferenceObject
447 : {
448 : ORowSetValue m_aValue; // my own value
449 : public:
450 5840 : ORowSetValueDecorator(){m_aValue.setBound(true);}
451 3460 : ORowSetValueDecorator(const ORowSetValue& _aValue) : m_aValue(_aValue){m_aValue.setBound(true);}
452 : ORowSetValueDecorator& operator=(const ORowSetValue& _aValue);
453 :
454 9862 : inline operator const ORowSetValue&() const { return m_aValue; }
455 0 : inline bool operator ==( const ORowSetValue & _rRH ) { return m_aValue == _rRH; }
456 8210 : inline const ORowSetValue& getValue() const { return m_aValue; }
457 32120 : inline ORowSetValue& get() { return m_aValue; }
458 244 : inline void setValue(const ORowSetValue& _aValue) { m_aValue = _aValue; }
459 43954 : inline void setNull() { m_aValue.setNull(); }
460 11984 : inline void setBound(bool _bBound ) { m_aValue.setBound(_bBound);}
461 128160 : inline bool isBound( ) const { return m_aValue.isBound();}
462 33132 : inline void setTypeKind(sal_Int32 _nType) { m_aValue.setTypeKind(_nType); }
463 160 : inline void setModified(bool _bModified) { m_aValue.setModified(_bModified); }
464 :
465 : };
466 : typedef ::rtl::Reference<ORowSetValueDecorator> ORowSetValueDecoratorRef;
467 :
468 :
469 : /// TSetBound is a unary_function to set the bound value with e.q. for_each call
470 : struct OOO_DLLPUBLIC_DBTOOLS TSetBound : ::std::unary_function<ORowSetValue,void>
471 : {
472 : bool m_bBound;
473 4 : TSetBound(bool _bBound) : m_bBound(_bBound){}
474 148 : void operator()(ORowSetValue& _rValue) const { _rValue.setBound(m_bBound); }
475 :
476 : };
477 :
478 :
479 : /// TSetBound is a unary_function to set the bound value with e.q. for_each call
480 : struct OOO_DLLPUBLIC_DBTOOLS TSetRefBound : ::std::unary_function<ORowSetValueDecoratorRef,void>
481 : {
482 : bool m_bBound;
483 310 : TSetRefBound(bool _bBound) : m_bBound(_bBound){}
484 5472 : void operator()(ORowSetValueDecoratorRef& _rValue) const { _rValue->setBound(m_bBound); }
485 :
486 : };
487 :
488 :
489 : // Vector for file based rows
490 :
491 408 : template< class VectorVal > class ODeleteVector : public connectivity::ORowVector< VectorVal >
492 : {
493 : bool m_bDeleted;
494 : public:
495 88 : ODeleteVector() : connectivity::ORowVector< VectorVal >() ,m_bDeleted(false) {}
496 316 : ODeleteVector(size_t _st) : connectivity::ORowVector< VectorVal >(_st) ,m_bDeleted(false) {}
497 :
498 4112 : bool isDeleted() const { return m_bDeleted; }
499 4508 : void setDeleted(bool _bDeleted) { m_bDeleted = _bDeleted; }
500 : };
501 :
502 : typedef ODeleteVector< ORowSetValue > OValueVector;
503 :
504 800 : class OOO_DLLPUBLIC_DBTOOLS OValueRefVector : public ODeleteVector< ORowSetValueDecoratorRef >
505 : {
506 : public:
507 88 : OValueRefVector(){}
508 312 : OValueRefVector(size_t _st) : ODeleteVector< ORowSetValueDecoratorRef >(_st)
509 : {
510 6070 : for(OValueRefVector::Vector::iterator aIter = get().begin() ; aIter != get().end() ;++aIter)
511 5758 : *aIter = new ORowSetValueDecorator;
512 312 : }
513 : };
514 :
515 : #define SQL_NO_PARAMETER (SAL_MAX_UINT32)
516 0 : class OAssignValues : public OValueRefVector
517 : {
518 : ::std::vector<sal_Int32> m_nParameterIndexes;
519 : public:
520 : OAssignValues() : m_nParameterIndexes(1,SQL_NO_PARAMETER){}
521 0 : OAssignValues(Vector::size_type n) : OValueRefVector(n),m_nParameterIndexes(n+1,SQL_NO_PARAMETER){}
522 :
523 0 : void setParameterIndex(sal_Int32 _nId,sal_Int32 _nParameterIndex) { m_nParameterIndexes[_nId] = _nParameterIndex;}
524 0 : sal_Int32 getParameterIndex(sal_Int32 _nId) const { return m_nParameterIndexes[_nId]; }
525 : };
526 :
527 : typedef ::rtl::Reference< OAssignValues > ORefAssignValues;
528 :
529 :
530 :
531 : typedef ::rtl::Reference< OValueVector > OValueRow;
532 : typedef ::rtl::Reference< OValueRefVector > OValueRefRow;
533 : }
534 :
535 : #endif // INCLUDED_CONNECTIVITY_FVALUE_HXX
536 :
537 :
538 : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
