diff options
Diffstat (limited to 'dbaccess/source/ui/inc/DExport.hxx')
| -rw-r--r-- | dbaccess/source/ui/inc/DExport.hxx | 162 |
1 files changed, 162 insertions, 0 deletions
diff --git a/dbaccess/source/ui/inc/DExport.hxx b/dbaccess/source/ui/inc/DExport.hxx new file mode 100644 index 000000000..ab7c85811 --- /dev/null +++ b/dbaccess/source/ui/inc/DExport.hxx @@ -0,0 +1,162 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ +#pragma once + +#include <sal/config.h> + +#include <com/sun/star/sdbc/SQLException.hpp> +#include <com/sun/star/beans/XPropertySet.hpp> +#include <com/sun/star/util/XNumberFormatter.hpp> +#include <com/sun/star/container/XNameAccess.hpp> +#include <com/sun/star/lang/Locale.hpp> +#include <com/sun/star/util/Date.hpp> +#include <com/sun/star/uno/XComponentContext.hpp> +#include <map> +#include <vector> +#include <comphelper/stl_types.hxx> +#include "TypeInfo.hxx" +#include "WTypeSelect.hxx" +#include "commontypes.hxx" +#include "IUpdateHelper.hxx" + +namespace com::sun::star { + namespace awt{ + struct FontDescriptor; + } + namespace sdbc{ + class XPreparedStatement; + class XDatabaseMetaData; + } +} + +#define COLUMN_POSITION_NOT_FOUND (sal_Int32(-1)) + +class SvNumberFormatter; +namespace dbaui +{ + class OFieldDescription; + class ODatabaseExport + { + public: + typedef std::map<OUString, OFieldDescription*, ::comphelper::UStringMixLess> TColumns; + typedef std::vector<TColumns::const_iterator> TColumnVector; + typedef std::vector< std::pair<sal_Int32,sal_Int32> > TPositions; + + protected: + TPositions m_vColumnPositions; ///< columns to be used + std::vector<sal_Int32> m_vColumnTypes; ///< ColumnTypes for faster access + std::vector<sal_Int32> m_vColumnSize; + std::vector<sal_Int16> m_vNumberFormat; + css::lang::Locale m_aLocale; + + TColumns m_aDestColumns; ///< container for new created columns + TColumnVector m_vDestVector; + + css::uno::Reference< css::beans::XPropertySet > m_xTable; ///< dest table + css::uno::Reference< css::container::XNameAccess> m_xTables; ///< container + SharedConnection m_xConnection; ///< dest conn + + std::shared_ptr<IUpdateHelper> m_pUpdateHelper; + css::uno::Reference< css::util::XNumberFormatter > m_xFormatter; ///< a number formatter working with the connection's NumberFormatsSupplier + css::uno::Reference< css::uno::XComponentContext> m_xContext; + css::util::Date m_aNullDate; + + SvNumberFormatter* m_pFormatter; + SvStream& m_rInputStream; + /// for saving the selected tablename + OUString m_sDefaultTableName; + + OUString m_sTextToken; ///< cell content + OUString m_sNumToken; ///< SDNUM value + TOTypeInfoSP m_pTypeInfo; ///< contains the default type + const TColumnVector* m_pColumnList; + const OTypeInfoMap* m_pInfoMap; + sal_Int32 m_nColumnPos; ///< current column position + sal_Int32 m_nRows; ///< number of rows to be searched + sal_Int32 m_nRowCount; ///< current count of rows + bool m_bError; ///< error and termination code + bool m_bInTbl; ///< true, if parser is in RTF table + bool m_bHead; ///< true, if the header hasn't been read yet + bool m_bDontAskAgain;///< if there is an error when pasting, don't show it again + bool m_bIsAutoIncrement; ///< if PKey is set by user + bool m_bFoundTable; ///< set to true when a table was found + bool m_bCheckOnly; + bool m_bAppendFirstLine; + + + virtual TypeSelectionPageFactory + getTypeSelectionPageFactory() = 0; + + void CreateDefaultColumn(const OUString& _rColumnName); + sal_Int16 CheckString(const OUString& aToken, sal_Int16 _nOldNumberFormat); + void adjustFormat(); + void eraseTokens(); + void insertValueIntoColumn(); + void createRowSet(); + void showErrorDialog(const css::sdbc::SQLException& e); + void ensureFormatter(); + + /** executeWizard calls a wizard to create/append data + + @param _sTableName the tablename + @param _aTextColor the text color of the new created table + @param _rFont the font of the new table + + @return true when an error occurs + */ + bool executeWizard( const OUString& _sTableName, + const css::uno::Any& _aTextColor, + const css::awt::FontDescriptor& _rFont); + + virtual ~ODatabaseExport(); + + public: + ODatabaseExport( + const SharedConnection& _rxConnection, + const css::uno::Reference< css::util::XNumberFormatter >& _rxNumberF, + const css::uno::Reference< css::uno::XComponentContext >& _rxContext, + SvStream& _rInputStream + ); + + // required for automatic type recognition + ODatabaseExport( + sal_Int32 nRows, + TPositions&& _rColumnPositions, + const css::uno::Reference< css::util::XNumberFormatter >& _rxNumberF, + const css::uno::Reference< css::uno::XComponentContext >& _rxContext, + const TColumnVector* rList, + const OTypeInfoMap* _pInfoMap, + bool _bAutoIncrementEnabled, + SvStream& _rInputStream + ); + + void SetColumnTypes(const TColumnVector* rList,const OTypeInfoMap* _pInfoMap); + + void SetTableName(const OUString &_sTableName){ m_sDefaultTableName = _sTableName ; } + + void enableCheckOnly() { m_bCheckOnly = true; } + bool isCheckEnabled() const { return m_bCheckOnly; } + + static css::uno::Reference< css::sdbc::XPreparedStatement > createPreparedStatment( const css::uno::Reference< css::sdbc::XDatabaseMetaData>& _xMetaData + ,const css::uno::Reference< css::beans::XPropertySet>& _xDestTable + ,const TPositions& _rvColumnPositions); + }; +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |