{
  "error_questions": [
    {
      "question_text": "若 x+y=1, xy=-2，則 (2-x)(2-y) 的值為",
      "subject": "數學",
      "question_type": "選擇題",
      "difficulty": 3,
      "answer": "0",
      "user_answer": "B",
      "explanation": ""
    },
    {
      "question_text": "已知 x2+y2=22, xy=7，那么 (2x-y)(x-2y) 的值為",
      "subject": "數學",
      "question_type": "填空題",
      "difficulty": 3,
      "answer": "9",
      "user_answer": "-139",
      "explanation": ""
    },
    {
      "question_text": "計算: (a+1)(a2-2a+3)",
      "subject": "數學",
      "question_type": "問答題",
      "difficulty": 2,
      "answer": "a3 - a2 + a + 3",
      "user_answer": "a3 - a2 + a + 3",
      "explanation": ""
    }
  ]
}

import json
def main(arg1: str) -> dict:
    try:
        # 移除可能存在的Markdown代碼塊標記
        cleaned_json = arg1.strip()
        if cleaned_json.startswith('```json'):
            cleaned_json = cleaned_json[7:]
        if cleaned_json.endswith('```'):
            cleaned_json = cleaned_json[:-3]

        # 處理轉義字符，并確保正確的編碼處理
        # cleaned_json = cleaned_json.encode('utf-8').decode('unicode_escape').encode('latin1').decode('utf-8')
         # **替換轉義符**：將 \\n 轉為 \n（適用于 JSON 中用雙反斜杠表示換行的場景）
        cleaned_json = cleaned_json.replace('\\\\n', '\\n')  # 將四個反斜杠轉為兩個（JSON 標準轉義）
        # 將 JSON 字符串解析為 Python 字典
        result_dict = json.loads(cleaned_json)
        return {"error_questions": result_dict["error_questions"]} # 返回解析結果
    except json.JSONDecodeError as e:
        return {"error": f"JSON 解析失敗: {e}"}
    except Exception as e:
        return {"error": f"發(fā)生未知錯誤: {e}"}

def main(arg1: dict) -> dict:
    # 提取輸入字典的字段
    question_text = arg1.get("question_text", "")
    subject = arg1.get("subject", "")
    question_type = arg1.get("question_type", "")

    # 確保 difficulty 是字符串類型
    difficulty = arg1.get("difficulty", "")
    if not isinstance(difficulty, str):
        difficulty = str(difficulty)

    answer = arg1.get("answer", "")
    user_answer = arg1.get("user_answer", "")
    explanation = arg1.get("explanation", "")

    # 返回包含所有字段的字典
    return {
        "question_text": question_text,
        "subject": subject,
        "question_type": question_type,
        "difficulty": difficulty,  # 確保此處為字符串
        "answer": answer,
        "user_answer": user_answer,
        "explanation": explanation
    }

INSERT INTO error_questions
(question_text, subject, question_type, difficulty, answer, user_answer, explanation)
VALUES
('{{#1747669724911.question_text#}}','{{#1747669724911.subject#}}','{{#1747669724911.question_type#}}','{{#1747669724911.difficulty#}}','{{#1747669724911.answer#}}','{{#1747669724911.user_answer#}}','{{#1747669724911.explanation#}}');

CREATE TABLE error_questions (
    id INT PRIMARY KEY AUTO_INCREMENT,
    question_text TEXT NOT NULL COMMENT '題目內容',
    subject VARCHAR(50) NOT NULL COMMENT '學科',
    question_type VARCHAR(50) NOT NULL COMMENT '題目類型',
    difficulty TINYINT NOT NULL COMMENT '難度等級(1-5)',
    answer TEXT COMMENT '答案',
    user_answer TEXT COMMENT '用戶答案',
    explanation TEXT COMMENT '解析',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間'
);