def update_employee_list():
get_all_shops()
print('===================================')
print('Enter a shop id to choose that shop')
s_id = f_input()
running = True
while running:
employees = ec.get_all_employees()
print_list_of_tablerows(employees)
print('====================')
print('Enter employee id to add that to the shop of your choice')
value = f_input()
shop = sc.get_shop_by_id(s_id)
sc.update_shop_column(shop, 'employees', value)
print('Do you want to add more employees?\n' '1: Yes\n' '2: No')
if int(f_input()) == 1:
continue
else:
running = False
def get_all_orders():
orders = oc.get_all_orders()
print_list_of_tablerows(orders)
print_amount_matches(orders)
def get_orders_by_columnvalue(column_name):
print(f"enter searchvalue for {column_name}")
name = f_input()
orders = oc.get_orders_by_columnvalue(column_name, name)
print_list_of_tablerows(orders)
print_amount_matches(orders)
def get_all_cars():
cars = cc.get_all_cars()
print_list_of_tablerows(cars)
print_amount_matches(cars)
def get_all_employees():
employees = ec.get_all_employees()
print_list_of_tablerows(employees)
print_amount_matches(employees)
def get_employee_by_columnvalue(column_name):
print(f"enter searchvalue for {column_name}")
name = f_input()
employees = ec.get_employee_by_columnvalue(column_name, name)
print_list_of_tablerows(employees)
print_amount_matches(employees)
def get_employee_by_name():
print("Enter an employee name")
e_name = f_input()
employee = ec.get_employee_by_name(e_name)
print_list_of_tablerows(employee)
print_amount_matches(employee)
def get_customers_by_name():
print("Enter a Customer Name")
c_name = f_input()
customers = cc.get_customers_by_name(c_name)
print_list_of_tablerows(customers)
print_amount_matches(customers)
def get_all_shops():
shops = sc.get_all_shops()
print_list_of_tablerows(shops)
print_amount_matches(shops)
def get_shop_by_columnvalue(column_name):
print(f"enter searchvalue for {column_name}")
name = f_input()
shops = sc.get_shop_by_columnvalue(column_name, name)
print_list_of_tablerows(shops)
print_amount_matches(shops)
def get_all_products():
products = pc.get_all_products()
print_list_of_tablerows(products)
print_amount_matches(products)
def get_products_by_columnvalue(column_name):
print(f"enter searchvalue for {column_name}")
name = f_input()
products = pc.get_products_by_columnvalue(column_name, name)
print_list_of_tablerows(products)
print_amount_matches(products)
def get_product_by_name():
print("Enter a Product Name")
p_name = f_input()
products = pc.get_products_by_name(p_name)
print_list_of_tablerows(products)
