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
|
"""Test using sqlfluff to extract elements of queries."""
import sqlfluff
from sqlfluff.core.linter import RuleTuple
def test__api__info_dialects():
"""Basic linting of dialects."""
dialects = sqlfluff.list_dialects()
assert isinstance(dialects, list)
# Turn it into a dict so we can look for items in there.
dialect_dict = {dialect.label: dialect for dialect in dialects}
# Check the ansi dialect works
assert "ansi" in dialect_dict
ansi = dialect_dict["ansi"]
assert ansi.label == "ansi"
assert ansi.name == "ANSI"
assert ansi.inherits_from == "nothing"
assert "This is the base dialect" in ansi.docstring
# Check one other works
assert "postgres" in dialect_dict
postgres = dialect_dict["postgres"]
assert postgres.label == "postgres"
assert postgres.name == "PostgreSQL"
assert postgres.inherits_from == "ansi"
assert "this is often the dialect to use" in postgres.docstring
def test__api__info_rules():
"""Basic linting of dialects."""
rules = sqlfluff.list_rules()
assert isinstance(rules, list)
assert (
RuleTuple(
code="LT01",
name="layout.spacing",
description="Inappropriate Spacing.",
groups=("all", "core", "layout"),
aliases=(
"L001",
"L005",
"L006",
"L008",
"L023",
"L024",
"L039",
"L048",
"L071",
),
)
in rules
)
|
