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
|
"""Tests the python routines within AL04."""
import sqlfluff
def test__rules__std_AL04_one_aliases_one_duplicate():
"""Verify correct error message for one duplicate table aliases occur one times."""
sql = """
SELECT
a.pk
FROM table_1 AS a
JOIN table_2 AS a ON a.pk = a.pk
"""
result = sqlfluff.lint(sql)
assert "AL04" in [r["code"] for r in result]
assert [r["code"] for r in result].count("AL04") == 1
def test__rules__std_AL04_one_aliases_two_duplicate():
"""Verify correct error message for one duplicate table aliases occur two times."""
sql = """
SELECT
a.pk
FROM table_1 AS a
JOIN table_2 AS a ON a.pk = a.pk
JOIN table_3 AS a ON a.pk = a.pk
"""
result = sqlfluff.lint(sql)
result_filter = [r for r in result if r["code"] == "AL04"]
# Error message only show two times, not three
assert len(result_filter) == 2
assert (
len(
[
r
for r in result_filter
if "Duplicate table alias 'a'" in r["description"]
]
)
== 2
)
# Test specific line number
assert result_filter[0]["start_line_no"] == 5
assert result_filter[1]["start_line_no"] == 6
def test__rules__std_AL04_complex():
"""Verify that AL04 returns the correct error message for complex example."""
sql = """
SELECT
a.pk,
b.pk
FROM table_1 AS a
JOIN table_2 AS a ON a.pk = a.pk
JOIN table_3 AS b ON a.pk = b.pk
JOIN table_4 AS b ON b.pk = b.pk
JOIN table_5 AS a ON b.pk = a.pk
"""
result = sqlfluff.lint(sql)
result_filter = [r for r in result if r["code"] == "AL04"]
# Error message only show two times, not three
assert len(result_filter) == 3
assert (
len(
[
r
for r in result_filter
if "Duplicate table alias 'a'" in r["description"]
]
)
== 2
)
assert (
len(
[
r
for r in result_filter
if "Duplicate table alias 'b'" in r["description"]
]
)
== 1
)
# Test specific line number
assert result_filter[0]["start_line_no"] == 6
assert result_filter[1]["start_line_no"] == 8
assert result_filter[2]["start_line_no"] == 9
|
