huiyu-db-mapper-sqlite 0.1.0

Database Query Tool with Deadpool. Query Wrapper Tool. Orm Tool
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

use huiyu_db_mapper_core::base::entity::Entity;
use huiyu_db_mapper_core::base::param::ParamValue;
use huiyu_db_mapper_core::sql::sql_generator::{BaseSqlGenerator, PageSqlGenerator, QueryWrapperSqlGenerator, WhereSqlGenerator};

pub const SQLITE_SQL_GENERATOR:SqliteSqlGenerator= SqliteSqlGenerator {};
pub struct SqliteSqlGenerator;

impl PageSqlGenerator for SqliteSqlGenerator {
    fn gen_page_query_sql(&self, query_sql: &str, current_page: u64, page_size: u64) -> (String,u64,u64) {
        (format!("select * from({}) limit ? offset ?",query_sql),page_size, (current_page-1)*page_size)
    }
}

impl WhereSqlGenerator for SqliteSqlGenerator {

}

impl BaseSqlGenerator for SqliteSqlGenerator{
    fn gen_insert_and_get_id_sql<E>(&self, e:&E) -> (String, Vec<ParamValue>)
    where
        E: Entity
    {
        let (insert_sql, params) = self.gen_insert_one_sql(e);
        let sql = format!("{} {};", insert_sql, " RETURNING id".to_string());
        (sql, params)
    }
}

impl QueryWrapperSqlGenerator for SqliteSqlGenerator {}