#!/usr/bin/env python3 """Prevent a mismatch between SQL placeholders and parameter tuple in worker result persistence.""" import ast from pathlib import Path import re source = (Path(__file__).resolve().parents[1] / "app" / "jobs.py").read_text(encoding="utf-8") tree = ast.parse(source) fn = next(x for x in tree.body if isinstance(x, ast.FunctionDef) and x.name == "publish_result") matches = [] for node in ast.walk(fn): if not isinstance(node, ast.Call) or not isinstance(node.func, ast.Attribute): continue if node.func.attr != "execute" or len(node.args) < 2: continue if not isinstance(node.args[0], ast.Constant) or not isinstance(node.args[0].value, str): continue sql = node.args[0].value if "INSERT INTO attachment_variants" not in sql: continue assert isinstance(node.args[1], ast.Tuple), "Expected literal parameters tuple" placeholders = sql.count("%s") params = len(node.args[1].elts) columns_match = re.search(r"INSERT INTO attachment_variants\s*\(([^)]*)\)", sql, re.I | re.S) assert columns_match, "Columns missing in INSERT" columns = len(columns_match.group(1).split(",")) assert placeholders == columns == params, f"SQL mismatch: {columns} columns, {placeholders} placeholders, {params} parameters" matches.append((columns, placeholders, params)) assert len(matches) == 1, "Expected exactly one attachment_variants INSERT" print("PASS: attachment_variants INSERT has 9 columns, 9 placeholders, 9 arguments")