import json
from timApp.timdb.sqa import db


class Review(db.Model):
    """An review to a task."""
    __tablename__ = 'review'
    id = db.Column(db.Integer, primary_key=True)
    """Review identifier."""

    answer_id = db.Column(db.Integer, db.ForeignKey('answer.id'))
    """Answer id."""

    task_name = db.Column(db.Text)
    """Task name"""

    block_id = db.Column(db.Integer, db.ForeignKey('block.id'))
    """Doc id"""

    reviewer_id = db.Column(db.Integer, db.ForeignKey('useraccount.id'))
    """Reviewer id"""

    reviewable_id = db.Column(db.Integer, db.ForeignKey('useraccount.id'))
    """Reviewable id"""

    start_time = db.Column(db.DateTime(timezone=True), nullable=False)
    """Review start time"""

    end_time = db.Column(db.DateTime(timezone=True), nullable=False)
    """Review end time"""

    reviewed = db.Column(db.Boolean, default=False)
    """Review status"""

    @property
    def content_as_json(self):
        return json.loads(self.content)

    def to_json(self):
        return {
            'id': self.id,
            'answer_id': self.answer_id,
            'task_name': self.task_name,
            'block_id': self.block_id,
            'reviewer_id': self.reviewer_id,
            'reviewable_id': self.reviewable_id,
            'start_time': self.start_time,
            'end_time': self.end_time,
            'reviewed': self.reviewed
        }