from pathlib import Path
p=Path('/opt/struktur/social-media-agent/app.py')
s=p.read_text()
old='''        sql = (\n            "SELECT signal_id, signal_category, source_type, source_platform, radar_score, topic, extracted_hook,"\n'''
new='''        relevance_clause = "" if sort in ("facebook", "linkedin") else (\n            " AND (mallorca_relevance > 0 OR director_action IN ('pruefen','veroeffentlichen'))"\n        )\n\n        sql = (\n            "SELECT signal_id, signal_category, source_type, source_platform, radar_score, topic, extracted_hook,"\n'''
if old not in s: raise SystemExit('sql anchor missing')
s=s.replace(old,new,1)
s=s.replace('''            " WHERE radar_score >= 31"\n            " AND (mallorca_relevance > 0 OR director_action IN ('pruefen','veroeffentlichen'))"\n            f" {date_clause}"\n''','''            " WHERE radar_score >= 31"\n            + relevance_clause\n            + f" {date_clause}"\n''',1)
p.write_text(s)