Struct QueryWrapper 

pub struct QueryWrapper { /* private fields */ }

like mybatis plus for example:

let count = QueryWrapper::new()
    .custom_sql("select count(*) from member")
    .get_one::<u64>(&RB, "")
    .await?;
println!("count: {:?}", count);
#[derive(serde::Deserialize, serde::Serialize, Debug)]
struct Member {
    id: u64,
    email: Option<String>
}
let member = QueryWrapper::new()
    .eq("id", 7386)
    .get_one::<Member>(&RB, "member")
    .await?;
println!("member: {:?}", member);
Ok(Json(json!({
    "code": 0,
    "data": member,
    "count": count,
})))

Implementations

impl QueryWrapper

pub fn new() -> Self

pub fn eq<T: ToString>(self, column: &str, value: T) -> Self

pub fn ne<T: ToString>(self, column: &str, value: T) -> Self

pub fn gt<T: ToString>(self, column: &str, value: T) -> Self

pub fn lt<T: ToString>(self, column: &str, value: T) -> Self

pub fn like(self, column: &str, value: &str) -> Self

pub fn select(self, columns: Vec<&str>) -> Self

pub fn order_by(self, column: &str, asc: bool) -> Self

pub fn limit(&mut self, limit: u64) -> &mut Self

pub fn offset(&mut self, offset: u64) -> &mut Self

pub fn custom_sql(self, sql: &str) -> Self

pub fn inner_join(self, table: &str, on_condition: &str) -> Self

pub fn left_join(self, table: &str, on_condition: &str) -> Self

pub fn right_join(self, table: &str, on_condition: &str) -> Self

pub fn build_sql(&self, table_name: &str) -> String

pub async fn query<T>( &self, rb: &RBatis, table_name: &str, ) -> Result<Vec<T>, Error>

where T: Serialize + for<'de> Deserialize<'de>,

pub async fn get_one<T>( &self, rb: &RBatis, table_name: &str, ) -> Result<Option<T>, Error>

where T: Serialize + for<'de> Deserialize<'de>,

pub async fn delete(self, rb: &RBatis, table_name: &str) -> Result<u64, Error>

pub async fn page<T>( &self, rb: &RBatis, table_name: &str, page_no: u64, page_size: u64, ) -> Result<Page<T>, Error>

where T: Serialize + for<'de> Deserialize<'de>,

Trait Implementations

impl Clone for QueryWrapper

fn clone(&self) -> QueryWrapper

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for QueryWrapper

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for QueryWrapper

fn default() -> QueryWrapper

Returns the “default value” for a type.