def delete_menu(database):
view.clear()
view.print_table_names(database)
table_name = input('Input table name: ')
if table_name not in database.table_names:
return False
else:
delete_id = input('Input id to delete: ')
database.delete_from_table(table_name, delete_id)
return True
def insert_menu(database):
view.clear()
view.print_table_names(database)
table_name = input('Input table name: ')
if table_name not in database.table_names:
return False
else:
view.print_column_names(database, table_name)
values = input('Input values for columns separeted by space: ').split()
database.insert_to_table(table_name, *values)
return True
def update_menu(database):
view.print_table_names(database)
table_name = input('Input table name: ')
if table_name not in database.table_names:
return False
else:
view.print_column_names(database, table_name)
column_name = input('Input column name: ')
if column_name not in database.get_column_name_of_table(table_name):
return False
else:
value = input('Input value: ')
update_id = input('Input id: ')
database.update_table(table_name, column_name, value, update_id)
return True