Skip to main content

Crate sqlite3builder

Crate sqlite3builder 

Source
Expand description

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.