{
"event": "PreToolUse",
"tool_name": "Bash",
"tool_input": {
"command": "source \/var\/www\/dev.campus.systemische-tools.de\/.env && export DB_PASSWORD=\"$MARIADB_ROOT_PASSWORD\" && .\/venv\/bin\/python -c \"\nfrom db import db\ndb.connect()\n\n# Neuestes Dokument\ncursor = db.execute('''\n SELECT d.id, d.filename, d.status, d.file_type,\n (SELECT COUNT(*) FROM chunks WHERE document_id = d.id) as chunk_count,\n (SELECT COUNT(*) FROM chunks WHERE document_id = d.id AND qdrant_id IS NOT NULL) as embedded\n FROM documents d \n ORDER BY d.created_at DESC \n LIMIT 1\n''')\ndoc = cursor.fetchone()\ncursor.close()\n\nprint('Neuestes Dokument:')\nprint(f' ID: {doc[\\\"id\\\"]}')\nprint(f' Name: {doc[\\\"filename\\\"]}')\nprint(f' Status: {doc[\\\"status\\\"]}')\nprint(f' Chunks: {doc[\\\"chunk_count\\\"]} ({doc[\\\"embedded\\\"]} embedded)')\n\n# Gesamtstatistik\ncursor = db.execute('SELECT COUNT(*) as cnt FROM documents')\ndoc_count = cursor.fetchone()['cnt']\ncursor.close()\n\ncursor = db.execute('SELECT COUNT(*) as cnt FROM chunks')\nchunk_count = cursor.fetchone()['cnt']\ncursor.close()\n\ncursor = db.execute('SELECT COUNT(*) as cnt FROM chunks WHERE qdrant_id IS NOT NULL')\nembedded_count = cursor.fetchone()['cnt']\ncursor.close()\n\nprint()\nprint('Gesamtstatistik:')\nprint(f' Dokumente: {doc_count}')\nprint(f' Chunks: {chunk_count} ({embedded_count} embedded)')\n\ndb.disconnect()\n\"",
"description": "Check document and chunk stats"
}
}