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()