connectivity/source/drivers/macab/MacabPreparedStatement.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
  21 #include "MacabPreparedStatement.hxx"
  22 #include "MacabAddressBook.hxx"
  23 #include <propertyids.hxx>
  24 #include <connectivity/dbexception.hxx>
  25 #include <connectivity/dbtools.hxx>
  26 #include <strings.hrc>
  27 #include <resource/sharedresources.hxx>
  28
  29 using namespace connectivity::macab;
  30 using namespace com::sun::star::uno;
  31 using namespace com::sun::star::lang;
  32 using namespace com::sun::star::sdbc;
  33 using namespace com::sun::star::util;
  34
  35 IMPLEMENT_SERVICE_INFO(MacabPreparedStatement, "com.sun.star.sdbc.drivers.MacabPreparedStatement", "com.sun.star.sdbc.PreparedStatement");
  36
  37 void MacabPreparedStatement::checkAndResizeParameters(sal_Int32 nParams)
  38 {
  39     if ( !m_aParameterRow.is() )
  40         m_aParameterRow = new OValueVector();
  41
  42     if (nParams < 1)
  43         ::dbtools::throwInvalidIndexException(*this);
  44
  45     if (nParams >= static_cast<sal_Int32>(m_aParameterRow->size()))
  46         m_aParameterRow->resize(nParams);
  47 }
  48
  49 void MacabPreparedStatement::setMacabFields() const
  50 {
  51     ::rtl::Reference<connectivity::OSQLColumns> xColumns;   // selected columns
  52
  53     xColumns = m_aSQLIterator.getSelectColumns();
  54     if (!xColumns.is())
  55     {
  56         ::connectivity::SharedResources aResources;
  57         const OUString sError( aResources.getResourceString(
  58                 STR_INVALID_COLUMN_SELECTION
  59              ) );
  60         ::dbtools::throwGenericSQLException(sError,nullptr);
  61     }
  62     m_xMetaData->setMacabFields(xColumns);
  63 }
  64
  65 void MacabPreparedStatement::resetParameters() const
  66 {
  67     m_nParameterIndex = 0;
  68 }
  69
  70 void MacabPreparedStatement::getNextParameter(OUString &rParameter) const
  71 {
  72     if (m_nParameterIndex >= static_cast<sal_Int32>(m_aParameterRow->size()))
  73     {
  74         ::connectivity::SharedResources aResources;
  75         const OUString sError( aResources.getResourceString(
  76                 STR_INVALID_PARA_COUNT
  77              ) );
  78         ::dbtools::throwGenericSQLException(sError,*const_cast<MacabPreparedStatement *>(this));
  79     }
  80
  81     rParameter = (*m_aParameterRow)[m_nParameterIndex].getString();
  82
  83     m_nParameterIndex++;
  84 }
  85
  86 MacabPreparedStatement::MacabPreparedStatement(
  87     MacabConnection* _pConnection,
  88     const OUString& sql)
  89     : MacabPreparedStatement_BASE(_pConnection),
  90       m_sSqlStatement(sql),
  91       m_bPrepared(false),
  92       m_nParameterIndex(0),
  93       m_aParameterRow()
  94 {
  95
  96 }
  97
  98 MacabPreparedStatement::~MacabPreparedStatement()
  99 {
 100 }
 101
 102 void MacabPreparedStatement::disposing()
 103 {
 104     MacabPreparedStatement_BASE::disposing();
 105
 106     if (m_aParameterRow.is())
 107     {
 108         m_aParameterRow->clear();
 109         m_aParameterRow = nullptr;
 110     }
 111 }
 112
 113 Reference< XResultSetMetaData > SAL_CALL MacabPreparedStatement::getMetaData()
 114 {
 115     ::osl::MutexGuard aGuard( m_aMutex );
 116     checkDisposed(MacabCommonStatement_BASE::rBHelper.bDisposed);
 117
 118     if (!m_xMetaData.is())
 119     {
 120         const OSQLTables& xTabs = m_aSQLIterator.getTables();
 121         OUString sTableName = MacabAddressBook::getDefaultTableName();
 122
 123         if(! xTabs.empty() )
 124         {
 125
 126             // can only deal with one table at a time
 127             if(xTabs.size() == 1 && !m_aSQLIterator.hasErrors() )
 128                 sTableName = xTabs.begin()->first;
 129
 130         }
 131         m_xMetaData = new MacabResultSetMetaData(getOwnConnection(),sTableName);
 132         setMacabFields();
 133     }
 134     Reference< XResultSetMetaData > xMetaData = m_xMetaData;
 135     return xMetaData;
 136 }
 137
 138 void SAL_CALL MacabPreparedStatement::close()
 139 {
 140     ::osl::MutexGuard aGuard( m_aMutex );
 141     checkDisposed(MacabCommonStatement_BASE::rBHelper.bDisposed);
 142
 143     // Reset last warning message
 144     try {
 145         clearWarnings ();
 146         MacabCommonStatement::close();
 147     }
 148     catch (SQLException &) {
 149         // If we get an error, ignore
 150     }
 151
 152     // Remove this Statement object from the Connection object's
 153     // list
 154 }
 155
 156 sal_Bool SAL_CALL MacabPreparedStatement::execute()
 157 {
 158     ::osl::MutexGuard aGuard( m_aMutex );
 159     checkDisposed(MacabCommonStatement_BASE::rBHelper.bDisposed);
 160
 161     Reference< XResultSet> xRS = MacabCommonStatement::executeQuery(m_sSqlStatement);
 162
 163     return xRS.is();
 164 }
 165
 166 sal_Int32 SAL_CALL MacabPreparedStatement::executeUpdate()
 167 {
 168     ::osl::MutexGuard aGuard( m_aMutex );
 169     checkDisposed(MacabCommonStatement_BASE::rBHelper.bDisposed);
 170
 171     // same as in statement with the difference that this statement also can contain parameter
 172     return 0;
 173 }
 174
 175 Reference< XConnection > SAL_CALL MacabPreparedStatement::getConnection()
 176 {
 177     ::osl::MutexGuard aGuard( m_aMutex );
 178     checkDisposed(MacabCommonStatement_BASE::rBHelper.bDisposed);
 179
 180     return m_pConnection;
 181 }
 182
 183 Reference< XResultSet > SAL_CALL MacabPreparedStatement::executeQuery()
 184 {
 185     ::osl::MutexGuard aGuard( m_aMutex );
 186     checkDisposed(MacabCommonStatement_BASE::rBHelper.bDisposed);
 187
 188     Reference< XResultSet > rs = MacabCommonStatement::executeQuery(m_sSqlStatement);
 189
 190     return rs;
 191 }
 192
 193 void SAL_CALL MacabPreparedStatement::setNull(sal_Int32 parameterIndex, sal_Int32)
 194 {
 195     ::osl::MutexGuard aGuard( m_aMutex );
 196     checkDisposed(MacabCommonStatement_BASE::rBHelper.bDisposed);
 197
 198     checkAndResizeParameters(parameterIndex);
 199
 200     (*m_aParameterRow)[parameterIndex - 1].setNull();
 201 }
 202
 203 void SAL_CALL MacabPreparedStatement::setObjectNull(sal_Int32, sal_Int32, const OUString&)
 204 {
 205     ::dbtools::throwFunctionNotSupportedSQLException("setObjectNull", nullptr);
 206 }
 207
 208 void SAL_CALL MacabPreparedStatement::setBoolean(sal_Int32, sal_Bool)
 209 {
 210     ::dbtools::throwFunctionNotSupportedSQLException("setBoolean", nullptr);
 211 }
 212
 213 void SAL_CALL MacabPreparedStatement::setByte(sal_Int32, sal_Int8)
 214 {
 215     ::dbtools::throwFunctionNotSupportedSQLException("setByte", nullptr);
 216 }
 217
 218 void SAL_CALL MacabPreparedStatement::setShort(sal_Int32, sal_Int16)
 219 {
 220     ::dbtools::throwFunctionNotSupportedSQLException("setShort", nullptr);
 221 }
 222
 223 void SAL_CALL MacabPreparedStatement::setInt(sal_Int32, sal_Int32)
 224 {
 225     ::dbtools::throwFunctionNotSupportedSQLException("setInt", nullptr);
 226 }
 227
 228 void SAL_CALL MacabPreparedStatement::setLong(sal_Int32, sal_Int64)
 229 {
 230     ::dbtools::throwFunctionNotSupportedSQLException("setLong", nullptr);
 231 }
 232
 233 void SAL_CALL MacabPreparedStatement::setFloat(sal_Int32, float)
 234 {
 235     ::dbtools::throwFunctionNotSupportedSQLException("setFloat", nullptr);
 236 }
 237
 238 void SAL_CALL MacabPreparedStatement::setDouble(sal_Int32, double)
 239 {
 240     ::dbtools::throwFunctionNotSupportedSQLException("setDouble", nullptr);
 241 }
 242
 243 void SAL_CALL MacabPreparedStatement::setString(sal_Int32 parameterIndex, const OUString &x)
 244 {
 245     ::osl::MutexGuard aGuard( m_aMutex );
 246     checkDisposed(MacabCommonStatement_BASE::rBHelper.bDisposed);
 247
 248     checkAndResizeParameters(parameterIndex);
 249
 250     (*m_aParameterRow)[parameterIndex - 1] = x;
 251 }
 252
 253 void SAL_CALL MacabPreparedStatement::setBytes(sal_Int32, const Sequence< sal_Int8 >&)
 254 {
 255     ::dbtools::throwFunctionNotSupportedSQLException("setBytes", nullptr);
 256 }
 257
 258 void SAL_CALL MacabPreparedStatement::setDate(sal_Int32, const Date&)
 259 {
 260     ::dbtools::throwFunctionNotSupportedSQLException("setDate", nullptr);
 261 }
 262
 263 void SAL_CALL MacabPreparedStatement::setTime(sal_Int32, const css::util::Time&)
 264 {
 265
 266     ::dbtools::throwFunctionNotSupportedSQLException("setTime", nullptr);
 267 }
 268
 269 void SAL_CALL MacabPreparedStatement::setTimestamp(sal_Int32, const DateTime&)
 270 {
 271     ::dbtools::throwFunctionNotSupportedSQLException("setTimestamp", nullptr);
 272 }
 273
 274 void SAL_CALL MacabPreparedStatement::setBinaryStream(sal_Int32, const Reference< css::io::XInputStream >&, sal_Int32)
 275 {
 276     ::dbtools::throwFunctionNotSupportedSQLException("setBinaryStream", nullptr);
 277 }
 278
 279 void SAL_CALL MacabPreparedStatement::setCharacterStream(sal_Int32, const Reference< css::io::XInputStream >&, sal_Int32)
 280 {
 281     ::dbtools::throwFunctionNotSupportedSQLException("setCharacterStream", nullptr);
 282 }
 283
 284 void SAL_CALL MacabPreparedStatement::setObject(sal_Int32 parameterIndex, const Any& x)
 285 {
 286     if(!::dbtools::implSetObject(this,parameterIndex,x))
 287     {
 288         const OUString sError( m_pConnection->getResources().getResourceStringWithSubstitution(
 289                 STR_UNKNOWN_PARA_TYPE,
 290                 "$position$", OUString::number(parameterIndex)
 291              ) );
 292         ::dbtools::throwGenericSQLException(sError,*this);
 293     }
 294 }
 295
 296 void SAL_CALL MacabPreparedStatement::setObjectWithInfo(sal_Int32, const Any&, sal_Int32, sal_Int32)
 297 {
 298     ::dbtools::throwFunctionNotSupportedSQLException("setObjectWithInfo", nullptr);
 299 }
 300
 301 void SAL_CALL MacabPreparedStatement::setRef(sal_Int32, const Reference< XRef >&)
 302 {
 303     ::dbtools::throwFunctionNotSupportedSQLException("setRef", nullptr);
 304 }
 305
 306 void SAL_CALL MacabPreparedStatement::setBlob(sal_Int32, const Reference< XBlob >&)
 307 {
 308     ::dbtools::throwFunctionNotSupportedSQLException("setBlob", nullptr);
 309 }
 310
 311 void SAL_CALL MacabPreparedStatement::setClob(sal_Int32, const Reference< XClob >&)
 312 {
 313     ::dbtools::throwFunctionNotSupportedSQLException("setClob", nullptr);
 314 }
 315
 316 void SAL_CALL MacabPreparedStatement::setArray(sal_Int32, const Reference< XArray >&)
 317 {
 318     ::dbtools::throwFunctionNotSupportedSQLException("setArray", nullptr);
 319 }
 320
 321 void SAL_CALL MacabPreparedStatement::clearParameters()
 322 {
 323     ::dbtools::throwFunctionNotSupportedSQLException("clearParameters", nullptr);
 324 }
 325
 326 void MacabPreparedStatement::setFastPropertyValue_NoBroadcast(sal_Int32 nHandle,const Any& rValue)
 327 {
 328     switch (nHandle)
 329     {
 330         case PROPERTY_ID_RESULTSETCONCURRENCY:
 331             break;
 332         case PROPERTY_ID_RESULTSETTYPE:
 333             break;
 334         case PROPERTY_ID_FETCHDIRECTION:
 335             break;
 336         case PROPERTY_ID_USEBOOKMARKS:
 337             break;
 338         default:
 339             MacabCommonStatement::setFastPropertyValue_NoBroadcast(nHandle,rValue);
 340     }
 341 }
 342
 343 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */