Struct rbatis::wrapper::Wrapper

pub struct Wrapper {
    pub driver_type: DriverType,
    pub sql: String,
    pub args: Vec<Value>,
    pub error: Option<Error>,
    pub checked: bool,
}

you can serialize to JSON, and Clone, Debug use json rpc send this Wrapper to server

for Example: let w = Wrapper::new(&DriverType::Mysql) .eq("id", 1) .and() .ne("id", 1) .and() .in_array("id", &[1, 2, 3]) .in_("id", &[1, 2, 3]) .r#in("id", &[1, 2, 3]) .and() .not_in("id", &[1, 2, 3]) .and() .like("name", 1) .or() .not_like("name", "asdf") .and() .between("create_time", "2020-01-01 00:00:00", "2020-12-12 00:00:00") .group_by(&["id"]) .order_by(true, &["id", "name"]) .check().unwrap();

Fields

driver_type: DriverType

sql: String

args: Vec<Value>

error: Option<Error>

checked: bool

Implementations

impl Wrapper

pub fn new(driver_type: &DriverType) -> Self

pub fn from(driver_type: &DriverType, sql: &str, args: &Vec<Value>) -> Self

pub fn check(&mut self) -> Result<Wrapper, Error>

pub fn push_wrapper(&mut self, arg: &Wrapper) -> &mut Self

link left Wrapper to this Wrapper for Example: let w = Wrapper::new(&DriverType::Postgres).push_sql("(").eq("a", "1").push_sql(")").check().unwrap(); let w2 = Wrapper::new(&DriverType::Postgres).eq("b", "2") .and() .push_wrapper(&w) .check().unwrap(); println!("sql:{:?}", w2.sql.as_str()); // sql:"b = ? AND (a = ?)" println!("arg:{:?}", w2.args.clone()); // arg:[String("2"), String("1")]

pub fn push<T>(&mut self, sql: &str, args: &[T]) -> &mut Self where
    T: Serialize, 

push sql,args into self

pub fn do_if<'s, F>(&'s mut self, test: bool, method: F) -> &'s mut Self where
    F: FnOnce(&'s mut Self) -> &'s mut Self, 

do method,if test is true for example: let arg = 1; wrapper.if_do(true, |w,arg| w.eq("id", arg))

pub fn do_match<'s, F>(
    &'s mut self,
    cases: &'s [Case],
    default: F
) -> &'s mut Self where
    F: FnOnce(&'s mut Self) -> &'s mut Self, 

match cases for example: let p = Option::::Some(1); let w = Wrapper::new(&DriverType::Postgres) .do_match(&[ Case::new(p.is_some(),|w| w), Case::new(p.is_none(),|w| w), ], |w| w) .check().unwrap();

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

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

pub fn set_args<T>(&mut self, args: &[T]) -> &mut Self where
    T: Serialize, 

pub fn push_arg<T>(&mut self, arg: T) -> &mut Self where
    T: Serialize, 

pub fn pop_arg(&mut self) -> &mut Self

pub fn and(&mut self) -> &mut Self

link wrapper sql, if end with where , do nothing

pub fn or(&mut self) -> &mut Self

link wrapper sql, if end with where , do nothing

pub fn having(&mut self, sql_having: &str) -> &mut Self

pub fn all_eq<T>(&mut self, arg: T) -> &mut Self where
    T: Serialize, 

arg: JsonObject or struct{} or map[String,**]

pub fn eq<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

equal for example: eq("a",1) " a = 1 "

pub fn ne<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

not equal

pub fn order_by(&mut self, is_asc: bool, columns: &[&str]) -> &mut Self

pub fn group_by(&mut self, columns: &[&str]) -> &mut Self

pub fn gt<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

sql: column > obj

pub fn ge<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

sql: column >= obj

pub fn lt<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

sql: column < obj

pub fn le<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

sql: column <= obj

pub fn between<T>(&mut self, column: &str, min: T, max: T) -> &mut Self where
    T: Serialize, 

pub fn not_between<T>(&mut self, column: &str, min: T, max: T) -> &mut Self where
    T: Serialize, 

pub fn like<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

pub fn like_left<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

pub fn like_right<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

pub fn not_like<T>(&mut self, column: &str, obj: T) -> &mut Self where
    T: Serialize, 

pub fn is_null(&mut self, column: &str) -> &mut Self

pub fn is_not_null(&mut self, column: &str) -> &mut Self

pub fn in_array<T>(&mut self, column: &str, obj: &[T]) -> &mut Self where
    T: Serialize, 

gen sql: * in (,,*)

pub fn in_<T>(&mut self, column: &str, obj: &[T]) -> &mut Self where
    T: Serialize, 

gen sql: * in (,,*)

pub fn in<T>(&mut self, column: &str, obj: &[T]) -> &mut Self where
    T: Serialize, 

gen sql: * in (,,*)

pub fn not_in<T>(&mut self, column: &str, obj: &[T]) -> &mut Self where
    T: Serialize, 

pub fn trim_and(&mut self) -> &mut Self

pub fn trim_or(&mut self) -> &mut Self

Trait Implementations

impl Clone for Wrapper

fn clone(&self) -> Wrapper

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Wrapper

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Wrapper

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error> where
    __D: Deserializer<'de>, 

Deserialize this value from the given Serde deserializer.

impl Serialize for Wrapper

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error> where
    __S: Serializer, 

Serialize this value into the given Serde serializer.