LCOV - code coverage report
Current view: top level - dbaccess/source/ui/dlg - tablespage.cxx (source / functions) Hit Total Coverage
Test: commit e02a6cb2c3e2b23b203b422e4e0680877f232636 Lines: 0 269 0.0 %
Date: 2014-04-14 Functions: 0 22 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 "tablespage.hxx"
      21             : #include "dbu_dlg.hrc"
      22             : #include "dbadmin.hrc"
      23             : #include "dsitems.hxx"
      24             : #include "browserids.hxx"
      25             : #include "datasourceconnector.hxx"
      26             : #include <comphelper/types.hxx>
      27             : #include <connectivity/dbtools.hxx>
      28             : #include <connectivity/dbexception.hxx>
      29             : #include "stringlistitem.hxx"
      30             : #include <svl/eitem.hxx>
      31             : #include <svl/stritem.hxx>
      32             : #include "dbustrings.hrc"
      33             : #include <vcl/svapp.hxx>
      34             : #include <vcl/settings.hxx>
      35             : #include <vcl/waitobj.hxx>
      36             : #include <com/sun/star/i18n/Collator.hpp>
      37             : #include <com/sun/star/sdb/SQLContext.hpp>
      38             : #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
      39             : #include <com/sun/star/sdbcx/XAppend.hpp>
      40             : #include <com/sun/star/util/XModifiable.hpp>
      41             : #include <com/sun/star/sdbcx/XDrop.hpp>
      42             : #include <com/sun/star/sdbcx/XDataDefinitionSupplier.hpp>
      43             : #include "sqlmessage.hxx"
      44             : #include <vcl/msgbox.hxx>
      45             : #include "dbaccess_helpid.hrc"
      46             : #include "UITools.hxx"
      47             : #include <osl/mutex.hxx>
      48             : #include <osl/diagnose.h>
      49             : #include <svtools/imgdef.hxx>
      50             : #include "svtools/treelistentry.hxx"
      51             : #include "TablesSingleDlg.hxx"
      52             : #include <tools/diagnose_ex.h>
      53             : #include <comphelper/processfactory.hxx>
      54             : #include <cppuhelper/exc_hlp.hxx>
      55             : #include "AutoControls.hrc"
      56             : 
      57             : namespace dbaui
      58             : {
      59             : 
      60             :     using namespace ::com::sun::star::uno;
      61             :     using namespace ::com::sun::star::sdbc;
      62             :     using namespace ::com::sun::star::sdbcx;
      63             :     using namespace ::com::sun::star::sdb;
      64             :     using namespace ::com::sun::star::beans;
      65             :     using namespace ::com::sun::star::lang;
      66             :     using namespace ::com::sun::star::i18n;
      67             :     using namespace ::com::sun::star::container;
      68             :     using namespace ::com::sun::star::frame;
      69             :     using namespace ::com::sun::star::util;
      70             :     using namespace ::dbtools;
      71             :     using namespace ::comphelper;
      72             : 
      73             :     // OTableSubscriptionPage
      74           0 :     OTableSubscriptionPage::OTableSubscriptionPage(Window* pParent, const SfxItemSet& _rCoreAttrs,
      75             :         OTableSubscriptionDialog* _pTablesDlg)
      76             :         : OGenericAdministrationPage(pParent, "TablesFilterPage",
      77             :             "dbaccess/ui/tablesfilterpage.ui", _rCoreAttrs)
      78             :         , m_bCatalogAtStart(true)
      79           0 :         , m_pTablesDlg(_pTablesDlg)
      80             :     {
      81           0 :         get(m_pTables, "TablesFilterPage");
      82             : 
      83           0 :         get(m_pTablesList, "treeview");
      84           0 :         m_pTablesList->set_width_request(56 * m_pTablesList->approximate_char_width());
      85           0 :         m_pTablesList->set_height_request(12 * m_pTablesList->GetTextHeight());
      86             : 
      87           0 :         m_pTablesList->SetCheckHandler(getControlModifiedLink());
      88             : 
      89             :         // initialize the TabListBox
      90           0 :         m_pTablesList->SetSelectionMode( MULTIPLE_SELECTION );
      91           0 :         m_pTablesList->SetDragDropMode( 0 );
      92           0 :         m_pTablesList->EnableInplaceEditing( false );
      93           0 :         m_pTablesList->SetStyle(m_pTablesList->GetStyle() | WB_BORDER | WB_HASLINES | WB_HASLINESATROOT | WB_SORT | WB_HASBUTTONS | WB_HSCROLL |WB_HASBUTTONSATROOT);
      94             : 
      95           0 :         m_pTablesList->Clear();
      96             : 
      97           0 :         m_pTablesList->SetCheckButtonHdl(LINK(this, OTableSubscriptionPage, OnTreeEntryChecked));
      98           0 :         m_pTablesList->SetCheckHandler(LINK(this, OTableSubscriptionPage, OnTreeEntryChecked));
      99           0 :     }
     100             : 
     101           0 :     OTableSubscriptionPage::~OTableSubscriptionPage()
     102             :     {
     103             :         // just to make sure that our connection will be removed
     104             :         try
     105             :         {
     106           0 :             ::comphelper::disposeComponent(m_xCurrentConnection);
     107             :         }
     108           0 :         catch (RuntimeException&) { }
     109             : 
     110           0 :     }
     111             : 
     112           0 :     void OTableSubscriptionPage::StateChanged( StateChangedType nType )
     113             :     {
     114           0 :         OGenericAdministrationPage::StateChanged( nType );
     115             : 
     116           0 :         if ( nType == STATE_CHANGE_CONTROLBACKGROUND )
     117             :         {
     118             :             // Check if we need to get new images for normal/high contrast mode
     119           0 :             m_pTablesList->notifyHiContrastChanged();
     120             :         }
     121           0 :     }
     122           0 :     void OTableSubscriptionPage::DataChanged( const DataChangedEvent& rDCEvt )
     123             :     {
     124           0 :         OGenericAdministrationPage::DataChanged( rDCEvt );
     125             : 
     126           0 :         if ((( rDCEvt.GetType() == DATACHANGED_SETTINGS )   ||
     127           0 :             ( rDCEvt.GetType() == DATACHANGED_DISPLAY   ))  &&
     128           0 :             ( rDCEvt.GetFlags() & SETTINGS_STYLE        ))
     129             :         {
     130             :             // Check if we need to get new images for normal/high contrast mode
     131           0 :             m_pTablesList->notifyHiContrastChanged();
     132             :         }
     133           0 :     }
     134           0 :     void OTableSubscriptionPage::resizeControls(const Size& _rDiff)
     135             :     {
     136           0 :         if ( _rDiff.Height() )
     137             :         {
     138           0 :             Size aOldSize = m_pTablesList->GetSizePixel();
     139           0 :             aOldSize.Height() -= _rDiff.Height();
     140             :             m_pTablesList->SetPosSizePixel(
     141           0 :                     m_pTablesList->GetPosPixel()+Point(0,_rDiff.Height()),
     142             :                     aOldSize
     143           0 :                     );
     144             :         }
     145           0 :     }
     146           0 :     void OTableSubscriptionPage::implCheckTables(const Sequence< OUString >& _rTables)
     147             :     {
     148             :         // the meta data for the current connection, used for splitting up table names
     149           0 :         Reference< XDatabaseMetaData > xMeta;
     150             :         try
     151             :         {
     152           0 :             if (m_xCurrentConnection.is())
     153           0 :                 xMeta = m_xCurrentConnection->getMetaData();
     154             :         }
     155           0 :         catch(SQLException&)
     156             :         {
     157             :             OSL_FAIL("OTableSubscriptionPage::implCheckTables : could not retrieve the current connection's meta data!");
     158             :         }
     159             : 
     160             :         // uncheck all
     161           0 :         CheckAll(sal_False);
     162             : 
     163             :         // check the ones which are in the list
     164           0 :         OUString sCatalog, sSchema, sName;
     165             : 
     166           0 :         SvTreeListEntry* pRootEntry = m_pTablesList->getAllObjectsEntry();
     167           0 :         sal_Bool bAllTables = sal_False;
     168           0 :         sal_Bool bAllSchemas = sal_False;
     169             : 
     170           0 :         const OUString* pIncludeTable = _rTables.getConstArray();
     171           0 :         for (sal_Int32 i=0; i<_rTables.getLength(); ++i, ++pIncludeTable)
     172             :         {
     173           0 :             if (xMeta.is())
     174           0 :                 qualifiedNameComponents(xMeta, pIncludeTable->getStr(), sCatalog, sSchema, sName,::dbtools::eInDataManipulation);
     175             :             else
     176           0 :                 sName = pIncludeTable->getStr();
     177             : 
     178           0 :             bAllTables = (1 == sName.getLength()) && ('%' == sName[0]);
     179           0 :             bAllSchemas = (1 == sSchema.getLength()) && ('%' == sSchema[0]);
     180             : 
     181             :             // the catalog entry
     182           0 :             SvTreeListEntry* pCatalog = m_pTablesList->GetEntryPosByName(sCatalog, pRootEntry);
     183           0 :             if (!(pCatalog || sCatalog.isEmpty()))
     184             :                 // the table (resp. its catalog) refered in this filter entry does not exist anymore
     185           0 :                 continue;
     186             : 
     187           0 :             if (bAllSchemas && pCatalog)
     188             :             {
     189           0 :                 m_pTablesList->checkWildcard(pCatalog);
     190           0 :                 continue;
     191             :             }
     192             : 
     193             :             // the schema entry
     194           0 :             SvTreeListEntry* pSchema = m_pTablesList->GetEntryPosByName(sSchema, (pCatalog ? pCatalog : pRootEntry));
     195           0 :             if (!(pSchema || sSchema.isEmpty()))
     196             :                 // the table (resp. its schema) refered in this filter entry does not exist anymore
     197           0 :                 continue;
     198             : 
     199           0 :             if (bAllTables && pSchema)
     200             :             {
     201           0 :                 m_pTablesList->checkWildcard(pSchema);
     202           0 :                 continue;
     203             :             }
     204             : 
     205           0 :             SvTreeListEntry* pEntry = m_pTablesList->GetEntryPosByName(sName, pSchema ? pSchema : (pCatalog ? pCatalog : pRootEntry) );
     206           0 :             if (pEntry)
     207           0 :                 m_pTablesList->SetCheckButtonState(pEntry, SV_BUTTON_CHECKED);
     208             :         }
     209           0 :         m_pTablesList->CheckButtons();
     210           0 :     }
     211             : 
     212           0 :     void OTableSubscriptionPage::implCompleteTablesCheck( const ::com::sun::star::uno::Sequence< OUString >& _rTableFilter )
     213             :     {
     214           0 :         if (!_rTableFilter.getLength())
     215             :         {   // no tables visible
     216           0 :             CheckAll(sal_False);
     217             :         }
     218             :         else
     219             :         {
     220           0 :             if ((1 == _rTableFilter.getLength()) && _rTableFilter[0] == "%")
     221             :             {   // all tables visible
     222           0 :                 CheckAll(sal_True);
     223             :             }
     224             :             else
     225           0 :                 implCheckTables( _rTableFilter );
     226             :         }
     227           0 :     }
     228             : 
     229           0 :     void OTableSubscriptionPage::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
     230             :     {
     231             :         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
     232             :         sal_Bool bValid, bReadonly;
     233           0 :         getFlags(_rSet, bValid, bReadonly);
     234             : 
     235             :         // get the name of the data source we're working for
     236           0 :         SFX_ITEMSET_GET(_rSet, pNameItem, SfxStringItem, DSID_NAME, true);
     237             :         OSL_ENSURE(pNameItem, "OTableSubscriptionPage::implInitControls: missing the name attribute!");
     238           0 :         OUString sDSName = pNameItem->GetValue();
     239             : 
     240           0 :         if (bValid && !sDSName.isEmpty() && !m_xCurrentConnection.is() )
     241             :         {   // get the current table list from the connection for the current settings
     242             : 
     243             :             // the PropertyValues for the current dialog settings
     244           0 :             Sequence< PropertyValue > aConnectionParams;
     245             :             OSL_ENSURE(m_pTablesDlg, "OTableSubscriptionPage::implInitControls: need a parent dialog doing the translation!");
     246           0 :             if ( m_pTablesDlg )
     247             :             {
     248           0 :                 if (!m_pTablesDlg->getCurrentSettings(aConnectionParams))
     249             :                 {
     250           0 :                     m_pTablesList->Clear();
     251           0 :                     m_pTablesDlg->endExecution();
     252           0 :                     return;
     253             :                 }
     254             :             }
     255             : 
     256           0 :             if (!m_xCollator.is())
     257             :             {
     258             :                 // the collator for the string compares
     259             :                 try
     260             :                 {
     261           0 :                     m_xCollator = Collator::create(m_xORB);
     262           0 :                     m_xCollator->loadDefaultCollator(Application::GetSettings().GetLanguageTag().getLocale(), 0);
     263             :                 }
     264           0 :                 catch(const Exception&)
     265             :                 {
     266             :                     DBG_UNHANDLED_EXCEPTION();
     267             :                 }
     268             :             }
     269             : 
     270             :             // fill the table list with this connection information
     271           0 :             SQLExceptionInfo aErrorInfo;
     272             :             // the current DSN
     273           0 :             OUString sURL;
     274           0 :             if ( m_pTablesDlg )
     275           0 :                 sURL = m_pTablesDlg->getConnectionURL();
     276             : 
     277             :             try
     278             :             {
     279           0 :                 WaitObject aWaitCursor(this);
     280           0 :                 m_pTablesList->GetModel()->SetSortMode(SortAscending);
     281           0 :                 m_pTablesList->GetModel()->SetCompareHdl(LINK(this, OTableSubscriptionPage, OnTreeEntryCompare));
     282             : 
     283           0 :                 Reference< XDriver > xDriver;
     284           0 :                 Reference<XPropertySet> xProp = m_pTablesDlg->getCurrentDataSource();
     285             :                 OSL_ENSURE(xProp.is(),"No data source set!");
     286           0 :                 if ( xProp.is() )
     287             :                 {
     288           0 :                     Any aTableFilter = xProp->getPropertyValue(PROPERTY_TABLEFILTER);
     289           0 :                     Any aTableTypeFilter = xProp->getPropertyValue(PROPERTY_TABLETYPEFILTER);
     290             : 
     291           0 :                     Reference<XModifiable> xModi(getDataSourceOrModel(xProp),UNO_QUERY);
     292           0 :                     sal_Bool bModified = ( xModi.is() && xModi->isModified() );
     293             : 
     294           0 :                     Sequence< OUString > aNewTableFilter(1);
     295           0 :                     aNewTableFilter[0] = "%";
     296           0 :                     xProp->setPropertyValue(PROPERTY_TABLEFILTER,makeAny(aNewTableFilter));
     297             : 
     298           0 :                     xProp->setPropertyValue( PROPERTY_TABLETYPEFILTER, makeAny( Sequence< OUString >() ) );
     299           0 :                     Reference< ::com::sun::star::lang::XEventListener> xEvt;
     300           0 :                     aErrorInfo = ::dbaui::createConnection(xProp, m_xORB, xEvt, m_xCurrentConnection);
     301             : 
     302           0 :                     xProp->setPropertyValue(PROPERTY_TABLEFILTER,aTableFilter);
     303           0 :                     xProp->setPropertyValue(PROPERTY_TABLETYPEFILTER,aTableTypeFilter);
     304             : 
     305           0 :                     if ( xModi.is() && !bModified )
     306           0 :                         xModi->setModified(sal_False);
     307             : 
     308             :                 }
     309             : 
     310           0 :                 if ( m_xCurrentConnection.is() )
     311             :                 {
     312           0 :                     m_pTablesList->UpdateTableList( m_xCurrentConnection );
     313           0 :                     if (m_pTablesDlg)
     314           0 :                         m_pTablesDlg->successfullyConnected();
     315           0 :                 }
     316             :             }
     317           0 :             catch (const SQLException&)
     318             :             {
     319           0 :                 aErrorInfo = ::cppu::getCaughtException();
     320             :             }
     321             : 
     322           0 :             if (aErrorInfo.isValid())
     323             :             {
     324             :                 // establishing the connection failed. Show an error window and exit.
     325           0 :                 OSQLMessageBox aMessageBox( GetParentDialog(), aErrorInfo );
     326           0 :                 aMessageBox.Execute();
     327           0 :                 m_pTables->Enable(false);
     328           0 :                 m_pTablesList->Clear();
     329             : 
     330           0 :                 if ( m_pTablesDlg )
     331             :                 {
     332           0 :                     m_pTablesDlg->clearPassword();
     333           0 :                     m_pTablesDlg->endExecution();
     334           0 :                 }
     335             :             }
     336             :             else
     337             :             {
     338             :                 // in addition, we need some infos about the connection used
     339           0 :                 m_sCatalogSeparator = ".";    // (default)
     340           0 :                 m_bCatalogAtStart = sal_True;   // (default)
     341             :                 try
     342             :                 {
     343           0 :                     Reference< XDatabaseMetaData > xMeta;
     344           0 :                     if (m_xCurrentConnection.is())
     345           0 :                         xMeta = m_xCurrentConnection->getMetaData();
     346           0 :                     if (xMeta.is() && xMeta->supportsCatalogsInDataManipulation())
     347             :                     {
     348           0 :                         m_sCatalogSeparator = xMeta->getCatalogSeparator();
     349           0 :                         m_bCatalogAtStart = xMeta->isCatalogAtStart();
     350           0 :                     }
     351             :                 }
     352           0 :                 catch(Exception&)
     353             :                 {
     354             :                     DBG_UNHANDLED_EXCEPTION();
     355             :                 }
     356           0 :             }
     357             :         }
     358             : 
     359           0 :         bValid = bValid && m_xCurrentConnection.is();
     360           0 :         bReadonly = bReadonly || !bValid;
     361             : 
     362             :         // get the current table filter
     363           0 :         SFX_ITEMSET_GET(_rSet, pTableFilter, OStringListItem, DSID_TABLEFILTER, true);
     364           0 :         Sequence< OUString > aTableFilter;
     365           0 :         if (pTableFilter)
     366           0 :             aTableFilter = pTableFilter->getList();
     367             : 
     368           0 :         implCompleteTablesCheck( aTableFilter );
     369             : 
     370             :         // expand the first entry by default
     371           0 :         SvTreeListEntry* pExpand = m_pTablesList->getAllObjectsEntry();
     372           0 :         while (pExpand)
     373             :         {
     374           0 :             m_pTablesList->Expand(pExpand);
     375           0 :             pExpand = m_pTablesList->FirstChild(pExpand);
     376           0 :             if (pExpand && m_pTablesList->NextSibling(pExpand))
     377           0 :                 pExpand = NULL;
     378             :         }
     379             : 
     380             :         // update the toolbox according the current selection and check state
     381           0 :         OGenericAdministrationPage::implInitControls(_rSet, _bSaveValue);
     382             :     }
     383             : 
     384           0 :     void OTableSubscriptionPage::CheckAll( sal_Bool _bCheck )
     385             :     {
     386           0 :         SvButtonState eState = _bCheck ? SV_BUTTON_CHECKED : SV_BUTTON_UNCHECKED;
     387           0 :         SvTreeListEntry* pEntry = m_pTablesList->First();
     388           0 :         while (pEntry)
     389             :         {
     390           0 :             m_pTablesList->SetCheckButtonState( pEntry, eState);
     391           0 :             pEntry = m_pTablesList->Next(pEntry);
     392             :         }
     393             : 
     394           0 :         if (_bCheck && m_pTablesList->getAllObjectsEntry())
     395           0 :             m_pTablesList->checkWildcard(m_pTablesList->getAllObjectsEntry());
     396           0 :     }
     397             : 
     398           0 :     int OTableSubscriptionPage::DeactivatePage(SfxItemSet* _pSet)
     399             :     {
     400           0 :         int nResult = OGenericAdministrationPage::DeactivatePage(_pSet);
     401             : 
     402             :         // dispose the connection, we don't need it anymore, so we're not wasting resources
     403             :         try
     404             :         {
     405           0 :             ::comphelper::disposeComponent(m_xCurrentConnection);
     406             :         }
     407           0 :         catch (RuntimeException&) { }
     408             : 
     409           0 :         return nResult;
     410             :     }
     411           0 :     IMPL_LINK( OTableSubscriptionPage, OnTreeEntryChecked, Control*, _pControl )
     412             :     {
     413           0 :         return OnControlModified(_pControl);
     414             :     }
     415           0 :     IMPL_LINK( OTableSubscriptionPage, OnTreeEntryCompare, const SvSortData*, _pSortData )
     416             :     {
     417           0 :         const SvTreeListEntry* pLHS = static_cast<const SvTreeListEntry*>(_pSortData->pLeft);
     418           0 :         const SvTreeListEntry* pRHS = static_cast<const SvTreeListEntry*>(_pSortData->pRight);
     419             :         OSL_ENSURE(pLHS && pRHS, "SbaTableQueryBrowser::OnTreeEntryCompare: invalid tree entries!");
     420             : 
     421           0 :         const SvLBoxString* pLeftTextItem = static_cast<const SvLBoxString*>(pLHS->GetFirstItem(SV_ITEM_ID_LBOXSTRING));
     422           0 :         const SvLBoxString* pRightTextItem = static_cast<const SvLBoxString*>(pRHS->GetFirstItem(SV_ITEM_ID_LBOXSTRING));
     423             :         OSL_ENSURE(pLeftTextItem && pRightTextItem, "SbaTableQueryBrowser::OnTreeEntryCompare: invalid text items!");
     424             : 
     425           0 :         OUString sLeftText = pLeftTextItem->GetText();
     426           0 :         OUString sRightText = pRightTextItem->GetText();
     427             : 
     428           0 :         sal_Int32 nCompareResult = 0;   // equal by default
     429             : 
     430           0 :         if (m_xCollator.is())
     431             :         {
     432             :             try
     433             :             {
     434           0 :                 nCompareResult = m_xCollator->compareString(sLeftText, sRightText);
     435             :             }
     436           0 :             catch(Exception&)
     437             :             {
     438             :             }
     439             :         }
     440             :         else
     441             :             // default behaviour if we do not have a collator -> do the simple string compare
     442           0 :             nCompareResult = sLeftText.compareTo(sRightText);
     443             : 
     444           0 :         return nCompareResult;
     445             :     }
     446             : 
     447           0 :     Sequence< OUString > OTableSubscriptionPage::collectDetailedSelection() const
     448             :     {
     449           0 :         Sequence< OUString > aTableFilter;
     450           0 :         static const OUString sDot(".");
     451           0 :         static const OUString sWildcard("%");
     452             : 
     453           0 :         OUString sComposedName;
     454           0 :         const SvTreeListEntry* pAllObjectsEntry = m_pTablesList->getAllObjectsEntry();
     455           0 :         if (!pAllObjectsEntry)
     456           0 :             return aTableFilter;
     457           0 :         SvTreeListEntry* pEntry = m_pTablesList->GetModel()->Next(const_cast<SvTreeListEntry*>(pAllObjectsEntry));
     458           0 :         while(pEntry)
     459             :         {
     460           0 :             sal_Bool bCatalogWildcard = sal_False;
     461           0 :             sal_Bool bSchemaWildcard =  sal_False;
     462           0 :             SvTreeListEntry* pSchema = NULL;
     463           0 :             SvTreeListEntry* pCatalog = NULL;
     464             : 
     465           0 :             if (m_pTablesList->GetCheckButtonState(pEntry) == SV_BUTTON_CHECKED && !m_pTablesList->GetModel()->HasChildren(pEntry))
     466             :             {   // checked and a leaf, which means it's no catalog, no schema, but a real table
     467           0 :                 OUString sCatalog;
     468           0 :                 if(m_pTablesList->GetModel()->HasParent(pEntry))
     469             :                 {
     470           0 :                     pSchema = m_pTablesList->GetModel()->GetParent(pEntry);
     471           0 :                     if (pAllObjectsEntry == pSchema)
     472             :                         // do not want to have the root entry
     473           0 :                         pSchema = NULL;
     474             : 
     475           0 :                     if (pSchema)
     476             :                     {   // it's a real schema entry, not the "all objects" root
     477           0 :                         if(m_pTablesList->GetModel()->HasParent(pSchema))
     478             :                         {
     479           0 :                             pCatalog = m_pTablesList->GetModel()->GetParent(pSchema);
     480           0 :                             if (pAllObjectsEntry == pCatalog)
     481             :                                 // do not want to have the root entry
     482           0 :                                 pCatalog = NULL;
     483             : 
     484           0 :                             if (pCatalog)
     485             :                             {   // it's a real catalog entry, not the "all objects" root
     486           0 :                                 bCatalogWildcard = m_pTablesList->isWildcardChecked(pCatalog);
     487           0 :                                 if (m_bCatalogAtStart)
     488             :                                 {
     489           0 :                                     sComposedName += m_pTablesList->GetEntryText( pCatalog );
     490           0 :                                     sComposedName += m_sCatalogSeparator;
     491           0 :                                     if (bCatalogWildcard)
     492           0 :                                         sComposedName += sWildcard;
     493             :                                 }
     494             :                                 else
     495             :                                 {
     496           0 :                                     if (bCatalogWildcard)
     497           0 :                                         sCatalog = sWildcard;
     498             :                                     else
     499           0 :                                         sCatalog = "";
     500           0 :                                     sCatalog += m_sCatalogSeparator;
     501           0 :                                     sCatalog += m_pTablesList->GetEntryText( pCatalog );
     502             :                                 }
     503             :                             }
     504             :                         }
     505           0 :                         bSchemaWildcard = m_pTablesList->isWildcardChecked(pSchema);
     506           0 :                         sComposedName += m_pTablesList->GetEntryText( pSchema );
     507           0 :                         sComposedName += sDot;
     508             :                     }
     509             : 
     510           0 :                     if (bSchemaWildcard)
     511           0 :                         sComposedName += sWildcard;
     512             :                 }
     513           0 :                 if (!bSchemaWildcard && !bCatalogWildcard)
     514           0 :                     sComposedName += m_pTablesList->GetEntryText( pEntry );
     515             : 
     516           0 :                 if (!m_bCatalogAtStart && !bCatalogWildcard)
     517           0 :                     sComposedName += sCatalog;
     518             : 
     519             :                 // need some space
     520           0 :                 sal_Int32 nOldLen = aTableFilter.getLength();
     521           0 :                 aTableFilter.realloc(nOldLen + 1);
     522             :                 // add the new name
     523           0 :                 aTableFilter[nOldLen] = sComposedName;
     524             : 
     525             :                 // reset the composed name
     526           0 :                 sComposedName = "";
     527             :             }
     528             : 
     529           0 :             if (bCatalogWildcard)
     530           0 :                 pEntry = implNextSibling(pCatalog);
     531           0 :             else if (bSchemaWildcard)
     532           0 :                 pEntry = implNextSibling(pSchema);
     533             :             else
     534           0 :                 pEntry = m_pTablesList->GetModel()->Next(pEntry);
     535             :         }
     536             : 
     537           0 :         return aTableFilter;
     538             :     }
     539             : 
     540           0 :     SvTreeListEntry* OTableSubscriptionPage::implNextSibling(SvTreeListEntry* _pEntry) const
     541             :     {
     542           0 :         SvTreeListEntry* pReturn = NULL;
     543           0 :         if (_pEntry)
     544             :         {
     545           0 :             pReturn = m_pTablesList->NextSibling(_pEntry);
     546           0 :             if (!pReturn)
     547           0 :                 pReturn = implNextSibling(m_pTablesList->GetParent(_pEntry));
     548             :         }
     549           0 :         return pReturn;
     550             :     }
     551             : 
     552           0 :     bool OTableSubscriptionPage::FillItemSet( SfxItemSet& _rCoreAttrs )
     553             :     {
     554             :         sal_Bool bValid, bReadonly;
     555           0 :         getFlags(_rCoreAttrs, bValid, bReadonly);
     556             : 
     557           0 :         if (!bValid || bReadonly)
     558             :             // don't store anything if the data we're working with is invalid or readonly
     559           0 :             return true;
     560             : 
     561             :         // create the output string which contains all the table names
     562           0 :         if ( m_xCurrentConnection.is() )
     563             :         {   // collect the table filter data only if we have a connection - else no tables are displayed at all
     564           0 :             Sequence< OUString > aTableFilter;
     565           0 :             if (m_pTablesList->isWildcardChecked(m_pTablesList->getAllObjectsEntry()))
     566             :             {
     567           0 :                 aTableFilter.realloc(1);
     568           0 :                 aTableFilter[0] = "%";
     569             :             }
     570             :             else
     571             :             {
     572           0 :                 aTableFilter = collectDetailedSelection();
     573             :             }
     574           0 :             _rCoreAttrs.Put( OStringListItem(DSID_TABLEFILTER, aTableFilter) );
     575             :         }
     576             : 
     577           0 :         return true;
     578             :     }
     579             : 
     580           0 :     void OTableSubscriptionPage::fillControls(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
     581             :     {
     582           0 :     }
     583             : 
     584           0 :     void OTableSubscriptionPage::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
     585             :     {
     586           0 :         _rControlList.push_back(new ODisableWrapper<VclContainer>(m_pTables));
     587           0 :     }
     588           0 : }   // namespace dbaui
     589             : 
     590             : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

Generated by: LCOV version 1.10