Protokoll #17804

{
    "event": "PreToolUse",
    "tool_name": "Bash",
    "tool_input": {
        "command": "cat << 'PYTHON' | DB_PASSWORD=\"v8mFLmkF2fth_r\" .\/venv\/bin\/python\nimport sys\nsys.path.insert(0, \"\/var\/www\/scripts\/pipeline\")\nfrom db import db\ndb.connect()\n\n# Lösche nur entity-bezogene Daten für Dokument 1\ndoc_id = 1\n\n# Get chunk IDs for this document\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\"Document {doc_id}: {len(chunk_ids)} chunks\")\n\nif chunk_ids:\n    placeholders = ','.join(['%s'] * len(chunk_ids))\n    \n    # Delete chunk_entities links\n    cursor = db.execute(f\"DELETE FROM chunk_entities WHERE chunk_id IN ({placeholders})\", tuple(chunk_ids))\n    print(f\"Deleted {cursor.rowcount} chunk_entities\")\n    db.commit()\n    cursor.close()\n\n# Delete document_entities links\ncursor = db.execute(\"DELETE FROM document_entities WHERE document_id = %s\", (doc_id,))\nprint(f\"Deleted {cursor.rowcount} document_entities\")\ndb.commit()\ncursor.close()\n\n# Delete orphaned entities (no links)\ncursor = db.execute(\"\"\"\n    DELETE FROM entities \n    WHERE id NOT IN (SELECT DISTINCT entity_id FROM chunk_entities)\n    AND id NOT IN (SELECT DISTINCT entity_id FROM document_entities)\n\"\"\")\nprint(f\"Deleted {cursor.rowcount} orphaned entities\")\ndb.commit()\ncursor.close()\n\n# Delete relations for deleted entities\ncursor = db.execute(\"\"\"\n    DELETE FROM entity_relations \n    WHERE source_entity_id NOT IN (SELECT id FROM entities)\n    OR target_entity_id NOT IN (SELECT id FROM entities)\n\"\"\")\nprint(f\"Deleted {cursor.rowcount} orphaned relations\")\ndb.commit()\ncursor.close()\n\n# Reset document status\ncursor = db.execute(\"UPDATE documents SET status = 'pending' WHERE id = %s\", (doc_id,))\ndb.commit()\ncursor.close()\n\nprint(\"\\nReset complete. Ready for re-processing.\")\nPYTHON",
        "description": "Reset entity data for document"
    }
}

-