Typeerror: 'dict' object cannot be interpreted as an integer

Question

0.00/5 (No votes)

See more:

I need to create a Custom Tkinter app with CTK table, I have an errored when I insert data. I want to insert the data at the end of each row of table, but I didn't know what is the row number should be. My code is as below:

What I have tried:

Python

def data_insert():
    # Read the data from the entry boxes
    my_name = name.get()
    my_class = class1.get()
    my_mark = mark1.get()
    my_gender = gender.get()
    my_address = address.get("1.0", "end")
    my_hostel = hostel.get()
    
    # verification of input
    varify = True
    if my_name == '' or my_class == ''  or my_address == '':
        CTkMessagebox(title="Error", message="All entries cann't leave blank", icon="cancel")
        varify = False
    
    else:
        varify = True
        
        # insert into SQLite
        sql = "INSERT INTO student_address (name, class, mark, gender, address, hostel) \
            VALUES(:name, :class, :mark, :gender, :address, :hostel)"
    
        my_data = {
             "name": my_name,
             "class": my_class,
             "mark": my_mark,
             "gender": my_gender,
             "address": my_address,
             "hostel": my_hostel,
        }
    
        with engine.connect() as my_conn:
            content = my_conn.execute(text(sql), my_data)
            
            my_conn.commit()
        
            table.add_row(END, my_data)
        # print(my_data)
            clear_entries()

Error incurred

TypeError: 'dict' object cannot be interpreted as an integer

Posted 2-Apr-24 21:55pm

Member 15783420

Add a Solution

3 solutions

Solution 1

You shouldn't need to specify END in add_row. As far as I can tell, from the documentation, you should be able to do this to add the data to the end.

Python

table.add_row(my_data)

Having looked at your code, you're trying to add a dictionary to something that's expecting a list. Do this instead:

Python

table.add_row([my_name, my_class, my_mark, my_gender, my_address, my_hostel])

Posted 2-Apr-24 22:30pm

Pete O'Hanlon

Updated 2-Apr-24 22:45pm

v2

Comments

Member 15783420 3-Apr-24 4:37am

File "/home/runner/CTK-CRUD1/.pythonlibs/lib/python3.11/site-packages/customtkinter/windows/widgets/ctk_button.py", line 554, in _clicked
self._command()
File "/home/runner/CTK-CRUD1/main.py", line 61, in data_insert
table.add_row(my_data)
File "/home/runner/CTK-CRUD1/.pythonlibs/lib/python3.11/site-packages/CTkTable/ctktable.py", line 238, in add_row
self.draw_table(**kwargs)
File "/home/runner/CTK-CRUD1/.pythonlibs/lib/python3.11/site-packages/CTkTable/ctktable.py", line 119, in draw_table
value = self.values[i][j]
~~~~~~~~~~~~~~^^^
KeyError: 0

Solution 3

row_id = content.lastrowid
new_row_values = [row_id, my_name, my_class, my_mark,
                  my_gender, my_hostel, my_address]
table.add_row(new_row_values)

Posted 3-Apr-24 13:01pm

Member 15783420

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2024-04-02T22:55:00

You have your parameters in the wrong order in the call to add_row as shown in the source code at CTkTable/CTkTable/ctktable.py at main · Akascape/CTkTable · GitHub[^]:

Python

table.add_row(END, my_data)

The data dictionary must be the first parameter, thus:

Python

table.add_row(my_data, END)

I also noticed that the documentation at CTkTable · PyPI[^] has the parameters the wrong way round.

Typeerror: 'dict' object cannot be interpreted as an integer

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us