Skip to main content

to_sql

Function to_sql 

Source
pub fn to_sql(
    criteria: &Criteria,
    dialect: Dialect,
) -> Result<SqlQuery, SqlError>
Expand description

Translates criteria to a SQL expression for a WHERE or a SELECT list.

use ravenrs_criteria::{Criteria, Dialect, SqlParam, Value, to_sql};

let c = Criteria::parse("[Total] > 100 And [Name] Like ?Pattern").expect("valid");
let q = to_sql(&c, Dialect::Postgres).expect("translatable");
assert_eq!(q.text, r#""Total" > $1 AND "Name" LIKE $2"#);
assert_eq!(q.params, [SqlParam::Value(Value::Number(100.0)), SqlParam::Named("Pattern".into())]);