| 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() | |