{
"event": "PreToolUse",
"tool_name": "Edit",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php",
"old_string": "use Domain\\Repository\\ChunkRepositoryInterface;\nuse Infrastructure\\Config\\DatabaseFactory;\nuse PDO;",
"new_string": "use Domain\\Repository\\ChunkRepositoryInterface;\nuse PDO;"
}
}
{
"tool_response": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ChunkRepository.php",
"oldString": "use Domain\\Repository\\ChunkRepositoryInterface;\nuse Infrastructure\\Config\\DatabaseFactory;\nuse PDO;",
"newString": "use Domain\\Repository\\ChunkRepositoryInterface;\nuse PDO;",
"originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: CRUD-Operationen für Text-Chunks aus Dokumenten\n\nuse Domain\\Repository\\ChunkRepositoryInterface;\nuse Infrastructure\\Config\\DatabaseFactory;\nuse PDO;\n\nfinal class ChunkRepository implements ChunkRepositoryInterface\n{\n private PDO $db;\n\n public function __construct()\n {\n $this->db = DatabaseFactory::content();\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function getStats(): array\n {\n $result = $this->db->query(\n 'SELECT\n COUNT(*) as total,\n COALESCE(SUM(token_count), 0) as tokens,\n SUM(CASE WHEN qdrant_id IS NOT NULL THEN 1 ELSE 0 END) as embedded\n FROM chunks'\n )->fetch();\n\n return $result !== false ? $result : ['total' => 0, 'tokens' => 0, 'embedded' => 0];\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function findRecent(int $limit = 5): array\n {\n $stmt = $this->db->prepare(\n 'SELECT c.id, c.content, c.token_count, c.created_at, c.qdrant_id, d.filename\n FROM chunks c\n JOIN documents d ON c.document_id = d.id\n ORDER BY c.created_at DESC\n LIMIT :limit'\n );\n $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);\n $stmt->execute();\n\n return $stmt->fetchAll();\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function findByDocument(int $documentId): array\n {\n $stmt = $this->db->prepare(\n 'SELECT c.id, c.chunk_index, c.content, c.token_count, c.heading_path,\n c.metadata, c.qdrant_id, c.created_at\n FROM chunks c\n WHERE c.document_id = :id\n ORDER BY c.chunk_index'\n );\n $stmt->execute(['id' => $documentId]);\n\n return $stmt->fetchAll();\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function findFiltered(string $search = '', string $embedded = '', int $limit = 50, int $offset = 0): array\n {\n $sql = 'SELECT c.id, c.chunk_index, c.content, c.token_count, c.qdrant_id, c.created_at,\n d.filename, d.id as document_id\n FROM chunks c\n JOIN documents d ON c.document_id = d.id\n WHERE 1=1';\n\n $params = [];\n\n if ($search !== '') {\n $sql .= ' AND c.content LIKE :search';\n $params['search'] = '%' . $search . '%';\n }\n\n if ($embedded === 'yes') {\n $sql .= ' AND c.qdrant_id IS NOT NULL';\n } elseif ($embedded === 'no') {\n $sql .= ' AND c.qdrant_id IS NULL';\n }\n\n $sql .= ' ORDER BY c.created_at DESC 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 count(string $search = '', string $embedded = ''): int\n {\n $sql = 'SELECT COUNT(*) FROM chunks c\n JOIN documents d ON c.document_id = d.id\n WHERE 1=1';\n\n $params = [];\n\n if ($search !== '') {\n $sql .= ' AND c.content LIKE :search';\n $params['search'] = '%' . $search . '%';\n }\n\n if ($embedded === 'yes') {\n $sql .= ' AND c.qdrant_id IS NOT NULL';\n } elseif ($embedded === 'no') {\n $sql .= ' AND c.qdrant_id IS NULL';\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 find(int $id): ?array\n {\n $stmt = $this->db->prepare(\n 'SELECT c.*, d.filename, d.source_path, d.id as document_id\n FROM chunks c\n JOIN documents d ON c.document_id = d.id\n WHERE c.id = :id'\n );\n $stmt->execute(['id' => $id]);\n $result = $stmt->fetch();\n\n return $result === false ? null : $result;\n }\n\n \/**\n * {@inheritDoc}\n *\/\n public function findByDocumentAndIndex(int $documentId, int $chunkIndex): ?array\n {\n $stmt = $this->db->prepare(\n 'SELECT id, chunk_index FROM chunks\n WHERE document_id = :doc_id AND chunk_index = :idx'\n );\n $stmt->execute(['doc_id' => $documentId, 'idx' => $chunkIndex]);\n $result = $stmt->fetch();\n\n return $result === false ? null : $result;\n }\n}\n",
"structuredPatch": [
{
"oldStart": 7,
"oldLines": 7,
"newStart": 7,
"newLines": 6,
"lines": [
" \/\/ @responsibility: CRUD-Operationen für Text-Chunks aus Dokumenten",
" ",
" use Domain\\Repository\\ChunkRepositoryInterface;",
"-use Infrastructure\\Config\\DatabaseFactory;",
" use PDO;",
" ",
" final class ChunkRepository implements ChunkRepositoryInterface"
]
}
],
"userModified": false,
"replaceAll": false
}
}