Crate rawsql

rawsql is a rust library for abstract the sql code in one place and reuse it.

Given a sql file stored for example in “examples/postgre.sql”:

-- name: drop-table-person
DROP TABLE IF EXISTS "person";

-- name: create-table-person
CREATE TABLE "person" (id SERIAL PRIMARY KEY, name  VARCHAR NOT NULL, data BYTEA);

-- name: insert-person
INSERT INTO "person" (name, data) VALUES ($1, $2);

-- name: select-all
SELECT id, name, data FROM person;

Use this lib for get each query associated to the “name” declared on the previous sql file:

extern crate rawsql;
extern crate postgres;

use rawsql::Loader;
use postgres::{Connection, SslMode};

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

fn main() {
    let conn = Connection::connect("postgres://postgres:local@localhost", &SslMode::None).unwrap();

    let queries = Loader::read_queries_from("examples/postgre.sql").unwrap().queries;

    //Drop table
    conn.execute(queries.get("drop-table-person").unwrap(), &[]).unwrap();

    //Create table
    conn.execute(queries.get("create-table-person").unwrap(), &[]).unwrap();

    let me = Person {
        id: 0,
        name: "Manuel".to_string(),
        data: None
    };

    //Insert into table
    conn.execute(queries.get("insert-person").unwrap(),
                 &[&me.name, &me.data]).unwrap();

    //Select
    let stmt = conn.prepare(queries.get("select-all").unwrap()).unwrap();
    for row in stmt.query(&[]).unwrap() {
        let person = Person {
            id: row.get(0),
            name: row.get(1),
            data: row.get(2)
        };
        println!("Found person id : {}, name: {}", person.id, person.name);
    }
}

Structs

Loader

All queries info Queries as key(name) and value(query)