sql_wrapper 0.1.6

Generate table Struct and Sql function for table based on sqlx and sql_builder
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
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184

use chrono::{DateTime, NaiveDate, NaiveDateTime, NaiveTime};
use sqlx::postgres::types::{PgInterval, PgTimeTz};
use sqlx::types::Decimal;
use uuid::Uuid;

pub trait FieldToString {
    fn field_to_string(&self) -> String;
}

impl FieldToString for i8 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}
impl FieldToString for i16 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for i32 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for i64 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for i128 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for isize {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}


impl FieldToString for u8 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}
impl FieldToString for u16 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for u32 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for u64 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for u128 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for usize {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for String {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for &str {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for f32 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for f64 {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for bool {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for Vec<u8> {
    fn field_to_string(&self) -> String {
        String::from_utf8(self.to_vec()).unwrap()
        // format!("{:?}", self)
    }
}

impl FieldToString for PgInterval {
    fn field_to_string(&self) -> String {
        // 2 months 3 days 4 hours 5 minutes 6000.3 seconds
        format!("{} months {} days {} seconds", self.months, self.days, self.microseconds as f32 / 1000f32)
    }
}

impl FieldToString for Decimal {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for NaiveDateTime {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for DateTime<chrono::Utc> {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for DateTime<chrono::Local> {
    fn field_to_string(&self) -> String {
        let str = self.to_string();
        // 2024-06-27 10:05:49.96
        let str = &str[0..22];
        str.to_string()
        // 2024-06-27T10:05:49.96
        // let str = str.replace(" ", "T");
        // println!("{str}");
        // str
    }
}

impl FieldToString for NaiveDate {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for NaiveTime {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for Uuid {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}

impl FieldToString for PgTimeTz {
    fn field_to_string(&self) -> String {
        format!("{} {}", self.time, self.offset)
    }
}

impl FieldToString for serde_json::Value {
    fn field_to_string(&self) -> String {
        self.to_string()
    }
}