# 从数据库删除
del_bookinginfo = Q()
for room_id, time_id_list in loop_dict['del'].items():
for time_id in time_id_list:
temp = Q()
# (AND: ('user_id', 1), ('meeting_room_id', '1'), ('time_slice', '1'), ('booking_date', '2017-12-16'))
temp.connector = 'AND'
temp.children.append(('user_id', 1))
temp.children.append(('meeting_room_id', room_id))
temp.children.append(('time_slice', time_id))
temp.children.append(('booking_date', loop_date))
# print('====>>>', temp)
del_bookinginfo.add(temp, 'OR')
print('=====>>>', del_bookinginfo)
# (OR: (AND: ), (AND: ('user_id', 1), ('meeting_room_id', '1'), ('time_slice', '1'), ('booking_date', '2017-12-16')))
if del_bookinginfo:
models.BookingInfo.objects.filter(del_bookinginfo).delete()
Django之使用Q对象批量删除数据
最新推荐文章于 2024-03-07 14:21:48 发布