#mapper #postgresql #tokio

macro tokio-pg-mapper-derive

Proc-macro library used to map a tokio-postgres row to a Rust type (struct)

4 releases

0.2.0 Jan 4, 2021
0.1.6 Dec 30, 2020
0.1.5 Mar 2, 2020
0.1.4 Jan 11, 2020
0.1.0 Jan 10, 2020

#31 in #mapper

Download history 948/week @ 2024-03-26 1361/week @ 2024-04-02 976/week @ 2024-04-09 1269/week @ 2024-04-16 1138/week @ 2024-04-23 1102/week @ 2024-04-30 1034/week @ 2024-05-07 929/week @ 2024-05-14 879/week @ 2024-05-21 974/week @ 2024-05-28 1004/week @ 2024-06-04 913/week @ 2024-06-11 830/week @ 2024-06-18 1021/week @ 2024-06-25 535/week @ 2024-07-02 794/week @ 2024-07-09

3,379 downloads per month
Used in 6 crates (5 directly)

ISC license

8KB
159 lines

tokio-pg-mapper

tokio_postgres-mapper is a proc-macro designed to make mapping from postgresql tables to structs simple.

Why?

It can be frustrating to write a lot of boilerplate and, ultimately, duplicated code for mapping from postgres Rows into structs.

For example, this might be what someone would normally write:

extern crate postgres;

use postgres::rows::Row;

pub struct User {
    pub id: i64,
    pub name: String,
    pub email: Option<String>,
}

impl From<Row> for User {
    fn from(row: Row) -> Self {
        Self {
            id: row.get("id"),
            name: row.get("name"),
            email: row.get("email"),
        }
    }
}

// code to execute a query here and get back a row
let user = User::from(row); // this can panic

This becomes worse when manually implementating using the non-panicking get_opt method variant.

Using this crate, the boilerplate is removed, and panicking and non-panicking implementations are derived:

extern crate tokio_pg_mapper_derive;
extern crate tokio_pg_mapper;

use tokio_pg_mapper::FromTokioPostgresRow;
use tokio_pg_mapper_derive::PostgresMapper;

#[derive(PostgresMapper)]
pub struct User {
    pub id: i64,
    pub name: String,
    pub email: Option<String>,
}

// Code to execute a query here and get back a row might now look like:
let stmt = "SELECT * FROM user WHERE username = $1 AND password = $2";

let result = client.query_one(stmt, &[&5, "asdf"]).await?;
let user = User::from_row(result).unwrap(); // or from_row_ref(&result)


The two crates

This repository contains two crates: postgres-mapper which contains an Error enum and traits for converting from a tokio-postgres Row without panicking, and postgres-mapper-derive which contains the proc-macro.

Installation

Install tokio-pg-mapper-derive and tokio-pg-mapper from crates.io

License

ISC.

Dependencies

~8–18MB
~252K SLoC