squawk-parser 2.65.0

Linter for Postgres migrations & SQL
Documentation 
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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148

---
source: crates/squawk_parser/tests/tests.rs
input_file: crates/squawk_parser/tests/data/err/set.sql
---
SOURCE_FILE
  COMMENT "-- zone_value is a single value, not a list"
  WHITESPACE "\n"
  SET
    SET_KW "set"
    WHITESPACE " "
    SET_TIME_ZONE
      TIME_KW "time"
      WHITESPACE " "
      ZONE_KW "zone"
      WHITESPACE " "
      LITERAL
        STRING "'a'"
  ERROR
    COMMA ","
  WHITESPACE " "
  ERROR
    STRING "'b'"
  EMPTY_STMT
    SEMICOLON ";"
  WHITESPACE "\n\n"
  COMMENT "-- zone_value doesn't allow arbitrary expressions"
  WHITESPACE "\n"
  SET
    SET_KW "set"
    WHITESPACE " "
    SET_TIME_ZONE
      TIME_KW "time"
      WHITESPACE " "
      ZONE_KW "zone"
      WHITESPACE " "
      CONFIG_VALUE_NAME
        IDENT "now"
  ERROR
    L_PAREN "("
  ERROR
    R_PAREN ")"
  EMPTY_STMT
    SEMICOLON ";"
  WHITESPACE "\n\n"
  COMMENT "-- zone_value doesn't accept NULL"
  WHITESPACE "\n"
  SET
    SET_KW "set"
    WHITESPACE " "
    SET_TIME_ZONE
      TIME_KW "time"
      WHITESPACE " "
      ZONE_KW "zone"
  WHITESPACE " "
  ERROR
    NULL_KW "null"
  EMPTY_STMT
    SEMICOLON ";"
  WHITESPACE "\n\n"
  COMMENT "-- configuration value lists cannot have a trailing comma"
  WHITESPACE "\n"
  SET
    SET_KW "set"
    WHITESPACE " "
    SET_CONFIG
      CONFIG_PARAMETER_REF
        PATH_REF
          PATH_SEGMENT_REF
            IDENT "s"
      TO_CONFIG_VALUE
        EQ "="
        LITERAL
          STRING "''"
        COMMA ","
        CONFIG_VALUE_NAME
          IDENT "F"
        COMMA ","
        LITERAL
          STRING "''''"
        COMMA ","
    SEMICOLON ";"
  WHITESPACE "\n\n"
  SET
    SET_KW "set"
    WHITESPACE " "
    SET_CONFIG
      CONFIG_PARAMETER_REF
        PATH_REF
          PATH_SEGMENT_REF
            IDENT "c"
      TO_CONFIG_VALUE
        EQ "="
        LITERAL
          STRING "''"
        COMMA ","
    SEMICOLON ";"
  WHITESPACE "\n\n"
  SET
    SET_KW "set"
    WHITESPACE " "
    SET_CONFIG
      CONFIG_PARAMETER_REF
        PATH_REF
          PATH_SEGMENT_REF
            IDENT "m"
      TO_CONFIG_VALUE
        EQ "="
        LITERAL
          INT_NUMBER "2"
        COMMA ","
  WHITESPACE "\n"
---
error[syntax-error]: expected command, found COMMA
  ╭▸ 
2 │ set time zone 'a', 'b';
  ╰╴                 ━
error[syntax-error]: expected command, found STRING
  ╭▸ 
2 │ set time zone 'a', 'b';
  ╰╴                   ━
error[syntax-error]: expected command, found L_PAREN
  ╭▸ 
5 │ set time zone now();
  ╰╴                 ━
error[syntax-error]: expected command, found R_PAREN
  ╭▸ 
5 │ set time zone now();
  ╰╴                  ━
error[syntax-error]: expected time zone value, got NULL_KW
  ╭▸ 
8 │ set time zone null;
  ╰╴             ━
error[syntax-error]: expected command, found NULL_KW
  ╭▸ 
8 │ set time zone null;
  ╰╴              ━
error[syntax-error]: expected config value after comma
   ╭▸ 
11 │ set s='',F,'''',;
   ╰╴                ━
error[syntax-error]: expected config value after comma
   ╭▸ 
13 │ set c='',;
   ╰╴         ━
error[syntax-error]: expected config value after comma
   ╭▸ 
15 │ set m=2,
   ╰╴        ━