def get_form() -> forms.CustomerForm:
form = forms.ProductForm()
storage = mssql.ProducersStorage.get_connection(conn=mssql.get_conn())
producers_choices = list(enumerate(storage.get_producers_names()))
form.producer.choices = producers_choices
storage = mssql.SuppliersStorage.get_connection(conn=mssql.get_conn())
suppliers_choices = list(enumerate(storage.get_suppliers_names()))
form.supplier.choices = suppliers_choices
return form
def post(self):
storage = mssql.SuppliersStorage.get_connection(conn=mssql.get_conn())
form = forms.SupplierForm()
self.context['form'] = form
self.context['message'] = ''
if request.form['submit'] == 'Add':
self.add(storage, form)
if request.form['submit'] == 'Update':
self.update(storage, form)
if request.form['submit'] == 'Delete':
self.delete(storage, form)
self.context['suppliers'] = storage.get_suppliers()
return render_template(self.template, **self.context)
def get_customers() -> list:
storage = mssql.CustomersStorage().get_connection(
conn=mssql.get_conn())
return storage.get_customers()
def get_suppliers() -> list:
storage = mssql.SuppliersStorage.get_connection(conn=mssql.get_conn())
return storage.get_suppliers()
