def add_order():
insert_dict = {}
for column in oc.get_columns():
if column != "_id" and column != "id":
if column == "customer_info":
value = {}
value["first_name"] = input('first_name : ')
value["last_name"] = input('last_name: ')
value["address"] = input('address: ')
value["phone"] = input('phone: ')
elif column == "products":
running = True
value = []
while running:
dict_values = {
"product_name": input('product_name: '),
"retail_price": int(input('retail_price: ')),
}
value.append(dict_values)
print('Do you want to add more products?\n'
'1: Yes\n'
'2: No')
if int(f_input()) == 1:
continue
else:
running = False
else:
value = input(f'{column}: ')
insert_dict[column] = value
divider()
order = oc.add_order(insert_dict)
if order is not None:
print_tablerow(order)
def delete_product_by_id():
print("Enter a product id to delete product")
p_id = f_input()
deleted = pc.delete_product(p_id)
if deleted:
print(f'Product {p_id} was successfully deleted')
divider()
def get_car_by_id():
print("Enter a id")
c_id = f_input()
car = cc.get_car_by_id(c_id)
if car:
print_tablerow(car)
else:
print("not found")
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 update_shop():
print("enter a shop id: ")
s_id = f_input()
shop = sc.get_shop_by_id(s_id)
def inner(column, shop):
return lambda: update_shop_column(column, shop)
menu({
str(i + 1): {
"info": s,
"func": inner(s, shop)
}
for i, s in enumerate(sc.get_columns())
})
def update_car():
print("enter a car id: ")
c_id = f_input()
car = cc.get_car_by_id(c_id)
def inner(column, car):
return lambda: update_car_column(column, car)
menu({
str(i + 1): {
"info": c,
"func": inner(c, car)
}
for i, c in enumerate(cc.get_columns())
})
def update_orders():
print("enter an order id: ")
o_id = f_input()
order = oc.get_order_by_id(o_id)
def inner(column, order):
return lambda: update_order_column(column, order)
menu({
str(i + 1): {
"info": o,
"func": inner(o, order)
}
for i, o in enumerate(oc.get_columns())
})
def update_product():
print("enter a product id: ")
p_id = f_input()
product = pc.get_product_by_id(p_id)
print(product)
def inner(column, product):
return lambda: update_product_column(column, product)
menu({
str(i + 1): {
"info": p,
"func": inner(p, product)
}
for i, p in enumerate(pc.get_columns())
})
def update_employee():
get_all_employees()
print('====================')
print("enter an employee id: ")
e_id = f_input()
employee = ec.get_employee_by_id(e_id)
def inner(column, employee):
return lambda: update_employee_column(column, employee)
menu({
str(i + 1): {
"info": e,
"func": inner(e, employee)
}
for i, e in enumerate(ec.get_columns())
})
def add_employee():
get_all_shops()
print('============================================')
print('Enter a shop id to add employee to that shop')
s_id = f_input()
insert_dict = {}
for column in ec.get_columns():
if column == 'shop_id':
insert_dict['shop_id'] = s_id
elif column != '_id':
insert_dict[column] = input(f'{column}: ')
divider()
employee = ec.add_employee(insert_dict)
value = employee._id
if employee is not None:
shop = sc.get_shop_by_id(s_id)
sc.update_shop_column(shop, 'employees', value)
def drop_car_by_id():
print("Enter a id to delete car")
c_id = f_input()
cc.drop_car(c_id)
def update_car_column(column, car):
print("Enter new value: ")
value = f_input()
cc.update_car_column(car, column, value)
print_tablerow(car)
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 update_shop_column(column, shop):
print("Enter new value: ")
value = f_input()
sc.update_shop_column(shop, column, value)
print_tablerow(shop)
def drop_customer_by_id():
print("Enter a customer id to delete customer")
c_id = f_input()
cc.drop_customer(c_id)
def update_order_column(column, order):
print("Enter new value: ")
value = f_input()
oc.update_order_column(order, column, value)
print_tablerow(order)
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 update_product_column(column, product):
print("Enter new value: ")
value = f_input()
pc.update_product_column(product, column, value)
print_tablerow(product)
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_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_employee_by_id():
print("Enter an employee id")
e_id = f_input()
employee = ec.get_employee_by_id(e_id)
print_tablerow(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_customer_by_id():
print("Enter a Customer Id")
c_id = f_input()
customer = cc.get_customer_by_id(c_id)
print_tablerow(customer)
def drop_order_by_id():
print("Enter an order id to delete order")
o_id = f_input()
oc.drop_order(o_id)
def get_order_by_id():
print("Enter an order Id")
o_id = f_input()
order = oc.get_order_by_id(o_id)
print_tablerow(order)
def update_employee_column(column, employee):
print("Enter new value: ")
value = f_input()
ec.update_employee_column(employee, column, value)
print_tablerow(employee)
def get_shop_by_id():
print("Enter a shop id")
s_id = f_input()
shop = sc.get_shop_by_id(s_id)
print_tablerow(shop)
def drop_employee_by_id():
print("Enter an employee id to delete employee")
e_id = f_input()
ec.drop_employee(e_id)
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 drop_shop_by_id():
print("Enter a shop id to delete shop")
s_id = f_input()
sc.drop_shop(s_id)
