/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the LibreOffice project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed * with this work for additional information regarding copyright * ownership. The ASF licenses this file to you under the Apache * License, Version 2.0 (the "License"); you may not use this file * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . */ #include "CacheSet.hxx" #include "core_resource.hxx" #include "core_resource.hrc" #include #include #include #include #include #include #include #include "dbastrings.hrc" #include #include #include #include #include #include #include #include #include #include using namespace comphelper; using namespace dbaccess; using namespace dbtools; using namespace connectivity; using namespace ::com::sun::star::uno; using namespace ::com::sun::star::beans; using namespace ::com::sun::star::sdbc; using namespace ::com::sun::star::sdbcx; using namespace ::com::sun::star::container; using namespace ::com::sun::star::lang; using namespace ::com::sun::star::io; using namespace ::osl; OCacheSet::OCacheSet(sal_Int32 i_nMaxRows) :m_nMaxRows(i_nMaxRows) ,m_bInserted(false) ,m_bUpdated(false) ,m_bDeleted(false) { } OUString OCacheSet::getIdentifierQuoteString() const { OUString sQuote; Reference xMeta; if ( m_xConnection.is() && (xMeta = m_xConnection->getMetaData()).is() ) sQuote = xMeta->getIdentifierQuoteString(); return sQuote; } void OCacheSet::construct( const Reference< XResultSet>& _xDriverSet,const OUString &i_sRowSetFilter) { OSL_ENSURE(_xDriverSet.is(),"Invalid resultSet"); m_sRowSetFilter = i_sRowSetFilter; if(_xDriverSet.is()) { m_xDriverSet = _xDriverSet; m_xDriverRow.set(_xDriverSet,UNO_QUERY); m_xSetMetaData = Reference(_xDriverSet,UNO_QUERY)->getMetaData(); if ( m_xSetMetaData.is() ) { const sal_Int32 nCount = m_xSetMetaData->getColumnCount(); m_aNullable.resize(nCount); m_aSignedFlags.resize(nCount); m_aColumnTypes.resize(nCount); auto pNullableIter = m_aNullable.begin(); auto pSignedIter = m_aSignedFlags.begin(); auto pColumnIter = m_aColumnTypes.begin(); for (sal_Int32 i=1; i <= nCount; ++i,++pSignedIter,++pColumnIter,++pNullableIter) { *pNullableIter = m_xSetMetaData->isNullable(i) != ColumnValue::NO_NULLS; *pSignedIter = m_xSetMetaData->isSigned(i); *pColumnIter = m_xSetMetaData->getColumnType(i); } } Reference< XStatement> xStmt(m_xDriverSet->getStatement(),UNO_QUERY); if(xStmt.is()) m_xConnection = xStmt->getConnection(); else { Reference< XPreparedStatement> xPrepStmt(m_xDriverSet->getStatement(),UNO_QUERY); if ( xPrepStmt.is() ) m_xConnection = xPrepStmt->getConnection(); } } } OCacheSet::~OCacheSet() { try { m_xDriverSet = nullptr; m_xDriverRow = nullptr; m_xSetMetaData = nullptr; m_xConnection = nullptr; } catch(Exception&) { SAL_WARN("dbaccess", "Exception occurred"); } catch(...) { SAL_WARN("dbaccess", "Unknown Exception occurred"); } } void OCacheSet::fillTableName(const Reference& _xTable) throw(SQLException, RuntimeException) { OSL_ENSURE(_xTable.is(),"OCacheSet::fillTableName: PropertySet is empty!"); if(m_aComposedTableName.isEmpty() && _xTable.is() ) { Reference xMeta(m_xConnection->getMetaData()); m_aComposedTableName = composeTableName(xMeta ,comphelper::getString(_xTable->getPropertyValue(PROPERTY_CATALOGNAME)) ,comphelper::getString(_xTable->getPropertyValue(PROPERTY_SCHEMANAME)) ,comphelper::getString(_xTable->getPropertyValue(PROPERTY_NAME)) ,true ,::dbtools::EComposeRule::InDataManipulation); } } void SAL_CALL OCacheSet::insertRow( const ORowSetRow& _rInsertRow,const connectivity::OSQLTable& _xTable ) throw(SQLException, RuntimeException, std::exception) { Reference xSet(_xTable,UNO_QUERY); fillTableName(xSet); OUStringBuffer aSql("INSERT INTO " + m_aComposedTableName + " ( "); // set values and column names OUStringBuffer aValues(" VALUES ( "); static const char aPara[] = "?,"; OUString aQuote = getIdentifierQuoteString(); static const char aComma[] = ","; sal_Int32 i = 1; ORowVector< ORowSetValue >::Vector::const_iterator aIter = _rInsertRow->get().begin()+1; connectivity::ORowVector< ORowSetValue > ::Vector::iterator aEnd = _rInsertRow->get().end(); for(; aIter != aEnd;++aIter) { aSql.append(::dbtools::quoteName( aQuote,m_xSetMetaData->getColumnName(i++)) + aComma); aValues.append(aPara); } aSql[aSql.getLength() - 1] = ')'; aValues[aValues.getLength() - 1] = ')'; aSql.append(aValues.makeStringAndClear()); // now create end execute the prepared statement { Reference< XPreparedStatement > xPrep(m_xConnection->prepareStatement(aSql.makeStringAndClear())); Reference< XParameters > xParameter(xPrep,UNO_QUERY); i = 1; for(aIter = _rInsertRow->get().begin()+1; aIter != aEnd;++aIter,++i) { if(aIter->isNull()) xParameter->setNull(i,aIter->getTypeKind()); else setParameter(i,xParameter,*aIter,m_xSetMetaData->getColumnType(i),m_xSetMetaData->getScale(i)); } m_bInserted = xPrep->executeUpdate() > 0; } // TODO set the bookmark in the insert row } void OCacheSet::fillParameters( const ORowSetRow& _rRow ,const connectivity::OSQLTable& _xTable ,OUStringBuffer& _sCondition ,OUStringBuffer& _sParameter ,::std::list< sal_Int32>& _rOrgValues) { // use keys and indexes for exact positioning // first the keys Reference xSet(_xTable,UNO_QUERY); const Reference xPrimaryKeyColumns = getPrimaryKeyColumns_throw(xSet); // second the indexes Reference xIndexSup(_xTable,UNO_QUERY); Reference xIndexes; if(xIndexSup.is()) xIndexes.set(xIndexSup->getIndexes(),UNO_QUERY); // Reference Reference xIndexColsSup; Reference xIndexColumns; ::std::vector< Reference > aAllIndexColumns; if(xIndexes.is()) { for(sal_Int32 j=0;jgetCount();++j) { xIndexColsSup.set(xIndexes->getByIndex(j),UNO_QUERY); if( xIndexColsSup.is() && comphelper::getBOOL(xIndexColsSup->getPropertyValue(PROPERTY_ISUNIQUE)) && !comphelper::getBOOL(xIndexColsSup->getPropertyValue(PROPERTY_ISPRIMARYKEYINDEX)) ) aAllIndexColumns.push_back(Reference(xIndexColsSup,UNO_QUERY)->getColumns()); } } OUString aColumnName; static const char aPara[] = "?,"; static const char aAnd[] = " AND "; OUString aQuote = getIdentifierQuoteString(); sal_Int32 nCheckCount = 1; // index for the original values sal_Int32 i = 1; OUString sIsNull(" IS NULL"); OUString sParam(" = ?"); ORowVector< ORowSetValue >::Vector::const_iterator aIter = _rRow->get().begin()+1; ORowVector< ORowSetValue >::Vector::const_iterator aEnd = _rRow->get().end()+1; for(; aIter != aEnd;++aIter,++nCheckCount,++i) { aColumnName = m_xSetMetaData->getColumnName(i); if(xPrimaryKeyColumns.is() && xPrimaryKeyColumns->hasByName(aColumnName)) { _sCondition.append(::dbtools::quoteName( aQuote,aColumnName)); if(aIter->isNull()) _sCondition.append(sIsNull); else _sCondition.append(sParam); _sCondition.append(aAnd); _rOrgValues.push_back(nCheckCount); } ::std::vector< Reference >::const_iterator aIndexEnd = aAllIndexColumns.end(); for( ::std::vector< Reference >::const_iterator aIndexIter = aAllIndexColumns.begin(); aIndexIter != aIndexEnd;++aIndexIter) { if((*aIndexIter)->hasByName(aColumnName)) { _sCondition.append(::dbtools::quoteName( aQuote,aColumnName)); if(aIter->isNull()) _sCondition.append(sIsNull); else _sCondition.append(sParam); _sCondition.append(aAnd); _rOrgValues.push_back(nCheckCount); break; } } if(aIter->isModified()) { _sParameter.append(::dbtools::quoteName( aQuote,aColumnName) + aPara); } } } void SAL_CALL OCacheSet::updateRow(const ORowSetRow& _rInsertRow ,const ORowSetRow& _rOriginalRow,const connectivity::OSQLTable& _xTable ) throw(SQLException, RuntimeException, std::exception) { Reference xSet(_xTable,UNO_QUERY); fillTableName(xSet); OUStringBuffer aSql("UPDATE " + m_aComposedTableName + " SET "); // list all columns that should be set OUStringBuffer aCondition; ::std::list< sal_Int32> aOrgValues; fillParameters(_rInsertRow,_xTable,aCondition,aSql,aOrgValues); aSql[aSql.getLength() - 1] = ' '; if ( !aCondition.isEmpty() ) { aCondition.setLength(aCondition.getLength()-5); aSql.append(" WHERE " + aCondition.makeStringAndClear()); } else ::dbtools::throwSQLException( DBACORE_RESSTRING( RID_STR_NO_UPDATE_MISSING_CONDITION ), SQL_GENERAL_ERROR, *this ); // now create end execute the prepared statement Reference< XPreparedStatement > xPrep(m_xConnection->prepareStatement(aSql.makeStringAndClear())); Reference< XParameters > xParameter(xPrep,UNO_QUERY); sal_Int32 i = 1; connectivity::ORowVector< ORowSetValue > ::Vector::iterator aEnd = _rInsertRow->get().end(); for(ORowVector< ORowSetValue >::Vector::const_iterator aIter = _rInsertRow->get().begin()+1; aIter != aEnd;++aIter) { if(aIter->isModified()) { setParameter(i,xParameter,*aIter,m_xSetMetaData->getColumnType(i),m_xSetMetaData->getScale(i)); ++i; } } ::std::list< sal_Int32>::const_iterator aOrgValueEnd = aOrgValues.end(); for(::std::list< sal_Int32>::const_iterator aOrgValue = aOrgValues.begin(); aOrgValue != aOrgValueEnd;++aOrgValue,++i) { setParameter(i,xParameter,(_rOriginalRow->get())[*aOrgValue],m_xSetMetaData->getColumnType(i),m_xSetMetaData->getScale(i)); } m_bUpdated = xPrep->executeUpdate() > 0; } void SAL_CALL OCacheSet::deleteRow(const ORowSetRow& _rDeleteRow ,const connectivity::OSQLTable& _xTable ) throw(SQLException, RuntimeException) { Reference xSet(_xTable,UNO_QUERY); fillTableName(xSet); OUStringBuffer aSql("DELETE FROM " + m_aComposedTableName + " WHERE "); // use keys and indexes for exact positioning // first the keys const Reference xPrimaryKeyColumns = getPrimaryKeyColumns_throw(xSet); // second the indexes Reference xIndexSup(_xTable,UNO_QUERY); Reference xIndexes; if(xIndexSup.is()) xIndexes.set(xIndexSup->getIndexes(),UNO_QUERY); // Reference Reference xIndexColsSup; Reference xIndexColumns; ::std::vector< Reference > aAllIndexColumns; if(xIndexes.is()) { for(sal_Int32 j=0;jgetCount();++j) { xIndexColsSup.set(xIndexes->getByIndex(j),UNO_QUERY); if( xIndexColsSup.is() && comphelper::getBOOL(xIndexColsSup->getPropertyValue(PROPERTY_ISUNIQUE)) && !comphelper::getBOOL(xIndexColsSup->getPropertyValue(PROPERTY_ISPRIMARYKEYINDEX)) ) aAllIndexColumns.push_back(Reference(xIndexColsSup,UNO_QUERY)->getColumns()); } } OUStringBuffer aColumnName; ::std::list< sal_Int32> aOrgValues; fillParameters(_rDeleteRow,_xTable,aSql,aColumnName,aOrgValues); aSql.setLength(aSql.getLength()-5); // now create and execute the prepared statement Reference< XPreparedStatement > xPrep(m_xConnection->prepareStatement(aSql.makeStringAndClear())); Reference< XParameters > xParameter(xPrep,UNO_QUERY); sal_Int32 i = 1; ::std::list< sal_Int32>::const_iterator aOrgValueEnd = aOrgValues.end(); for(::std::list< sal_Int32>::const_iterator j = aOrgValues.begin(); j != aOrgValueEnd;++j,++i) { setParameter(i,xParameter,(_rDeleteRow->get())[*j],m_xSetMetaData->getColumnType(i),m_xSetMetaData->getScale(i)); } m_bDeleted = xPrep->executeUpdate() > 0; } void OCacheSet::setParameter(sal_Int32 nPos ,const Reference< XParameters >& _xParameter ,const ORowSetValue& _rValue ,sal_Int32 _nType ,sal_Int32 _nScale) { sal_Int32 nType = ( _nType != DataType::OTHER ) ? _nType : _rValue.getTypeKind(); ::dbtools::setObjectWithInfo(_xParameter,nPos,_rValue,nType,_nScale); } void OCacheSet::fillValueRow(ORowSetRow& _rRow,sal_Int32 _nPosition) { Any aBookmark = getBookmark(); if(!aBookmark.hasValue()) aBookmark = makeAny(_nPosition); connectivity::ORowVector< ORowSetValue >::Vector::iterator aIter = _rRow->get().begin(); connectivity::ORowVector< ORowSetValue >::Vector::iterator aEnd = _rRow->get().end(); (*aIter) = aBookmark; ++aIter; for(sal_Int32 i=1;aIter != aEnd;++aIter,++i) { aIter->setSigned(m_aSignedFlags[i-1]); aIter->fill(i, m_aColumnTypes[i-1], this); } } sal_Bool SAL_CALL OCacheSet::wasNull( ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->wasNull(); } OUString SAL_CALL OCacheSet::getString( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getString(columnIndex); } sal_Bool SAL_CALL OCacheSet::getBoolean( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getBoolean(columnIndex); } sal_Int8 SAL_CALL OCacheSet::getByte( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getByte(columnIndex); } sal_Int16 SAL_CALL OCacheSet::getShort( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getShort(columnIndex); } sal_Int32 SAL_CALL OCacheSet::getInt( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getInt(columnIndex); } sal_Int64 SAL_CALL OCacheSet::getLong( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getLong(columnIndex); } float SAL_CALL OCacheSet::getFloat( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getFloat(columnIndex); } double SAL_CALL OCacheSet::getDouble( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getDouble(columnIndex); } Sequence< sal_Int8 > SAL_CALL OCacheSet::getBytes( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getBytes(columnIndex); } css::util::Date SAL_CALL OCacheSet::getDate( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getDate(columnIndex); } css::util::Time SAL_CALL OCacheSet::getTime( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getTime(columnIndex); } css::util::DateTime SAL_CALL OCacheSet::getTimestamp( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getTimestamp(columnIndex); } Reference< css::io::XInputStream > SAL_CALL OCacheSet::getBinaryStream( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getBinaryStream(columnIndex); } Reference< css::io::XInputStream > SAL_CALL OCacheSet::getCharacterStream( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getCharacterStream(columnIndex); } Any SAL_CALL OCacheSet::getObject( sal_Int32 columnIndex, const Reference< css::container::XNameAccess >& typeMap ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getObject(columnIndex,typeMap); } Reference< XRef > SAL_CALL OCacheSet::getRef( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getRef(columnIndex); } Reference< XBlob > SAL_CALL OCacheSet::getBlob( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getBlob(columnIndex); } Reference< XClob > SAL_CALL OCacheSet::getClob( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getClob(columnIndex); } Reference< XArray > SAL_CALL OCacheSet::getArray( sal_Int32 columnIndex ) throw(SQLException, RuntimeException, std::exception) { return m_xDriverRow->getArray(columnIndex); } // XResultSet bool SAL_CALL OCacheSet::next( ) throw(SQLException, RuntimeException) { m_bInserted = m_bUpdated = m_bDeleted = false; return m_xDriverSet->next(); } bool SAL_CALL OCacheSet::isBeforeFirst( ) throw(SQLException, RuntimeException) { return m_xDriverSet->isBeforeFirst(); } bool SAL_CALL OCacheSet::isAfterLast( ) throw(SQLException, RuntimeException) { return m_xDriverSet->isAfterLast(); } void SAL_CALL OCacheSet::beforeFirst( ) throw(SQLException, RuntimeException) { m_bInserted = m_bUpdated = m_bDeleted = false; m_xDriverSet->beforeFirst(); } void SAL_CALL OCacheSet::afterLast( ) throw(SQLException, RuntimeException) { m_bInserted = m_bUpdated = m_bDeleted = false; m_xDriverSet->afterLast(); } bool SAL_CALL OCacheSet::first( ) throw(SQLException, RuntimeException) { m_bInserted = m_bUpdated = m_bDeleted = false; return m_xDriverSet->first(); } bool SAL_CALL OCacheSet::last( ) throw(SQLException, RuntimeException) { m_bInserted = m_bUpdated = m_bDeleted = false; return m_xDriverSet->last(); } sal_Int32 SAL_CALL OCacheSet::getRow( ) throw(SQLException, RuntimeException) { return m_xDriverSet->getRow(); } bool SAL_CALL OCacheSet::absolute( sal_Int32 row ) throw(SQLException, RuntimeException) { m_bInserted = m_bUpdated = m_bDeleted = false; return m_xDriverSet->absolute(row); } bool SAL_CALL OCacheSet::previous( ) throw(SQLException, RuntimeException) { m_bInserted = m_bUpdated = m_bDeleted = false; return m_xDriverSet->previous(); } bool OCacheSet::last_checked( bool /*i_bFetchRow*/) { return last(); } bool OCacheSet::previous_checked( bool /*i_bFetchRow*/ ) { return previous(); } bool OCacheSet::absolute_checked( sal_Int32 row,bool /*i_bFetchRow*/ ) { return absolute(row); } void SAL_CALL OCacheSet::refreshRow( ) throw(SQLException, RuntimeException) { m_xDriverSet->refreshRow(); } bool SAL_CALL OCacheSet::rowUpdated( ) throw(SQLException, RuntimeException) { return m_xDriverSet->rowUpdated(); } bool SAL_CALL OCacheSet::rowInserted( ) throw(SQLException, RuntimeException) { return m_xDriverSet->rowInserted(); } bool SAL_CALL OCacheSet::rowDeleted( ) throw(SQLException, RuntimeException) { return m_xDriverSet->rowDeleted(); } bool OCacheSet::isResultSetChanged() const { return false; } void OCacheSet::mergeColumnValues(sal_Int32 i_nColumnIndex,ORowSetValueVector::Vector& /*io_aInsertRow*/,ORowSetValueVector::Vector& /*io_aRow*/,::std::vector& o_aChangedColumns) { o_aChangedColumns.push_back(i_nColumnIndex); } bool OCacheSet::columnValuesUpdated(ORowSetValueVector::Vector& /*io_aCachedRow*/,const ORowSetValueVector::Vector& /*io_aRow*/) { return false; } bool OCacheSet::updateColumnValues(const ORowSetValueVector::Vector& /*io_aCachedRow*/,ORowSetValueVector::Vector& /*io_aRow*/,const ::std::vector& /*i_aChangedColumns*/) { return true; } void OCacheSet::fillMissingValues(ORowSetValueVector::Vector& /*io_aRow*/) const { } /* vim:set shiftwidth=4 softtabstop=4 expandtab: */