{
"event": "PreToolUse",
"tool_name": "Write",
"tool_input": {
"file_path": "\/tmp\/check_profiles.py",
"content": "#!\/usr\/bin\/env python3\n\"\"\"Check if YAML profiles match database entries.\"\"\"\nimport sys\nimport json\nimport yaml\nsys.path.insert(0, \"\/opt\/scripts\/pipeline\")\nfrom config import DB_CONFIG\nimport mysql.connector\n\n# Override database to ki_content\nconfig = DB_CONFIG.copy()\nconfig[\"database\"] = \"ki_content\"\n\nconn = mysql.connector.connect(**config)\ncursor = conn.cursor(dictionary=True)\n\n# Check Cary Web profile in DB\nprint(\"=\" * 80)\nprint(\"PROFILES IN DATABASE (type='author_profile')\")\nprint(\"=\" * 80)\n\ncursor.execute(\"\"\"\n SELECT id, name, slug, version, status, LEFT(content, 200) as content_preview\n FROM content_config\n WHERE type = 'author_profile' AND name LIKE 'Cary%'\n ORDER BY name\n\"\"\")\nfor row in cursor.fetchall():\n print(f\"\\nID: {row['id']} | Name: {row['name']} | Status: {row['status']}\")\n print(f\"Content preview: {row['content_preview'][:100]}...\")\n\n# Check if YAML files exist\nimport os\nyaml_dir = \"\/var\/www\/dev.campus.systemische-tools.de\/config\/profiles\"\nprint(\"\\n\" + \"=\" * 80)\nprint(\"YAML FILES IN FILESYSTEM\")\nprint(\"=\" * 80)\n\nfor f in os.listdir(yaml_dir):\n if f.endswith('.yaml'):\n path = os.path.join(yaml_dir, f)\n size = os.path.getsize(path)\n print(f\"\\n{f} ({size} bytes)\")\n\n # Load and check structure\n with open(path) as yf:\n try:\n data = yaml.safe_load(yf)\n if data and 'autorenprofil' in data:\n ap = data['autorenprofil']\n print(f\" - Name: {ap.get('name', 'N\/A')}\")\n print(f\" - Version: {ap.get('version', 'N\/A')}\")\n print(f\" - Domain: {ap.get('domain', 'N\/A')[:50]}...\")\n except Exception as e:\n print(f\" Error parsing: {e}\")\n\n# Check if code references YAML files directly\nprint(\"\\n\" + \"=\" * 80)\nprint(\"CODE REFERENCES TO YAML FILES\")\nprint(\"=\" * 80)\nimport subprocess\nresult = subprocess.run(\n ['grep', '-r', 'config\/profiles', '\/var\/www\/dev.campus.systemische-tools.de\/src', '\/opt\/scripts\/pipeline'],\n capture_output=True, text=True\n)\nif result.stdout:\n print(result.stdout)\nelse:\n print(\"No direct references to config\/profiles found in code.\")\n\ncursor.close()\nconn.close()\n"
}
}
{
"tool_response": {
"type": "create",
"filePath": "\/tmp\/check_profiles.py",
"content": "#!\/usr\/bin\/env python3\n\"\"\"Check if YAML profiles match database entries.\"\"\"\nimport sys\nimport json\nimport yaml\nsys.path.insert(0, \"\/opt\/scripts\/pipeline\")\nfrom config import DB_CONFIG\nimport mysql.connector\n\n# Override database to ki_content\nconfig = DB_CONFIG.copy()\nconfig[\"database\"] = \"ki_content\"\n\nconn = mysql.connector.connect(**config)\ncursor = conn.cursor(dictionary=True)\n\n# Check Cary Web profile in DB\nprint(\"=\" * 80)\nprint(\"PROFILES IN DATABASE (type='author_profile')\")\nprint(\"=\" * 80)\n\ncursor.execute(\"\"\"\n SELECT id, name, slug, version, status, LEFT(content, 200) as content_preview\n FROM content_config\n WHERE type = 'author_profile' AND name LIKE 'Cary%'\n ORDER BY name\n\"\"\")\nfor row in cursor.fetchall():\n print(f\"\\nID: {row['id']} | Name: {row['name']} | Status: {row['status']}\")\n print(f\"Content preview: {row['content_preview'][:100]}...\")\n\n# Check if YAML files exist\nimport os\nyaml_dir = \"\/var\/www\/dev.campus.systemische-tools.de\/config\/profiles\"\nprint(\"\\n\" + \"=\" * 80)\nprint(\"YAML FILES IN FILESYSTEM\")\nprint(\"=\" * 80)\n\nfor f in os.listdir(yaml_dir):\n if f.endswith('.yaml'):\n path = os.path.join(yaml_dir, f)\n size = os.path.getsize(path)\n print(f\"\\n{f} ({size} bytes)\")\n\n # Load and check structure\n with open(path) as yf:\n try:\n data = yaml.safe_load(yf)\n if data and 'autorenprofil' in data:\n ap = data['autorenprofil']\n print(f\" - Name: {ap.get('name', 'N\/A')}\")\n print(f\" - Version: {ap.get('version', 'N\/A')}\")\n print(f\" - Domain: {ap.get('domain', 'N\/A')[:50]}...\")\n except Exception as e:\n print(f\" Error parsing: {e}\")\n\n# Check if code references YAML files directly\nprint(\"\\n\" + \"=\" * 80)\nprint(\"CODE REFERENCES TO YAML FILES\")\nprint(\"=\" * 80)\nimport subprocess\nresult = subprocess.run(\n ['grep', '-r', 'config\/profiles', '\/var\/www\/dev.campus.systemische-tools.de\/src', '\/opt\/scripts\/pipeline'],\n capture_output=True, text=True\n)\nif result.stdout:\n print(result.stdout)\nelse:\n print(\"No direct references to config\/profiles found in code.\")\n\ncursor.close()\nconn.close()\n",
"structuredPatch": [],
"originalFile": null
}
}