sqlc-gen-sqlx 0.2.3

A sqlc plugin that generates type-safe sqlx Rust code from SQL queries.
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83

---
source: tests/codegen.rs
expression: code
---
// Code generated by sqlc-gen-sqlx v[VERSION]. DO NOT EDIT.
// sqlc version: [VERSION]

#![allow(
    dead_code,
    reason = "generated queries may expose items a caller does not use"
)]

pub trait AsExecutor {
    fn as_executor(&mut self) -> impl sqlx::Executor<'_, Database = sqlx::Postgres>;
}
impl AsExecutor for sqlx::PgPool {
    fn as_executor(&mut self) -> impl sqlx::Executor<'_, Database = sqlx::Postgres> {
        &*self
    }
}
impl AsExecutor for &sqlx::PgPool {
    fn as_executor(&mut self) -> impl sqlx::Executor<'_, Database = sqlx::Postgres> {
        *self
    }
}
impl AsExecutor for sqlx::PgConnection {
    fn as_executor(&mut self) -> impl sqlx::Executor<'_, Database = sqlx::Postgres> {
        &mut *self
    }
}
impl AsExecutor for sqlx::Transaction<'_, sqlx::Postgres> {
    fn as_executor(&mut self) -> impl sqlx::Executor<'_, Database = sqlx::Postgres> {
        &mut **self
    }
}
impl AsExecutor for sqlx::pool::PoolConnection<sqlx::Postgres> {
    fn as_executor(&mut self) -> impl sqlx::Executor<'_, Database = sqlx::Postgres> {
        &mut **self
    }
}
impl<T: AsExecutor + ?Sized> AsExecutor for &mut T {
    fn as_executor(&mut self) -> impl sqlx::Executor<'_, Database = sqlx::Postgres> {
        (**self).as_executor()
    }
}
pub const LIST_AUTHORS_BY_DYNAMIC_IDS: &str = "SELECT id, name, bio FROM authors WHERE id IN ($1)";
#[derive(Debug, Clone, sqlx::FromRow)]
pub struct ListAuthorsByDynamicIdsRow {
    pub id: i64,
    pub name: String,
    pub bio: Option<String>,
}
pub async fn list_authors_by_dynamic_ids<E: AsExecutor>(
    mut db: E,
    ids: Vec<i64>,
) -> Result<Vec<ListAuthorsByDynamicIdsRow>, sqlx::Error> {
    let mut sql = LIST_AUTHORS_BY_DYNAMIC_IDS.to_string();
    let next_placeholder = 1usize;
    let placeholder_1 = next_placeholder;
    let slice_len = (ids).len();
    let replacement = if slice_len == 0 {
        "NULL".to_string()
    } else {
        (placeholder_1..(placeholder_1 + slice_len))
            .map(|n| format!("${}", n))
            .collect::<Vec<_>>()
            .join(", ")
    };
    if sql.contains("/*SLICE:ids*/?") {
        sql = sql.replace("/*SLICE:ids*/?", &replacement);
    } else {
        if sql.contains("/*SLICE:ids*/$1") {
            sql = sql.replace("/*SLICE:ids*/$1", &replacement);
        } else {
            sql = sql.replace("$1", &replacement);
        }
    }
    let mut query = sqlx::query_as::<_, ListAuthorsByDynamicIdsRow>(&sql);
    for value in ids {
        query = query.bind(value);
    }
    query.fetch_all(db.as_executor()).await
}