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
121
122
123
124

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

/// 删除操作
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) => {
                format!("DELETE FROM {} WHERE {}", self.table_name.full_name(), wsql)
            }
            None => {
                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
    }
}