vantage-sql 0.6.28

Vantage extension for SQL databases (Postgres, MySQL, SQLite)
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

pub mod condition;
pub mod prelude;
pub mod primitives;

// Re-export so that macros (sqlite_expr!, sql_expr!, etc.) resolve
// without downstream crates needing a direct vantage-expressions dependency.
pub use vantage_expressions;
pub(crate) mod types;

#[cfg(any(feature = "sqlite", feature = "postgres", feature = "mysql"))]
mod sql_exec;
#[cfg(all(
    feature = "vista",
    any(feature = "sqlite", feature = "postgres", feature = "mysql")
))]
mod sql_vista;
#[cfg(any(feature = "sqlite", feature = "postgres", feature = "mysql"))]
mod table_writes;

#[cfg(feature = "sqlite")]
pub mod sqlite;

#[cfg(feature = "postgres")]
pub mod postgres;

#[cfg(feature = "mysql")]
pub mod mysql;

#[cfg(feature = "rhai")]
pub mod rhai_engine;

/// The `LIKE` operand for a substring match: `%text%` with the wildcards and
/// the escape itself escaped, so a `_` or `%` in what the user typed matches
/// itself. Shared by quicksearch and by the vista `FilterOp::Like`, which is
/// what keeps the two spelling the same pattern.
pub(crate) fn like_pattern_str(text: &str) -> String {
    let escaped = text
        .replace('$', "$$")
        .replace('%', "$%")
        .replace('_', "$_");
    format!("%{escaped}%")
}

/// [`like_pattern_str`] over a filter operand, which may be any scalar.
#[cfg(feature = "vista")]
pub(crate) fn like_pattern(value: &ciborium::Value) -> String {
    like_pattern_str(&vantage_vista::operand_text(value))
}