from pathlib import Path
p=Path('/opt/struktur/social-media-agent/publish_ready.py'); s=p.read_text()
old='''        item["legacy_variants"] = [v for group in legacy_groups for v in group["variants"]]
        item["media_status"] = media_status_label(item)'''
new='''        item["legacy_variants"] = [v for group in legacy_groups for v in group["variants"]]
        brief_row = con.execute("SELECT * FROM media_briefs WHERE package_id=? ORDER BY created_at DESC LIMIT 1", (item["package_id"],)).fetchone()
        if brief_row:
            brief = dict(brief_row)
            for key in ("required_objects_json", "technical_requirements_json", "avoid_motifs_json", "avoid_technical_errors_json", "reference_assets_json", "feedback_rules_json"):
                try: brief[key.removesuffix("_json")] = json.loads(brief.pop(key))
                except (TypeError, json.JSONDecodeError): brief[key.removesuffix("_json")] = []
            item["media_brief"] = brief
        else:
            item["media_brief"] = None
        item["media_status"] = media_status_label(item)'''
assert s.count(old)==1; p.write_text(s.replace(old,new)); print('media brief added to package view')