Example #1
0
 def test_get_line_comment_count(self):
     created_at = datetime.now()
     node1 = TicketNode.add(
         TICKET_NODE_TYPE_COMMENT, 0, 'user1', 1, created_at)
     node2 = TicketNode.add(
         TICKET_NODE_TYPE_COMMENT, 0, 'user1', 1, created_at)
     node3 = TicketNode.add(
         TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', 1, created_at)
     node4 = TicketNode.add(
         TICKET_NODE_TYPE_COMMENT, 0, 'user1', 2, created_at)
     node5 = TicketNode.add(
         TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', 2, created_at)
     test_count = TicketRank.get_line_comment_count(1)
     assert test_count == 1
Example #2
0
 def test_get_last_created_time(self):
     node1 = TicketNode.add(
         TICKET_NODE_TYPE_COMMENT, 0, 'user1', 1, datetime.now())
     node2 = TicketNode.add(
         TICKET_NODE_TYPE_COMMENT, 0, 'user1', 1, datetime.now())
     node3 = TicketNode.add(
         TICKET_NODE_TYPE_COMMENT, 0, 'user1', 2, datetime.now())
     node4 = TicketNode.add(
         TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', 2, datetime.now())
     created_at = datetime.now()
     node5 = TicketNode.add(
         TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', 1, created_at)
     testtime = TicketRank.get_last_created_time(1)
     assert node5.created_at.timetuple() == testtime.timetuple()
Example #3
0
 def test_get_comment_count(self):
     clean_up()
     created_at = datetime.now()
     node1 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', 1,
                            created_at)
     node2 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', 1,
                            created_at)
     node3 = TicketNode.add(TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', 1,
                            created_at)
     node4 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', 2,
                            created_at)
     node5 = TicketNode.add(TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', 2,
                            created_at)
     test_count = TicketRank.get_comment_count(1)
     assert test_count == 2
Example #4
0
 def test_get_last_created_time(self):
     clean_up()
     node1 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', 1,
                            datetime.now())
     node2 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', 1,
                            datetime.now())
     node3 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', 2,
                            datetime.now())
     node4 = TicketNode.add(TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', 2,
                            datetime.now())
     created_at = datetime.now()
     node5 = TicketNode.add(TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', 1,
                            created_at)
     testtime = TicketRank.get_last_created_time(1)
     assert node5.created_at.timetuple() == testtime.timetuple()
     clean_up()
Example #5
0
    def test_count_ticket_rank(self):
        clean_up()
        title = 'test title'
        desc = 'test desc'
        author = 'testuser'
        tick1 = Ticket.add(1, title, desc, author)
        tick2 = Ticket.add(2, title, desc, author)
        created_at = datetime.now()
        aDay = timedelta(days=-1)
        yesterday = created_at + aDay
        node1 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', tick1.id,
                               created_at)
        node2 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', tick1.id,
                               created_at)
        node3 = TicketNode.add(TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1',
                               tick1.id, created_at)
        node4 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 0, 'user1', tick2.id,
                               yesterday)
        node5 = TicketNode.add(TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1',
                               tick2.id, yesterday)

        # 验证 已经关闭的 ticket
        store.execute(
            "update codedouban_ticket set time=%s, closed=%s "
            "where id=%s", (yesterday, created_at, tick2.id))
        store.commit()
        TicketRank.count_ticket_rank(True)
        rank_score2 = TicketRank.get_rank_by_ticket_id(tick2.id)
        rank_s2 = rank_score2[0][0]
        rank2 = 32.07
        assert rank_s2 == rank2

        # 验证 没有关闭的 ticket
        TicketRank.count_ticket_rank(False)
        rank_score1 = TicketRank.get_rank_by_ticket_id(tick1.id)
        rank_s1 = rank_score1[0][0]
        rank1 = 37.97
        assert rank_s1 == rank1
Example #6
0
    def test_count_ticket_rank(self):
        clean_up()
        title = 'test title'
        desc = 'test desc'
        author = 'testuser'
        tick1 = Ticket.add(1, title, desc, author)
        tick2 = Ticket.add(2, title, desc, author)
        created_at = datetime.now()
        aDay = timedelta(days=-1)
        yesterday = created_at + aDay
        node1 = TicketNode.add(
            TICKET_NODE_TYPE_COMMENT, 0, 'user1', tick1.id, created_at)
        node2 = TicketNode.add(
            TICKET_NODE_TYPE_COMMENT, 0, 'user1', tick1.id, created_at)
        node3 = TicketNode.add(
            TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', tick1.id, created_at)
        node4 = TicketNode.add(
            TICKET_NODE_TYPE_COMMENT, 0, 'user1', tick2.id, yesterday)
        node5 = TicketNode.add(
            TICKET_NODE_TYPE_LINECOMMENT, 0, 'user1', tick2.id, yesterday)

        # 验证 已经关闭的 ticket
        store.execute("update codedouban_ticket set time=%s, closed=%s "
                      "where id=%s", (yesterday, created_at, tick2.id))
        store.commit()
        TicketRank.count_ticket_rank(True)
        rank_score2 = TicketRank.get_rank_by_ticket_id(tick2.id)
        rank_s2 = rank_score2[0][0]
        rank2 = 32.07
        assert rank_s2 == rank2

        # 验证 没有关闭的 ticket
        TicketRank.count_ticket_rank(False)
        rank_score1 = TicketRank.get_rank_by_ticket_id(tick1.id)
        rank_s1 = rank_score1[0][0]
        rank1 = 37.97
        assert rank_s1 == rank1
Example #7
0
def update_ticket_rankscore_closed():
    TicketRank.count_ticket_rank(True)
Example #8
0
def update_ticket_rankscore_null():
    TicketRank.count_ticket_rank(False)
Example #9
0
def update_ticket_rankscore_closed():
    TicketRank.count_ticket_rank(True)
Example #10
0
def update_ticket_rankscore_null():
    TicketRank.count_ticket_rank(False)