LCOV - code coverage report
Current view: top level - libreoffice/dbaccess/source/ui/querydesign - QTableWindow.cxx (source / functions) Hit Total Coverage
Test: libreoffice_filtered.info Lines: 0 86 0.0 %
Date: 2012-12-27 Functions: 0 10 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 "QTableWindow.hxx"
      21             : #include "QueryTableView.hxx"
      22             : #include "dbustrings.hrc"
      23             : #include <osl/diagnose.h>
      24             : #include "dbaccess_helpid.hrc"
      25             : #include "QueryDesignView.hxx"
      26             : #include "browserids.hxx"
      27             : #include "querycontroller.hxx"
      28             : #include <vcl/image.hxx>
      29             : #include "TableWindowListBox.hxx"
      30             : #include "dbu_qry.hrc"
      31             : #include "Query.hrc"
      32             : #include <com/sun/star/sdbcx/XKeysSupplier.hpp>
      33             : #include <com/sun/star/container/XNameAccess.hpp>
      34             : #include <com/sun/star/container/XIndexAccess.hpp>
      35             : #include <com/sun/star/beans/XPropertySet.hpp>
      36             : #include <com/sun/star/sdbcx/KeyType.hpp>
      37             : #include <com/sun/star/sdbcx/XColumnsSupplier.hpp>
      38             : #include "TableFieldInfo.hxx"
      39             : #include <comphelper/extract.hxx>
      40             : #include <comphelper/string.hxx>
      41             : #include <comphelper/uno3.hxx>
      42             : #include "UITools.hxx"
      43             : #include "svtools/treelistentry.hxx"
      44             : 
      45             : using namespace ::com::sun::star::sdbc;
      46             : using namespace ::com::sun::star::sdbcx;
      47             : using namespace ::com::sun::star::uno;
      48             : using namespace ::com::sun::star::container;
      49             : using namespace ::com::sun::star::beans;
      50             : using namespace dbaui;
      51             : //========================================================================
      52             : // class OQueryTableWindow
      53             : //========================================================================
      54             : DBG_NAME(OQueryTableWindow)
      55             : //------------------------------------------------------------------------------
      56           0 : OQueryTableWindow::OQueryTableWindow( Window* pParent, const TTableWindowData::value_type& pTabWinData, sal_Unicode* pszInitialAlias)
      57             :     :OTableWindow( pParent, pTabWinData )
      58           0 :     ,m_nAliasNum(0)
      59             : {
      60             :     DBG_CTOR(OQueryTableWindow,NULL);
      61           0 :     if (pszInitialAlias != NULL)
      62           0 :         m_strInitialAlias = ::rtl::OUString(pszInitialAlias);
      63             :     else
      64           0 :         m_strInitialAlias = GetAliasName();
      65             : 
      66             :     // if table name matches alias, do not pass to InitialAlias,
      67             :     // as the appending of a possible token could not succeed...
      68           0 :     if (m_strInitialAlias == pTabWinData->GetTableName())
      69           0 :         m_strInitialAlias = ::rtl::OUString();
      70             : 
      71           0 :     SetHelpId(HID_CTL_QRYDGNTAB);
      72           0 : }
      73             : 
      74             : //------------------------------------------------------------------------------
      75           0 : OQueryTableWindow::~OQueryTableWindow()
      76             : {
      77             :     DBG_DTOR(OQueryTableWindow,NULL);
      78           0 : }
      79             : 
      80             : //------------------------------------------------------------------------------
      81           0 : sal_Bool OQueryTableWindow::Init()
      82             : {
      83           0 :     sal_Bool bSuccess = OTableWindow::Init();
      84           0 :     if(!bSuccess)
      85           0 :         return bSuccess;
      86             : 
      87           0 :     OQueryTableView* pContainer = static_cast<OQueryTableView*>(getTableView());
      88             : 
      89             :     // first determine Alias
      90           0 :     ::rtl::OUString sAliasName;
      91             : 
      92           0 :     TTableWindowData::value_type pWinData = GetData();
      93             : 
      94           0 :     if (!m_strInitialAlias.isEmpty() )
      95             :         // Alias was explicitly given
      96           0 :         sAliasName = m_strInitialAlias;
      97           0 :     else if ( GetTable().is() )
      98           0 :         GetTable()->getPropertyValue( PROPERTY_NAME ) >>= sAliasName;
      99             :     else
     100           0 :         return sal_False;
     101             : 
     102             :     // Alias with successive number
     103           0 :     if (pContainer->CountTableAlias(sAliasName, m_nAliasNum))
     104             :     {
     105           0 :         sAliasName += ::rtl::OUString('_');
     106           0 :         sAliasName += ::rtl::OUString::valueOf(m_nAliasNum);
     107             :     }
     108             : 
     109             : 
     110           0 :     sAliasName = comphelper::string::remove(sAliasName, '"');
     111           0 :     SetAliasName(sAliasName);
     112             :         // SetAliasName passes it as WinName, hence it uses the base class
     113             :     // reset the title
     114           0 :     m_aTitle.SetText( pWinData->GetWinName() );
     115           0 :     m_aTitle.Show();
     116             : 
     117           0 :     if (!bSuccess)
     118             :     {   // it should just open a dummy window...
     119             :         OSL_ENSURE(!GetAliasName().isEmpty(), "OQueryTableWindow::Init : kein Alias- UND kein Tabellenname geht nicht !");
     120             :             // .. but that needs at least an Alias
     121             : 
     122             :         // create ::com::sun::star::form::ListBox
     123           0 :         if (!m_pListBox)
     124           0 :             m_pListBox = CreateListBox();
     125             : 
     126             :         // set titel
     127           0 :         m_aTitle.SetText(GetAliasName());
     128           0 :         m_aTitle.Show();
     129             : 
     130           0 :         clearListBox();
     131             :             // don't need to refill them as I don't have a table
     132           0 :         m_pListBox->Show();
     133             :     }
     134             : 
     135           0 :     getTableView()->getDesignView()->getController().InvalidateFeature(ID_BROWSER_QUERY_EXECUTE);
     136           0 :     return bSuccess;
     137             : }
     138             : // -----------------------------------------------------------------------------
     139           0 : void* OQueryTableWindow::createUserData(const Reference< XPropertySet>& _xColumn,bool _bPrimaryKey)
     140             : {
     141           0 :     OTableFieldInfo* pInfo = new OTableFieldInfo();
     142           0 :     pInfo->SetKey(_bPrimaryKey ? TAB_PRIMARY_FIELD : TAB_NORMAL_FIELD);
     143           0 :     if ( _xColumn.is() )
     144           0 :         pInfo->SetDataType(::comphelper::getINT32(_xColumn->getPropertyValue(PROPERTY_TYPE)));
     145           0 :     return pInfo;
     146             : }
     147             : // -----------------------------------------------------------------------------
     148           0 : void OQueryTableWindow::deleteUserData(void*& _pUserData)
     149             : {
     150           0 :     delete static_cast<OTableFieldInfo*>(_pUserData);
     151           0 :     _pUserData = NULL;
     152           0 : }
     153             : //------------------------------------------------------------------------------
     154           0 : void OQueryTableWindow::OnEntryDoubleClicked(SvTreeListEntry* pEntry)
     155             : {
     156             :     OSL_ENSURE(pEntry != NULL, "OQueryTableWindow::OnEntryDoubleClicked : pEntry must not be NULL !");
     157             :         // you could also scan that and then return, but like this it could possibly hint to faults at the caller
     158             : 
     159           0 :     if (getTableView()->getDesignView()->getController().isReadOnly())
     160           0 :         return;
     161             : 
     162           0 :     OTableFieldInfo* pInf = static_cast<OTableFieldInfo*>(pEntry->GetUserData());
     163             :     OSL_ENSURE(pInf != NULL, "OQueryTableWindow::OnEntryDoubleClicked : field doesn't have FieldInfo !");
     164             : 
     165             :     // build up DragInfo
     166           0 :     OTableFieldDescRef aInfo = new OTableFieldDesc(GetTableName(),m_pListBox->GetEntryText(pEntry));
     167           0 :     aInfo->SetTabWindow(this);
     168           0 :     aInfo->SetAlias(GetAliasName());
     169           0 :     aInfo->SetFieldIndex(m_pListBox->GetModel()->GetAbsPos(pEntry));
     170           0 :     aInfo->SetDataType(pInf->GetDataType());
     171             : 
     172             :     // and insert corresponding field
     173           0 :     static_cast<OQueryTableView*>(getTableView())->InsertField(aInfo);
     174             : }
     175             : 
     176             : //------------------------------------------------------------------------------
     177           0 : sal_Bool OQueryTableWindow::ExistsField(const ::rtl::OUString& strFieldName, OTableFieldDescRef& rInfo)
     178             : {
     179             :     OSL_ENSURE(m_pListBox != NULL, "OQueryTableWindow::ExistsField : doesn't have ::com::sun::star::form::ListBox !");
     180             :     OSL_ENSURE(rInfo.is(),"OQueryTableWindow::ExistsField: invalid argument for OTableFieldDescRef!");
     181           0 :     Reference< XConnection> xConnection = getTableView()->getDesignView()->getController().getConnection();
     182           0 :     sal_Bool bExists = sal_False;
     183           0 :     if(xConnection.is())
     184             :     {
     185           0 :         SvTreeListEntry* pEntry = m_pListBox->First();
     186             :         try
     187             :         {
     188           0 :             Reference<XDatabaseMetaData> xMeta = xConnection->getMetaData();
     189           0 :             ::comphelper::UStringMixEqual bCase(xMeta.is() && xMeta->supportsMixedCaseQuotedIdentifiers());
     190             : 
     191           0 :             while (pEntry)
     192             :             {
     193           0 :                 if (bCase(strFieldName,::rtl::OUString(m_pListBox->GetEntryText(pEntry))))
     194             :                 {
     195           0 :                     OTableFieldInfo* pInf = static_cast<OTableFieldInfo*>(pEntry->GetUserData());
     196             :                     OSL_ENSURE(pInf != NULL, "OQueryTableWindow::ExistsField : field doesn't have FieldInfo !");
     197             : 
     198           0 :                     rInfo->SetTabWindow(this);
     199           0 :                     rInfo->SetField(strFieldName);
     200           0 :                     rInfo->SetTable(GetTableName());
     201           0 :                     rInfo->SetAlias(GetAliasName());
     202           0 :                     rInfo->SetFieldIndex(m_pListBox->GetModel()->GetAbsPos(pEntry));
     203           0 :                     rInfo->SetDataType(pInf->GetDataType());
     204           0 :                     bExists = sal_True;
     205           0 :                     break;
     206             :                 }
     207           0 :                 pEntry = m_pListBox->Next(pEntry);
     208           0 :             }
     209             :         }
     210           0 :         catch(SQLException&)
     211             :         {
     212             :         }
     213             :     }
     214             : 
     215           0 :     return bExists;
     216             : }
     217             : 
     218             : //------------------------------------------------------------------------------
     219           0 : sal_Bool OQueryTableWindow::ExistsAVisitedConn() const
     220             : {
     221           0 :     return static_cast<const OQueryTableView*>(getTableView())->ExistsAVisitedConn(this);
     222             : }
     223             : 
     224             : //------------------------------------------------------------------------------
     225           0 : void OQueryTableWindow::KeyInput( const KeyEvent& rEvt )
     226             : {
     227           0 :     OTableWindow::KeyInput( rEvt );
     228           0 : }
     229             : // -----------------------------------------------------------------------------
     230             : 
     231             : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

Generated by: LCOV version 1.10