def update_model(): good = Goods.get_by_id(2) #更新 # good.click_num += 1 # good.save() # Goods.update(click_num=Goods.click_num + 1).where(Goods.id == 1).execute() #删除 # good.delete_instance() Goods.delete().where(Goods.id==2).execute()
def delete_children(id_): children = Goods.select().where(Goods.parent_id == id_) if (len(children) != 0): for child in children: delete(child.id) query = Goods.delete().where(Goods.id == id_) query.execute()
def clear_base(): query = Goods.delete().where(Goods.id != 1) query.execute() query = Goods.update({Goods.amount: 0}).where(Goods.id == 0) query.execute() query = Orders_Info.delete().where(Orders_Info.id > 0) query.execute() query = Orders_Content.delete().where(Orders_Content.id > 0) query.execute()
def delete(id_): children = Goods.select().where(Goods.parent_id == id_) if (len(children) != 0): for child in children: delete_children(child.id) if (id_ != 1): amount = Goods.select().where(Goods.id == id_)[0].amount update_amount(id_, -amount) query = Goods.delete().where(Goods.id == id_) query.execute()