"""Injection checks: SQL built from input, raw ORM escapes, dynamic SQL, PostgREST filters, NoSQL operators, a shell into a DB tool.""" import re from .common import Rule, blank_comments, code_files, dedupe_lines, hits DOMAIN = "injection" JS_EXTS = (".ts", ".tsx", ".js", ".jsx", ".mjs", ".cjs", ".vue", ".svelte", ".astro") SQL_EXTS = (".sql", ".pgsql", ".plpgsql") GAP = r"[^'\"`]{0,200}" STMT = ( rf"(?:select\b{GAP}\bfrom\b{GAP}\b(?:where|join|limit|order\s+by" rf"|group\s+by)\b|select\s+\*\s+from\b" rf"|insert\s+into\s+[\w.\"]+{GAP}\b(?:values|select)\b" r"|insert\s+into\s+[\w.\"]+\s*\(|update\s+[\w.\"]+\s+set\b" r"|delete\s+from\s+[\w.\"]+\s+where\b" r"|\bwhere\s+[\w.\"]+\s*(?:=|like\b|in\b|<|>)" r"|create\s+(?:table|index)\s|drop\s+(?:table|index)\s" r"|alter\s+table\s|truncate\s+table\s)") DQ = r"[^\"\n]{0,200}" SQ = r"[^'\n]{0,200}" def _quoted(tail): """A double- or single-quoted SQL statement string followed by tail.""" return rf"\"{DQ}?{STMT}{DQ}\"{tail}|'{SQ}?{STMT}{SQ}'{tail}" CONCAT = { JS_EXTS: re.compile( rf"(?])`[^`]{{0,400}}?{STMT}[^`]{{0,400}}?\$\{{|" + _quoted(r"\s*\+\s*[\w$(]"), re.I), (".py",): re.compile( rf"\b(?:rf|fr|f)['\"][^'\"\n]{{0,200}}?{STMT}" rf"|\b(?:rf|fr|f)(?:\"\"\"|''')\s{{0,40}}{STMT}|" + _quoted(r"\s*(?:%\s*[\w(]|\.format\(|\+\s*[\w(])"), re.I), (".php",): re.compile( rf"\"{DQ}?{STMT}{DQ}\$[A-Za-z_]\w*|" + _quoted(r"\s*\.\s*\$[A-Za-z_]"), re.I), (".rb",): re.compile( rf"\"{DQ}?{STMT}{DQ}#\{{|\.where\(\s*\"{DQ}#\{{", re.I), (".rs",): re.compile(rf"format!\(\s*\"{DQ}?{STMT}", re.I), (".go",): re.compile( rf"fmt\.Sprintf\(\s*(?:\"{DQ}?{STMT}|`\s{{0,40}}{STMT})", re.I), } RAW = { JS_EXTS: re.compile( r"(?:\$queryRawUnsafe|\$executeRawUnsafe|\b(?:sql|db|trx|knex)\.raw" r"|\bsequelize\.query|\b[Ss]equelize\.literal)\s*\(\s*(?![\s'\"`)])"), (".py",): re.compile( r"\.objects\.raw\(\s*(?![\s'\"`)])|\.extra\(\s*(?![\s'\"`)])"), } SQLA_TEXT = re.compile( r"(?:(?