xref: /trunk/main/connectivity/source/commontools/TSkipDeletedSet.cxx (revision cf6516809c57e1bb0a940545cca99cdad54d4ce2)
19b5730f6SAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
39b5730f6SAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
49b5730f6SAndrew Rist  * or more contributor license agreements.  See the NOTICE file
59b5730f6SAndrew Rist  * distributed with this work for additional information
69b5730f6SAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
79b5730f6SAndrew Rist  * to you under the Apache License, Version 2.0 (the
89b5730f6SAndrew Rist  * "License"); you may not use this file except in compliance
99b5730f6SAndrew Rist  * with the License.  You may obtain a copy of the License at
10cdf0e10cSrcweir  *
119b5730f6SAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12cdf0e10cSrcweir  *
139b5730f6SAndrew Rist  * Unless required by applicable law or agreed to in writing,
149b5730f6SAndrew Rist  * software distributed under the License is distributed on an
159b5730f6SAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
169b5730f6SAndrew Rist  * KIND, either express or implied.  See the License for the
179b5730f6SAndrew Rist  * specific language governing permissions and limitations
189b5730f6SAndrew Rist  * under the License.
19cdf0e10cSrcweir  *
209b5730f6SAndrew Rist  *************************************************************/
219b5730f6SAndrew Rist 
229b5730f6SAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_connectivity.hxx"
26cdf0e10cSrcweir #include "TSkipDeletedSet.hxx"
27cdf0e10cSrcweir #include <osl/diagnose.h>
28cdf0e10cSrcweir #include <rtl/logfile.hxx>
2982c0ddf2SHerbert Dürr #include <algorithm>
30cdf0e10cSrcweir 
31cdf0e10cSrcweir using namespace connectivity;
32cdf0e10cSrcweir // -----------------------------------------------------------------------------
OSkipDeletedSet(IResultSetHelper * _pHelper)33cdf0e10cSrcweir OSkipDeletedSet::OSkipDeletedSet(IResultSetHelper* _pHelper)
34cdf0e10cSrcweir     : m_pHelper(_pHelper)
35cdf0e10cSrcweir     ,m_bDeletedVisible(false)
36cdf0e10cSrcweir {
37cdf0e10cSrcweir     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "commontools", "Ocke.Janssen@sun.com", "OSkipDeletedSet::OSkipDeletedSet" );
38cdf0e10cSrcweir     m_aBookmarksPositions.reserve(256);
39cdf0e10cSrcweir }
40cdf0e10cSrcweir // -----------------------------------------------------------------------------
~OSkipDeletedSet()41cdf0e10cSrcweir OSkipDeletedSet::~OSkipDeletedSet()
42cdf0e10cSrcweir {
43cdf0e10cSrcweir     m_aBookmarksPositions.clear();
44cdf0e10cSrcweir     //m_aBookmarks.clear();
45cdf0e10cSrcweir }
46cdf0e10cSrcweir // -----------------------------------------------------------------------------
skipDeleted(IResultSetHelper::Movement _eCursorPosition,sal_Int32 _nOffset,sal_Bool _bRetrieveData)47cdf0e10cSrcweir sal_Bool OSkipDeletedSet::skipDeleted(IResultSetHelper::Movement _eCursorPosition, sal_Int32 _nOffset, sal_Bool _bRetrieveData)
48cdf0e10cSrcweir {
49cdf0e10cSrcweir     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "commontools", "Ocke.Janssen@sun.com", "OSkipDeletedSet::skipDeleted" );
50cdf0e10cSrcweir     OSL_ENSURE(_eCursorPosition != IResultSetHelper::BOOKMARK,"OSkipDeletedSet::SkipDeleted can't be called for BOOKMARK");
51cdf0e10cSrcweir 
52cdf0e10cSrcweir     IResultSetHelper::Movement eDelPosition = _eCursorPosition;
53cdf0e10cSrcweir     sal_Int32 nDelOffset = abs(_nOffset);
54cdf0e10cSrcweir 
55cdf0e10cSrcweir     switch (_eCursorPosition)
56cdf0e10cSrcweir     {
57cdf0e10cSrcweir         case IResultSetHelper::ABSOLUTE:
58cdf0e10cSrcweir             return moveAbsolute(_nOffset,_bRetrieveData);
59cdf0e10cSrcweir         case IResultSetHelper::FIRST:                   // set the movement when positioning failed
60cdf0e10cSrcweir             eDelPosition = IResultSetHelper::NEXT;
61cdf0e10cSrcweir             nDelOffset = 1;
62cdf0e10cSrcweir             break;
63cdf0e10cSrcweir         case IResultSetHelper::LAST:
64*07a3d7f1SPedro Giffuni             eDelPosition = IResultSetHelper::PRIOR; // last row is invalid so position before
65cdf0e10cSrcweir             nDelOffset = 1;
66cdf0e10cSrcweir             break;
67cdf0e10cSrcweir         case IResultSetHelper::RELATIVE:
68cdf0e10cSrcweir             eDelPosition = (_nOffset >= 0) ? IResultSetHelper::NEXT : IResultSetHelper::PRIOR;
69cdf0e10cSrcweir             break;
70cdf0e10cSrcweir         default:
71cdf0e10cSrcweir             break;
72cdf0e10cSrcweir     }
73cdf0e10cSrcweir 
74cdf0e10cSrcweir     sal_Bool bDone          = sal_True;
75cdf0e10cSrcweir     sal_Bool bDataFound     = sal_False;
76cdf0e10cSrcweir 
77cdf0e10cSrcweir     if (_eCursorPosition == IResultSetHelper::LAST)
78cdf0e10cSrcweir     {
79cdf0e10cSrcweir         RTL_LOGFILE_CONTEXT_TRACE( aLogger, "OSkipDeletedSet::skipDeleted: last" );
80cdf0e10cSrcweir         sal_Int32 nBookmark = 0;
81cdf0e10cSrcweir         // first position on the last known row
82cdf0e10cSrcweir         if ( m_aBookmarksPositions.empty() )
83cdf0e10cSrcweir         {
84cdf0e10cSrcweir             bDataFound = m_pHelper->move(IResultSetHelper::FIRST, 0, _bRetrieveData);
85cdf0e10cSrcweir             if(bDataFound && (m_bDeletedVisible || !m_pHelper->isRowDeleted()))
86cdf0e10cSrcweir                 //m_aBookmarksPositions.push_back(m_aBookmarks.insert(TInt2IntMap::value_type(m_pHelper->getDriverPos(),m_aBookmarksPositions.size()+1)).first);
87cdf0e10cSrcweir                 m_aBookmarksPositions.push_back(m_pHelper->getDriverPos());
88cdf0e10cSrcweir         }
89cdf0e10cSrcweir         else
90cdf0e10cSrcweir         {
91cdf0e10cSrcweir             // I already have a bookmark so we can positioned on that and look if it is the last one
92cdf0e10cSrcweir             nBookmark = (*m_aBookmarksPositions.rbegin())/*->first*/;
93cdf0e10cSrcweir 
94cdf0e10cSrcweir             bDataFound = m_pHelper->move(IResultSetHelper::BOOKMARK, nBookmark, _bRetrieveData);
95cdf0e10cSrcweir             OSL_ENSURE((m_bDeletedVisible || !m_pHelper->isRowDeleted()),"A bookmark should not be deleted!");
96cdf0e10cSrcweir         }
97cdf0e10cSrcweir 
98cdf0e10cSrcweir 
99cdf0e10cSrcweir         // and than move forward until we are after the last row
100cdf0e10cSrcweir         while(bDataFound)
101cdf0e10cSrcweir         {
102cdf0e10cSrcweir             bDataFound = m_pHelper->move(IResultSetHelper::NEXT, 1, sal_False); // we don't need the data here
103cdf0e10cSrcweir             if( bDataFound && ( m_bDeletedVisible || !m_pHelper->isRowDeleted()) )
104cdf0e10cSrcweir             {   // we weren't on the last row we remember it and move on
105cdf0e10cSrcweir                 m_aBookmarksPositions.push_back(m_pHelper->getDriverPos());
106cdf0e10cSrcweir                 //m_aBookmarksPositions.push_back(m_aBookmarks.insert(TInt2IntMap::value_type(m_pHelper->getDriverPos(),m_aBookmarksPositions.size()+1)).first);
107cdf0e10cSrcweir             }
108cdf0e10cSrcweir             else if(!bDataFound && !m_aBookmarksPositions.empty() )
109cdf0e10cSrcweir             {
110cdf0e10cSrcweir                 // i already know the last bookmark :-)
111cdf0e10cSrcweir                 // now we only have to repositioning us to the last row
112cdf0e10cSrcweir                 nBookmark = (*m_aBookmarksPositions.rbegin())/*->first*/;
113cdf0e10cSrcweir                 bDataFound = m_pHelper->move(IResultSetHelper::BOOKMARK, nBookmark, _bRetrieveData);
114cdf0e10cSrcweir                 break;
115cdf0e10cSrcweir             }
116cdf0e10cSrcweir         }
117cdf0e10cSrcweir         return bDataFound;
118cdf0e10cSrcweir     }
119cdf0e10cSrcweir     else if (_eCursorPosition != IResultSetHelper::RELATIVE)
120cdf0e10cSrcweir     {
121cdf0e10cSrcweir         bDataFound = m_pHelper->move(_eCursorPosition, _nOffset, _bRetrieveData);
122cdf0e10cSrcweir         bDone = bDataFound && (m_bDeletedVisible || !m_pHelper->isRowDeleted());
123cdf0e10cSrcweir     }
124cdf0e10cSrcweir     else
125cdf0e10cSrcweir     {
126cdf0e10cSrcweir         bDataFound = m_pHelper->move(eDelPosition, 1, _bRetrieveData);
127cdf0e10cSrcweir         if (bDataFound && (m_bDeletedVisible || !m_pHelper->isRowDeleted()))
128cdf0e10cSrcweir         {
129cdf0e10cSrcweir             bDone = (--nDelOffset) == 0;
130cdf0e10cSrcweir             if ( !bDone )
131cdf0e10cSrcweir                 m_aBookmarksPositions.push_back(m_pHelper->getDriverPos());
132cdf0e10cSrcweir             //m_aBookmarksPositions.push_back(m_aBookmarks.insert(TInt2IntMap::value_type(m_pHelper->getDriverPos(),m_aBookmarksPositions.size()+1)).first);
133cdf0e10cSrcweir         }
134cdf0e10cSrcweir         else
135cdf0e10cSrcweir             bDone = sal_False;
136cdf0e10cSrcweir     }
137cdf0e10cSrcweir 
138cdf0e10cSrcweir     while (bDataFound && !bDone)            // solange iterieren bis man auf einem gueltigen Satz ist
139cdf0e10cSrcweir     {
140cdf0e10cSrcweir         bDataFound = m_pHelper->move(eDelPosition, 1, _bRetrieveData);
141cdf0e10cSrcweir         if (_eCursorPosition != IResultSetHelper::RELATIVE)
142cdf0e10cSrcweir             bDone = bDataFound && (m_bDeletedVisible || !m_pHelper->isRowDeleted());
143cdf0e10cSrcweir         else if (bDataFound && (m_bDeletedVisible || !m_pHelper->isRowDeleted()))
144cdf0e10cSrcweir         {
145cdf0e10cSrcweir             bDone = (--nDelOffset) == 0;
146cdf0e10cSrcweir             if ( !bDone )
147cdf0e10cSrcweir                 m_aBookmarksPositions.push_back(m_pHelper->getDriverPos());
148cdf0e10cSrcweir             //m_aBookmarksPositions.push_back(m_aBookmarks.insert(TInt2IntMap::value_type(m_pHelper->getDriverPos(),m_aBookmarksPositions.size()+1)).first);
149cdf0e10cSrcweir         }
150cdf0e10cSrcweir         else
151cdf0e10cSrcweir             bDone = sal_False;
152cdf0e10cSrcweir     }
153cdf0e10cSrcweir 
154cdf0e10cSrcweir     if(bDataFound && bDone)
155cdf0e10cSrcweir     {
156cdf0e10cSrcweir         const sal_Int32 nDriverPos = m_pHelper->getDriverPos();
157cdf0e10cSrcweir         if ( m_bDeletedVisible )
158cdf0e10cSrcweir         {
159cdf0e10cSrcweir             if ( nDriverPos > (sal_Int32)m_aBookmarksPositions.size() )
160cdf0e10cSrcweir                 m_aBookmarksPositions.push_back(nDriverPos);
161cdf0e10cSrcweir         }
162cdf0e10cSrcweir         else if ( ::std::find(m_aBookmarksPositions.begin(),m_aBookmarksPositions.end(),nDriverPos) == m_aBookmarksPositions.end() )
163cdf0e10cSrcweir             m_aBookmarksPositions.push_back(nDriverPos);
164cdf0e10cSrcweir         /*sal_Int32 nDriverPos = m_pHelper->getDriverPos();
165cdf0e10cSrcweir         if(m_aBookmarks.find(nDriverPos) == m_aBookmarks.end())
166cdf0e10cSrcweir             m_aBookmarksPositions.push_back(m_aBookmarks.insert(TInt2IntMap::value_type(nDriverPos,m_aBookmarksPositions.size()+1)).first);*/
167cdf0e10cSrcweir     }
168cdf0e10cSrcweir 
169cdf0e10cSrcweir     return bDataFound;
170cdf0e10cSrcweir }
171cdf0e10cSrcweir // -------------------------------------------------------------------------
moveAbsolute(sal_Int32 _nPos,sal_Bool _bRetrieveData)172cdf0e10cSrcweir sal_Bool OSkipDeletedSet::moveAbsolute(sal_Int32 _nPos,sal_Bool _bRetrieveData)
173cdf0e10cSrcweir {
174cdf0e10cSrcweir     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "commontools", "Ocke.Janssen@sun.com", "OSkipDeletedSet::moveAbsolute" );
175cdf0e10cSrcweir     sal_Bool bDataFound = sal_False;
176cdf0e10cSrcweir     sal_Int32 nNewPos = _nPos;
177cdf0e10cSrcweir     if(nNewPos > 0)
178cdf0e10cSrcweir     {
179cdf0e10cSrcweir         if((sal_Int32)m_aBookmarksPositions.size() < nNewPos)
180cdf0e10cSrcweir         {
181cdf0e10cSrcweir             // bookmark isn't known yet
182cdf0e10cSrcweir             // start at the last known position
183cdf0e10cSrcweir             sal_Int32 nCurPos = 0,nLastBookmark = 1;
184cdf0e10cSrcweir             if ( m_aBookmarksPositions.empty() )
185cdf0e10cSrcweir             {
186cdf0e10cSrcweir                 bDataFound = m_pHelper->move(IResultSetHelper::FIRST, 0, _bRetrieveData );
187cdf0e10cSrcweir                 if(bDataFound && (m_bDeletedVisible || !m_pHelper->isRowDeleted()))
188cdf0e10cSrcweir                 {
189cdf0e10cSrcweir                     ++nCurPos;
190cdf0e10cSrcweir                     m_aBookmarksPositions.push_back(m_pHelper->getDriverPos());
191cdf0e10cSrcweir                     //m_aBookmarksPositions.push_back(m_aBookmarks.insert(TInt2IntMap::value_type(m_pHelper->getDriverPos(),m_aBookmarksPositions.size()+1)).first);
192cdf0e10cSrcweir                     --nNewPos;
193cdf0e10cSrcweir                 }
194cdf0e10cSrcweir             } // if ( m_aBookmarksPositions.empty() )
195cdf0e10cSrcweir             else
196cdf0e10cSrcweir             {
197cdf0e10cSrcweir                 nLastBookmark   = (*m_aBookmarksPositions.rbegin())/*->first*/;
198cdf0e10cSrcweir                 nCurPos         = /*(**/m_aBookmarksPositions.size()/*->second*/;
199cdf0e10cSrcweir                 nNewPos         = nNewPos - nCurPos;
200cdf0e10cSrcweir                 bDataFound      = m_pHelper->move(IResultSetHelper::BOOKMARK, nLastBookmark, _bRetrieveData);
201cdf0e10cSrcweir             }
202cdf0e10cSrcweir 
203cdf0e10cSrcweir             // now move to that row we need and don't count deleted rows
204cdf0e10cSrcweir             while (bDataFound && nNewPos)
205cdf0e10cSrcweir             {
206cdf0e10cSrcweir                 bDataFound = m_pHelper->move(IResultSetHelper::NEXT, 1, _bRetrieveData);
207cdf0e10cSrcweir                 if(bDataFound && (m_bDeletedVisible || !m_pHelper->isRowDeleted()))
208cdf0e10cSrcweir                 {
209cdf0e10cSrcweir                     ++nCurPos;
210cdf0e10cSrcweir                     m_aBookmarksPositions.push_back(m_pHelper->getDriverPos());
211cdf0e10cSrcweir                     //m_aBookmarksPositions.push_back(m_aBookmarks.insert(TInt2IntMap::value_type(m_pHelper->getDriverPos(),m_aBookmarksPositions.size()+1)).first);
212cdf0e10cSrcweir                     --nNewPos;
213cdf0e10cSrcweir                 }
214cdf0e10cSrcweir             }
215cdf0e10cSrcweir         }
216cdf0e10cSrcweir         else
217cdf0e10cSrcweir         {
218cdf0e10cSrcweir             const sal_Int32 nBookmark = m_aBookmarksPositions[nNewPos-1]/*->first*/;
219cdf0e10cSrcweir             bDataFound = m_pHelper->move(IResultSetHelper::BOOKMARK,nBookmark, _bRetrieveData);
220cdf0e10cSrcweir             OSL_ENSURE((m_bDeletedVisible || !m_pHelper->isRowDeleted()),"moveAbsolute: row can't be deleted!");
221cdf0e10cSrcweir         }
222cdf0e10cSrcweir     }
223cdf0e10cSrcweir     else
224cdf0e10cSrcweir     {
225cdf0e10cSrcweir         ++nNewPos;
226cdf0e10cSrcweir         bDataFound = skipDeleted(IResultSetHelper::LAST,0,nNewPos == 0);
227cdf0e10cSrcweir 
228cdf0e10cSrcweir         for(sal_Int32 i=nNewPos+1;bDataFound && i <= 0;++i)
229cdf0e10cSrcweir             bDataFound = skipDeleted(IResultSetHelper::PRIOR,1,i == 0);
230cdf0e10cSrcweir 
231cdf0e10cSrcweir     }
232cdf0e10cSrcweir     return bDataFound;
233cdf0e10cSrcweir }
234cdf0e10cSrcweir // -----------------------------------------------------------------------------
clear()235cdf0e10cSrcweir void OSkipDeletedSet::clear()
236cdf0e10cSrcweir {
237cdf0e10cSrcweir     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "commontools", "Ocke.Janssen@sun.com", "OSkipDeletedSet::clear" );
238cdf0e10cSrcweir     ::std::vector<sal_Int32>().swap(m_aBookmarksPositions);
239cdf0e10cSrcweir     //TInt2IntMap().swap(m_aBookmarks);
240cdf0e10cSrcweir }
241cdf0e10cSrcweir // -----------------------------------------------------------------------------
getMappedPosition(sal_Int32 _nPos) const242cdf0e10cSrcweir sal_Int32 OSkipDeletedSet::getMappedPosition(sal_Int32 _nPos) const
243cdf0e10cSrcweir {
244cdf0e10cSrcweir     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "commontools", "Ocke.Janssen@sun.com", "OSkipDeletedSet::getMappedPosition" );
245cdf0e10cSrcweir     ::std::vector<sal_Int32>::const_iterator aFind = ::std::find(m_aBookmarksPositions.begin(),m_aBookmarksPositions.end(),_nPos);
246cdf0e10cSrcweir     if ( aFind !=  m_aBookmarksPositions.end() )
247cdf0e10cSrcweir         return (aFind - m_aBookmarksPositions.begin()) + 1;
248cdf0e10cSrcweir     /*TInt2IntMap::const_iterator aFind = m_aBookmarks.find(_nPos);
249cdf0e10cSrcweir     OSL_ENSURE(aFind != m_aBookmarks.end(),"OSkipDeletedSet::getMappedPosition() invalid bookmark!");
250cdf0e10cSrcweir     return aFind->second;*/
251cdf0e10cSrcweir     OSL_ENSURE(0,"Why!");
252cdf0e10cSrcweir     return -1;
253cdf0e10cSrcweir }
254cdf0e10cSrcweir // -----------------------------------------------------------------------------
insertNewPosition(sal_Int32 _nPos)255cdf0e10cSrcweir void OSkipDeletedSet::insertNewPosition(sal_Int32 _nPos)
256cdf0e10cSrcweir {
257cdf0e10cSrcweir     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "commontools", "Ocke.Janssen@sun.com", "OSkipDeletedSet::insertNewPosition" );
258cdf0e10cSrcweir     //OSL_ENSURE(m_aBookmarks.find(_nPos) == m_aBookmarks.end(),"OSkipDeletedSet::insertNewPosition: Invalid position");
259cdf0e10cSrcweir     //m_aBookmarksPositions.push_back(m_aBookmarks.insert(TInt2IntMap::value_type(_nPos,m_aBookmarksPositions.size()+1)).first);
260cdf0e10cSrcweir     //OSL_ENSURE(::std::find(m_aBookmarksPositions.begin(),m_aBookmarksPositions.end(),_nPos) == m_aBookmarksPositions.end(),"Invalid driver pos");
261cdf0e10cSrcweir     m_aBookmarksPositions.push_back(_nPos);
262cdf0e10cSrcweir }
263cdf0e10cSrcweir // -----------------------------------------------------------------------------
deletePosition(sal_Int32 _nBookmark)264cdf0e10cSrcweir void OSkipDeletedSet::deletePosition(sal_Int32 _nBookmark)
265cdf0e10cSrcweir {
266cdf0e10cSrcweir     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "commontools", "Ocke.Janssen@sun.com", "OSkipDeletedSet::deletePosition" );
267cdf0e10cSrcweir     ::std::vector<sal_Int32>::iterator aFind = ::std::find(m_aBookmarksPositions.begin(),m_aBookmarksPositions.end(),_nBookmark);
268cdf0e10cSrcweir     if ( aFind !=  m_aBookmarksPositions.end() )
269cdf0e10cSrcweir     {
270cdf0e10cSrcweir     //TInt2IntMap::iterator aFind = m_aBookmarks.find(_nPos);
271cdf0e10cSrcweir     //OSL_ENSURE(aFind != m_aBookmarks.end(),"OSkipDeletedSet::deletePosition() bookmark not found!");
272cdf0e10cSrcweir     //TInt2IntMap::iterator aIter = aFind;
273cdf0e10cSrcweir         m_aBookmarksPositions.erase(aFind);
274cdf0e10cSrcweir         //for (; aFind != m_aBookmarksPositions.end() ; ++aIter)
275cdf0e10cSrcweir            // --(aFind->second);
276cdf0e10cSrcweir     } // if ( aFind !=  m_aBookmarksPositions.end() )
277cdf0e10cSrcweir     //m_aBookmarksPositions.erase(m_aBookmarksPositions.begin() + aFind->second-1);
278cdf0e10cSrcweir     //m_aBookmarks.erase(_nPos);
279cdf0e10cSrcweir }
280cdf0e10cSrcweir // -----------------------------------------------------------------------------
281