xref: /aoo41x/main/dbaccess/source/ui/inc/DExport.hxx (revision cdf0e10c)

/*************************************************************************
 *
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
 *
 * Copyright 2000, 2010 Oracle and/or its affiliates.
 *
 * OpenOffice.org - a multi-platform office productivity suite
 *
 * This file is part of OpenOffice.org.
 *
 * OpenOffice.org is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License version 3
 * only, as published by the Free Software Foundation.
 *
 * OpenOffice.org is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License version 3 for more details
 * (a copy is included in the LICENSE file that accompanied this code).
 *
 * You should have received a copy of the GNU Lesser General Public License
 * version 3 along with OpenOffice.org.  If not, see
 * <http://www.openoffice.org/license.html>
 * for a copy of the LGPLv3 License.
 *
 ************************************************************************/
#ifndef DBAUI_DATABASEEXPORT_HXX
#define DBAUI_DATABASEEXPORT_HXX

#include <com/sun/star/sdbc/XResultSet.hpp>
#include <com/sun/star/sdbc/XResultSetMetaData.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/container/XIndexAccess.hpp>
#include <com/sun/star/lang/Locale.hpp>
#include <com/sun/star/lang/XMultiServiceFactory.hpp>
#include <com/sun/star/util/Date.hpp>
#include <vector>
#include <tools/string.hxx>
#include <comphelper/stl_types.hxx>
#include "TypeInfo.hxx"
#include "WTypeSelect.hxx"
#include "commontypes.hxx"
#include "IUpdateHelper.hxx"
#include "WTypeSelect.hxx"

namespace com { namespace sun { namespace star {
    namespace awt{
	    struct FontDescriptor;
    }
    namespace sdbc{
	    class XPreparedStatement;
        class XDatabaseMetaData;
    }
}}}

#define COLUMN_POSITION_NOT_FOUND   ((sal_Int32)-1)

class Window;
class SvNumberFormatter;
namespace dbaui
{
	class OFieldDescription;
	class OTypeInfo;
	class OWizTypeSelect;
	class ODatabaseExport
	{
	public:
		DECLARE_STL_MAP(::rtl::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_vColumns;		// Welche Spalten "ubernommen werden sollen
		::std::vector<sal_Int32>		m_vColumnTypes; // FeldTypen f"ur schnelleren Zugriff
		::std::vector<sal_Int32>		m_vColumnSize;
		::std::vector<sal_Int16>		m_vNumberFormat;
		::com::sun::star::lang::Locale	m_aLocale;

        TColumns		                m_aDestColumns; // container for new created columns
		TColumnVector	                m_vDestVector;

		::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >		m_xTable;		// dest table
		::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess>		m_xTables;		// container
		SharedConnection                                                                m_xConnection;	// dest conn

        ::boost::shared_ptr<IUpdateHelper>                                              m_pUpdateHelper;
		::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet >			m_xResultSet;	//
		::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter > 	m_xFormatter;	// a number formatter working with the connection's NumberFormatsSupplier
		::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory> m_xFactory;
        ::com::sun::star::util::Date                                                    m_aNullDate;

        SvNumberFormatter*  m_pFormatter;
        SvStream&           m_rInputStream;
		//dyf add 2006/06/01
		//for save the selected tablename
		::rtl::OUString     m_sDefaultTableName;
		//dyf add end
		String				m_sTextToken;		// Zellen Inhalt
        String				m_sNumToken;        /// SDNUM value
        String				m_sValToken;        /// SDVAL value
		TOTypeInfoSP		m_pTypeInfo;	// contains the default type
		const TColumnVector* m_pColumnList;
		const OTypeInfoMap* m_pInfoMap;
		sal_Int32			m_nColumnPos;		// aktuelle Spaltenposition
		sal_Int32			m_nRows;		// Anzahl der Zeilen die durchsucht werden sollen
		sal_Int32			m_nRowCount;	// current count of rows
		rtl_TextEncoding	m_nDefToken;		// Sprache
		sal_Bool			m_bError;			// Fehler und Abbruchstatus
		sal_Bool			m_bInTbl;			// Ist gesetzt, wenn der Parser sich in der RTF Tabelle befindet
		sal_Bool			m_bHead;		// ist true, wenn die Kopfzeile noch nicht gelesen wurde
		sal_Bool			m_bDontAskAgain;// Falls beim Einf"ugen ein Fehler auftritt, soll die Fehlermeldung nicht
		sal_Bool			m_bIsAutoIncrement; // if PKey is set by user
		sal_Bool			m_bFoundTable;		// set to true when a table was found
		sal_Bool			m_bCheckOnly;
        bool                m_bAppendFirstLine;


		virtual sal_Bool		CreateTable(int nToken)			= 0;
        virtual TypeSelectionPageFactory
                                getTypeSelectionPageFactory()   = 0;

		void					CreateDefaultColumn(const ::rtl::OUString& _rColumnName);
		sal_Int16				CheckString(const String& aToken, sal_Int16 _nOldNumberFormat);
        void                    adjustFormat();
        void                    eraseTokens();
		void					insertValueIntoColumn();
		sal_Bool				createRowSet();
		void					showErrorDialog(const ::com::sun::star::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
		*/
		sal_Bool				executeWizard(	const ::rtl::OUString& _sTableName,
												const ::com::sun::star::uno::Any& _aTextColor,
												const ::com::sun::star::awt::FontDescriptor& _rFont);

		virtual ~ODatabaseExport();
	public:
		ODatabaseExport(
            const SharedConnection& _rxConnection,
			const ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >& _rxNumberF,
			const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM,
			const TColumnVector* rList,
			const OTypeInfoMap* _pInfoMap,
            SvStream& _rInputStream
        );

		// wird f"ur auto. Typ-Erkennung gebraucht
		ODatabaseExport(
            sal_Int32 nRows,
			const TPositions& _rColumnPositions,
			const ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >& _rxNumberF,
			const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM,
			const TColumnVector* rList,
			const OTypeInfoMap* _pInfoMap,
            sal_Bool _bAutoIncrementEnabled,
            SvStream& _rInputStream
        );

		void	SetColumnTypes(const TColumnVector* rList,const OTypeInfoMap* _pInfoMap);

		//dyf add 20070601
		inline void                    SetTableName(const ::rtl::OUString &_sTableName){ m_sDefaultTableName = _sTableName ; }
		//dyf add end

		virtual void release() = 0;

		void enableCheckOnly() { m_bCheckOnly = sal_True; }
		sal_Bool isCheckEnabled() const { return m_bCheckOnly; }

        static ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XPreparedStatement > createPreparedStatment( const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData>& _xMetaData
                                                       ,const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& _xDestTable
                                                       ,const TPositions& _rvColumns);
	};
}

#endif // DBAUI_DATABASEEXPORT_HXX