示例#1
0
 def del_inventory(inventory_id, update_controls=[None]):
     ip = dp.InventoryProcessor(database)
     sql = ip.build_del_code(inventory_id=inventory_id)
     ip.execute_sql_code(sql)
     ip.db_con.commit()
     ip.db_con.close()
     if update_controls is not None:
         IOProcessor.sel_inventory(update_controls[0])
示例#2
0
 def del_inventory(inventory_id, update_controls=[None]):
     pp = DP.InventoryProcessor('Python210FinalDB.db')
     sql = pp.build_del_code(inventory_id=inventory_id)
     pp.execute_sql_code(sql)
     pp.db_con.commit()
     pp.db_con.close()
     if update_controls is not None:
         IOProcessor.sel_inventory(update_controls[0])
示例#3
0
 def ins_inventory(inventory_id, inventory_date, update_controls=[None]):
     pp = DP.InventoryProcessor('Python210FinalDB.db')
     sql = pp.build_ins_code(inventory_id=inventory_id,
                             inventory_date=inventory_date)
     pp.execute_sql_code(sql)
     pp.db_con.commit()
     pp.db_con.close()
     if update_controls is None:
         IOProcessor.sel_inventory(update_controls[0])
     if update_controls is not None:
         # Needs work, cannot allow inventory to repopulate new data
         IOProcessor.sel_inventory(update_controls[0])
示例#4
0
    def sel_inventory(text_widget):
        inventory = []
        pp = DP.InventoryProcessor('Python210FinalDB.db')
        sql = pp.build_sel_code()
        for row in pp.execute_sql_code(sql):
            inventory.append(DM.Inventory(row[0], row[1]))
        pp.db_con.commit()
        pp.db_con.close()

        text_widget['state'] = 'normal'
        text_widget.delete(1.0, tk.END)

        if inventory is None:
            text_widget.insert("No data available")

        if inventory is not None:
            text_widget.insert(tk.END, "InventoryID | InventoryDate\n")
            for row in inventory:
                text_widget.insert(tk.END, str(row) + "\n")
        text_widget['state'] = 'disabled'
示例#5
0
    def sel_inventory(text_widget):
        inventory = []
        ip = dp.InventoryProcessor(database)
        sql = ip.build_sel_code()
        for row in ip.execute_sql_code(sql):
            inventory.append(dm.Inventory(row[0], row[1]))
        ip.db_con.commit()
        ip.db_con.close()

        text_widget['state'] = 'normal'
        text_widget.delete(1.0, tk.END)

        if inventory is None:
            text_widget.insert("No data available")
        else:
            text_widget.insert(tk.END, "InventoryID,InventoryDate\n")
            for row in inventory:
                print(row, type(row))
                text_widget.insert(tk.END, str(row) + "\n")

        text_widget['state'] = 'disabled'