| import sqlite3 | |
| import app | |
| print(f"DB PATH is: {app.DB_PATH}") | |
| conn = sqlite3.connect(app.DB_PATH) | |
| conn.row_factory = sqlite3.Row | |
| c = conn.cursor() | |
| c.execute("SELECT id, url, status, mode, error FROM jobs WHERE status='failed' ORDER BY id DESC LIMIT 5") | |
| rows = c.fetchall() | |
| for r in rows: | |
| print(f"--- JOB {r['id']} ({r['mode']}) ---") | |
| print(f"URL: {r['url']}") | |
| print(f"ERROR: {r['error']}") | |
| print("") | |