def del_product(product_id, update_controls=[None]):
pp = DP.ProductsProcessor('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 sel_product(text_widget):
products = []
pp = DP.ProductsProcessor('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")
if products is not None:
text_widget.insert(tk.END, "ProductID | ProductName\n")
for row in products:
text_widget.insert(tk.END, str(row) + "\n")
text_widget['state'] = 'disabled'
import DataProcessor as dp
import DataModel as dm
# Fill Products
pp = dp.ProductsProcessor(':memory:')
# Create a table for testing
crs = pp.db_con.cursor()
crs.execute(
"CREATE TABLE Products (ProductID int Primary Key, ProductName varchar(100));"
)
pp.db_con.commit()
pp.execute_sql_code(pp.build_ins_code(product_id=1, product_name='Mouse'))
pp.db_con.commit()
pp.execute_sql_code(pp.build_ins_code(product_id=2, product_name='Keyboard'))
pp.db_con.commit()
# print(pp.build_sel_code())
plst = []
for row in crs.execute(pp.build_sel_code()):
# print(row)
plst.append(dm.Product(row[0], row[1]))
# print(plst)
pp.db_con.commit()
pp.db_con.close()
# Fill Inventory Counts
icp = dp.InventoryCountsProcessor(':memory:')
# Create table for testing
crs = icp.db_con.cursor()
