Crate query_builder

About

This crate is intended to be easy to use for creating SQL-Queries dynamically as you need it.

Usage

For creating a simple SELECT-Query you first need to add query_builder = "*" to your Cargo.toml file (you may of cource replace * with any version)
In your code write extern crate query_builder and use query_builder::* to import all structs and enums.
Finally creating the SelectQuery looks like this:

use query_builder::SelectQuery;

let query = SelectQuery::select(&["*"]).from("users");
// make sure the query looks like expected
assert_eq!(query.as_string(), "SELECT * FROM users");

Creating a [`InsertQuery`] works similar:

use query_builder::{InsertQuery, Value};

// create the basic query
let mut query = InsertQuery::into("users");
// add values to the query
query.values.insert("name", Value::Varchar("george"));

// make sure that the query looks like expected
assert_eq!(query.as_string(), "INSERT INTO users(name) VALUES('george')");

More detailed explanations and examples can be found at the corresponding sections to the structs and enums

Structs

• DeleteQuery
  Struct representing a SQL Delete Statement
• InsertQuery
  Struct representing an SQL Insert Statement
• SelectQuery
  Struct representing a SQL-INSERT Query A simple query to select everything from a table can be created like this:
• UpdateQuery
  Struct representing an SQL Update statement
• WhereClause
  Struct representing an WHERE-Clause

Enums

• Condition
  Enum representing the ways to combine conditional parts of a query
• OrderBy
  Representing the way to format the ORDER BY clause of some queries
• Value
  Enum representing common SQL-datatypes