VSQLite++
0.3
Toggle main menu visibility
Loading...
Searching...
No Matches
include
sqlite
json_fts.hpp
Go to the documentation of this file.
1
/*##############################################################################
2
VSQLite++ - virtuosic bytes SQLite3 C++ wrapper
3
4
Copyright (c) 2006-2024 Vinzenz Feenstra
5
and contributors
6
All rights reserved.
7
8
Redistribution and use in source and binary forms, with or without modification,
9
are permitted provided that the following conditions are met:
10
11
* Redistributions of source code must retain the above copyright notice,
12
this list of conditions and the following disclaimer.
13
* Redistributions in binary forms must reproduce the above copyright notice,
14
this list of conditions and the following disclaimer in the documentation
15
and/or other materials provided with the distribution.
16
* Neither the name of virtuosic bytes nor the names of its contributors may
17
be used to endorse or promote products derived from this software without
18
specific prior written permission.
19
20
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
21
AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
22
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
23
ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
24
LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
25
CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
26
SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
27
INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
28
CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
29
ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
30
POSSIBILITY OF SUCH DAMAGE.
31
32
##############################################################################*/
33
#ifndef GUARD_SQLITE_JSON_FTS_HPP_INCLUDED
34
#define GUARD_SQLITE_JSON_FTS_HPP_INCLUDED
35
36
#include <string>
37
#include <string_view>
38
46
namespace
sqlite
{
47
inline
namespace
v2
{
48
struct
connection
;
49
50
namespace
json
{
58
class
path_builder
{
59
public
:
61
path_builder
();
62
71
path_builder
&
key
(std::string_view segment);
72
79
path_builder
&
index
(std::size_t idx);
80
82
std::string
const
&
str
() const noexcept {
83
return
path_
;
84
}
85
86
private
:
87
std::string
path_
;
88
};
89
91
inline
path_builder
path
() {
92
return
path_builder
();
93
}
94
102
std::string
extract_expression
(std::string_view json_expr,
path_builder
const
&
path
);
103
111
std::string
contains_expression
(std::string_view json_expr,
path_builder
const
&
path
,
112
std::string_view value_expr);
113
119
bool
available
(
connection
&con);
120
129
void
register_contains_function
(
connection
&con,
130
std::string_view function_name =
"json_contains_value"
);
131
}
// namespace json
132
133
namespace
fts
{
139
bool
available
(
connection
&con);
140
149
std::string
match_expression
(std::string_view column_or_table,
150
std::string_view query_expr =
"?"
);
151
163
void
register_rank_function
(
connection
&con, std::string_view function_name =
"fts_rank"
);
164
}
// namespace fts
165
}
// namespace v2
166
}
// namespace sqlite
167
168
#endif
// GUARD_SQLITE_JSON_FTS_HPP_INCLUDED
sqlite::v2::json::path_builder
Helper for composing JSON path expressions compatible with SQLite's JSON1 dialect.
Definition
json_fts.hpp:58
sqlite::v2::json::path_builder::path_
std::string path_
Definition
json_fts.hpp:87
sqlite::v2::json::path_builder::key
path_builder & key(std::string_view segment)
Appends an object key to the path.
sqlite::v2::json::path_builder::index
path_builder & index(std::size_t idx)
Appends an array index access to the path.
sqlite::v2::json::path_builder::str
std::string const & str() const noexcept
Returns the current JSON path representation (e.g. $.user.name).
Definition
json_fts.hpp:82
sqlite::v2::json::path_builder::path_builder
path_builder()
Constructs a builder positioned at the JSON root ($).
sqlite::fts
Definition
json_fts.hpp:133
sqlite::v2::fts::match_expression
std::string match_expression(std::string_view column_or_table, std::string_view query_expr="?")
Builds a SQL MATCH expression for FTS tables or columns.
sqlite::v2::fts::available
bool available(connection &con)
Detects whether the connected SQLite build exposes the FTS5 extension.
sqlite::v2::fts::register_rank_function
void register_rank_function(connection &con, std::string_view function_name="fts_rank")
Registers a custom ranking function compatible with fts5 queries.
sqlite::json
Definition
json_fts.hpp:50
sqlite::v2::json::extract_expression
std::string extract_expression(std::string_view json_expr, path_builder const &path)
Produces a SQL expression that extracts a JSON value at the given path.
sqlite::v2::json::path
path_builder path()
Convenience shortcut for starting a new JSON path builder rooted at $.
Definition
json_fts.hpp:91
sqlite::v2::json::register_contains_function
void register_contains_function(connection &con, std::string_view function_name="json_contains_value")
Registers a deterministic SQL scalar function that checks for JSON containment.
sqlite::v2::json::contains_expression
std::string contains_expression(std::string_view json_expr, path_builder const &path, std::string_view value_expr)
Produces a SQL expression that compares a JSON value at path with value_expr.
sqlite::v2::json::available
bool available(connection &con)
Detects whether the connected SQLite build exposes the JSON1 extension.
sqlite::v2
Definition
backup.hpp:18
sqlite
Definition
backup.hpp:17
sqlite::v2::connection
connection is used to open, close, attach and detach a database. Further it has to be passed to all c...
Definition
connection.hpp:64
Generated by
1.17.0