sql-builder
Simple SQL code generator.
Usage
To use sql-builder
, add this to your Cargo.toml
:
[]
= "3.1"
Examples:
SELECT
use SqlBuilder;
let sql = select_from
.field
.field
.and_where_gt
.sql?;
assert_eq!;
use *;
let sql = select_from
.fields
.and_where
.and_where
.sql?;
assert_eq!;
INSERT
use ;
let sql = insert_into
.field
.field
.field
.values
.values
.sql?;
assert_eq!;
use *;
let sql = insert_into
.field
.field
.field
.values
.values
.sql?
.bind_nums
.binds;
assert_eq!;
UPDATE
use SqlBuilder;
let sql = update_table
.set
.and_where_lt
.sql?;
assert_eq!;
use *;
let sql = update_table
.set
.set
.and_where
.sql?
.bind_nums;
assert_eq!;
DELETE
use SqlBuilder;
let sql = delete_from
.or_where_lt
.or_where_gt
.sql?;
assert_eq!;
use *;
use HashMap;
let mut names: = new;
names.insert;
names.insert;
let sql = delete_from
.and_where
.and_where
.sql?
.bind_names;
assert_eq!;
See more examples
SQL support
Statements
- SELECT
- INSERT
- UPDATE
- DELETE
Operations
- join
- distinct
- group by
- order by
- where
- union
- limit, offset
- subquery
Functions
- escape
- quote, double quote, back quote, brackets quote
- bind, binds, bind_num, bind_nums, bind_name, bind_names
Macroes
- name, qname, baname, brname, dname
License
This project is licensed under the MIT license.