squawk-parser 2.48.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

---
source: crates/squawk_parser/tests/tests.rs
input_file: crates/squawk_parser/tests/data/ok/do.sql
---
SOURCE_FILE
  COMMENT "-- pg_docs"
  WHITESPACE "\n"
  DO
    DO_KW "DO"
    WHITESPACE " "
    LITERAL
      DOLLAR_QUOTED_STRING "$$DECLARE r record;\nBEGIN\n    FOR r IN SELECT table_schema, table_name FROM information_schema.tables\n             WHERE table_type = 'VIEW' AND table_schema = 'public'\n    LOOP\n        EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser';\n    END LOOP;\nEND$$"
  SEMICOLON ";"
  WHITESPACE "\n\n"
  COMMENT "-- do_with_language"
  WHITESPACE "\n"
  DO
    DO_KW "do"
    WHITESPACE " "
    LANGUAGE_KW "language"
    WHITESPACE " "
    IDENT "plpgsql"
    WHITESPACE " "
    LITERAL
      STRING "'select 1'"
  SEMICOLON ";"
  WHITESPACE "\n\n"