1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove 25*b1cdbd2cSJim Jagielski #include "precompiled_dbaccess.hxx" 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski #ifndef _DBAUI_INDEXCOLLECTION_HXX_ 28*b1cdbd2cSJim Jagielski #include "indexcollection.hxx" 29*b1cdbd2cSJim Jagielski #endif 30*b1cdbd2cSJim Jagielski #ifndef TOOLS_DIAGNOSE_EX_H 31*b1cdbd2cSJim Jagielski #include <tools/diagnose_ex.h> 32*b1cdbd2cSJim Jagielski #endif 33*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBCX_XAPPEND_HPP_ 34*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XAppend.hpp> 35*b1cdbd2cSJim Jagielski #endif 36*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_BEANS_XPROPERTYSET_HPP_ 37*b1cdbd2cSJim Jagielski #include <com/sun/star/beans/XPropertySet.hpp> 38*b1cdbd2cSJim Jagielski #endif 39*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBCX_XCOLUMNSSUPPLIER_HPP_ 40*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XColumnsSupplier.hpp> 41*b1cdbd2cSJim Jagielski #endif 42*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBCX_XDATADESCRIPTORFACTORY_HPP_ 43*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XDataDescriptorFactory.hpp> 44*b1cdbd2cSJim Jagielski #endif 45*b1cdbd2cSJim Jagielski #ifndef _COMPHELPER_EXTRACT_HXX_ 46*b1cdbd2cSJim Jagielski #include <comphelper/extract.hxx> 47*b1cdbd2cSJim Jagielski #endif 48*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBCX_XDROP_HPP_ 49*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XDrop.hpp> 50*b1cdbd2cSJim Jagielski #endif 51*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_CONTAINER_XNAMECONTAINER_HPP_ 52*b1cdbd2cSJim Jagielski #include <com/sun/star/container/XNameContainer.hpp> 53*b1cdbd2cSJim Jagielski #endif 54*b1cdbd2cSJim Jagielski 55*b1cdbd2cSJim Jagielski //...................................................................... 56*b1cdbd2cSJim Jagielski namespace dbaui 57*b1cdbd2cSJim Jagielski { 58*b1cdbd2cSJim Jagielski //...................................................................... 59*b1cdbd2cSJim Jagielski 60*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno; 61*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::container; 62*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::beans; 63*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbcx; 64*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbc; 65*b1cdbd2cSJim Jagielski 66*b1cdbd2cSJim Jagielski //================================================================== 67*b1cdbd2cSJim Jagielski //= OIndexCollection 68*b1cdbd2cSJim Jagielski //================================================================== 69*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ OIndexCollection()70*b1cdbd2cSJim Jagielski OIndexCollection::OIndexCollection() 71*b1cdbd2cSJim Jagielski { 72*b1cdbd2cSJim Jagielski } 73*b1cdbd2cSJim Jagielski 74*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ OIndexCollection(const OIndexCollection & _rSource)75*b1cdbd2cSJim Jagielski OIndexCollection::OIndexCollection(const OIndexCollection& _rSource) 76*b1cdbd2cSJim Jagielski { 77*b1cdbd2cSJim Jagielski *this = _rSource; 78*b1cdbd2cSJim Jagielski } 79*b1cdbd2cSJim Jagielski 80*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ 81*b1cdbd2cSJim Jagielski // OIndexCollection::OIndexCollection(const Reference< XNameAccess >& _rxIndexes) 82*b1cdbd2cSJim Jagielski // { 83*b1cdbd2cSJim Jagielski // implConstructFrom(_rxIndexes); 84*b1cdbd2cSJim Jagielski // } 85*b1cdbd2cSJim Jagielski 86*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ operator =(const OIndexCollection & _rSource)87*b1cdbd2cSJim Jagielski const OIndexCollection& OIndexCollection::operator=(const OIndexCollection& _rSource) 88*b1cdbd2cSJim Jagielski { 89*b1cdbd2cSJim Jagielski detach(); 90*b1cdbd2cSJim Jagielski m_xIndexes = _rSource.m_xIndexes; 91*b1cdbd2cSJim Jagielski m_aIndexes = _rSource.m_aIndexes; 92*b1cdbd2cSJim Jagielski return *this; 93*b1cdbd2cSJim Jagielski } 94*b1cdbd2cSJim Jagielski 95*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ attach(const Reference<XNameAccess> & _rxIndexes)96*b1cdbd2cSJim Jagielski void OIndexCollection::attach(const Reference< XNameAccess >& _rxIndexes) 97*b1cdbd2cSJim Jagielski { 98*b1cdbd2cSJim Jagielski implConstructFrom(_rxIndexes); 99*b1cdbd2cSJim Jagielski } 100*b1cdbd2cSJim Jagielski 101*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ detach()102*b1cdbd2cSJim Jagielski void OIndexCollection::detach() 103*b1cdbd2cSJim Jagielski { 104*b1cdbd2cSJim Jagielski m_xIndexes.clear(); 105*b1cdbd2cSJim Jagielski m_aIndexes.clear(); 106*b1cdbd2cSJim Jagielski } 107*b1cdbd2cSJim Jagielski 108*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ find(const String & _rName) const109*b1cdbd2cSJim Jagielski Indexes::const_iterator OIndexCollection::find(const String& _rName) const 110*b1cdbd2cSJim Jagielski { 111*b1cdbd2cSJim Jagielski ::rtl::OUString sNameCompare(_rName); 112*b1cdbd2cSJim Jagielski 113*b1cdbd2cSJim Jagielski // loop'n'compare 114*b1cdbd2cSJim Jagielski Indexes::const_iterator aSearch = m_aIndexes.begin(); 115*b1cdbd2cSJim Jagielski Indexes::const_iterator aEnd = m_aIndexes.end(); 116*b1cdbd2cSJim Jagielski for (; aSearch != aEnd; ++aSearch) 117*b1cdbd2cSJim Jagielski if (aSearch->sName == sNameCompare) 118*b1cdbd2cSJim Jagielski break; 119*b1cdbd2cSJim Jagielski 120*b1cdbd2cSJim Jagielski return aSearch; 121*b1cdbd2cSJim Jagielski } 122*b1cdbd2cSJim Jagielski 123*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ find(const String & _rName)124*b1cdbd2cSJim Jagielski Indexes::iterator OIndexCollection::find(const String& _rName) 125*b1cdbd2cSJim Jagielski { 126*b1cdbd2cSJim Jagielski ::rtl::OUString sNameCompare(_rName); 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski // loop'n'compare 129*b1cdbd2cSJim Jagielski Indexes::iterator aSearch = m_aIndexes.begin(); 130*b1cdbd2cSJim Jagielski Indexes::iterator aEnd = m_aIndexes.end(); 131*b1cdbd2cSJim Jagielski for (; aSearch != aEnd; ++aSearch) 132*b1cdbd2cSJim Jagielski if (aSearch->sName == sNameCompare) 133*b1cdbd2cSJim Jagielski break; 134*b1cdbd2cSJim Jagielski 135*b1cdbd2cSJim Jagielski return aSearch; 136*b1cdbd2cSJim Jagielski } 137*b1cdbd2cSJim Jagielski 138*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ findOriginal(const String & _rName) const139*b1cdbd2cSJim Jagielski Indexes::const_iterator OIndexCollection::findOriginal(const String& _rName) const 140*b1cdbd2cSJim Jagielski { 141*b1cdbd2cSJim Jagielski ::rtl::OUString sNameCompare(_rName); 142*b1cdbd2cSJim Jagielski 143*b1cdbd2cSJim Jagielski // loop'n'compare 144*b1cdbd2cSJim Jagielski Indexes::const_iterator aSearch = m_aIndexes.begin(); 145*b1cdbd2cSJim Jagielski Indexes::const_iterator aEnd = m_aIndexes.end(); 146*b1cdbd2cSJim Jagielski for (; aSearch != aEnd; ++aSearch) 147*b1cdbd2cSJim Jagielski if (aSearch->getOriginalName() == sNameCompare) 148*b1cdbd2cSJim Jagielski break; 149*b1cdbd2cSJim Jagielski 150*b1cdbd2cSJim Jagielski return aSearch; 151*b1cdbd2cSJim Jagielski } 152*b1cdbd2cSJim Jagielski 153*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ findOriginal(const String & _rName)154*b1cdbd2cSJim Jagielski Indexes::iterator OIndexCollection::findOriginal(const String& _rName) 155*b1cdbd2cSJim Jagielski { 156*b1cdbd2cSJim Jagielski ::rtl::OUString sNameCompare(_rName); 157*b1cdbd2cSJim Jagielski 158*b1cdbd2cSJim Jagielski // loop'n'compare 159*b1cdbd2cSJim Jagielski Indexes::iterator aSearch = m_aIndexes.begin(); 160*b1cdbd2cSJim Jagielski Indexes::iterator aEnd = m_aIndexes.end(); 161*b1cdbd2cSJim Jagielski for (; aSearch != aEnd; ++aSearch) 162*b1cdbd2cSJim Jagielski if (aSearch->getOriginalName() == sNameCompare) 163*b1cdbd2cSJim Jagielski break; 164*b1cdbd2cSJim Jagielski 165*b1cdbd2cSJim Jagielski return aSearch; 166*b1cdbd2cSJim Jagielski } 167*b1cdbd2cSJim Jagielski 168*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ commitNewIndex(const Indexes::iterator & _rPos)169*b1cdbd2cSJim Jagielski void OIndexCollection::commitNewIndex(const Indexes::iterator& _rPos) SAL_THROW((SQLException)) 170*b1cdbd2cSJim Jagielski { 171*b1cdbd2cSJim Jagielski OSL_ENSURE(_rPos->isNew(), "OIndexCollection::commitNewIndex: index must be new!"); 172*b1cdbd2cSJim Jagielski 173*b1cdbd2cSJim Jagielski try 174*b1cdbd2cSJim Jagielski { 175*b1cdbd2cSJim Jagielski Reference< XDataDescriptorFactory > xIndexFactory(m_xIndexes, UNO_QUERY); 176*b1cdbd2cSJim Jagielski Reference< XAppend > xAppendIndex(xIndexFactory, UNO_QUERY); 177*b1cdbd2cSJim Jagielski if (!xAppendIndex.is()) 178*b1cdbd2cSJim Jagielski { 179*b1cdbd2cSJim Jagielski OSL_ENSURE(sal_False, "OIndexCollection::commitNewIndex: missing an interface of the index container!"); 180*b1cdbd2cSJim Jagielski return; 181*b1cdbd2cSJim Jagielski } 182*b1cdbd2cSJim Jagielski 183*b1cdbd2cSJim Jagielski Reference< XPropertySet > xIndexDescriptor = xIndexFactory->createDataDescriptor(); 184*b1cdbd2cSJim Jagielski Reference< XColumnsSupplier > xColsSupp(xIndexDescriptor, UNO_QUERY); 185*b1cdbd2cSJim Jagielski Reference< XNameAccess > xCols; 186*b1cdbd2cSJim Jagielski if (xColsSupp.is()) 187*b1cdbd2cSJim Jagielski xCols = xColsSupp->getColumns(); 188*b1cdbd2cSJim Jagielski 189*b1cdbd2cSJim Jagielski Reference< XDataDescriptorFactory > xColumnFactory(xCols, UNO_QUERY); 190*b1cdbd2cSJim Jagielski Reference< XAppend > xAppendCols(xColumnFactory, UNO_QUERY); 191*b1cdbd2cSJim Jagielski if (!xAppendCols.is()) 192*b1cdbd2cSJim Jagielski { 193*b1cdbd2cSJim Jagielski OSL_ENSURE(sal_False, "OIndexCollection::commitNewIndex: invalid index descriptor returned!"); 194*b1cdbd2cSJim Jagielski return; 195*b1cdbd2cSJim Jagielski } 196*b1cdbd2cSJim Jagielski 197*b1cdbd2cSJim Jagielski // set the properties 198*b1cdbd2cSJim Jagielski static const ::rtl::OUString s_sUniquePropertyName = ::rtl::OUString::createFromAscii("IsUnique"); 199*b1cdbd2cSJim Jagielski static const ::rtl::OUString s_sSortPropertyName = ::rtl::OUString::createFromAscii("IsAscending"); 200*b1cdbd2cSJim Jagielski static const ::rtl::OUString s_sNamePropertyName = ::rtl::OUString::createFromAscii("Name"); 201*b1cdbd2cSJim Jagielski // the index' own props 202*b1cdbd2cSJim Jagielski xIndexDescriptor->setPropertyValue(s_sUniquePropertyName, ::cppu::bool2any(_rPos->bUnique)); 203*b1cdbd2cSJim Jagielski xIndexDescriptor->setPropertyValue(s_sNamePropertyName, makeAny(_rPos->sName)); 204*b1cdbd2cSJim Jagielski 205*b1cdbd2cSJim Jagielski // the fields 206*b1cdbd2cSJim Jagielski for ( ConstIndexFieldsIterator aFieldLoop = _rPos->aFields.begin(); 207*b1cdbd2cSJim Jagielski aFieldLoop != _rPos->aFields.end(); 208*b1cdbd2cSJim Jagielski ++aFieldLoop 209*b1cdbd2cSJim Jagielski ) 210*b1cdbd2cSJim Jagielski { 211*b1cdbd2cSJim Jagielski OSL_ENSURE(!xCols->hasByName(aFieldLoop->sFieldName), "OIndexCollection::commitNewIndex: double column name (need to prevent this outside)!"); 212*b1cdbd2cSJim Jagielski 213*b1cdbd2cSJim Jagielski Reference< XPropertySet > xColDescriptor = xColumnFactory->createDataDescriptor(); 214*b1cdbd2cSJim Jagielski OSL_ENSURE(xColDescriptor.is(), "OIndexCollection::commitNewIndex: invalid column descriptor!"); 215*b1cdbd2cSJim Jagielski if (xColDescriptor.is()) 216*b1cdbd2cSJim Jagielski { 217*b1cdbd2cSJim Jagielski xColDescriptor->setPropertyValue(s_sSortPropertyName, ::cppu::bool2any(aFieldLoop->bSortAscending)); 218*b1cdbd2cSJim Jagielski xColDescriptor->setPropertyValue(s_sNamePropertyName, makeAny(::rtl::OUString(aFieldLoop->sFieldName))); 219*b1cdbd2cSJim Jagielski xAppendCols->appendByDescriptor(xColDescriptor); 220*b1cdbd2cSJim Jagielski } 221*b1cdbd2cSJim Jagielski } 222*b1cdbd2cSJim Jagielski 223*b1cdbd2cSJim Jagielski xAppendIndex->appendByDescriptor(xIndexDescriptor); 224*b1cdbd2cSJim Jagielski 225*b1cdbd2cSJim Jagielski _rPos->flagAsCommitted(GrantIndexAccess()); 226*b1cdbd2cSJim Jagielski _rPos->clearModified(); 227*b1cdbd2cSJim Jagielski } 228*b1cdbd2cSJim Jagielski catch(SQLException&) 229*b1cdbd2cSJim Jagielski { // allowed to pass 230*b1cdbd2cSJim Jagielski throw; 231*b1cdbd2cSJim Jagielski } 232*b1cdbd2cSJim Jagielski catch( const Exception& ) 233*b1cdbd2cSJim Jagielski { 234*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION(); 235*b1cdbd2cSJim Jagielski } 236*b1cdbd2cSJim Jagielski } 237*b1cdbd2cSJim Jagielski 238*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ dropNoRemove(const Indexes::iterator & _rPos)239*b1cdbd2cSJim Jagielski sal_Bool OIndexCollection::dropNoRemove(const Indexes::iterator& _rPos) SAL_THROW((SQLException)) 240*b1cdbd2cSJim Jagielski { 241*b1cdbd2cSJim Jagielski try 242*b1cdbd2cSJim Jagielski { 243*b1cdbd2cSJim Jagielski OSL_ENSURE(m_xIndexes->hasByName(_rPos->getOriginalName()), "OIndexCollection::drop: invalid name!"); 244*b1cdbd2cSJim Jagielski 245*b1cdbd2cSJim Jagielski Reference< XDrop > xDropIndex(m_xIndexes, UNO_QUERY); 246*b1cdbd2cSJim Jagielski if (!xDropIndex.is()) 247*b1cdbd2cSJim Jagielski { 248*b1cdbd2cSJim Jagielski OSL_ENSURE(sal_False, "OIndexCollection::drop: no XDrop interface!"); 249*b1cdbd2cSJim Jagielski return sal_False; 250*b1cdbd2cSJim Jagielski } 251*b1cdbd2cSJim Jagielski 252*b1cdbd2cSJim Jagielski xDropIndex->dropByName(_rPos->getOriginalName()); 253*b1cdbd2cSJim Jagielski } 254*b1cdbd2cSJim Jagielski catch(SQLException&) 255*b1cdbd2cSJim Jagielski { // allowed to pass 256*b1cdbd2cSJim Jagielski throw; 257*b1cdbd2cSJim Jagielski } 258*b1cdbd2cSJim Jagielski catch( const Exception& ) 259*b1cdbd2cSJim Jagielski { 260*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION(); 261*b1cdbd2cSJim Jagielski return sal_False; 262*b1cdbd2cSJim Jagielski } 263*b1cdbd2cSJim Jagielski 264*b1cdbd2cSJim Jagielski // adjust the OIndex structure 265*b1cdbd2cSJim Jagielski Indexes::iterator aDropped = findOriginal(_rPos->getOriginalName()); 266*b1cdbd2cSJim Jagielski OSL_ENSURE(aDropped != m_aIndexes.end(), "OIndexCollection::drop: invalid original name, but successfull commit?!"); 267*b1cdbd2cSJim Jagielski aDropped->flagAsNew(GrantIndexAccess()); 268*b1cdbd2cSJim Jagielski 269*b1cdbd2cSJim Jagielski return sal_True; 270*b1cdbd2cSJim Jagielski } 271*b1cdbd2cSJim Jagielski 272*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ drop(const Indexes::iterator & _rPos)273*b1cdbd2cSJim Jagielski sal_Bool OIndexCollection::drop(const Indexes::iterator& _rPos) SAL_THROW((SQLException)) 274*b1cdbd2cSJim Jagielski { 275*b1cdbd2cSJim Jagielski OSL_ENSURE((_rPos >= m_aIndexes.begin()) && (_rPos < m_aIndexes.end()), 276*b1cdbd2cSJim Jagielski "OIndexCollection::drop: invalid position (fasten your seatbelt .... this will crash)!"); 277*b1cdbd2cSJim Jagielski 278*b1cdbd2cSJim Jagielski if (!_rPos->isNew()) 279*b1cdbd2cSJim Jagielski if (!dropNoRemove(_rPos)) 280*b1cdbd2cSJim Jagielski return sal_False; 281*b1cdbd2cSJim Jagielski 282*b1cdbd2cSJim Jagielski // adjust the index array 283*b1cdbd2cSJim Jagielski m_aIndexes.erase(_rPos); 284*b1cdbd2cSJim Jagielski return sal_True; 285*b1cdbd2cSJim Jagielski } 286*b1cdbd2cSJim Jagielski 287*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ implFillIndexInfo(OIndex & _rIndex)288*b1cdbd2cSJim Jagielski void OIndexCollection::implFillIndexInfo(OIndex& _rIndex) SAL_THROW((Exception)) 289*b1cdbd2cSJim Jagielski { 290*b1cdbd2cSJim Jagielski // get the UNO descriptor for the index 291*b1cdbd2cSJim Jagielski Reference< XPropertySet > xIndex; 292*b1cdbd2cSJim Jagielski m_xIndexes->getByName(_rIndex.getOriginalName()) >>= xIndex; 293*b1cdbd2cSJim Jagielski if (!xIndex.is()) 294*b1cdbd2cSJim Jagielski { 295*b1cdbd2cSJim Jagielski OSL_ENSURE(sal_False, "OIndexCollection::implFillIndexInfo: got an invalid index object!"); 296*b1cdbd2cSJim Jagielski } 297*b1cdbd2cSJim Jagielski else 298*b1cdbd2cSJim Jagielski implFillIndexInfo(_rIndex, xIndex); 299*b1cdbd2cSJim Jagielski } 300*b1cdbd2cSJim Jagielski 301*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ implFillIndexInfo(OIndex & _rIndex,Reference<XPropertySet> _rxDescriptor)302*b1cdbd2cSJim Jagielski void OIndexCollection::implFillIndexInfo(OIndex& _rIndex, Reference< XPropertySet > _rxDescriptor) SAL_THROW((Exception)) 303*b1cdbd2cSJim Jagielski { 304*b1cdbd2cSJim Jagielski static const ::rtl::OUString s_sPrimaryIndexPropertyName = ::rtl::OUString::createFromAscii("IsPrimaryKeyIndex"); 305*b1cdbd2cSJim Jagielski static const ::rtl::OUString s_sUniquePropertyName = ::rtl::OUString::createFromAscii("IsUnique"); 306*b1cdbd2cSJim Jagielski static const ::rtl::OUString s_sSortPropertyName = ::rtl::OUString::createFromAscii("IsAscending"); 307*b1cdbd2cSJim Jagielski static const ::rtl::OUString s_sCatalogPropertyName = ::rtl::OUString::createFromAscii("Catalog"); 308*b1cdbd2cSJim Jagielski 309*b1cdbd2cSJim Jagielski _rIndex.bPrimaryKey = ::cppu::any2bool(_rxDescriptor->getPropertyValue(s_sPrimaryIndexPropertyName)); 310*b1cdbd2cSJim Jagielski _rIndex.bUnique = ::cppu::any2bool(_rxDescriptor->getPropertyValue(s_sUniquePropertyName)); 311*b1cdbd2cSJim Jagielski _rxDescriptor->getPropertyValue(s_sCatalogPropertyName) >>= _rIndex.sDescription; 312*b1cdbd2cSJim Jagielski 313*b1cdbd2cSJim Jagielski // the columns 314*b1cdbd2cSJim Jagielski Reference< XColumnsSupplier > xSuppCols(_rxDescriptor, UNO_QUERY); 315*b1cdbd2cSJim Jagielski Reference< XNameAccess > xCols; 316*b1cdbd2cSJim Jagielski if (xSuppCols.is()) 317*b1cdbd2cSJim Jagielski xCols = xSuppCols->getColumns(); 318*b1cdbd2cSJim Jagielski OSL_ENSURE(xCols.is(), "OIndexCollection::implFillIndexInfo: the index does not have columns!"); 319*b1cdbd2cSJim Jagielski if (xCols.is()) 320*b1cdbd2cSJim Jagielski { 321*b1cdbd2cSJim Jagielski Sequence< ::rtl::OUString > aFieldNames = xCols->getElementNames(); 322*b1cdbd2cSJim Jagielski _rIndex.aFields.resize(aFieldNames.getLength()); 323*b1cdbd2cSJim Jagielski 324*b1cdbd2cSJim Jagielski const ::rtl::OUString* pFieldNames = aFieldNames.getConstArray(); 325*b1cdbd2cSJim Jagielski const ::rtl::OUString* pFieldNamesEnd = pFieldNames + aFieldNames.getLength(); 326*b1cdbd2cSJim Jagielski IndexFields::iterator aCopyTo = _rIndex.aFields.begin(); 327*b1cdbd2cSJim Jagielski 328*b1cdbd2cSJim Jagielski Reference< XPropertySet > xIndexColumn; 329*b1cdbd2cSJim Jagielski for (;pFieldNames < pFieldNamesEnd; ++pFieldNames, ++aCopyTo) 330*b1cdbd2cSJim Jagielski { 331*b1cdbd2cSJim Jagielski // extract the column 332*b1cdbd2cSJim Jagielski xIndexColumn.clear(); 333*b1cdbd2cSJim Jagielski xCols->getByName(*pFieldNames) >>= xIndexColumn; 334*b1cdbd2cSJim Jagielski if (!xIndexColumn.is()) 335*b1cdbd2cSJim Jagielski { 336*b1cdbd2cSJim Jagielski OSL_ENSURE(sal_False, "OIndexCollection::implFillIndexInfo: invalid index column!"); 337*b1cdbd2cSJim Jagielski --aCopyTo; 338*b1cdbd2cSJim Jagielski continue; 339*b1cdbd2cSJim Jagielski } 340*b1cdbd2cSJim Jagielski 341*b1cdbd2cSJim Jagielski // get the relevant properties 342*b1cdbd2cSJim Jagielski aCopyTo->sFieldName = *pFieldNames; 343*b1cdbd2cSJim Jagielski aCopyTo->bSortAscending = ::cppu::any2bool(xIndexColumn->getPropertyValue(s_sSortPropertyName)); 344*b1cdbd2cSJim Jagielski } 345*b1cdbd2cSJim Jagielski 346*b1cdbd2cSJim Jagielski _rIndex.aFields.resize(aCopyTo - _rIndex.aFields.begin()); 347*b1cdbd2cSJim Jagielski // (just in case some fields were invalid ...) 348*b1cdbd2cSJim Jagielski } 349*b1cdbd2cSJim Jagielski } 350*b1cdbd2cSJim Jagielski 351*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ resetIndex(const Indexes::iterator & _rPos)352*b1cdbd2cSJim Jagielski void OIndexCollection::resetIndex(const Indexes::iterator& _rPos) SAL_THROW((SQLException)) 353*b1cdbd2cSJim Jagielski { 354*b1cdbd2cSJim Jagielski OSL_ENSURE(_rPos >= m_aIndexes.begin() && _rPos < m_aIndexes.end(), 355*b1cdbd2cSJim Jagielski "OIndexCollection::resetIndex: invalid position!"); 356*b1cdbd2cSJim Jagielski 357*b1cdbd2cSJim Jagielski try 358*b1cdbd2cSJim Jagielski { 359*b1cdbd2cSJim Jagielski _rPos->sName = _rPos->getOriginalName(); 360*b1cdbd2cSJim Jagielski implFillIndexInfo(*_rPos); 361*b1cdbd2cSJim Jagielski 362*b1cdbd2cSJim Jagielski _rPos->clearModified(); 363*b1cdbd2cSJim Jagielski _rPos->flagAsCommitted(GrantIndexAccess()); 364*b1cdbd2cSJim Jagielski } 365*b1cdbd2cSJim Jagielski catch(SQLException&) 366*b1cdbd2cSJim Jagielski { // allowed to pass 367*b1cdbd2cSJim Jagielski throw; 368*b1cdbd2cSJim Jagielski } 369*b1cdbd2cSJim Jagielski catch( const Exception& ) 370*b1cdbd2cSJim Jagielski { 371*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION(); 372*b1cdbd2cSJim Jagielski } 373*b1cdbd2cSJim Jagielski } 374*b1cdbd2cSJim Jagielski 375*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ insert(const String & _rName)376*b1cdbd2cSJim Jagielski Indexes::iterator OIndexCollection::insert(const String& _rName) 377*b1cdbd2cSJim Jagielski { 378*b1cdbd2cSJim Jagielski OSL_ENSURE(end() == find(_rName), "OIndexCollection::insert: invalid new name!"); 379*b1cdbd2cSJim Jagielski String tmpName; 380*b1cdbd2cSJim Jagielski OIndex aNewIndex(tmpName); // the empty string indicates the index is a new one 381*b1cdbd2cSJim Jagielski aNewIndex.sName = _rName; 382*b1cdbd2cSJim Jagielski m_aIndexes.push_back(aNewIndex); 383*b1cdbd2cSJim Jagielski return m_aIndexes.end() - 1; // the last element is the new one ... 384*b1cdbd2cSJim Jagielski } 385*b1cdbd2cSJim Jagielski 386*b1cdbd2cSJim Jagielski //------------------------------------------------------------------ implConstructFrom(const Reference<XNameAccess> & _rxIndexes)387*b1cdbd2cSJim Jagielski void OIndexCollection::implConstructFrom(const Reference< XNameAccess >& _rxIndexes) 388*b1cdbd2cSJim Jagielski { 389*b1cdbd2cSJim Jagielski detach(); 390*b1cdbd2cSJim Jagielski 391*b1cdbd2cSJim Jagielski m_xIndexes = _rxIndexes; 392*b1cdbd2cSJim Jagielski if (m_xIndexes.is()) 393*b1cdbd2cSJim Jagielski { 394*b1cdbd2cSJim Jagielski // loop through all the indexes 395*b1cdbd2cSJim Jagielski Sequence< ::rtl::OUString > aNames = m_xIndexes->getElementNames(); 396*b1cdbd2cSJim Jagielski const ::rtl::OUString* pNames = aNames.getConstArray(); 397*b1cdbd2cSJim Jagielski const ::rtl::OUString* pEnd = pNames + aNames.getLength(); 398*b1cdbd2cSJim Jagielski for (; pNames < pEnd; ++pNames) 399*b1cdbd2cSJim Jagielski { 400*b1cdbd2cSJim Jagielski // extract the index object 401*b1cdbd2cSJim Jagielski Reference< XPropertySet > xIndex; 402*b1cdbd2cSJim Jagielski m_xIndexes->getByName(*pNames) >>= xIndex; 403*b1cdbd2cSJim Jagielski if (!xIndex.is()) 404*b1cdbd2cSJim Jagielski { 405*b1cdbd2cSJim Jagielski OSL_ENSURE(sal_False, "OIndexCollection::implConstructFrom: got an invalid index object ... ignoring!"); 406*b1cdbd2cSJim Jagielski continue; 407*b1cdbd2cSJim Jagielski } 408*b1cdbd2cSJim Jagielski 409*b1cdbd2cSJim Jagielski // fill the OIndex structure 410*b1cdbd2cSJim Jagielski OIndex aCurrentIndex(*pNames); 411*b1cdbd2cSJim Jagielski implFillIndexInfo(aCurrentIndex); 412*b1cdbd2cSJim Jagielski m_aIndexes.push_back(aCurrentIndex); 413*b1cdbd2cSJim Jagielski } 414*b1cdbd2cSJim Jagielski } 415*b1cdbd2cSJim Jagielski } 416*b1cdbd2cSJim Jagielski 417*b1cdbd2cSJim Jagielski //...................................................................... 418*b1cdbd2cSJim Jagielski } // namespace dbaui 419*b1cdbd2cSJim Jagielski //...................................................................... 420*b1cdbd2cSJim Jagielski 421