How to insert variable to database table sqlite3 - Python

Question

Whenever i try to run the following code i get an error saying that theres no such column "title_data", im really confused because "TITLE" is the column not "title_data"

def insertData(self):
    title_Data = self.edit_title.text()
    year_Data = self.edit_year.text()
    rating_Data = self.edit_rating.text()


    connection = sqlite3.connect('films.db')
    try:
        connection.execute("INSERT INTO FILMS (TITLE,YEAR,RATING) VALUES(title_Data,year_Data,rating_Data)")


    except sqlite3.IntegrityError:
        print("You have already stored this data")
    connection.commit()
    connection.close()

asongtoruin · Accepted Answer · 2017-06-21 14:20:15Z

2

You're not passing your variables correctly. Instead of

connection.execute("INSERT INTO FILMS (TITLE,YEAR,RATING) VALUES(title_Data,year_Data,rating_Data)")

You should use

connection.execute("INSERT INTO FILMS (TITLE,YEAR,RATING) VALUES(?,?,?)", (title_Data,year_Data,rating_Data))

See the docs for execute() for more information.

answered Jun 21, 2017 at 14:20

asongtoruin

10.4k3 gold badges42 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Noob Over a year ago

Thank you very much , im relatively new to sqlite3 thank you.

asongtoruin Over a year ago

@Noob that's ok! If this helped you, you can mark it as the answer and/or vote it up using the buttons on the left of it.

Noob Over a year ago

Could you help me out with one more thing?

asongtoruin Over a year ago

@Noob Is it related? If so, yes. If not, you might need to open another question.

Noob Over a year ago

its part of the same program but not this question. Ill open another question.

Collectives™ on Stack Overflow

How to insert variable to database table sqlite3 - Python

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related