taitan-orm-parser 0.1.10

Next Generation ORM based on sqlx
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
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
125
126
127
128
129
130
131
132
133

use crate::{DatabaseType, FieldMapper, SqlType, TableDef};
use proc_macro2::TokenStream;
use quote::{format_ident, quote};
use crate::condition_def::{ConditionDef, VariantsOrFields};

#[derive(Debug, Default)]
pub struct SqlGenerator;
impl SqlGenerator {
    pub fn gen_sql(
        &self,
        db_type: &DatabaseType,
        sql_type: &SqlType,
        table: &TableDef,
    ) -> TokenStream {
        match sql_type {
            SqlType::Insert => self.gen_insert_sql(table, db_type),
            SqlType::Upsert => self.gen_upsert_sql(table, db_type),
        }
    }

    pub fn gen_insert_sql(&self, table_def: &TableDef, db_type: &DatabaseType) -> TokenStream {
        let field_mapper = FieldMapper::new();
        let table_name = field_mapper.escape(&table_def.table_name, db_type);
        let fields = field_mapper.gen_names(&table_def.fields, &db_type);
        let marks = field_mapper.gen_marks(&table_def.fields, &db_type);
        let sql_template = format!("INSERT INTO {table_name} ({{}}) VALUES({{}})");
        quote! {
            let fields = #fields;
            let marks = #marks;
            std::borrow::Cow::Owned(format!(#sql_template, fields, marks))
        }
    }
    pub fn gen_upsert_sql(&self, table_def: &TableDef, db_type: &DatabaseType) -> TokenStream {
        let field_mapper = FieldMapper::new();
        let table_name = field_mapper.escape(&table_def.table_name, db_type);
        let fields = field_mapper.gen_names(&table_def.fields, db_type);
        let primary_fields = table_def.get_primary_fields();
        let primary_fields_stream = field_mapper.gen_names(primary_fields, db_type);
        let non_primary_fields = table_def.get_not_primary_fields();
        let upsert_sets_stream = field_mapper.gen_upsert_sets(non_primary_fields, db_type);

        let marks = field_mapper.gen_marks(&table_def.fields, db_type);
        return match db_type {
            DatabaseType::MySql => {
                let sql = format!(
                    "INSERT INTO {table_name} ({{}}) VALUES({{}}) ON DUPLICATE KEY UPDATE {{}}"
                );
                quote! {
                    let fields = #fields;
                    let marks = #marks;
                    let upsert_sets = #upsert_sets_stream;
                    std::borrow::Cow::Owned(format!(#sql, fields, marks, upsert_sets))
                }
            }
            DatabaseType::Postgres => {
                let sql = format!("INSERT INTO {table_name} ({{}}) VALUES({{}}) ON CONFLICT ({{}}) DO UPDATE SET {{}}");
                quote! {
                    let fields = #fields;
                    let marks = #marks;
                    let primarys = #primary_fields_stream;
                    let upsert_sets = #upsert_sets_stream;
                    std::borrow::Cow::Owned(format!(#sql, fields, marks, primarys, upsert_sets))
                }
            }
            DatabaseType::Sqlite => {
                let sql = format!("INSERT INTO {table_name} ({{}}) VALUES({{}}) ON CONFLICT ({{}}) DO UPDATE SET {{}}");
                quote! {
                    let fields = #fields;
                    let marks = #marks;
                    let primarys = #primary_fields_stream;
                    let upsert_sets = #upsert_sets_stream;
                    std::borrow::Cow::Owned(format!(#sql, fields, marks, primarys, upsert_sets))
                }
            }
        };
    }

    pub fn gen_update_set_sql(&self, table_def: &TableDef, db_type: &DatabaseType) -> TokenStream {
        let field_mapper = FieldMapper::new();
        field_mapper.gen_sets(&table_def.fields, db_type)
    }

    pub fn gen_where_sql(&self, condition_def: &ConditionDef, db_type: &DatabaseType) -> TokenStream {
        let field_mapper = FieldMapper::new();
        let mut stream = TokenStream::new();
        match &condition_def.variants_or_fields {
            VariantsOrFields::Variants(variants) => {
                for variant in variants {
                    let variant_name = format_ident!("{}", &variant.name);
                    let idents = field_mapper.gen_idents(&variant.fields);
                    // panic!("idents: {}", idents);
                    let s = field_mapper.gen_conditions(&variant.fields, db_type, true);
                    if variant.named {
                        stream.extend(quote! {
                            Self::#variant_name{ #idents }=> {
                                #s
                            }
                        });
                    } else {
                        stream.extend(quote! {
                    Self::#variant_name( #idents )=> {
                        #s
                    }
                });
                    }
                }

                quote! {
                    let s = match self {
                        #stream
                    };
                    std::borrow::Cow::Owned(s)
                }
            }
            VariantsOrFields::Fields(fields) => {
                let stream = field_mapper.gen_conditions(fields, db_type, false);
                quote! {
                    let s =  {
                        #stream
                    };
                    std::borrow::Cow::Owned(s)
                }
            }
        }


    }

    pub fn gen_select_sql(&self, table_def: &TableDef, db_type: &DatabaseType) -> TokenStream {
        let field_mapper = FieldMapper::new();
        field_mapper.gen_names(&table_def.fields, db_type)
    }
}