elastic / elasticsearch-rs

Official Elasticsearch Rust Client
https://www.elastic.co/guide/en/elasticsearch/client/rust-api/current/index.html
Apache License 2.0
705 stars 72 forks source link

[ENHANCEMENT] Passing parameters to query #196

Open Jasperav opened 2 years ago

Jasperav commented 2 years ago

As stated here: https://www.elastic.co/guide/en/elasticsearch/reference/master/sql-rest-params.html

russcam commented 2 years ago

Hey @Jasperav, it's already possible to do this

let client = Elasticsearch::default();
let response = client.sql()
    .query()
    .body(json!({
        "query": "SELECT YEAR(release_date) AS year FROM library WHERE page_count > ? AND author = ? GROUP BY year HAVING COUNT(*) > ?",
        "params": [300, "Frank Herbert", 0]
    }))
    .format("txt")
    .send()
    .await?;

let text = response.text().await?;