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
|
from __future__ import annotations
import argparse
import sys
import typing as t
import sqlglot
parser = argparse.ArgumentParser(description="Transpile SQL")
parser.add_argument(
"sql",
metavar="sql",
type=str,
help="SQL statement(s) to transpile, or - to parse stdin.",
)
parser.add_argument(
"--read",
dest="read",
type=str,
default=None,
help="Dialect to read default is generic",
)
parser.add_argument(
"--write",
dest="write",
type=str,
default=None,
help="Dialect to write default is generic",
)
parser.add_argument(
"--no-identify",
dest="identify",
action="store_false",
help="Don't auto identify fields",
)
parser.add_argument(
"--no-pretty",
dest="pretty",
action="store_false",
help="Compress sql",
)
parser.add_argument(
"--parse",
dest="parse",
action="store_true",
help="Parse and return the expression tree",
)
parser.add_argument(
"--tokenize",
dest="tokenize",
action="store_true",
help="Tokenize and return the tokens list",
)
parser.add_argument(
"--error-level",
dest="error_level",
type=str,
default="IMMEDIATE",
help="IGNORE, WARN, RAISE, IMMEDIATE (default)",
)
parser.add_argument(
"--version",
action="version",
version=sqlglot.__version__,
help="Display the SQLGlot version",
)
args = parser.parse_args()
error_level = sqlglot.ErrorLevel[args.error_level.upper()]
sql = sys.stdin.read() if args.sql == "-" else args.sql
if args.parse:
objs: t.Union[t.List[str], t.List[sqlglot.tokens.Token]] = [
repr(expression)
for expression in sqlglot.parse(
sql,
read=args.read,
error_level=error_level,
)
]
elif args.tokenize:
objs = sqlglot.Dialect.get_or_raise(args.read).tokenize(sql)
else:
objs = sqlglot.transpile(
sql,
read=args.read,
write=args.write,
identify=args.identify,
pretty=args.pretty,
error_level=error_level,
)
for obj in objs:
print(obj)
|