[−][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. |