Feb-26-2020, 08:10 AM
(Feb-25-2020, 06:24 PM)t4keheart Wrote: Here ya goactually i think you misunderstood.I meant to say that what should i ask or what exact how should i ask to correct this problem statement with respect to categories here , i mean how should i explain what is exactly wrong here in categories and how should it be to correct it to solve it?
items: id(pkey), name categories: id(pkey), name category_items: id(pkey), category_id (fkey categories), item_id(fkey items) menu.json { "category”:[{ “name”: “Appetizer”, }, { “name”: “Entree” } ] ], "item”:[ { "name":"French Fries", "category":"Appetizer" }, { "name":"Onion Rings", "category":"Appetizer" }, { "name":"Sandwich", "category":"Entree" }, { "name":"Tacos", "category":"Entree" }, { "name":"Ice Cream Sundae", "category":"Dessert" } ], "restaurant":"Joe's Grill" } } Existing classes: class category: def __init__(self, name): self.name = name class item: def __init__(self, name, category_name): self.name = name self.category_name = category_name Helper Functions that Already exist // json.get_categories(file_name) -> returns array of active category objects (category.name) // json.get_items(file_name) --> returns array of item object (item.name, item.category_name) // db.write(table_name, <a data dict or an array of data dicts>) //db.write('categories', {'name': 'c1'})