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_TABLETREE_HXX_
28*b1cdbd2cSJim Jagielski #include "tabletree.hxx"
29*b1cdbd2cSJim Jagielski #endif
30*b1cdbd2cSJim Jagielski #ifndef _DBAUI_TABLETREE_HRC_
31*b1cdbd2cSJim Jagielski #include "tabletree.hrc"
32*b1cdbd2cSJim Jagielski #endif
33*b1cdbd2cSJim Jagielski #ifndef DBACCESS_IMAGEPROVIDER_HXX
34*b1cdbd2cSJim Jagielski #include "imageprovider.hxx"
35*b1cdbd2cSJim Jagielski #endif
36*b1cdbd2cSJim Jagielski #ifndef _DBAUI_MODULE_DBU_HXX_
37*b1cdbd2cSJim Jagielski #include "moduledbu.hxx"
38*b1cdbd2cSJim Jagielski #endif
39*b1cdbd2cSJim Jagielski #ifndef _DBU_CONTROL_HRC_
40*b1cdbd2cSJim Jagielski #include "dbu_control.hrc"
41*b1cdbd2cSJim Jagielski #endif
42*b1cdbd2cSJim Jagielski #ifndef _SV_MENU_HXX
43*b1cdbd2cSJim Jagielski #include <vcl/menu.hxx>
44*b1cdbd2cSJim Jagielski #endif
45*b1cdbd2cSJim Jagielski #ifndef _CONNECTIVITY_DBTOOLS_HXX_
46*b1cdbd2cSJim Jagielski #include <connectivity/dbtools.hxx>
47*b1cdbd2cSJim Jagielski #endif
48*b1cdbd2cSJim Jagielski #ifndef _COMPHELPER_TYPES_HXX_
49*b1cdbd2cSJim Jagielski #include <comphelper/types.hxx>
50*b1cdbd2cSJim Jagielski #endif
51*b1cdbd2cSJim Jagielski #ifndef DBACCESS_SHARED_DBUSTRINGS_HRC
52*b1cdbd2cSJim Jagielski #include "dbustrings.hrc"
53*b1cdbd2cSJim Jagielski #endif
54*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDB_APPLICATION_DATABASEOBJECT_HPP_
55*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/application/DatabaseObject.hpp>
56*b1cdbd2cSJim Jagielski #endif
57*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDB_APPLICATION_DATABASEOBJECTFOLDER_HPP_
58*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/application/DatabaseObjectContainer.hpp>
59*b1cdbd2cSJim Jagielski #endif
60*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBC_XDRIVERACCESS_HPP_
61*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/XDriverAccess.hpp>
62*b1cdbd2cSJim Jagielski #endif
63*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBCX_XDATADEFINITIONSUPPLIER_HPP_
64*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XDataDefinitionSupplier.hpp>
65*b1cdbd2cSJim Jagielski #endif
66*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBCX_XVIEWSSUPPLIER_HPP_
67*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XViewsSupplier.hpp>
68*b1cdbd2cSJim Jagielski #endif
69*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBCX_XTABLESSUPPLIER_HPP_
70*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
71*b1cdbd2cSJim Jagielski #endif
72*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDB_SQLCONTEXT_HPP_
73*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/SQLContext.hpp>
74*b1cdbd2cSJim Jagielski #endif
75*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_SDBC_XROW_HPP_
76*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/XRow.hpp>
77*b1cdbd2cSJim Jagielski #endif
78*b1cdbd2cSJim Jagielski #ifndef _COM_SUN_STAR_BEANS_XPROPERTYSET_HPP_
79*b1cdbd2cSJim Jagielski #include <com/sun/star/beans/XPropertySet.hpp>
80*b1cdbd2cSJim Jagielski #endif
81*b1cdbd2cSJim Jagielski #ifndef _DBAUI_COMMON_TYPES_HXX_
82*b1cdbd2cSJim Jagielski #include "commontypes.hxx"
83*b1cdbd2cSJim Jagielski #endif
84*b1cdbd2cSJim Jagielski #ifndef _DBAUI_LISTVIEWITEMS_HXX_
85*b1cdbd2cSJim Jagielski #include "listviewitems.hxx"
86*b1cdbd2cSJim Jagielski #endif
87*b1cdbd2cSJim Jagielski #ifndef TOOLS_DIAGNOSE_EX_H
88*b1cdbd2cSJim Jagielski #include <tools/diagnose_ex.h>
89*b1cdbd2cSJim Jagielski #endif
90*b1cdbd2cSJim Jagielski #ifndef _RTL_USTRBUF_HXX_
91*b1cdbd2cSJim Jagielski #include <rtl/ustrbuf.hxx>
92*b1cdbd2cSJim Jagielski #endif
93*b1cdbd2cSJim Jagielski #include <connectivity/dbmetadata.hxx>
94*b1cdbd2cSJim Jagielski
95*b1cdbd2cSJim Jagielski #include <algorithm>
96*b1cdbd2cSJim Jagielski
97*b1cdbd2cSJim Jagielski //.........................................................................
98*b1cdbd2cSJim Jagielski namespace dbaui
99*b1cdbd2cSJim Jagielski {
100*b1cdbd2cSJim Jagielski //.........................................................................
101*b1cdbd2cSJim Jagielski
102*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno;
103*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdb;
104*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::lang;
105*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbc;
106*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbcx;
107*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::beans;
108*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::container;
109*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdb::application;
110*b1cdbd2cSJim Jagielski
111*b1cdbd2cSJim Jagielski using namespace ::dbtools;
112*b1cdbd2cSJim Jagielski using namespace ::comphelper;
113*b1cdbd2cSJim Jagielski
114*b1cdbd2cSJim Jagielski namespace DatabaseObject = ::com::sun::star::sdb::application::DatabaseObject;
115*b1cdbd2cSJim Jagielski namespace DatabaseObjectContainer = ::com::sun::star::sdb::application::DatabaseObjectContainer;
116*b1cdbd2cSJim Jagielski
117*b1cdbd2cSJim Jagielski //========================================================================
118*b1cdbd2cSJim Jagielski //= OTableTreeListBox
119*b1cdbd2cSJim Jagielski //========================================================================
OTableTreeListBox(Window * pParent,const Reference<XMultiServiceFactory> & _rxORB,WinBits nWinStyle,sal_Bool _bVirtualRoot)120*b1cdbd2cSJim Jagielski OTableTreeListBox::OTableTreeListBox( Window* pParent, const Reference< XMultiServiceFactory >& _rxORB, WinBits nWinStyle,sal_Bool _bVirtualRoot )
121*b1cdbd2cSJim Jagielski :OMarkableTreeListBox(pParent,_rxORB,nWinStyle)
122*b1cdbd2cSJim Jagielski ,m_pImageProvider( new ImageProvider )
123*b1cdbd2cSJim Jagielski ,m_bVirtualRoot(_bVirtualRoot)
124*b1cdbd2cSJim Jagielski ,m_bNoEmptyFolders( false )
125*b1cdbd2cSJim Jagielski {
126*b1cdbd2cSJim Jagielski implSetDefaultImages();
127*b1cdbd2cSJim Jagielski }
128*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
OTableTreeListBox(Window * pParent,const Reference<XMultiServiceFactory> & _rxORB,const ResId & rResId,sal_Bool _bVirtualRoot)129*b1cdbd2cSJim Jagielski OTableTreeListBox::OTableTreeListBox( Window* pParent, const Reference< XMultiServiceFactory >& _rxORB, const ResId& rResId ,sal_Bool _bVirtualRoot)
130*b1cdbd2cSJim Jagielski :OMarkableTreeListBox(pParent,_rxORB,rResId)
131*b1cdbd2cSJim Jagielski ,m_pImageProvider( new ImageProvider )
132*b1cdbd2cSJim Jagielski ,m_bVirtualRoot(_bVirtualRoot)
133*b1cdbd2cSJim Jagielski ,m_bNoEmptyFolders( false )
134*b1cdbd2cSJim Jagielski {
135*b1cdbd2cSJim Jagielski implSetDefaultImages();
136*b1cdbd2cSJim Jagielski }
137*b1cdbd2cSJim Jagielski
138*b1cdbd2cSJim Jagielski // -----------------------------------------------------------------------------
~OTableTreeListBox()139*b1cdbd2cSJim Jagielski OTableTreeListBox::~OTableTreeListBox()
140*b1cdbd2cSJim Jagielski {
141*b1cdbd2cSJim Jagielski }
142*b1cdbd2cSJim Jagielski
143*b1cdbd2cSJim Jagielski // -----------------------------------------------------------------------------
implSetDefaultImages()144*b1cdbd2cSJim Jagielski void OTableTreeListBox::implSetDefaultImages()
145*b1cdbd2cSJim Jagielski {
146*b1cdbd2cSJim Jagielski ImageProvider aImageProvider;
147*b1cdbd2cSJim Jagielski SetDefaultExpandedEntryBmp( aImageProvider.getFolderImage( DatabaseObject::TABLE, false ), BMP_COLOR_NORMAL );
148*b1cdbd2cSJim Jagielski SetDefaultExpandedEntryBmp( aImageProvider.getFolderImage( DatabaseObject::TABLE, true ), BMP_COLOR_HIGHCONTRAST );
149*b1cdbd2cSJim Jagielski SetDefaultCollapsedEntryBmp( aImageProvider.getFolderImage( DatabaseObject::TABLE, false ), BMP_COLOR_NORMAL );
150*b1cdbd2cSJim Jagielski SetDefaultCollapsedEntryBmp( aImageProvider.getFolderImage( DatabaseObject::TABLE, true ), BMP_COLOR_HIGHCONTRAST );
151*b1cdbd2cSJim Jagielski }
152*b1cdbd2cSJim Jagielski
153*b1cdbd2cSJim Jagielski // -----------------------------------------------------------------------------
isFolderEntry(const SvLBoxEntry * _pEntry) const154*b1cdbd2cSJim Jagielski bool OTableTreeListBox::isFolderEntry( const SvLBoxEntry* _pEntry ) const
155*b1cdbd2cSJim Jagielski {
156*b1cdbd2cSJim Jagielski sal_Int32 nEntryType = reinterpret_cast< sal_IntPtr >( _pEntry->GetUserData() );
157*b1cdbd2cSJim Jagielski if ( ( nEntryType == DatabaseObjectContainer::TABLES )
158*b1cdbd2cSJim Jagielski || ( nEntryType == DatabaseObjectContainer::CATALOG )
159*b1cdbd2cSJim Jagielski || ( nEntryType == DatabaseObjectContainer::SCHEMA )
160*b1cdbd2cSJim Jagielski )
161*b1cdbd2cSJim Jagielski return true;
162*b1cdbd2cSJim Jagielski return false;
163*b1cdbd2cSJim Jagielski }
164*b1cdbd2cSJim Jagielski
165*b1cdbd2cSJim Jagielski // -----------------------------------------------------------------------------
notifyHiContrastChanged()166*b1cdbd2cSJim Jagielski void OTableTreeListBox::notifyHiContrastChanged()
167*b1cdbd2cSJim Jagielski {
168*b1cdbd2cSJim Jagielski implSetDefaultImages();
169*b1cdbd2cSJim Jagielski
170*b1cdbd2cSJim Jagielski SvLBoxEntry* pEntryLoop = First();
171*b1cdbd2cSJim Jagielski while (pEntryLoop)
172*b1cdbd2cSJim Jagielski {
173*b1cdbd2cSJim Jagielski sal_uInt16 nCount = pEntryLoop->ItemCount();
174*b1cdbd2cSJim Jagielski for (sal_uInt16 i=0;i<nCount;++i)
175*b1cdbd2cSJim Jagielski {
176*b1cdbd2cSJim Jagielski SvLBoxItem* pItem = pEntryLoop->GetItem(i);
177*b1cdbd2cSJim Jagielski if ( pItem && pItem->IsA() == SV_ITEM_ID_LBOXCONTEXTBMP)
178*b1cdbd2cSJim Jagielski {
179*b1cdbd2cSJim Jagielski SvLBoxContextBmp* pContextBitmapItem = static_cast< SvLBoxContextBmp* >( pItem );
180*b1cdbd2cSJim Jagielski
181*b1cdbd2cSJim Jagielski Image aImage, aImageHC;
182*b1cdbd2cSJim Jagielski if ( isFolderEntry( pEntryLoop ) )
183*b1cdbd2cSJim Jagielski {
184*b1cdbd2cSJim Jagielski aImage = m_pImageProvider->getFolderImage( DatabaseObject::TABLE, false );
185*b1cdbd2cSJim Jagielski aImageHC = m_pImageProvider->getFolderImage( DatabaseObject::TABLE, true );
186*b1cdbd2cSJim Jagielski }
187*b1cdbd2cSJim Jagielski else
188*b1cdbd2cSJim Jagielski {
189*b1cdbd2cSJim Jagielski String sCompleteName( getQualifiedTableName( pEntryLoop ) );
190*b1cdbd2cSJim Jagielski m_pImageProvider->getImages( sCompleteName, DatabaseObject::TABLE, aImage, aImageHC );
191*b1cdbd2cSJim Jagielski }
192*b1cdbd2cSJim Jagielski
193*b1cdbd2cSJim Jagielski pContextBitmapItem->SetBitmap1( aImage, BMP_COLOR_NORMAL );
194*b1cdbd2cSJim Jagielski pContextBitmapItem->SetBitmap2( aImage, BMP_COLOR_NORMAL );
195*b1cdbd2cSJim Jagielski pContextBitmapItem->SetBitmap1( aImageHC, BMP_COLOR_HIGHCONTRAST );
196*b1cdbd2cSJim Jagielski pContextBitmapItem->SetBitmap2( aImageHC, BMP_COLOR_HIGHCONTRAST );
197*b1cdbd2cSJim Jagielski // TODO: Now that we give both images to the entry item, it is not necessary anymore
198*b1cdbd2cSJim Jagielski // to do this anytime HC changes - the tree control will do this itself now.
199*b1cdbd2cSJim Jagielski // We would only need to properly initialize newly inserted entries.
200*b1cdbd2cSJim Jagielski break;
201*b1cdbd2cSJim Jagielski }
202*b1cdbd2cSJim Jagielski }
203*b1cdbd2cSJim Jagielski pEntryLoop = Next(pEntryLoop);
204*b1cdbd2cSJim Jagielski }
205*b1cdbd2cSJim Jagielski }
206*b1cdbd2cSJim Jagielski
207*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
implOnNewConnection(const Reference<XConnection> & _rxConnection)208*b1cdbd2cSJim Jagielski void OTableTreeListBox::implOnNewConnection( const Reference< XConnection >& _rxConnection )
209*b1cdbd2cSJim Jagielski {
210*b1cdbd2cSJim Jagielski m_xConnection = _rxConnection;
211*b1cdbd2cSJim Jagielski m_pImageProvider.reset( new ImageProvider( m_xConnection ) );
212*b1cdbd2cSJim Jagielski }
213*b1cdbd2cSJim Jagielski
214*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
UpdateTableList(const Reference<XConnection> & _rxConnection)215*b1cdbd2cSJim Jagielski void OTableTreeListBox::UpdateTableList( const Reference< XConnection >& _rxConnection ) throw(SQLException)
216*b1cdbd2cSJim Jagielski {
217*b1cdbd2cSJim Jagielski Sequence< ::rtl::OUString > sTables, sViews;
218*b1cdbd2cSJim Jagielski
219*b1cdbd2cSJim Jagielski String sCurrentActionError;
220*b1cdbd2cSJim Jagielski try
221*b1cdbd2cSJim Jagielski {
222*b1cdbd2cSJim Jagielski Reference< XTablesSupplier > xTableSupp( _rxConnection, UNO_QUERY_THROW );
223*b1cdbd2cSJim Jagielski sCurrentActionError = String(ModuleRes(STR_NOTABLEINFO));
224*b1cdbd2cSJim Jagielski
225*b1cdbd2cSJim Jagielski Reference< XNameAccess > xTables,xViews;
226*b1cdbd2cSJim Jagielski
227*b1cdbd2cSJim Jagielski Reference< XViewsSupplier > xViewSupp( _rxConnection, UNO_QUERY );
228*b1cdbd2cSJim Jagielski if ( xViewSupp.is() )
229*b1cdbd2cSJim Jagielski {
230*b1cdbd2cSJim Jagielski xViews = xViewSupp->getViews();
231*b1cdbd2cSJim Jagielski if (xViews.is())
232*b1cdbd2cSJim Jagielski sViews = xViews->getElementNames();
233*b1cdbd2cSJim Jagielski }
234*b1cdbd2cSJim Jagielski
235*b1cdbd2cSJim Jagielski xTables = xTableSupp->getTables();
236*b1cdbd2cSJim Jagielski if (xTables.is())
237*b1cdbd2cSJim Jagielski sTables = xTables->getElementNames();
238*b1cdbd2cSJim Jagielski }
239*b1cdbd2cSJim Jagielski catch(RuntimeException&)
240*b1cdbd2cSJim Jagielski {
241*b1cdbd2cSJim Jagielski DBG_ERROR("OTableTreeListBox::UpdateTableList : caught an RuntimeException!");
242*b1cdbd2cSJim Jagielski }
243*b1cdbd2cSJim Jagielski catch ( const SQLException& )
244*b1cdbd2cSJim Jagielski {
245*b1cdbd2cSJim Jagielski throw;
246*b1cdbd2cSJim Jagielski }
247*b1cdbd2cSJim Jagielski catch(Exception&)
248*b1cdbd2cSJim Jagielski {
249*b1cdbd2cSJim Jagielski // a non-SQLException exception occured ... simply throw an SQLException
250*b1cdbd2cSJim Jagielski SQLException aInfo;
251*b1cdbd2cSJim Jagielski aInfo.Message = sCurrentActionError;
252*b1cdbd2cSJim Jagielski throw aInfo;
253*b1cdbd2cSJim Jagielski }
254*b1cdbd2cSJim Jagielski
255*b1cdbd2cSJim Jagielski UpdateTableList( _rxConnection, sTables, sViews );
256*b1cdbd2cSJim Jagielski }
257*b1cdbd2cSJim Jagielski // -----------------------------------------------------------------------------
258*b1cdbd2cSJim Jagielski namespace
259*b1cdbd2cSJim Jagielski {
260*b1cdbd2cSJim Jagielski struct OViewSetter : public ::std::unary_function< OTableTreeListBox::TNames::value_type, bool>
261*b1cdbd2cSJim Jagielski {
262*b1cdbd2cSJim Jagielski const Sequence< ::rtl::OUString> m_aViews;
263*b1cdbd2cSJim Jagielski ::comphelper::TStringMixEqualFunctor m_aEqualFunctor;
264*b1cdbd2cSJim Jagielski
OViewSetterdbaui::__anon923adc5c0111::OViewSetter265*b1cdbd2cSJim Jagielski OViewSetter(const Sequence< ::rtl::OUString>& _rViews,sal_Bool _bCase) : m_aViews(_rViews),m_aEqualFunctor(_bCase){}
operator ()dbaui::__anon923adc5c0111::OViewSetter266*b1cdbd2cSJim Jagielski OTableTreeListBox::TNames::value_type operator() (const ::rtl::OUString& lhs)
267*b1cdbd2cSJim Jagielski {
268*b1cdbd2cSJim Jagielski OTableTreeListBox::TNames::value_type aRet;
269*b1cdbd2cSJim Jagielski aRet.first = lhs;
270*b1cdbd2cSJim Jagielski const ::rtl::OUString* pIter = m_aViews.getConstArray();
271*b1cdbd2cSJim Jagielski const ::rtl::OUString* pEnd = m_aViews.getConstArray() + m_aViews.getLength();
272*b1cdbd2cSJim Jagielski aRet.second = (::std::find_if(pIter,pEnd,::std::bind2nd(m_aEqualFunctor,lhs)) != pEnd);
273*b1cdbd2cSJim Jagielski
274*b1cdbd2cSJim Jagielski return aRet;
275*b1cdbd2cSJim Jagielski }
276*b1cdbd2cSJim Jagielski };
277*b1cdbd2cSJim Jagielski
278*b1cdbd2cSJim Jagielski }
279*b1cdbd2cSJim Jagielski // -----------------------------------------------------------------------------
UpdateTableList(const Reference<XConnection> & _rxConnection,const Sequence<::rtl::OUString> & _rTables,const Sequence<::rtl::OUString> & _rViews)280*b1cdbd2cSJim Jagielski void OTableTreeListBox::UpdateTableList(
281*b1cdbd2cSJim Jagielski const Reference< XConnection >& _rxConnection,
282*b1cdbd2cSJim Jagielski const Sequence< ::rtl::OUString>& _rTables,
283*b1cdbd2cSJim Jagielski const Sequence< ::rtl::OUString>& _rViews
284*b1cdbd2cSJim Jagielski )
285*b1cdbd2cSJim Jagielski {
286*b1cdbd2cSJim Jagielski TNames aTables;
287*b1cdbd2cSJim Jagielski aTables.resize(_rTables.getLength());
288*b1cdbd2cSJim Jagielski const ::rtl::OUString* pIter = _rTables.getConstArray();
289*b1cdbd2cSJim Jagielski const ::rtl::OUString* pEnd = _rTables.getConstArray() + _rTables.getLength();
290*b1cdbd2cSJim Jagielski try
291*b1cdbd2cSJim Jagielski {
292*b1cdbd2cSJim Jagielski Reference< XDatabaseMetaData > xMeta( _rxConnection->getMetaData(), UNO_QUERY_THROW );
293*b1cdbd2cSJim Jagielski ::std::transform( pIter, pEnd,
294*b1cdbd2cSJim Jagielski aTables.begin(), OViewSetter( _rViews, xMeta->supportsMixedCaseQuotedIdentifiers() ) );
295*b1cdbd2cSJim Jagielski }
296*b1cdbd2cSJim Jagielski catch(Exception&)
297*b1cdbd2cSJim Jagielski {
298*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
299*b1cdbd2cSJim Jagielski }
300*b1cdbd2cSJim Jagielski UpdateTableList( _rxConnection, aTables );
301*b1cdbd2cSJim Jagielski }
302*b1cdbd2cSJim Jagielski
303*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
304*b1cdbd2cSJim Jagielski namespace
305*b1cdbd2cSJim Jagielski {
lcl_getMetaDataStrings_throw(const Reference<XResultSet> & _rxMetaDataResult,sal_Int32 _nColumnIndex)306*b1cdbd2cSJim Jagielski ::std::vector< ::rtl::OUString > lcl_getMetaDataStrings_throw( const Reference< XResultSet >& _rxMetaDataResult, sal_Int32 _nColumnIndex )
307*b1cdbd2cSJim Jagielski {
308*b1cdbd2cSJim Jagielski ::std::vector< ::rtl::OUString > aStrings;
309*b1cdbd2cSJim Jagielski Reference< XRow > xRow( _rxMetaDataResult, UNO_QUERY_THROW );
310*b1cdbd2cSJim Jagielski while ( _rxMetaDataResult->next() )
311*b1cdbd2cSJim Jagielski aStrings.push_back( xRow->getString( _nColumnIndex ) );
312*b1cdbd2cSJim Jagielski return aStrings;
313*b1cdbd2cSJim Jagielski }
314*b1cdbd2cSJim Jagielski
lcl_shouldDisplayEmptySchemasAndCatalogs(const Reference<XConnection> & _rxConnection)315*b1cdbd2cSJim Jagielski bool lcl_shouldDisplayEmptySchemasAndCatalogs( const Reference< XConnection >& _rxConnection )
316*b1cdbd2cSJim Jagielski {
317*b1cdbd2cSJim Jagielski ::dbtools::DatabaseMetaData aMetaData( _rxConnection );
318*b1cdbd2cSJim Jagielski return aMetaData.displayEmptyTableFolders();
319*b1cdbd2cSJim Jagielski }
320*b1cdbd2cSJim Jagielski }
321*b1cdbd2cSJim Jagielski
322*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
UpdateTableList(const Reference<XConnection> & _rxConnection,const TNames & _rTables)323*b1cdbd2cSJim Jagielski void OTableTreeListBox::UpdateTableList( const Reference< XConnection >& _rxConnection, const TNames& _rTables )
324*b1cdbd2cSJim Jagielski {
325*b1cdbd2cSJim Jagielski implOnNewConnection( _rxConnection );
326*b1cdbd2cSJim Jagielski
327*b1cdbd2cSJim Jagielski // throw away all the old stuff
328*b1cdbd2cSJim Jagielski Clear();
329*b1cdbd2cSJim Jagielski
330*b1cdbd2cSJim Jagielski try
331*b1cdbd2cSJim Jagielski {
332*b1cdbd2cSJim Jagielski // the root entry saying "all objects"
333*b1cdbd2cSJim Jagielski SvLBoxEntry* pAllObjects = NULL;
334*b1cdbd2cSJim Jagielski if (haveVirtualRoot())
335*b1cdbd2cSJim Jagielski {
336*b1cdbd2cSJim Jagielski String sRootEntryText;
337*b1cdbd2cSJim Jagielski TNames::const_iterator aViews = ::std::find_if(_rTables.begin(),_rTables.end(),
338*b1cdbd2cSJim Jagielski ::std::compose1(::std::bind2nd(::std::equal_to<sal_Bool>(),sal_False),::std::select2nd<TNames::value_type>()));
339*b1cdbd2cSJim Jagielski TNames::const_iterator aTables = ::std::find_if(_rTables.begin(),_rTables.end(),
340*b1cdbd2cSJim Jagielski ::std::compose1(::std::bind2nd(::std::equal_to<sal_Bool>(),sal_True),::std::select2nd<TNames::value_type>()));
341*b1cdbd2cSJim Jagielski
342*b1cdbd2cSJim Jagielski if ( aViews == _rTables.end() )
343*b1cdbd2cSJim Jagielski sRootEntryText = String(ModuleRes(STR_ALL_TABLES));
344*b1cdbd2cSJim Jagielski else if ( aTables == _rTables.end() )
345*b1cdbd2cSJim Jagielski sRootEntryText = String(ModuleRes(STR_ALL_VIEWS));
346*b1cdbd2cSJim Jagielski else
347*b1cdbd2cSJim Jagielski sRootEntryText = String(ModuleRes(STR_ALL_TABLES_AND_VIEWS));
348*b1cdbd2cSJim Jagielski pAllObjects = InsertEntry( sRootEntryText, NULL, sal_False, LIST_APPEND, reinterpret_cast< void* >( DatabaseObjectContainer::TABLES ) );
349*b1cdbd2cSJim Jagielski }
350*b1cdbd2cSJim Jagielski
351*b1cdbd2cSJim Jagielski if ( _rTables.empty() )
352*b1cdbd2cSJim Jagielski // nothing to do (besides inserting the root entry)
353*b1cdbd2cSJim Jagielski return;
354*b1cdbd2cSJim Jagielski
355*b1cdbd2cSJim Jagielski // get the table/view names
356*b1cdbd2cSJim Jagielski TNames::const_iterator aIter = _rTables.begin();
357*b1cdbd2cSJim Jagielski TNames::const_iterator aEnd = _rTables.end();
358*b1cdbd2cSJim Jagielski
359*b1cdbd2cSJim Jagielski Reference< XDatabaseMetaData > xMeta( _rxConnection->getMetaData(), UNO_QUERY_THROW );
360*b1cdbd2cSJim Jagielski for ( ; aIter != aEnd; ++aIter )
361*b1cdbd2cSJim Jagielski {
362*b1cdbd2cSJim Jagielski // add the entry
363*b1cdbd2cSJim Jagielski implAddEntry(
364*b1cdbd2cSJim Jagielski xMeta,
365*b1cdbd2cSJim Jagielski aIter->first,
366*b1cdbd2cSJim Jagielski sal_False
367*b1cdbd2cSJim Jagielski );
368*b1cdbd2cSJim Jagielski }
369*b1cdbd2cSJim Jagielski
370*b1cdbd2cSJim Jagielski if ( !m_bNoEmptyFolders && lcl_shouldDisplayEmptySchemasAndCatalogs( _rxConnection ) )
371*b1cdbd2cSJim Jagielski {
372*b1cdbd2cSJim Jagielski sal_Bool bSupportsCatalogs = xMeta->supportsCatalogsInDataManipulation();
373*b1cdbd2cSJim Jagielski sal_Bool bSupportsSchemas = xMeta->supportsSchemasInDataManipulation();
374*b1cdbd2cSJim Jagielski
375*b1cdbd2cSJim Jagielski if ( bSupportsCatalogs || bSupportsSchemas )
376*b1cdbd2cSJim Jagielski {
377*b1cdbd2cSJim Jagielski // we display empty catalogs if the DB supports catalogs, and they're noted at the beginning of a
378*b1cdbd2cSJim Jagielski // composed name. Otherwise, we display empty schematas. (also see the tree structure explained in
379*b1cdbd2cSJim Jagielski // implAddEntry)
380*b1cdbd2cSJim Jagielski bool bCatalogs = bSupportsCatalogs && xMeta->isCatalogAtStart();
381*b1cdbd2cSJim Jagielski
382*b1cdbd2cSJim Jagielski ::std::vector< ::rtl::OUString > aFolderNames( lcl_getMetaDataStrings_throw(
383*b1cdbd2cSJim Jagielski bCatalogs ? xMeta->getCatalogs() : xMeta->getSchemas(), 1 ) );
384*b1cdbd2cSJim Jagielski sal_Int32 nFolderType = bCatalogs ? DatabaseObjectContainer::CATALOG : DatabaseObjectContainer::SCHEMA;
385*b1cdbd2cSJim Jagielski
386*b1cdbd2cSJim Jagielski SvLBoxEntry* pRootEntry = getAllObjectsEntry();
387*b1cdbd2cSJim Jagielski for ( ::std::vector< ::rtl::OUString >::const_iterator folder = aFolderNames.begin();
388*b1cdbd2cSJim Jagielski folder != aFolderNames.end();
389*b1cdbd2cSJim Jagielski ++folder
390*b1cdbd2cSJim Jagielski )
391*b1cdbd2cSJim Jagielski {
392*b1cdbd2cSJim Jagielski SvLBoxEntry* pFolder = GetEntryPosByName( *folder, pRootEntry );
393*b1cdbd2cSJim Jagielski if ( !pFolder )
394*b1cdbd2cSJim Jagielski pFolder = InsertEntry( *folder, pRootEntry, sal_False, LIST_APPEND, reinterpret_cast< void* >( nFolderType ) );
395*b1cdbd2cSJim Jagielski }
396*b1cdbd2cSJim Jagielski }
397*b1cdbd2cSJim Jagielski }
398*b1cdbd2cSJim Jagielski }
399*b1cdbd2cSJim Jagielski catch ( const Exception& )
400*b1cdbd2cSJim Jagielski {
401*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
402*b1cdbd2cSJim Jagielski }
403*b1cdbd2cSJim Jagielski }
404*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isWildcardChecked(SvLBoxEntry * _pEntry) const405*b1cdbd2cSJim Jagielski sal_Bool OTableTreeListBox::isWildcardChecked(SvLBoxEntry* _pEntry) const
406*b1cdbd2cSJim Jagielski {
407*b1cdbd2cSJim Jagielski if (_pEntry)
408*b1cdbd2cSJim Jagielski {
409*b1cdbd2cSJim Jagielski OBoldListboxString* pTextItem = static_cast<OBoldListboxString*>(_pEntry->GetFirstItem(SV_ITEM_ID_BOLDLBSTRING));
410*b1cdbd2cSJim Jagielski if (pTextItem)
411*b1cdbd2cSJim Jagielski return pTextItem->isEmphasized();
412*b1cdbd2cSJim Jagielski }
413*b1cdbd2cSJim Jagielski return sal_False;
414*b1cdbd2cSJim Jagielski }
415*b1cdbd2cSJim Jagielski
416*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
checkWildcard(SvLBoxEntry * _pEntry)417*b1cdbd2cSJim Jagielski void OTableTreeListBox::checkWildcard(SvLBoxEntry* _pEntry)
418*b1cdbd2cSJim Jagielski {
419*b1cdbd2cSJim Jagielski SetCheckButtonState(_pEntry, SV_BUTTON_CHECKED);
420*b1cdbd2cSJim Jagielski checkedButton_noBroadcast(_pEntry);
421*b1cdbd2cSJim Jagielski }
422*b1cdbd2cSJim Jagielski
423*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
getAllObjectsEntry() const424*b1cdbd2cSJim Jagielski SvLBoxEntry* OTableTreeListBox::getAllObjectsEntry() const
425*b1cdbd2cSJim Jagielski {
426*b1cdbd2cSJim Jagielski return haveVirtualRoot() ? First() : NULL;
427*b1cdbd2cSJim Jagielski }
428*b1cdbd2cSJim Jagielski
429*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
checkedButton_noBroadcast(SvLBoxEntry * _pEntry)430*b1cdbd2cSJim Jagielski void OTableTreeListBox::checkedButton_noBroadcast(SvLBoxEntry* _pEntry)
431*b1cdbd2cSJim Jagielski {
432*b1cdbd2cSJim Jagielski OMarkableTreeListBox::checkedButton_noBroadcast(_pEntry);
433*b1cdbd2cSJim Jagielski
434*b1cdbd2cSJim Jagielski // if an entry has children, it makes a difference if the entry is checked because alls children are checked
435*b1cdbd2cSJim Jagielski // or if the user checked it explicitly.
436*b1cdbd2cSJim Jagielski // So we track explicit (un)checking
437*b1cdbd2cSJim Jagielski
438*b1cdbd2cSJim Jagielski SvButtonState eState = GetCheckButtonState(_pEntry);
439*b1cdbd2cSJim Jagielski DBG_ASSERT(SV_BUTTON_TRISTATE != eState, "OTableTreeListBox::CheckButtonHdl: user action which lead to TRISTATE?");
440*b1cdbd2cSJim Jagielski implEmphasize(_pEntry, SV_BUTTON_CHECKED == eState);
441*b1cdbd2cSJim Jagielski }
442*b1cdbd2cSJim Jagielski
443*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
implEmphasize(SvLBoxEntry * _pEntry,sal_Bool _bChecked,sal_Bool _bUpdateDescendants,sal_Bool _bUpdateAncestors)444*b1cdbd2cSJim Jagielski void OTableTreeListBox::implEmphasize(SvLBoxEntry* _pEntry, sal_Bool _bChecked, sal_Bool _bUpdateDescendants, sal_Bool _bUpdateAncestors)
445*b1cdbd2cSJim Jagielski {
446*b1cdbd2cSJim Jagielski DBG_ASSERT(_pEntry, "OTableTreeListBox::implEmphasize: invalid entry (NULL)!");
447*b1cdbd2cSJim Jagielski
448*b1cdbd2cSJim Jagielski // special emphasizing handling for the "all objects" entry
449*b1cdbd2cSJim Jagielski // 89709 - 16.07.2001 - frank.schoenheit@sun.com
450*b1cdbd2cSJim Jagielski sal_Bool bAllObjectsEntryAffected = haveVirtualRoot() && (getAllObjectsEntry() == _pEntry);
451*b1cdbd2cSJim Jagielski if ( GetModel()->HasChilds(_pEntry) // the entry has children
452*b1cdbd2cSJim Jagielski || bAllObjectsEntryAffected // or it is the "all objects" entry
453*b1cdbd2cSJim Jagielski )
454*b1cdbd2cSJim Jagielski {
455*b1cdbd2cSJim Jagielski OBoldListboxString* pTextItem = static_cast<OBoldListboxString*>(_pEntry->GetFirstItem(SV_ITEM_ID_BOLDLBSTRING));
456*b1cdbd2cSJim Jagielski if (pTextItem)
457*b1cdbd2cSJim Jagielski pTextItem->emphasize(_bChecked);
458*b1cdbd2cSJim Jagielski
459*b1cdbd2cSJim Jagielski if (bAllObjectsEntryAffected)
460*b1cdbd2cSJim Jagielski InvalidateEntry(_pEntry);
461*b1cdbd2cSJim Jagielski }
462*b1cdbd2cSJim Jagielski
463*b1cdbd2cSJim Jagielski if (_bUpdateDescendants)
464*b1cdbd2cSJim Jagielski {
465*b1cdbd2cSJim Jagielski // remove the mark for all children of the checked entry
466*b1cdbd2cSJim Jagielski SvLBoxEntry* pChildLoop = FirstChild(_pEntry);
467*b1cdbd2cSJim Jagielski while (pChildLoop)
468*b1cdbd2cSJim Jagielski {
469*b1cdbd2cSJim Jagielski if (GetModel()->HasChilds(pChildLoop))
470*b1cdbd2cSJim Jagielski implEmphasize(pChildLoop, sal_False, sal_True, sal_False);
471*b1cdbd2cSJim Jagielski pChildLoop = NextSibling(pChildLoop);
472*b1cdbd2cSJim Jagielski }
473*b1cdbd2cSJim Jagielski }
474*b1cdbd2cSJim Jagielski
475*b1cdbd2cSJim Jagielski if (_bUpdateAncestors)
476*b1cdbd2cSJim Jagielski {
477*b1cdbd2cSJim Jagielski // remove the mark for all ancestors of the entry
478*b1cdbd2cSJim Jagielski if (GetModel()->HasParent(_pEntry))
479*b1cdbd2cSJim Jagielski implEmphasize(GetParent(_pEntry), sal_False, sal_False, sal_True);
480*b1cdbd2cSJim Jagielski }
481*b1cdbd2cSJim Jagielski }
482*b1cdbd2cSJim Jagielski
483*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
InitEntry(SvLBoxEntry * _pEntry,const XubString & _rString,const Image & _rCollapsedBitmap,const Image & _rExpandedBitmap,SvLBoxButtonKind _eButtonKind)484*b1cdbd2cSJim Jagielski void OTableTreeListBox::InitEntry(SvLBoxEntry* _pEntry, const XubString& _rString, const Image& _rCollapsedBitmap, const Image& _rExpandedBitmap, SvLBoxButtonKind _eButtonKind)
485*b1cdbd2cSJim Jagielski {
486*b1cdbd2cSJim Jagielski OMarkableTreeListBox::InitEntry(_pEntry, _rString, _rCollapsedBitmap, _rExpandedBitmap, _eButtonKind);
487*b1cdbd2cSJim Jagielski
488*b1cdbd2cSJim Jagielski // replace the text item with our own one
489*b1cdbd2cSJim Jagielski SvLBoxItem* pTextItem = _pEntry->GetFirstItem(SV_ITEM_ID_LBOXSTRING);
490*b1cdbd2cSJim Jagielski DBG_ASSERT(pTextItem, "OTableTreeListBox::InitEntry: no text item!?");
491*b1cdbd2cSJim Jagielski sal_uInt16 nTextPos = _pEntry->GetPos(pTextItem);
492*b1cdbd2cSJim Jagielski DBG_ASSERT(((sal_uInt16)-1) != nTextPos, "OTableTreeListBox::InitEntry: no text item pos!");
493*b1cdbd2cSJim Jagielski
494*b1cdbd2cSJim Jagielski _pEntry->ReplaceItem(new OBoldListboxString(_pEntry, 0, _rString), nTextPos);
495*b1cdbd2cSJim Jagielski }
496*b1cdbd2cSJim Jagielski
497*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
implAddEntry(const Reference<XDatabaseMetaData> & _rxMeta,const::rtl::OUString & _rTableName,sal_Bool _bCheckName)498*b1cdbd2cSJim Jagielski SvLBoxEntry* OTableTreeListBox::implAddEntry(
499*b1cdbd2cSJim Jagielski const Reference< XDatabaseMetaData >& _rxMeta,
500*b1cdbd2cSJim Jagielski const ::rtl::OUString& _rTableName,
501*b1cdbd2cSJim Jagielski sal_Bool _bCheckName
502*b1cdbd2cSJim Jagielski )
503*b1cdbd2cSJim Jagielski {
504*b1cdbd2cSJim Jagielski OSL_PRECOND( _rxMeta.is(), "OTableTreeListBox::implAddEntry: invalid meta data!" );
505*b1cdbd2cSJim Jagielski if ( !_rxMeta.is() )
506*b1cdbd2cSJim Jagielski return NULL;
507*b1cdbd2cSJim Jagielski
508*b1cdbd2cSJim Jagielski // split the complete name into it's components
509*b1cdbd2cSJim Jagielski ::rtl::OUString sCatalog, sSchema, sName;
510*b1cdbd2cSJim Jagielski qualifiedNameComponents( _rxMeta, _rTableName, sCatalog, sSchema, sName, ::dbtools::eInDataManipulation );
511*b1cdbd2cSJim Jagielski
512*b1cdbd2cSJim Jagielski SvLBoxEntry* pParentEntry = getAllObjectsEntry();
513*b1cdbd2cSJim Jagielski
514*b1cdbd2cSJim Jagielski // if the DB uses catalog at the start of identifiers, then our hierarchy is
515*b1cdbd2cSJim Jagielski // catalog
516*b1cdbd2cSJim Jagielski // +- schema
517*b1cdbd2cSJim Jagielski // +- table
518*b1cdbd2cSJim Jagielski // else it is
519*b1cdbd2cSJim Jagielski // schema
520*b1cdbd2cSJim Jagielski // +- catalog
521*b1cdbd2cSJim Jagielski // +- table
522*b1cdbd2cSJim Jagielski sal_Bool bCatalogAtStart = _rxMeta->isCatalogAtStart();
523*b1cdbd2cSJim Jagielski const ::rtl::OUString& rFirstName = bCatalogAtStart ? sCatalog : sSchema;
524*b1cdbd2cSJim Jagielski const sal_Int32 nFirstFolderType = bCatalogAtStart ? DatabaseObjectContainer::CATALOG : DatabaseObjectContainer::SCHEMA;
525*b1cdbd2cSJim Jagielski const ::rtl::OUString& rSecondName = bCatalogAtStart ? sSchema : sCatalog;
526*b1cdbd2cSJim Jagielski const sal_Int32 nSecondFolderType = bCatalogAtStart ? DatabaseObjectContainer::SCHEMA : DatabaseObjectContainer::CATALOG;
527*b1cdbd2cSJim Jagielski
528*b1cdbd2cSJim Jagielski if ( rFirstName.getLength() )
529*b1cdbd2cSJim Jagielski {
530*b1cdbd2cSJim Jagielski SvLBoxEntry* pFolder = GetEntryPosByName( rFirstName, pParentEntry );
531*b1cdbd2cSJim Jagielski if ( !pFolder )
532*b1cdbd2cSJim Jagielski pFolder = InsertEntry( rFirstName, pParentEntry, sal_False, LIST_APPEND, reinterpret_cast< void* >( nFirstFolderType ) );
533*b1cdbd2cSJim Jagielski pParentEntry = pFolder;
534*b1cdbd2cSJim Jagielski }
535*b1cdbd2cSJim Jagielski
536*b1cdbd2cSJim Jagielski if ( rSecondName.getLength() )
537*b1cdbd2cSJim Jagielski {
538*b1cdbd2cSJim Jagielski SvLBoxEntry* pFolder = GetEntryPosByName( rSecondName, pParentEntry );
539*b1cdbd2cSJim Jagielski if ( !pFolder )
540*b1cdbd2cSJim Jagielski pFolder = InsertEntry( rSecondName, pParentEntry, sal_False, LIST_APPEND, reinterpret_cast< void* >( nSecondFolderType ) );
541*b1cdbd2cSJim Jagielski pParentEntry = pFolder;
542*b1cdbd2cSJim Jagielski }
543*b1cdbd2cSJim Jagielski
544*b1cdbd2cSJim Jagielski SvLBoxEntry* pRet = NULL;
545*b1cdbd2cSJim Jagielski if ( !_bCheckName || !GetEntryPosByName( sName, pParentEntry ) )
546*b1cdbd2cSJim Jagielski {
547*b1cdbd2cSJim Jagielski pRet = InsertEntry( sName, pParentEntry, sal_False, LIST_APPEND );
548*b1cdbd2cSJim Jagielski
549*b1cdbd2cSJim Jagielski Image aImage, aImageHC;
550*b1cdbd2cSJim Jagielski m_pImageProvider->getImages( _rTableName, DatabaseObject::TABLE, aImage, aImageHC );
551*b1cdbd2cSJim Jagielski
552*b1cdbd2cSJim Jagielski SetExpandedEntryBmp( pRet, aImage, BMP_COLOR_NORMAL );
553*b1cdbd2cSJim Jagielski SetCollapsedEntryBmp( pRet, aImage, BMP_COLOR_NORMAL );
554*b1cdbd2cSJim Jagielski SetExpandedEntryBmp( pRet, aImageHC, BMP_COLOR_HIGHCONTRAST );
555*b1cdbd2cSJim Jagielski SetCollapsedEntryBmp( pRet, aImageHC, BMP_COLOR_HIGHCONTRAST );
556*b1cdbd2cSJim Jagielski }
557*b1cdbd2cSJim Jagielski return pRet;
558*b1cdbd2cSJim Jagielski }
559*b1cdbd2cSJim Jagielski
560*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
describeObject(SvLBoxEntry * _pEntry)561*b1cdbd2cSJim Jagielski NamedDatabaseObject OTableTreeListBox::describeObject( SvLBoxEntry* _pEntry )
562*b1cdbd2cSJim Jagielski {
563*b1cdbd2cSJim Jagielski NamedDatabaseObject aObject;
564*b1cdbd2cSJim Jagielski
565*b1cdbd2cSJim Jagielski sal_Int32 nEntryType = reinterpret_cast< sal_IntPtr >( _pEntry->GetUserData() );
566*b1cdbd2cSJim Jagielski
567*b1cdbd2cSJim Jagielski if ( nEntryType == DatabaseObjectContainer::TABLES )
568*b1cdbd2cSJim Jagielski {
569*b1cdbd2cSJim Jagielski aObject.Type = DatabaseObjectContainer::TABLES;
570*b1cdbd2cSJim Jagielski }
571*b1cdbd2cSJim Jagielski else if ( ( nEntryType == DatabaseObjectContainer::CATALOG )
572*b1cdbd2cSJim Jagielski || ( nEntryType == DatabaseObjectContainer::SCHEMA )
573*b1cdbd2cSJim Jagielski )
574*b1cdbd2cSJim Jagielski {
575*b1cdbd2cSJim Jagielski SvLBoxEntry* pParent = GetParent( _pEntry );
576*b1cdbd2cSJim Jagielski sal_Int32 nParentEntryType = pParent ? reinterpret_cast< sal_IntPtr >( pParent->GetUserData() ) : -1;
577*b1cdbd2cSJim Jagielski
578*b1cdbd2cSJim Jagielski ::rtl::OUStringBuffer buffer;
579*b1cdbd2cSJim Jagielski if ( nEntryType == DatabaseObjectContainer::CATALOG )
580*b1cdbd2cSJim Jagielski {
581*b1cdbd2cSJim Jagielski if ( nParentEntryType == DatabaseObjectContainer::SCHEMA )
582*b1cdbd2cSJim Jagielski {
583*b1cdbd2cSJim Jagielski buffer.append( GetEntryText( pParent ) );
584*b1cdbd2cSJim Jagielski buffer.append( sal_Unicode( '.' ) );
585*b1cdbd2cSJim Jagielski }
586*b1cdbd2cSJim Jagielski buffer.append( GetEntryText( _pEntry ) );
587*b1cdbd2cSJim Jagielski }
588*b1cdbd2cSJim Jagielski else if ( nEntryType == DatabaseObjectContainer::SCHEMA )
589*b1cdbd2cSJim Jagielski {
590*b1cdbd2cSJim Jagielski if ( nParentEntryType == DatabaseObjectContainer::CATALOG )
591*b1cdbd2cSJim Jagielski {
592*b1cdbd2cSJim Jagielski buffer.append( GetEntryText( pParent ) );
593*b1cdbd2cSJim Jagielski buffer.append( sal_Unicode( '.' ) );
594*b1cdbd2cSJim Jagielski }
595*b1cdbd2cSJim Jagielski buffer.append( GetEntryText( _pEntry ) );
596*b1cdbd2cSJim Jagielski }
597*b1cdbd2cSJim Jagielski }
598*b1cdbd2cSJim Jagielski else
599*b1cdbd2cSJim Jagielski {
600*b1cdbd2cSJim Jagielski aObject.Type = DatabaseObject::TABLE;
601*b1cdbd2cSJim Jagielski aObject.Name = getQualifiedTableName( _pEntry );
602*b1cdbd2cSJim Jagielski }
603*b1cdbd2cSJim Jagielski
604*b1cdbd2cSJim Jagielski return aObject;
605*b1cdbd2cSJim Jagielski }
606*b1cdbd2cSJim Jagielski
607*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
addedTable(const::rtl::OUString & _rName)608*b1cdbd2cSJim Jagielski SvLBoxEntry* OTableTreeListBox::addedTable( const ::rtl::OUString& _rName )
609*b1cdbd2cSJim Jagielski {
610*b1cdbd2cSJim Jagielski try
611*b1cdbd2cSJim Jagielski {
612*b1cdbd2cSJim Jagielski Reference< XDatabaseMetaData > xMeta;
613*b1cdbd2cSJim Jagielski if ( impl_getAndAssertMetaData( xMeta ) )
614*b1cdbd2cSJim Jagielski return implAddEntry( xMeta, _rName );
615*b1cdbd2cSJim Jagielski }
616*b1cdbd2cSJim Jagielski catch( const Exception& )
617*b1cdbd2cSJim Jagielski {
618*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
619*b1cdbd2cSJim Jagielski }
620*b1cdbd2cSJim Jagielski return NULL;
621*b1cdbd2cSJim Jagielski }
622*b1cdbd2cSJim Jagielski
623*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
impl_getAndAssertMetaData(Reference<XDatabaseMetaData> & _out_rMetaData) const624*b1cdbd2cSJim Jagielski bool OTableTreeListBox::impl_getAndAssertMetaData( Reference< XDatabaseMetaData >& _out_rMetaData ) const
625*b1cdbd2cSJim Jagielski {
626*b1cdbd2cSJim Jagielski if ( m_xConnection.is() )
627*b1cdbd2cSJim Jagielski _out_rMetaData = m_xConnection->getMetaData();
628*b1cdbd2cSJim Jagielski OSL_PRECOND( _out_rMetaData.is(), "OTableTreeListBox::impl_getAndAssertMetaData: invalid current connection!" );
629*b1cdbd2cSJim Jagielski return _out_rMetaData.is();
630*b1cdbd2cSJim Jagielski }
631*b1cdbd2cSJim Jagielski
632*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
getQualifiedTableName(SvLBoxEntry * _pEntry) const633*b1cdbd2cSJim Jagielski String OTableTreeListBox::getQualifiedTableName( SvLBoxEntry* _pEntry ) const
634*b1cdbd2cSJim Jagielski {
635*b1cdbd2cSJim Jagielski OSL_PRECOND( !isFolderEntry( _pEntry ), "OTableTreeListBox::getQualifiedTableName: folder entries not allowed here!" );
636*b1cdbd2cSJim Jagielski
637*b1cdbd2cSJim Jagielski try
638*b1cdbd2cSJim Jagielski {
639*b1cdbd2cSJim Jagielski Reference< XDatabaseMetaData > xMeta;
640*b1cdbd2cSJim Jagielski if ( !impl_getAndAssertMetaData( xMeta ) )
641*b1cdbd2cSJim Jagielski return String();
642*b1cdbd2cSJim Jagielski
643*b1cdbd2cSJim Jagielski ::rtl::OUString sCatalog;
644*b1cdbd2cSJim Jagielski ::rtl::OUString sSchema;
645*b1cdbd2cSJim Jagielski ::rtl::OUString sTable;
646*b1cdbd2cSJim Jagielski
647*b1cdbd2cSJim Jagielski SvLBoxEntry* pSchema = GetParent( _pEntry );
648*b1cdbd2cSJim Jagielski if ( pSchema )
649*b1cdbd2cSJim Jagielski {
650*b1cdbd2cSJim Jagielski SvLBoxEntry* pCatalog = GetParent( pSchema );
651*b1cdbd2cSJim Jagielski if ( pCatalog
652*b1cdbd2cSJim Jagielski || ( xMeta->supportsCatalogsInDataManipulation()
653*b1cdbd2cSJim Jagielski && !xMeta->supportsSchemasInDataManipulation()
654*b1cdbd2cSJim Jagielski ) // here we support catalog but no schema
655*b1cdbd2cSJim Jagielski )
656*b1cdbd2cSJim Jagielski {
657*b1cdbd2cSJim Jagielski if ( pCatalog == NULL )
658*b1cdbd2cSJim Jagielski {
659*b1cdbd2cSJim Jagielski pCatalog = pSchema;
660*b1cdbd2cSJim Jagielski pSchema = NULL;
661*b1cdbd2cSJim Jagielski }
662*b1cdbd2cSJim Jagielski sCatalog = GetEntryText( pCatalog );
663*b1cdbd2cSJim Jagielski }
664*b1cdbd2cSJim Jagielski if ( pSchema )
665*b1cdbd2cSJim Jagielski sSchema = GetEntryText(pSchema);
666*b1cdbd2cSJim Jagielski }
667*b1cdbd2cSJim Jagielski sTable = GetEntryText( _pEntry );
668*b1cdbd2cSJim Jagielski
669*b1cdbd2cSJim Jagielski return ::dbtools::composeTableName( xMeta, sCatalog, sSchema, sTable, sal_False, ::dbtools::eInDataManipulation );
670*b1cdbd2cSJim Jagielski }
671*b1cdbd2cSJim Jagielski catch( const Exception& )
672*b1cdbd2cSJim Jagielski {
673*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
674*b1cdbd2cSJim Jagielski }
675*b1cdbd2cSJim Jagielski return String();
676*b1cdbd2cSJim Jagielski }
677*b1cdbd2cSJim Jagielski
678*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
getEntryByQualifiedName(const::rtl::OUString & _rName)679*b1cdbd2cSJim Jagielski SvLBoxEntry* OTableTreeListBox::getEntryByQualifiedName( const ::rtl::OUString& _rName )
680*b1cdbd2cSJim Jagielski {
681*b1cdbd2cSJim Jagielski try
682*b1cdbd2cSJim Jagielski {
683*b1cdbd2cSJim Jagielski Reference< XDatabaseMetaData > xMeta;
684*b1cdbd2cSJim Jagielski if ( !impl_getAndAssertMetaData( xMeta ) )
685*b1cdbd2cSJim Jagielski return NULL;
686*b1cdbd2cSJim Jagielski
687*b1cdbd2cSJim Jagielski // split the complete name into it's components
688*b1cdbd2cSJim Jagielski ::rtl::OUString sCatalog, sSchema, sName;
689*b1cdbd2cSJim Jagielski qualifiedNameComponents(xMeta, _rName, sCatalog, sSchema, sName,::dbtools::eInDataManipulation);
690*b1cdbd2cSJim Jagielski
691*b1cdbd2cSJim Jagielski SvLBoxEntry* pParent = getAllObjectsEntry();
692*b1cdbd2cSJim Jagielski SvLBoxEntry* pCat = NULL;
693*b1cdbd2cSJim Jagielski SvLBoxEntry* pSchema = NULL;
694*b1cdbd2cSJim Jagielski if ( sCatalog.getLength() )
695*b1cdbd2cSJim Jagielski {
696*b1cdbd2cSJim Jagielski pCat = GetEntryPosByName(sCatalog, pParent);
697*b1cdbd2cSJim Jagielski if ( pCat )
698*b1cdbd2cSJim Jagielski pParent = pCat;
699*b1cdbd2cSJim Jagielski }
700*b1cdbd2cSJim Jagielski
701*b1cdbd2cSJim Jagielski if ( sSchema.getLength() )
702*b1cdbd2cSJim Jagielski {
703*b1cdbd2cSJim Jagielski pSchema = GetEntryPosByName(sSchema, pParent);
704*b1cdbd2cSJim Jagielski if ( pSchema )
705*b1cdbd2cSJim Jagielski pParent = pSchema;
706*b1cdbd2cSJim Jagielski }
707*b1cdbd2cSJim Jagielski
708*b1cdbd2cSJim Jagielski return GetEntryPosByName(sName, pParent);
709*b1cdbd2cSJim Jagielski }
710*b1cdbd2cSJim Jagielski catch( const Exception& )
711*b1cdbd2cSJim Jagielski {
712*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
713*b1cdbd2cSJim Jagielski }
714*b1cdbd2cSJim Jagielski return NULL;
715*b1cdbd2cSJim Jagielski }
716*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
removedTable(const::rtl::OUString & _rName)717*b1cdbd2cSJim Jagielski void OTableTreeListBox::removedTable( const ::rtl::OUString& _rName )
718*b1cdbd2cSJim Jagielski {
719*b1cdbd2cSJim Jagielski try
720*b1cdbd2cSJim Jagielski {
721*b1cdbd2cSJim Jagielski SvLBoxEntry* pEntry = getEntryByQualifiedName( _rName );
722*b1cdbd2cSJim Jagielski if ( pEntry )
723*b1cdbd2cSJim Jagielski GetModel()->Remove( pEntry );
724*b1cdbd2cSJim Jagielski }
725*b1cdbd2cSJim Jagielski catch( const Exception& )
726*b1cdbd2cSJim Jagielski {
727*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION();
728*b1cdbd2cSJim Jagielski }
729*b1cdbd2cSJim Jagielski }
730*b1cdbd2cSJim Jagielski
731*b1cdbd2cSJim Jagielski //.........................................................................
732*b1cdbd2cSJim Jagielski } // namespace dbaui
733*b1cdbd2cSJim Jagielski //.........................................................................
734*b1cdbd2cSJim Jagielski
735