#!/usr/bin/env python3 """Optional static SQL/YAML check: pip install pglast PyYAML. Does not execute SQL.""" from pathlib import Path import re import yaml from pglast import parse_sql root=Path(__file__).resolve().parents[1] for file in (root/'src/Messenger/Migrations').glob('*.sql'): parse_sql(file.read_text()) print('PASS SQL syntax:',file.name) parse_sql((root/'scripts/explain.sql').read_text()) for file in (root/'src/Messenger').rglob('*.cs'): for query in re.findall(r'"((?:SELECT|INSERT INTO|DELETE FROM|CREATE TABLE)[^"\n]+)"',file.read_text()): if not query.endswith('FROM chats c '): parse_sql(query) config=yaml.safe_load((root/'compose.yaml').read_text()) assert set(config['services'])=={'api','postgres','redis'} assert len(config['volumes'])==2 assert 'ports' not in config['services']['postgres'] assert 'ports' not in config['services']['redis'] print('PASS literal SQL and Compose YAML syntax; runtime NOT tested')