from pathlib import Path
p=Path('/opt/struktur/social-media-agent/app.py')
s=p.read_text()
old='''        elif sort == "linkedin":
            platform_clause = (
                "AND COALESCE(mas_relevant,0)=1 AND (COALESCE(platform_linkedin,1)>=2 "
                "OR lower(COALESCE(briefing_li_fit,'')) IN ('ja','pruefen') "
                "OR " + platform_expr + " = 'linkedin' OR source_type = 'linkedin')"
            )
'''
new='''        elif sort == "linkedin":
            # LinkedIn ist Zielplattform: Provenienz darf keine Eignung ersetzen.
            platform_clause = (
                "AND COALESCE(mas_relevant,0)=1 AND "
                "(COALESCE(platform_linkedin,1)>=2 "
                "OR lower(COALESCE(briefing_li_fit,'')) IN ('ja','pruefen'))"
            )
'''
assert old in s
p.write_text(s.replace(old,new))