{
"event": "PreToolUse",
"tool_name": "Grep",
"tool_input": {
"pattern": "getSemanticStats",
"path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SemanticSearchRepository.php",
"output_mode": "content",
"-A": 30,
"-n": true
}
}
{
"tool_response": {
"mode": "content",
"numFiles": 0,
"filenames": [],
"content": "24: public function getSemanticStats(): array\n25- {\n26- return $this->db->query(\n27- 'SELECT\n28- (SELECT COUNT(*) FROM entities) as entities,\n29- (SELECT COUNT(*) FROM entity_relations) as relations,\n30- (SELECT COUNT(*) FROM taxonomy_terms) as taxonomy,\n31- (SELECT COUNT(*) FROM ontology_classes) as ontology,\n32- (SELECT COUNT(*) FROM chunk_semantics) as semantics,\n33- (SELECT COUNT(*) FROM stopwords WHERE is_active = 1) as stopwords,\n34- (SELECT COUNT(*) FROM entities) as total,\n35- (SELECT COUNT(DISTINCT type) FROM entities) as types,\n36- (SELECT COUNT(DISTINCT chunk_id) FROM chunk_entities) as linked_chunks,\n37- (SELECT COUNT(DISTINCT c.document_id) FROM chunk_entities ce JOIN chunks c ON ce.chunk_id = c.id) as linked_docs'\n38- )->fetch();\n39- }\n40-\n41- \/**\n42- * {@inheritDoc}\n43- *\/\n44- public function findEntitySemantics(string $search = '', string $type = '', int $limit = 50, int $offset = 0): array\n45- {\n46- \/\/ Deduplicated entities with aggregated chunk\/document counts\n47- $sql = 'SELECT e.id, e.name, e.canonical_name, e.type, e.description, e.status,\n48- COUNT(DISTINCT ce.chunk_id) as chunk_count,\n49- COUNT(DISTINCT c.document_id) as document_count,\n50- MIN(ce.chunk_id) as first_chunk_id,\n51- MIN(d.filename) as first_filename,\n52- MIN(d.id) as first_document_id\n53- FROM entities e\n54- LEFT JOIN chunk_entities ce ON e.id = ce.entity_id",
"numLines": 31
}
}