From acf878b309065d72786c4ec94baccc13b470a3da Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 30 Jan 2024 11:18:20 -0600 Subject: [PATCH] Require that the CREATE VIEW explicitly list column names --- doc/extract_view.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/doc/extract_view.py b/doc/extract_view.py index 9b78229..9752da9 100755 --- a/doc/extract_view.py +++ b/doc/extract_view.py @@ -22,14 +22,14 @@ the body of the view. import re # Patterns -CREATE_VIEW = re.compile(r"\s*CREATE OR REPLACE VIEW \S+ AS\s*$") +VIEW_RE = re.compile(r"\s*CREATE OR REPLACE VIEW \S+ \(\s*$") GRANT = re.compile(r"\s*GRANT ") SQL_COMMENT = re.compile(r"\s*(?:--.*)|$") def get_body(fd): """Return a list of every line between (exclusive) the line matching - CREATE_VIEW and the line matching GRANT. + VIEW_RE and the line matching GRANT. """ body = [] found = False @@ -39,7 +39,7 @@ def get_body(fd): break body.append(line) else: - found = CREATE_VIEW.match(line) is not None + found = VIEW_RE.match(line) is not None return body -- 2.34.1