建立一个字典类型:
record_position = {}
循环给字典赋值,索引是某个position_id:
for row in range(0, nrows):
...
record_position[position_id] = happen_date
从数据库取一列工单数据与字典进行比较,判断的是字典的索引里如果不含有某个position_id则执行下一步。用的是__contains__对字典索引进行检索:
pending_tickets = SecuTicket.objects.filter(status__lt=3)
for item in pending_tickets:
if not record_position.__contains__(item.position_id):
...
至于按照索引取字典某个值只需要用get,如这里的record_position.get(position_id)
if item.happen_date.date() < record_position.get(position_id):
Python+Django真的是简洁强大