def category_name_to_id(category_name):
match_list = session.query(Category).filter(
Category.category_name == category_name).all()
if len(match_list) == 1:
return match_list[0].category_id
else:
raise ValueError("該当するカテゴリーが存在しません")
def show_item():
items = session.query(Item).all()
show = []
for row in items:
show.append(row.name)
return show
def show_matching_recipe(recipe_name):
material_list = []
finished_item_id = item_name_to_id(recipe_name)
match_material = session.query(Recipe).filter(
Recipe.finished_item_id == finished_item_id).all()
for row in match_material:
name = id_to_item_name(row.material_id)
count = row.material_count
material_list.append({"name": name, "count": count})
return material_list
def add_item_when_dont_exist(name):
match_count = session.query(Item).filter(Item.name == name).count()
if match_count == 0:
add_item(name)
def id_to_item_name(item_id):
match_list = session.query(Item).filter(Item.item_id == item_id).all()
if len(match_list) == 1:
return match_list[0].name
else:
raise ValueError("該当するidが存在しません")
def item_name_to_id(name):
match_list = session.query(Item).filter(Item.name == name).all()
if len(match_list) == 1:
return match_list[0].item_id
else:
raise ValueError("該当するidが存在しません")