from datetime import datetime
from src.extensions import db

class ChatFile(db.Model):
    """Modelo para armazenar arquivos enviados nos chats"""
    __tablename__ = 'chat_files'

    id = db.Column(db.Integer, primary_key=True)
    chat_id = db.Column(db.Integer, db.ForeignKey('chats.id', ondelete='CASCADE'), nullable=False)
    filename = db.Column(db.String(255), nullable=False)
    file_path = db.Column(db.String(512), nullable=False)
    file_type = db.Column(db.String(100), nullable=False)
    file_size = db.Column(db.Integer, nullable=False)  
    created_at = db.Column(db.DateTime, default=datetime.utcnow)

    chat = db.relationship('Chat', backref=db.backref('files', lazy=True, cascade='all, delete-orphan'))

    def __repr__(self):
        return f'<ChatFile {self.filename}>'