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 :
21 : #include <connectivity/sdbcx/VColumn.hxx>
22 : #include <osl/diagnose.h>
23 : #include "file/FPreparedStatement.hxx"
24 : #include <com/sun/star/sdbc/DataType.hpp>
25 : #include "file/FResultSetMetaData.hxx"
26 : #include <cppuhelper/queryinterface.hxx>
27 : #include <cppuhelper/typeprovider.hxx>
28 : #include <comphelper/sequence.hxx>
29 : #include <com/sun/star/lang/DisposedException.hpp>
30 : #include <connectivity/dbconversion.hxx>
31 : #include <connectivity/dbexception.hxx>
32 : #include <connectivity/dbtools.hxx>
33 : #include <connectivity/PColumn.hxx>
34 : #include "diagnose_ex.h"
35 : #include <comphelper/types.hxx>
36 : #include <com/sun/star/sdbc/ColumnValue.hpp>
37 : #include "resource/file_res.hrc"
38 :
39 : using namespace connectivity;
40 : using namespace comphelper;
41 : using namespace ::dbtools;
42 : using namespace connectivity::file;
43 : using namespace com::sun::star::uno;
44 : using namespace com::sun::star::lang;
45 : using namespace com::sun::star::beans;
46 : using namespace com::sun::star::sdbc;
47 : using namespace com::sun::star::sdbcx;
48 : using namespace com::sun::star::container;
49 : using namespace com::sun::star;
50 :
51 0 : IMPLEMENT_SERVICE_INFO(OPreparedStatement,"com.sun.star.sdbc.driver.file.PreparedStatement","com.sun.star.sdbc.PreparedStatement");
52 :
53 69 : OPreparedStatement::OPreparedStatement( OConnection* _pConnection)
54 69 : : OStatement_BASE2( _pConnection )
55 : {
56 69 : }
57 :
58 :
59 69 : OPreparedStatement::~OPreparedStatement()
60 : {
61 69 : }
62 :
63 :
64 69 : void OPreparedStatement::disposing()
65 : {
66 69 : ::osl::MutexGuard aGuard(m_aMutex);
67 :
68 69 : OStatement_BASE2::disposing();
69 :
70 69 : m_xParamColumns = NULL;
71 69 : m_xMetaData.clear();
72 69 : if(m_aParameterRow.is())
73 : {
74 58 : m_aParameterRow->get().clear();
75 58 : m_aParameterRow = NULL;
76 69 : }
77 69 : }
78 :
79 69 : void OPreparedStatement::construct(const OUString& sql) throw(SQLException, RuntimeException)
80 : {
81 69 : OStatement_Base::construct(sql);
82 :
83 58 : m_aParameterRow = new OValueRefVector();
84 58 : m_aParameterRow->get().push_back(new ORowSetValueDecorator(sal_Int32(0)) );
85 :
86 58 : Reference<XIndexAccess> xNames(m_xColNames,UNO_QUERY);
87 :
88 58 : if ( m_aSQLIterator.getStatementType() == SQL_STATEMENT_SELECT )
89 58 : m_xParamColumns = m_aSQLIterator.getParameters();
90 : else
91 : {
92 0 : m_xParamColumns = new OSQLColumns();
93 : // describe all parameters need for the resultset
94 0 : describeParameter();
95 : }
96 :
97 116 : OValueRefRow aTemp;
98 116 : OResultSet::setBoundedColumns(m_aEvaluateRow,aTemp,m_xParamColumns,xNames,false,m_xDBMetaData,m_aColMapping);
99 58 : }
100 :
101 29 : rtl::Reference<OResultSet> OPreparedStatement::makeResultSet()
102 : {
103 29 : closeResultSet();
104 :
105 29 : rtl::Reference<OResultSet> xResultSet(createResultSet());
106 29 : m_xResultSet = xResultSet.get();
107 29 : initializeResultSet(xResultSet.get());
108 29 : initResultSet(xResultSet.get());
109 29 : return xResultSet;
110 : }
111 :
112 762 : Any SAL_CALL OPreparedStatement::queryInterface( const Type & rType ) throw(RuntimeException, std::exception)
113 : {
114 762 : Any aRet = OStatement_BASE2::queryInterface(rType);
115 762 : return aRet.hasValue() ? aRet : ::cppu::queryInterface( rType,
116 : static_cast< XPreparedStatement*>(this),
117 : static_cast< XParameters*>(this),
118 762 : static_cast< XResultSetMetaDataSupplier*>(this));
119 : }
120 :
121 0 : ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL OPreparedStatement::getTypes( ) throw(::com::sun::star::uno::RuntimeException, std::exception)
122 : {
123 0 : ::cppu::OTypeCollection aTypes( cppu::UnoType<XPreparedStatement>::get(),
124 0 : cppu::UnoType<XParameters>::get(),
125 0 : cppu::UnoType<XResultSetMetaDataSupplier>::get());
126 :
127 0 : return ::comphelper::concatSequences(aTypes.getTypes(),OStatement_BASE2::getTypes());
128 : }
129 :
130 :
131 59 : Reference< XResultSetMetaData > SAL_CALL OPreparedStatement::getMetaData( ) throw(SQLException, RuntimeException, std::exception)
132 : {
133 59 : ::osl::MutexGuard aGuard( m_aMutex );
134 59 : checkDisposed(OStatement_BASE::rBHelper.bDisposed);
135 :
136 :
137 59 : if(!m_xMetaData.is())
138 58 : m_xMetaData = new OResultSetMetaData(m_aSQLIterator.getSelectColumns(),m_aSQLIterator.getTables().begin()->first,m_pTable);
139 59 : return m_xMetaData;
140 : }
141 :
142 :
143 58 : void SAL_CALL OPreparedStatement::close( ) throw(SQLException, RuntimeException, std::exception)
144 : {
145 58 : ::osl::MutexGuard aGuard( m_aMutex );
146 58 : checkDisposed(OStatement_BASE::rBHelper.bDisposed);
147 :
148 58 : closeResultSet();
149 58 : }
150 :
151 :
152 0 : sal_Bool SAL_CALL OPreparedStatement::execute( ) throw(SQLException, RuntimeException, std::exception)
153 : {
154 0 : ::osl::MutexGuard aGuard( m_aMutex );
155 0 : checkDisposed(OStatement_BASE::rBHelper.bDisposed);
156 :
157 0 : rtl::Reference<OResultSet> xRS(makeResultSet());
158 : // since we don't support the XMultipleResults interface, nobody will ever get that ResultSet...
159 0 : if(xRS.is())
160 0 : xRS->dispose();
161 :
162 0 : return m_aSQLIterator.getStatementType() == SQL_STATEMENT_SELECT;
163 : }
164 :
165 :
166 0 : sal_Int32 SAL_CALL OPreparedStatement::executeUpdate( ) throw(SQLException, RuntimeException, std::exception)
167 : {
168 0 : ::osl::MutexGuard aGuard( m_aMutex );
169 0 : checkDisposed(OStatement_BASE::rBHelper.bDisposed);
170 :
171 0 : rtl::Reference<OResultSet> xRS(makeResultSet());
172 0 : if(xRS.is())
173 : {
174 0 : const sal_Int32 res(xRS->getRowCountResult());
175 : // nobody will ever get that ResultSet...
176 0 : xRS->dispose();
177 0 : return res;
178 : }
179 : else
180 0 : return 0;
181 : }
182 :
183 :
184 5 : void SAL_CALL OPreparedStatement::setString( sal_Int32 parameterIndex, const OUString& x ) throw(SQLException, RuntimeException, std::exception)
185 : {
186 5 : setParameter(parameterIndex,x);
187 5 : }
188 :
189 :
190 0 : Reference< XConnection > SAL_CALL OPreparedStatement::getConnection( ) throw(SQLException, RuntimeException, std::exception)
191 : {
192 0 : ::osl::MutexGuard aGuard( m_aMutex );
193 0 : checkDisposed(OStatement_BASE::rBHelper.bDisposed);
194 :
195 0 : return Reference< XConnection >(m_pConnection);
196 : }
197 :
198 :
199 29 : Reference< XResultSet > SAL_CALL OPreparedStatement::executeQuery( ) throw(SQLException, RuntimeException, std::exception)
200 : {
201 29 : ::osl::MutexGuard aGuard( m_aMutex );
202 29 : checkDisposed(OStatement_BASE::rBHelper.bDisposed);
203 :
204 29 : return makeResultSet().get();
205 : }
206 :
207 :
208 0 : void SAL_CALL OPreparedStatement::setBoolean( sal_Int32 parameterIndex, sal_Bool x ) throw(SQLException, RuntimeException, std::exception)
209 : {
210 0 : setParameter(parameterIndex,static_cast<bool>(x));
211 0 : }
212 :
213 0 : void SAL_CALL OPreparedStatement::setByte( sal_Int32 parameterIndex, sal_Int8 x ) throw(SQLException, RuntimeException, std::exception)
214 : {
215 0 : setParameter(parameterIndex,x);
216 0 : }
217 :
218 :
219 0 : void SAL_CALL OPreparedStatement::setDate( sal_Int32 parameterIndex, const util::Date& aData ) throw(SQLException, RuntimeException, std::exception)
220 : {
221 0 : setParameter(parameterIndex,DBTypeConversion::toDouble(aData));
222 0 : }
223 :
224 0 : void SAL_CALL OPreparedStatement::setTime( sal_Int32 parameterIndex, const util::Time& aVal ) throw(SQLException, RuntimeException, std::exception)
225 : {
226 0 : setParameter(parameterIndex,DBTypeConversion::toDouble(aVal));
227 0 : }
228 :
229 :
230 0 : void SAL_CALL OPreparedStatement::setTimestamp( sal_Int32 parameterIndex, const util::DateTime& aVal ) throw(SQLException, RuntimeException, std::exception)
231 : {
232 0 : setParameter(parameterIndex,DBTypeConversion::toDouble(aVal));
233 0 : }
234 :
235 :
236 0 : void SAL_CALL OPreparedStatement::setDouble( sal_Int32 parameterIndex, double x ) throw(SQLException, RuntimeException, std::exception)
237 : {
238 0 : setParameter(parameterIndex,x);
239 0 : }
240 :
241 :
242 :
243 0 : void SAL_CALL OPreparedStatement::setFloat( sal_Int32 parameterIndex, float x ) throw(SQLException, RuntimeException, std::exception)
244 : {
245 0 : setParameter(parameterIndex,x);
246 0 : }
247 :
248 :
249 0 : void SAL_CALL OPreparedStatement::setInt( sal_Int32 parameterIndex, sal_Int32 x ) throw(SQLException, RuntimeException, std::exception)
250 : {
251 0 : setParameter(parameterIndex,x);
252 0 : }
253 :
254 :
255 0 : void SAL_CALL OPreparedStatement::setLong( sal_Int32 /*parameterIndex*/, sal_Int64 /*aVal*/ ) throw(SQLException, RuntimeException, std::exception)
256 : {
257 0 : throwFeatureNotImplementedSQLException( "XParameters::setLong", *this );
258 0 : }
259 :
260 :
261 0 : void SAL_CALL OPreparedStatement::setNull( sal_Int32 parameterIndex, sal_Int32 /*sqlType*/ ) throw(SQLException, RuntimeException, std::exception)
262 : {
263 0 : ::osl::MutexGuard aGuard( m_aMutex );
264 0 : checkAndResizeParameters(parameterIndex);
265 :
266 0 : if ( m_aAssignValues.is() )
267 0 : (m_aAssignValues->get())[m_aParameterIndexes[parameterIndex]]->setNull();
268 : else
269 0 : (m_aParameterRow->get())[parameterIndex]->setNull();
270 0 : }
271 :
272 :
273 0 : void SAL_CALL OPreparedStatement::setClob( sal_Int32 /*parameterIndex*/, const Reference< XClob >& /*x*/ ) throw(SQLException, RuntimeException, std::exception)
274 : {
275 0 : throwFeatureNotImplementedSQLException( "XParameters::setClob", *this );
276 0 : }
277 :
278 :
279 0 : void SAL_CALL OPreparedStatement::setBlob( sal_Int32 /*parameterIndex*/, const Reference< XBlob >& /*x*/ ) throw(SQLException, RuntimeException, std::exception)
280 : {
281 0 : throwFeatureNotImplementedSQLException( "XParameters::setBlob", *this );
282 0 : }
283 :
284 :
285 0 : void SAL_CALL OPreparedStatement::setArray( sal_Int32 /*parameterIndex*/, const Reference< XArray >& /*x*/ ) throw(SQLException, RuntimeException, std::exception)
286 : {
287 0 : throwFeatureNotImplementedSQLException( "XParameters::setArray", *this );
288 0 : }
289 :
290 :
291 0 : void SAL_CALL OPreparedStatement::setRef( sal_Int32 /*parameterIndex*/, const Reference< XRef >& /*x*/ ) throw(SQLException, RuntimeException, std::exception)
292 : {
293 0 : throwFeatureNotImplementedSQLException( "XParameters::setRef", *this );
294 0 : }
295 :
296 :
297 0 : void SAL_CALL OPreparedStatement::setObjectWithInfo( sal_Int32 parameterIndex, const Any& x, sal_Int32 sqlType, sal_Int32 scale ) throw(SQLException, RuntimeException, std::exception)
298 : {
299 0 : switch(sqlType)
300 : {
301 : case DataType::DECIMAL:
302 : case DataType::NUMERIC:
303 0 : setString(parameterIndex,::comphelper::getString(x));
304 0 : break;
305 : default:
306 0 : ::dbtools::setObjectWithInfo(this,parameterIndex,x,sqlType,scale);
307 0 : break;
308 : }
309 0 : }
310 :
311 :
312 0 : void SAL_CALL OPreparedStatement::setObjectNull( sal_Int32 parameterIndex, sal_Int32 sqlType, const OUString& /*typeName*/ ) throw(SQLException, RuntimeException, std::exception)
313 : {
314 0 : setNull(parameterIndex,sqlType);
315 0 : }
316 :
317 :
318 0 : void SAL_CALL OPreparedStatement::setObject( sal_Int32 parameterIndex, const Any& x ) throw(SQLException, RuntimeException, std::exception)
319 : {
320 0 : if(!::dbtools::implSetObject(this,parameterIndex,x))
321 : {
322 0 : const OUString sError( m_pConnection->getResources().getResourceStringWithSubstitution(
323 : STR_UNKNOWN_PARA_TYPE,
324 : "$position$", OUString::number(parameterIndex)
325 0 : ) );
326 0 : ::dbtools::throwGenericSQLException(sError,*this);
327 : }
328 : // setObject (parameterIndex, x, sqlType, 0);
329 0 : }
330 :
331 :
332 0 : void SAL_CALL OPreparedStatement::setShort( sal_Int32 parameterIndex, sal_Int16 x ) throw(SQLException, RuntimeException, std::exception)
333 : {
334 0 : setParameter(parameterIndex,x);
335 0 : }
336 :
337 :
338 0 : void SAL_CALL OPreparedStatement::setBytes( sal_Int32 parameterIndex, const Sequence< sal_Int8 >& x ) throw(SQLException, RuntimeException, std::exception)
339 : {
340 0 : setParameter(parameterIndex,x);
341 0 : }
342 :
343 :
344 :
345 0 : void SAL_CALL OPreparedStatement::setCharacterStream( sal_Int32 parameterIndex, const Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw(SQLException, RuntimeException, std::exception)
346 : {
347 0 : setBinaryStream(parameterIndex,x,length );
348 0 : }
349 :
350 :
351 0 : void SAL_CALL OPreparedStatement::setBinaryStream( sal_Int32 parameterIndex, const Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw(SQLException, RuntimeException, std::exception)
352 : {
353 0 : if(!x.is())
354 0 : ::dbtools::throwFunctionSequenceException(*this);
355 :
356 0 : Sequence<sal_Int8> aSeq;
357 0 : x->readBytes(aSeq,length);
358 0 : setParameter(parameterIndex,aSeq);
359 0 : }
360 :
361 :
362 0 : void SAL_CALL OPreparedStatement::clearParameters( ) throw(SQLException, RuntimeException, std::exception)
363 : {
364 0 : ::osl::MutexGuard aGuard( m_aMutex );
365 0 : checkDisposed(OStatement_BASE::rBHelper.bDisposed);
366 :
367 0 : m_aParameterRow->get().clear();
368 0 : m_aParameterRow->get().push_back(new ORowSetValueDecorator(sal_Int32(0)) );
369 0 : }
370 :
371 0 : OResultSet* OPreparedStatement::createResultSet()
372 : {
373 0 : return new OResultSet(this,m_aSQLIterator);
374 : }
375 :
376 29 : void OPreparedStatement::initResultSet(OResultSet *pResultSet)
377 : {
378 : // check if we got enough parameters
379 58 : if ( (m_aParameterRow.is() && ( m_aParameterRow->get().size() -1 ) < m_xParamColumns->get().size()) ||
380 58 : (m_xParamColumns.is() && !m_aParameterRow.is() && !m_aParameterRow->get().empty()) )
381 0 : m_pConnection->throwGenericSQLException(STR_INVALID_PARA_COUNT,*this);
382 :
383 29 : pResultSet->OpenImpl();
384 29 : pResultSet->setMetaData(getMetaData());
385 29 : }
386 :
387 1645 : void SAL_CALL OPreparedStatement::acquire() throw()
388 : {
389 1645 : OStatement_BASE2::acquire();
390 1645 : }
391 :
392 1645 : void SAL_CALL OPreparedStatement::release() throw()
393 : {
394 1645 : OStatement_BASE2::release();
395 1645 : }
396 :
397 5 : void OPreparedStatement::checkAndResizeParameters(sal_Int32 parameterIndex)
398 : {
399 5 : ::connectivity::checkDisposed(OStatement_BASE::rBHelper.bDisposed);
400 5 : if ( m_aAssignValues.is() && (parameterIndex < 1 || parameterIndex >= static_cast<sal_Int32>(m_aParameterIndexes.size())) )
401 0 : throwInvalidIndexException(*this);
402 5 : else if ( static_cast<sal_Int32>((m_aParameterRow->get()).size()) <= parameterIndex )
403 : {
404 0 : sal_Int32 i = m_aParameterRow->get().size();
405 0 : (m_aParameterRow->get()).resize(parameterIndex+1);
406 0 : for ( ; i <= parameterIndex; ++i)
407 : {
408 0 : if ( !(m_aParameterRow->get())[i].is() )
409 0 : (m_aParameterRow->get())[i] = new ORowSetValueDecorator;
410 : }
411 : }
412 5 : }
413 :
414 5 : void OPreparedStatement::setParameter(sal_Int32 parameterIndex, const ORowSetValue& x)
415 : {
416 5 : ::osl::MutexGuard aGuard( m_aMutex );
417 5 : checkAndResizeParameters(parameterIndex);
418 :
419 5 : if(m_aAssignValues.is())
420 0 : *(m_aAssignValues->get())[m_aParameterIndexes[parameterIndex]] = x;
421 : else
422 5 : *((m_aParameterRow->get())[parameterIndex]) = x;
423 5 : }
424 :
425 0 : sal_uInt32 OPreparedStatement::AddParameter(OSQLParseNode * pParameter, const Reference<XPropertySet>& _xCol)
426 : {
427 : OSL_UNUSED( pParameter );
428 : OSL_ENSURE(SQL_ISRULE(pParameter,parameter),"OResultSet::AddParameter: Argument ist kein Parameter");
429 : OSL_ENSURE(pParameter->count() > 0,"OResultSet: Fehler im Parse Tree");
430 : #if OSL_DEBUG_LEVEL > 0
431 : OSQLParseNode * pMark = pParameter->getChild(0);
432 : OSL_UNUSED( pMark );
433 : #endif
434 :
435 0 : OUString sParameterName;
436 : // set up Parameter-Column:
437 0 : sal_Int32 eType = DataType::VARCHAR;
438 0 : sal_uInt32 nPrecision = 255;
439 0 : sal_Int32 nScale = 0;
440 0 : sal_Int32 nNullable = ColumnValue::NULLABLE;
441 :
442 0 : if (_xCol.is())
443 : {
444 : // Use type, precision, scale ... from the given column,
445 : // because this Column will get a value assigned or
446 : // with this Column the value will be compared.
447 0 : _xCol->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE)) >>= eType;
448 0 : _xCol->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION)) >>= nPrecision;
449 0 : _xCol->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE)) >>= nScale;
450 0 : _xCol->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE)) >>= nNullable;
451 0 : _xCol->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME)) >>= sParameterName;
452 : }
453 :
454 : Reference<XPropertySet> xParaColumn = new connectivity::parse::OParseColumn(sParameterName
455 : ,OUString()
456 : ,OUString()
457 : ,OUString()
458 : ,nNullable
459 : ,nPrecision
460 : ,nScale
461 : ,eType
462 : ,false
463 : ,false
464 0 : ,m_aSQLIterator.isCaseSensitive()
465 : ,OUString()
466 : ,OUString()
467 0 : ,OUString());
468 0 : m_xParamColumns->get().push_back(xParaColumn);
469 0 : return m_xParamColumns->get().size();
470 : }
471 :
472 0 : void OPreparedStatement::describeColumn(OSQLParseNode* _pParameter,OSQLParseNode* _pNode,const OSQLTable& _xTable)
473 : {
474 0 : Reference<XPropertySet> xProp;
475 0 : if(SQL_ISRULE(_pNode,column_ref))
476 : {
477 0 : OUString sColumnName,sTableRange;
478 0 : m_aSQLIterator.getColumnRange(_pNode,sColumnName,sTableRange);
479 0 : if ( !sColumnName.isEmpty() )
480 : {
481 0 : Reference<XNameAccess> xNameAccess = _xTable->getColumns();
482 0 : if(xNameAccess->hasByName(sColumnName))
483 0 : xNameAccess->getByName(sColumnName) >>= xProp;
484 0 : AddParameter(_pParameter,xProp);
485 0 : }
486 0 : }
487 : // else
488 : // AddParameter(_pParameter,xProp);
489 0 : }
490 :
491 0 : void OPreparedStatement::describeParameter()
492 : {
493 0 : ::std::vector< OSQLParseNode*> aParseNodes;
494 0 : scanParameter(m_pParseTree,aParseNodes);
495 0 : if ( !aParseNodes.empty() )
496 : {
497 : // m_xParamColumns = new OSQLColumns();
498 0 : const OSQLTables& xTabs = m_aSQLIterator.getTables();
499 0 : if( !xTabs.empty() )
500 : {
501 0 : OSQLTable xTable = xTabs.begin()->second;
502 0 : ::std::vector< OSQLParseNode*>::const_iterator aIter = aParseNodes.begin();
503 0 : for (;aIter != aParseNodes.end();++aIter )
504 : {
505 0 : describeColumn(*aIter,(*aIter)->getParent()->getChild(0),xTable);
506 0 : }
507 : }
508 0 : }
509 0 : }
510 29 : void OPreparedStatement::initializeResultSet(OResultSet* pRS)
511 : {
512 29 : OStatement_Base::initializeResultSet(pRS);
513 :
514 29 : pRS->setParameterColumns(m_xParamColumns);
515 29 : pRS->setParameterRow(m_aParameterRow);
516 :
517 : // Substitute parameter (AssignValues and criteria):
518 29 : if (!m_xParamColumns->get().empty())
519 : {
520 : // begin with AssignValues
521 6 : sal_uInt16 nParaCount=0; // gives the current number of previously set Parameters
522 :
523 : // search for parameters to be substituted:
524 6 : size_t nCount = m_aAssignValues.is() ? m_aAssignValues->get().size() : 1; // 1 is important for the Criteria
525 6 : for (size_t j = 1; j < nCount; j++)
526 : {
527 0 : sal_uInt32 nParameter = (*m_aAssignValues).getParameterIndex(j);
528 0 : if (nParameter == SQL_NO_PARAMETER)
529 0 : continue; // this AssignValue is no Parameter
530 :
531 0 : ++nParaCount; // now the Parameter is valid
532 : }
533 :
534 6 : if (m_aParameterRow.is() && (m_xParamColumns->get().size()+1) != m_aParameterRow->get().size() )
535 : {
536 0 : sal_Int32 i = m_aParameterRow->get().size();
537 0 : sal_Int32 nParamColumns = m_xParamColumns->get().size()+1;
538 0 : m_aParameterRow->get().resize(nParamColumns);
539 0 : for ( ;i < nParamColumns; ++i )
540 : {
541 0 : if ( !(m_aParameterRow->get())[i].is() )
542 0 : (m_aParameterRow->get())[i] = new ORowSetValueDecorator;
543 : }
544 : }
545 6 : if (m_aParameterRow.is() && nParaCount < m_aParameterRow->get().size() )
546 6 : m_pSQLAnalyzer->bindParameterRow(m_aParameterRow);
547 : }
548 29 : }
549 :
550 0 : void OPreparedStatement::parseParamterElem(const OUString& _sColumnName, OSQLParseNode* pRow_Value_Constructor_Elem)
551 : {
552 0 : Reference<XPropertySet> xCol;
553 0 : m_xColNames->getByName(_sColumnName) >>= xCol;
554 0 : sal_Int32 nParameter = -1;
555 0 : if(m_xParamColumns.is())
556 : {
557 0 : OSQLColumns::Vector::const_iterator aIter = find(m_xParamColumns->get().begin(),m_xParamColumns->get().end(),_sColumnName,::comphelper::UStringMixEqual(m_pTable->isCaseSensitive()));
558 0 : if(aIter != m_xParamColumns->get().end())
559 0 : nParameter = m_xParamColumns->get().size() - (m_xParamColumns->get().end() - aIter) + 1;// +1 because the rows start at 1
560 : }
561 0 : if(nParameter == -1)
562 0 : nParameter = AddParameter(pRow_Value_Constructor_Elem,xCol);
563 : // Save number of parameter in the variable:
564 0 : SetAssignValue(_sColumnName, OUString(), true, nParameter);
565 0 : }
566 :
567 :
568 :
569 : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
