{
"event": "PreToolUse",
"tool_name": "Bash",
"tool_input": {
"command": "DB_PASSWORD=\"v8mFLmkF2fth_r\" .\/venv\/bin\/python -c \"\nfrom db import db\ndb.connect()\n\ndoc_id = 12\n\n# Get chunk IDs first\ncursor = db.execute('SELECT id FROM chunks WHERE document_id = %s', (doc_id,))\nchunk_ids = [r['id'] for r in cursor.fetchall()]\ncursor.close()\n\nprint(f'Lösche Daten für {len(chunk_ids)} Chunks...')\n\nif chunk_ids:\n placeholders = ','.join(['%s'] * len(chunk_ids))\n \n # Delete in correct FK order\n db.execute(f'DELETE FROM chunk_text_semantics WHERE chunk_id IN ({placeholders})', chunk_ids)\n db.execute(f'DELETE FROM chunk_semantics WHERE chunk_id IN ({placeholders})', chunk_ids)\n db.execute(f'DELETE FROM chunk_entities WHERE chunk_id IN ({placeholders})', chunk_ids)\n db.execute(f'DELETE FROM chunk_taxonomy WHERE chunk_id IN ({placeholders})', chunk_ids)\n db.execute(f'DELETE FROM chunks WHERE document_id = %s', (doc_id,))\n\n# Delete document related\ndb.execute('DELETE FROM document_pages WHERE document_id = %s', (doc_id,))\ndb.execute('DELETE FROM document_taxonomy WHERE document_id = %s', (doc_id,))\n\n# Reset document\ndb.execute('UPDATE documents SET status = %s WHERE id = %s', ('pending', doc_id))\n\ndb.commit()\nprint('✓ Document 12 zurückgesetzt')\n\ndb.disconnect()\n\"",
"description": "Reset document with proper FK order"
}
}
{
"tool_response": {
"stdout": "Lösche Daten für 16 Chunks...\n✓ Document 12 zurückgesetzt",
"stderr": "",
"interrupted": false,
"isImage": false
}
}