Crate sql_builder

Simple SQL code generator.

Usage

To use sql-builder, first add this to your Cargo.toml:

[dependencies]
sql-builder = "0.9"

Next, add this to your crate:

extern crate sql_builder;

use sql_builder::SqlBuilder;

Examples:

extern crate sql_builder;

use sql_builder::SqlBuilder;

let sql = SqlBuilder::select_from("company")
    .field("id")
    .field("name")
    .and_where_gt("salary", 25000)
    .sql()?;

assert_eq!("SELECT id, name FROM company WHERE salary > 25000;", &sql);

SQL support

Statements

• SELECT
• INSERT
• UPDATE
• DELETE

Operations

• join
• distinct
• group by
• order by
• where
• limit, offset
• subquery
• get all results
• get first row
• get first value, first integer value, first string value

Functions

• escape
• query

License

This project is licensed under the MIT license.

Structs

SqlBuilder

Main SQL builder

Functions

esc	Escape string for SQL.
quote	Quote string for SQL.