Function where_sql_expr

nodedb-sql/src/resolver/expr/tests.rs:218–228

Extract and convert the WHERE predicate from a simple `SELECT * FROM tbl WHERE ` statement.

(sql: &str)

/// Extract and convert the WHERE predicate from a simple
/// `SELECT * FROM tbl WHERE <expr>` statement.
fn where_sql_expr(sql: &str) -> SqlExpr {
    let stmts = parse_sql(sql).expect("parse failed");
    let Statement::Query(q) = &stmts[0] else {
        panic!("expected query");
    };
    let sqlparser::ast::SetExpr::Select(sel) = q.body.as_ref() else {
        panic!("expected select body");
    };
    let raw = sel.selection.as_ref().expect("expected WHERE clause");
    convert_expr(raw).expect("convert_expr failed")
}

#[test]
fn like_is_case_sensitive() {