diff options
| -rw-r--r-- | apps/codestyle/codestyle-sql.py | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/apps/codestyle/codestyle-sql.py b/apps/codestyle/codestyle-sql.py index 1bb98e037b..703607c128 100644 --- a/apps/codestyle/codestyle-sql.py +++ b/apps/codestyle/codestyle-sql.py @@ -216,12 +216,18 @@ def backtick_check(file: io, file_path: str) -> None: quote_pattern = re.compile(r"'(?:\\'|[^'])*'|\"(?:\\\"|[^\"])*\"") for line_number, line in enumerate(file, start=1): + # Ignore comments + if line.startswith('--'): + continue + + # Sanitize single- and doublequotes to prevent false positives sanitized_line = quote_pattern.sub('', line) matches = pattern.findall(sanitized_line) for clause, content in matches: words = re.findall(r'\b[a-zA-Z_][a-zA-Z0-9_]*\b', content) for word in words: + # Skip SQL keywords if word.upper() in {"SELECT", "FROM", "JOIN", "WHERE", "GROUP", "BY", "ORDER", "DELETE", "UPDATE", "INSERT", "INTO", "SET", "VALUES", "AND", "IN", "OR", "REPLACE"}: |