#sqlite #sql #db

sqlite3builder

Simple SQL code generator for Sqlite3

8 releases

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

#2224 in Database interfaces

MIT license

90KB
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.1–7.5MB
~36K SLoC