Protokoll #14284

{
    "event": "PreToolUse",
    "tool_name": "Edit",
    "tool_input": {
        "file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/PromptsRepository.php",
        "old_string": "\/\/ @responsibility: Persistenz für Prompt-Templates\n\nuse Infrastructure\\Config\\DatabaseFactory;",
        "new_string": "\/\/ @responsibility: Persistenz für Prompt-Templates"
    }
}

{
    "tool_response": {
        "filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/PromptsRepository.php",
        "oldString": "\/\/ @responsibility: Persistenz für Prompt-Templates\n\nuse Infrastructure\\Config\\DatabaseFactory;",
        "newString": "\/\/ @responsibility: Persistenz für Prompt-Templates",
        "originalFile": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für Prompt-Templates\n\nuse Infrastructure\\Config\\DatabaseFactory;\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",
        "structuredPatch": [
            {
                "oldStart": 6,
                "oldLines": 8,
                "newStart": 6,
                "newLines": 6,
                "lines": [
                    " ",
                    " \/\/ @responsibility: Persistenz für Prompt-Templates",
                    " ",
                    "-use Infrastructure\\Config\\DatabaseFactory;",
                    "-",
                    " class PromptsRepository",
                    " {",
                    "     private \\PDO $pdo;"
                ]
            }
        ],
        "userModified": false,
        "replaceAll": false
    }
}