Files
odfstudio/svx/source/inc/sqlparserclient.hxx
Vissarion Fisikopoulos 68bed36a97 tdf#153057, tdf#173589 enable Base to filter date and time values
This patch implements and fixes cases for filtering. In particular
the cases for form-based and dialogue-based filtering in forms for
data and time. Additionally, the cases for time values in Table
Data View.

A specific limitation comes from firebird which accepts only 4 digits
for nanoseconds in time values. The data are rounded to that digit
for firebird while still support full precision (up to 9 digits)
for other engines. This is implemented using the driver's metadata
functions.

Unit tests are added.

Change-Id: I89435da239c898f3c782fcc9f78f98caf4223f62
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/211298
Reviewed-by: Vissarion Fisikopoulos <vfisikop@libreoffice.org>
Tested-by: Jenkins
2026-09-22 15:54:40 +02:00

76 lines
2.3 KiB
C++

/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#ifndef INCLUDED_SVX_SOURCE_INC_SQLPARSERCLIENT_HXX
#define INCLUDED_SVX_SOURCE_INC_SQLPARSERCLIENT_HXX
#include <config_options.h>
#include <svx/ParseContext.hxx>
#include <com/sun/star/uno/XComponentContext.hpp>
#include <memory>
namespace com::sun::star {
namespace util {
class XNumberFormatter;
}
namespace beans {
class XPropertySet;
}
namespace sdbc {
class XConnection;
}
}
namespace connectivity {
class OSQLParser;
class OSQLParseNode;
}
namespace svxform
{
//= OSQLParserClient
class UNLESS_MERGELIBS(SVXCORE_DLLPUBLIC) OSQLParserClient : public ::svxform::OParseContextClient
{
protected:
mutable std::shared_ptr< ::connectivity::OSQLParser > m_pParser;
OSQLParserClient(
const css::uno::Reference< css::uno::XComponentContext >& rxContext);
std::unique_ptr< ::connectivity::OSQLParseNode > predicateTree(
OUString& _rErrorMessage,
const OUString& _rStatement,
const css::uno::Reference< css::util::XNumberFormatter >& _rxFormatter,
const css::uno::Reference< css::beans::XPropertySet >& _rxField,
const css::uno::Reference< css::sdbc::XConnection >& _rxConnection
= css::uno::Reference< css::sdbc::XConnection >()
) const;
};
}
#endif // INCLUDED_SVX_SOURCE_INC_SQLPARSERCLIENT_HXX
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */