dbaccess/source/ui/inc/DExport.hxx

   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 #ifndef INCLUDED_DBACCESS_SOURCE_UI_INC_DEXPORT_HXX
  20 #define INCLUDED_DBACCESS_SOURCE_UI_INC_DEXPORT_HXX
  21
  22 #include <com/sun/star/sdbc/XResultSet.hpp>
  23 #include <com/sun/star/sdbc/XResultSetMetaData.hpp>
  24 #include <com/sun/star/beans/XPropertySet.hpp>
  25 #include <com/sun/star/util/XNumberFormatter.hpp>
  26 #include <com/sun/star/container/XNameAccess.hpp>
  27 #include <com/sun/star/container/XIndexAccess.hpp>
  28 #include <com/sun/star/lang/Locale.hpp>
  29 #include <com/sun/star/lang/XMultiServiceFactory.hpp>
  30 #include <com/sun/star/util/Date.hpp>
  31 #include <com/sun/star/uno/XComponentContext.hpp>
  32 #include <map>
  33 #include <vector>
  34 #include <comphelper/stl_types.hxx>
  35 #include "TypeInfo.hxx"
  36 #include "WTypeSelect.hxx"
  37 #include "commontypes.hxx"
  38 #include "IUpdateHelper.hxx"
  39
  40 namespace com { namespace sun { namespace star {
  41     namespace awt{
  42         struct FontDescriptor;
  43     }
  44     namespace sdbc{
  45         class XPreparedStatement;
  46         class XDatabaseMetaData;
  47     }
  48 }}}
  49
  50 #define COLUMN_POSITION_NOT_FOUND   ((sal_Int32)-1)
  51
  52 class SvNumberFormatter;
  53 namespace dbaui
  54 {
  55     class OFieldDescription;
  56     class ODatabaseExport
  57     {
  58     public:
  59         typedef std::map<OUString, OFieldDescription*, ::comphelper::UStringMixLess> TColumns;
  60         typedef ::std::vector<TColumns::const_iterator>             TColumnVector;
  61         typedef ::std::vector< ::std::pair<sal_Int32,sal_Int32> >   TPositions;
  62
  63     protected:
  64         TPositions                      m_vColumns;     ///< columns to be used
  65         ::std::vector<sal_Int32>        m_vColumnTypes; ///< ColumnTypes for faster access
  66         ::std::vector<sal_Int32>        m_vColumnSize;
  67         ::std::vector<sal_Int16>        m_vNumberFormat;
  68         ::com::sun::star::lang::Locale  m_aLocale;
  69
  70         TColumns                        m_aDestColumns; ///< container for new created columns
  71         TColumnVector                   m_vDestVector;
  72
  73         ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >       m_xTable;       ///< dest table
  74         ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess>     m_xTables;      ///< container
  75         SharedConnection                                                                m_xConnection;  ///< dest conn
  76
  77         ::boost::shared_ptr<IUpdateHelper>                                              m_pUpdateHelper;
  78         ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet >          m_xResultSet;
  79         ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >    m_xFormatter;   ///< a number formatter working with the connection's NumberFormatsSupplier
  80         ::com::sun::star::uno::Reference< ::com::sun::star::uno::XComponentContext>     m_xContext;
  81         ::com::sun::star::util::Date                                                    m_aNullDate;
  82
  83         SvNumberFormatter*  m_pFormatter;
  84         SvStream&           m_rInputStream;
  85         /// for saving the selected tablename
  86         OUString     m_sDefaultTableName;
  87
  88         OUString            m_sTextToken;   ///< cell content
  89         OUString            m_sNumToken;    ///< SDNUM value
  90         OUString            m_sValToken;    ///< SDVAL value
  91         TOTypeInfoSP        m_pTypeInfo;    ///< contains the default type
  92         const TColumnVector* m_pColumnList;
  93         const OTypeInfoMap* m_pInfoMap;
  94         sal_Int32           m_nColumnPos;   ///< current column position
  95         sal_Int32           m_nRows;        ///< number of rows to be searched
  96         sal_Int32           m_nRowCount;    ///< current count of rows
  97         rtl_TextEncoding    m_nDefToken;    ///< language
  98         bool            m_bError;       ///< error and termination code
  99         bool            m_bInTbl;       ///< true, if parser is in RTF table
 100         bool            m_bHead;        ///< true, if the header hasn't been read yet
 101         bool            m_bDontAskAgain;///< if there is an error when pasting, don't show it again
 102         bool            m_bIsAutoIncrement; ///< if PKey is set by user
 103         bool            m_bFoundTable;  ///< set to true when a table was found
 104         bool            m_bCheckOnly;
 105         bool                m_bAppendFirstLine;
 106
 107
 108         virtual bool    CreateTable(int nToken)         = 0;
 109         virtual TypeSelectionPageFactory
 110                             getTypeSelectionPageFactory()   = 0;
 111
 112         void                CreateDefaultColumn(const OUString& _rColumnName);
 113         sal_Int16           CheckString(const OUString& aToken, sal_Int16 _nOldNumberFormat);
 114         void                adjustFormat();
 115         void                eraseTokens();
 116         void                insertValueIntoColumn();
 117         bool                createRowSet();
 118         void                showErrorDialog(const ::com::sun::star::sdbc::SQLException& e);
 119         void                ensureFormatter();
 120
 121         /** executeWizard calls a wizard to create/append data
 122
 123             @param  _sTableName the tablename
 124             @param  _aTextColor the text color of the new created table
 125             @param  _rFont      the font of the new table
 126
 127             @return true when an error occurs
 128         */
 129         bool                executeWizard( const OUString& _sTableName,
 130                                            const ::com::sun::star::uno::Any& _aTextColor,
 131                                            const ::com::sun::star::awt::FontDescriptor& _rFont);
 132
 133         virtual ~ODatabaseExport();
 134
 135     public:
 136         ODatabaseExport(
 137             const SharedConnection& _rxConnection,
 138             const ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >& _rxNumberF,
 139             const ::com::sun::star::uno::Reference< ::com::sun::star::uno::XComponentContext >& _rxContext,
 140             const TColumnVector* rList,
 141             const OTypeInfoMap* _pInfoMap,
 142             SvStream& _rInputStream
 143         );
 144
 145         // required for automatic type recognition
 146         ODatabaseExport(
 147             sal_Int32 nRows,
 148             const TPositions& _rColumnPositions,
 149             const ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >& _rxNumberF,
 150             const ::com::sun::star::uno::Reference< ::com::sun::star::uno::XComponentContext >& _rxContext,
 151             const TColumnVector* rList,
 152             const OTypeInfoMap* _pInfoMap,
 153             bool _bAutoIncrementEnabled,
 154             SvStream& _rInputStream
 155         );
 156
 157         void SetColumnTypes(const TColumnVector* rList,const OTypeInfoMap* _pInfoMap);
 158
 159         inline void SetTableName(const OUString &_sTableName){ m_sDefaultTableName = _sTableName ; }
 160
 161         virtual void release() = 0;
 162
 163         void enableCheckOnly() { m_bCheckOnly = true; }
 164         bool isCheckEnabled() const { return m_bCheckOnly; }
 165
 166         static ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XPreparedStatement > createPreparedStatment( const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData>& _xMetaData
 167                                                        ,const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& _xDestTable
 168                                                        ,const TPositions& _rvColumns);
 169     };
 170 }
 171
 172 #endif
 173
 174 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */