This repository was archived by the owner on Apr 18, 2026. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 14
Expand file tree
/
Copy pathfunc.py
More file actions
125 lines (101 loc) · 3.54 KB
/
func.py
File metadata and controls
125 lines (101 loc) · 3.54 KB
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
# Copyright 2020 Google LLC
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# https://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
from dataclasses import dataclass
from typing import Optional
from typing import List
from rfmt.blocks import LineBlock as LB
from rfmt.blocks import IndentBlock as IB
from rfmt.blocks import TextBlock as TB
from rfmt.blocks import StackBlock as SB
from rfmt.blocks import WrapBlock as WB
from .utils import comments_sqlf
from .const import SQLString
from .ident import SQLIdentifier
from .node import SQLNode
from .node import SQLNodeList
from .expr import SQLExpr
from .types import SQLType
from .types import SQLNamedType
@dataclass(frozen=True)
class SQLFunction(SQLNode):
name: SQLIdentifier
params: SQLNodeList[SQLNode]
retval: Optional[SQLNode]
impl: SQLNode
comments: List[str]
def sqlf(self, compact):
# Start the stack with comments
stack = comments_sqlf(self.comments)
# Get params as a list of sqlf
paramf = []
for param in self.params[:-1]:
paramf.append(LB([param.sqlf(compact), TB(',')]))
if self.params:
paramf.append(self.params[-1].sqlf(compact))
stack.append(LB([
TB('CREATE TEMPORARY FUNCTION '),
self.name.sqlf(True),
TB('('),
WB(paramf, sep=' '),
TB(')')
]))
if self.retval:
stack.append(LB([TB('RETURNS '),
self.retval.sqlf(compact)]))
if isinstance(self.impl, SQLString):
stack.append(TB('LANGUAGE js AS'))
stack.append(IB(LB([
self.impl.sqlf(compact), TB(';')
])))
else:
stack.append(TB('AS'))
stack.append(IB(LB([self.impl.sqlf(compact),
TB(';')])))
stack.append(TB(''))
return SB(stack)
@staticmethod
def consume(lex) -> 'Optional[SQLFunction]':
if not (lex.consume(['CREATE', 'TEMP']) or
lex.consume(['CREATE', 'TEMPORARY'])):
return None
comments = lex.get_comments()
lex.expect('FUNCTION')
name = (SQLIdentifier.consume(lex) or
lex.error('Expected UDF name'))
lex.expect('(')
params = []
while True:
var_name = SQLIdentifier.parse(lex)
ltype = SQLType.parse(lex)
params.append(SQLNamedType(var_name, ltype))
if not lex.consume(','):
break
lex.expect(')')
rtype = None
# Javascript function
if lex.consume('RETURNS'):
rtype = SQLType.parse(lex)
lex.expect('LANGUAGE')
lex.expect('JS')
lex.expect('AS')
impl = (SQLString.consume(lex) or
lex.error('Expected Javascript code'))
# SQL-expression
else:
lex.expect('AS')
impl = SQLExpr.parse(lex)
comments.extend(lex.get_comments())
return SQLFunction(name, SQLNodeList(params),
rtype, impl, comments)