LibreOffice Module connectivity (master) 1
mysqlc_prepared_resultset.hxx
Go to the documentation of this file.
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#pragma once
21
23#include "mysqlc_statement.hxx"
25#include "mysqlc_connection.hxx"
26
27#include <com/sun/star/sdbc/XCloseable.hpp>
28#include <com/sun/star/sdbc/XColumnLocate.hpp>
29#include <com/sun/star/sdbc/XResultSet.hpp>
30#include <com/sun/star/sdbc/XResultSetMetaDataSupplier.hpp>
31#include <com/sun/star/sdbc/XResultSetUpdate.hpp>
32#include <com/sun/star/sdbc/XRow.hpp>
33#include <com/sun/star/sdbc/XRowUpdate.hpp>
34#include <com/sun/star/sdbc/XWarningsSupplier.hpp>
35#include <com/sun/star/sdbcx/XDeleteRows.hpp>
36#include <com/sun/star/sdbcx/XRowLocate.hpp>
37#include <com/sun/star/util/XCancellable.hpp>
39
41
43{
44using ::com::sun::star::uno::Any;
45
47 css::sdbc::XResultSet, css::sdbc::XRow, css::sdbc::XResultSetMetaDataSupplier,
48 css::util::XCancellable, css::sdbc::XWarningsSupplier, css::sdbc::XResultSetUpdate,
49 css::sdbc::XRowUpdate, css::sdbcx::XRowLocate, css::sdbcx::XDeleteRows, css::sdbc::XCloseable,
50 css::sdbc::XColumnLocate, css::lang::XServiceInfo>
52
56 public OPropertyArrayUsageHelper<OPreparedResultSet>
57{
59 css::uno::WeakReferenceHelper m_aStatement;
60 css::uno::Reference<css::sdbc::XResultSetMetaData> m_xMetaData;
61
62 // non-owning pointers
63 MYSQL_RES* m_pResult;
64 MYSQL_STMT* m_pStmt;
65 MYSQL_FIELD* m_aFields;
66
67 rtl_TextEncoding m_encoding;
68 sal_Int32 m_nCurrentRow = 0;
69 sal_Int32 m_nColumnCount;
70 sal_Int32 m_nRowCount;
71
72 // Use c style arrays, because we have to work with pointers
73 // on these.
74 std::unique_ptr<MYSQL_BIND[]> m_aData;
75 std::unique_ptr<BindMetaData[]> m_aMetaData;
76
77 bool m_bWasNull = false;
78
79 // OPropertyArrayUsageHelper
81 // OPropertySetHelper
83
84 sal_Bool SAL_CALL convertFastPropertyValue(Any& rConvertedValue, Any& rOldValue,
85 sal_Int32 nHandle, const Any& rValue) override;
86
87 void SAL_CALL setFastPropertyValue_NoBroadcast(sal_Int32 nHandle, const Any& rValue) override;
88
89 void SAL_CALL getFastPropertyValue(Any& rValue, sal_Int32 nHandle) const override;
90
91 template <typename T> T safelyRetrieveValue(const sal_Int32 nColumnIndex);
92 template <typename T> T retrieveValue(const sal_Int32 nColumnIndex);
93 connectivity::ORowSetValue getRowSetValue(sal_Int32 nColumnIndex);
94
95 bool fetchResult();
96
97 // you can't delete objects of this type
98 virtual ~OPreparedResultSet() override = default;
99
100public:
101 virtual OUString SAL_CALL getImplementationName() override;
102
103 virtual sal_Bool SAL_CALL supportsService(OUString const& ServiceName) override;
104
105 virtual css::uno::Sequence<OUString> SAL_CALL getSupportedServiceNames() override;
106
107 OPreparedResultSet(OConnection& rConn, OPreparedStatement* pStmt, MYSQL_STMT* pMyStmt);
108
109 // ::cppu::OComponentHelper
110 void SAL_CALL disposing() override;
111
112 // XInterface
113 Any SAL_CALL queryInterface(const css::uno::Type& rType) override;
114
115 void SAL_CALL acquire() noexcept override;
116 void SAL_CALL release() noexcept override;
117
118 //XTypeProvider
119 css::uno::Sequence<css::uno::Type> SAL_CALL getTypes() override;
120
121 // XPropertySet
122 css::uno::Reference<css::beans::XPropertySetInfo> SAL_CALL getPropertySetInfo() override;
123
124 // XResultSet
125 sal_Bool SAL_CALL next() override;
126 sal_Bool SAL_CALL isBeforeFirst() override;
127 sal_Bool SAL_CALL isAfterLast() override;
128 sal_Bool SAL_CALL isFirst() override;
129 sal_Bool SAL_CALL isLast() override;
130
131 void SAL_CALL beforeFirst() override;
132 void SAL_CALL afterLast() override;
133
134 sal_Bool SAL_CALL first() override;
135 sal_Bool SAL_CALL last() override;
136
137 sal_Int32 SAL_CALL getRow() override;
138
139 sal_Bool SAL_CALL absolute(sal_Int32 row) override;
140 sal_Bool SAL_CALL relative(sal_Int32 rows) override;
141 sal_Bool SAL_CALL previous() override;
142
143 void SAL_CALL refreshRow() override;
144
145 sal_Bool SAL_CALL rowUpdated() override;
146 sal_Bool SAL_CALL rowInserted() override;
147 sal_Bool SAL_CALL rowDeleted() override;
148
149 css::uno::Reference<css::uno::XInterface> SAL_CALL getStatement() override;
150 // XRow
151 sal_Bool SAL_CALL wasNull() override;
152
153 OUString SAL_CALL getString(sal_Int32 column) override;
154
155 sal_Bool SAL_CALL getBoolean(sal_Int32 column) override;
156 sal_Int8 SAL_CALL getByte(sal_Int32 column) override;
157 sal_Int16 SAL_CALL getShort(sal_Int32 column) override;
158 sal_Int32 SAL_CALL getInt(sal_Int32 column) override;
159 sal_Int64 SAL_CALL getLong(sal_Int32 column) override;
160
161 float SAL_CALL getFloat(sal_Int32 column) override;
162 double SAL_CALL getDouble(sal_Int32 column) override;
163
164 css::uno::Sequence<sal_Int8> SAL_CALL getBytes(sal_Int32 column) override;
165 css::util::Date SAL_CALL getDate(sal_Int32 column) override;
166 css::util::Time SAL_CALL getTime(sal_Int32 column) override;
167 css::util::DateTime SAL_CALL getTimestamp(sal_Int32 column) override;
168
169 css::uno::Reference<css::io::XInputStream> SAL_CALL getBinaryStream(sal_Int32 column) override;
170 css::uno::Reference<css::io::XInputStream>
171 SAL_CALL getCharacterStream(sal_Int32 column) override;
172
173 Any SAL_CALL getObject(
174 sal_Int32 column, const css::uno::Reference<css::container::XNameAccess>& typeMap) override;
175
176 css::uno::Reference<css::sdbc::XRef> SAL_CALL getRef(sal_Int32 column) override;
177 css::uno::Reference<css::sdbc::XBlob> SAL_CALL getBlob(sal_Int32 column) override;
178 css::uno::Reference<css::sdbc::XClob> SAL_CALL getClob(sal_Int32 column) override;
179 css::uno::Reference<css::sdbc::XArray> SAL_CALL getArray(sal_Int32 column) override;
180
181 // XResultSetMetaDataSupplier
182 css::uno::Reference<css::sdbc::XResultSetMetaData> SAL_CALL getMetaData() override;
183
184 // XCancellable
185 void SAL_CALL cancel() override;
186
187 // XCloseable
188 void SAL_CALL close() override;
189
190 // XWarningsSupplier
191 Any SAL_CALL getWarnings() override;
192
193 void SAL_CALL clearWarnings() override;
194
195 // XResultSetUpdate
196 void SAL_CALL insertRow() override;
197 void SAL_CALL updateRow() override;
198 void SAL_CALL deleteRow() override;
199 void SAL_CALL cancelRowUpdates() override;
200 void SAL_CALL moveToInsertRow() override;
201 void SAL_CALL moveToCurrentRow() override;
202
203 // XRowUpdate
204 void SAL_CALL updateNull(sal_Int32 column) override;
205 void SAL_CALL updateBoolean(sal_Int32 column, sal_Bool x) override;
206 void SAL_CALL updateByte(sal_Int32 column, sal_Int8 x) override;
207 void SAL_CALL updateShort(sal_Int32 column, sal_Int16 x) override;
208 void SAL_CALL updateInt(sal_Int32 column, sal_Int32 x) override;
209 void SAL_CALL updateLong(sal_Int32 column, sal_Int64 x) override;
210 void SAL_CALL updateFloat(sal_Int32 column, float x) override;
211 void SAL_CALL updateDouble(sal_Int32 column, double x) override;
212 void SAL_CALL updateString(sal_Int32 column, const OUString& x) override;
213 void SAL_CALL updateBytes(sal_Int32 column, const css::uno::Sequence<sal_Int8>& x) override;
214 void SAL_CALL updateDate(sal_Int32 column, const css::util::Date& x) override;
215 void SAL_CALL updateTime(sal_Int32 column, const css::util::Time& x) override;
216 void SAL_CALL updateTimestamp(sal_Int32 column, const css::util::DateTime& x) override;
217 void SAL_CALL updateBinaryStream(sal_Int32 column,
218 const css::uno::Reference<css::io::XInputStream>& x,
219 sal_Int32 length) override;
220 void SAL_CALL updateCharacterStream(sal_Int32 column,
221 const css::uno::Reference<css::io::XInputStream>& x,
222 sal_Int32 length) override;
223 void SAL_CALL updateObject(sal_Int32 column, const Any& x) override;
224 void SAL_CALL updateNumericObject(sal_Int32 column, const Any& x, sal_Int32 scale) override;
225
226 // XColumnLocate
227 sal_Int32 SAL_CALL findColumn(const OUString& columnName) override;
228
229 // XRowLocate
230 Any SAL_CALL getBookmark() override;
231
232 sal_Bool SAL_CALL moveToBookmark(const Any& bookmark) override;
233 sal_Bool SAL_CALL moveRelativeToBookmark(const Any& bookmark, sal_Int32 rows) override;
234 sal_Int32 SAL_CALL compareBookmarks(const Any& first, const Any& second) override;
235 sal_Bool SAL_CALL hasOrderedBookmarks() override;
236 sal_Int32 SAL_CALL hashBookmark(const Any& bookmark) override;
237
238 // XDeleteRows
239 css::uno::Sequence<sal_Int32> SAL_CALL deleteRows(const css::uno::Sequence<Any>& rows) override;
240
243 void checkColumnIndex(sal_Int32 index);
244
245private:
247};
248
249} /* connectivity::mysqlc */
250
251/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
void SAL_CALL setFastPropertyValue_NoBroadcast(sal_Int32 nHandle, const Any &rValue) override
void SAL_CALL updateFloat(sal_Int32 column, float x) override
void SAL_CALL updateInt(sal_Int32 column, sal_Int32 x) override
void SAL_CALL updateBytes(sal_Int32 column, const css::uno::Sequence< sal_Int8 > &x) override
css::uno::Reference< css::sdbc::XRef > SAL_CALL getRef(sal_Int32 column) override
sal_Bool SAL_CALL getBoolean(sal_Int32 column) override
virtual ~OPreparedResultSet() override=default
sal_Int16 SAL_CALL getShort(sal_Int32 column) override
::cppu::IPropertyArrayHelper &SAL_CALL getInfoHelper() override
css::uno::Reference< css::io::XInputStream > SAL_CALL getCharacterStream(sal_Int32 column) override
void SAL_CALL getFastPropertyValue(Any &rValue, sal_Int32 nHandle) const override
OUString SAL_CALL getString(sal_Int32 column) override
css::uno::Reference< css::sdbc::XResultSetMetaData > SAL_CALL getMetaData() override
virtual css::uno::Sequence< OUString > SAL_CALL getSupportedServiceNames() override
void SAL_CALL updateByte(sal_Int32 column, sal_Int8 x) override
css::uno::Reference< css::uno::XInterface > SAL_CALL getStatement() override
sal_Bool SAL_CALL convertFastPropertyValue(Any &rConvertedValue, Any &rOldValue, sal_Int32 nHandle, const Any &rValue) override
Any SAL_CALL getObject(sal_Int32 column, const css::uno::Reference< css::container::XNameAccess > &typeMap) override
css::util::DateTime SAL_CALL getTimestamp(sal_Int32 column) override
T safelyRetrieveValue(const sal_Int32 nColumnIndex)
sal_Int32 SAL_CALL compareBookmarks(const Any &first, const Any &second) override
sal_Bool SAL_CALL moveToBookmark(const Any &bookmark) override
sal_Int32 SAL_CALL hashBookmark(const Any &bookmark) override
css::uno::Reference< css::sdbc::XBlob > SAL_CALL getBlob(sal_Int32 column) override
void SAL_CALL updateBoolean(sal_Int32 column, sal_Bool x) override
void SAL_CALL updateLong(sal_Int32 column, sal_Int64 x) override
css::util::Time SAL_CALL getTime(sal_Int32 column) override
css::uno::Reference< css::beans::XPropertySetInfo > SAL_CALL getPropertySetInfo() override
sal_Bool SAL_CALL absolute(sal_Int32 row) override
void SAL_CALL updateCharacterStream(sal_Int32 column, const css::uno::Reference< css::io::XInputStream > &x, sal_Int32 length) override
sal_Int8 SAL_CALL getByte(sal_Int32 column) override
void SAL_CALL updateObject(sal_Int32 column, const Any &x) override
sal_Bool SAL_CALL relative(sal_Int32 rows) override
css::uno::Reference< css::sdbc::XResultSetMetaData > m_xMetaData
float SAL_CALL getFloat(sal_Int32 column) override
void SAL_CALL updateTime(sal_Int32 column, const css::util::Time &x) override
::cppu::IPropertyArrayHelper * createArrayHelper() const override
used to implement the creation of the array helper which is shared amongst all instances of the class...
void SAL_CALL updateTimestamp(sal_Int32 column, const css::util::DateTime &x) override
Any SAL_CALL queryInterface(const css::uno::Type &rType) override
void SAL_CALL updateNull(sal_Int32 column) override
virtual sal_Bool SAL_CALL supportsService(OUString const &ServiceName) override
void SAL_CALL updateDate(sal_Int32 column, const css::util::Date &x) override
double SAL_CALL getDouble(sal_Int32 column) override
css::uno::Reference< css::sdbc::XClob > SAL_CALL getClob(sal_Int32 column) override
css::uno::Reference< css::sdbc::XArray > SAL_CALL getArray(sal_Int32 column) override
css::util::Date SAL_CALL getDate(sal_Int32 column) override
void SAL_CALL updateString(sal_Int32 column, const OUString &x) override
virtual OUString SAL_CALL getImplementationName() override
connectivity::ORowSetValue getRowSetValue(sal_Int32 nColumnIndex)
sal_Int32 SAL_CALL findColumn(const OUString &columnName) override
void SAL_CALL updateBinaryStream(sal_Int32 column, const css::uno::Reference< css::io::XInputStream > &x, sal_Int32 length) override
OPreparedResultSet(OConnection &rConn, OPreparedStatement *pStmt, MYSQL_STMT *pMyStmt)
css::uno::Sequence< sal_Int32 > SAL_CALL deleteRows(const css::uno::Sequence< Any > &rows) override
void SAL_CALL updateShort(sal_Int32 column, sal_Int16 x) override
sal_Int32 SAL_CALL getInt(sal_Int32 column) override
void SAL_CALL updateNumericObject(sal_Int32 column, const Any &x, sal_Int32 scale) override
sal_Int64 SAL_CALL getLong(sal_Int32 column) override
css::uno::Sequence< css::uno::Type > SAL_CALL getTypes() override
css::uno::Sequence< sal_Int8 > SAL_CALL getBytes(sal_Int32 column) override
void SAL_CALL updateDouble(sal_Int32 column, double x) override
css::uno::Reference< css::io::XInputStream > SAL_CALL getBinaryStream(sal_Int32 column) override
sal_Bool SAL_CALL moveRelativeToBookmark(const Any &bookmark, sal_Int32 rows) override
Type
::cppu::WeakComponentImplHelper12< css::sdbc::XResultSet, css::sdbc::XRow, css::sdbc::XResultSetMetaDataSupplier, css::util::XCancellable, css::sdbc::XWarningsSupplier, css::sdbc::XResultSetUpdate, css::sdbc::XRowUpdate, css::sdbcx::XRowLocate, css::sdbcx::XDeleteRows, css::sdbc::XCloseable, css::sdbc::XColumnLocate, css::lang::XServiceInfo > OPreparedResultSet_BASE
sal_Int32 scale
Definition: pq_statics.cxx:62
const char * columnName
Definition: pq_statics.cxx:56
unsigned char sal_Bool
signed char sal_Int8