from pathlib import Path
p=Path('/opt/struktur/social-media-agent/app.py')
s=p.read_text()
old='''            " COALESCE(action_platform,'') as action_platform,"\n'''
new='''            " COALESCE(action_platform,'') as action_platform,"\n            " COALESCE(action_platform,'') as recommended_platform,"\n'''
if old not in s: raise SystemExit('recommended alias anchor missing')
p.write_text(s.replace(old,new,1))