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()
