[−][src]Crate sqlite3builder

Simple SQL code generator. May be used with pooled Sqlite3 connection.

Usage

To use sqlite3builder, first add this to your Cargo.toml:

[dependencies]
sqlite3builder = "0.3"

Next, add this to your crate:

extern crate sqlite3builder;

use sqlite3builder::Sqlite3Builder;

Example:

extern crate sqlite3builder;

use sqlite3builder::Sqlite3Builder;

let sql = Sqlite3Builder::select_from("company")
    .field("id")
    .field("name")
    .and_where("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

Sqlite3Builder

Main Sqlite3 builder

Functions

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