import enum

from sqlalchemy import (
    Column, Integer, String, ForeignKey, JSON, DateTime, func
)

from community_qa_bot.db import Base
from community_qa_bot.types import FeedbackType


class QaFeedback(Base):
    id = Column(Integer, primary_key=True)
    qa_history_id = Column(Integer, ForeignKey('qa_histories.id'))
    user_id = Column(String(50), ForeignKey('users.id'))
    feedback_type = Column(String(10), nullable=False, default=FeedbackType.LIKE.value)
    feedback_body = Column(JSON)
    created_at = Column(DateTime, default=func.now())
    updated_at = Column(DateTime, default=func.now(), onupdate=func.now())

    __tablename__ = 'qa_feedbacks'