8 releases

✓ Uses Rust 2018 edition

0.3.0 Feb 18, 2020
0.2.0 Feb 14, 2020
0.1.5 Feb 12, 2020

#216 in Database interfaces

34 downloads per month

MIT license

89KB
876 lines

sqlite3builder

Build Status Latest Version Docs

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 sql_builder;

use sql_builder::SqlBuilder;

Example:

let sql = SqlBuilder::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.

Dependencies

~1.5MB
~31K SLoC