I am having problems
select_item = tree_frame.selection()[0]
IndexError: tuple index out of range
I have an employee table, I am trying to delete a record from the table, but when I select a record for 1st time it is working fine but while I'm trying to delete another record then it is throwing an error.
import tkinter as tk
from tkinter import ttk
from datetime import datetime,date
from tkinter import messagebox as msg
from tkinter import *
import sys
import time
from tkcalendar import DateEntry
from PIL import ImageTk,Image
import mysql.connector
def show_all_emp():
delete_page()
emp_data_frame = Frame(main_frame, width=1450, height=720, highlightbackground='black', highlightthickness=1)
emp_data_frame.place(x=1, y=30)
# update button
update_selected_button = Button(main_frame, text="Update Selected Row", bg="#bb44db", fg="white", width=30,font=('Times', 10, 'bold'), command=lambda: update_data(tree_frame))
update_selected_button.place(x=50, y=1)
# Delete button
delete_selected_button = Button(main_frame, text="Delete Selected Row", bg="#bb44db", fg="white", width=30, font=('Times', 10, 'bold'),command= lambda : delete_data(tree_frame))
delete_selected_button.place(x=300, y=1)
# searching part according to degination choose
filter_enter = ttk.Combobox(main_frame, state="readonly", textvariable=filter_var)
filter_enter['values'] = ('all_emp', 'Director', 'Manager', 'Employee')
filter_enter.current(0)
filter_enter.place(x=1220, y=4)
filter_var.trace('w', filter_match_show)
#__________________________________________________
tree_frame = ttk.Treeview(emp_data_frame)
tree_frame.place(x=1, y=1, width=1350, height=670)
s.configure('Treeview', rowheight=40)
# remove unwanted parameter
tree_frame['show'] = 'headings'
# define number of columns
tree_frame["columns"] = ('Employee Name','user_id', 'password', 'emp. type','report to','doj','start_date','end_date','dob','email', 'Address','Action')
# assigning the width for column
tree_frame.column('Employee Name', anchor=tk.CENTER)
tree_frame.column('user_id', anchor=tk.CENTER)
tree_frame.column('password', anchor=tk.CENTER)
tree_frame.column('emp. type', anchor=tk.CENTER)
tree_frame.column('report to', anchor=tk.CENTER)
tree_frame.column('doj', anchor=tk.CENTER)
tree_frame.column('start_date', anchor=tk.CENTER)
tree_frame.column('end_date', anchor=tk.CENTER)
tree_frame.column('dob', anchor=tk.CENTER)
tree_frame.column('email', anchor=tk.CENTER)
tree_frame.column('Address', anchor=tk.CENTER)
tree_frame.column('Action', anchor=tk.CENTER)
# assigning heading name representive column
tree_frame.heading('Employee Name', text="EMPLOYEE NAME", anchor=tk.CENTER)
tree_frame.heading('user_id', text="USER_ID", anchor=tk.CENTER)
tree_frame.heading('password', text="PASSWORD", anchor=tk.CENTER)
tree_frame.heading('emp. type', text="EMP. TYPE", anchor=tk.CENTER)
tree_frame.heading('report to', text="REPORT TO", anchor=tk.CENTER)
tree_frame.heading('doj', text="DOJ", anchor=tk.CENTER)
tree_frame.heading('start_date', text="START DATE", anchor=tk.CENTER)
tree_frame.heading('end_date', text="END DATE", anchor=tk.CENTER)
tree_frame.heading('dob', text="DOB", anchor=tk.CENTER)
tree_frame.heading('email', text="EMAIL", anchor=tk.CENTER)
tree_frame.heading('Address', text="ADDRESS", anchor=tk.CENTER)
tree_frame.heading('Action', text="ACTION", anchor=tk.CENTER)
tree_frame.tag_configure('grey', background='yellow')
tree_frame.tag_configure('black', background='white')
my_tag = 'yellow' # first row
cn = mysql.connector.connect(database="HRMS_PROJECT", user="root", password="root", host="localhost")
cur = cn.cursor()
q = 'SELECT * FROM Director_table UNION SELECT * FROM manager_table UNION SELECT * FROM emp_table;'
cur.execute(q)
records = cur.fetchall()
for i, (emp_name,user_id,password, emp_type,report_to, doj,start_date,end_date,dob, email,address) in enumerate(records, start=1):
my_tag = 'grey' if my_tag == 'yellow' else 'yellow' # condition for row color
tree_frame.insert("", "end", values=(emp_name,user_id , password, emp_type,report_to, doj,start_date,end_date,dob, email,address ),tags=(my_tag))
cn.close()
# creating vertical scrollbar
vsb = ttk.Scrollbar(emp_data_frame, orient="vertical")
vsb.configure(command=tree_frame.yview)
tree_frame.configure(yscrollcommand=vsb.set)
vsb.place(x=1353, y=1, height=670)
# creating horizontal scrollbar
hsb = ttk.Scrollbar(emp_data_frame, orient="horizontal")
hsb.configure(command=tree_frame.xview)
tree_frame.configure(xscrollcommand=hsb.set)
hsb.place(x=1, y=672, width=1350)
def delete_data(tree_frame):
# select_item= tree_frame.selection()[0]
# print(select_item,type(select_item))
select_item=tree_frame.selection()[0]
print(len(select_item),(select_item),type(select_item))
uid=tree_frame.item(select_item)['values'][1]
print(uid)
tbl=''
type_of_emp=tree_frame.item(select_item)['values'][3]
print(type_of_emp)
if type_of_emp == 'Employee':
tbl='emp_table'
elif type_of_emp == 'Manager':
tbl='manager_table'
elif type_of_emp =='Director':
tbl='director_table'
del_query=f'delete from {tbl} where user_id=%s'
sel_data=(user_id,)
print(sel_data)
cn = mysql.connector.connect(database="HRMS_PROJECT", user="root", password="root", host='localhost')
cur = cn.cursor()
def del_data():
ans=msg.askyesno('Delete Record',' Are you sure!!!')
if ans == True :
cur.execute(del_query, sel_data)
cur.close()
cn.commit()
tree_frame.delete(select_item)
msg.showinfo('Deleted', 'Employee has been Deleted Sucessfully!!!')
cn.close()
show_all_emp()
elif ans== False:
show_all_emp()
print(select_item)
del_data()
As the error says, you try to access the first item in an empty tuple which is returned by tree_frame.selection() when there is no item is selected in the treeview.
You need to check whether the tuple is empty or not before proceeding:
def delete_data(tree_frame):
selection = tree_frame.selection()
if selection:
# there is item selected
select_item = selection[0]
...