Class DiscussionComment

shared/database/discussion/discussion_comment.py:5–117

class DiscussionComment(Base):
    """
    

    """
    __tablename__ = 'discussion_comment'

    id = Column(Integer, primary_key = True)

    user_id = Column(Integer, ForeignKey('userbase.id'))
    user = relationship("User")

    project_id = Column(Integer, ForeignKey('project.id'))
    project = relationship("Project", foreign_keys = [project_id])

    discussion_id = Column(Integer, ForeignKey('discussion.id'))
    discussion = relationship("Discussion", foreign_keys = [discussion_id])

    # Markdown format?
    content = Column(String())

    member_created_id = Column(Integer, ForeignKey('member.id'))
    member_created = relationship("Member", foreign_keys = [member_created_id])

    member_updated_id = Column(Integer, ForeignKey('member.id'))
    member_updated = relationship("Member", foreign_keys = [member_updated_id])

    time_created = Column(DateTime, default = datetime.datetime.utcnow)
    time_updated = Column(DateTime, onupdate = datetime.datetime.utcnow)

    # Add reaction?
    @staticmethod
    def update(
            session: object,
            comment_id: int = None,
            member: object = None,
            content: str = None,
    ):
        comment = DiscussionComment.get_by_id(session, id = comment_id)
        comment.content = content
        comment.member_updated = member
        comment.time_updated = datetime.datetime.utcnow()
        session.add(comment)
        return comment

    @staticmethod
    def list(
            session: object,
            project_id: int = None,
            discussion_id: int = None,
            ordering: str = 'asc',
    ):
        """
            List the comments based on the given dicussion and project_id.
        :param session:
        :param project_id:
        :param discussion_id:
        :param ordering: Can be any of ['asc', 'desc']. Sets the ordering of the result by the created time.