1#[derive(Debug, Clone, PartialEq)]
6#[non_exhaustive]
7pub enum FieldType {
8 Standard,
10 Bool,
12 Json,
14 Jsonb,
16 DateTime,
18 TimestampTz,
20 Date,
22 Time,
24 Uuid,
26 Timestamp,
28 Decimal,
30 Blob,
32 Text,
34 Array(Box<FieldType>),
36 Inet,
38 Cidr,
40 MacAddr,
42 MacAddr8,
44 Bit,
46 Varbit,
48 Range(Box<FieldType>),
54 Multirange(Box<FieldType>),
57}
58
59impl FieldType {
60 pub fn postgres_type_name(&self) -> Option<String> {
66 Some(match self {
67 Self::Standard => return None,
68 Self::Bool => "boolean".to_string(),
69 Self::Array(inner) => format!("{}[]", inner.postgres_type_name()?),
70 Self::Json => "json".to_string(),
71 Self::Jsonb => "jsonb".to_string(),
72 Self::DateTime => "timestamp".to_string(),
73 Self::TimestampTz => "timestamptz".to_string(),
74 Self::Date => "date".to_string(),
75 Self::Time => "time".to_string(),
76 Self::Uuid => "uuid".to_string(),
77 Self::Timestamp => "bigint".to_string(),
79 Self::Decimal => "numeric".to_string(),
80 Self::Blob => "bytea".to_string(),
81 Self::Text => "text".to_string(),
82 Self::Inet => "inet".to_string(),
83 Self::Cidr => "cidr".to_string(),
84 Self::MacAddr => "macaddr".to_string(),
85 Self::MacAddr8 => "macaddr8".to_string(),
86 Self::Bit => "bit".to_string(),
87 Self::Varbit => "varbit".to_string(),
88 Self::Range(inner) => range_type_name(inner, false)?.to_string(),
89 Self::Multirange(inner) => range_type_name(inner, true)?.to_string(),
90 })
91 }
92}
93
94fn range_type_name(element: &FieldType, multirange: bool) -> Option<&'static str> {
99 Some(match (element, multirange) {
100 (FieldType::Standard, false) => "int4range",
101 (FieldType::Standard, true) => "int4multirange",
102 (FieldType::Timestamp, false) => "int8range",
103 (FieldType::Timestamp, true) => "int8multirange",
104 (FieldType::Decimal, false) => "numrange",
105 (FieldType::Decimal, true) => "nummultirange",
106 (FieldType::DateTime, false) => "tsrange",
107 (FieldType::DateTime, true) => "tsmultirange",
108 (FieldType::TimestampTz, false) => "tstzrange",
109 (FieldType::TimestampTz, true) => "tstzmultirange",
110 (FieldType::Date, false) => "daterange",
111 (FieldType::Date, true) => "datemultirange",
112 _ => return None,
113 })
114}
115
116pub const SESSION_GUC_BASELINE: &[(&str, &str)] = &[
130 ("TimeZone", "UTC"),
131 ("DateStyle", "ISO, YMD"),
132 ("IntervalStyle", "postgres"),
133 ("extra_float_digits", "3"),
134 ("standard_conforming_strings", "on"),
135];
136
137#[derive(Debug, Clone)]
139#[non_exhaustive]
140pub enum JoinType {
141 Inner,
142 Left,
143 Right,
144}
145
146#[derive(Debug, Clone)]
148pub struct JoinClause {
149 pub join_type: JoinType,
151 pub table: String,
153 pub on: String,
155}
156
157#[derive(Debug, Clone)]
159pub struct OrderClause {
160 pub field: String,
162 pub asc: bool,
164}
165
166#[cfg(test)]
167#[allow(clippy::unwrap_used, clippy::expect_used)]
168mod tests {
169 use super::*;
170
171 #[test]
172 fn postgres_type_name_maps_existing_and_new_types() {
173 let cases = [
174 (FieldType::Bool, "boolean"),
175 (FieldType::Json, "json"),
176 (FieldType::Jsonb, "jsonb"),
177 (FieldType::DateTime, "timestamp"),
178 (FieldType::TimestampTz, "timestamptz"),
179 (FieldType::Date, "date"),
180 (FieldType::Time, "time"),
181 (FieldType::Uuid, "uuid"),
182 (FieldType::Timestamp, "bigint"),
183 (FieldType::Decimal, "numeric"),
184 (FieldType::Blob, "bytea"),
185 (FieldType::Text, "text"),
186 (FieldType::Inet, "inet"),
187 (FieldType::Cidr, "cidr"),
188 (FieldType::MacAddr, "macaddr"),
189 (FieldType::MacAddr8, "macaddr8"),
190 (FieldType::Bit, "bit"),
191 (FieldType::Varbit, "varbit"),
192 ];
193 for (field_type, expected) in cases {
194 assert_eq!(
195 field_type.postgres_type_name().as_deref(),
196 Some(expected),
197 "{field_type:?} 应映射到 PostgreSQL 类型名 {expected}"
198 );
199 }
200 }
201
202 #[test]
203 fn postgres_type_name_is_recursive_for_arrays() {
204 assert_eq!(
205 FieldType::Array(Box::new(FieldType::Text))
206 .postgres_type_name()
207 .as_deref(),
208 Some("text[]")
209 );
210 assert_eq!(
211 FieldType::Array(Box::new(FieldType::Inet))
212 .postgres_type_name()
213 .as_deref(),
214 Some("inet[]")
215 );
216 assert_eq!(
217 FieldType::Array(Box::new(FieldType::Blob))
218 .postgres_type_name()
219 .as_deref(),
220 Some("bytea[]")
221 );
222 assert_eq!(
224 FieldType::Array(Box::new(FieldType::Standard)).postgres_type_name(),
225 None
226 );
227 assert_eq!(FieldType::Standard.postgres_type_name(), None);
228 }
229
230 #[test]
231 fn postgres_type_name_maps_builtin_range_and_multirange_types() {
232 let ranges = [
233 (FieldType::Standard, "int4range", "int4multirange"),
234 (FieldType::Timestamp, "int8range", "int8multirange"),
235 (FieldType::Decimal, "numrange", "nummultirange"),
236 (FieldType::DateTime, "tsrange", "tsmultirange"),
237 (FieldType::TimestampTz, "tstzrange", "tstzmultirange"),
238 (FieldType::Date, "daterange", "datemultirange"),
239 ];
240 for (element, range, multirange) in ranges {
241 assert_eq!(
242 FieldType::Range(Box::new(element.clone()))
243 .postgres_type_name()
244 .as_deref(),
245 Some(range),
246 "Range({element:?}) 应映射到 {range}"
247 );
248 assert_eq!(
249 FieldType::Multirange(Box::new(element))
250 .postgres_type_name()
251 .as_deref(),
252 Some(multirange)
253 );
254 }
255
256 for element in [FieldType::Text, FieldType::Json, FieldType::Uuid] {
258 assert_eq!(
259 FieldType::Range(Box::new(element.clone())).postgres_type_name(),
260 None
261 );
262 assert_eq!(
263 FieldType::Multirange(Box::new(element)).postgres_type_name(),
264 None
265 );
266 }
267 }
268
269 #[test]
270 fn session_guc_baseline_pins_deterministic_formats() {
271 assert_eq!(
272 SESSION_GUC_BASELINE,
273 [
274 ("TimeZone", "UTC"),
275 ("DateStyle", "ISO, YMD"),
276 ("IntervalStyle", "postgres"),
277 ("extra_float_digits", "3"),
278 ("standard_conforming_strings", "on"),
279 ]
280 .as_slice(),
281 "会话 GUC 基线是类型编解码确定性的契约,变更需同步文档与集成测试"
282 );
283 }
284
285 #[test]
287 fn session_guc_baseline_datestyle_matches_set_statement() {
288 let datestyle = SESSION_GUC_BASELINE
289 .iter()
290 .find(|(name, _)| *name == "DateStyle")
291 .map(|(_, value)| *value)
292 .expect("基线必须包含 DateStyle");
293 assert_eq!(datestyle, "ISO, YMD");
294 }
295}