Coverage Report

Created: 2026-08-14 10:22

next uncovered line (L), next uncovered region (R), next uncovered branch (B)
/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: */