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
|
import unittest
from sqlglot.dataframe.sql import types
class TestDataframeTypes(unittest.TestCase):
def test_string(self):
self.assertEqual("string", types.StringType().simpleString())
def test_char(self):
self.assertEqual("char(100)", types.CharType(100).simpleString())
def test_varchar(self):
self.assertEqual("varchar(65)", types.VarcharType(65).simpleString())
def test_binary(self):
self.assertEqual("binary", types.BinaryType().simpleString())
def test_boolean(self):
self.assertEqual("boolean", types.BooleanType().simpleString())
def test_date(self):
self.assertEqual("date", types.DateType().simpleString())
def test_timestamp(self):
self.assertEqual("timestamp", types.TimestampType().simpleString())
def test_timestamp_ntz(self):
self.assertEqual("timestamp_ntz", types.TimestampNTZType().simpleString())
def test_decimal(self):
self.assertEqual("decimal(10, 3)", types.DecimalType(10, 3).simpleString())
def test_double(self):
self.assertEqual("double", types.DoubleType().simpleString())
def test_float(self):
self.assertEqual("float", types.FloatType().simpleString())
def test_byte(self):
self.assertEqual("tinyint", types.ByteType().simpleString())
def test_integer(self):
self.assertEqual("int", types.IntegerType().simpleString())
def test_long(self):
self.assertEqual("bigint", types.LongType().simpleString())
def test_short(self):
self.assertEqual("smallint", types.ShortType().simpleString())
def test_array(self):
self.assertEqual("array<int>", types.ArrayType(types.IntegerType()).simpleString())
def test_map(self):
self.assertEqual(
"map<int, string>",
types.MapType(types.IntegerType(), types.StringType()).simpleString(),
)
def test_struct_field(self):
self.assertEqual("cola:int", types.StructField("cola", types.IntegerType()).simpleString())
def test_struct_type(self):
self.assertEqual(
"struct<cola:int, colb:string>",
types.StructType(
[
types.StructField("cola", types.IntegerType()),
types.StructField("colb", types.StringType()),
]
).simpleString(),
)
|
