mssql_quick/method/
msdel.rs

1/// 删除数据 ，返回 sql 语句。
2/// ```
3/// # use serde::{Deserialize, Serialize};
4/// # use mssql_quick::{msdel, ms_run_vec, MssqlQuick, EncryptionLevel, MssqlQuickSet};
5/// # const MSSQL_URL: &str = "server=tcp:localhost,1433;user=SA;password=ji83laFidia32FAEE534DFa;database=dev_db;IntegratedSecurity=true;TrustServerCertificate=true";
6/// # tokio_test::block_on(async {
7/// # let mut client = MssqlQuick::new(MSSQL_URL, EncryptionLevel::NotSupported).await.unwrap().client;
8/// // 通过 id 删除（删除id为1066的数据）
9/// let sql = msdel!("for_test", 1066);
10/// let _: Vec<()> = ms_run_vec(&mut client, sql).await.unwrap();
11///
12/// // 通过指定字段的值，删除全部数据
13/// // 删除 uid = 23 的数据 （注：如果有多条，会全部删除）
14/// let sql = msdel!("for_test", {"uid": 23});
15/// let _: Vec<()> = ms_run_vec(&mut client, sql).await.unwrap();
16/// # });
17/// ```
18#[macro_export]
19macro_rules! msdel {
20    ($t:expr, {$k:tt: $v:expr}) => {{
21        fn type_of<T>(_: T) -> &'static str {
22            std::any::type_name::<T>()
23        }
24        let keys = $k.to_string();
25        let temp_v = $v;
26        let v_type = type_of(&temp_v);
27        let values = match v_type {
28            "&&str" | "&alloc::string::String" | "&&alloc::string::String" => {
29                let mut v_r = temp_v.to_string();
30                v_r = v_r.replace("'", "''");
31                "N'".to_string() + &v_r + "'"
32            }
33            "&u8" | "&u16" | "&u32" | "&u64" | "&u128" | "&usize" | "&i8" | "&i16" | "&i32"
34            | "&i64" | "&i128" | "&isize" | "&f32" | "&f64" | "&f128" | "&bool" => {
35                temp_v.to_string() + ""
36            }
37            "&&u8" | "&&u16" | "&&u32" | "&&u64" | "&&u128" | "&&usize" | "&&i8" | "&&i16"
38            | "&&i32" | "&&i64" | "&&i128" | "&&isize" | "&&f32" | "&&f64" | "&&f128"
39            | "&&bool" => temp_v.to_string() + "",
40            _ => "".to_string(),
41        };
42
43        let sql: String =
44            "DELETE FROM ".to_string() + $t + " WHERE " + keys.as_str() + "=" + values.as_str();
45
46        sql
47    }};
48
49    ($t:expr, $v: expr) => {{
50        fn type_of<T>(_: T) -> &'static str {
51            std::any::type_name::<T>()
52        }
53        let temp_v = $v;
54        let v_type = type_of(&temp_v);
55        let values = match v_type {
56            "&&str" | "&alloc::string::String" | "&&alloc::string::String" => {
57                let mut v_r = temp_v.to_string();
58                v_r = v_r.replace("'", "''");
59                "N'".to_string() + &v_r + "'"
60            }
61            "&u8" | "&u16" | "&u32" | "&u64" | "&u128" | "&usize" | "&i8" | "&i16" | "&i32"
62            | "&i64" | "&i128" | "&isize" | "&f32" | "&f64" | "&f128" | "&bool" => {
63                temp_v.to_string() + ""
64            }
65            "&&u8" | "&&u16" | "&&u32" | "&&u64" | "&&u128" | "&&usize" | "&&i8" | "&&i16"
66            | "&&i32" | "&&i64" | "&&i128" | "&&isize" | "&&f32" | "&&f64" | "&&f128"
67            | "&&bool" => temp_v.to_string() + "",
68            _ => "".to_string(),
69        };
70
71        let sql: String = "DELETE FROM ".to_string() + $t + " WHERE id=" + values.as_str();
72
73        sql
74    }};
75}
mssql_quick/method/msdel.rs

mssql_quick/method/
msdel.rs
