Macro dysql::fetch_all

source ·
fetch_all!() { /* proc-macro */ }
Expand description

fetch all datas that filtered by dto

§Examples

Basic usage:

let mut conn = connect_db().await;
 
let dto = UserDto {id: None, name: None, age: 13};
let rst = fetch_all!(|&conn, dto| -> User {
    r#"select * from test_user 
    where 1 = 1
        {{#name}}and name = :name{{/name}}
        {{#age}}and age > :age{{/age}}
    order by id"#
}).unwrap();
 
assert_eq!(
    vec![
        User { id: 2, name: Some("zhanglan".to_owned()), age: Some(21) }, 
        User { id: 3, name: Some("zhangsan".to_owned()), age: Some(35) },
    ], 
    rst
);