Struct Sqlite

pub struct Sqlite {
    pub connection: Connection,
    pub default: String,
    pub params: Params,
}

Fields

connection: Connection

当前连接配置

default: String

当前选中配置

params: Params

Implementations

impl Sqlite

pub fn connect(connection: Connection, default: String) -> Result<Self, String>

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

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

Trait Implementations

impl Clone for Sqlite

fn clone(&self) -> Sqlite

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl DbMode for Sqlite

fn database_tables(&mut self) -> JsonValue

数据库是否存在

fn database_create(&mut self, _name: &str) -> bool

创建数据库

fn backups(&mut self, _filename: &str) -> bool

备份

impl Debug for Sqlite

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

Formats the value using the given formatter.

impl Mode for Sqlite

fn table_create(&mut self, options: TableOptions) -> JsonValue

fn table_update(&mut self, options: TableOptions) -> JsonValue

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

获取表信息

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

判断表是否存在

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

当前表

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

别名

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

主键自增

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

返回sql语句

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

JSON 字段

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

显示字段

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

隐藏字段

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 page(&mut self, page: i32, limit: i32) -> &mut Self

分页

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

查询指定列并返回数组

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 update(&mut self, data: JsonValue) -> JsonValue

更新

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

批量更新

fn delete(&mut self) -> JsonValue

删除

fn transaction(&mut self) -> bool

事务开始

fn commit(&mut self) -> bool

事务提交

fn rollback(&mut self) -> bool

事务回滚

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

sql语句执行

fn sql_execute(&mut self, sql: &str) -> Result<JsonValue, String>

fn inc(&mut self, field: &str, num: f64) -> &mut Self

自增

fn dec(&mut self, field: &str, num: f64) -> &mut Self

自减

fn buildsql(&mut self) -> String

构造子查询

fn join( &mut self, table: &str, main_fields: &str, right_fields: &str, ) -> &mut Self

连结

fn join_inner( &mut self, table: &str, main_fields: &str, second_fields: &str, ) -> &mut Self

内连接–用来取交集