from sqlalchemy import BigInteger, String, DateTime, Text, ForeignKey, Boolean
from sqlalchemy.orm import mapped_column, Mapped, relationship
from src.database import db


class Reply(db.Model):
    __tablename__ = 'replies'

    id = mapped_column(BigInteger, primary_key=True)
    content: Mapped[str] = mapped_column(Text)
    email: Mapped[str] = mapped_column(String(256), nullable=True)
    author: Mapped[str] = mapped_column(String(128), nullable=True)
    comment_id: Mapped[int] = mapped_column(ForeignKey('comments.id'),
                                            index=True)
    approved: Mapped[bool] = mapped_column(Boolean, nullable=False,
                                           default=True)
    comment = relationship('Comment', back_populates='replies')
    created_at = mapped_column(DateTime)
    updated_at = mapped_column(DateTime)