Creates a new empty SqlQuery This equals a sql query like SELECT * FROM *;

Example

let query = exo::SqlQuery::new();
assert!(query is exo::SqlQuery);

Return the SqlQuery as sql string.

Example

let query = exo::SqlQuery::new();
assert_eq!(query.to_string(), "SELECT * FROM *;");

This function tries to parse the SqlQuery from a string.

Example

let query = exo::SqlQuery::parse_str("SELECT * FROM *;")?;
assert_eq!(query,exo::SqlQuery::new());

Clones the SqlQuery and returns a new independet one.

Set one or multiple models to the SqlQuery. This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new().model("user").model("right");
assert_eq!(query.to_string(), "SELECT * FROM user, right;");

Set the limit of the SqlQuery. This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new().limit(10);
assert_eq!(query.to_string(), "SELECT * FROM * LIMIT 10;");

Set the offset of the SqlQuery. This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new().offset(10);
assert_eq!(query.to_string(), "SELECT * FROM * OFFSET 10;");

Set an additonal check/where condition This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new().check("ident", "==", "test");
assert_eq!(query.to_string(), "SELECT * FROM * WHERE ident = \"test\";");

Set a full text search query for the given language This functions consumes the SqlQuery and returns it updated. Also sets sort_by to none and sort_oder to desc.

Example

let query = exo::SqlQuery::new().search("Right");

Set a specific column for the SqlQuery This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new().column("uuid");
assert_eq!(query.to_string(), "SELECT uuid FROM *;");

Set a specific aggregate column for the SqlQuery This functions consumes the SqlQuery and returns it updated. Aggregates can not be combined with normal columns.

Example

let query = exo::SqlQuery::new().aggregate("uuid", "count");
assert_eq!(query.to_string(), "SELECT COUNT(uuid) FROM *;");

Set a specific aggregate column with parameter for the SqlQuery This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new().aggregate_with_param("currency_col", "sum_currency_only", "CHF");
assert_eq!(query.to_string(), "SELECT SUM_CURRENCY_ONLY(currency_col, \"CHF\") FROM *;");

Add an AND condition to the query This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new().and("name", "=", "John").and("age", ">", 18);
assert_eq!(query.to_string(), "SELECT * FROM * WHERE name = \"John\" AND age > \"18\";");

Add an OR condition to the query This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new().and("status", "=", "active").or("priority", "=", "high");
assert_eq!(query.to_string(), "SELECT * FROM * WHERE status = \"active\" OR priority = \"high\";");

Add a grouped set of conditions with AND chaining to the query This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new()
   .and_group(|q| q.and("a", "=", 1).and("b", "=", 2))
   .or("c", "=", 3);
// Produces: WHERE (a = "1" AND b = "2") OR c = "3"

Add a grouped set of conditions with OR chaining to the query This functions consumes the SqlQuery and returns it updated.

Example

let query = exo::SqlQuery::new()
   .and("status", "=", "active")
   .or_group(|q| q.and("priority", "=", "high").or("urgent", "=", true));
// Produces: WHERE status = "active" OR (priority = "high" OR urgent = "true")

Define the column by which the values should be sorted

Define the sort oder (desc / asc)

Allows a get operation to work.

Allows a set operation to work.

Allows a get operation to work.

Allows a set operation to work.

Allows a get operation to work.

Allows a set operation to work.

Allows a get operation to work.

Allows a set operation to work.

Allows a get operation to work.

Allows a set operation to work.

Allows a get operation to work.

Allows a set operation to work.

Allows for partial equality operations to work.

Allows the value to be debug printed.

Allows the value to be display printed.