sw/source/ui/dbui/selectdbtabledialog.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 <o3tl/safeint.hxx>
  21 #include <comphelper/propertyvalue.hxx>
  22 #include <swtypes.hxx>
  23 #include "selectdbtabledialog.hxx"
  24 #include "dbtablepreviewdialog.hxx"
  25 #include <osl/diagnose.h>
  26 #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
  27 #include <com/sun/star/sdb/XQueriesSupplier.hpp>
  28 #include <com/sun/star/beans/XPropertySet.hpp>
  29 #include <com/sun/star/beans/PropertyValue.hpp>
  30 #include <com/sun/star/container/XChild.hpp>
  31 #include <com/sun/star/sdbc/XDataSource.hpp>
  32
  33 #include <strings.hrc>
  34 #include <utility>
  35
  36 using namespace ::com::sun::star;
  37 using namespace ::com::sun::star::sdbcx;
  38 using namespace ::com::sun::star::sdbc;
  39 using namespace ::com::sun::star::sdb;
  40 using namespace ::com::sun::star::uno;
  41 using namespace ::com::sun::star::container;
  42 using namespace ::com::sun::star::beans;
  43
  44 SwSelectDBTableDialog::SwSelectDBTableDialog(weld::Window* pParent,
  45                                              uno::Reference<sdbc::XConnection> xConnection)
  46     : SfxDialogController(pParent, "modules/swriter/ui/selecttabledialog.ui", "SelectTableDialog")
  47     , m_xConnection(std::move(xConnection))
  48     , m_xTable(m_xBuilder->weld_tree_view("table"))
  49     , m_xPreviewPB(m_xBuilder->weld_button("preview"))
  50 {
  51     m_xTable->set_size_request(m_xTable->get_approximate_digit_width() * 60,
  52                                m_xTable->get_height_rows(6));
  53
  54     std::vector<int> aWidths{ o3tl::narrowing<int>(m_xTable->get_approximate_digit_width() * 30) };
  55     m_xTable->set_column_fixed_widths(aWidths);
  56
  57     m_xPreviewPB->connect_clicked(LINK(this, SwSelectDBTableDialog, PreviewHdl));
  58
  59     Reference<XTablesSupplier> xTSupplier(m_xConnection, UNO_QUERY);
  60     if (xTSupplier.is())
  61     {
  62         Reference<XNameAccess> xTables = xTSupplier->getTables();
  63         Sequence<OUString> aTables = xTables->getElementNames();
  64         const OUString* pTables = aTables.getConstArray();
  65         for (int i = 0; i < aTables.getLength(); i++)
  66         {
  67             OUString sEntry = pTables[i];
  68             m_xTable->append_text(sEntry);
  69             m_xTable->set_text(i, SwResId(ST_TABLE), 1);
  70         }
  71     }
  72     Reference<XQueriesSupplier> xQSupplier(m_xConnection, UNO_QUERY);
  73     if (!xQSupplier.is())
  74         return;
  75
  76     Reference<XNameAccess> xQueries = xQSupplier->getQueries();
  77     const Sequence<OUString> aQueries = xQueries->getElementNames();
  78     int nPos = m_xTable->n_children();
  79     for (const OUString& rQuery : aQueries)
  80     {
  81         m_xTable->append_text(rQuery);
  82         m_xTable->set_text(nPos, SwResId(ST_QUERY), 1);
  83         m_xTable->set_id(nPos, OUString::number(1));
  84         ++nPos;
  85     }
  86 }
  87
  88 SwSelectDBTableDialog::~SwSelectDBTableDialog() {}
  89
  90 IMPL_LINK_NOARG(SwSelectDBTableDialog, PreviewHdl, weld::Button&, void)
  91 {
  92     int nEntry = m_xTable->get_selected_index();
  93     if (nEntry == -1)
  94         return;
  95
  96     OUString sTableOrQuery = m_xTable->get_text(nEntry, 0);
  97     sal_Int32 nCommandType = m_xTable->get_id(nEntry).isEmpty() ? 0 : 1;
  98
  99     OUString sDataSourceName;
 100     Reference<XChild> xChild(m_xConnection, UNO_QUERY);
 101     if (xChild.is())
 102     {
 103         Reference<XDataSource> xSource(xChild->getParent(), UNO_QUERY);
 104         Reference<XPropertySet> xPrSet(xSource, UNO_QUERY);
 105         xPrSet->getPropertyValue("Name") >>= sDataSourceName;
 106     }
 107     OSL_ENSURE(!sDataSourceName.isEmpty(), "no data source found");
 108     Sequence<PropertyValue> aProperties{
 109         comphelper::makePropertyValue("DataSourceName", sDataSourceName),
 110         comphelper::makePropertyValue("Command", sTableOrQuery),
 111         comphelper::makePropertyValue("CommandType", nCommandType),
 112         comphelper::makePropertyValue("ShowTreeView", false),
 113         comphelper::makePropertyValue("ShowTreeViewButton", false)
 114     };
 115
 116     SwDBTablePreviewDialog aDlg(m_xDialog.get(), aProperties);
 117     aDlg.run();
 118 }
 119
 120 OUString SwSelectDBTableDialog::GetSelectedTable(bool& bIsTable)
 121 {
 122     int nEntry = m_xTable->get_selected_index();
 123     if (nEntry != -1)
 124     {
 125         bIsTable = m_xTable->get_id(nEntry).isEmpty();
 126         return m_xTable->get_text(nEntry, 0);
 127     }
 128     bIsTable = false;
 129     return OUString();
 130 }
 131
 132 void SwSelectDBTableDialog::SetSelectedTable(std::u16string_view rTable, bool bIsTable)
 133 {
 134     for (int i = 0, nCount = m_xTable->n_children(); i < nCount; ++i)
 135     {
 136         if (m_xTable->get_text(i, 0) == rTable && m_xTable->get_id(i).isEmpty() == bIsTable)
 137         {
 138             m_xTable->select(i);
 139             break;
 140         }
 141     }
 142 }
 143
 144 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */