VSQLite++ 0.3
Loading...
Searching...
No Matches
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
46namespace sqlite {
47inline namespace v2 {
48 struct connection;
49
50 namespace json {
59 public:
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
120
130 std::string_view function_name = "json_contains_value");
131 } // namespace json
132
133 namespace fts {
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
Helper for composing JSON path expressions compatible with SQLite's JSON1 dialect.
Definition json_fts.hpp:58
path_builder & key(std::string_view segment)
Appends an object key to the path.
path_builder & index(std::size_t idx)
Appends an array index access to the path.
std::string const & str() const noexcept
Returns the current JSON path representation (e.g. $.user.name).
Definition json_fts.hpp:82
path_builder()
Constructs a builder positioned at the JSON root ($).
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.
bool available(connection &con)
Detects whether the connected SQLite build exposes the FTS5 extension.
void register_rank_function(connection &con, std::string_view function_name="fts_rank")
Registers a custom ranking function compatible with fts5 queries.
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.
path_builder path()
Convenience shortcut for starting a new JSON path builder rooted at $.
Definition json_fts.hpp:91
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.
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.
bool available(connection &con)
Detects whether the connected SQLite build exposes the JSON1 extension.
connection is used to open, close, attach and detach a database. Further it has to be passed to all c...