def quiz_app() -> None:
main = QuizRouter().main()['main']
if not main:
print("No Quiz option selected")
return
elif main[0] == "CREATE":
rows = CategoryView().read_all()
if not rows:
create = CategoryRouter().create()
name = create['name']
if not name:
print("create ERROR - every quiz needs a Category")
return
if not CategoryView().create(name):
print("name ERROR - No name for Category")
return
rows = CategoryView().read_all()
row_id = MainRouter().category(rows)['id']
if row_id:
cat_id = row_id[0].split(' - ')[0].strip()
create = QuizRouter().create()
if all(create.values()):
question = create['question']
options = create['options']
answer = create['answer']
if QuizView().create(cat_id, question, options, answer):
print("OK")
else:
print("create ERROR")
else:
print(
"fields ERROR - question, option and answer is required to create a quiz"
)
else:
print("row selection ERROR - category is required")
elif main[0] == "READ":
rows = QuizView().read_all()
if not rows:
print("read ERROR")
return
MainRouter().quiz(rows)
elif main[0] == "UPDATE":
rows = QuizView().read_all()
row_id = MainRouter().quiz(rows)['quiz']
if row_id:
print("row selection ERROR")
return
id = row_id[0].split(' - ')[0].strip()
update = QuizRouter().update(id)
update = {k: v for k, v in update.items() if v}
if not update or not all(update.values()):
print("update ERROR - at least a field is needed for update")
return
if not QuizView().update(id, **update):
print("update ERROR")
return
print("OK - UPDATED")
elif main[0] == "DELETE":
rows = QuizView().read_all()
row_id = MainRouter().quiz(rows)['id']
if not row_id:
print("row selection ERROR")
return
id = row_id[0].split(' - ')[0].strip()
delete = QuizRouter().delete(id)['DELETE']
if not delete:
print("No row affected")
return
if not QuizView().delete(id):
print("Ok - no row affected")
return
print("OK - DELETED")
return
def category_app() -> None:
main = CategoryRouter().main()['main']
if not main:
print("No Category option selected")
elif main[0] == "CREATE":
create = CategoryRouter().create()
name = create['name']
if not name:
print("name ERROR")
return
if not CategoryView().create(name):
print("create ERROR")
return
print("OK - CREATED")
elif main[0] == "READ":
rows = CategoryView().read_all()
if not rows:
print("read ERROR")
return
MainRouter().category(rows)
elif main[0] == "UPDATE":
rows = CategoryView().read_all()
row_id = MainRouter().category(rows)['id']
if not row_id:
print("row selection ERROR")
return
id = row_id[0].split(' - ')[0].strip()
update = CategoryRouter().update(id)
if not CategoryView().update(id, **update):
print("update ERROR")
return
print("OK - UPDATE")
elif main[0] == "DELETE":
rows = CategoryView().read_all()
row_id = MainRouter().category(rows)['id']
if not row_id:
print("row selection ERROR")
return
id = row_id[0].split(' - ')[0].strip()
delete = CategoryRouter().delete(id)['DELETE']
if not delete:
print("No row affected")
return
if not CategoryView().delete(int(id)):
print("Ok - no row affected")
return
print("OK - DELETE")
return
