from pathlib import Path
p=Path('/opt/struktur/social-media-agent/publish_ready.py'); s=p.read_text()
old='''        item["media_status"] = media_status_label(item)
        result.append(item)'''
new='''        carousel_row = con.execute("SELECT * FROM carousels WHERE package_id=? ORDER BY created_at DESC LIMIT 1", (item["package_id"],)).fetchone()
        if carousel_row:
            carousel = dict(carousel_row)
            carousel["slides"] = [dict(v) for v in con.execute("SELECT * FROM carousel_slides WHERE carousel_id=? ORDER BY slide_number", (carousel["carousel_id"],)).fetchall()]
            item["carousel"] = carousel
        else:
            item["carousel"] = None
        item["media_status"] = media_status_label(item)
        result.append(item)'''
assert s.count(old)==1; s=s.replace(old,new); p.write_text(s); print('carousel added to package read model')