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'
