# database/db_operations.py

import json
import logging
from typing import List, Tuple
from .db_manager import DatabaseManager

logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)

def adicionar_lote_questoes(db: DatabaseManager, questoes: list):
    try:
        conn = db.get_connection()
        cursor = conn.cursor()
        
        for questao in questoes:
            cursor.execute('''
            INSERT INTO previous_questions
            (year, area, question_text, options, correct_answer, 
             explanation, difficulty, ref_sources, tags)  # Alterado aqui
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
            ''', (
                questao.get('year'),
                questao.get('area'),
                questao.get('question_text'),
                json.dumps(questao.get('options', {})),
                questao.get('correct_answer'),
                questao.get('explanation'),
                questao.get('difficulty', 'medium'),
                json.dumps(questao.get('references', [])),  # O nome no dicionário pode continuar como references
                json.dumps(questao.get('tags', []))
            ))
        
        conn.commit()
        return True, "Questões adicionadas com sucesso"
    except Exception as e:
        return False, f"Erro ao adicionar questões: {str(e)}"