from sqlmodel import SQLModel, Field, Column, JSON
from typing import Optional, List, Dict, Any
from datetime import date, datetime
from app.core.base_model import BaseInsuranceModel

class HealthInsuranceModel(BaseInsuranceModel, table=True):
    __tablename__ = "health_insurance"
    
    # Personal Information (Encrypted)
    full_name: str = Field(description="Full name")
    date_of_birth: date = Field(description="Date of birth")
    gender: str = Field(description="Gender")
    email: str = Field(description="Email address")
    phone_number: str = Field(description="Phone number")
    
    # Address & Lifestyle (Encrypted)
    residential_address: str = Field(description="Residential address")
    zip_code: str = Field(description="ZIP code")
    tobacco_usage: bool = Field(description="Tobacco usage")
    current_health_plan: Optional[str] = Field(default=None, description="Current health plan")
    takes_prescription_meds: Optional[bool] = Field(default=None, description="Takes prescription medications")
    
    # Household & Income
    estimated_annual_income: Optional[float] = Field(default=None, description="Estimated annual income")
    household_size: int = Field(description="Household size")
    add_dependents: bool = Field(description="Add dependents")
    dependent_info: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Dependent information as JSON")
    
    # Coverage Preferences
    coverage_start_date: date = Field(description="Coverage start date")
    preferred_plan_type: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Preferred plan types as JSON")
    preferred_insurance_carriers: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Preferred insurance carriers as JSON")
    primary_doctor_name: Optional[str] = Field(default=None, description="Primary doctor name")
    top_health_concerns: Optional[str] = Field(sa_column=Column(JSON), default=None, description="Top health concerns as JSON")
    monthly_budget_premium: Optional[float] = Field(default=None, description="Monthly budget for premium")
    
    # Consent
    consent_to_share: bool = Field(description="Consent to share information")
    lead_source: Optional[str] = Field(default=None, description="Where did you hear about us?")
    transaction_no: str = Field(index=True, max_length=100, description="Transaction number")

    def get_encrypted_fields(self) -> List[str]:
        return [
            "full_name", "email", "phone_number", "residential_address",
            "current_health_plan", "primary_doctor_name"
        ]

    def get_searchable_fields(self) -> List[str]:
        return ["full_name", "email", "zip_code"]