{
"event": "PreToolUse",
"tool_name": "Read",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeAnalysisRepository.php",
"limit": 100
}
}
{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/CodeAnalysisRepository.php",
"content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Code-Analyse-Ergebnisse\n\nuse Domain\\Repository\\CodeAnalysisRepositoryInterface;\nuse PDO;\n\nclass CodeAnalysisRepository implements CodeAnalysisRepositoryInterface\n{\n private PDO $pdo;\n\n public function __construct(PDO $pdo)\n {\n $this->pdo = $pdo;\n }\n\n \/**\n * @param array<string, mixed> $filters\n * @return array<array<string, mixed>>\n *\/\n public function findAll(array $filters = [], int $limit = 100, int $offset = 0): array\n {\n $sql = 'SELECT * FROM code_analysis WHERE 1=1';\n $params = [];\n\n if (!empty($filters['scan_id'])) {\n $sql .= ' AND scan_id = :scan_id';\n $params['scan_id'] = $filters['scan_id'];\n }\n\n if (!empty($filters['directory'])) {\n $sql .= ' AND directory = :directory';\n $params['directory'] = $filters['directory'];\n }\n\n if (!empty($filters['namespace'])) {\n $sql .= ' AND namespace = :namespace';\n $params['namespace'] = $filters['namespace'];\n }\n\n if (!empty($filters['extension'])) {\n $sql .= ' AND extension = :extension';\n $params['extension'] = $filters['extension'];\n }\n\n if (!empty($filters['search'])) {\n $sql .= ' AND (file_name LIKE :search OR namespace LIKE :search2)';\n $params['search'] = '%' . $filters['search'] . '%';\n $params['search2'] = '%' . $filters['search'] . '%';\n }\n\n if (isset($filters['has_classes']) && $filters['has_classes'] !== '') {\n if ($filters['has_classes'] === '1') {\n $sql .= \" AND classes IS NOT NULL AND classes != '[]'\";\n } else {\n $sql .= \" AND (classes IS NULL OR classes = '[]')\";\n }\n }\n\n if (isset($filters['has_error']) && $filters['has_error'] === '1') {\n $sql .= ' AND parse_error IS NOT NULL';\n }\n\n $sql .= ' ORDER BY directory, file_name LIMIT :limit OFFSET :offset';\n\n $stmt = $this->pdo->prepare($sql);\n foreach ($params as $key => $value) {\n $stmt->bindValue(':' . $key, $value);\n }\n $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);\n $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);\n $stmt->execute();\n\n return $stmt->fetchAll(PDO::FETCH_ASSOC);\n }\n\n \/**\n * @return array<string, mixed>|null\n *\/\n public function findById(int $id): ?array\n {\n $stmt = $this->pdo->prepare('SELECT * FROM code_analysis WHERE id = :id');\n $stmt->execute(['id' => $id]);\n $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n return $result ?: null;\n }\n\n \/**\n * @param array<array<string, mixed>> $items\n *\/\n public function saveBatch(array $items, string $scanId): int\n {\n if (empty($items)) {\n return 0;\n }",
"numLines": 100,
"startLine": 1,
"totalLines": 453
}
}
}