Macro rbatis::htmlsql_select_page
source · macro_rules! htmlsql_select_page { ($fn_name:ident($($param_key:ident:$param_type:ty$(,)?)*) -> $table:ty => $html_file:expr) => { ... }; }
Expand description
impl html_sql select page.
you must deal with 3 param: (do_count:bool,page_no:u64,page_size:u64)
you must deal with sql:
return Vec
you can see ${page_no} = (page_no -1) * page_size; you can see ${page_size} = page_size;
just like this example:
<select id="select_page_data">
`select `
<if test="do_count == true">
`count(1) from table`
</if>
<if test="do_count == false">
`* from table limit ${page_no},${page_size}`
</if>
</select>
#[derive(serde::Serialize, serde::Deserialize)]
pub struct MockTable{}
//rbatis::htmlsql_select_page!(select_page_data(name: &str) -> MockTable => "example.html");
rbatis::htmlsql_select_page!(select_page_data(name: &str) -> MockTable => r#"
<select id="select_page_data">
`select `
<if test="do_count == true">
`count(1) from table`
</if>
<if test="do_count == false">
`* from table limit ${page_no},${page_size}`
</if>
</select>"#);