ai_la/base6/check_difficulty_status.py

import requests
import json

def check_difficulty_status():
    """检查数据库中goal_of_detail表的difficulty字段状态"""
    base_url = "http://localhost:8080"
    
    try:
        # 使用用户ID获取目标（假设用户ID为1）
        print("=== 检查数据库中difficulty字段状态 ===")
        user_id = 1
        response = requests.get(f"{base_url}/api/goals/user/{user_id}")
        
        if response.status_code == 200:
            api_response = response.json()
            if api_response.get('code') == 200:
                goals = api_response.get('data', [])
                print(f"找到 {len(goals)} 个目标")
                
                for goal in goals:
                    goal_id = goal.get('goalId')
                    goal_name = goal.get('goalName', 'Unknown')
                    print(f"\n目标ID: {goal_id}, 名称: {goal_name}")
                    
                    # 获取该目标的题目
                    questions_response = requests.get(f"{base_url}/api/ai/questions/{goal_id}")
                    
                    if questions_response.status_code == 200:
                        questions_api_response = questions_response.json()
                        if questions_api_response.get('code') == 200:
                            questions = questions_api_response.get('data', [])
                            print(f"  题目数量: {len(questions)}")
                            
                            for i, question in enumerate(questions, 1):
                                difficulty = question.get('difficulty')
                                question_text = question.get('question', '')[:50] + '...' if len(question.get('question', '')) > 50 else question.get('question', '')
                                print(f"    题目{i}: difficulty='{difficulty}', 内容: {question_text}")
                                
                                if difficulty is None:
                                    print(f"      ⚠️ 发现null difficulty!")
                                elif difficulty == "":
                                    print(f"      ⚠️ 发现空字符串difficulty!")
                                else:
                                    print(f"      ✅ difficulty正常: {difficulty}")
                        else:
                            print(f"  获取题目API返回错误: {questions_api_response}")
                    else:
                        print(f"  获取题目失败: {questions_response.status_code}")
                        print(f"  响应内容: {questions_response.text}")
            else:
                print(f"API返回错误: {api_response}")
        else:
            print(f"获取目标失败: {response.status_code}")
            print(f"响应内容: {response.text}")
            
    except Exception as e:
        print(f"检查过程中出现错误: {e}")

if __name__ == "__main__":
    check_difficulty_status()