| /************************************************************** | |
| * | |
| * 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 | |
| * | |
| * Unless required by applicable law or agreed to in writing, | |
| * software distributed under the License is distributed on an | |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
| * KIND, either express or implied. See the License for the | |
| * specific language governing permissions and limitations | |
| * under the License. | |
| * | |
| *************************************************************/ | |
| // MARKER(update_precomp.py): autogen include statement, do not remove | |
| #include "precompiled_forms.hxx" | |
| #include "cachedrowset.hxx" | |
| #include "services.hxx" | |
| #include "frm_strings.hxx" | |
| /** === begin UNO includes === **/ | |
| #include <com/sun/star/lang/XComponent.hpp> | |
| #include <com/sun/star/beans/XPropertySet.hpp> | |
| #include <com/sun/star/sdb/XQueriesSupplier.hpp> | |
| #include <com/sun/star/sdbc/ResultSetType.hpp> | |
| /** === end UNO includes === **/ | |
| #include <tools/diagnose_ex.h> | |
| //........................................................................ | |
| namespace frm | |
| { | |
| //........................................................................ | |
| /** === begin UNO using === **/ | |
| using ::com::sun::star::uno::Reference; | |
| using ::com::sun::star::uno::UNO_QUERY; | |
| using ::com::sun::star::uno::UNO_QUERY_THROW; | |
| using ::com::sun::star::uno::UNO_SET_THROW; | |
| using ::com::sun::star::uno::Exception; | |
| using ::com::sun::star::uno::RuntimeException; | |
| using ::com::sun::star::sdbc::XConnection; | |
| using ::com::sun::star::lang::XComponent; | |
| using ::com::sun::star::beans::XPropertySet; | |
| using ::com::sun::star::uno::makeAny; | |
| using ::com::sun::star::sdbc::SQLException; | |
| using ::com::sun::star::uno::Any; | |
| using ::com::sun::star::sdb::XQueriesSupplier; | |
| using ::com::sun::star::container::XNameAccess; | |
| using ::com::sun::star::sdbc::XResultSet; | |
| using ::com::sun::star::sdbc::XStatement; | |
| /** === end UNO using === **/ | |
| namespace ResultSetType = ::com::sun::star::sdbc::ResultSetType; | |
| //==================================================================== | |
| //= CachedRowSet_Data | |
| //==================================================================== | |
| struct CachedRowSet_Data | |
| { | |
| ::comphelper::ComponentContext aContext; | |
| ::rtl::OUString sCommand; | |
| sal_Bool bEscapeProcessing; | |
| Reference< XConnection > xConnection; | |
| bool bStatementDirty; | |
| CachedRowSet_Data( const ::comphelper::ComponentContext& _rContext ) | |
| :aContext( _rContext ) | |
| ,sCommand() | |
| ,bEscapeProcessing( sal_False ) | |
| ,xConnection() | |
| ,bStatementDirty( true ) | |
| { | |
| } | |
| }; | |
| //==================================================================== | |
| //= CachedRowSet | |
| //==================================================================== | |
| //-------------------------------------------------------------------- | |
| CachedRowSet::CachedRowSet( const ::comphelper::ComponentContext& _rContext ) | |
| :m_pData( new CachedRowSet_Data( _rContext ) ) | |
| { | |
| } | |
| //-------------------------------------------------------------------- | |
| CachedRowSet::~CachedRowSet() | |
| { | |
| dispose(); | |
| } | |
| //-------------------------------------------------------------------- | |
| void CachedRowSet::setCommand( const ::rtl::OUString& _rCommand ) | |
| { | |
| if ( m_pData->sCommand == _rCommand ) | |
| return; | |
| m_pData->sCommand = _rCommand; | |
| m_pData->bStatementDirty = true; | |
| } | |
| //-------------------------------------------------------------------- | |
| void CachedRowSet::setCommandFromQuery( const ::rtl::OUString& _rQueryName ) | |
| { | |
| Reference< XQueriesSupplier > xSupplyQueries( m_pData->xConnection, UNO_QUERY_THROW ); | |
| Reference< XNameAccess > xQueries ( xSupplyQueries->getQueries(), UNO_QUERY_THROW ); | |
| Reference< XPropertySet > xQuery ( xQueries->getByName( _rQueryName ), UNO_QUERY_THROW ); | |
| sal_Bool bEscapeProcessing( sal_False ); | |
| OSL_VERIFY( xQuery->getPropertyValue( PROPERTY_ESCAPE_PROCESSING ) >>= bEscapeProcessing ); | |
| setEscapeProcessing( bEscapeProcessing ); | |
| ::rtl::OUString sCommand; | |
| OSL_VERIFY( xQuery->getPropertyValue( PROPERTY_COMMAND ) >>= sCommand ); | |
| setCommand( sCommand ); | |
| } | |
| //-------------------------------------------------------------------- | |
| void CachedRowSet::setEscapeProcessing ( const sal_Bool _bEscapeProcessing ) | |
| { | |
| if ( m_pData->bEscapeProcessing == _bEscapeProcessing ) | |
| return; | |
| m_pData->bEscapeProcessing = _bEscapeProcessing; | |
| m_pData->bStatementDirty = true; | |
| } | |
| //-------------------------------------------------------------------- | |
| void CachedRowSet::setConnection( const Reference< XConnection >& _rxConnection ) | |
| { | |
| if ( m_pData->xConnection == _rxConnection ) | |
| return; | |
| m_pData->xConnection = _rxConnection; | |
| m_pData->bStatementDirty = true; | |
| } | |
| //-------------------------------------------------------------------- | |
| Reference< XResultSet > CachedRowSet::execute() | |
| { | |
| Reference< XResultSet > xResult; | |
| try | |
| { | |
| OSL_PRECOND( m_pData->xConnection.is(), "CachedRowSet::execute: how am I expected to do this without a connection?" ); | |
| if ( !m_pData->xConnection.is() ) | |
| return xResult; | |
| Reference< XStatement > xStatement( m_pData->xConnection->createStatement(), UNO_SET_THROW ); | |
| Reference< XPropertySet > xStatementProps( xStatement, UNO_QUERY_THROW ); | |
| xStatementProps->setPropertyValue( PROPERTY_ESCAPE_PROCESSING, makeAny( m_pData->bEscapeProcessing ) ); | |
| xStatementProps->setPropertyValue( PROPERTY_RESULTSET_TYPE, makeAny( ResultSetType::FORWARD_ONLY ) ); | |
| xResult.set( xStatement->executeQuery( m_pData->sCommand ), UNO_SET_THROW ); | |
| m_pData->bStatementDirty = false; | |
| } | |
| catch( const SQLException& ) | |
| { | |
| throw; | |
| } | |
| catch( const Exception& ) | |
| { | |
| DBG_UNHANDLED_EXCEPTION(); | |
| } | |
| return xResult; | |
| } | |
| //-------------------------------------------------------------------- | |
| bool CachedRowSet::isDirty() const | |
| { | |
| return m_pData->bStatementDirty; | |
| } | |
| //-------------------------------------------------------------------- | |
| void CachedRowSet::dispose() | |
| { | |
| try | |
| { | |
| m_pData.reset( new CachedRowSet_Data( m_pData->aContext ) ); | |
| } | |
| catch( const Exception& ) | |
| { | |
| DBG_UNHANDLED_EXCEPTION(); | |
| } | |
| } | |
| //........................................................................ | |
| } // namespace frm | |
| //........................................................................ |