{
"event": "PreToolUse",
"tool_name": "Edit",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/DokumentationRepository.php",
"old_string": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nclass DokumentationRepository\n{\n private \\PDO $pdo;\n\n public function __construct()\n {\n $this->pdo = new \\PDO(\n 'mysql:host=localhost;dbname=ki_dev;charset=utf8mb4',\n 'root',\n $this->getPassword(),\n [\n \\PDO::ATTR_ERRMODE => \\PDO::ERRMODE_EXCEPTION,\n \\PDO::ATTR_DEFAULT_FETCH_MODE => \\PDO::FETCH_ASSOC,\n ]\n );\n }\n\n private function getPassword(): string\n {\n $file = '\/var\/www\/docs\/credentials\/credentials.md';\n $content = file_get_contents($file);\n foreach (explode(\"\\n\", $content) as $line) {\n if (str_contains($line, 'MariaDB') && str_contains($line, 'root')) {\n $parts = explode('|', $line);\n if (count($parts) >= 4) {\n return trim($parts[3]);\n }\n }\n }\n\n return '';\n }",
"new_string": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass DokumentationRepository\n{\n private \\PDO $pdo;\n\n public function __construct()\n {\n $this->pdo = DatabaseFactory::dev();\n }"
}
}
{
"tool_response": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/DokumentationRepository.php",
"oldString": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nclass DokumentationRepository\n{\n private \\PDO $pdo;\n\n public function __construct()\n {\n $this->pdo = new \\PDO(\n 'mysql:host=localhost;dbname=ki_dev;charset=utf8mb4',\n 'root',\n $this->getPassword(),\n [\n \\PDO::ATTR_ERRMODE => \\PDO::ERRMODE_EXCEPTION,\n \\PDO::ATTR_DEFAULT_FETCH_MODE => \\PDO::FETCH_ASSOC,\n ]\n );\n }\n\n private function getPassword(): string\n {\n $file = '\/var\/www\/docs\/credentials\/credentials.md';\n $content = file_get_contents($file);\n foreach (explode(\"\\n\", $content) as $line) {\n if (str_contains($line, 'MariaDB') && str_contains($line, 'root')) {\n $parts = explode('|', $line);\n if (count($parts) >= 4) {\n return trim($parts[3]);\n }\n }\n }\n\n return '';\n }",
"newString": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nuse Infrastructure\\Config\\DatabaseFactory;\n\nclass DokumentationRepository\n{\n private \\PDO $pdo;\n\n public function __construct()\n {\n $this->pdo = DatabaseFactory::dev();\n }",
"originalFile": "<?php\n\nnamespace Infrastructure\\Persistence;\n\nclass DokumentationRepository\n{\n private \\PDO $pdo;\n\n public function __construct()\n {\n $this->pdo = new \\PDO(\n 'mysql:host=localhost;dbname=ki_dev;charset=utf8mb4',\n 'root',\n $this->getPassword(),\n [\n \\PDO::ATTR_ERRMODE => \\PDO::ERRMODE_EXCEPTION,\n \\PDO::ATTR_DEFAULT_FETCH_MODE => \\PDO::FETCH_ASSOC,\n ]\n );\n }\n\n private function getPassword(): string\n {\n $file = '\/var\/www\/docs\/credentials\/credentials.md';\n $content = file_get_contents($file);\n foreach (explode(\"\\n\", $content) as $line) {\n if (str_contains($line, 'MariaDB') && str_contains($line, 'root')) {\n $parts = explode('|', $line);\n if (count($parts) >= 4) {\n return trim($parts[3]);\n }\n }\n }\n\n return '';\n }\n\n public function findById(int $id): ?array\n {\n $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE id = :id');\n $stmt->execute(['id' => $id]);\n $result = $stmt->fetch();\n\n return $result !== false ? $result : null;\n }\n\n public function findByPath(string $path): ?array\n {\n $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE path = :path AND status = :status');\n $stmt->execute(['path' => $path, 'status' => 'published']);\n $result = $stmt->fetch();\n\n return $result !== false ? $result : null;\n }\n\n public function findBySlug(string $slug, ?int $parentId = null): ?array\n {\n if ($parentId === null) {\n $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE slug = :slug AND parent_id IS NULL AND status = :status');\n $stmt->execute(['slug' => $slug, 'status' => 'published']);\n } else {\n $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE slug = :slug AND parent_id = :parent_id AND status = :status');\n $stmt->execute(['slug' => $slug, 'parent_id' => $parentId, 'status' => 'published']);\n }\n $result = $stmt->fetch();\n\n return $result !== false ? $result : null;\n }\n\n public function findDocBySlug(string $slug): ?array\n {\n $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE slug = :slug AND status = :status LIMIT 1');\n $stmt->execute(['slug' => $slug, 'status' => 'published']);\n $result = $stmt->fetch();\n\n return $result !== false ? $result : null;\n }\n\n public function findChildren(int $parentId): array\n {\n $stmt = $this->pdo->prepare('\n SELECT * FROM dokumentation\n WHERE parent_id = :parent_id AND status = :status\n ORDER BY sort_order ASC\n ');\n $stmt->execute(['parent_id' => $parentId, 'status' => 'published']);\n\n return $stmt->fetchAll();\n }\n\n public function findRootDocuments(): array\n {\n $stmt = $this->pdo->prepare('\n SELECT * FROM dokumentation\n WHERE parent_id IS NULL AND status = :status\n ORDER BY sort_order ASC\n ');\n $stmt->execute(['status' => 'published']);\n\n return $stmt->fetchAll();\n }\n\n public function getHierarchy(): array\n {\n $roots = $this->findRootDocuments();\n\n return $this->buildTree($roots);\n }\n\n private function buildTree(array $items): array\n {\n $result = [];\n foreach ($items as $item) {\n $children = $this->findChildren((int) $item['id']);\n $item['children'] = $this->buildTree($children);\n $result[] = $item;\n }\n\n return $result;\n }\n\n public function getBreadcrumb(int $docId): array\n {\n $breadcrumb = [];\n $doc = $this->findById($docId);\n\n while ($doc !== null) {\n array_unshift($breadcrumb, [\n 'title' => $doc['title'],\n 'path' => $doc['path'],\n ]);\n\n if ($doc['parent_id'] !== null) {\n $doc = $this->findById((int) $doc['parent_id']);\n } else {\n $doc = null;\n }\n }\n\n return $breadcrumb;\n }\n\n public function getSiblings(int $docId): array\n {\n $doc = $this->findById($docId);\n if ($doc === null) {\n return [];\n }\n\n if ($doc['parent_id'] === null) {\n return $this->findRootDocuments();\n }\n\n return $this->findChildren((int) $doc['parent_id']);\n }\n\n public function getStatistics(): array\n {\n $stats = [];\n\n $stmt = $this->pdo->query('SELECT COUNT(*) FROM dokumentation');\n $stats['total'] = (int) $stmt->fetchColumn();\n\n $stmt = $this->pdo->query('SELECT depth, COUNT(*) as count FROM dokumentation GROUP BY depth ORDER BY depth');\n $stats['by_depth'] = $stmt->fetchAll();\n\n $stmt = $this->pdo->query('SELECT status, COUNT(*) as count FROM dokumentation GROUP BY status');\n $stats['by_status'] = $stmt->fetchAll();\n\n return $stats;\n }\n}\n",
"structuredPatch": [
{
"oldStart": 2,
"oldLines": 39,
"newStart": 2,
"newLines": 17,
"lines": [
" ",
" namespace Infrastructure\\Persistence;",
" ",
"+use Infrastructure\\Config\\DatabaseFactory;",
"+",
" class DokumentationRepository",
" {",
" private \\PDO $pdo;",
" ",
" public function __construct()",
" {",
"- $this->pdo = new \\PDO(",
"- 'mysql:host=localhost;dbname=ki_dev;charset=utf8mb4',",
"- 'root',",
"- $this->getPassword(),",
"- [",
"- \\PDO::ATTR_ERRMODE => \\PDO::ERRMODE_EXCEPTION,",
"- \\PDO::ATTR_DEFAULT_FETCH_MODE => \\PDO::FETCH_ASSOC,",
"- ]",
"- );",
"+ $this->pdo = DatabaseFactory::dev();",
" }",
" ",
"- private function getPassword(): string",
"- {",
"- $file = '\/var\/www\/docs\/credentials\/credentials.md';",
"- $content = file_get_contents($file);",
"- foreach (explode(\"\\n\", $content) as $line) {",
"- if (str_contains($line, 'MariaDB') && str_contains($line, 'root')) {",
"- $parts = explode('|', $line);",
"- if (count($parts) >= 4) {",
"- return trim($parts[3]);",
"- }",
"- }",
"- }",
"-",
"- return '';",
"- }",
"-",
" public function findById(int $id): ?array",
" {",
" $stmt = $this->pdo->prepare('SELECT * FROM dokumentation WHERE id = :id');"
]
}
],
"userModified": false,
"replaceAll": false
}
}