xref: /aoo42x/main/dbaccess/source/ui/inc/DExport.hxx (revision 2e2212a7)
1 /**************************************************************
2  *
3  * Licensed to the Apache Software Foundation (ASF) under one
4  * or more contributor license agreements.  See the NOTICE file
5  * distributed with this work for additional information
6  * regarding copyright ownership.  The ASF licenses this file
7  * to you under the Apache License, Version 2.0 (the
8  * "License"); you may not use this file except in compliance
9  * with the License.  You may obtain a copy of the License at
10  *
11  *   http://www.apache.org/licenses/LICENSE-2.0
12  *
13  * Unless required by applicable law or agreed to in writing,
14  * software distributed under the License is distributed on an
15  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16  * KIND, either express or implied.  See the License for the
17  * specific language governing permissions and limitations
18  * under the License.
19  *
20  *************************************************************/
21 
22 
23 #ifndef DBAUI_DATABASEEXPORT_HXX
24 #define DBAUI_DATABASEEXPORT_HXX
25 
26 #include <com/sun/star/sdbc/XResultSet.hpp>
27 #include <com/sun/star/sdbc/XResultSetMetaData.hpp>
28 #include <com/sun/star/beans/XPropertySet.hpp>
29 #include <com/sun/star/util/XNumberFormatter.hpp>
30 #include <com/sun/star/container/XNameAccess.hpp>
31 #include <com/sun/star/container/XIndexAccess.hpp>
32 #include <com/sun/star/lang/Locale.hpp>
33 #include <com/sun/star/lang/XMultiServiceFactory.hpp>
34 #include <com/sun/star/util/Date.hpp>
35 #include <vector>
36 #include <tools/string.hxx>
37 #include <comphelper/stl_types.hxx>
38 #include "TypeInfo.hxx"
39 #include "WTypeSelect.hxx"
40 #include "commontypes.hxx"
41 #include "IUpdateHelper.hxx"
42 #include "WTypeSelect.hxx"
43 
44 namespace com { namespace sun { namespace star {
45     namespace awt{
46 	    struct FontDescriptor;
47     }
48     namespace sdbc{
49 	    class XPreparedStatement;
50         class XDatabaseMetaData;
51     }
52 }}}
53 
54 #define COLUMN_POSITION_NOT_FOUND   ((sal_Int32)-1)
55 
56 class Window;
57 class SvNumberFormatter;
58 namespace dbaui
59 {
60 	class OFieldDescription;
61 	class OTypeInfo;
62 	class OWizTypeSelect;
63 	class ODatabaseExport
64 	{
65 	public:
66 		DECLARE_STL_MAP(::rtl::OUString,OFieldDescription*,::comphelper::UStringMixLess,TColumns);
67 		typedef ::std::vector<TColumns::const_iterator>				TColumnVector;
68 		typedef ::std::vector< ::std::pair<sal_Int32,sal_Int32> >	TPositions;
69 
70     protected:
71 		TPositions						m_vColumns;		// Welche Spalten "ubernommen werden sollen
72 		::std::vector<sal_Int32>		m_vColumnTypes; // FeldTypen f"ur schnelleren Zugriff
73 		::std::vector<sal_Int32>		m_vColumnSize;
74 		::std::vector<sal_Int16>		m_vNumberFormat;
75 		::com::sun::star::lang::Locale	m_aLocale;
76 
77         TColumns		                m_aDestColumns; // container for new created columns
78 		TColumnVector	                m_vDestVector;
79 
80 		::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >		m_xTable;		// dest table
81 		::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess>		m_xTables;		// container
82 		SharedConnection                                                                m_xConnection;	// dest conn
83 
84         ::boost::shared_ptr<IUpdateHelper>                                              m_pUpdateHelper;
85 		::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet >			m_xResultSet;	//
86 		::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter > 	m_xFormatter;	// a number formatter working with the connection's NumberFormatsSupplier
87 		::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory> m_xFactory;
88         ::com::sun::star::util::Date                                                    m_aNullDate;
89 
90         SvNumberFormatter*  m_pFormatter;
91         SvStream&           m_rInputStream;
92 		//dyf add 2006/06/01
93 		//for save the selected tablename
94 		::rtl::OUString     m_sDefaultTableName;
95 		//dyf add end
96 		String				m_sTextToken;		// Zellen Inhalt
97         String				m_sNumToken;        /// SDNUM value
98         String				m_sValToken;        /// SDVAL value
99 		TOTypeInfoSP		m_pTypeInfo;	// contains the default type
100 		const TColumnVector* m_pColumnList;
101 		const OTypeInfoMap* m_pInfoMap;
102 		sal_Int32			m_nColumnPos;		// aktuelle Spaltenposition
103 		sal_Int32			m_nRows;		// Anzahl der Zeilen die durchsucht werden sollen
104 		sal_Int32			m_nRowCount;	// current count of rows
105 		rtl_TextEncoding	m_nDefToken;		// Sprache
106 		sal_Bool			m_bError;			// Fehler und Abbruchstatus
107 		sal_Bool			m_bInTbl;			// Ist gesetzt, wenn der Parser sich in der RTF Tabelle befindet
108 		sal_Bool			m_bHead;		// ist true, wenn die Kopfzeile noch nicht gelesen wurde
109 		sal_Bool			m_bDontAskAgain;// Falls beim Einf"ugen ein Fehler auftritt, soll die Fehlermeldung nicht
110 		sal_Bool			m_bIsAutoIncrement; // if PKey is set by user
111 		sal_Bool			m_bFoundTable;		// set to true when a table was found
112 		sal_Bool			m_bCheckOnly;
113         bool                m_bAppendFirstLine;
114 
115 
116 		virtual sal_Bool		CreateTable(int nToken)			= 0;
117         virtual TypeSelectionPageFactory
118                                 getTypeSelectionPageFactory()   = 0;
119 
120 		void					CreateDefaultColumn(const ::rtl::OUString& _rColumnName);
121 		sal_Int16				CheckString(const String& aToken, sal_Int16 _nOldNumberFormat);
122         void                    adjustFormat();
123         void                    eraseTokens();
124 		void					insertValueIntoColumn();
125 		sal_Bool				createRowSet();
126 		void					showErrorDialog(const ::com::sun::star::sdbc::SQLException& e);
127         void                    ensureFormatter();
128 
129 		/** executeWizard calls a wizard to create/append data
130 			@param	_sTableName	the tablename
131 			@param	_aTextColor	the text color of the new created table
132 			@param	_rFont		the font of the new table
133 
134 			@return	true when an error occurs
135 		*/
136 		sal_Bool				executeWizard(	const ::rtl::OUString& _sTableName,
137 												const ::com::sun::star::uno::Any& _aTextColor,
138 												const ::com::sun::star::awt::FontDescriptor& _rFont);
139 
140 		virtual ~ODatabaseExport();
141 	public:
142 		ODatabaseExport(
143             const SharedConnection& _rxConnection,
144 			const ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >& _rxNumberF,
145 			const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM,
146 			const TColumnVector* rList,
147 			const OTypeInfoMap* _pInfoMap,
148             SvStream& _rInputStream
149         );
150 
151 		// wird f"ur auto. Typ-Erkennung gebraucht
152 		ODatabaseExport(
153             sal_Int32 nRows,
154 			const TPositions& _rColumnPositions,
155 			const ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter >& _rxNumberF,
156 			const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM,
157 			const TColumnVector* rList,
158 			const OTypeInfoMap* _pInfoMap,
159             sal_Bool _bAutoIncrementEnabled,
160             SvStream& _rInputStream
161         );
162 
163 		void	SetColumnTypes(const TColumnVector* rList,const OTypeInfoMap* _pInfoMap);
164 
165 		//dyf add 20070601
SetTableName(const::rtl::OUString & _sTableName)166 		inline void                    SetTableName(const ::rtl::OUString &_sTableName){ m_sDefaultTableName = _sTableName ; }
167 		//dyf add end
168 
169 		virtual void release() = 0;
170 
enableCheckOnly()171 		void enableCheckOnly() { m_bCheckOnly = sal_True; }
isCheckEnabled() const172 		sal_Bool isCheckEnabled() const { return m_bCheckOnly; }
173 
174         static ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XPreparedStatement > createPreparedStatment( const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData>& _xMetaData
175                                                        ,const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& _xDestTable
176                                                        ,const TPositions& _rvColumns);
177 	};
178 }
179 
180 #endif // DBAUI_DATABASEEXPORT_HXX
181 
182 
183 
184 
185 
186