{
"event": "PreToolUse",
"tool_name": "Grep",
"tool_input": {
"pattern": "getSemanticStats|getStats",
"path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence",
"output_mode": "content",
"-A": 25,
"-n": true
}
}
{
"tool_response": {
"mode": "content",
"numFiles": 0,
"filenames": [],
"content": "src\/Infrastructure\/Persistence\/ChunkRepository.php:24: public function getStats(): array\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-25- {\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-26- $result = $this->db->query(\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-27- 'SELECT\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-28- COUNT(*) as total,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-29- COALESCE(SUM(token_count), 0) as tokens,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-30- SUM(CASE WHEN qdrant_id IS NOT NULL THEN 1 ELSE 0 END) as embedded\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-31- FROM chunks'\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-32- )->fetch();\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-33-\nsrc\/Infrastructure\/Persistence\/ChunkRepository.php-34- return $result !== false ? $result : ['total' => 0, 'tokens' => 0, 'embedded' => 0];\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-35- }\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-36-\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-37- \/**\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-38- * {@inheritDoc}\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-39- *\/\nsrc\/Infrastructure\/Persistence\/ChunkRepository.php-40- public function findRecent(int $limit = 5): array\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-41- {\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-42- $stmt = $this->db->prepare(\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-43- 'SELECT c.id, c.content, c.token_count, c.created_at, c.qdrant_id, d.filename\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-44- FROM chunks c\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-45- JOIN documents d ON c.document_id = d.id\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-46- ORDER BY c.created_at DESC\nsrc\/Infrastructure\/Persistence\/ChunkRepository.php-47- LIMIT :limit'\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php-48- );\nsrc\/Infrastructure\/Persistence\/ChunkRepository.php-49- $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);\n--\nsrc\/Infrastructure\/Persistence\/EntityRepository.php:58: public function getStats(): array\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-59- {\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-60- return $this->db->query(\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-61- 'SELECT type, COUNT(*) as count FROM entities GROUP BY type'\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-62- )->fetchAll();\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-63- }\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-64-\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-65- \/**\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-66- * {@inheritDoc}\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-67- *\/\nsrc\/Infrastructure\/Persistence\/EntityRepository.php-68- public function find(int $id): ?array\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-69- {\nsrc\/Infrastructure\/Persistence\/EntityRepository.php-70- $stmt = $this->db->prepare('SELECT * FROM entities WHERE id = :id');\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-71- $stmt->execute(['id' => $id]);\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-72- $result = $stmt->fetch();\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-73-\nsrc\/Infrastructure\/Persistence\/EntityRepository.php-74- return $result === false ? null : $result;\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-75- }\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-76-\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-77- \/**\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-78- * {@inheritDoc}\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-79- *\/\nsrc\/Infrastructure\/Persistence\/EntityRepository.php-80- public function findSynonyms(int $entityId): array\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-81- {\nsrc\/Infrastructure\/Persistence\/EntityRepository.php-82- $stmt = $this->db->prepare('SELECT * FROM entity_synonyms WHERE entity_id = :id');\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/EntityRepository.php-83- $stmt->execute(['id' => $entityId]);\n--\nsrc\/Infrastructure\/Persistence\/SemanticSearchRepository.php:24: public function getSemanticStats(): array\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-25- {\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-26- return $this->db->query(\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-27- 'SELECT\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-28- (SELECT COUNT(*) FROM entities) as entities,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-29- (SELECT COUNT(*) FROM entity_relations) as relations,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-30- (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-31- (SELECT COUNT(*) FROM ontology_classes) as ontology,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-32- (SELECT COUNT(*) FROM chunk_semantics) as semantics,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-33- (SELECT COUNT(*) FROM stopwords WHERE is_active = 1) as stopwords,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-34- (SELECT COUNT(*) FROM entities) as total,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-35- (SELECT COUNT(DISTINCT type) FROM entities) as types,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-36- (SELECT COUNT(DISTINCT chunk_id) FROM chunk_entities) as linked_chunks,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-37- (SELECT COUNT(DISTINCT c.document_id) FROM chunk_entities ce JOIN chunks c ON ce.chunk_id = c.id) as linked_docs'\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-38- )->fetch();\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-39- }\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-40-\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-41- \/**\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-42- * {@inheritDoc}\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-43- *\/\nsrc\/Infrastructure\/Persistence\/SemanticSearchRepository.php-44- public function findEntitySemantics(string $search = '', string $type = '', int $limit = 50, int $offset = 0): array\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-45- {\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-46- \/\/ Deduplicated entities with aggregated chunk\/document counts\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-47- $sql = 'SELECT e.id, e.name, e.canonical_name, e.type, e.description, e.status,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-48- COUNT(DISTINCT ce.chunk_id) as chunk_count,\n\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php-4... [TRUNCATED-3c61541bdbe5d8b1]",
"numLines": 215
}
}