def test_delete(self): created_at = datetime.now() node1 = TicketNode.add( TICKET_NODE_TYPE_CLOSE, 0, 'user1', 1, created_at) node2 = TicketNode.add( TICKET_NODE_TYPE_MERGE, 0, 'user1', 1, created_at) node3 = TicketNode.add( TICKET_NODE_TYPE_MERGE, 0, 'user1', 2, created_at) node = TicketNode.get(id=node2.id) assert node != None node2.delete() node = TicketNode.get(id=node2.id) assert node == None
def test_delete(self): created_at = datetime.now() node1 = TicketNode.add(TICKET_NODE_TYPE_CLOSE, 0, 'user1', 1, created_at) node2 = TicketNode.add(TICKET_NODE_TYPE_MERGE, 0, 'user1', 1, created_at) node3 = TicketNode.add(TICKET_NODE_TYPE_MERGE, 0, 'user1', 2, created_at) node = TicketNode.get(id=node2.id) assert node is not None node2.delete() node = TicketNode.get(id=node2.id) assert node is None
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
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()
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
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()
def test_add(self): type = TICKET_NODE_TYPE_OPEN type_id = 1 author = "user1" ticket_id = 1 created_at = datetime.now() node = TicketNode.add(type, type_id, author, ticket_id, created_at) assert node.type == type assert node.type_id == type_id assert node.author == author assert node.ticket_id == ticket_id assert node.created_at.timetuple() == created_at.timetuple()
def test_get(self): created_at = datetime.now() node1 = TicketNode.add( TICKET_NODE_TYPE_CLOSE, 0, 'user1', 1, created_at) node2 = TicketNode.add( TICKET_NODE_TYPE_MERGE, 0, 'user1', 1, created_at) node3 = TicketNode.add( TICKET_NODE_TYPE_MERGE, 0, 'user1', 2, created_at) nodes = TicketNode.gets_by_ticket_id(1) assert len(nodes) == 2 node1 = TicketNode.add( TICKET_NODE_TYPE_LINECOMMENT, 1, 'user1', 2, created_at) node2 = TicketNode.add( TICKET_NODE_TYPE_COMMENT, 1, 'user1', 2, created_at) node = TicketNode.get_by_type_id(TICKET_NODE_TYPE_LINECOMMENT, 1) assert node.id == node1.id assert node.type == node1.type assert node.type_id == node1.type_id assert node.ticket_id == node1.ticket_id node = TicketNode.get_by_type_id(TICKET_NODE_TYPE_COMMIT, 1) assert node is None
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
def test_get(self): clean_up() created_at = datetime.now() node1 = TicketNode.add(TICKET_NODE_TYPE_CLOSE, 0, 'user1', 1, created_at) node2 = TicketNode.add(TICKET_NODE_TYPE_MERGE, 0, 'user1', 1, created_at) node3 = TicketNode.add(TICKET_NODE_TYPE_MERGE, 0, 'user1', 2, created_at) nodes = TicketNode.gets_by_ticket_id(1) assert len(nodes) == 2 node1 = TicketNode.add(TICKET_NODE_TYPE_LINECOMMENT, 1, 'user1', 2, created_at) node2 = TicketNode.add(TICKET_NODE_TYPE_COMMENT, 1, 'user1', 2, created_at) node = TicketNode.get_by_type_id(TICKET_NODE_TYPE_LINECOMMENT, 1) assert node.id == node1.id assert node.type == node1.type assert node.type_id == node1.type_id assert node.ticket_id == node1.ticket_id node = TicketNode.get_by_type_id(TICKET_NODE_TYPE_COMMIT, 1) assert node is None
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