risingwave_sqlparser/ast/
data_type.rs

1// Licensed under the Apache License, Version 2.0 (the "License");
2// you may not use this file except in compliance with the License.
3// You may obtain a copy of the License at
4//
5//     http://www.apache.org/licenses/LICENSE-2.0
6//
7// Unless required by applicable law or agreed to in writing, software
8// distributed under the License is distributed on an "AS IS" BASIS,
9// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
10// See the License for the specific language governing permissions and
11// limitations under the License.
12
13#[cfg(not(feature = "std"))]
14use alloc::boxed::Box;
15use core::fmt;
16
17#[cfg(feature = "serde")]
18use serde::{Deserialize, Serialize};
19
20use crate::ast::{Ident, ObjectName, display_comma_separated};
21
22/// SQL data types
23#[derive(Debug, Clone, PartialEq, Eq, Hash)]
24#[cfg_attr(feature = "serde", derive(Serialize, Deserialize))]
25pub enum DataType {
26    /// Fixed-length character type e.g. CHAR(10)
27    Char(Option<u64>),
28    /// Variable-length character type.
29    /// We diverge from postgres by disallowing Varchar(n).
30    Varchar,
31    /// Uuid type
32    Uuid,
33    /// Decimal type with optional precision and scale e.g. DECIMAL(10,2)
34    Decimal(Option<u64>, Option<u64>),
35    /// Floating point with optional precision e.g. FLOAT(8)
36    Float(Option<u64>),
37    /// SMALLINT (int2)
38    SmallInt,
39    /// INTEGER (int4)
40    Int,
41    /// BIGINT (int8)
42    BigInt,
43    /// Floating point e.g. REAL
44    Real,
45    /// Double e.g. DOUBLE PRECISION
46    Double,
47    /// Boolean
48    Boolean,
49    /// Date
50    Date,
51    /// Time with optional time zone
52    Time(bool),
53    /// Timestamp with optional time zone
54    Timestamp(bool),
55    /// Interval
56    Interval,
57    /// Regclass used in postgresql serial
58    Regclass,
59    /// Regproc used in postgresql function
60    Regproc,
61    /// Text
62    Text,
63    /// Bytea
64    Bytea,
65    /// JSONB
66    Jsonb,
67    /// Custom type such as enums
68    Custom(ObjectName),
69    /// Arrays
70    Array(Box<DataType>),
71    /// Structs
72    Struct(Vec<StructField>),
73    /// Map(key_type, value_type)
74    Map(Box<(DataType, DataType)>),
75}
76
77impl fmt::Display for DataType {
78    fn fmt(&self, f: &mut fmt::Formatter<'_>) -> fmt::Result {
79        match self {
80            DataType::Char(size) => format_type_with_optional_length(f, "CHAR", size),
81            DataType::Varchar => write!(f, "CHARACTER VARYING"),
82            DataType::Uuid => write!(f, "UUID"),
83            DataType::Decimal(precision, scale) => {
84                if let Some(scale) = scale {
85                    write!(f, "NUMERIC({},{})", precision.unwrap(), scale)
86                } else {
87                    format_type_with_optional_length(f, "NUMERIC", precision)
88                }
89            }
90            DataType::Float(size) => format_type_with_optional_length(f, "FLOAT", size),
91            DataType::SmallInt => {
92                write!(f, "SMALLINT")
93            }
94            DataType::Int => write!(f, "INT"),
95            DataType::BigInt => write!(f, "BIGINT"),
96            DataType::Real => write!(f, "REAL"),
97            DataType::Double => write!(f, "DOUBLE"),
98            DataType::Boolean => write!(f, "BOOLEAN"),
99            DataType::Date => write!(f, "DATE"),
100            DataType::Time(tz) => write!(f, "TIME{}", if *tz { " WITH TIME ZONE" } else { "" }),
101            DataType::Timestamp(tz) => {
102                write!(f, "TIMESTAMP{}", if *tz { " WITH TIME ZONE" } else { "" })
103            }
104            DataType::Interval => write!(f, "INTERVAL"),
105            DataType::Regclass => write!(f, "REGCLASS"),
106            DataType::Regproc => write!(f, "REGPROC"),
107            DataType::Text => write!(f, "TEXT"),
108            DataType::Bytea => write!(f, "BYTEA"),
109            DataType::Jsonb => write!(f, "JSONB"),
110            DataType::Array(ty) => write!(f, "{}[]", ty),
111            DataType::Custom(ty) => write!(f, "{}", ty),
112            DataType::Struct(defs) => {
113                write!(f, "STRUCT<{}>", display_comma_separated(defs))
114            }
115            DataType::Map(kv) => {
116                write!(f, "MAP({},{})", kv.0, kv.1)
117            }
118        }
119    }
120}
121
122fn format_type_with_optional_length(
123    f: &mut fmt::Formatter<'_>,
124    sql_type: &'static str,
125    len: &Option<u64>,
126) -> fmt::Result {
127    write!(f, "{}", sql_type)?;
128    if let Some(len) = len {
129        write!(f, "({})", len)?;
130    }
131    Ok(())
132}
133
134#[derive(Debug, Clone, PartialEq, Eq, Hash)]
135#[cfg_attr(feature = "serde", derive(Serialize, Deserialize))]
136pub struct StructField {
137    pub name: Ident,
138    pub data_type: DataType,
139}
140
141impl fmt::Display for StructField {
142    fn fmt(&self, f: &mut fmt::Formatter<'_>) -> fmt::Result {
143        write!(f, "{} {}", self.name, self.data_type)
144    }
145}
risingwave_sqlparser/ast/data_type.rs

risingwave_sqlparser/ast/
data_type.rs
