1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove 29*cdf0e10cSrcweir #include "precompiled_connectivity.hxx" 30*cdf0e10cSrcweir #include <com/sun/star/sdbcx/CompareBookmark.hpp> 31*cdf0e10cSrcweir #include "calc/CResultSet.hxx" 32*cdf0e10cSrcweir #include <com/sun/star/lang/DisposedException.hpp> 33*cdf0e10cSrcweir #include <comphelper/sequence.hxx> 34*cdf0e10cSrcweir #include <comphelper/types.hxx> 35*cdf0e10cSrcweir #include <connectivity/dbexception.hxx> 36*cdf0e10cSrcweir 37*cdf0e10cSrcweir using namespace ::comphelper; 38*cdf0e10cSrcweir using namespace connectivity::calc; 39*cdf0e10cSrcweir using namespace connectivity::file; 40*cdf0e10cSrcweir using namespace ::cppu; 41*cdf0e10cSrcweir using namespace com::sun::star::uno; 42*cdf0e10cSrcweir using namespace com::sun::star::lang; 43*cdf0e10cSrcweir using namespace com::sun::star::beans; 44*cdf0e10cSrcweir using namespace com::sun::star::sdbc; 45*cdf0e10cSrcweir using namespace com::sun::star::sdbcx; 46*cdf0e10cSrcweir // using namespace com::sun::star::container; 47*cdf0e10cSrcweir // using namespace com::sun::star::util; 48*cdf0e10cSrcweir //------------------------------------------------------------------------------ 49*cdf0e10cSrcweir OCalcResultSet::OCalcResultSet( OStatement_Base* pStmt,connectivity::OSQLParseTreeIterator& _aSQLIterator) 50*cdf0e10cSrcweir : file::OResultSet(pStmt,_aSQLIterator) 51*cdf0e10cSrcweir ,m_bBookmarkable(sal_True) 52*cdf0e10cSrcweir { 53*cdf0e10cSrcweir registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISBOOKMARKABLE), PROPERTY_ID_ISBOOKMARKABLE, PropertyAttribute::READONLY,&m_bBookmarkable, ::getBooleanCppuType()); 54*cdf0e10cSrcweir } 55*cdf0e10cSrcweir // ------------------------------------------------------------------------- 56*cdf0e10cSrcweir ::rtl::OUString SAL_CALL OCalcResultSet::getImplementationName( ) throw ( RuntimeException) 57*cdf0e10cSrcweir { 58*cdf0e10cSrcweir return ::rtl::OUString::createFromAscii("com.sun.star.sdbcx.calc.ResultSet"); 59*cdf0e10cSrcweir } 60*cdf0e10cSrcweir // ------------------------------------------------------------------------- 61*cdf0e10cSrcweir Sequence< ::rtl::OUString > SAL_CALL OCalcResultSet::getSupportedServiceNames( ) throw( RuntimeException) 62*cdf0e10cSrcweir { 63*cdf0e10cSrcweir Sequence< ::rtl::OUString > aSupported(2); 64*cdf0e10cSrcweir aSupported[0] = ::rtl::OUString::createFromAscii("com.sun.star.sdbc.ResultSet"); 65*cdf0e10cSrcweir aSupported[1] = ::rtl::OUString::createFromAscii("com.sun.star.sdbcx.ResultSet"); 66*cdf0e10cSrcweir return aSupported; 67*cdf0e10cSrcweir } 68*cdf0e10cSrcweir // ------------------------------------------------------------------------- 69*cdf0e10cSrcweir sal_Bool SAL_CALL OCalcResultSet::supportsService( const ::rtl::OUString& _rServiceName ) throw( RuntimeException) 70*cdf0e10cSrcweir { 71*cdf0e10cSrcweir Sequence< ::rtl::OUString > aSupported(getSupportedServiceNames()); 72*cdf0e10cSrcweir const ::rtl::OUString* pSupported = aSupported.getConstArray(); 73*cdf0e10cSrcweir const ::rtl::OUString* pEnd = pSupported + aSupported.getLength(); 74*cdf0e10cSrcweir for (;pSupported != pEnd && !pSupported->equals(_rServiceName); ++pSupported) 75*cdf0e10cSrcweir ; 76*cdf0e10cSrcweir 77*cdf0e10cSrcweir return pSupported != pEnd; 78*cdf0e10cSrcweir } 79*cdf0e10cSrcweir // ------------------------------------------------------------------------- 80*cdf0e10cSrcweir Any SAL_CALL OCalcResultSet::queryInterface( const Type & rType ) throw(RuntimeException) 81*cdf0e10cSrcweir { 82*cdf0e10cSrcweir Any aRet = OResultSet::queryInterface(rType); 83*cdf0e10cSrcweir return aRet.hasValue() ? aRet : OCalcResultSet_BASE::queryInterface(rType); 84*cdf0e10cSrcweir } 85*cdf0e10cSrcweir // ------------------------------------------------------------------------- 86*cdf0e10cSrcweir Sequence< Type > SAL_CALL OCalcResultSet::getTypes( ) throw( RuntimeException) 87*cdf0e10cSrcweir { 88*cdf0e10cSrcweir return ::comphelper::concatSequences(OResultSet::getTypes(),OCalcResultSet_BASE::getTypes()); 89*cdf0e10cSrcweir } 90*cdf0e10cSrcweir 91*cdf0e10cSrcweir // ------------------------------------------------------------------------- 92*cdf0e10cSrcweir // XRowLocate 93*cdf0e10cSrcweir Any SAL_CALL OCalcResultSet::getBookmark( ) throw( SQLException, RuntimeException) 94*cdf0e10cSrcweir { 95*cdf0e10cSrcweir ::osl::MutexGuard aGuard( m_aMutex ); 96*cdf0e10cSrcweir checkDisposed(OResultSet_BASE::rBHelper.bDisposed); 97*cdf0e10cSrcweir 98*cdf0e10cSrcweir 99*cdf0e10cSrcweir return makeAny((sal_Int32)(m_aRow->get())[0]->getValue()); 100*cdf0e10cSrcweir } 101*cdf0e10cSrcweir // ------------------------------------------------------------------------- 102*cdf0e10cSrcweir sal_Bool SAL_CALL OCalcResultSet::moveToBookmark( const Any& bookmark ) throw( SQLException, RuntimeException) 103*cdf0e10cSrcweir { 104*cdf0e10cSrcweir ::osl::MutexGuard aGuard( m_aMutex ); 105*cdf0e10cSrcweir checkDisposed(OResultSet_BASE::rBHelper.bDisposed); 106*cdf0e10cSrcweir 107*cdf0e10cSrcweir 108*cdf0e10cSrcweir m_bRowDeleted = m_bRowInserted = m_bRowUpdated = sal_False; 109*cdf0e10cSrcweir 110*cdf0e10cSrcweir return Move(IResultSetHelper::BOOKMARK,comphelper::getINT32(bookmark),sal_True); 111*cdf0e10cSrcweir } 112*cdf0e10cSrcweir // ------------------------------------------------------------------------- 113*cdf0e10cSrcweir sal_Bool SAL_CALL OCalcResultSet::moveRelativeToBookmark( const Any& bookmark, sal_Int32 rows ) throw( SQLException, RuntimeException) 114*cdf0e10cSrcweir { 115*cdf0e10cSrcweir ::osl::MutexGuard aGuard( m_aMutex ); 116*cdf0e10cSrcweir checkDisposed(OResultSet_BASE::rBHelper.bDisposed); 117*cdf0e10cSrcweir 118*cdf0e10cSrcweir 119*cdf0e10cSrcweir m_bRowDeleted = m_bRowInserted = m_bRowUpdated = sal_False; 120*cdf0e10cSrcweir 121*cdf0e10cSrcweir Move(IResultSetHelper::BOOKMARK,comphelper::getINT32(bookmark),sal_False); 122*cdf0e10cSrcweir 123*cdf0e10cSrcweir return relative(rows); 124*cdf0e10cSrcweir } 125*cdf0e10cSrcweir 126*cdf0e10cSrcweir // ------------------------------------------------------------------------- 127*cdf0e10cSrcweir sal_Int32 SAL_CALL OCalcResultSet::compareBookmarks( const Any& lhs, const Any& rhs ) throw( SQLException, RuntimeException) 128*cdf0e10cSrcweir { 129*cdf0e10cSrcweir return (lhs == rhs) ? 0 : 2; 130*cdf0e10cSrcweir } 131*cdf0e10cSrcweir // ------------------------------------------------------------------------- 132*cdf0e10cSrcweir sal_Bool SAL_CALL OCalcResultSet::hasOrderedBookmarks( ) throw( SQLException, RuntimeException) 133*cdf0e10cSrcweir { 134*cdf0e10cSrcweir return sal_True; 135*cdf0e10cSrcweir } 136*cdf0e10cSrcweir // ------------------------------------------------------------------------- 137*cdf0e10cSrcweir sal_Int32 SAL_CALL OCalcResultSet::hashBookmark( const Any& bookmark ) throw( SQLException, RuntimeException) 138*cdf0e10cSrcweir { 139*cdf0e10cSrcweir ::osl::MutexGuard aGuard( m_aMutex ); 140*cdf0e10cSrcweir checkDisposed(OResultSet_BASE::rBHelper.bDisposed); 141*cdf0e10cSrcweir 142*cdf0e10cSrcweir 143*cdf0e10cSrcweir return comphelper::getINT32(bookmark); 144*cdf0e10cSrcweir } 145*cdf0e10cSrcweir // ------------------------------------------------------------------------- 146*cdf0e10cSrcweir // XDeleteRows 147*cdf0e10cSrcweir Sequence< sal_Int32 > SAL_CALL OCalcResultSet::deleteRows( const Sequence< Any >& /*rows*/ ) throw( SQLException, RuntimeException) 148*cdf0e10cSrcweir { 149*cdf0e10cSrcweir ::osl::MutexGuard aGuard( m_aMutex ); 150*cdf0e10cSrcweir checkDisposed(OResultSet_BASE::rBHelper.bDisposed); 151*cdf0e10cSrcweir 152*cdf0e10cSrcweir ::dbtools::throwFeatureNotImplementedException( "XDeleteRows::deleteRows", *this ); 153*cdf0e10cSrcweir return Sequence< sal_Int32 >(); 154*cdf0e10cSrcweir } 155*cdf0e10cSrcweir // ------------------------------------------------------------------------- 156*cdf0e10cSrcweir sal_Bool OCalcResultSet::fillIndexValues(const Reference< XColumnsSupplier> &/*_xIndex*/) 157*cdf0e10cSrcweir { 158*cdf0e10cSrcweir // Calc table has no index 159*cdf0e10cSrcweir return sal_False; 160*cdf0e10cSrcweir } 161*cdf0e10cSrcweir // ------------------------------------------------------------------------- 162*cdf0e10cSrcweir ::cppu::IPropertyArrayHelper & OCalcResultSet::getInfoHelper() 163*cdf0e10cSrcweir { 164*cdf0e10cSrcweir return *OCalcResultSet_BASE3::getArrayHelper(); 165*cdf0e10cSrcweir } 166*cdf0e10cSrcweir // ----------------------------------------------------------------------------- 167*cdf0e10cSrcweir ::cppu::IPropertyArrayHelper* OCalcResultSet::createArrayHelper() const 168*cdf0e10cSrcweir { 169*cdf0e10cSrcweir Sequence< Property > aProps; 170*cdf0e10cSrcweir describeProperties(aProps); 171*cdf0e10cSrcweir return new ::cppu::OPropertyArrayHelper(aProps); 172*cdf0e10cSrcweir } 173*cdf0e10cSrcweir // ------------------------------------------------------------------------- 174*cdf0e10cSrcweir // ----------------------------------------------------------------------------- 175*cdf0e10cSrcweir void SAL_CALL OCalcResultSet::acquire() throw() 176*cdf0e10cSrcweir { 177*cdf0e10cSrcweir OCalcResultSet_BASE2::acquire(); 178*cdf0e10cSrcweir } 179*cdf0e10cSrcweir // ----------------------------------------------------------------------------- 180*cdf0e10cSrcweir void SAL_CALL OCalcResultSet::release() throw() 181*cdf0e10cSrcweir { 182*cdf0e10cSrcweir OCalcResultSet_BASE2::release(); 183*cdf0e10cSrcweir } 184*cdf0e10cSrcweir // ----------------------------------------------------------------------------- 185*cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySetInfo > SAL_CALL OCalcResultSet::getPropertySetInfo( ) throw(::com::sun::star::uno::RuntimeException) 186*cdf0e10cSrcweir { 187*cdf0e10cSrcweir return ::cppu::OPropertySetHelper::createPropertySetInfo(getInfoHelper()); 188*cdf0e10cSrcweir } 189*cdf0e10cSrcweir // ----------------------------------------------------------------------------- 190*cdf0e10cSrcweir 191*cdf0e10cSrcweir 192