rbatis_plus_core/
wrapper.rs1use crate::conditions::query::QueryWrapper;
4use crate::conditions::join::Join;
5use crate::page::{Page, PageRequest};
6use rbatis::executor::Executor;
7use rbatis::Error;
8use serde::de::DeserializeOwned;
9use serde::Serialize;
10
11impl QueryWrapper {
17 pub async fn query<T: Serialize + DeserializeOwned>(
21 &self,
22 rb: &dyn Executor,
23 table_name: &str,
24 ) -> Result<Vec<T>, Error> {
25 let sql = self.build_select_sql(table_name);
26 let v = rb.query(&sql, vec![]).await?;
27 Ok(rbs::from_value(v)?)
28 }
29
30 pub async fn get_one<T: Serialize + DeserializeOwned>(
34 &self,
35 rb: &dyn Executor,
36 table_name: &str,
37 ) -> Result<Option<T>, Error> {
38 let mut clone = self.clone();
40 if clone.inner.sql_last.is_empty() {
41 clone.last("LIMIT 1");
42 }
43 let sql = clone.build_select_sql(table_name);
44 let v = rb.query(&sql, vec![]).await?;
45 let list: Vec<T> = rbs::from_value(v)?;
46 Ok(list.into_iter().next())
47 }
48
49 pub async fn page<T: Serialize + DeserializeOwned>(
53 &self,
54 rb: &dyn Executor,
55 table_name: &str,
56 page_no: u64,
57 page_size: u64,
58 ) -> Result<Page<T>, Error> {
59 let req = PageRequest::new(page_no, page_size);
60
61 let count_sql = self.build_count_sql(table_name);
63 let v = rb.query(&count_sql, vec![]).await?;
64 let total: u64 = rbs::from_value(v).unwrap_or(0);
65
66 if total == 0 {
67 return Ok(Page::empty(page_no, page_size));
68 }
69
70 let mut clone = self.clone();
72 clone.last(&format!("LIMIT {} OFFSET {}", req.page_size, req.offset()));
73 let sql = clone.build_select_sql(table_name);
74 let v = rb.query(&sql, vec![]).await?;
75 let records: Vec<T> = rbs::from_value(v)?;
76
77 Ok(Page::new(records, total, page_no, page_size))
78 }
79}