Struct Db 

pub struct Db { /* private fields */ }

Implementations

impl Db

pub fn connect(config: JsonValue) -> Self

数据库链接配置

{
    "type": "mysql",            数据库类型
    "hostname": "127.0.0.1",    数据库地址
    "hostport": 3306,           数据库端口
    "database": "tests",        数据库名
    "username": "root",         用户账号
    "userpass": "11111111",     用户密码
    "params": [],               链接参数
    "charset": "utf8mb4",      语言
    "prefix": ""                数据库前缀
    "idauto": false,            主键在创建时方式 false 使用自定义生成 true 使用系统生成
}

Examples found in repository

examples/db.rs (line 9)

fn main() {
    let root_path = tools::root_path();

    let conf = file::file_content_get_json(format!("{}/tests/config/db.json", root_path.clone()).as_str());
    let mut db = Db::connect(conf);
    let user_user = file::file_content_get_json(format!("{}/tests/sql/user_user.json", root_path.clone()).as_str());
    let table = "user_user";
    let is_table = db.query_table(table);
    if is_table {
        // db.delete_table(table, true);
        // db.create_table(table, user_user.clone());
        let res = db.update_table(table, user_user);
        println!("{}", res);
        // let data = db.fieldsinfo();
        // println!("{:#}", data);
    } else {
        let res = db.create_table(table, user_user);
        println!("{}", res);
        //     let data = array![
        //     object! {
        //         name:"我的",
        //         code:112
        //     },
        //     object! {
        //         name:"我的",
        //         code:1123
        //     }
        // ];
        //     let res = db.table("user_user").add(data);
        //     println!("{}", res);
    }
}

pub fn add_config(self, default: &str, config: JsonValue) -> Self

添加配置

pub fn set_connection(&mut self, default: &str) -> &mut Self

切换配置

pub fn get_connections(self) -> JsonValue

获取配置清单

pub fn database(database: &str, config: JsonValue) -> Self

执行数据库

pub fn query_table(&mut self, table: &str) -> bool

查询数据表是否存在

Examples found in repository

examples/db.rs (line 12)

fn main() {
    let root_path = tools::root_path();

    let conf = file::file_content_get_json(format!("{}/tests/config/db.json", root_path.clone()).as_str());
    let mut db = Db::connect(conf);
    let user_user = file::file_content_get_json(format!("{}/tests/sql/user_user.json", root_path.clone()).as_str());
    let table = "user_user";
    let is_table = db.query_table(table);
    if is_table {
        // db.delete_table(table, true);
        // db.create_table(table, user_user.clone());
        let res = db.update_table(table, user_user);
        println!("{}", res);
        // let data = db.fieldsinfo();
        // println!("{:#}", data);
    } else {
        let res = db.create_table(table, user_user);
        println!("{}", res);
        //     let data = array![
        //     object! {
        //         name:"我的",
        //         code:112
        //     },
        //     object! {
        //         name:"我的",
        //         code:1123
        //     }
        // ];
        //     let res = db.table("user_user").add(data);
        //     println!("{}", res);
    }
}

pub fn create_table(&mut self, table: &str, fields: JsonValue) -> bool

创建数据表

Examples found in repository

examples/db.rs (line 21)

fn main() {
    let root_path = tools::root_path();

    let conf = file::file_content_get_json(format!("{}/tests/config/db.json", root_path.clone()).as_str());
    let mut db = Db::connect(conf);
    let user_user = file::file_content_get_json(format!("{}/tests/sql/user_user.json", root_path.clone()).as_str());
    let table = "user_user";
    let is_table = db.query_table(table);
    if is_table {
        // db.delete_table(table, true);
        // db.create_table(table, user_user.clone());
        let res = db.update_table(table, user_user);
        println!("{}", res);
        // let data = db.fieldsinfo();
        // println!("{:#}", data);
    } else {
        let res = db.create_table(table, user_user);
        println!("{}", res);
        //     let data = array![
        //     object! {
        //         name:"我的",
        //         code:112
        //     },
        //     object! {
        //         name:"我的",
        //         code:1123
        //     }
        // ];
        //     let res = db.table("user_user").add(data);
        //     println!("{}", res);
    }
}

pub fn update_table(&mut self, table: &str, info: JsonValue) -> bool

更新数据表

Examples found in repository

examples/db.rs (line 16)

fn main() {
    let root_path = tools::root_path();

    let conf = file::file_content_get_json(format!("{}/tests/config/db.json", root_path.clone()).as_str());
    let mut db = Db::connect(conf);
    let user_user = file::file_content_get_json(format!("{}/tests/sql/user_user.json", root_path.clone()).as_str());
    let table = "user_user";
    let is_table = db.query_table(table);
    if is_table {
        // db.delete_table(table, true);
        // db.create_table(table, user_user.clone());
        let res = db.update_table(table, user_user);
        println!("{}", res);
        // let data = db.fieldsinfo();
        // println!("{:#}", data);
    } else {
        let res = db.create_table(table, user_user);
        println!("{}", res);
        //     let data = array![
        //     object! {
        //         name:"我的",
        //         code:112
        //     },
        //     object! {
        //         name:"我的",
        //         code:1123
        //     }
        // ];
        //     let res = db.table("user_user").add(data);
        //     println!("{}", res);
    }
}

pub fn fieldsinfo(&mut self) -> JsonValue

字段信息

pub fn fieldsinfo_obj(&mut self) -> JsonValue

pub fn delete_table(&mut self, table: &str, all: bool) -> bool

删除数据表

• all true 删除表数据与表结构 false 只清空表数据不删除表结构

pub fn transaction(&mut self) -> bool

事务开始

pub fn commit(&mut self) -> bool

提交事务

pub fn rollback(&mut self) -> bool

回滚事务

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

执行数据表

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

显示字段

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

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

页码

pub fn fetch_sql(&mut self, open: bool) -> &mut Self

返回SQL不执行

pub fn order(&mut self, field: &str, sort: i8) -> &mut Self

排序

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

分组

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

限制

pub fn distinct(&mut self, open: bool) -> &mut Self

去重复

pub fn union(&mut self, table: &str, all: bool) -> &mut Self

两表同字段

pub fn where_and(&mut self, k: &str, compare: &str, v: JsonValue) -> &mut Self

设置and条件

pub fn where_or(&mut self, k: &str, compare: &str, v: JsonValue) -> &mut Self

设置or条件

pub fn where_column( &mut self, field1: &str, compare: &str, field2: &str, ) -> &mut Self

pub fn inc(&mut self, field: &str, data: JsonValue) -> &mut Self

自增

pub fn dec(&mut self, field: &str, data: JsonValue) -> &mut Self

自减

pub fn find(&mut self) -> JsonValue

查询-单条记录

pub fn select(&mut self) -> JsonValue

查询-多条记录

pub fn column(&mut self) -> JsonValue

查询-多条列记录

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

查询单一记录指定字段

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

添加记录

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

更新记录

pub fn update_case(&mut self, field: &str, data: JsonValue) -> JsonValue

批量更新记录 field 更新主键

pub fn delete(&mut self) -> JsonValue

删除记录

pub fn count(&mut self) -> JsonValue

统计数量

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

最大值

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

最小值

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

平均值

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

求和