{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/PromptsRepository.php",
"content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Prompt-Templates\n\nuse Domain\\Repository\\PromptsRepositoryInterface;\n\nclass PromptsRepository implements PromptsRepositoryInterface\n{\n private \\PDO $pdo;\n\n public function __construct(\\PDO $pdo)\n {\n $this->pdo = $pdo;\n }\n\n public function findById(int $id): ?array\n {\n $stmt = $this->pdo->prepare('SELECT * FROM prompts WHERE id = ?');\n $stmt->execute([$id]);\n $result = $stmt->fetch(\\PDO::FETCH_ASSOC);\n\n return $result !== false ? $result : null;\n }\n\n public function findAll(): array\n {\n $stmt = $this->pdo->query('\n SELECT p.*,\n (SELECT COUNT(*) FROM critics c WHERE c.prompt_id = p.id) as critic_count\n FROM prompts p\n ORDER BY p.name\n ');\n\n return $stmt->fetchAll(\\PDO::FETCH_ASSOC);\n }\n\n public function findActivePrompts(): array\n {\n $stmt = $this->pdo->query('\n SELECT id, name, version\n FROM prompts\n WHERE is_active = 1\n ORDER BY name\n ');\n\n return $stmt->fetchAll(\\PDO::FETCH_ASSOC);\n }\n\n public function create(string $name, string $version, string $content, int $isActive): int\n {\n $stmt = $this->pdo->prepare('\n INSERT INTO prompts (name, version, content, is_active)\n VALUES (?, ?, ?, ?)\n ');\n $stmt->execute([$name, $version, $content, $isActive]);\n\n return (int) $this->pdo->lastInsertId();\n }\n\n public function update(int $id, string $name, string $version, string $content, int $isActive): void\n {\n $stmt = $this->pdo->prepare('\n UPDATE prompts\n SET name = ?, version = ?, content = ?, is_active = ?\n WHERE id = ?\n ');\n $stmt->execute([$name, $version, $content, $isActive, $id]);\n }\n\n public function delete(int $id): void\n {\n $stmt = $this->pdo->prepare('DELETE FROM prompts WHERE id = ?');\n $stmt->execute([$id]);\n }\n\n public function duplicate(int $id, string $newName, string $newVersion): int\n {\n $original = $this->findById($id);\n if ($original === null) {\n throw new \\RuntimeException(\"Prompt {$id} not found\");\n }\n\n $stmt = $this->pdo->prepare('\n INSERT INTO prompts (name, version, content, is_active)\n VALUES (?, ?, ?, 0)\n ');\n $stmt->execute([$newName, $newVersion, $original['content']]);\n\n return (int) $this->pdo->lastInsertId();\n }\n\n public function findLinkedCritics(int $promptId): array\n {\n $stmt = $this->pdo->prepare('SELECT * FROM critics WHERE prompt_id = ? ORDER BY name');\n $stmt->execute([$promptId]);\n\n return $stmt->fetchAll(\\PDO::FETCH_ASSOC);\n }\n\n public function countLinkedCritics(int $promptId): int\n {\n $stmt = $this->pdo->prepare('SELECT COUNT(*) FROM critics WHERE prompt_id = ?');\n $stmt->execute([$promptId]);\n\n return (int) $stmt->fetchColumn();\n }\n\n public function getStatistics(): array\n {\n $stats = ['total' => 0, 'active' => 0, 'inactive' => 0, 'linked_to_critics' => 0];\n\n $stmt = $this->pdo->query('SELECT COUNT(*) as cnt, SUM(is_active) as active FROM prompts');\n $row = $stmt->fetch(\\PDO::FETCH_ASSOC);\n $stats['total'] = (int) $row['cnt'];\n $stats['active'] = (int) $row['active'];\n $stats['inactive'] = $stats['total'] - $stats['active'];\n\n $stmt = $this->pdo->query('SELECT COUNT(DISTINCT prompt_id) FROM critics WHERE prompt_id IS NOT NULL');\n $stats['linked_to_critics'] = (int) $stmt->fetchColumn();\n\n return $stats;\n }\n}\n",
"numLines": 128,
"startLine": 1,
"totalLines": 128
}
}
}