コード例 #1
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'
コード例 #2
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'