sql-macros-derive 0.5.0

Auto generate sql queries for CRUD on sqlx
Documentation
use quote::quote;

use crate::model::{self, TableModel};

pub fn expand(model: &TableModel) -> darling::Result<proc_macro2::TokenStream> {
    let struct_name = &model.struct_name;
    let table_name = &model.table_name;
    let sql_columns = model.sql_columns();
    let query = format!("SELECT {sql_columns}\nFROM {table_name}");
    let doc = model::sql_doc(&query);

    Ok(quote! {
        impl #struct_name {
            #[doc = #doc]
            pub async fn select_all<'e, E>(executor: E) -> Result<Vec<#struct_name>, sqlx::Error>
            where
                E: sqlx::PgExecutor<'e>,
            {
                let object = sqlx::query_as!(#struct_name, #query)
                    .fetch_all(executor)
                    .await?;
                Ok(object)
            }
        }
    })
}