/src/libreoffice/connectivity/source/commontools/TDatabaseMetaDataBase.cxx
Line | Count | Source |
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 | | #include <sal/config.h> |
21 | | |
22 | | #include <cstddef> |
23 | | |
24 | | #include <TDatabaseMetaDataBase.hxx> |
25 | | #include <RowFunctionParser.hxx> |
26 | | |
27 | | #include <comphelper/sequenceashashmap.hxx> |
28 | | #include <comphelper/evtlistenerhlp.hxx> |
29 | | #include <comphelper/types.hxx> |
30 | | #include <com/sun/star/lang/XComponent.hpp> |
31 | | #include <resource/sharedresources.hxx> |
32 | | #include <strings.hrc> |
33 | | #include <connectivity/dbexception.hxx> |
34 | | |
35 | | using namespace com::sun::star::uno; |
36 | | using namespace com::sun::star::lang; |
37 | | using namespace com::sun::star::sdbc; |
38 | | using namespace com::sun::star::beans; |
39 | | using namespace comphelper; |
40 | | using namespace connectivity; |
41 | | |
42 | | |
43 | | ODatabaseMetaDataBase::ODatabaseMetaDataBase(const Reference< XConnection >& _rxConnection,const Sequence< PropertyValue >& _rInfo) |
44 | 0 | : m_aConnectionInfo(_rInfo) |
45 | 0 | ,m_isCatalogAtStart(false,false) |
46 | 0 | ,m_sCatalogSeparator(false,OUString()) |
47 | 0 | ,m_sIdentifierQuoteString(false,OUString()) |
48 | 0 | ,m_supportsCatalogsInTableDefinitions(false,false) |
49 | 0 | ,m_supportsSchemasInTableDefinitions(false,false) |
50 | 0 | ,m_supportsCatalogsInDataManipulation(false,false) |
51 | 0 | ,m_supportsSchemasInDataManipulation(false,false) |
52 | 0 | ,m_supportsMixedCaseQuotedIdentifiers(false,false) |
53 | 0 | ,m_supportsAlterTableWithAddColumn(false,false) |
54 | 0 | ,m_supportsAlterTableWithDropColumn(false,false) |
55 | 0 | ,m_MaxStatements(false,0) |
56 | 0 | ,m_MaxTablesInSelect(false,0) |
57 | 0 | ,m_storesMixedCaseQuotedIdentifiers(false,false) |
58 | 0 | , m_xConnection(_rxConnection) |
59 | 0 | { |
60 | 0 | osl_atomic_increment( &m_refCount ); |
61 | 0 | { |
62 | 0 | m_xListenerHelper = new OEventListenerHelper(this); |
63 | 0 | Reference<XComponent> xCom(m_xConnection,UNO_QUERY); |
64 | 0 | if(xCom.is()) |
65 | 0 | xCom->addEventListener(m_xListenerHelper); |
66 | 0 | } |
67 | 0 | osl_atomic_decrement( &m_refCount ); |
68 | 0 | } |
69 | | |
70 | | ODatabaseMetaDataBase::~ODatabaseMetaDataBase() |
71 | 0 | { |
72 | 0 | } |
73 | | |
74 | | |
75 | | Sequence< PropertyValue > SAL_CALL ODatabaseMetaDataBase::getConnectionInfo( ) |
76 | 0 | { |
77 | 0 | return m_aConnectionInfo; |
78 | 0 | } |
79 | | |
80 | | |
81 | | void SAL_CALL ODatabaseMetaDataBase::disposing( const EventObject& /*Source*/ ) |
82 | 0 | { |
83 | | // cut off all references to the connection |
84 | 0 | m_xConnection.clear(); |
85 | 0 | m_xListenerHelper.clear(); |
86 | 0 | } |
87 | | |
88 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getTypeInfo( ) |
89 | 0 | { |
90 | 0 | ::osl::MutexGuard aGuard( m_aMutex ); |
91 | 0 | if ( m_aTypeInfoRows.empty() ) |
92 | 0 | { |
93 | 0 | Reference< XResultSet > xRet = impl_getTypeInfo_throw(); |
94 | 0 | Reference< XRow > xRow(xRet,UNO_QUERY); |
95 | 0 | ::comphelper::SequenceAsHashMap aMap(m_aConnectionInfo); |
96 | 0 | Sequence< Any > aTypeInfoSettings; |
97 | 0 | aTypeInfoSettings = aMap.getUnpackedValueOrDefault(u"TypeInfoSettings"_ustr,aTypeInfoSettings); |
98 | |
|
99 | 0 | if ( xRow.is() ) |
100 | 0 | { |
101 | 0 | static const sal_Int32 pTypes[] = { |
102 | 0 | DataType::VARCHAR |
103 | 0 | ,DataType::INTEGER |
104 | 0 | ,DataType::INTEGER |
105 | 0 | ,DataType::VARCHAR |
106 | 0 | ,DataType::VARCHAR |
107 | 0 | ,DataType::VARCHAR |
108 | 0 | ,DataType::INTEGER |
109 | 0 | ,DataType::BOOLEAN |
110 | 0 | ,DataType::INTEGER |
111 | 0 | ,DataType::BOOLEAN |
112 | 0 | ,DataType::BOOLEAN |
113 | 0 | ,DataType::BOOLEAN |
114 | 0 | ,DataType::VARCHAR |
115 | 0 | ,DataType::INTEGER |
116 | 0 | ,DataType::INTEGER |
117 | 0 | ,DataType::INTEGER |
118 | 0 | ,DataType::INTEGER |
119 | 0 | ,DataType::INTEGER |
120 | 0 | }; |
121 | 0 | std::vector<std::shared_ptr<ExpressionNode>> aConditions; |
122 | 0 | if ( aTypeInfoSettings.getLength() > 1 && ((aTypeInfoSettings.getLength() % 2) == 0) ) |
123 | 0 | { |
124 | 0 | try |
125 | 0 | { |
126 | 0 | for (auto& any : aTypeInfoSettings) |
127 | 0 | aConditions.push_back(FunctionParser::parseFunction(::comphelper::getString(any))); |
128 | 0 | } |
129 | 0 | catch(ParseError&) |
130 | 0 | { |
131 | 0 | ::connectivity::SharedResources aResources; |
132 | 0 | const OUString sError( aResources.getResourceString(STR_FORMULA_WRONG)); |
133 | 0 | ::dbtools::throwGenericSQLException(sError,*this); |
134 | 0 | } |
135 | 0 | } |
136 | |
|
137 | 0 | ::connectivity::ODatabaseMetaDataResultSet::ORows aTypeInfoRows; |
138 | 0 | while( xRet->next() ) |
139 | 0 | { |
140 | 0 | ::connectivity::ODatabaseMetaDataResultSet::ORow aRow; |
141 | 0 | aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue()); |
142 | 0 | const sal_Int32* pType = pTypes; |
143 | 0 | for (std::size_t i = 1; i <= std::size(pTypes); ++i,++pType) |
144 | 0 | { |
145 | 0 | ORowSetValue aValue; |
146 | 0 | aValue.fill(i,*pType,xRow); |
147 | 0 | aRow.push_back(new ORowSetValueDecorator(std::move(aValue))); |
148 | 0 | } |
149 | |
|
150 | 0 | std::vector<std::shared_ptr<ExpressionNode>>::iterator aIter = aConditions.begin(); |
151 | 0 | std::vector<std::shared_ptr<ExpressionNode>>::const_iterator aEnd = aConditions.end(); |
152 | 0 | for (; aIter != aEnd; ++aIter) |
153 | 0 | { |
154 | 0 | if ( (*aIter)->evaluate(aRow)->getValue().getBool() ) |
155 | 0 | { |
156 | 0 | ++aIter; |
157 | 0 | (*aIter)->fill(aRow); |
158 | 0 | } |
159 | 0 | else |
160 | 0 | ++aIter; |
161 | 0 | } |
162 | 0 | aTypeInfoRows.push_back(std::move(aRow)); |
163 | 0 | } |
164 | 0 | m_aTypeInfoRows = std::move(aTypeInfoRows); |
165 | 0 | } |
166 | 0 | } |
167 | 0 | rtl::Reference<::connectivity::ODatabaseMetaDataResultSet> pResult = new ::connectivity::ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eTypeInfo); |
168 | 0 | pResult->setRows(std::vector(m_aTypeInfoRows)); |
169 | 0 | return pResult; |
170 | 0 | } |
171 | | |
172 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getExportedKeys( |
173 | | const Any& /*catalog*/, const OUString& /*schema*/, const OUString& /*table*/ ) |
174 | 0 | { |
175 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eExportedKeys ); |
176 | 0 | } |
177 | | |
178 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getImportedKeys( |
179 | | const Any& /*catalog*/, const OUString& /*schema*/, const OUString& /*table*/ ) |
180 | 0 | { |
181 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eImportedKeys ); |
182 | 0 | } |
183 | | |
184 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getPrimaryKeys( |
185 | | const Any& /*catalog*/, const OUString& /*schema*/, const OUString& /*table*/ ) |
186 | 0 | { |
187 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::ePrimaryKeys ); |
188 | 0 | } |
189 | | |
190 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getIndexInfo( |
191 | | const Any& /*catalog*/, const OUString& /*schema*/, const OUString& /*table*/, |
192 | | sal_Bool /*unique*/, sal_Bool /*approximate*/ ) |
193 | 0 | { |
194 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eIndexInfo ); |
195 | 0 | } |
196 | | |
197 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getBestRowIdentifier( |
198 | | const Any& /*catalog*/, const OUString& /*schema*/, const OUString& /*table*/, sal_Int32 /*scope*/, |
199 | | sal_Bool /*nullable*/ ) |
200 | 0 | { |
201 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eBestRowIdentifier ); |
202 | 0 | } |
203 | | |
204 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getCrossReference( |
205 | | const Any& /*primaryCatalog*/, const OUString& /*primarySchema*/, |
206 | | const OUString& /*primaryTable*/, const Any& /*foreignCatalog*/, |
207 | | const OUString& /*foreignSchema*/, const OUString& /*foreignTable*/ ) |
208 | 0 | { |
209 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eCrossReference ); |
210 | 0 | } |
211 | | |
212 | | Reference< XConnection > SAL_CALL ODatabaseMetaDataBase::getConnection( ) |
213 | 0 | { |
214 | 0 | return m_xConnection; |
215 | 0 | } |
216 | | |
217 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getProcedureColumns( |
218 | | const Any& /*catalog*/, const OUString& /*schemaPattern*/, |
219 | | const OUString& /*procedureNamePattern*/, const OUString& /*columnNamePattern*/ ) |
220 | 0 | { |
221 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eProcedureColumns ); |
222 | 0 | } |
223 | | |
224 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getProcedures( |
225 | | const Any& /*catalog*/, const OUString& /*schemaPattern*/, |
226 | | const OUString& /*procedureNamePattern*/ ) |
227 | 0 | { |
228 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eProcedures ); |
229 | 0 | } |
230 | | |
231 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getVersionColumns( |
232 | | const Any& /*catalog*/, const OUString& /*schema*/, const OUString& /*table*/ ) |
233 | 0 | { |
234 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eVersionColumns ); |
235 | 0 | } |
236 | | |
237 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getSchemas( ) |
238 | 0 | { |
239 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eSchemas ); |
240 | 0 | } |
241 | | |
242 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getColumnPrivileges( |
243 | | const Any& /*catalog*/, const OUString& /*schema*/, const OUString& /*table*/, |
244 | | const OUString& /*columnNamePattern*/ ) |
245 | 0 | { |
246 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eColumnPrivileges ); |
247 | 0 | } |
248 | | |
249 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getTablePrivileges( |
250 | | const Any& /*catalog*/, const OUString& /*schema*/, const OUString& /*table*/) |
251 | 0 | { |
252 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eTablePrivileges ); |
253 | 0 | } |
254 | | |
255 | | Reference< XResultSet > SAL_CALL ODatabaseMetaDataBase::getCatalogs( ) |
256 | 0 | { |
257 | 0 | return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eCatalogs ); |
258 | 0 | } |
259 | | |
260 | | OUString SAL_CALL ODatabaseMetaDataBase::getIdentifierQuoteString( ) |
261 | 0 | { |
262 | 0 | return callImplMethod(m_sIdentifierQuoteString,std::function<OUString(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_getIdentifierQuoteString_throw)); |
263 | 0 | } |
264 | | |
265 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::isCatalogAtStart( ) |
266 | 0 | { |
267 | 0 | return callImplMethod(m_isCatalogAtStart,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_isCatalogAtStart_throw)); |
268 | 0 | } |
269 | | |
270 | | OUString SAL_CALL ODatabaseMetaDataBase::getCatalogSeparator( ) |
271 | 0 | { |
272 | 0 | return callImplMethod(m_sCatalogSeparator,std::function<OUString(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_getCatalogSeparator_throw)); |
273 | 0 | } |
274 | | |
275 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::supportsCatalogsInTableDefinitions( ) |
276 | 0 | { |
277 | 0 | return callImplMethod(m_supportsCatalogsInTableDefinitions,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_supportsCatalogsInTableDefinitions_throw)); |
278 | 0 | } |
279 | | |
280 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::supportsSchemasInTableDefinitions( ) |
281 | 0 | { |
282 | 0 | return callImplMethod(m_supportsSchemasInTableDefinitions,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_supportsSchemasInTableDefinitions_throw)); |
283 | 0 | } |
284 | | |
285 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::supportsCatalogsInDataManipulation( ) |
286 | 0 | { |
287 | 0 | return callImplMethod(m_supportsCatalogsInDataManipulation,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_supportsCatalogsInDataManipulation_throw)); |
288 | 0 | } |
289 | | |
290 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::supportsSchemasInDataManipulation( ) |
291 | 0 | { |
292 | 0 | return callImplMethod(m_supportsSchemasInDataManipulation,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_supportsSchemasInDataManipulation_throw)); |
293 | 0 | } |
294 | | |
295 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::supportsMixedCaseQuotedIdentifiers( ) |
296 | 0 | { |
297 | 0 | return callImplMethod(m_supportsMixedCaseQuotedIdentifiers,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_supportsMixedCaseQuotedIdentifiers_throw)); |
298 | 0 | } |
299 | | |
300 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::supportsAlterTableWithAddColumn( ) |
301 | 0 | { |
302 | 0 | return callImplMethod(m_supportsAlterTableWithAddColumn,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_supportsAlterTableWithAddColumn_throw)); |
303 | 0 | } |
304 | | |
305 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::supportsAlterTableWithDropColumn( ) |
306 | 0 | { |
307 | 0 | return callImplMethod(m_supportsAlterTableWithDropColumn,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_supportsAlterTableWithDropColumn_throw)); |
308 | 0 | } |
309 | | |
310 | | sal_Int32 SAL_CALL ODatabaseMetaDataBase::getMaxStatements( ) |
311 | 0 | { |
312 | 0 | return callImplMethod(m_MaxStatements,std::function<sal_Int32(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_getMaxStatements_throw)); |
313 | 0 | } |
314 | | |
315 | | sal_Int32 SAL_CALL ODatabaseMetaDataBase::getMaxTablesInSelect( ) |
316 | 0 | { |
317 | 0 | return callImplMethod(m_MaxTablesInSelect,std::function<sal_Int32(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_getMaxTablesInSelect_throw)); |
318 | 0 | } |
319 | | |
320 | | sal_Bool SAL_CALL ODatabaseMetaDataBase::storesMixedCaseQuotedIdentifiers( ) |
321 | 0 | { |
322 | 0 | return callImplMethod(m_storesMixedCaseQuotedIdentifiers,std::function<bool(ODatabaseMetaDataBase *)>(&ODatabaseMetaDataBase::impl_storesMixedCaseQuotedIdentifiers_throw)); |
323 | 0 | } |
324 | | |
325 | | |
326 | | /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |