sqlx_macro_ex 0.2.0

Macros replace sqlx-macros without compiling time
Documentation
  • Coverage
  • 80%
    4 out of 5 items documented0 out of 0 items with examples
  • Size
  • Source code size: 4.06 kB This is the summed size of all the files inside the crates.io package for this release.
  • Documentation size: 181.18 kB This is the summed size of all files generated by rustdoc for all configured targets
  • Links
  • dryBranch/sqlx_macro_ex
    0 0 0
  • crates.io
  • Dependencies
  • Versions
  • Owners
  • dryBranch

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
}