{
"event": "PreToolUse",
"tool_name": "Bash",
"tool_input": {
"command": ".\/venv\/bin\/python << 'EOF'\nimport sys\nimport json\nsys.path.insert(0, '\/var\/www\/scripts\/pipeline')\nfrom config import get_db_password\nimport mysql.connector\n\nconn = mysql.connector.connect(host='localhost', database='ki_content', user='root', password=get_db_password())\ncursor = conn.cursor(dictionary=True)\n\n# Get critique results for order 35\ncursor.execute(\"\"\"\n SELECT cr.*, c.name as critic_name\n FROM critique_results cr\n JOIN critics c ON cr.critic_id = c.id\n WHERE cr.version_id = (\n SELECT id FROM content_versions WHERE order_id = 35 ORDER BY version_number DESC LIMIT 1\n )\n ORDER BY cr.created_at DESC\n\"\"\")\nresults = cursor.fetchall()\ncursor.close()\nconn.close()\n\nprint(f\"=== CRITIQUE ERGEBNISSE (Order #35, Version 8) ===\\n\")\nprint(f\"Anzahl: {len(results)} Kritiker\\n\")\n\nfor r in results:\n name = r['critic_name']\n score = r['score']\n status = '✓' if score and score >= 7 else '✗' if score else '?'\n print(f\"{status} {name}: {score}\/10\")\n \n feedback = r.get('feedback', '')\n if feedback:\n # Parse feedback if JSON\n try:\n fb = json.loads(feedback)\n if isinstance(fb, dict):\n for k, v in fb.items():\n print(f\" {k}: {v}\")\n except:\n lines = feedback.strip().split('\\n')\n for line in lines[:6]:\n print(f\" {line}\")\n print()\n\n# Calculate average\nif results:\n scores = [r['score'] for r in results if r['score']]\n if scores:\n avg = sum(scores) \/ len(scores)\n print(f\"{'='*40}\")\n print(f\"DURCHSCHNITT: {avg:.1f}\/10\")\nEOF\n",
"description": "Get critique results from DB"
}
}