pgde 0.2.1

A simple library for consuming tokio_postgres::row::Row data into structs that derive the RowConsumer trait.

Most of the complex PostgreSQL types are not supported, namely arrays. Consequently Vec types on structs are not currently supported.

Features

Examples

consume

You may use consume to consume PostgreSQL row data into a struct like so.

#[derive(RowConsumer)]
struct Foo {
    Id: i32,
    Data: String,
}

...

let query = "select * from public.\"Foo\";";

match Foo::consume(&conn, query, &[]).await {
    Ok(v) => ..., // v is of type Vec<Foo>
    Err(v) => ...,
};

This crate implements from_row on the following types so that consume can be used in a similar fashion.

let query = "select Id from public.\"Foo\";";

match i32::consume(&conn, query, &[]).await {
    Ok(v) => ..., // v is of type Vec<i32>
    Err(v) => ...,
};

Features

The json and uuid features provide consume on serde_json::Value and uuid::Uuid for json and uuid data types in PostgreSQL.

With the consume_json feature you get access to consume_json, which returns json data in a String.

#[derive(Serialize, RowConsumer)]
struct Foo { ... }

...

match Foo::consume_json(&conn, query, &[]).await {
    Ok(v) => ..., // v is of type String
    Err(v) => ...,
};

Testing

Testing requires access to a PostgreSQL database with no tables. Setting the following environment variables will allow you to test.

To test, you would then run.

cargo test --tests --all-features