Protokoll #24593

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkTaxonomyRepository.php",
        "old_string": "namespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: CRUD-Operationen für Chunk-Taxonomie-Mappings\n\nuse Domain\\Entity\\ChunkTaxonomyMapping;",
        "new_string": "namespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: CRUD-Operationen für Chunk-Taxonomie-Mappings\n\nuse Domain\\Constants;\nuse Domain\\Entity\\ChunkTaxonomyMapping;"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkTaxonomyRepository.php",
        "oldString": "namespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: CRUD-Operationen für Chunk-Taxonomie-Mappings\n\nuse Domain\\Entity\\ChunkTaxonomyMapping;",
        "newString": "namespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: CRUD-Operationen für Chunk-Taxonomie-Mappings\n\nuse Domain\\Constants;\nuse Domain\\Entity\\ChunkTaxonomyMapping;",
        "originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: CRUD-Operationen für Chunk-Taxonomie-Mappings\n\nuse Domain\\Entity\\ChunkTaxonomyMapping;\nuse Domain\\Repository\\ChunkTaxonomyRepositoryInterface;\nuse PDO;\n\nfinal class ChunkTaxonomyRepository implements ChunkTaxonomyRepositoryInterface\n{\n    private PDO $db;\n\n    public function __construct(PDO $pdo)\n    {\n        $this->db = $pdo;\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function findByChunkId(int $chunkId): array\n    {\n        $stmt = $this->db->prepare(\n            'SELECT * FROM chunk_taxonomy WHERE chunk_id = :chunk_id ORDER BY confidence DESC'\n        );\n        $stmt->execute(['chunk_id' => $chunkId]);\n\n        $mappings = [];\n        foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {\n            $mappings[] = ChunkTaxonomyMapping::fromArray($row);\n        }\n\n        return $mappings;\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function findByTaxonomyTermId(int $termId): array\n    {\n        $stmt = $this->db->prepare(\n            'SELECT chunk_id, confidence, source\n             FROM chunk_taxonomy\n             WHERE taxonomy_term_id = :term_id\n             ORDER BY confidence DESC'\n        );\n        $stmt->execute(['term_id' => $termId]);\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function save(ChunkTaxonomyMapping $mapping): int\n    {\n        if ($mapping->getId() !== null) {\n            \/\/ Update\n            $stmt = $this->db->prepare(\n                'UPDATE chunk_taxonomy\n                 SET chunk_id = :chunk_id,\n                     taxonomy_term_id = :term_id,\n                     confidence = :confidence,\n                     source = :source\n                 WHERE id = :id'\n            );\n            $stmt->execute([\n                'id' => $mapping->getId(),\n                'chunk_id' => $mapping->getChunkId(),\n                'term_id' => $mapping->getTaxonomyTermId(),\n                'confidence' => $mapping->getConfidence()->value(),\n                'source' => $mapping->getSource()->value,\n            ]);\n\n            return $mapping->getId();\n        }\n\n        \/\/ Insert\n        $stmt = $this->db->prepare(\n            'INSERT INTO chunk_taxonomy (chunk_id, taxonomy_term_id, confidence, source, created_at)\n             VALUES (:chunk_id, :term_id, :confidence, :source, :created_at)'\n        );\n        $stmt->execute([\n            'chunk_id' => $mapping->getChunkId(),\n            'term_id' => $mapping->getTaxonomyTermId(),\n            'confidence' => $mapping->getConfidence()->value(),\n            'source' => $mapping->getSource()->value,\n            'created_at' => $mapping->getCreatedAt()->format('Y-m-d H:i:s'),\n        ]);\n\n        return (int) $this->db->lastInsertId();\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function delete(int $id): bool\n    {\n        $stmt = $this->db->prepare('DELETE FROM chunk_taxonomy WHERE id = :id');\n\n        return $stmt->execute(['id' => $id]);\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function deleteByChunkId(int $chunkId): int\n    {\n        $stmt = $this->db->prepare('DELETE FROM chunk_taxonomy WHERE chunk_id = :chunk_id');\n        $stmt->execute(['chunk_id' => $chunkId]);\n\n        return $stmt->rowCount();\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function getUnmappedChunks(int $limit = 100): array\n    {\n        $stmt = $this->db->prepare(\n            'SELECT c.id, c.document_id, SUBSTRING(c.content, 1, 500) as content\n             FROM chunks c\n             LEFT JOIN chunk_taxonomy ct ON c.id = ct.chunk_id\n             WHERE ct.id IS NULL\n               AND c.status = \"embedded\"\n             LIMIT :limit'\n        );\n        $stmt->bindValue('limit', $limit, PDO::PARAM_INT);\n        $stmt->execute();\n\n        return $stmt->fetchAll(PDO::FETCH_ASSOC);\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function exists(int $chunkId, int $taxonomyTermId): bool\n    {\n        $stmt = $this->db->prepare(\n            'SELECT COUNT(*) FROM chunk_taxonomy\n             WHERE chunk_id = :chunk_id AND taxonomy_term_id = :term_id'\n        );\n        $stmt->execute([\n            'chunk_id' => $chunkId,\n            'term_id' => $taxonomyTermId,\n        ]);\n\n        return (int) $stmt->fetchColumn() > 0;\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function countByTaxonomyTerm(): array\n    {\n        $stmt = $this->db->query(\n            'SELECT taxonomy_term_id, COUNT(*) as count\n             FROM chunk_taxonomy\n             GROUP BY taxonomy_term_id'\n        );\n\n        $counts = [];\n        foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {\n            $counts[(int) $row['taxonomy_term_id']] = (int) $row['count'];\n        }\n\n        return $counts;\n    }\n}\n",
        "structuredPatch": [
            {
                "oldStart": 6,
                "oldLines": 6,
                "newStart": 6,
                "newLines": 7,
                "lines": [
                    " ",
                    " \/\/ @responsibility: CRUD-Operationen für Chunk-Taxonomie-Mappings",
                    " ",
                    "+use Domain\\Constants;",
                    " use Domain\\Entity\\ChunkTaxonomyMapping;",
                    " use Domain\\Repository\\ChunkTaxonomyRepositoryInterface;",
                    " use PDO;"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}