from typing import Optional
from datetime import datetime
from sqlmodel import SQLModel, Field

class RefreshToken(SQLModel, table=True):
    __tablename__ = "refresh_tokens"
    
    id: Optional[int] = Field(default=None, primary_key=True)
    token: str = Field(unique=True, index=True, nullable=False)
    user_id: int = Field(foreign_key="users.id", index=True, nullable=False)
    device_id: Optional[str] = Field(default=None, nullable=True)
    expires_at: datetime = Field(nullable=False)
    revoked: bool = Field(default=False, nullable=False)
    created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False)

class VerificationToken(SQLModel, table=True):
    __tablename__ = "verification_tokens"
    
    id: Optional[int] = Field(default=None, primary_key=True)
    user_id: int = Field(foreign_key="users.id", index=True, nullable=False)
    token: str = Field(unique=True, index=True, nullable=False)
    type: str = Field(nullable=False)  # "email" or "mobile"
    expires_at: datetime = Field(nullable=False)
    created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False)

class AuditLog(SQLModel, table=True):
    __tablename__ = "audit_logs"
    
    id: Optional[int] = Field(default=None, primary_key=True)
    user_id: Optional[int] = Field(default=None, foreign_key="users.id", nullable=True, index=True)
    role: Optional[str] = Field(default=None, nullable=True)
    action: str = Field(nullable=False)  # e.g., "LOGIN", "LOGOUT", "QUOTE_CREATE", "QUOTE_DELETE"
    resource_type: str = Field(nullable=False)  # e.g., "life-insurance", "users"
    resource_id: Optional[int] = Field(default=None, nullable=True)
    ip_address: Optional[str] = Field(default=None, nullable=True)
    timestamp: datetime = Field(default_factory=datetime.utcnow, nullable=False)
    success: bool = Field(default=True, nullable=False)
