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