LCOV - code coverage report
Current view: top level - dbaccess/source/ui/control - tabletree.cxx (source / functions) Hit Total Coverage
Test: commit e02a6cb2c3e2b23b203b422e4e0680877f232636 Lines: 0 289 0.0 %
Date: 2014-04-14 Functions: 0 29 0.0 %
Legend: Lines: hit not hit

          Line data    Source code
       1             : /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
       2             : /*
       3             :  * This file is part of the LibreOffice project.
       4             :  *
       5             :  * This Source Code Form is subject to the terms of the Mozilla Public
       6             :  * License, v. 2.0. If a copy of the MPL was not distributed with this
       7             :  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
       8             :  *
       9             :  * This file incorporates work covered by the following license notice:
      10             :  *
      11             :  *   Licensed to the Apache Software Foundation (ASF) under one or more
      12             :  *   contributor license agreements. See the NOTICE file distributed
      13             :  *   with this work for additional information regarding copyright
      14             :  *   ownership. The ASF licenses this file to you under the Apache
      15             :  *   License, Version 2.0 (the "License"); you may not use this file
      16             :  *   except in compliance with the License. You may obtain a copy of
      17             :  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
      18             :  */
      19             : 
      20             : #include "tabletree.hxx"
      21             : #include "imageprovider.hxx"
      22             : #include "moduledbu.hxx"
      23             : #include "dbu_control.hrc"
      24             : #include <vcl/layout.hxx>
      25             : #include <vcl/menu.hxx>
      26             : #include <connectivity/dbtools.hxx>
      27             : #include <comphelper/types.hxx>
      28             : #include "dbustrings.hrc"
      29             : #include <com/sun/star/sdb/application/DatabaseObject.hpp>
      30             : #include <com/sun/star/sdb/application/DatabaseObjectContainer.hpp>
      31             : #include <com/sun/star/sdbc/XDriverAccess.hpp>
      32             : #include <com/sun/star/sdbcx/XDataDefinitionSupplier.hpp>
      33             : #include <com/sun/star/sdbcx/XViewsSupplier.hpp>
      34             : #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
      35             : #include <com/sun/star/sdb/SQLContext.hpp>
      36             : #include <com/sun/star/sdbc/XRow.hpp>
      37             : #include <com/sun/star/beans/XPropertySet.hpp>
      38             : #include "commontypes.hxx"
      39             : #include "listviewitems.hxx"
      40             : #include <tools/diagnose_ex.h>
      41             : #include <osl/diagnose.h>
      42             : #include <rtl/ustrbuf.hxx>
      43             : #include <connectivity/dbmetadata.hxx>
      44             : #include "svtools/treelistentry.hxx"
      45             : 
      46             : #include <algorithm>
      47             : #include <o3tl/compat_functional.hxx>
      48             : 
      49             : namespace dbaui
      50             : {
      51             : 
      52             : using namespace ::com::sun::star::uno;
      53             : using namespace ::com::sun::star::sdb;
      54             : using namespace ::com::sun::star::lang;
      55             : using namespace ::com::sun::star::sdbc;
      56             : using namespace ::com::sun::star::sdbcx;
      57             : using namespace ::com::sun::star::beans;
      58             : using namespace ::com::sun::star::container;
      59             : using namespace ::com::sun::star::sdb::application;
      60             : 
      61             : using namespace ::dbtools;
      62             : using namespace ::comphelper;
      63             : 
      64             : namespace DatabaseObject = ::com::sun::star::sdb::application::DatabaseObject;
      65             : namespace DatabaseObjectContainer = ::com::sun::star::sdb::application::DatabaseObjectContainer;
      66             : 
      67             : // OTableTreeListBox
      68           0 : OTableTreeListBox::OTableTreeListBox(Window* pParent, WinBits nWinStyle)
      69             :     :OMarkableTreeListBox(pParent, nWinStyle)
      70           0 :     ,m_xImageProvider( new ImageProvider )
      71             :     ,m_bVirtualRoot(false)
      72           0 :     ,m_bNoEmptyFolders( false )
      73             : {
      74           0 :     implSetDefaultImages();
      75           0 : }
      76             : 
      77           0 : extern "C" SAL_DLLPUBLIC_EXPORT Window* SAL_CALL makeOTableTreeListBox(Window *pParent, VclBuilder::stringmap &rMap)
      78             : {
      79           0 :     WinBits nWinStyle = 0;
      80           0 :     OString sBorder = VclBuilder::extractCustomProperty(rMap);
      81           0 :     if (!sBorder.isEmpty())
      82           0 :         nWinStyle |= WB_BORDER;
      83           0 :     return new OTableTreeListBox(pParent, nWinStyle);
      84             : }
      85             : 
      86           0 : void OTableTreeListBox::implSetDefaultImages()
      87             : {
      88           0 :     ImageProvider aImageProvider;
      89           0 :     SetDefaultExpandedEntryBmp(  aImageProvider.getFolderImage( DatabaseObject::TABLE ) );
      90           0 :     SetDefaultCollapsedEntryBmp( aImageProvider.getFolderImage( DatabaseObject::TABLE ) );
      91           0 : }
      92             : 
      93           0 : bool  OTableTreeListBox::isFolderEntry( const SvTreeListEntry* _pEntry ) const
      94             : {
      95           0 :     sal_Int32 nEntryType = reinterpret_cast< sal_IntPtr >( _pEntry->GetUserData() );
      96           0 :     if  (   ( nEntryType == DatabaseObjectContainer::TABLES )
      97           0 :         ||  ( nEntryType == DatabaseObjectContainer::CATALOG )
      98           0 :         ||  ( nEntryType == DatabaseObjectContainer::SCHEMA )
      99             :         )
     100           0 :         return true;
     101           0 :     return false;
     102             : }
     103             : 
     104           0 : void OTableTreeListBox::notifyHiContrastChanged()
     105             : {
     106           0 :     implSetDefaultImages();
     107             : 
     108           0 :     SvTreeListEntry* pEntryLoop = First();
     109           0 :     while (pEntryLoop)
     110             :     {
     111           0 :         size_t nCount = pEntryLoop->ItemCount();
     112           0 :         for (size_t i=0;i<nCount;++i)
     113             :         {
     114           0 :             SvLBoxItem* pItem = pEntryLoop->GetItem(i);
     115           0 :             if (pItem && pItem->GetType() == SV_ITEM_ID_LBOXCONTEXTBMP)
     116             :             {
     117           0 :                 SvLBoxContextBmp* pContextBitmapItem = static_cast< SvLBoxContextBmp* >( pItem );
     118             : 
     119           0 :                 Image aImage;
     120           0 :                 if ( isFolderEntry( pEntryLoop ) )
     121             :                 {
     122           0 :                     aImage = m_xImageProvider->getFolderImage( DatabaseObject::TABLE );
     123             :                 }
     124             :                 else
     125             :                 {
     126           0 :                     OUString sCompleteName( getQualifiedTableName( pEntryLoop ) );
     127           0 :                     m_xImageProvider->getImages( sCompleteName, DatabaseObject::TABLE, aImage );
     128             :                 }
     129             : 
     130           0 :                 pContextBitmapItem->SetBitmap1( aImage );
     131           0 :                 pContextBitmapItem->SetBitmap2( aImage );
     132           0 :                 break;
     133             :             }
     134             :         }
     135           0 :         pEntryLoop = Next(pEntryLoop);
     136             :     }
     137           0 : }
     138             : 
     139           0 : void OTableTreeListBox::implOnNewConnection( const Reference< XConnection >& _rxConnection )
     140             : {
     141           0 :     m_xConnection = _rxConnection;
     142           0 :     m_xImageProvider.reset( new ImageProvider( m_xConnection  ) );
     143           0 : }
     144             : 
     145           0 : void OTableTreeListBox::UpdateTableList( const Reference< XConnection >& _rxConnection ) throw(SQLException)
     146             : {
     147           0 :     Sequence< OUString > sTables, sViews;
     148             : 
     149           0 :     OUString sCurrentActionError;
     150             :     try
     151             :     {
     152           0 :         Reference< XTablesSupplier > xTableSupp( _rxConnection, UNO_QUERY_THROW );
     153           0 :         sCurrentActionError = ModuleRes(STR_NOTABLEINFO);
     154             : 
     155           0 :         Reference< XNameAccess > xTables,xViews;
     156             : 
     157           0 :         Reference< XViewsSupplier > xViewSupp( _rxConnection, UNO_QUERY );
     158           0 :         if ( xViewSupp.is() )
     159             :         {
     160           0 :             xViews = xViewSupp->getViews();
     161           0 :             if (xViews.is())
     162           0 :                 sViews = xViews->getElementNames();
     163             :         }
     164             : 
     165           0 :         xTables = xTableSupp->getTables();
     166           0 :         if (xTables.is())
     167           0 :             sTables = xTables->getElementNames();
     168             :     }
     169           0 :     catch(RuntimeException&)
     170             :     {
     171             :         OSL_FAIL("OTableTreeListBox::UpdateTableList : caught an RuntimeException!");
     172             :     }
     173           0 :     catch ( const SQLException& )
     174             :     {
     175           0 :         throw;
     176             :     }
     177           0 :     catch(Exception&)
     178             :     {
     179             :         // a non-SQLException exception occurred ... simply throw an SQLException
     180           0 :         SQLException aInfo;
     181           0 :         aInfo.Message = sCurrentActionError;
     182           0 :         throw aInfo;
     183             :     }
     184             : 
     185           0 :     UpdateTableList( _rxConnection, sTables, sViews );
     186           0 : }
     187             : 
     188             : namespace
     189             : {
     190           0 :     struct OViewSetter : public ::std::unary_function< OTableTreeListBox::TNames::value_type, bool>
     191             :     {
     192             :         const Sequence< OUString> m_aViews;
     193             :         ::comphelper::UStringMixEqual m_aEqualFunctor;
     194             : 
     195           0 :         OViewSetter(const Sequence< OUString>& _rViews,sal_Bool _bCase) : m_aViews(_rViews),m_aEqualFunctor(_bCase){}
     196           0 :         OTableTreeListBox::TNames::value_type operator() (const OUString& lhs)
     197             :         {
     198           0 :             OTableTreeListBox::TNames::value_type aRet;
     199           0 :             aRet.first = lhs;
     200           0 :             const OUString* pIter = m_aViews.getConstArray();
     201           0 :             const OUString* pEnd = m_aViews.getConstArray() + m_aViews.getLength();
     202           0 :             aRet.second = (::std::find_if(pIter,pEnd,::std::bind2nd(m_aEqualFunctor,lhs)) != pEnd);
     203             : 
     204           0 :             return aRet;
     205             :         }
     206             :     };
     207             : 
     208             : }
     209             : 
     210           0 : void OTableTreeListBox::UpdateTableList(
     211             :                 const Reference< XConnection >& _rxConnection,
     212             :                 const Sequence< OUString>& _rTables,
     213             :                 const Sequence< OUString>& _rViews
     214             :             )
     215             : {
     216           0 :     TNames aTables;
     217           0 :     aTables.resize(_rTables.getLength());
     218           0 :     const OUString* pIter = _rTables.getConstArray();
     219           0 :     const OUString* pEnd = _rTables.getConstArray() + _rTables.getLength();
     220             :     try
     221             :     {
     222           0 :         Reference< XDatabaseMetaData > xMeta( _rxConnection->getMetaData(), UNO_QUERY_THROW );
     223             :         ::std::transform( pIter, pEnd,
     224           0 :             aTables.begin(), OViewSetter( _rViews, xMeta->supportsMixedCaseQuotedIdentifiers() ) );
     225             :     }
     226           0 :     catch(Exception&)
     227             :     {
     228             :         DBG_UNHANDLED_EXCEPTION();
     229             :     }
     230           0 :     UpdateTableList( _rxConnection, aTables );
     231           0 : }
     232             : 
     233             : namespace
     234             : {
     235           0 :     ::std::vector< OUString > lcl_getMetaDataStrings_throw( const Reference< XResultSet >& _rxMetaDataResult, sal_Int32 _nColumnIndex )
     236             :     {
     237           0 :         ::std::vector< OUString > aStrings;
     238           0 :         Reference< XRow > xRow( _rxMetaDataResult, UNO_QUERY_THROW );
     239           0 :         while ( _rxMetaDataResult->next() )
     240           0 :             aStrings.push_back( xRow->getString( _nColumnIndex ) );
     241           0 :         return aStrings;
     242             :     }
     243             : 
     244           0 :     bool lcl_shouldDisplayEmptySchemasAndCatalogs( const Reference< XConnection >& _rxConnection )
     245             :     {
     246           0 :         ::dbtools::DatabaseMetaData aMetaData( _rxConnection );
     247           0 :         return aMetaData.displayEmptyTableFolders();
     248             :     }
     249             : }
     250             : 
     251           0 : void OTableTreeListBox::UpdateTableList( const Reference< XConnection >& _rxConnection, const TNames& _rTables )
     252             : {
     253           0 :     implOnNewConnection( _rxConnection );
     254             : 
     255             :     // throw away all the old stuff
     256           0 :     Clear();
     257             : 
     258             :     try
     259             :     {
     260           0 :         if (haveVirtualRoot())
     261             :         {
     262           0 :             OUString sRootEntryText;
     263             :             TNames::const_iterator aViews = ::std::find_if(_rTables.begin(),_rTables.end(),
     264           0 :             ::o3tl::compose1(::std::bind2nd(::std::equal_to<sal_Bool>(),sal_False),::o3tl::select2nd<TNames::value_type>()));
     265             :             TNames::const_iterator aTables = ::std::find_if(_rTables.begin(),_rTables.end(),
     266           0 :             ::o3tl::compose1(::std::bind2nd(::std::equal_to<sal_Bool>(),sal_True),::o3tl::select2nd<TNames::value_type>()));
     267             : 
     268           0 :             if ( aViews == _rTables.end() )
     269           0 :                 sRootEntryText  = ModuleRes(STR_ALL_TABLES);
     270           0 :             else if ( aTables == _rTables.end() )
     271           0 :                 sRootEntryText  = ModuleRes(STR_ALL_VIEWS);
     272             :             else
     273           0 :                 sRootEntryText  = ModuleRes(STR_ALL_TABLES_AND_VIEWS);
     274           0 :             InsertEntry( sRootEntryText, NULL, false, TREELIST_APPEND, reinterpret_cast< void* >( DatabaseObjectContainer::TABLES ) );
     275             :         }
     276             : 
     277           0 :         if ( _rTables.empty() )
     278             :             // nothing to do (besides inserting the root entry)
     279           0 :             return;
     280             : 
     281             :         // get the table/view names
     282           0 :         TNames::const_iterator aIter = _rTables.begin();
     283           0 :         TNames::const_iterator aEnd = _rTables.end();
     284             : 
     285           0 :         Reference< XDatabaseMetaData > xMeta( _rxConnection->getMetaData(), UNO_QUERY_THROW );
     286           0 :         for ( ; aIter != aEnd; ++aIter )
     287             :         {
     288             :             // add the entry
     289             :             implAddEntry(
     290             :                 xMeta,
     291           0 :                 aIter->first,
     292             :                 sal_False
     293           0 :             );
     294             :         }
     295             : 
     296           0 :         if ( !m_bNoEmptyFolders && lcl_shouldDisplayEmptySchemasAndCatalogs( _rxConnection ) )
     297             :         {
     298           0 :             sal_Bool bSupportsCatalogs = xMeta->supportsCatalogsInDataManipulation();
     299           0 :             sal_Bool bSupportsSchemas = xMeta->supportsSchemasInDataManipulation();
     300             : 
     301           0 :             if ( bSupportsCatalogs || bSupportsSchemas )
     302             :             {
     303             :                 // we display empty catalogs if the DB supports catalogs, and they're noted at the beginning of a
     304             :                 // composed name. Otherwise, we display empty schematas. (also see the tree structure explained in
     305             :                 // implAddEntry)
     306           0 :                 bool bCatalogs = bSupportsCatalogs && xMeta->isCatalogAtStart();
     307             : 
     308             :                 ::std::vector< OUString > aFolderNames( lcl_getMetaDataStrings_throw(
     309           0 :                     bCatalogs ? xMeta->getCatalogs() : xMeta->getSchemas(), 1 ) );
     310           0 :                 sal_Int32 nFolderType = bCatalogs ? DatabaseObjectContainer::CATALOG : DatabaseObjectContainer::SCHEMA;
     311             : 
     312           0 :                 SvTreeListEntry* pRootEntry = getAllObjectsEntry();
     313           0 :                 for (   ::std::vector< OUString >::const_iterator folder = aFolderNames.begin();
     314           0 :                         folder != aFolderNames.end();
     315             :                         ++folder
     316             :                     )
     317             :                 {
     318           0 :                     SvTreeListEntry* pFolder = GetEntryPosByName( *folder, pRootEntry );
     319           0 :                     if ( !pFolder )
     320           0 :                         pFolder = InsertEntry( *folder, pRootEntry, false, TREELIST_APPEND, reinterpret_cast< void* >( nFolderType ) );
     321           0 :                 }
     322             :             }
     323           0 :         }
     324             :     }
     325           0 :     catch ( const Exception& )
     326             :     {
     327             :         DBG_UNHANDLED_EXCEPTION();
     328             :     }
     329             : }
     330             : 
     331           0 : sal_Bool OTableTreeListBox::isWildcardChecked(SvTreeListEntry* _pEntry) const
     332             : {
     333           0 :     if (_pEntry)
     334             :     {
     335           0 :         OBoldListboxString* pTextItem = static_cast<OBoldListboxString*>(_pEntry->GetFirstItem(SV_ITEM_ID_BOLDLBSTRING));
     336           0 :         if (pTextItem)
     337           0 :             return pTextItem->isEmphasized();
     338             :     }
     339           0 :     return sal_False;
     340             : }
     341             : 
     342           0 : void OTableTreeListBox::checkWildcard(SvTreeListEntry* _pEntry)
     343             : {
     344           0 :     SetCheckButtonState(_pEntry, SV_BUTTON_CHECKED);
     345           0 :     checkedButton_noBroadcast(_pEntry);
     346           0 : }
     347             : 
     348           0 : SvTreeListEntry* OTableTreeListBox::getAllObjectsEntry() const
     349             : {
     350           0 :     return haveVirtualRoot() ? First() : NULL;
     351             : }
     352             : 
     353           0 : void OTableTreeListBox::checkedButton_noBroadcast(SvTreeListEntry* _pEntry)
     354             : {
     355           0 :     OMarkableTreeListBox::checkedButton_noBroadcast(_pEntry);
     356             : 
     357             :     // if an entry has children, it makes a difference if the entry is checked
     358             :     // because all children are checked or if the user checked it explicitly.
     359             :     // So we track explicit (un)checking
     360             : 
     361           0 :     SvButtonState eState = GetCheckButtonState(_pEntry);
     362             :     OSL_ENSURE(SV_BUTTON_TRISTATE != eState, "OTableTreeListBox::CheckButtonHdl: user action which lead to TRISTATE?");
     363           0 :     implEmphasize(_pEntry, SV_BUTTON_CHECKED == eState);
     364           0 : }
     365             : 
     366           0 : void OTableTreeListBox::implEmphasize(SvTreeListEntry* _pEntry, sal_Bool _bChecked, sal_Bool _bUpdateDescendants, sal_Bool _bUpdateAncestors)
     367             : {
     368             :     OSL_ENSURE(_pEntry, "OTableTreeListBox::implEmphasize: invalid entry (NULL)!");
     369             : 
     370             :     // special emphasizing handling for the "all objects" entry
     371           0 :     sal_Bool bAllObjectsEntryAffected = haveVirtualRoot() && (getAllObjectsEntry() == _pEntry);
     372           0 :     if  (   GetModel()->HasChildren(_pEntry)              // the entry has children
     373           0 :         ||  bAllObjectsEntryAffected                    // or it is the "all objects" entry
     374             :         )
     375             :     {
     376           0 :         OBoldListboxString* pTextItem = static_cast<OBoldListboxString*>(_pEntry->GetFirstItem(SV_ITEM_ID_BOLDLBSTRING));
     377           0 :         if (pTextItem)
     378           0 :             pTextItem->emphasize(_bChecked);
     379             : 
     380           0 :         if (bAllObjectsEntryAffected)
     381           0 :             InvalidateEntry(_pEntry);
     382             :     }
     383             : 
     384           0 :     if (_bUpdateDescendants)
     385             :     {
     386             :         // remove the mark for all children of the checked entry
     387           0 :         SvTreeListEntry* pChildLoop = FirstChild(_pEntry);
     388           0 :         while (pChildLoop)
     389             :         {
     390           0 :             if (GetModel()->HasChildren(pChildLoop))
     391           0 :                 implEmphasize(pChildLoop, sal_False, sal_True, sal_False);
     392           0 :             pChildLoop = NextSibling(pChildLoop);
     393             :         }
     394             :     }
     395             : 
     396           0 :     if (_bUpdateAncestors)
     397             :     {
     398             :         // remove the mark for all ancestors of the entry
     399           0 :         if (GetModel()->HasParent(_pEntry))
     400           0 :             implEmphasize(GetParent(_pEntry), sal_False, sal_False, sal_True);
     401             :     }
     402           0 : }
     403             : 
     404           0 : void OTableTreeListBox::InitEntry(SvTreeListEntry* _pEntry, const OUString& _rString, const Image& _rCollapsedBitmap, const Image& _rExpandedBitmap, SvLBoxButtonKind _eButtonKind)
     405             : {
     406           0 :     OMarkableTreeListBox::InitEntry(_pEntry, _rString, _rCollapsedBitmap, _rExpandedBitmap, _eButtonKind);
     407             : 
     408             :     // replace the text item with our own one
     409           0 :     SvLBoxItem* pTextItem = _pEntry->GetFirstItem(SV_ITEM_ID_LBOXSTRING);
     410             :     OSL_ENSURE(pTextItem, "OTableTreeListBox::InitEntry: no text item!?");
     411           0 :     size_t nTextPos = _pEntry->GetPos(pTextItem);
     412             :     OSL_ENSURE(SvTreeListEntry::ITEM_NOT_FOUND != nTextPos, "OTableTreeListBox::InitEntry: no text item pos!");
     413             : 
     414           0 :     _pEntry->ReplaceItem(new OBoldListboxString(_pEntry, 0, _rString), nTextPos);
     415           0 : }
     416             : 
     417           0 : SvTreeListEntry* OTableTreeListBox::implAddEntry(
     418             :         const Reference< XDatabaseMetaData >& _rxMeta,
     419             :         const OUString& _rTableName,
     420             :         sal_Bool _bCheckName
     421             :     )
     422             : {
     423             :     OSL_PRECOND( _rxMeta.is(), "OTableTreeListBox::implAddEntry: invalid meta data!" );
     424           0 :     if ( !_rxMeta.is() )
     425           0 :         return NULL;
     426             : 
     427             :     // split the complete name into it's components
     428           0 :     OUString sCatalog, sSchema, sName;
     429           0 :     qualifiedNameComponents( _rxMeta, _rTableName, sCatalog, sSchema, sName, ::dbtools::eInDataManipulation );
     430             : 
     431           0 :     SvTreeListEntry* pParentEntry = getAllObjectsEntry();
     432             : 
     433             :     // if the DB uses catalog at the start of identifiers, then our hierarchy is
     434             :     //   catalog
     435             :     //   +- schema
     436             :     //      +- table
     437             :     // else it is
     438             :     //   schema
     439             :     //   +- catalog
     440             :     //      +- table
     441           0 :     sal_Bool bCatalogAtStart = _rxMeta->isCatalogAtStart();
     442           0 :     const OUString& rFirstName  = bCatalogAtStart ? sCatalog : sSchema;
     443           0 :     const sal_Int32 nFirstFolderType   = bCatalogAtStart ? DatabaseObjectContainer::CATALOG : DatabaseObjectContainer::SCHEMA;
     444           0 :     const OUString& rSecondName = bCatalogAtStart ? sSchema : sCatalog;
     445           0 :     const sal_Int32 nSecondFolderType  = bCatalogAtStart ? DatabaseObjectContainer::SCHEMA : DatabaseObjectContainer::CATALOG;
     446             : 
     447           0 :     if ( !rFirstName.isEmpty() )
     448             :     {
     449           0 :         SvTreeListEntry* pFolder = GetEntryPosByName( rFirstName, pParentEntry );
     450           0 :         if ( !pFolder )
     451           0 :             pFolder = InsertEntry( rFirstName, pParentEntry, false, TREELIST_APPEND, reinterpret_cast< void* >( nFirstFolderType ) );
     452           0 :         pParentEntry = pFolder;
     453             :     }
     454             : 
     455           0 :     if ( !rSecondName.isEmpty() )
     456             :     {
     457           0 :         SvTreeListEntry* pFolder = GetEntryPosByName( rSecondName, pParentEntry );
     458           0 :         if ( !pFolder )
     459           0 :             pFolder = InsertEntry( rSecondName, pParentEntry, false, TREELIST_APPEND, reinterpret_cast< void* >( nSecondFolderType ) );
     460           0 :         pParentEntry = pFolder;
     461             :     }
     462             : 
     463           0 :     SvTreeListEntry* pRet = NULL;
     464           0 :     if ( !_bCheckName || !GetEntryPosByName( sName, pParentEntry ) )
     465             :     {
     466           0 :         pRet = InsertEntry( sName, pParentEntry, false, TREELIST_APPEND );
     467             : 
     468           0 :         Image aImage;
     469           0 :         m_xImageProvider->getImages( _rTableName, DatabaseObject::TABLE, aImage );
     470             : 
     471           0 :         SetExpandedEntryBmp( pRet, aImage );
     472           0 :         SetCollapsedEntryBmp( pRet, aImage );
     473             :     }
     474           0 :     return pRet;
     475             : }
     476             : 
     477           0 : NamedDatabaseObject OTableTreeListBox::describeObject( SvTreeListEntry* _pEntry )
     478             : {
     479           0 :     NamedDatabaseObject aObject;
     480             : 
     481           0 :     sal_Int32 nEntryType = reinterpret_cast< sal_IntPtr >( _pEntry->GetUserData() );
     482             : 
     483           0 :     if  ( nEntryType == DatabaseObjectContainer::TABLES )
     484             :     {
     485           0 :         aObject.Type = DatabaseObjectContainer::TABLES;
     486             :     }
     487           0 :     else if (   ( nEntryType == DatabaseObjectContainer::CATALOG )
     488           0 :             ||  ( nEntryType == DatabaseObjectContainer::SCHEMA )
     489             :             )
     490             :     {
     491           0 :         SvTreeListEntry* pParent = GetParent( _pEntry );
     492           0 :         sal_Int32 nParentEntryType = pParent ? reinterpret_cast< sal_IntPtr >( pParent->GetUserData() ) : -1;
     493             : 
     494           0 :         OUStringBuffer buffer;
     495           0 :         if  ( nEntryType == DatabaseObjectContainer::CATALOG )
     496             :         {
     497           0 :             if ( nParentEntryType == DatabaseObjectContainer::SCHEMA )
     498             :             {
     499           0 :                 buffer.append( GetEntryText( pParent ) );
     500           0 :                 buffer.append( '.' );
     501             :             }
     502           0 :             buffer.append( GetEntryText( _pEntry ) );
     503             :         }
     504           0 :         else if ( nEntryType == DatabaseObjectContainer::SCHEMA )
     505             :         {
     506           0 :             if ( nParentEntryType == DatabaseObjectContainer::CATALOG )
     507             :             {
     508           0 :                 buffer.append( GetEntryText( pParent ) );
     509           0 :                 buffer.append( '.' );
     510             :             }
     511           0 :             buffer.append( GetEntryText( _pEntry ) );
     512           0 :         }
     513             :     }
     514             :     else
     515             :     {
     516           0 :         aObject.Type = DatabaseObject::TABLE;
     517           0 :         aObject.Name = getQualifiedTableName( _pEntry );
     518             :     }
     519             : 
     520           0 :     return aObject;
     521             : }
     522             : 
     523           0 : SvTreeListEntry* OTableTreeListBox::addedTable( const OUString& _rName )
     524             : {
     525             :     try
     526             :     {
     527           0 :         Reference< XDatabaseMetaData > xMeta;
     528           0 :         if ( impl_getAndAssertMetaData( xMeta ) )
     529           0 :             return implAddEntry( xMeta, _rName );
     530             :     }
     531           0 :     catch( const Exception& )
     532             :     {
     533             :         DBG_UNHANDLED_EXCEPTION();
     534             :     }
     535           0 :     return NULL;
     536             : }
     537             : 
     538           0 : bool OTableTreeListBox::impl_getAndAssertMetaData( Reference< XDatabaseMetaData >& _out_rMetaData ) const
     539             : {
     540           0 :     if ( m_xConnection.is() )
     541           0 :         _out_rMetaData = m_xConnection->getMetaData();
     542             :     OSL_PRECOND( _out_rMetaData.is(), "OTableTreeListBox::impl_getAndAssertMetaData: invalid current connection!" );
     543           0 :     return _out_rMetaData.is();
     544             : }
     545             : 
     546           0 : OUString OTableTreeListBox::getQualifiedTableName( SvTreeListEntry* _pEntry ) const
     547             : {
     548             :     OSL_PRECOND( !isFolderEntry( _pEntry ), "OTableTreeListBox::getQualifiedTableName: folder entries not allowed here!" );
     549             : 
     550             :     try
     551             :     {
     552           0 :         Reference< XDatabaseMetaData > xMeta;
     553           0 :         if ( !impl_getAndAssertMetaData( xMeta ) )
     554           0 :             return OUString();
     555             : 
     556           0 :         OUString sCatalog;
     557           0 :         OUString sSchema;
     558           0 :         OUString sTable;
     559             : 
     560           0 :         SvTreeListEntry* pSchema = GetParent( _pEntry );
     561           0 :         if ( pSchema )
     562             :         {
     563           0 :             SvTreeListEntry* pCatalog = GetParent( pSchema );
     564           0 :             if  (   pCatalog
     565           0 :                 ||  (   xMeta->supportsCatalogsInDataManipulation()
     566           0 :                     &&  !xMeta->supportsSchemasInDataManipulation()
     567             :                     )   // here we support catalog but no schema
     568             :                 )
     569             :             {
     570           0 :                 if ( pCatalog == NULL )
     571             :                 {
     572           0 :                     pCatalog = pSchema;
     573           0 :                     pSchema = NULL;
     574             :                 }
     575           0 :                 sCatalog = GetEntryText( pCatalog );
     576             :             }
     577           0 :             if ( pSchema )
     578           0 :                 sSchema = GetEntryText(pSchema);
     579             :         }
     580           0 :         sTable = GetEntryText( _pEntry );
     581             : 
     582           0 :         return ::dbtools::composeTableName( xMeta, sCatalog, sSchema, sTable, false, ::dbtools::eInDataManipulation );
     583             :     }
     584           0 :     catch( const Exception& )
     585             :     {
     586             :         DBG_UNHANDLED_EXCEPTION();
     587             :     }
     588           0 :     return OUString();
     589             : }
     590             : 
     591           0 : SvTreeListEntry* OTableTreeListBox::getEntryByQualifiedName( const OUString& _rName )
     592             : {
     593             :     try
     594             :     {
     595           0 :         Reference< XDatabaseMetaData > xMeta;
     596           0 :         if ( !impl_getAndAssertMetaData( xMeta ) )
     597           0 :             return NULL;
     598             : 
     599             :         // split the complete name into it's components
     600           0 :         OUString sCatalog, sSchema, sName;
     601           0 :         qualifiedNameComponents(xMeta, _rName, sCatalog, sSchema, sName,::dbtools::eInDataManipulation);
     602             : 
     603           0 :         SvTreeListEntry* pParent = getAllObjectsEntry();
     604           0 :         SvTreeListEntry* pCat = NULL;
     605           0 :         SvTreeListEntry* pSchema = NULL;
     606           0 :         if ( !sCatalog.isEmpty() )
     607             :         {
     608           0 :             pCat = GetEntryPosByName(sCatalog, pParent);
     609           0 :             if ( pCat )
     610           0 :                 pParent = pCat;
     611             :         }
     612             : 
     613           0 :         if ( !sSchema.isEmpty() )
     614             :         {
     615           0 :             pSchema = GetEntryPosByName(sSchema, pParent);
     616           0 :             if ( pSchema )
     617           0 :                 pParent = pSchema;
     618             :         }
     619             : 
     620           0 :         return GetEntryPosByName(sName, pParent);
     621             :     }
     622           0 :     catch( const Exception& )
     623             :     {
     624             :         DBG_UNHANDLED_EXCEPTION();
     625             :     }
     626           0 :     return NULL;
     627             : }
     628             : 
     629           0 : void OTableTreeListBox::removedTable( const OUString& _rName )
     630             : {
     631             :     try
     632             :     {
     633           0 :         SvTreeListEntry* pEntry = getEntryByQualifiedName( _rName );
     634           0 :         if ( pEntry )
     635           0 :             GetModel()->Remove( pEntry );
     636             :     }
     637           0 :     catch( const Exception& )
     638             :     {
     639             :         DBG_UNHANDLED_EXCEPTION();
     640             :     }
     641           0 : }
     642             : 
     643           0 : }   // namespace dbaui
     644             : 
     645             : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

Generated by: LCOV version 1.10