def check_storage(model, color):
storage = Storage.select().where(Storage.model == model,
Storage.color == color).get()
if storage and storage.num > 0:
return True
else:
return False
def get_storage(model):
"""通过车型获取 该车型所有库存分类
:param model:
:type model:
:return: 该车型所有库存
:rtype: json
"""
storage = Storage.select().where(Storage.model == model)
return storage
def get_storage_total(model):
"""通过车型获取 该车型库存总数
:param model:
:type model:
:return:
:rtype:
"""
storage = Storage.select().where(Storage.model == model)
count = 0
for one in storage:
count += one.num
return count
def get_by_model_color(model, color):
storage = Storage.select().where(Storage.model == model, color == color)
return storage
def count_all():
count = Storage.select().count()
return count
def get_all_paginate(page, paginate_by):
storage = Storage.select().paginate(page, paginate_by)
return storage
def get_all():
storage = Storage.select()
return storage