Line data Source code
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 : #ifndef DBAUI_QUERYCONTROLLER_HXX
21 : #define DBAUI_QUERYCONTROLLER_HXX
22 :
23 : #include "JoinController.hxx"
24 : #include "JoinTableView.hxx"
25 : #include "querycontainerwindow.hxx"
26 : #include "queryview.hxx"
27 : #include "svx/ParseContext.hxx"
28 : #include "TableFieldDescription.hxx"
29 :
30 : #include <com/sun/star/io/XObjectInputStream.hpp>
31 : #include <com/sun/star/io/XObjectOutputStream.hpp>
32 : #include <com/sun/star/sdb/CommandType.hpp>
33 : #include <com/sun/star/sdb/XSQLQueryComposer.hpp>
34 : #include <com/sun/star/sdbc/XConnection.hpp>
35 : #include <com/sun/star/sdbcx/XAlterView.hpp>
36 :
37 : #include <comphelper/proparrhlp.hxx>
38 : #include <comphelper/propertycontainer.hxx>
39 : #include <comphelper/uno3.hxx>
40 : #include <connectivity/sqliterator.hxx>
41 : #include <connectivity/sqlnode.hxx>
42 : #include <connectivity/sqlparse.hxx>
43 : #include <svl/undo.hxx>
44 :
45 : namespace comphelper
46 : {
47 : class NamedValueCollection;
48 : }
49 :
50 : namespace dbaui
51 : {
52 : class OQueryContainerWindow;
53 :
54 : class OQueryController;
55 : typedef ::comphelper::OPropertyContainer OQueryController_PBase;
56 : typedef ::comphelper::OPropertyArrayUsageHelper< OQueryController > OQueryController_PABase;
57 : class OQueryController :public OJoinController
58 : ,public OQueryController_PBase
59 : ,public OQueryController_PABase
60 : {
61 : OTableFields m_vTableFieldDesc;
62 : OTableFields m_vUnUsedFieldsDesc; // contains fields which aren't visible and don't have any criteria
63 :
64 : ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue > m_aFieldInformation;
65 :
66 : ::svxform::OSystemParseContext* m_pParseContext;
67 : ::connectivity::OSQLParser m_aSqlParser;
68 : ::connectivity::OSQLParseTreeIterator* m_pSqlIterator;
69 :
70 : ::com::sun::star::uno::Reference< ::com::sun::star::sdb::XSQLQueryComposer > m_xComposer;
71 : /// if we're editing an existing view, this is non-NULL
72 : ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XAlterView > m_xAlterView;
73 :
74 : ::rtl::OUString m_sStatement; // contains the current sql statement
75 : ::rtl::OUString m_sUpdateCatalogName; // catalog for update data
76 : ::rtl::OUString m_sUpdateSchemaName; // schema for update data
77 : ::rtl::OUString m_sUpdateTableName; // table for update data
78 : mutable ::rtl::OUString
79 : m_sName; // name of the query
80 :
81 : sal_Int32 m_nVisibleRows; // which rows the selection browse should show
82 : sal_Int32 m_nSplitPos; // the position of the splitter
83 : sal_Int32 m_nCommandType; // the type of the object we're designing
84 : sal_Bool m_bGraphicalDesign; // are we in the graphical design mode (sal_True) or in the text design (sal_False)?
85 : sal_Bool m_bDistinct; // true when you want "select distinct" otherwise false
86 : sal_Bool m_bViewAlias; // show the alias row in the design view
87 : sal_Bool m_bViewTable; // show the table row in the design view
88 : sal_Bool m_bViewFunction; // show the function row in the design view
89 : sal_Bool m_bEscapeProcessing;// is true when we shouldn't parse the statement
90 :
91 :
92 : /** returns the container of queries, views, or command definitions, depending on what object type
93 : we design currently.
94 :
95 : Not allowed to be called if we design an independent SQL command.
96 : */
97 : ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess >
98 : getObjectContainer() const;
99 :
100 0 : inline bool editingView() const { return m_nCommandType == ::com::sun::star::sdb::CommandType::TABLE; }
101 0 : inline bool editingQuery() const { return m_nCommandType == ::com::sun::star::sdb::CommandType::QUERY; }
102 0 : inline bool editingCommand() const { return m_nCommandType == ::com::sun::star::sdb::CommandType::COMMAND; }
103 :
104 : sal_Bool askForNewName( const ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess>& _xElements,
105 : sal_Bool _bSaveAs);
106 : // creates the querycomposer
107 : void setQueryComposer();
108 : void deleteIterator();
109 : void executeQuery();
110 : bool doSaveAsDoc(sal_Bool _bSaveAs);
111 :
112 : void saveViewSettings( ::comphelper::NamedValueCollection& o_rViewSettings, const bool i_includingCriteria ) const;
113 : void loadViewSettings( const ::comphelper::NamedValueCollection& o_rViewSettings );
114 : ::rtl::OUString translateStatement( bool _bFireStatementChange = true );
115 :
116 : ::rtl::OUString getDefaultName() const;
117 :
118 : protected:
119 : // all the features which should be handled by this class
120 : virtual void describeSupportedFeatures();
121 : // state of a feature. 'feature' may be the handle of a ::com::sun::star::util::URL somebody requested a dispatch interface for OR a toolbar slot.
122 : virtual FeatureState GetState(sal_uInt16 nId) const;
123 : // execute a feature
124 : virtual void Execute(sal_uInt16 nId, const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue>& aArgs);
125 :
126 : virtual void reconnect( sal_Bool _bUI );
127 : virtual ::rtl::OUString getPrivateTitle( ) const;
128 :
129 0 : OQueryContainerWindow* getContainer() const { return static_cast< OQueryContainerWindow* >( getView() ); }
130 :
131 : public:
132 : OQueryController(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM);
133 :
134 : virtual ~OQueryController();
135 0 : OTableFields& getTableFieldDesc() { return m_vTableFieldDesc; }
136 0 : OTableFields& getUnUsedFields() { return m_vUnUsedFieldsDesc; }
137 :
138 : void clearFields();
139 :
140 : virtual void impl_onModifyChanged();
141 :
142 : // should the statement be parsed by our own sql parser
143 0 : sal_Bool isEsacpeProcessing() const { return m_bEscapeProcessing; }
144 0 : sal_Bool isGraphicalDesign() const { return m_bGraphicalDesign; }
145 0 : sal_Bool isDistinct() const { return m_bDistinct; }
146 :
147 0 : ::rtl::OUString getStatement() const { return m_sStatement; }
148 0 : sal_Int32 getSplitPos() const { return m_nSplitPos;}
149 0 : sal_Int32 getVisibleRows() const { return m_nVisibleRows; }
150 :
151 0 : void setDistinct(sal_Bool _bDistinct) { m_bDistinct = _bDistinct;}
152 0 : void setSplitPos(sal_Int32 _nSplitPos) { m_nSplitPos = _nSplitPos;}
153 0 : void setVisibleRows(sal_Int32 _nVisibleRows) { m_nVisibleRows = _nVisibleRows;}
154 :
155 : sal_Int32 getColWidth(sal_uInt16 _nColPos) const;
156 :
157 : const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue >&
158 0 : getFieldInformation() const { return m_aFieldInformation; }
159 :
160 0 : ::connectivity::OSQLParser& getParser() { return m_aSqlParser; }
161 0 : ::connectivity::OSQLParseTreeIterator& getParseIterator() { return *m_pSqlIterator; }
162 :
163 : virtual sal_Bool Construct(Window* pParent);
164 :
165 : DECLARE_XINTERFACE( )
166 : DECLARE_XTYPEPROVIDER( )
167 : // XPropertySet
168 : virtual com::sun::star::uno::Reference<com::sun::star::beans::XPropertySetInfo> SAL_CALL getPropertySetInfo() throw(com::sun::star::uno::RuntimeException);
169 : virtual ::cppu::IPropertyArrayHelper& SAL_CALL getInfoHelper();
170 :
171 : // XEventListener
172 : virtual void SAL_CALL disposing( const ::com::sun::star::lang::EventObject& Source ) throw(::com::sun::star::uno::RuntimeException);
173 :
174 : // ::com::sun::star::lang::XComponent
175 : virtual void SAL_CALL disposing();
176 :
177 : virtual ::rtl::OUString SAL_CALL getImplementationName() throw(::com::sun::star::uno::RuntimeException);
178 : virtual ::com::sun::star::uno::Sequence< ::rtl::OUString> SAL_CALL getSupportedServiceNames() throw(::com::sun::star::uno::RuntimeException);
179 : // need by registration
180 : static ::rtl::OUString getImplementationName_Static() throw( ::com::sun::star::uno::RuntimeException );
181 : static ::com::sun::star::uno::Sequence< ::rtl::OUString > getSupportedServiceNames_Static(void) throw( ::com::sun::star::uno::RuntimeException );
182 : static ::com::sun::star::uno::Reference< ::com::sun::star::uno::XInterface >
183 : SAL_CALL Create(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >&);
184 :
185 : // XController
186 : virtual ::com::sun::star::uno::Any SAL_CALL getViewData(void) throw( ::com::sun::star::uno::RuntimeException );
187 : virtual void SAL_CALL restoreViewData(const ::com::sun::star::uno::Any& Data) throw( ::com::sun::star::uno::RuntimeException );
188 :
189 : private:
190 : virtual void onLoadedMenu(const ::com::sun::star::uno::Reference< ::com::sun::star::frame::XLayoutManager >& _xLayoutManager);
191 : // OPropertyArrayUsageHelper
192 : virtual ::cppu::IPropertyArrayHelper* createArrayHelper( ) const;
193 :
194 : // OPropertySetHelper
195 : virtual sal_Bool SAL_CALL convertFastPropertyValue(
196 : ::com::sun::star::uno::Any& rConvertedValue,
197 : ::com::sun::star::uno::Any& rOldValue,
198 : sal_Int32 nHandle,
199 : const ::com::sun::star::uno::Any& rValue
200 : ) throw (::com::sun::star::lang::IllegalArgumentException);
201 : virtual void SAL_CALL setFastPropertyValue_NoBroadcast(
202 : sal_Int32 nHandle,
203 : const ::com::sun::star::uno::Any& rValue
204 : ) throw (::com::sun::star::uno::Exception );
205 : virtual void SAL_CALL getFastPropertyValue(
206 : ::com::sun::star::uno::Any& rValue,
207 : sal_Int32 nHandle
208 : ) const;
209 :
210 : virtual OJoinDesignView* getJoinView();
211 : // ask the user if the design should be saved when it is modified
212 : virtual short saveModified();
213 : virtual void reset();
214 : virtual void impl_initialize();
215 :
216 : void impl_reset( const bool i_bIgnoreQuerySettings = false );
217 : /// tells the user that we needed to switch to SQL view automatically
218 : void impl_showAutoSQLViewError( const ::com::sun::star::uno::Any& _rErrorDetails );
219 :
220 : /** switches to the graphical or SQL view mode, as determined by m_bGraphicalDesign
221 : */
222 : bool impl_setViewMode( ::dbtools::SQLExceptionInfo* _pErrorInfo );
223 :
224 : /// sets m_sStatement, and notifies our respective property change listeners
225 : void setStatement_fireEvent( const ::rtl::OUString& _rNewStatement, bool _bFireStatementChange = true );
226 : /// sets the m_bEscapeProcessing member, and notifies our respective property change listeners
227 : void setEscapeProcessing_fireEvent( const sal_Bool _bEscapeProcessing );
228 :
229 : // OJoinController overridables
230 : virtual bool allowViews() const;
231 : virtual bool allowQueries() const;
232 :
233 : private:
234 : DECL_LINK( OnExecuteAddTable, void* );
235 :
236 : private:
237 : using OQueryController_PBase::getFastPropertyValue;
238 : };
239 : }
240 : #endif // DBAUI_QUERYCONTROLLER_HXX
241 :
242 : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
