forked from mtusi2026/mtusi2026lab2
21 lines
958 B
Python
21 lines
958 B
Python
#!/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')
|