connectivity/source/drivers/file/FStatement.cxx

   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 <osl/diagnose.h>
  21 #include "file/FStatement.hxx"
  22 #include "file/FConnection.hxx"
  23 #include "sqlbison.hxx"
  24 #include "file/FDriver.hxx"
  25 #include "file/FResultSet.hxx"
  26 #include <comphelper/property.hxx>
  27 #include <comphelper/uno3.hxx>
  28 #include <osl/thread.h>
  29 #include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
  30 #include <com/sun/star/sdbc/ResultSetType.hpp>
  31 #include <com/sun/star/sdbc/FetchDirection.hpp>
  32 #include <com/sun/star/lang/DisposedException.hpp>
  33 #include <comphelper/processfactory.hxx>
  34 #include <comphelper/sequence.hxx>
  35 #include <cppuhelper/typeprovider.hxx>
  36 #include <connectivity/dbexception.hxx>
  37 #include "resource/file_res.hrc"
  38 #include <algorithm>
  39
  40 namespace connectivity
  41 {
  42     namespace file
  43     {
  44
  45
  46 using namespace dbtools;
  47 using namespace com::sun::star::uno;
  48 using namespace com::sun::star::lang;
  49 using namespace com::sun::star::beans;
  50 using namespace com::sun::star::sdbc;
  51 using namespace com::sun::star::sdbcx;
  52 using namespace com::sun::star::container;
  53
  54 OStatement_Base::OStatement_Base(OConnection* _pConnection )
  55     :OStatement_BASE(m_aMutex)
  56     ,::comphelper::OPropertyContainer(OStatement_BASE::rBHelper)
  57     ,m_xDBMetaData(_pConnection->getMetaData())
  58     ,m_aParser( _pConnection->getDriver()->getComponentContext() )
  59     ,m_aSQLIterator( _pConnection, _pConnection->createCatalog()->getTables(), m_aParser )
  60     ,m_pConnection(_pConnection)
  61     ,m_pParseTree(nullptr)
  62     ,m_pSQLAnalyzer(nullptr)
  63     ,m_nMaxFieldSize(0)
  64     ,m_nMaxRows(0)
  65     ,m_nQueryTimeOut(0)
  66     ,m_nFetchSize(0)
  67     ,m_nResultSetType(ResultSetType::FORWARD_ONLY)
  68     ,m_nFetchDirection(FetchDirection::FORWARD)
  69     ,m_nResultSetConcurrency(ResultSetConcurrency::UPDATABLE)
  70     ,m_bEscapeProcessing(true)
  71 {
  72     sal_Int32 nAttrib = 0;
  73
  74     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_CURSORNAME),      PROPERTY_ID_CURSORNAME,         nAttrib,&m_aCursorName,     ::cppu::UnoType<OUString>::get());
  75     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_MAXFIELDSIZE),    PROPERTY_ID_MAXFIELDSIZE,       nAttrib,&m_nMaxFieldSize,       ::cppu::UnoType<sal_Int32>::get());
  76     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_MAXROWS),         PROPERTY_ID_MAXROWS,            nAttrib,&m_nMaxRows,        ::cppu::UnoType<sal_Int32>::get());
  77     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_QUERYTIMEOUT),    PROPERTY_ID_QUERYTIMEOUT,       nAttrib,&m_nQueryTimeOut,   ::cppu::UnoType<sal_Int32>::get());
  78     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FETCHSIZE),       PROPERTY_ID_FETCHSIZE,          nAttrib,&m_nFetchSize,      ::cppu::UnoType<sal_Int32>::get());
  79     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_RESULTSETTYPE),   PROPERTY_ID_RESULTSETTYPE,      nAttrib,&m_nResultSetType,  ::cppu::UnoType<sal_Int32>::get());
  80     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FETCHDIRECTION),  PROPERTY_ID_FETCHDIRECTION,     nAttrib,&m_nFetchDirection, ::cppu::UnoType<sal_Int32>::get());
  81     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ESCAPEPROCESSING),PROPERTY_ID_ESCAPEPROCESSING,   nAttrib,&m_bEscapeProcessing,cppu::UnoType<bool>::get());
  82
  83     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_RESULTSETCONCURRENCY),        PROPERTY_ID_RESULTSETCONCURRENCY,   nAttrib,&m_nResultSetConcurrency,       ::cppu::UnoType<sal_Int32>::get());
  84 }
  85
  86 OStatement_Base::~OStatement_Base()
  87 {
  88     osl_atomic_increment( &m_refCount );
  89     disposing();
  90     delete m_pSQLAnalyzer;
  91 }
  92
  93 void OStatement_Base::disposeResultSet()
  94 {
  95     SAL_INFO( "connectivity.drivers", "file Ocke.Janssen@sun.com OStatement_Base::disposeResultSet" );
  96     // free the cursor if alive
  97     Reference< XComponent > xComp(m_xResultSet.get(), UNO_QUERY);
  98     assert(xComp.is() || !m_xResultSet.get().is());
  99     if (xComp.is())
 100         xComp->dispose();
 101     m_xResultSet.clear();
 102 }
 103
 104 void OStatement_BASE2::disposing()
 105 {
 106     ::osl::MutexGuard aGuard(m_aMutex);
 107
 108     disposeResultSet();
 109
 110     if(m_pSQLAnalyzer)
 111         m_pSQLAnalyzer->dispose();
 112
 113     if(m_aRow.is())
 114     {
 115         m_aRow->get().clear();
 116         m_aRow = nullptr;
 117     }
 118
 119     m_aSQLIterator.dispose();
 120
 121     m_pTable.clear();
 122
 123     m_pConnection.clear();
 124
 125     dispose_ChildImpl();
 126
 127     if ( m_pParseTree )
 128     {
 129         delete m_pParseTree;
 130         m_pParseTree = nullptr;
 131     }
 132
 133     OStatement_Base::disposing();
 134 }
 135
 136 void SAL_CALL OStatement_Base::acquire() throw()
 137 {
 138     OStatement_BASE::acquire();
 139 }
 140
 141 void SAL_CALL OStatement_BASE2::release() throw()
 142 {
 143     release_ChildImpl();
 144 }
 145
 146 Any SAL_CALL OStatement_Base::queryInterface( const Type & rType ) throw(RuntimeException, std::exception)
 147 {
 148     const Any aRet = OStatement_BASE::queryInterface(rType);
 149     return aRet.hasValue() ? aRet : OPropertySetHelper::queryInterface(rType);
 150 }
 151
 152 Sequence< Type > SAL_CALL OStatement_Base::getTypes(  ) throw(RuntimeException, std::exception)
 153 {
 154     ::cppu::OTypeCollection aTypes( cppu::UnoType<css::beans::XMultiPropertySet>::get(),
 155                                     cppu::UnoType<css::beans::XFastPropertySet>::get(),
 156                                     cppu::UnoType<css::beans::XPropertySet>::get());
 157
 158     return ::comphelper::concatSequences(aTypes.getTypes(),OStatement_BASE::getTypes());
 159 }
 160
 161
 162 void SAL_CALL OStatement_Base::cancel(  ) throw(RuntimeException, std::exception)
 163 {
 164 }
 165
 166 void SAL_CALL OStatement_Base::close() throw (SQLException, RuntimeException, std::exception)
 167 {
 168     {
 169         ::osl::MutexGuard aGuard( m_aMutex );
 170         checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 171     }
 172     dispose();
 173 }
 174
 175 void OStatement_Base::closeResultSet() throw (SQLException, RuntimeException, std::exception)
 176 {
 177     SAL_INFO( "connectivity.drivers", "file Ocke.Janssen@sun.com OStatement_Base::clearMyResultSet " );
 178     ::osl::MutexGuard aGuard( m_aMutex );
 179     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 180
 181     Reference< XCloseable > xCloseable(m_xResultSet.get(), UNO_QUERY);
 182     assert(xCloseable.is() || !m_xResultSet.get().is());
 183     if (xCloseable.is())
 184     {
 185         try
 186         {
 187             xCloseable->close();
 188         }
 189         catch( const DisposedException& ) { }
 190     }
 191
 192     m_xResultSet.clear();
 193 }
 194
 195 Any SAL_CALL OStatement_Base::getWarnings(  ) throw(SQLException, RuntimeException, std::exception)
 196 {
 197     ::osl::MutexGuard aGuard( m_aMutex );
 198     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 199
 200     return makeAny(m_aLastWarning);
 201 }
 202
 203 void SAL_CALL OStatement_Base::clearWarnings(  ) throw(SQLException, RuntimeException, std::exception)
 204 {
 205     ::osl::MutexGuard aGuard( m_aMutex );
 206     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 207
 208     m_aLastWarning = SQLWarning();
 209 }
 210
 211 ::cppu::IPropertyArrayHelper* OStatement_Base::createArrayHelper( ) const
 212 {
 213     Sequence< Property > aProps;
 214     describeProperties(aProps);
 215     return new ::cppu::OPropertyArrayHelper(aProps);
 216 }
 217
 218
 219 ::cppu::IPropertyArrayHelper & OStatement_Base::getInfoHelper()
 220 {
 221     return *getArrayHelper();
 222 }
 223
 224 OResultSet* OStatement::createResultSet()
 225 {
 226     return new OResultSet(this,m_aSQLIterator);
 227 }
 228
 229 IMPLEMENT_SERVICE_INFO(OStatement,"com.sun.star.sdbc.driver.file.Statement","com.sun.star.sdbc.Statement");
 230
 231 void SAL_CALL OStatement::acquire() throw()
 232 {
 233     OStatement_BASE2::acquire();
 234 }
 235
 236 void SAL_CALL OStatement::release() throw()
 237 {
 238     OStatement_BASE2::release();
 239 }
 240
 241
 242 sal_Bool SAL_CALL OStatement::execute( const OUString& sql ) throw(SQLException, RuntimeException, std::exception)
 243 {
 244     ::osl::MutexGuard aGuard( m_aMutex );
 245
 246     executeQuery(sql);
 247
 248     return m_aSQLIterator.getStatementType() == OSQLStatementType::Select;
 249 }
 250
 251
 252 Reference< XResultSet > SAL_CALL OStatement::executeQuery( const OUString& sql ) throw(SQLException, RuntimeException, std::exception)
 253 {
 254     ::osl::MutexGuard aGuard( m_aMutex );
 255     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 256
 257     construct(sql);
 258     Reference< XResultSet > xRS;
 259     OResultSet* pResult = createResultSet();
 260     xRS = pResult;
 261     initializeResultSet(pResult);
 262     m_xResultSet = xRS;
 263
 264     pResult->OpenImpl();
 265
 266     return xRS;
 267 }
 268
 269 Reference< XConnection > SAL_CALL OStatement::getConnection(  ) throw(SQLException, RuntimeException, std::exception)
 270 {
 271     return Reference< XConnection >(m_pConnection.get());
 272 }
 273
 274 sal_Int32 SAL_CALL OStatement::executeUpdate( const OUString& sql ) throw(SQLException, RuntimeException, std::exception)
 275 {
 276     ::osl::MutexGuard aGuard( m_aMutex );
 277     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 278
 279
 280     construct(sql);
 281     OResultSet* pResult = createResultSet();
 282     Reference< XResultSet > xRS = pResult;
 283     initializeResultSet(pResult);
 284     pResult->OpenImpl();
 285
 286     return pResult->getRowCountResult();
 287 }
 288
 289
 290 void SAL_CALL OStatement_Base::disposing()
 291 {
 292     if(m_aEvaluateRow.is())
 293     {
 294         m_aEvaluateRow->get().clear();
 295         m_aEvaluateRow = nullptr;
 296     }
 297     OStatement_BASE::disposing();
 298 }
 299
 300 Reference< css::beans::XPropertySetInfo > SAL_CALL OStatement_Base::getPropertySetInfo(  ) throw(RuntimeException, std::exception)
 301 {
 302     return ::cppu::OPropertySetHelper::createPropertySetInfo(getInfoHelper());
 303 }
 304
 305 Any SAL_CALL OStatement::queryInterface( const Type & rType ) throw(RuntimeException, std::exception)
 306 {
 307     Any aRet = OStatement_XStatement::queryInterface( rType);
 308     return aRet.hasValue() ? aRet : OStatement_BASE2::queryInterface( rType);
 309 }
 310
 311 void OStatement_Base::anylizeSQL()
 312 {
 313     OSL_ENSURE(m_pSQLAnalyzer,"OResultSet::anylizeSQL: Analyzer isn't set!");
 314     // start analysing the statement
 315     m_pSQLAnalyzer->setOrigColumns(m_xColNames);
 316     m_pSQLAnalyzer->start(m_pParseTree);
 317
 318     const OSQLParseNode* pOrderbyClause = m_aSQLIterator.getOrderTree();
 319     if(pOrderbyClause)
 320     {
 321         OSQLParseNode * pOrderingSpecCommalist = pOrderbyClause->getChild(2);
 322         OSL_ENSURE(SQL_ISRULE(pOrderingSpecCommalist,ordering_spec_commalist),"OResultSet: Fehler im Parse Tree");
 323
 324         for (size_t m = 0; m < pOrderingSpecCommalist->count(); m++)
 325         {
 326             OSQLParseNode * pOrderingSpec = pOrderingSpecCommalist->getChild(m);
 327             OSL_ENSURE(SQL_ISRULE(pOrderingSpec,ordering_spec),"OResultSet: Fehler im Parse Tree");
 328             OSL_ENSURE(pOrderingSpec->count() == 2,"OResultSet: Fehler im Parse Tree");
 329
 330             OSQLParseNode * pColumnRef = pOrderingSpec->getChild(0);
 331             if(!SQL_ISRULE(pColumnRef,column_ref))
 332             {
 333                 throw SQLException();
 334             }
 335             OSQLParseNode * pAscendingDescending = pOrderingSpec->getChild(1);
 336             setOrderbyColumn(pColumnRef,pAscendingDescending);
 337         }
 338     }
 339 }
 340
 341 void OStatement_Base::setOrderbyColumn( OSQLParseNode* pColumnRef,
 342                                         OSQLParseNode* pAscendingDescending)
 343 {
 344     OUString aColumnName;
 345     if (pColumnRef->count() == 1)
 346         aColumnName = pColumnRef->getChild(0)->getTokenValue();
 347     else if (pColumnRef->count() == 3)
 348     {
 349         pColumnRef->getChild(2)->parseNodeToStr( aColumnName, getOwnConnection(), nullptr, false, false );
 350     }
 351     else
 352     {
 353         throw SQLException();
 354     }
 355
 356     Reference<XColumnLocate> xColLocate(m_xColNames,UNO_QUERY);
 357     if(!xColLocate.is())
 358         return;
 359     // Everything tested and we have the name of the Column.
 360     // What number is the Column?
 361     ::rtl::Reference<OSQLColumns> aSelectColumns = m_aSQLIterator.getSelectColumns();
 362     ::comphelper::UStringMixEqual aCase;
 363     OSQLColumns::Vector::const_iterator aFind = ::connectivity::find(aSelectColumns->get().begin(),aSelectColumns->get().end(),aColumnName,aCase);
 364     if ( aFind == aSelectColumns->get().end() )
 365         throw SQLException();
 366     m_aOrderbyColumnNumber.push_back((aFind - aSelectColumns->get().begin()) + 1);
 367
 368     // Ascending or Descending?
 369     m_aOrderbyAscending.push_back((SQL_ISTOKEN(pAscendingDescending,DESC)) ? TAscendingOrder::DESC : TAscendingOrder::ASC);
 370 }
 371
 372 void OStatement_Base::construct(const OUString& sql)  throw(SQLException, RuntimeException, std::exception)
 373 {
 374     OUString aErr;
 375     m_pParseTree = m_aParser.parseTree(aErr,sql);
 376     if(m_pParseTree)
 377     {
 378         m_aSQLIterator.setParseTree(m_pParseTree);
 379         m_aSQLIterator.traverseAll();
 380         const OSQLTables& rTabs = m_aSQLIterator.getTables();
 381
 382         // sanity checks
 383         if ( rTabs.empty() )
 384             // no tables -> nothing to operate on -> error
 385             m_pConnection->throwGenericSQLException(STR_QUERY_NO_TABLE,*this);
 386
 387         if ( rTabs.size() > 1 || m_aSQLIterator.hasErrors() )
 388             // more than one table -> can't operate on them -> error
 389             m_pConnection->throwGenericSQLException(STR_QUERY_MORE_TABLES,*this);
 390
 391         if ( (m_aSQLIterator.getStatementType() == OSQLStatementType::Select) && m_aSQLIterator.getSelectColumns()->get().empty() )
 392             // SELECT statement without columns -> error
 393             m_pConnection->throwGenericSQLException(STR_QUERY_NO_COLUMN,*this);
 394
 395         switch(m_aSQLIterator.getStatementType())
 396         {
 397             case OSQLStatementType::CreateTable:
 398             case OSQLStatementType::OdbcCall:
 399             case OSQLStatementType::Unknown:
 400                 m_pConnection->throwGenericSQLException(STR_QUERY_TOO_COMPLEX,*this);
 401                 break;
 402             default:
 403                 break;
 404         }
 405
 406         // at this moment we support only one table per select statement
 407         Reference< css::lang::XUnoTunnel> xTunnel(rTabs.begin()->second,UNO_QUERY);
 408         if(xTunnel.is())
 409         {
 410             m_pTable = reinterpret_cast<OFileTable*>(xTunnel->getSomething(OFileTable::getUnoTunnelImplementationId()));
 411         }
 412         OSL_ENSURE(m_pTable.is(),"No table!");
 413         if ( m_pTable.is() )
 414             m_xColNames     = m_pTable->getColumns();
 415         Reference<XIndexAccess> xNames(m_xColNames,UNO_QUERY);
 416         // set the binding of the resultrow
 417         m_aRow          = new OValueRefVector(xNames->getCount());
 418         (m_aRow->get())[0]->setBound(true);
 419         ::std::for_each(m_aRow->get().begin()+1,m_aRow->get().end(),TSetRefBound(false));
 420
 421         // set the binding of the resultrow
 422         m_aEvaluateRow  = new OValueRefVector(xNames->getCount());
 423
 424         (m_aEvaluateRow->get())[0]->setBound(true);
 425         ::std::for_each(m_aEvaluateRow->get().begin()+1,m_aEvaluateRow->get().end(),TSetRefBound(false));
 426
 427         // set the select row
 428         m_aSelectRow = new OValueRefVector(m_aSQLIterator.getSelectColumns()->get().size());
 429         ::std::for_each(m_aSelectRow->get().begin(),m_aSelectRow->get().end(),TSetRefBound(true));
 430
 431         // create the column mapping
 432         createColumnMapping();
 433
 434         m_pSQLAnalyzer = new OSQLAnalyzer(m_pConnection.get());
 435
 436         Reference<XIndexesSupplier> xIndexSup(xTunnel,UNO_QUERY);
 437         if(xIndexSup.is())
 438             m_pSQLAnalyzer->setIndexes(xIndexSup->getIndexes());
 439
 440         anylizeSQL();
 441     }
 442     else
 443         throw SQLException(aErr,*this,OUString(),0,Any());
 444 }
 445
 446 void OStatement_Base::createColumnMapping()
 447 {
 448     // initialize the column index map (mapping select columns to table columns)
 449     ::rtl::Reference<connectivity::OSQLColumns> xColumns = m_aSQLIterator.getSelectColumns();
 450     m_aColMapping.resize(xColumns->get().size() + 1);
 451     for (sal_Int32 i=0; i<(sal_Int32)m_aColMapping.size(); ++i)
 452         m_aColMapping[i] = i;
 453
 454     Reference<XIndexAccess> xNames(m_xColNames,UNO_QUERY);
 455     // now check which columns are bound
 456     OResultSet::setBoundedColumns(m_aRow,m_aSelectRow,xColumns,xNames,true,m_xDBMetaData,m_aColMapping);
 457 }
 458
 459 void OStatement_Base::initializeResultSet(OResultSet* _pResult)
 460 {
 461     GetAssignValues();
 462
 463     _pResult->setSqlAnalyzer(m_pSQLAnalyzer);
 464     _pResult->setOrderByColumns(m_aOrderbyColumnNumber);
 465     _pResult->setOrderByAscending(m_aOrderbyAscending);
 466     _pResult->setBindingRow(m_aRow);
 467     _pResult->setColumnMapping(m_aColMapping);
 468     _pResult->setEvaluationRow(m_aEvaluateRow);
 469     _pResult->setAssignValues(m_aAssignValues);
 470     _pResult->setSelectRow(m_aSelectRow);
 471
 472     m_pSQLAnalyzer->bindSelectRow(m_aRow);
 473     m_pSQLAnalyzer->bindEvaluationRow(m_aEvaluateRow);    // Set values in the code of the Compiler
 474 }
 475
 476 void OStatement_Base::GetAssignValues()
 477 {
 478     if (m_pParseTree == nullptr)
 479     {
 480         ::dbtools::throwFunctionSequenceException(*this);
 481         return;
 482     }
 483
 484     if (SQL_ISRULE(m_pParseTree,select_statement))
 485         // no values have to be set for SELECT
 486         return;
 487     else if (SQL_ISRULE(m_pParseTree,insert_statement))
 488     {
 489         // Create Row for the values to be set (Reference through new)
 490         if(m_aAssignValues.is())
 491             m_aAssignValues->get().clear();
 492         sal_Int32 nCount = Reference<XIndexAccess>(m_xColNames,UNO_QUERY)->getCount();
 493         m_aAssignValues = new OAssignValues(nCount);
 494         // unbound all
 495         ::std::for_each(m_aAssignValues->get().begin()+1,m_aAssignValues->get().end(),TSetRefBound(false));
 496
 497         m_aParameterIndexes.resize(nCount+1,SQL_NO_PARAMETER);
 498
 499         // List of Column-Names, that exist in the column_commalist (separated by ;):
 500         ::std::vector<OUString> aColumnNameList;
 501
 502         OSL_ENSURE(m_pParseTree->count() >= 4,"OResultSet: Fehler im Parse Tree");
 503
 504         OSQLParseNode * pOptColumnCommalist = m_pParseTree->getChild(3);
 505         OSL_ENSURE(pOptColumnCommalist != nullptr,"OResultSet: Fehler im Parse Tree");
 506         OSL_ENSURE(SQL_ISRULE(pOptColumnCommalist,opt_column_commalist),"OResultSet: Fehler im Parse Tree");
 507         if (pOptColumnCommalist->count() == 0)
 508         {
 509             const Sequence< OUString>& aNames = m_xColNames->getElementNames();
 510             const OUString* pBegin = aNames.getConstArray();
 511             const OUString* pEnd = pBegin + aNames.getLength();
 512             for (; pBegin != pEnd; ++pBegin)
 513                 aColumnNameList.push_back(*pBegin);
 514         }
 515         else
 516         {
 517             OSL_ENSURE(pOptColumnCommalist->count() == 3,"OResultSet: Fehler im Parse Tree");
 518
 519             OSQLParseNode * pColumnCommalist = pOptColumnCommalist->getChild(1);
 520             OSL_ENSURE(pColumnCommalist != nullptr,"OResultSet: Fehler im Parse Tree");
 521             OSL_ENSURE(SQL_ISRULE(pColumnCommalist,column_commalist),"OResultSet: Fehler im Parse Tree");
 522             OSL_ENSURE(pColumnCommalist->count() > 0,"OResultSet: Fehler im Parse Tree");
 523
 524             // All Columns in the column_commalist ...
 525             for (size_t i = 0; i < pColumnCommalist->count(); i++)
 526             {
 527                 OSQLParseNode * pCol = pColumnCommalist->getChild(i);
 528                 OSL_ENSURE(pCol != nullptr,"OResultSet: Fehler im Parse Tree");
 529                 aColumnNameList.push_back(pCol->getTokenValue());
 530             }
 531         }
 532         if ( aColumnNameList.empty() )
 533             throwFunctionSequenceException(*this);
 534
 535         // Values ...
 536         OSQLParseNode * pValuesOrQuerySpec = m_pParseTree->getChild(4);
 537         OSL_ENSURE(pValuesOrQuerySpec != nullptr,"OResultSet: pValuesOrQuerySpec darf nicht NULL sein!");
 538         OSL_ENSURE(SQL_ISRULE(pValuesOrQuerySpec,values_or_query_spec),"OResultSet: ! SQL_ISRULE(pValuesOrQuerySpec,values_or_query_spec)");
 539         OSL_ENSURE(pValuesOrQuerySpec->count() > 0,"OResultSet: pValuesOrQuerySpec->count() <= 0");
 540
 541         // just "VALUES" is allowed ...
 542         if (! SQL_ISTOKEN(pValuesOrQuerySpec->getChild(0),VALUES))
 543             throwFunctionSequenceException(*this);
 544
 545         OSL_ENSURE(pValuesOrQuerySpec->count() == 4,"OResultSet: pValuesOrQuerySpec->count() != 4");
 546
 547         // List of values
 548         OSQLParseNode * pInsertAtomCommalist = pValuesOrQuerySpec->getChild(2);
 549         OSL_ENSURE(pInsertAtomCommalist != nullptr,"OResultSet: pInsertAtomCommalist darf nicht NULL sein!");
 550         OSL_ENSURE(pInsertAtomCommalist->count() > 0,"OResultSet: pInsertAtomCommalist <= 0");
 551
 552         sal_Int32 nIndex=0;
 553         for (size_t i = 0; i < pInsertAtomCommalist->count(); i++)
 554         {
 555             OSQLParseNode * pRow_Value_Const = pInsertAtomCommalist->getChild(i); // row_value_constructor
 556             OSL_ENSURE(pRow_Value_Const != nullptr,"OResultSet: pRow_Value_Const darf nicht NULL sein!");
 557             if(SQL_ISRULE(pRow_Value_Const,parameter))
 558             {
 559                 ParseAssignValues(aColumnNameList,pRow_Value_Const,nIndex++); // only one Columnname allowed per loop
 560             }
 561             else if(pRow_Value_Const->isToken())
 562                 ParseAssignValues(aColumnNameList,pRow_Value_Const,i);
 563             else
 564             {
 565                 if(pRow_Value_Const->count() == aColumnNameList.size())
 566                 {
 567                     for (size_t j = 0; j < pRow_Value_Const->count(); ++j)
 568                         ParseAssignValues(aColumnNameList,pRow_Value_Const->getChild(j),nIndex++);
 569                 }
 570                 else
 571                     throwFunctionSequenceException(*this);
 572             }
 573         }
 574     }
 575     else if (SQL_ISRULE(m_pParseTree,update_statement_searched))
 576     {
 577         if(m_aAssignValues.is())
 578             m_aAssignValues->get().clear();
 579         sal_Int32 nCount = Reference<XIndexAccess>(m_xColNames,UNO_QUERY)->getCount();
 580         m_aAssignValues = new OAssignValues(nCount);
 581         // unbound all
 582         ::std::for_each(m_aAssignValues->get().begin()+1,m_aAssignValues->get().end(),TSetRefBound(false));
 583
 584         m_aParameterIndexes.resize(nCount+1,SQL_NO_PARAMETER);
 585
 586         OSL_ENSURE(m_pParseTree->count() >= 4,"OResultSet: Fehler im Parse Tree");
 587
 588         OSQLParseNode * pAssignmentCommalist = m_pParseTree->getChild(3);
 589         OSL_ENSURE(pAssignmentCommalist != nullptr,"OResultSet: pAssignmentCommalist == NULL");
 590         OSL_ENSURE(SQL_ISRULE(pAssignmentCommalist,assignment_commalist),"OResultSet: Fehler im Parse Tree");
 591         OSL_ENSURE(pAssignmentCommalist->count() > 0,"OResultSet: pAssignmentCommalist->count() <= 0");
 592
 593         // work on all assignments (commalist) ...
 594         ::std::vector< OUString> aList(1);
 595         for (size_t i = 0; i < pAssignmentCommalist->count(); i++)
 596         {
 597             OSQLParseNode * pAssignment = pAssignmentCommalist->getChild(i);
 598             OSL_ENSURE(pAssignment != nullptr,"OResultSet: pAssignment == NULL");
 599             OSL_ENSURE(SQL_ISRULE(pAssignment,assignment),"OResultSet: Fehler im Parse Tree");
 600             OSL_ENSURE(pAssignment->count() == 3,"OResultSet: pAssignment->count() != 3");
 601
 602             OSQLParseNode * pCol = pAssignment->getChild(0);
 603             OSL_ENSURE(pCol != nullptr,"OResultSet: pCol == NULL");
 604
 605             OSQLParseNode * pComp = pAssignment->getChild(1);
 606             OSL_ENSURE(pComp != nullptr,"OResultSet: pComp == NULL");
 607             OSL_ENSURE(pComp->getNodeType() == SQLNodeType::Equal,"OResultSet: pComp->getNodeType() != SQLNodeType::Comparison");
 608             if (pComp->getTokenValue().toChar() != '=')
 609             {
 610                 throwFunctionSequenceException(*this);
 611             }
 612
 613             OSQLParseNode * pVal = pAssignment->getChild(2);
 614             OSL_ENSURE(pVal != nullptr,"OResultSet: pVal == NULL");
 615             aList[0] = pCol->getTokenValue();
 616             ParseAssignValues(aList,pVal,0);
 617         }
 618
 619     }
 620 }
 621
 622 void OStatement_Base::ParseAssignValues(const ::std::vector< OUString>& aColumnNameList,OSQLParseNode* pRow_Value_Constructor_Elem, sal_Int32 nIndex)
 623 {
 624     OSL_ENSURE(size_t(nIndex) <= aColumnNameList.size(),"SdbFileCursor::ParseAssignValues: nIndex > aColumnNameList.GetTokenCount()");
 625     OUString aColumnName(aColumnNameList[nIndex]);
 626     OSL_ENSURE(aColumnName.getLength() > 0,"OResultSet: Column-Name nicht gefunden");
 627     OSL_ENSURE(pRow_Value_Constructor_Elem != nullptr,"OResultSet: pRow_Value_Constructor_Elem darf nicht NULL sein!");
 628
 629     if (pRow_Value_Constructor_Elem->getNodeType() == SQLNodeType::String ||
 630         pRow_Value_Constructor_Elem->getNodeType() == SQLNodeType::IntNum ||
 631         pRow_Value_Constructor_Elem->getNodeType() == SQLNodeType::ApproxNum)
 632     {
 633         // set value:
 634         SetAssignValue(aColumnName, pRow_Value_Constructor_Elem->getTokenValue());
 635     }
 636     else if (SQL_ISTOKEN(pRow_Value_Constructor_Elem,NULL))
 637     {
 638         // set NULL
 639         SetAssignValue(aColumnName, OUString(), true);
 640     }
 641     else if (SQL_ISRULE(pRow_Value_Constructor_Elem,parameter))
 642         parseParamterElem(aColumnName,pRow_Value_Constructor_Elem);
 643     else
 644     {
 645         throwFunctionSequenceException(*this);
 646     }
 647 }
 648
 649 void OStatement_Base::SetAssignValue(const OUString& aColumnName,
 650                                      const OUString& aValue,
 651                                      bool bSetNull,
 652                                      sal_uInt32 nParameter)
 653 {
 654     Reference<XPropertySet> xCol;
 655     m_xColNames->getByName(aColumnName) >>= xCol;
 656     sal_Int32 nId = Reference<XColumnLocate>(m_xColNames,UNO_QUERY)->findColumn(aColumnName);
 657     // does this column actually exist in the file?
 658
 659     if (!xCol.is())
 660     {
 661         // This Column doesn't exist!
 662         throwFunctionSequenceException(*this);
 663     }
 664
 665
 666     // Everything tested and we have the names of the Column.
 667     // Now allocate one Value, set the value and tie the value to the Row.
 668     if (bSetNull)
 669         (m_aAssignValues->get())[nId]->setNull();
 670     else
 671     {
 672         switch (::comphelper::getINT32(xCol->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE))))
 673         {
 674             // put criteria depending on the Type as String or double in the variable
 675         case DataType::CHAR:
 676         case DataType::VARCHAR:
 677         case DataType::LONGVARCHAR:
 678             *(m_aAssignValues->get())[nId] = ORowSetValue(aValue);
 679             //Characterset is already converted, since the entire statement was converted
 680             break;
 681
 682         case DataType::BIT:
 683             if (aValue.equalsIgnoreAsciiCase("TRUE")  || aValue[0] == '1')
 684                 *(m_aAssignValues->get())[nId] = true;
 685             else if (aValue.equalsIgnoreAsciiCase("FALSE") || aValue[0] == '0')
 686                 *(m_aAssignValues->get())[nId] = false;
 687             else
 688                 throwFunctionSequenceException(*this);
 689             break;
 690         case DataType::TINYINT:
 691         case DataType::SMALLINT:
 692         case DataType::INTEGER:
 693         case DataType::DECIMAL:
 694         case DataType::NUMERIC:
 695         case DataType::REAL:
 696         case DataType::DOUBLE:
 697         case DataType::DATE:
 698         case DataType::TIME:
 699         case DataType::TIMESTAMP:
 700             *(m_aAssignValues->get())[nId] = ORowSetValue(aValue);
 701             break;
 702         default:
 703             throwFunctionSequenceException(*this);
 704         }
 705     }
 706
 707     // save Parameter-No. (as User Data)
 708     // SQL_NO_PARAMETER = no Parameter.
 709     m_aAssignValues->setParameterIndex(nId,nParameter);
 710     if(nParameter != SQL_NO_PARAMETER)
 711         m_aParameterIndexes[nParameter] = nId;
 712 }
 713
 714 void OStatement_Base::parseParamterElem(const OUString& /*_sColumnName*/,OSQLParseNode* /*pRow_Value_Constructor_Elem*/)
 715 {
 716     // do nothing here
 717 }
 718
 719     } // namespace file
 720
 721 }// namespace connectivity
 722
 723
 724 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */