#sqlx #macro #sql-query #replace #compiling #db #sqlx-macros

sqlx_macro_ex

Macros replace sqlx-macros without compiling time

2 unstable releases

0.2.0 Aug 18, 2024
0.1.0 Aug 29, 2023

#2022 in Database interfaces

Download history 118/week @ 2024-08-17 24/week @ 2024-08-24 2/week @ 2024-08-31 10/week @ 2024-09-14 8/week @ 2024-09-21 32/week @ 2024-09-28 3/week @ 2024-10-05 1/week @ 2024-10-12

61 downloads per month

MIT license

4KB

Sql Macro Ex

Just for no compling time check.

Example


#[derive(Debug, FromRow)]
struct User {
    uid: i32,
    name: String,
}

async fn insert_user(db: &DB, user: &User) -> sqlx::Result<()> {
    sqlx_macro_ex::query!(
        r#"
        insert into user(uid, name)
        values(?, ?)
        "#,
        &user.uid,
        &user.name,
    ).execute(mdb).await?;
    Ok(())
}

async fn get_user_with_uid(db: &DB, uid: i32) -> sqlx::Result<User> {
    sqlx_macro_ex::query_as!(
        User,
        r#"
        select * from user
        where uid = ?
        "#,
        uid
    ).fetch_one(db).await
}

async fn get_user_names__in_range(db: &DB, uid: i32) -> sqlx::Result<Vec<String>> {
    sqlx_macro_ex::query_scalar!(
        String,
        r#"
        select name from user
        where uid < ?
        "#,
        uid
    ).fetch_all(db).await
}

No runtime deps