from __future__ import annotations

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


class TranslationLogBase(SQLModel):
    timestamp: datetime
    confidence: float


class TranslationLog(TranslationLogBase, table=True):
    __tablename__ = "translation_logs"

    id: Optional[int] = Field(default=None, primary_key=True)

    session_id: int = Field(foreign_key="sessions.session_id")
    letterID: int = Field(foreign_key="sign_alphabets.letterID")


class TranslationLogCreate(TranslationLogBase):
    session_id: int
    letterID: int