dbaccess/source/ui/misc/WCPage.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 <WCPage.hxx>
  21 #include <WCopyTable.hxx>
  22
  23 #include <defaultobjectnamecheck.hxx>
  24 #include <strings.hrc>
  25 #include <core_resource.hxx>
  26 #include <com/sun/star/sdb/CommandType.hpp>
  27 #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
  28 #include <com/sun/star/sdb/application/CopyTableOperation.hpp>
  29 #include <connectivity/dbexception.hxx>
  30 #include <connectivity/dbtools.hxx>
  31
  32 using namespace ::dbaui;
  33 using namespace ::dbtools;
  34 using namespace ::com::sun::star::uno;
  35 using namespace ::com::sun::star::beans;
  36 using namespace ::com::sun::star::container;
  37 using namespace ::com::sun::star::sdb;
  38 using namespace ::com::sun::star::sdbc;
  39 using namespace ::com::sun::star::sdbcx;
  40
  41 namespace CopyTableOperation = css::sdb::application::CopyTableOperation;
  42
  43 OCopyTable::OCopyTable(weld::Container* pPage, OCopyTableWizard* pWizard)
  44     : OWizardPage(pPage, pWizard, u"dbaccess/ui/copytablepage.ui"_ustr, u"CopyTablePage"_ustr)
  45     , m_bPKeyAllowed(false)
  46     , m_bUseHeaderAllowed(true)
  47     , m_nOldOperation(0)
  48     , m_xEdTableName(m_xBuilder->weld_entry(u"name"_ustr))
  49     , m_xRB_DefData(m_xBuilder->weld_radio_button(u"defdata"_ustr))
  50     , m_xRB_Def(m_xBuilder->weld_radio_button(u"def"_ustr))
  51     , m_xRB_View(m_xBuilder->weld_radio_button(u"view"_ustr))
  52     , m_xRB_AppendData(m_xBuilder->weld_radio_button(u"data"_ustr))
  53     , m_xCB_UseHeaderLine(m_xBuilder->weld_check_button(u"firstline"_ustr))
  54     , m_xCB_PrimaryColumn(m_xBuilder->weld_check_button(u"primarykey"_ustr))
  55     , m_xFT_KeyName(m_xBuilder->weld_label(u"keynamelabel"_ustr))
  56     , m_xEdKeyName(m_xBuilder->weld_entry(u"keyname"_ustr))
  57 {
  58     if ( m_pParent->m_xDestConnection.is() )
  59     {
  60         if (!m_pParent->supportsViews())
  61             m_xRB_View->set_sensitive(false);
  62
  63         m_xCB_UseHeaderLine->set_active(true);
  64         m_bPKeyAllowed = m_pParent->supportsPrimaryKey();
  65
  66         m_xCB_PrimaryColumn->set_sensitive(m_bPKeyAllowed);
  67
  68         m_xRB_AppendData->connect_toggled(  LINK( this, OCopyTable, RadioChangeHdl ) );
  69         m_xRB_DefData->connect_toggled(     LINK( this, OCopyTable, RadioChangeHdl ) );
  70         m_xRB_Def->connect_toggled(         LINK( this, OCopyTable, RadioChangeHdl ) );
  71         m_xRB_View->connect_toggled(        LINK( this, OCopyTable, RadioChangeHdl ) );
  72
  73         m_xCB_PrimaryColumn->connect_toggled(LINK( this, OCopyTable, KeyClickHdl ) );
  74
  75         m_xFT_KeyName->set_sensitive(false);
  76         m_xEdKeyName->set_sensitive(false);
  77         m_xEdKeyName->set_text(m_pParent->createUniqueName(u"ID"_ustr));
  78
  79         const sal_Int32 nMaxLen = m_pParent->getMaxColumnNameLength();
  80         m_xEdKeyName->set_max_length(nMaxLen);
  81     }
  82
  83     SetPageTitle(DBA_RES(STR_COPYTABLE_TITLE_COPY));
  84 }
  85
  86 OCopyTable::~OCopyTable()
  87 {
  88 }
  89
  90 void OCopyTable::SetAppendDataRadio()
  91 {
  92     m_pParent->EnableNextButton(true);
  93     m_xFT_KeyName->set_sensitive(false);
  94     m_xCB_PrimaryColumn->set_sensitive(false);
  95     m_xEdKeyName->set_sensitive(false);
  96     m_pParent->setOperation(CopyTableOperation::AppendData);
  97 }
  98
  99 IMPL_LINK(OCopyTable, RadioChangeHdl, weld::Toggleable&, rButton, void)
 100 {
 101     if (!rButton.get_active())
 102         return;
 103     if (m_xRB_AppendData->get_active())
 104     {
 105         SetAppendDataRadio();
 106         return;
 107     }
 108     m_pParent->EnableNextButton(!m_xRB_View->get_active());
 109     bool bKey = m_bPKeyAllowed && !m_xRB_View->get_active();
 110     m_xFT_KeyName->set_sensitive(bKey && m_xCB_PrimaryColumn->get_active());
 111     m_xEdKeyName->set_sensitive(bKey && m_xCB_PrimaryColumn->get_active());
 112     m_xCB_PrimaryColumn->set_sensitive(bKey);
 113     m_xCB_UseHeaderLine->set_sensitive(m_bUseHeaderAllowed && IsOptionDefData());
 114
 115     // set type what to do
 116     if( IsOptionDefData() )
 117         m_pParent->setOperation( CopyTableOperation::CopyDefinitionAndData );
 118     else if( IsOptionDef() )
 119         m_pParent->setOperation( CopyTableOperation::CopyDefinitionOnly );
 120     else if( IsOptionView() )
 121         m_pParent->setOperation( CopyTableOperation::CreateAsView );
 122 }
 123
 124 IMPL_LINK_NOARG( OCopyTable, KeyClickHdl, weld::Toggleable&, void )
 125 {
 126     m_xEdKeyName->set_sensitive(m_xCB_PrimaryColumn->get_active());
 127     m_xFT_KeyName->set_sensitive(m_xCB_PrimaryColumn->get_active());
 128 }
 129
 130 bool OCopyTable::LeavePage()
 131 {
 132     m_pParent->m_bCreatePrimaryKeyColumn    = m_bPKeyAllowed && m_xCB_PrimaryColumn->get_sensitive() && m_xCB_PrimaryColumn->get_active();
 133     m_pParent->m_aKeyName                   = m_pParent->m_bCreatePrimaryKeyColumn ? m_xEdKeyName->get_text() : OUString();
 134     m_pParent->setUseHeaderLine( m_xCB_UseHeaderLine->get_active() );
 135
 136     // first check if the table already exists in the database
 137     if( m_pParent->getOperation() != CopyTableOperation::AppendData )
 138     {
 139         m_pParent->clearDestColumns();
 140         DynamicTableOrQueryNameCheck aNameCheck( m_pParent->m_xDestConnection, CommandType::TABLE );
 141         SQLExceptionInfo aErrorInfo;
 142         if ( !aNameCheck.isNameValid( m_xEdTableName->get_text(), aErrorInfo ) )
 143         {
 144             aErrorInfo.append( SQLExceptionInfo::TYPE::SQLContext, DBA_RES( STR_SUGGEST_APPEND_TABLE_DATA ) );
 145             m_pParent->showError(aErrorInfo.get());
 146
 147             return false;
 148         }
 149
 150         // have to check the length of the table name
 151         Reference< XDatabaseMetaData > xMeta = m_pParent->m_xDestConnection->getMetaData();
 152         OUString sCatalog;
 153         OUString sSchema;
 154         OUString sTable;
 155         ::dbtools::qualifiedNameComponents( xMeta,
 156                                             m_xEdTableName->get_text(),
 157                                             sCatalog,
 158                                             sSchema,
 159                                             sTable,
 160                                             ::dbtools::EComposeRule::InDataManipulation);
 161         sal_Int32 nMaxLength = xMeta->getMaxTableNameLength();
 162         if ( nMaxLength && sTable.getLength() > nMaxLength )
 163         {
 164             m_pParent->showError(DBA_RES(STR_INVALID_TABLE_NAME_LENGTH));
 165             return false;
 166         }
 167
 168         // now we have to check if the name of the primary key already exists
 169         if (    m_pParent->m_bCreatePrimaryKeyColumn
 170             &&  m_pParent->m_aKeyName != m_pParent->createUniqueName(m_pParent->m_aKeyName) )
 171         {
 172             m_pParent->showError(DBA_RES(STR_WIZ_NAME_ALREADY_DEFINED) + " " + m_pParent->m_aKeyName);
 173             return false;
 174         }
 175     }
 176
 177     if (m_xEdTableName->get_value_changed_from_saved())
 178     { // table exists and name has changed
 179         if ( m_pParent->getOperation() == CopyTableOperation::AppendData )
 180         {
 181             if(!checkAppendData())
 182                 return false;
 183         }
 184         else if ( m_nOldOperation == CopyTableOperation::AppendData )
 185         {
 186             m_xEdTableName->save_value();
 187             return LeavePage();
 188         }
 189     }
 190     else
 191     { // table exist and is not new or doesn't exist and so on
 192         if ( CopyTableOperation::AppendData == m_pParent->getOperation() )
 193         {
 194             if( !checkAppendData() )
 195                 return false;
 196         }
 197     }
 198     m_pParent->m_sName = m_xEdTableName->get_text();
 199     m_xEdTableName->save_value();
 200
 201     if(m_pParent->m_sName.isEmpty())
 202     {
 203         m_pParent->showError(DBA_RES(STR_INVALID_TABLE_NAME));
 204         return false;
 205     }
 206
 207     return true;
 208 }
 209
 210 void OCopyTable::Activate()
 211 {
 212     m_pParent->GetOKButton().set_sensitive(true);
 213     m_nOldOperation = m_pParent->getOperation();
 214     m_xEdTableName->grab_focus();
 215     m_xCB_UseHeaderLine->set_active(m_pParent->UseHeaderLine());
 216 }
 217
 218 OUString OCopyTable::GetTitle() const
 219 {
 220     return DBA_RES(STR_WIZ_TABLE_COPY);
 221 }
 222
 223 void OCopyTable::Reset()
 224 {
 225     m_bFirstTime = false;
 226
 227     m_xEdTableName->set_text( m_pParent->m_sName );
 228     m_xEdTableName->save_value();
 229 }
 230
 231 bool OCopyTable::checkAppendData()
 232 {
 233     m_pParent->clearDestColumns();
 234     Reference< XPropertySet > xTable;
 235     Reference< XTablesSupplier > xSup( m_pParent->m_xDestConnection, UNO_QUERY );
 236     Reference<XNameAccess> xTables;
 237     if (xSup.is())
 238         xTables = xSup->getTables();
 239     if (xTables.is() && xTables->hasByName(m_xEdTableName->get_text()))
 240     {
 241         const ODatabaseExport::TColumnVector& rSrcColumns = m_pParent->getSrcVector();
 242         const sal_uInt32 nSrcSize = rSrcColumns.size();
 243         m_pParent->m_vColumnPositions.resize( nSrcSize, ODatabaseExport::TPositions::value_type( COLUMN_POSITION_NOT_FOUND, COLUMN_POSITION_NOT_FOUND ) );
 244         m_pParent->m_vColumnTypes.resize( nSrcSize , COLUMN_POSITION_NOT_FOUND );
 245
 246         // set new destination
 247         xTables->getByName( m_xEdTableName->get_text() ) >>= xTable;
 248         ObjectCopySource aTableCopySource( m_pParent->m_xDestConnection, xTable );
 249         m_pParent->loadData( aTableCopySource, m_pParent->m_vDestColumns, m_pParent->m_aDestVec );
 250         const ODatabaseExport::TColumnVector& rDestColumns          = m_pParent->getDestVector();
 251         const sal_uInt32 nMinSrcDestSize = std::min<sal_uInt32>(nSrcSize, rDestColumns.size());
 252         sal_uInt32 i = 0;
 253         for (auto const& column : rDestColumns)
 254         {
 255             if (i >= nMinSrcDestSize)
 256                 break;
 257             bool bNotConvert = true;
 258             m_pParent->m_vColumnPositions[i] = ODatabaseExport::TPositions::value_type(i+1,i+1);
 259             TOTypeInfoSP pTypeInfo = m_pParent->convertType(column->second->getSpecialTypeInfo(),bNotConvert);
 260             if ( !bNotConvert )
 261             {
 262                 m_pParent->showColumnTypeNotSupported(column->first);
 263                 return false;
 264             }
 265
 266             if ( pTypeInfo )
 267                 m_pParent->m_vColumnTypes[i] = pTypeInfo->nType;
 268             else
 269                 m_pParent->m_vColumnTypes[i] = DataType::VARCHAR;
 270             ++i;
 271         }
 272
 273     }
 274
 275     if ( !xTable.is() )
 276     {
 277         m_pParent->showError(DBA_RES(STR_INVALID_TABLE_NAME));
 278         return false;
 279     }
 280     return true;
 281 }
 282
 283 void OCopyTable::setCreatePrimaryKey( bool _bDoCreate, const OUString& _rSuggestedName )
 284 {
 285     bool bCreatePK = m_bPKeyAllowed && _bDoCreate;
 286     m_xCB_PrimaryColumn->set_active( bCreatePK );
 287     m_xEdKeyName->set_text( _rSuggestedName );
 288
 289     m_xFT_KeyName->set_sensitive( bCreatePK );
 290     m_xEdKeyName->set_sensitive( bCreatePK );
 291 }
 292
 293 void OCopyTable::setCreateStyleAction()
 294 {
 295     // reselect the last action before
 296     switch (m_pParent->getOperation())
 297     {
 298         case CopyTableOperation::CopyDefinitionAndData:
 299             m_xRB_DefData->set_active(true);
 300             RadioChangeHdl(*m_xRB_DefData);
 301             break;
 302         case CopyTableOperation::CopyDefinitionOnly:
 303             m_xRB_Def->set_active(true);
 304             RadioChangeHdl(*m_xRB_Def);
 305             break;
 306         case CopyTableOperation::AppendData:
 307             m_xRB_AppendData->set_active(true);
 308             SetAppendDataRadio();
 309             break;
 310         case CopyTableOperation::CreateAsView:
 311             if (m_xRB_View->get_sensitive())
 312             {
 313                 m_xRB_View->set_active(true);
 314                 RadioChangeHdl(*m_xRB_View);
 315             }
 316             else
 317             {
 318                 m_xRB_DefData->set_active(true);
 319                 RadioChangeHdl(*m_xRB_DefData);
 320             }
 321     }
 322 }
 323
 324 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */