Delete from treeview in tkinter

huangapple
go评论95阅读模式
英文:

Delete from treeview in tkinter

问题

这是您要翻译的代码部分：

  1. def delete(self):
  2.     selected_item = self.record_list.selection()
  3.     if selected_item:
  4.         item_code = self.record_list.item(selected_item)["text"]
  5.         db = sql.connect('record.db')
  6.         curs = db.cursor()
  7.         curs.execute("DELETE FROM tb_transfers WHERE code=?", (item_code,))
  8.         db.commit()
  9.         db.close()
  10.         self.record_list_refresh()
  11.         self.total_label_refresh()
  12.         self.withdraw_label_refresh()
  13.         self.deposit_label_refresh()

这部分代码是用于删除所选项目的函数，当您点击删除按钮时，它会从 SQLite 中删除相应的记录。

英文: 
  1. import tkinter as tk
  2. from tkinter import ttk
  3. import sqlite3 as sql
  5. class main_window:
  6.     def __init__(self, window):
  7.         self.wind = window
  8.         self.wind.geometry('700x550')
  9.         self.wind.resizable(0, 0)
  10.         self.wind.title('Transfer Record')
  11.         self.wind.iconbitmap('icon.ico')
  12.         self.draw()
  13.         self.record_list_refresh()
  15.     def draw(self):
  16.         data_entry = tk.LabelFrame(self.wind, text= 'Data Entry', bd= 5)
  17.         data_entry.pack(padx= 2, pady= 2, anchor= 'center')
  19.         tk.Label(data_entry, text= 'Description:').grid(row= 0, column= 0)
  20.         self.description = tk.Entry(data_entry, width= 30)
  21.         self.description.grid(row= 1, column= 0, padx= 25)                                       #Description entry
  23.         tk.Label(data_entry, text= 'Kind:').grid(row= 0, column= 1)
  24.         self.kind = ttk.Combobox(data_entry, state= 'readonly')                                                                                #Combobox kind
  25.         self.kind['values'] = ('Deposit', 'Withdrawn')   
  26.         self.kind.current(0)                                                                         
  27.         self.kind.grid(row= 1, column= 1, padx= 25)
  29.         tk.Label(data_entry, text= 'Amount').grid(row= 0, column= 2)
  30.         self.amount = tk.Entry(data_entry)
  31.         self.amount.grid(row= 1, column= 2, padx= 25)                                            #Amount entry
  33.         tk.Button(data_entry, text= 'Add', height= 2, width= 8, bd= 3, command= self.save).grid(row= 0, column= 3, padx= 5, pady= 4)
  34.         tk.Button(data_entry, text= 'Delete', height= 2, width= 8, bd= 3, command= self.delete).grid(row= 1, column= 3, padx= 5, pady= 4)                       #Save button
  36.         transfer_record = tk.LabelFrame(self.wind, text= 'Transfer Record', bd= 5)
  37.         transfer_record.pack(padx= 1, pady= 1, anchor= 'center')
  39.         self.record_list = ttk.Treeview(transfer_record, columns= ('Kind', 'Description', 'Amount'), height= 15)
  40.         self.record_list.column('#0', width= 80, anchor= 'center')
  41.         self.record_list.heading('#0', text= 'Code')
  42.         self.record_list.column('Description', width= 300, anchor= 'center')
  43.         self.record_list.heading('Description', text= 'Description')
  44.         self.record_list.column('Kind', width= 125, anchor= 'center')
  45.         self.record_list.heading('Kind', text= 'Kind')
  46.         self.record_list.column('Amount', width= 80, anchor= 'center')
  47.         self.record_list.heading('Amount', text= 'Amount')
  48.         self.record_list.pack(padx= 5,pady= 4)
  50.         self.totals = tk.LabelFrame(self.wind, text= 'TOTALS', bd= 5)
  51.         self.totals.pack(padx= 1, pady= 1, anchor= 'center')
  53.         self.label_deposit = tk.Label(self.totals, text= '')
  54.         self.label_deposit.pack(side= 'left', padx= 2, pady= 2)
  55.         self.deposit_label_refresh()
  57.         self.label_withdrawn = tk.Label(self.totals, text= '')
  58.         self.label_withdrawn.pack(side= 'left', padx= 200, pady= 2)
  59.         self.withdraw_label_refresh()
  61.         self.label_total= tk.Label(self.totals, text= '')
  62.         self.label_total.pack(side= 'left', padx= 2, pady= 2)
  63.         self.total_label_refresh()
  65.     def record_list_refresh(self):
  66.         self.description.delete(0, tk.END)
  67.         self.amount.delete(0, tk.END)
  68.         for item in self.record_list.get_children():
  69.             self.record_list.delete(item)
  70.         db = sql.connect('record.db')
  71.         curs = db.cursor()
  73.         data = curs.execute("SELECT * FROM tb_transfers")
  74.         data = data.fetchall()
  75.         for code, description, kind, amount in data:
  76.             self.record_list.insert('', tk.END, text= code, values= (description, kind, amount))
  78.         db.commit()
  79.         db.close()
  81.     def deposit_label_refresh(self):
  82.         db = sql.connect('record.db')
  83.         curs = db.cursor()
  85.         deposits = curs.execute("Select amount FROM tb_transfers WHERE kind= 'Deposit'")
  86.         deposits = list(deposits.fetchall())
  87.         deposits_list = []
  88.         for deposit in deposits:
  89.             for depo in deposit:
  90.                 deposits_list.append(depo)
  91.         total_deposits = sum(deposits_list)
  92.         total_deposits = str(total_deposits)
  94.         db.commit()
  95.         db.close()
  96.         
  97.         self.label_deposit.configure(text= 'Deposit: $' + total_deposits)
  98.     
  99.     def withdraw_label_refresh(self):
  100.         db = sql.connect('record.db')
  101.         curs = db.cursor()
  103.         withdraws = curs.execute("Select amount FROM tb_transfers WHERE kind= 'Withdrawn'")
  104.         withdraws = list(withdraws.fetchall())
  105.         withdraws_list = []
  106.         for withdraw in withdraws:
  107.             for withd in withdraw:
  108.                 withdraws_list.append(withd)
  109.         total_withdraws = sum(withdraws_list)
  110.         total_withdraws = str(total_withdraws)
  112.         db.commit()
  113.         db.close()
  114.         
  115.         self.label_withdrawn.configure(text= 'TOTAL: $' + total_withdraws)
  116.     
  117.     def total_label_refresh(self):
  118.         db = sql.connect('record.db')
  119.         curs = db.cursor()
  121.         deposits = curs.execute("Select amount FROM tb_transfers WHERE kind= 'Deposit'")
  122.         deposits = list(deposits.fetchall())
  123.         deposits_list = []
  124.         for deposit in deposits:
  125.             for depo in deposit:
  126.                 deposits_list.append(depo)
  127.         total_deposits = sum(deposits_list)
  129.         withdraws = curs.execute("Select amount FROM tb_transfers WHERE kind= 'Withdrawn'")
  130.         withdraws = list(withdraws.fetchall())
  131.         withdraws_list = []
  132.         for withdraw in withdraws:
  133.             for withd in withdraw:
  134.                 withdraws_list.append(withd)
  135.         total_withdraws = sum(withdraws_list)
  137.         total_totals = total_deposits - total_withdraws
  138.         total_totals = str(total_totals)
  140.         db.commit()
  141.         db.close()
  142.         
  143.         self.label_total.configure(text= 'TOTAL: $' + total_totals)
  145.     def save(self):
  146.         db = sql.connect('record.db')
  147.         curs = db.cursor()
  148.         curs.execute("INSERT INTO tb_transfers(description, kind, amount) VALUES(?, ?, ?)", (self.description.get(), self.kind.get(), self.amount.get()))
  149.         db.commit()
  150.         db.close()
  151.         self.record_list_refresh()
  152.         self.total_label_refresh()
  153.         self.withdraw_label_refresh()
  154.         self.deposit_label_refresh()
  156.     def delete(self):
  157.         
  159. obj_main_window = main_window(tk.Tk())
  160. obj_main_window.wind.mainloop()

the idea is delete the selected item from the sqlite when i press the delete button.

答案1

得分: 0

You can get the selected code using Treeview.focus() and Treeview.item():

  1. def delete(self):
  2.     selected = self.record_list.focus()  # item selected?
  3.     if selected:
  4.         # 获取所选项的 'code'
  5.         code = self.record_list.item(selected, "text")
  6.         # 从 sqlite 表中删除记录
  7.         db = sql.connect("record.db")
  8.         cur = db.cursor()
  9.         cur.execute("DELETE FROM tb_transfers WHERE code = ?", (code,))
  10.         db.commit()
  11.         db.close()
  12.         # 更新 GUI
  13.         self.record_list_refresh()
  14.         self.total_label_refresh()
  15.         self.withdraw_label_refresh()
  16.         self.deposit_label_refresh()
英文:

You can get the selected code using Treeview.focus() and Treevew.item():

  1. def delete(self):
  2.     selected = self.record_list.focus()  # item selected?
  3.     if selected:
  4.         # get the 'code' of selected item
  5.         code = self.record_list.item(selected, "text")
  6.         # remove record from sqlite table
  7.         db = sql.connect("record.db")
  8.         cur = db.cursor()
  9.         cur.execute("DELETE FROM tb_transfers WHERE code = ?", (code,))
  10.         db.commit()
  11.         db.close()
  12.         # update GUI
  13.         self.record_list_refresh()
  14.         self.total_label_refresh()
  15.         self.withdraw_label_refresh()
  16.         self.deposit_label_refresh()

huangapple
  • 本文由 发表于 2023年5月11日 01:08:59
  • 转载请务必保留本文链接：https://go.coder-hub.com/76220999.html
  • python
  • sqlite
  • tkinter
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定