Protokoll #24428

{
    "event": "PreToolUse",
    "tool_name": "mcp__mcp-db__db_select",
    "tool_input": {
        "query": "SELECT ca.file_path, cq.issues_count, cq.hygiene_score, cq.issues_json\nFROM code_analysis ca\nJOIN code_quality cq ON cq.analysis_id = ca.id\nWHERE ca.file_path LIKE '%\/src\/UseCases\/%'\n  AND cq.issues_count > 0\nORDER BY cq.issues_count DESC\nLIMIT 15",
        "database": "ki_dev"
    }
}

{
    "tool_response": [
        {
            "type": "text",
            "text": "{\n  \"status\": \"success\",\n  \"data\": [\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Taxonomy\/GetTaxonomyOverviewUseCase.php\",\n      \"issues_count\": 4,\n      \"hygiene_score\": 96,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":52},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":62},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":139},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":139}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Chat\/StreamingChatMessageUseCase.php\",\n      \"issues_count\": 4,\n      \"hygiene_score\": 64,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 1000\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":61},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 1000\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":225},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 1000\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":283},{\\\"type\\\":\\\"complexity\\\",\\\"rule\\\":\\\"file-too-long\\\",\\\"message\\\":\\\"Datei hat 515 Zeilen (max: 350)\\\",\\\"severity\\\":\\\"warning\\\"}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Pipeline\/PipelineRunStatusUseCase.php\",\n      \"issues_count\": 3,\n      \"hygiene_score\": 97,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":49},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":49},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 60\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":57}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Chat\/ManageChatSessionsUseCase.php\",\n      \"issues_count\": 2,\n      \"hygiene_score\": 59,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":82},{\\\"type\\\":\\\"srp\\\",\\\"rule\\\":\\\"too-many-methods\\\",\\\"message\\\":\\\"Klasse hat 24 Methoden (max: 20)\\\",\\\"severity\\\":\\\"warning\\\"}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Command\/CreateCriticCommand.php\",\n      \"issues_count\": 2,\n      \"hygiene_score\": 98,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":45},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":46}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Command\/CreatePromptCommand.php\",\n      \"issues_count\": 2,\n      \"hygiene_score\": 98,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":43},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":44}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Command\/SendChatMessageCommand.php\",\n      \"issues_count\": 2,\n      \"hygiene_score\": 98,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":73},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":74}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Command\/UpdateCriticCommand.php\",\n      \"issues_count\": 2,\n      \"hygiene_score\": 98,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":51},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":52}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Command\/UpdatePromptCommand.php\",\n      \"issues_count\": 2,\n      \"hygiene_score\": 98,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":49},{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":50}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Taxonomy\/AssignEntityTaxonomyUseCase.php\",\n      \"issues_count\": 1,\n      \"hygiene_score\": 89,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 1000\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":78}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Chat\/ExportChatSessionUseCase.php\",\n      \"issues_count\": 1,\n      \"hygiene_score\": 99,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":60}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Chat\/SendChatMessageUseCase.php\",\n      \"issues_count\": 1,\n      \"hygiene_score\": 80,\n      \"issues_json\": \"[{\\\"type\\\":\\\"complexity\\\",\\\"rule\\\":\\\"file-too-long\\\",\\\"message\\\":\\\"Datei hat 361 Zeilen (max: 350)\\\",\\\"severity\\\":\\\"warning\\\"}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Chat\/UpdateChatSessionUseCase.php\",\n      \"issues_count\": 1,\n      \"hygiene_score\": 90,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":36}]\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/CodeAnalysis\/GetCodeAnalysisUseCase.php\",\n      \"issues_count\": 1,\n      \"hygiene_score\": 99,\n      \"issues_json\": \"[{\\\"type\\\":\\\"magic_number\\\",\\\"rule\\\":\\\"hardcoded-magic-number\\\",\\\"message\\\":\\\"Magic Number gefunden: 100\\\",\\\"severity\\\":\\\"info\\\",\\\"line\\\":26}]\"\n    }\n  ],\n  \"row_count\": 14,\n  \"error\": null,\n  \"execution_ms\": 1\n}"
        }
    ]
}