Postgres Query Builder for Rust

• for usage with postgres crate

For How it works

~~~rs extern crate postgres; use postgres::{Connection, TlsMode, Error as PostgresError}; use sqlink::postgres::{SqlInsert, SqlSelect}; use sqlinkderive::{postgresfmt};

[derive(Debug, PartialEq)]

struct Person { id: i32, name: String, data: Option> }

struct PersonForm { id: i32, name: String, data: Option> }

[test]

fn testpostgresdb() -> Result<(), PostgresError> { let conn = Connection::connect("postgresql://pguser:password@localhost:54321/sqlink_postgres", TlsMode::None) .unwrap(); conn.execute("DROP TABLE IF EXISTS person", &[]).unwrap(); conn.execute("CREATE TABLE person ( id INT PRIMARY KEY, name VARCHAR(255) NOT NULL, data Bytea )", &[]).unwrap();

let person_form = PersonForm {
    id: 3,
    name: "Hello World".to_owned(),
    data: None
};
let mut sqlinsert = SqlInsert::new();
let qbuild = sqlinsert
    .table("person")
    .into(("id", person_form.id))
    .into(("name", person_form.name))
    .into(("data", person_form.data))
    .build().unwrap();
conn.execute(
    &qbuild.query,
    &qbuild.parameters,
)?;
let mut sqlselect = SqlSelect::new();
let qbuild2 = sqlselect
    .select("id")
    .select(("name", "person_name"))
    .select("data")
    .table("person")
    .and_where(
        postgres_fmt!("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(&qbuild2.query, &qbuild2.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: "Hello World".to_owned(),
    data: None
}]);
Ok(())

}

~~~

Limitation

Current queryfmt macro does not intelligently notify error like how format! macro do