Protokoll #17485

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php",
        "old_string": "    \/**\n     * {@inheritDoc}\n     *\/\n    public function getSemanticStats(): array\n    {\n        return $this->db->query(\n            'SELECT\n                (SELECT COUNT(*) FROM entities) as entities,\n                (SELECT COUNT(*) FROM entity_relations) as relations,\n                (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,\n                (SELECT COUNT(*) FROM ontology_classes) as ontology,\n                (SELECT COUNT(*) FROM chunk_semantics) as semantics'\n        )->fetch();\n    }",
        "new_string": "    \/**\n     * {@inheritDoc}\n     *\/\n    public function getSemanticStats(): array\n    {\n        return $this->db->query(\n            'SELECT\n                (SELECT COUNT(*) FROM entities) as entities,\n                (SELECT COUNT(*) FROM entity_relations) as relations,\n                (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,\n                (SELECT COUNT(*) FROM ontology_classes) as ontology,\n                (SELECT COUNT(*) FROM chunk_semantics) as semantics,\n                (SELECT COUNT(*) FROM entities) as total,\n                (SELECT COUNT(DISTINCT type) FROM entities) as types,\n                (SELECT COUNT(DISTINCT chunk_id) FROM chunk_entities) as linked_chunks,\n                (SELECT COUNT(DISTINCT c.document_id) FROM chunk_entities ce JOIN chunks c ON ce.chunk_id = c.id) as linked_docs'\n        )->fetch();\n    }"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php",
        "oldString": "    \/**\n     * {@inheritDoc}\n     *\/\n    public function getSemanticStats(): array\n    {\n        return $this->db->query(\n            'SELECT\n                (SELECT COUNT(*) FROM entities) as entities,\n                (SELECT COUNT(*) FROM entity_relations) as relations,\n                (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,\n                (SELECT COUNT(*) FROM ontology_classes) as ontology,\n                (SELECT COUNT(*) FROM chunk_semantics) as semantics'\n        )->fetch();\n    }",
        "newString": "    \/**\n     * {@inheritDoc}\n     *\/\n    public function getSemanticStats(): array\n    {\n        return $this->db->query(\n            'SELECT\n                (SELECT COUNT(*) FROM entities) as entities,\n                (SELECT COUNT(*) FROM entity_relations) as relations,\n                (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,\n                (SELECT COUNT(*) FROM ontology_classes) as ontology,\n                (SELECT COUNT(*) FROM chunk_semantics) as semantics,\n                (SELECT COUNT(*) FROM entities) as total,\n                (SELECT COUNT(DISTINCT type) FROM entities) as types,\n                (SELECT COUNT(DISTINCT chunk_id) FROM chunk_entities) as linked_chunks,\n                (SELECT COUNT(DISTINCT c.document_id) FROM chunk_entities ce JOIN chunks c ON ce.chunk_id = c.id) as linked_docs'\n        )->fetch();\n    }",
        "originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Semantik-Suche und Graph-Daten für Semantic Explorer\n\nuse Domain\\Repository\\SemanticSearchRepositoryInterface;\nuse PDO;\n\nfinal class SemanticSearchRepository implements SemanticSearchRepositoryInterface\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 getSemanticStats(): array\n    {\n        return $this->db->query(\n            'SELECT\n                (SELECT COUNT(*) FROM entities) as entities,\n                (SELECT COUNT(*) FROM entity_relations) as relations,\n                (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,\n                (SELECT COUNT(*) FROM ontology_classes) as ontology,\n                (SELECT COUNT(*) FROM chunk_semantics) as semantics'\n        )->fetch();\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function findEntitySemantics(string $search = '', string $type = '', int $limit = 50, int $offset = 0): array\n    {\n        \/\/ Deduplicated entities with aggregated chunk\/document counts\n        $sql = 'SELECT e.id, e.name, e.canonical_name, e.type, e.description, e.status,\n                       COUNT(DISTINCT ce.chunk_id) as chunk_count,\n                       COUNT(DISTINCT c.document_id) as document_count,\n                       MIN(ce.chunk_id) as first_chunk_id,\n                       MIN(d.filename) as first_filename,\n                       MIN(d.id) as first_document_id\n                FROM entities e\n                LEFT JOIN chunk_entities ce ON e.id = ce.entity_id\n                LEFT JOIN chunks c ON ce.chunk_id = c.id\n                LEFT JOIN documents d ON c.document_id = d.id\n                WHERE 1=1';\n\n        $params = [];\n\n        if ($search !== '') {\n            $sql .= ' AND (e.name LIKE :search OR e.description LIKE :search2 OR e.canonical_name LIKE :search3)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n            $params['search3'] = '%' . $search . '%';\n        }\n\n        if ($type !== '') {\n            $sql .= ' AND e.type = :type';\n            $params['type'] = $type;\n        }\n\n        $sql .= ' GROUP BY e.id, e.name, e.canonical_name, e.type, e.description, e.status';\n        $sql .= ' ORDER BY e.name LIMIT ' . $limit . ' OFFSET ' . $offset;\n\n        $stmt = $this->db->prepare($sql);\n        $stmt->execute($params);\n\n        return $stmt->fetchAll();\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function countEntitySemantics(string $search = '', string $type = ''): int\n    {\n        $sql = 'SELECT COUNT(DISTINCT e.id) FROM entities e WHERE 1=1';\n        $params = [];\n\n        if ($search !== '') {\n            $sql .= ' AND (e.name LIKE :search OR e.description LIKE :search2 OR e.canonical_name LIKE :search3)';\n            $params['search'] = '%' . $search . '%';\n            $params['search2'] = '%' . $search . '%';\n            $params['search3'] = '%' . $search . '%';\n        }\n\n        if ($type !== '') {\n            $sql .= ' AND e.type = :type';\n            $params['type'] = $type;\n        }\n\n        $stmt = $this->db->prepare($sql);\n        $stmt->execute($params);\n\n        return (int) $stmt->fetchColumn();\n    }\n\n    \/**\n     * {@inheritDoc}\n     *\/\n    public function getGraphData(): array\n    {\n        \/\/ Get all entities\n        $entities = $this->db->query(\n            'SELECT id, name, type FROM entities ORDER BY name'\n        )->fetchAll();\n\n        \/\/ Get all relations\n        $relations = $this->db->query(\n            'SELECT source_entity_id, target_entity_id, relation_type, strength\n             FROM entity_relations'\n        )->fetchAll();\n\n        \/\/ Build node index for link resolution\n        $nodeIndex = [];\n        $nodes = [];\n        foreach ($entities as $i => $entity) {\n            $nodeIndex[$entity['id']] = $i;\n            $nodes[] = [\n                'id' => 'entity_' . $entity['id'],\n                'label' => $entity['name'],\n                'type' => strtoupper($entity['type'] ?? 'OTHER'),\n                'entityId' => (int) $entity['id'],\n            ];\n        }\n\n        \/\/ Build links with index references\n        $links = [];\n        foreach ($relations as $relation) {\n            $sourceId = $relation['source_entity_id'];\n            $targetId = $relation['target_entity_id'];\n\n            \/\/ Skip if entity not found\n            if (!isset($nodeIndex[$sourceId]) || !isset($nodeIndex[$targetId])) {\n                continue;\n            }\n\n            $links[] = [\n                'source' => $nodeIndex[$sourceId],\n                'target' => $nodeIndex[$targetId],\n                'type' => $relation['relation_type'],\n                'strength' => (float) ($relation['strength'] ?? 1.0),\n            ];\n        }\n\n        \/\/ Get unique types for stats\n        $entityTypes = array_unique(array_column($nodes, 'type'));\n        $relationTypes = array_unique(array_column($links, 'type'));\n\n        return [\n            'nodes' => $nodes,\n            'links' => $links,\n            'stats' => [\n                'nodes' => count($nodes),\n                'links' => count($links),\n                'entityTypes' => count($entityTypes),\n                'relationTypes' => count($relationTypes),\n            ],\n        ];\n    }\n}\n",
        "structuredPatch": [
            {
                "oldStart": 29,
                "oldLines": 7,
                "newStart": 29,
                "newLines": 11,
                "lines": [
                    "                 (SELECT COUNT(*) FROM entity_relations) as relations,",
                    "                 (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,",
                    "                 (SELECT COUNT(*) FROM ontology_classes) as ontology,",
                    "-                (SELECT COUNT(*) FROM chunk_semantics) as semantics'",
                    "+                (SELECT COUNT(*) FROM chunk_semantics) as semantics,",
                    "+                (SELECT COUNT(*) FROM entities) as total,",
                    "+                (SELECT COUNT(DISTINCT type) FROM entities) as types,",
                    "+                (SELECT COUNT(DISTINCT chunk_id) FROM chunk_entities) as linked_chunks,",
                    "+                (SELECT COUNT(DISTINCT c.document_id) FROM chunk_entities ce JOIN chunks c ON ce.chunk_id = c.id) as linked_docs'",
                    "         )->fetch();",
                    "     }",
                    " "
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}