Branch data Line data Source code
1 : : /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 : : /*************************************************************************
3 : : *
4 : : * Effective License of whole file:
5 : : *
6 : : * This library is free software; you can redistribute it and/or
7 : : * modify it under the terms of the GNU Lesser General Public
8 : : * License version 2.1, as published by the Free Software Foundation.
9 : : *
10 : : * This library is distributed in the hope that it will be useful,
11 : : * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 : : * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13 : : * Lesser General Public License for more details.
14 : : *
15 : : * You should have received a copy of the GNU Lesser General Public
16 : : * License along with this library; if not, write to the Free Software
17 : : * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
18 : : * MA 02111-1307 USA
19 : : *
20 : : * Parts "Copyright by Sun Microsystems, Inc" prior to August 2011:
21 : : *
22 : : * The Contents of this file are made available subject to the terms of
23 : : * the GNU Lesser General Public License Version 2.1
24 : : *
25 : : * Copyright: 2000 by Sun Microsystems, Inc.
26 : : *
27 : : * Contributor(s): Joerg Budischewski
28 : : *
29 : : * All parts contributed on or after August 2011:
30 : : *
31 : : * Version: MPL 1.1 / GPLv3+ / LGPLv2.1+
32 : : *
33 : : * The contents of this file are subject to the Mozilla Public License Version
34 : : * 1.1 (the "License"); you may not use this file except in compliance with
35 : : * the License or as specified alternatively below. You may obtain a copy of
36 : : * the License at http://www.mozilla.org/MPL/
37 : : *
38 : : * Software distributed under the License is distributed on an "AS IS" basis,
39 : : * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
40 : : * for the specific language governing rights and limitations under the
41 : : * License.
42 : : *
43 : : * Major Contributor(s):
44 : : * [ Copyright (C) 2011 Lionel Elie Mamane <lionel@mamane.lu> ]
45 : : *
46 : : * All Rights Reserved.
47 : : *
48 : : * For minor contributions see the git repository.
49 : : *
50 : : * Alternatively, the contents of this file may be used under the terms of
51 : : * either the GNU General Public License Version 3 or later (the "GPLv3+"), or
52 : : * the GNU Lesser General Public License Version 2.1 or later (the "LGPLv2.1+"),
53 : : * in which case the provisions of the GPLv3+ or the LGPLv2.1+ are applicable
54 : : * instead of those above.
55 : : *
56 : : ************************************************************************/
57 : :
58 : : #ifndef _PQ_STATEMENT_HXX_
59 : : #define _PQ_STATEMENT_HXX_
60 : : #include <cppuhelper/propshlp.hxx>
61 : : #include <cppuhelper/component.hxx>
62 : :
63 : : #include <libpq-fe.h>
64 : :
65 : : #include "pq_connection.hxx"
66 : : #include <com/sun/star/sdbc/XMultipleResults.hpp>
67 : : #include <com/sun/star/sdbc/XGeneratedResultSet.hpp>
68 : : #include <com/sun/star/sdbc/XResultSetMetaDataSupplier.hpp>
69 : :
70 : : namespace pq_sdbc_driver
71 : : {
72 : :
73 : : static const sal_Int32 STATEMENT_CURSOR_NAME = 0;
74 : : static const sal_Int32 STATEMENT_ESCAPE_PROCESSING = 1;
75 : : static const sal_Int32 STATEMENT_FETCH_DIRECTION = 2;
76 : : static const sal_Int32 STATEMENT_FETCH_SIZE = 3;
77 : : static const sal_Int32 STATEMENT_MAX_FIELD_SIZE = 4;
78 : : static const sal_Int32 STATEMENT_MAX_ROWS = 5;
79 : : static const sal_Int32 STATEMENT_QUERY_TIME_OUT = 6;
80 : : static const sal_Int32 STATEMENT_RESULT_SET_CONCURRENCY = 7;
81 : : static const sal_Int32 STATEMENT_RESULT_SET_TYPE = 8;
82 : :
83 : : #define STATEMENT_SIZE 9
84 : :
85 : : class Statement : public cppu::OComponentHelper,
86 : : public cppu::OPropertySetHelper,
87 : : public com::sun::star::sdbc::XStatement,
88 : : public com::sun::star::sdbc::XCloseable,
89 : : public com::sun::star::sdbc::XWarningsSupplier,
90 : : public com::sun::star::sdbc::XMultipleResults,
91 : : public com::sun::star::sdbc::XGeneratedResultSet,
92 : : public com::sun::star::sdbc::XResultSetMetaDataSupplier
93 : : {
94 : : private:
95 : : com::sun::star::uno::Any m_props[STATEMENT_SIZE];
96 : : com::sun::star::uno::Reference< com::sun::star::sdbc::XConnection > m_connection;
97 : : ConnectionSettings *m_pSettings;
98 : : com::sun::star::uno::Reference< com::sun::star::sdbc::XCloseable > m_lastResultset;
99 : : ::rtl::Reference< RefCountedMutex > m_refMutex;
100 : : sal_Bool m_multipleResultAvailable;
101 : : sal_Int32 m_multipleResultUpdateCount;
102 : : sal_Int32 m_lastOidInserted;
103 : : rtl::OUString m_lastTableInserted;
104 : : rtl::OString m_lastQuery;
105 : :
106 : : public:
107 : : /**
108 : : * @param ppConnection The piece of memory, pConnection points to, is accessisble
109 : : * as long as a reference to paramenter con is held.
110 : : */
111 : : Statement( const rtl::Reference< RefCountedMutex > & refMutex,
112 : : const com::sun::star::uno::Reference< com::sun::star::sdbc::XConnection> & con,
113 : : struct ConnectionSettings *pSettings );
114 : :
115 : : virtual ~Statement();
116 : : public: // XInterface
117 : 0 : virtual void SAL_CALL acquire() throw() { OComponentHelper::acquire(); }
118 : 0 : virtual void SAL_CALL release() throw() { OComponentHelper::release(); }
119 : : virtual com::sun::star::uno::Any SAL_CALL queryInterface( const com::sun::star::uno::Type & reqType )
120 : : throw (com::sun::star::uno::RuntimeException);
121 : :
122 : : public: // XCloseable
123 : : virtual void SAL_CALL close( )
124 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
125 : :
126 : : public: // XStatement
127 : : virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL executeQuery(
128 : : const ::rtl::OUString& sql )
129 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
130 : : virtual sal_Int32 SAL_CALL executeUpdate( const ::rtl::OUString& sql )
131 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
132 : : virtual sal_Bool SAL_CALL execute( const ::rtl::OUString& sql )
133 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
134 : : virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > SAL_CALL getConnection( )
135 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
136 : :
137 : : public: // XWarningsSupplier
138 : : virtual ::com::sun::star::uno::Any SAL_CALL getWarnings( )
139 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
140 : : virtual void SAL_CALL clearWarnings( )
141 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
142 : :
143 : : public: // XTypeProvider, first implemented by OPropertySetHelper
144 : : virtual com::sun::star::uno::Sequence< com::sun::star::uno::Type > SAL_CALL getTypes()
145 : : throw( com::sun::star::uno::RuntimeException );
146 : : virtual com::sun::star::uno::Sequence< sal_Int8> SAL_CALL getImplementationId()
147 : : throw( com::sun::star::uno::RuntimeException );
148 : :
149 : : public: // OPropertySetHelper
150 : : virtual cppu::IPropertyArrayHelper & SAL_CALL getInfoHelper();
151 : :
152 : : virtual sal_Bool SAL_CALL convertFastPropertyValue(
153 : : ::com::sun::star::uno::Any & rConvertedValue,
154 : : ::com::sun::star::uno::Any & rOldValue,
155 : : sal_Int32 nHandle,
156 : : const ::com::sun::star::uno::Any& rValue )
157 : : throw (::com::sun::star::lang::IllegalArgumentException);
158 : :
159 : : virtual void SAL_CALL setFastPropertyValue_NoBroadcast(
160 : : sal_Int32 nHandle,
161 : : const ::com::sun::star::uno::Any& rValue )
162 : : throw (::com::sun::star::uno::Exception);
163 : :
164 : : using ::cppu::OPropertySetHelper::getFastPropertyValue;
165 : :
166 : : void SAL_CALL getFastPropertyValue(
167 : : ::com::sun::star::uno::Any& rValue,
168 : : sal_Int32 nHandle ) const;
169 : :
170 : : // XPropertySet
171 : : ::com::sun::star::uno::Reference < ::com::sun::star::beans::XPropertySetInfo > SAL_CALL getPropertySetInfo()
172 : : throw(com::sun::star::uno::RuntimeException);
173 : :
174 : : public: // XGeneratedResultSet
175 : : virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL
176 : : getGeneratedValues( )
177 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
178 : :
179 : : public: // XMultipleResults
180 : : virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getResultSet( )
181 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
182 : : virtual sal_Int32 SAL_CALL getUpdateCount( )
183 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
184 : : virtual sal_Bool SAL_CALL getMoreResults( )
185 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
186 : :
187 : : public: // OComponentHelper
188 : : virtual void SAL_CALL disposing();
189 : :
190 : : public: // XResultSetMetaDataSupplier (is required by framework (see
191 : : // dbaccess/source/core/api/preparedstatement.cxx::getMetaData() )
192 : : virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSetMetaData > SAL_CALL getMetaData( )
193 : : throw (::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
194 : :
195 : : private:
196 : : void checkClosed() throw (com::sun::star::sdbc::SQLException, com::sun::star::uno::RuntimeException);
197 : : void raiseSQLException( const ::rtl::OUString & sql, const char * errorMsg, const char *errorType = 0 )
198 : : throw ( com::sun::star::sdbc::SQLException );
199 : : };
200 : :
201 : :
202 : 0 : struct CommandData
203 : : {
204 : : ConnectionSettings **ppSettings;
205 : : sal_Int32 *pLastOidInserted;
206 : : sal_Int32 *pMultipleResultUpdateCount;
207 : : sal_Bool *pMultipleResultAvailable;
208 : : ::rtl::OUString *pLastTableInserted;
209 : : ::com::sun::star::uno::Reference< com::sun::star::sdbc::XCloseable > *pLastResultset;
210 : : ::rtl::OString *pLastQuery;
211 : : ::rtl::Reference< RefCountedMutex > refMutex;
212 : : ::com::sun::star::uno::Reference< com::sun::star::uno::XInterface > owner;
213 : : ::com::sun::star::uno::Reference< com::sun::star::sdbcx::XTablesSupplier > tableSupplier;
214 : : sal_Int32 concurrency;
215 : : };
216 : :
217 : : bool executePostgresCommand( const rtl::OString & cmd, struct CommandData *data );
218 : : com::sun::star::uno::Reference< com::sun::star::sdbc::XResultSet > getGeneratedValuesFromLastInsert(
219 : : ConnectionSettings *pConnectionSettings,
220 : : const com::sun::star::uno::Reference< com::sun::star::sdbc::XConnection > &connection,
221 : : sal_Int32 nLastOid,
222 : : const rtl::OUString & lastTableInserted,
223 : : const rtl::OString & lastQuery );
224 : :
225 : :
226 : : }
227 : : #endif
|