from typing import List, Optional
from sqlmodel import Session, select
from app.core.base_repository import BaseRepository
from app.models.HealthInsuranceModel import HealthInsuranceModel
from app.schemas.HealthInsuranceSchema import HealthInsuranceCreate, HealthInsuranceUpdate
from app.utils.transaction_generator import generate_transaction_number

class HealthInsuranceRepository(BaseRepository[HealthInsuranceModel, HealthInsuranceCreate, HealthInsuranceUpdate]):
    def __init__(self, session: Session):
        super().__init__(HealthInsuranceModel, session)
    
    def create(self, obj_in: HealthInsuranceCreate) -> HealthInsuranceModel:
        obj_data = obj_in.model_dump()
        obj_data['transaction_no'] = generate_transaction_number('health')
        
        # Encrypt sensitive fields
        obj_data = self._encrypt_fields(obj_data)
        
        db_obj = self.model(**obj_data)
        return super().create_db_object(db_obj)

    def search_by_name(self, name: str) -> List[HealthInsuranceModel]:
        return self.search_by_field("full_name", name)

    def search_by_email(self, email: str) -> List[HealthInsuranceModel]:
        return self.search_by_field("email", email)

    def get_by_zip_code(self, zip_code: str) -> List[HealthInsuranceModel]:
        stmt = select(self.model).where(self.model.zip_code == zip_code)
        db_objs = self.session.exec(stmt).all()
        
        for db_obj in db_objs:
            db_obj = self._decrypt_fields(db_obj)
            db_obj = self._convert_json_fields_to_objects(db_obj)
        
        return db_objs

    def get_by_status(self, status: str) -> List[HealthInsuranceModel]:
        stmt = select(self.model).where(self.model.quote_status == status)
        db_objs = self.session.exec(stmt).all()
        
        for db_obj in db_objs:
            db_obj = self._decrypt_fields(db_obj)
            db_obj = self._convert_json_fields_to_objects(db_obj)
        
        return db_objs