dbaccess/source/ui/dlg/adtabdlg.cxx

   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 "adtabdlg.hxx"
  21 #include "sqlmessage.hxx"
  22 #include <tools/debug.hxx>
  23 #include <tools/diagnose_ex.h>
  24 #include <svtools/localresaccess.hxx>
  25 #include "dbaccess_helpid.hrc"
  26 #include "dbu_resource.hrc"
  27 #include "dbu_dlg.hrc"
  28 #include <sfx2/sfxsids.hrc>
  29 #include "QueryTableView.hxx"
  30 #include "QueryDesignView.hxx"
  31 #include "querycontroller.hxx"
  32 #include <connectivity/dbtools.hxx>
  33 #include "browserids.hxx"
  34 #include <com/sun/star/sdb/XQueriesSupplier.hpp>
  35 #include <com/sun/star/sdbcx/XViewsSupplier.hpp>
  36 #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
  37 #include <com/sun/star/container/XNameAccess.hpp>
  38 #include "UITools.hxx"
  39 #include "imageprovider.hxx"
  40 #include <comphelper/containermultiplexer.hxx>
  41 #include "cppuhelper/basemutex.hxx"
  42 #include <algorithm>
  43
  44 // slot ids
  45 using namespace dbaui;
  46 using namespace ::com::sun::star;
  47 using namespace ::com::sun::star::uno;
  48 using namespace ::com::sun::star::container;
  49 using namespace ::com::sun::star::sdb;
  50 using namespace ::com::sun::star::sdbc;
  51 using namespace ::com::sun::star::sdbcx;
  52 using namespace dbtools;
  53
  54 TableObjectListFacade::~TableObjectListFacade()
  55 {
  56 }
  57
  58 class TableListFacade : public ::cppu::BaseMutex
  59                     ,   public TableObjectListFacade
  60                     ,   public ::comphelper::OContainerListener
  61 {
  62     OTableTreeListBox&          m_rTableList;
  63     Reference< XConnection >    m_xConnection;
  64     ::rtl::Reference< comphelper::OContainerListenerAdapter>
  65                                 m_pContainerListener;
  66     bool                        m_bAllowViews;
  67
  68 public:
  69     TableListFacade( OTableTreeListBox& _rTableList, const Reference< XConnection >& _rxConnection )
  70         : ::comphelper::OContainerListener(m_aMutex)
  71         ,m_rTableList( _rTableList )
  72         ,m_xConnection( _rxConnection )
  73         ,m_bAllowViews(true)
  74     {
  75     }
  76     virtual ~TableListFacade();
  77
  78 private:
  79     virtual void    updateTableObjectList( bool _bAllowViews ) SAL_OVERRIDE;
  80     virtual OUString  getSelectedName( OUString& _out_rAliasName ) const SAL_OVERRIDE;
  81     virtual bool    isLeafSelected() const SAL_OVERRIDE;
  82     // OContainerListener
  83     virtual void _elementInserted( const ::com::sun::star::container::ContainerEvent& _rEvent ) throw(::com::sun::star::uno::RuntimeException, std::exception) SAL_OVERRIDE;
  84     virtual void _elementRemoved( const  ::com::sun::star::container::ContainerEvent& _rEvent ) throw(::com::sun::star::uno::RuntimeException, std::exception) SAL_OVERRIDE;
  85     virtual void _elementReplaced( const ::com::sun::star::container::ContainerEvent& _rEvent ) throw(::com::sun::star::uno::RuntimeException, std::exception) SAL_OVERRIDE;
  86 };
  87
  88 TableListFacade::~TableListFacade()
  89 {
  90     if ( m_pContainerListener.is() )
  91         m_pContainerListener->dispose();
  92 }
  93
  94 OUString TableListFacade::getSelectedName( OUString& _out_rAliasName ) const
  95 {
  96     SvTreeListEntry* pEntry = m_rTableList.FirstSelected();
  97     if ( !pEntry )
  98         return OUString();
  99
 100     OUString aCatalog, aSchema, aTableName;
 101     SvTreeListEntry* pSchema = m_rTableList.GetParent(pEntry);
 102     if(pSchema && pSchema != m_rTableList.getAllObjectsEntry())
 103     {
 104         SvTreeListEntry* pCatalog = m_rTableList.GetParent(pSchema);
 105         if(pCatalog && pCatalog != m_rTableList.getAllObjectsEntry())
 106             aCatalog = m_rTableList.GetEntryText(pCatalog);
 107         aSchema = m_rTableList.GetEntryText(pSchema);
 108     }
 109     aTableName = m_rTableList.GetEntryText(pEntry);
 110
 111     OUString aComposedName;
 112     try
 113     {
 114         Reference< XDatabaseMetaData > xMeta( m_xConnection->getMetaData(), UNO_QUERY_THROW );
 115         if (  aCatalog.isEmpty()
 116             && !aSchema.isEmpty()
 117             && xMeta->supportsCatalogsInDataManipulation()
 118             && !xMeta->supportsSchemasInDataManipulation() )
 119         {
 120             aCatalog = aSchema;
 121             aSchema.clear();
 122         }
 123
 124         aComposedName = ::dbtools::composeTableName(
 125             xMeta, aCatalog, aSchema, aTableName, false, ::dbtools::eInDataManipulation );
 126     }
 127     catch ( const Exception& )
 128     {
 129         DBG_UNHANDLED_EXCEPTION();
 130     }
 131
 132     _out_rAliasName = aTableName;
 133     return aComposedName;
 134 }
 135
 136 void TableListFacade::_elementInserted( const container::ContainerEvent& /*_rEvent*/ )  throw(::com::sun::star::uno::RuntimeException, std::exception)
 137 {
 138     updateTableObjectList(m_bAllowViews);
 139 }
 140
 141 void TableListFacade::_elementRemoved( const container::ContainerEvent& /*_rEvent*/ ) throw(::com::sun::star::uno::RuntimeException, std::exception)
 142 {
 143     updateTableObjectList(m_bAllowViews);
 144 }
 145
 146 void TableListFacade::_elementReplaced( const container::ContainerEvent& /*_rEvent*/ ) throw(::com::sun::star::uno::RuntimeException, std::exception)
 147 {
 148 }
 149
 150 void TableListFacade::updateTableObjectList( bool _bAllowViews )
 151 {
 152     m_bAllowViews = _bAllowViews;
 153     m_rTableList.Clear();
 154     try
 155     {
 156         Reference< XTablesSupplier > xTableSupp( m_xConnection, UNO_QUERY_THROW );
 157
 158         Reference< XViewsSupplier > xViewSupp;
 159         Reference< XNameAccess > xTables, xViews;
 160         Sequence< OUString > sTables, sViews;
 161
 162         xTables = xTableSupp->getTables();
 163         if ( xTables.is() )
 164         {
 165             if ( !m_pContainerListener.is() )
 166             {
 167                 Reference< XContainer> xContainer(xTables,uno::UNO_QUERY);
 168                 if ( xContainer.is() )
 169                     m_pContainerListener = new ::comphelper::OContainerListenerAdapter(this,xContainer);
 170             }
 171             sTables = xTables->getElementNames();
 172         }
 173
 174         xViewSupp.set( xTableSupp, UNO_QUERY );
 175         if ( xViewSupp.is() )
 176         {
 177             xViews = xViewSupp->getViews();
 178             if ( xViews.is() )
 179                 sViews = xViews->getElementNames();
 180         }
 181
 182         // if no views are allowed remove the views also out the table name filter
 183         if ( !_bAllowViews )
 184         {
 185             const OUString* pTableBegin  = sTables.getConstArray();
 186             const OUString* pTableEnd    = pTableBegin + sTables.getLength();
 187             ::std::vector< OUString > aTables(pTableBegin,pTableEnd);
 188
 189             const OUString* pViewBegin = sViews.getConstArray();
 190             const OUString* pViewEnd   = pViewBegin + sViews.getLength();
 191             ::comphelper::UStringMixEqual aEqualFunctor;
 192             for(;pViewBegin != pViewEnd;++pViewBegin)
 193                 aTables.erase(::std::remove_if(aTables.begin(),aTables.end(),::std::bind2nd(aEqualFunctor,*pViewBegin)),aTables.end());
 194             sTables = Sequence< OUString>(aTables.data(), aTables.size());
 195             sViews = Sequence< OUString>();
 196         }
 197
 198         m_rTableList.UpdateTableList( m_xConnection, sTables, sViews );
 199         SvTreeListEntry* pEntry = m_rTableList.First();
 200         while( pEntry && m_rTableList.GetModel()->HasChildren( pEntry ) )
 201         {
 202             m_rTableList.Expand( pEntry );
 203             pEntry = m_rTableList.Next( pEntry );
 204         }
 205         if ( pEntry )
 206             m_rTableList.Select(pEntry);
 207     }
 208     catch( const Exception& )
 209     {
 210         DBG_UNHANDLED_EXCEPTION();
 211     }
 212 }
 213
 214 bool TableListFacade::isLeafSelected() const
 215 {
 216     SvTreeListEntry* pEntry = m_rTableList.FirstSelected();
 217     return pEntry && !m_rTableList.GetModel()->HasChildren( pEntry );
 218 }
 219
 220 class QueryListFacade : public ::cppu::BaseMutex
 221                     ,   public TableObjectListFacade
 222                     ,   public ::comphelper::OContainerListener
 223 {
 224     SvTreeListBox&              m_rQueryList;
 225     Reference< XConnection >    m_xConnection;
 226     ::rtl::Reference< comphelper::OContainerListenerAdapter>
 227                                 m_pContainerListener;
 228
 229 public:
 230     QueryListFacade( SvTreeListBox& _rQueryList, const Reference< XConnection >& _rxConnection )
 231         : ::comphelper::OContainerListener(m_aMutex)
 232         ,m_rQueryList( _rQueryList )
 233         ,m_xConnection( _rxConnection )
 234     {
 235     }
 236     virtual ~QueryListFacade();
 237
 238 private:
 239     virtual void    updateTableObjectList( bool _bAllowViews ) SAL_OVERRIDE;
 240     virtual OUString  getSelectedName( OUString& _out_rAliasName ) const SAL_OVERRIDE;
 241     virtual bool    isLeafSelected() const SAL_OVERRIDE;
 242     // OContainerListener
 243     virtual void _elementInserted( const ::com::sun::star::container::ContainerEvent& _rEvent ) throw(::com::sun::star::uno::RuntimeException, std::exception) SAL_OVERRIDE;
 244     virtual void _elementRemoved( const  ::com::sun::star::container::ContainerEvent& _rEvent ) throw(::com::sun::star::uno::RuntimeException, std::exception) SAL_OVERRIDE;
 245     virtual void _elementReplaced( const ::com::sun::star::container::ContainerEvent& _rEvent ) throw(::com::sun::star::uno::RuntimeException, std::exception) SAL_OVERRIDE;
 246 };
 247
 248 QueryListFacade::~QueryListFacade()
 249 {
 250     if ( m_pContainerListener.is() )
 251         m_pContainerListener->dispose();
 252 }
 253
 254 void QueryListFacade::_elementInserted( const container::ContainerEvent& _rEvent )  throw(::com::sun::star::uno::RuntimeException, std::exception)
 255 {
 256     OUString sName;
 257     if ( _rEvent.Accessor >>= sName )
 258         m_rQueryList.InsertEntry( sName );
 259 }
 260
 261 void QueryListFacade::_elementRemoved( const container::ContainerEvent& /*_rEvent*/ ) throw(::com::sun::star::uno::RuntimeException, std::exception)
 262 {
 263     updateTableObjectList(true);
 264 }
 265
 266 void QueryListFacade::_elementReplaced( const container::ContainerEvent& /*_rEvent*/ ) throw(::com::sun::star::uno::RuntimeException, std::exception)
 267 {
 268 }
 269
 270 void QueryListFacade::updateTableObjectList( bool /*_bAllowViews*/ )
 271 {
 272     m_rQueryList.Clear();
 273     try
 274     {
 275         ImageProvider aImageProvider( m_xConnection );
 276         Image aQueryImage( ImageProvider::getDefaultImage( css::sdb::application::DatabaseObject::QUERY ) );
 277
 278         m_rQueryList.SetDefaultExpandedEntryBmp( aQueryImage );
 279         m_rQueryList.SetDefaultCollapsedEntryBmp( aQueryImage );
 280
 281         Reference< XQueriesSupplier > xSuppQueries( m_xConnection, UNO_QUERY_THROW );
 282         Reference< XNameAccess > xQueries( xSuppQueries->getQueries(), UNO_QUERY_THROW );
 283         if ( !m_pContainerListener.is() )
 284         {
 285             Reference< XContainer> xContainer(xQueries,UNO_QUERY_THROW);
 286             m_pContainerListener = new ::comphelper::OContainerListenerAdapter(this,xContainer);
 287         }
 288         Sequence< OUString > aQueryNames = xQueries->getElementNames();
 289
 290         const OUString* pQuery = aQueryNames.getConstArray();
 291         const OUString* pQueryEnd = aQueryNames.getConstArray() + aQueryNames.getLength();
 292         while ( pQuery != pQueryEnd )
 293             m_rQueryList.InsertEntry( *pQuery++ );
 294     }
 295     catch( const Exception& )
 296     {
 297         DBG_UNHANDLED_EXCEPTION();
 298     }
 299 }
 300
 301 OUString QueryListFacade::getSelectedName( OUString& _out_rAliasName ) const
 302 {
 303     OUString sSelected;
 304     SvTreeListEntry* pEntry = m_rQueryList.FirstSelected();
 305     if ( pEntry )
 306         sSelected = _out_rAliasName = m_rQueryList.GetEntryText( pEntry );
 307     return sSelected;
 308 }
 309
 310 bool QueryListFacade::isLeafSelected() const
 311 {
 312     SvTreeListEntry* pEntry = m_rQueryList.FirstSelected();
 313     return pEntry && !m_rQueryList.GetModel()->HasChildren( pEntry );
 314 }
 315
 316 OAddTableDlg::OAddTableDlg( vcl::Window* pParent, IAddTableDialogContext& _rContext )
 317    : ModelessDialog(pParent, "TablesJoinDialog", "dbaccess/ui/tablesjoindialog.ui")
 318    , m_rContext(_rContext)
 319 {
 320     get(m_pCaseTables, "tables");
 321     get(m_pCaseQueries, "queries");
 322
 323     get(m_pTableList, "tablelist");
 324     get(m_pQueryList, "querylist");
 325     Size aSize(LogicToPixel(Size(106 , 122), MAP_APPFONT));
 326     m_pTableList->set_height_request(aSize.Height());
 327     m_pTableList->set_width_request(aSize.Width());
 328     get(m_pQueryList, "querylist");
 329     m_pQueryList->set_height_request(aSize.Height());
 330     m_pQueryList->set_width_request(aSize.Width());
 331
 332     get(m_pAddButton, "add");
 333     get(m_pCloseButton, "close");
 334
 335     m_pCaseTables->SetClickHdl( LINK( this, OAddTableDlg, OnTypeSelected ) );
 336     m_pCaseQueries->SetClickHdl( LINK( this, OAddTableDlg, OnTypeSelected ) );
 337     m_pAddButton->SetClickHdl( LINK( this, OAddTableDlg, AddClickHdl ) );
 338     m_pCloseButton->SetClickHdl( LINK( this, OAddTableDlg, CloseClickHdl ) );
 339     m_pTableList->SetDoubleClickHdl( LINK( this, OAddTableDlg, TableListDoubleClickHdl ) );
 340     m_pTableList->SetSelectHdl( LINK( this, OAddTableDlg, TableListSelectHdl ) );
 341     m_pQueryList->SetDoubleClickHdl( LINK( this, OAddTableDlg, TableListDoubleClickHdl ) );
 342     m_pQueryList->SetSelectHdl( LINK( this, OAddTableDlg, TableListSelectHdl ) );
 343
 344     m_pTableList->EnableInplaceEditing( false );
 345     m_pTableList->SetStyle(m_pTableList->GetStyle() | WB_BORDER | WB_HASLINES |WB_HASBUTTONS | WB_HASBUTTONSATROOT | WB_HASLINESATROOT | WB_SORT | WB_HSCROLL );
 346     m_pTableList->EnableCheckButton( NULL ); // do not show any buttons
 347     m_pTableList->SetSelectionMode( SINGLE_SELECTION );
 348     m_pTableList->notifyHiContrastChanged();
 349     m_pTableList->suppressEmptyFolders();
 350
 351     m_pQueryList->EnableInplaceEditing( false );
 352     m_pQueryList->SetSelectionMode( SINGLE_SELECTION );
 353
 354     if ( !m_rContext.allowQueries() )
 355     {
 356         m_pCaseTables->Hide();
 357         m_pCaseQueries->Hide();
 358     }
 359
 360     SetText( getDialogTitleForContext( m_rContext ) );
 361 }
 362
 363 OAddTableDlg::~OAddTableDlg()
 364 {
 365     disposeOnce();
 366 }
 367
 368 void OAddTableDlg::dispose()
 369 {
 370     m_rContext.onWindowClosing( this );
 371     m_pCaseTables.clear();
 372     m_pCaseQueries.clear();
 373     m_pTableList.clear();
 374     m_pQueryList.clear();
 375     m_pAddButton.clear();
 376     m_pCloseButton.clear();
 377     ModelessDialog::dispose();
 378 }
 379
 380 void OAddTableDlg::impl_switchTo( ObjectList _eList )
 381 {
 382     switch ( _eList )
 383     {
 384     case Tables:
 385         m_pTableList->Show( true );  m_pCaseTables->Check( true );
 386         m_pQueryList->Show( false ); m_pCaseQueries->Check( false );
 387         m_xCurrentList.reset( new TableListFacade( *m_pTableList, m_rContext.getConnection() ) );
 388         m_pTableList->GrabFocus();
 389         break;
 390
 391     case Queries:
 392         m_pTableList->Show( false ); m_pCaseTables->Check( false );
 393         m_pQueryList->Show( true );  m_pCaseQueries->Check( true );
 394         m_xCurrentList.reset( new QueryListFacade( *m_pQueryList, m_rContext.getConnection() ) );
 395         m_pQueryList->GrabFocus();
 396         break;
 397     }
 398     m_xCurrentList->updateTableObjectList( m_rContext.allowViews() );
 399 }
 400
 401 void OAddTableDlg::Update()
 402 {
 403     if ( !m_xCurrentList.get() )
 404         impl_switchTo( Tables );
 405     else
 406         m_xCurrentList->updateTableObjectList( m_rContext.allowViews() );
 407 }
 408
 409 void OAddTableDlg::impl_addTable()
 410 {
 411     if ( m_xCurrentList->isLeafSelected() )
 412     {
 413         OUString sSelectedName, sAliasName;
 414         sSelectedName = m_xCurrentList->getSelectedName( sAliasName );
 415
 416         m_rContext.addTableWindow( sSelectedName, sAliasName );
 417     }
 418 }
 419
 420 IMPL_LINK( OAddTableDlg, AddClickHdl, Button*, /*pButton*/ )
 421 {
 422     TableListDoubleClickHdl(NULL);
 423     return 0;
 424 }
 425
 426 IMPL_LINK_NOARG( OAddTableDlg, TableListDoubleClickHdl )
 427 {
 428     if ( impl_isAddAllowed() )
 429     {
 430         impl_addTable();
 431         if ( !impl_isAddAllowed() )
 432             Close();
 433         return 1L;  // handled
 434     }
 435
 436     return 0L;  // not handled
 437 }
 438
 439 IMPL_LINK_NOARG( OAddTableDlg, TableListSelectHdl )
 440 {
 441     m_pAddButton->Enable( m_xCurrentList->isLeafSelected() );
 442     return 0;
 443 }
 444
 445 IMPL_LINK( OAddTableDlg, CloseClickHdl, Button*, /*pButton*/ )
 446 {
 447     return int(Close());
 448 }
 449
 450 IMPL_LINK_NOARG( OAddTableDlg, OnTypeSelected )
 451 {
 452     if ( m_pCaseTables->IsChecked() )
 453         impl_switchTo( Tables );
 454     else
 455         impl_switchTo( Queries );
 456     return 0;
 457 }
 458
 459 bool OAddTableDlg::Close()
 460 {
 461     m_rContext.onWindowClosing( this );
 462     return ModelessDialog::Close();
 463 }
 464
 465 bool OAddTableDlg::impl_isAddAllowed()
 466 {
 467     return  m_rContext.allowAddition();
 468 }
 469
 470 OUString OAddTableDlg::getDialogTitleForContext( IAddTableDialogContext& _rContext )
 471 {
 472     OUString sTitle;
 473
 474     if ( _rContext.allowQueries() )
 475         sTitle = ModuleRes( STR_ADD_TABLE_OR_QUERY );
 476     else
 477         sTitle = ModuleRes( STR_ADD_TABLES );
 478
 479     return sTitle;
 480 }
 481
 482 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */