Function render_sql_literal

nodedb-client/src/remote/sql.rs:136–147

Render a single `Value` as a SQL literal. Strings are single-quote escaped; numeric / boolean / null variants are formatted directly. Returns `Err` for variants the SQL literal layer cannot represent.

(v: &Value)

/// escaped; numeric / boolean / null variants are formatted directly.
/// Returns `Err` for variants the SQL literal layer cannot represent.
fn render_sql_literal(v: &Value) -> NodeDbResult<String> {
    match v {
        Value::Null => Ok("NULL".into()),
        Value::Bool(b) => Ok(if *b { "TRUE".into() } else { "FALSE".into() }),
        Value::Integer(i) => Ok(i.to_string()),
        Value::Float(f) => Ok(f.to_string()),
        Value::String(s) => Ok(quote_string_literal(s)),
        other => Err(NodeDbError::storage(format!(
            "metadata filter value cannot be rendered as a SQL literal: {other:?}"
        ))),
    }
}

/// Translate trait-level `&[Value]` parameters into owned, `ToSql`-
/// compatible boxes for `tokio_postgres`. Returns one boxed parameter