Protokoll #14339

{
    "event": "PostToolUse",
    "raw_data": {
        "session_id": "f0f145c4-ac1d-417a-b15b-271983ae648b",
        "transcript_path": "\/root\/.claude\/projects\/-var-www\/f0f145c4-ac1d-417a-b15b-271983ae648b.jsonl",
        "cwd": "\/var\/www\/dev.campus.systemische-tools.de",
        "permission_mode": "acceptEdits",
        "hook_event_name": "PostToolUse",
        "tool_name": "Read",
        "tool_input": {
            "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/PromptsRepository.php"
        },
        "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\nclass PromptsRepository\n{\n    private \\PDO $pdo;\n\n    public function __construct(?\\PDO $pdo = null)\n    {\n        $this->pdo = $pdo ?? DatabaseFactory::content();\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": 126,
                "startLine": 1,
                "totalLines": 126
            }
        },
        "tool_use_id": "toolu_01B4ki2m9FBvZXfNVEbsgQLt"
    }
}

-