def del_product(product_id, update_controls=[None]): pp = DP.ProductProcessor('Python210FinalDB.db') sql = pp.build_del_code(product_id=product_id) pp.execute_sql_code(sql) pp.db_con.commit() pp.db_con.close() if update_controls is not None: IOProcessor.sel_product(update_controls[0])
def del_product(product_id, update_controls=[None]): pp = dp.ProductProcessor(database) sql = pp.build_del_code(product_id=product_id) pp.execute_sql_code(sql) pp.db_con.commit() pp.db_con.close() if update_controls is not None: IOProcessor.sel_product(update_controls[0])
def sel_product(text_widget): products = [] pp = DP.ProductProcessor('Python210FinalDB.db') sql = pp.build_sel_code() for row in pp.execute_sql_code(sql): products.append(DM.Product(row[0], row[1])) pp.db_con.commit() pp.db_con.close() text_widget['state'] = 'normal' text_widget.delete(1.0, tk.END) if products is None: text_widget.insert("No data available") else: text_widget.insert(tk.END, "ProductID,ProductName\n") for row in products: text_widget.insert(tk.END, str(row) + "\n") text_widget['state'] = 'disabled'