コード例 #1
0
    def process(self, db, user, comment_id):
        comment = Comment.fromId(db, comment_id, user)

        if user != comment.user:
            raise OperationError(
                "can't delete comment written by another user")
        if comment.state != "draft":
            raise OperationError(
                "can't delete comment that has been submitted")

        cursor = db.cursor()
        cursor.execute(
            """UPDATE comments
                             SET state='deleted'
                           WHERE id=%s""", (comment.id, ))

        if comment.chain.state == "draft":
            # If the comment chain was a draft, then delete it as well.
            cursor.execute(
                """UPDATE commentchains
                                 SET state='empty'
                               WHERE id=%s""", (comment.chain.id, ))

        db.commit()

        return OperationResult(
            draft_status=comment.chain.review.getDraftStatus(db, user))
コード例 #2
0
    def process(self, db, user, comment_id, new_text):
        comment = Comment.fromId(db, comment_id, user)

        if user != comment.user:
            raise OperationError, "can't edit comment written by another user"
        if comment.state != "draft":
            raise OperationError, "can't edit comment that has been submitted"
        if not new_text.strip():
            raise OperationError, "empty comment"

        cursor = db.cursor()
        cursor.execute("""UPDATE comments
                             SET comment=%s, time=now()
                           WHERE id=%s""",
                       (new_text, comment.id))

        db.commit()

        return OperationResult(draft_status=comment.chain.review.getDraftStatus(db, user))
コード例 #3
0
    def process(self, db, user, comment_id, new_text):
        comment = Comment.fromId(db, comment_id, user)

        if user != comment.user:
            raise OperationError("can't edit comment written by another user")
        if comment.state != "draft":
            raise OperationError("can't edit comment that has been submitted")
        if not new_text.strip():
            raise OperationError("empty comment")

        cursor = db.cursor()
        cursor.execute("""UPDATE comments
                             SET comment=%s, time=now()
                           WHERE id=%s""",
                       (new_text, comment.id))

        db.commit()

        return OperationResult(draft_status=comment.chain.review.getDraftStatus(db, user))
コード例 #4
0
    def process(self, db, user, comment_id):
        comment = Comment.fromId(db, comment_id, user)

        if user != comment.user:
            raise OperationError, "can't delete comment written by another user"
        if comment.state != "draft":
            raise OperationError, "can't delete comment that has been submitted"

        cursor = db.cursor()
        cursor.execute("""UPDATE comments
                             SET state='deleted'
                           WHERE id=%s""",
                       (comment.id,))

        if comment.chain.state == "draft":
            # If the comment chain was a draft, then delete it as well.
            cursor.execute("""UPDATE commentchains
                                 SET state='empty'
                               WHERE id=%s""",
                           (comment.chain.id,))

        db.commit()

        return OperationResult(draft_status=comment.chain.review.getDraftStatus(db, user))