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
|
import pytest
from sqlfmt.mode import Mode
from sqlfmt.node_manager import NodeManager
from sqlfmt.tokens import Token, TokenType
from tests.util import read_test_data
@pytest.fixture
def node_manager(default_mode: Mode) -> NodeManager:
return NodeManager(default_mode.dialect.case_sensitive_names)
@pytest.mark.parametrize(
"token,result", [("between", True), ("BETWEEN", True), ("like", False)]
)
def test_is_the_between_operator(
token: str, result: bool, node_manager: NodeManager
) -> None:
t = Token(
type=TokenType.WORD_OPERATOR,
prefix="",
token=token,
spos=0,
epos=7,
)
n = node_manager.create_node(t, previous_node=None)
assert n.is_the_between_operator is result
@pytest.mark.parametrize(
"source_string,node_index,result",
[
("my_array[0]", 1, True),
("my_dict['my_key']", 1, True),
("my_dict['my_key']['my_nested_key']", 4, True),
("foo, bar[0]", 3, True),
("foo, [0]", 2, False),
("foo, ['a', 'b', 'c']", 2, False),
("foo, [1 + foo]", 2, False),
('"my_quoted_array"[1]', 1, True),
("my_array_func()[0]", 3, True),
("[", 0, False),
("[1, 2]", 0, False),
("[1, 2][0]", 5, True),
],
)
def test_is_square_bracket_operator(
source_string: str, node_index: int, result: bool, default_mode: Mode
) -> None:
q = default_mode.dialect.initialize_analyzer(
line_length=default_mode.line_length
).parse_query(source_string=source_string)
n = q.nodes[node_index]
assert n.value == "[" # just to make sure our index is right
assert n.is_bracket_operator is result
@pytest.mark.parametrize(
"source_string,node_index,result",
[
("foo(0)", 1, False),
("struct<a int64, b int64>(1, 2)", 7, True),
],
)
def test_is_paren_bracket_operator(
source_string: str, node_index: int, result: bool, default_mode: Mode
) -> None:
q = default_mode.dialect.initialize_analyzer(
line_length=default_mode.line_length
).parse_query(source_string=source_string)
n = q.nodes[node_index]
assert n.value == "(" # just to make sure our index is right
assert n.is_bracket_operator is result
def test_is_the_and_after_the_between_operator(default_mode: Mode) -> None:
source_string, _ = read_test_data(
"unit_tests/test_node/test_is_the_and_after_the_between_operator.sql"
)
q = default_mode.dialect.initialize_analyzer(
line_length=default_mode.line_length
).parse_query(source_string=source_string)
and_nodes = [
node for node in q.nodes if node.token.type is TokenType.BOOLEAN_OPERATOR
]
other_nodes = [
node for node in q.nodes if node.token.type is not TokenType.BOOLEAN_OPERATOR
]
boolean_ands = and_nodes[::2]
between_ands = and_nodes[1::2]
assert all([not n.is_the_and_after_the_between_operator for n in boolean_ands])
assert all([n.is_the_and_after_the_between_operator for n in between_ands])
assert all([not n.is_the_and_after_the_between_operator for n in other_nodes])
|
