Skip to main content

to_sql

postgrest_parser

Function to_sql 

Source 
pub fn to_sql(table: &str, params: &ParsedParams) -> Result<QueryResult, Error>
Expand description

Converts parsed parameters into a parameterized PostgreSQL SELECT query.

§Arguments

  • table - The table name to query
  • params - Parsed parameters containing select, filters, order, limit, and offset

§Returns

Returns a QueryResult containing the SQL query string and parameter values.

§Examples

use postgrest_parser::{parse_query_string, to_sql};

let params = parse_query_string("age=gte.18&order=name.asc&limit=10").unwrap();
let result = to_sql("users", &params).unwrap();

assert!(result.query.contains("SELECT"));
assert!(result.query.contains("WHERE"));
assert!(result.query.contains("ORDER BY"));
assert!(result.query.contains("LIMIT"));