def del_project(name): # firstly del project p_id = Project.get(Project.p_name == name).p_id query = Project.delete().where(Project.p_name == name) query.execute() # secondly del p_id in admin_pro users = User.select() for user in users: admin_pro = user.admin_pro u_id = user.u_id if admin_pro: if admin_pro == str(p_id): admin_pro = None else: pids = admin_pro.split(',') if str(p_id) in pids: pids.remove(str(p_id)) splits = ',' admin_pro = splits.join(pids) query = User.update(admin_pro = admin_pro).where(User.u_id == u_id) query.execute() # thirdly del item if p_id in item items = Item.select() items_id = [] for item in items: if item.project_id == p_id: items_id.append(item.it_id) query = Item.delete().where(Item.project_id == p_id) query.execute() # fourly del reply if it_id in items_id for item_id in items_id: query = Reply.delete().where(Reply.item_id == item_id) query.execute()
def del_item(it_id_list): # firstly del item for it_id_1 in it_id_list: query = Item.delete().where(Item.it_id == int(it_id_1)) query.execute() # secondly del reply if it_id in Reply.item_id # 一个条目只对应一条回复信息 for it_id_2 in it_id_list: query = Reply.delete().where(Reply.item_id == int(it_id_2)) query.execute()