Trait df_db::Mode

source ·
pub trait Mode {
Show 35 methods // Required methods fn table_create(&mut self, data: Table) -> bool; fn table_update(&mut self, data: Table) -> bool; fn table_info(&mut self, table: &str) -> JsonValue; fn table_is_exist(&mut self, name: &str) -> bool; fn table(&mut self, name: &str) -> &mut Self; fn autoinc(&mut self) -> &mut Self; fn fetch_sql(&mut self) -> &mut Self; fn order(&mut self, field: &str, by: bool) -> &mut Self; fn group(&mut self, field: &str) -> &mut Self; fn distinct(&mut self) -> &mut Self; fn json(&mut self, field: &str) -> &mut Self; fn column(&mut self, field: &str) -> JsonValue; fn where_and( &mut self, field: &str, compare: &str, value: JsonValue ) -> &mut Self; fn where_or( &mut self, field: &str, compare: &str, value: JsonValue ) -> &mut Self; fn where_column( &mut self, field_a: &str, compare: &str, field_b: &str ) -> &mut Self; fn count(&mut self) -> JsonValue; fn max(&mut self, field: &str) -> JsonValue; fn min(&mut self, field: &str) -> JsonValue; fn sum(&mut self, field: &str) -> JsonValue; fn avg(&mut self, field: &str) -> JsonValue; fn select(&mut self) -> JsonValue; fn find(&mut self) -> JsonValue; fn value(&mut self, field: &str) -> JsonValue; fn insert(&mut self, data: JsonValue) -> JsonValue; fn insert_all(&mut self, data: JsonValue) -> JsonValue; fn page(&mut self, page: i32, limit: i32) -> &mut Self; fn update(&mut self, data: JsonValue) -> JsonValue; fn delete(&mut self) -> JsonValue; fn field(&mut self, name: &str) -> &mut Self; fn hidden(&mut self, name: &str) -> &mut Self; fn pool(&mut self) -> Pool; fn transaction(&mut self) -> bool; fn commit(&mut self) -> bool; fn rollback(&mut self) -> bool; fn sql(&mut self, sql: String) -> JsonValue;
}

Required Methods§

source

fn table_create(&mut self, data: Table) -> bool

source

fn table_update(&mut self, data: Table) -> bool

source

fn table_info(&mut self, table: &str) -> JsonValue

source

fn table_is_exist(&mut self, name: &str) -> bool

source

fn table(&mut self, name: &str) -> &mut Self

当前表

source

fn autoinc(&mut self) -> &mut Self

主键自增

source

fn fetch_sql(&mut self) -> &mut Self

返回sql语句

source

fn order(&mut self, field: &str, by: bool) -> &mut Self

排序

source

fn group(&mut self, field: &str) -> &mut Self

分组

source

fn distinct(&mut self) -> &mut Self

消除重复记录

source

fn json(&mut self, field: &str) -> &mut Self

JSON 字段

source

fn column(&mut self, field: &str) -> JsonValue

查询指定列并返回数组

source

fn where_and( &mut self, field: &str, compare: &str, value: JsonValue ) -> &mut Self

查询

source

fn where_or( &mut self, field: &str, compare: &str, value: JsonValue ) -> &mut Self

source

fn where_column( &mut self, field_a: &str, compare: &str, field_b: &str ) -> &mut Self

比较两个列

source

fn count(&mut self) -> JsonValue

总数量

source

fn max(&mut self, field: &str) -> JsonValue

最大值

source

fn min(&mut self, field: &str) -> JsonValue

最小值

source

fn sum(&mut self, field: &str) -> JsonValue

合计

source

fn avg(&mut self, field: &str) -> JsonValue

平均值

source

fn select(&mut self) -> JsonValue

获取集合

source

fn find(&mut self) -> JsonValue

获取单记录

source

fn value(&mut self, field: &str) -> JsonValue

获取单一列值

source

fn insert(&mut self, data: JsonValue) -> JsonValue

添加

source

fn insert_all(&mut self, data: JsonValue) -> JsonValue

批量添加

source

fn page(&mut self, page: i32, limit: i32) -> &mut Self

分页

source

fn update(&mut self, data: JsonValue) -> JsonValue

更新

source

fn delete(&mut self) -> JsonValue

删除

source

fn field(&mut self, name: &str) -> &mut Self

显示字段

source

fn hidden(&mut self, name: &str) -> &mut Self

隐藏字段

source

fn pool(&mut self) -> Pool

池子

source

fn transaction(&mut self) -> bool

事务开始

source

fn commit(&mut self) -> bool

事务提交

source

fn rollback(&mut self) -> bool

事务回滚

source

fn sql(&mut self, sql: String) -> JsonValue

sql语句执行

Implementors§

source§

impl Mode for Db