sqlink 0.3.0

sqlink

A simple query builder to use with low level library such as rust-postgres

Documentation

https://docs.rs/sqlink/0.2.0/sqlink/

For How it works

let mut sqlinsert = PostgresBuilder::insert();
let qbuiltinsert = sqlinsert
    .table("person")
    .returning("id")
    .into("id", person_form.id)
    .into("name", person_form.name)
    .into("data", person_form.data)
    .build().unwrap();
conn.execute(
    &qbuiltinsert.query,
    &qbuiltinsert.parameters,
)?;
let mut sqlupdate = PostgresBuilder::update();
let qbuiltinsert = sqlupdate
    .table("person")
    .set("name", "Real Hello World")
    .and_where(
        fmt_query!("person.id = {}", 3) // note that 3 has to be same type as person id, which is i32/INT here
    )
    .build().unwrap();
conn.execute(
    &qbuiltinsert.query,
    &qbuiltinsert.parameters,
)?;
let mut sqlselect = PostgresBuilder::select();
let qbuiltselect = sqlselect
    .select("id")
    .select(("name", "person_name"))
    .select("data")
    .table("person")
    .and_where(
        fmt_query!("person.id = {}", 3) // note that 3 has to be same type as person id, which is i32/INT here
    )
    .build().unwrap();
let mut person_vec: Vec<Person> = Vec::new();
for row in &conn.query(&qbuiltselect.query, &qbuiltselect.parameters).unwrap() {
    person_vec.push(Person {
        id: row.get(0),
        name: row.get(1),
        data: row.get(2),
    })
}
assert_eq!(person_vec, vec![Person {
    id: 3,
    name: "Real Hello World".to_owned(),
    data: None
}]);