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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120

use sqlx::database::HasArguments;
use sqlx::{Arguments, Database, Error, Executor, IntoArguments};
use sqlx::query::{Query};
use super::TableName;
use super::{DbType,  ModelTableField, ModelTableName};

/// 删除操作
pub struct Delete<DB>
    where DB:Database
{
    pub table_name:TableName,
    _marker:std::marker::PhantomData<DB>
}
impl <DB> Delete<DB>
    where DB:Database
{
    pub fn type_new<T1>() -> Delete<DB>
    where
        T1: ModelTableField<DB>+ModelTableName
    {
        Delete {
           table_name:T1::table_name(),
           _marker:Default::default()
        }
    }
    pub fn new(table_name:TableName) -> Delete<DB>
    {
        Delete {
           table_name,
           _marker:Default::default()
        }
    }
    pub async fn execute_by_where_call<'c,RB,E>(
        &self,
        where_sql: &str,
        where_bind: RB,
        executor:E,
    ) -> Result<<DB as Database>::QueryResult, Error>
    where
        for<'q> RB: FnOnce(
            Query<'q,DB,<DB as HasArguments<'q>>::Arguments> ,
            &'q Delete<DB>,
        ) ->Query<'q,DB,<DB as HasArguments<'q>>::Arguments>,
        for<'n> <DB as HasArguments<'n>>::Arguments:
            Arguments<'n>+IntoArguments<'n,DB>,
        E: Executor<'c, Database = DB>
    {
        let sql = format!("DELETE FROM {} WHERE {}", self.table_name.full_name(), where_sql);
        let mut res = sqlx::query(sql.as_str());
        res = where_bind(res,self);
        executor.execute(res).await
    }
    pub async fn execute_by_where<'c,E>(
        &self,
        where_sql: Option<String>,
        executor:E,
    ) -> Result<<DB as Database>::QueryResult, Error>
    where
        for<'n> <DB as HasArguments<'n>>::Arguments:
            Arguments<'n>+IntoArguments<'n,DB>,
        E: Executor<'c, Database = DB>
    {
        let sql;
        match where_sql {
            Some(wsql)=>{
                sql = format!("DELETE FROM {} WHERE {}", self.table_name.full_name(), wsql);
            }
            None=>{
                sql = format!("DELETE FROM {} ", self.table_name.full_name());
            }
        }
        let res = sqlx::query(sql.as_str());
        executor.execute(res).await
    }
    pub async fn execute_by_pk<'c,T,E>(&self, 
    source: &T, 
    executor:E,
    ) 
    -> Result<<DB as Database>::QueryResult, Error>
    where
        for<'n> <DB as HasArguments<'n>>::Arguments:
        Arguments<'n>+IntoArguments<'n,DB>,
        T: ModelTableField<DB>,
        E: Executor<'c, Database = DB>
    {
        let pkf = T::table_pk();
        let mut where_sql = vec![];
        for (pos, val) in pkf.0.iter().enumerate() {
            let bst = DbType::type_new::<DB>().mark(pos);
            where_sql.push(format!("{}={}", val.name, bst));
        }
        let sql = format!(
            "DELETE FROM {} WHERE {}",
            self.table_name.full_name(),
            where_sql.join(" and ")
        );
        let mut res = sqlx::query(sql.as_str());
        for val in pkf.0.iter() {
            res = source.query_sqlx_bind(val, res);
        }
        executor.execute(res).await
    }
    pub async fn execute_by_scalar_pk<'c,T,PT,E>(&self, pk_scalar: PT, executor:E,) -> Result<<DB as Database>::QueryResult, Error>
        where 
            for<'n> <DB as HasArguments<'n>>::Arguments:
            Arguments<'n>+IntoArguments<'n,DB>,
            T:ModelTableField<DB>,
            for<'q> PT:'q+ Send + sqlx::Encode<'q, DB> + sqlx::Type<DB>,
            E: Executor<'c, Database = DB>
    {
        let sql = format!(
            "DELETE FROM {} WHERE {}",
            self.table_name.full_name(),
            scalar_pk_where!(DB,T::table_pk())
        );
        let mut res = sqlx::query(sql.as_str());
        res=res.bind(pk_scalar);
        executor.execute(res).await
    }
}