check_json_posts.py

import app
conn = app.get_db()
rows = conn.execute("SELECT id, source_url FROM posts WHERE source_url LIKE '%{%'").fetchall()
if not rows:
    print("NO POSTS FOUND WITH JSON IN SOURCE_URL")
else:
    for r in rows:
        print(f"[{r['id']}] {r['source_url']}")
conn.close()