sqlm-postgres 0.1.0

`sql!` macro to write compile-time checked database queries similar to how `format!` works
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

use sqlm_postgres::sql;

#[tokio::test]
async fn test_option_param_i64() {
    let id: i64 = sql!("SELECT id FROM users WHERE id = {id}", id = Some(1i64))
        .await
        .unwrap();
    assert_eq!(id, 1);
}

#[tokio::test]
async fn test_option_param_string() {
    let id = Some("first".to_string());
    let id: i64 = sql!("SELECT id FROM users WHERE name = {id}")
        .await
        .unwrap();
    assert_eq!(id, 1);
}

#[tokio::test]
async fn test_param_str() {
    let id: i64 = sql!("SELECT id FROM users WHERE name = {id}", id = "first")
        .await
        .unwrap();
    assert_eq!(id, 1);
}

#[tokio::test]
async fn test_option_param_str() {
    let id: i64 = sql!("SELECT id FROM users WHERE name = {id}", id = Some("first"))
        .await
        .unwrap();
    assert_eq!(id, 1);
}