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