from typing import List, Optional
from sqlmodel import Session, select
from app.core.base_repository import BaseRepository
from app.models.AgricultureInsuranceModel import AgricultureInsuranceModel
from app.schemas.AgricultureInsuranceSchema import AgricultureInsuranceCreate, AgricultureInsuranceUpdate
from app.utils.transaction_generator import generate_transaction_number

class AgricultureInsuranceRepository(BaseRepository[AgricultureInsuranceModel, AgricultureInsuranceCreate, AgricultureInsuranceUpdate]):
    def __init__(self, session: Session):
        super().__init__(AgricultureInsuranceModel, session)
    
    def create(self, obj_in: AgricultureInsuranceCreate) -> AgricultureInsuranceModel:
        obj_data = obj_in.model_dump()
        obj_data['transaction_no'] = generate_transaction_number('agriculture')
        
        # 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_farm_name(self, farm_name: str) -> List[AgricultureInsuranceModel]:
        return self.search_by_field("farm_name", farm_name)

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

    def get_by_state(self, state: str) -> List[AgricultureInsuranceModel]:
        stmt = select(self.model).where(self.model.state == state)
        results = self.session.exec(stmt).all()
        for result in results:
            result = self._decrypt_fields(result)
            result = self._convert_json_fields_to_objects(result)
        return results

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

