Updating a Table by using Sqlite3 Module in Python

Question

I am working on a project where i need to update the password column of a user table pointing userid as the primary key, whenever the user reset his/her password. I am passing username and password to update_table function based on the values entered by the user from console and below is my code snippet -

def sql_update_table(conn, username, reset_password):
    c = conn.cursor()
    #value = (username, reset_password)
    #c.execute('''UPDATE user SET password = ? WHERE userid = ? ''', value)
    c.execute('''UPDATE user SET password = reset_password WHERE userid = username''')
    conn.commit()

I tried both case passing values with a tuple as mentioned in # and directly as mentioned without a #. However, for first case, there is no error but the table is not getting updated with the new value of password and for later one i am getting below error -

sqlite3.OperationalError: no such column: reset_password

Please help me to solve this. Thanks in advance !

Does this answer your question? python + sqlite, insert data from variables into table — Chase
– Chase, Commented Aug 12, 2020 at 10:02

Bindu · Accepted Answer · 2020-08-12 10:10:01Z

0

Can you please try replacing

c.execute('''UPDATE user SET password = reset_password WHERE userid = username''')

with

c.execute('''UPDATE user SET password = ? WHERE userid = ? ''', (username,reset_password))

answered Aug 12, 2020 at 10:10

Bindu

295 bronze badges

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

4 Comments

Sameer Ranjan Sahoo Over a year ago

Thank you Bindu for your reply. However, I have tried that as well as below. Table is not getting updated. value = (username, reset_password) c.execute('''UPDATE user SET password = ? WHERE userid = ? ''', value)

Sameer Ranjan Sahoo Over a year ago

while printing value, i am getting the updated values in a Tuple format but not sure why its not getting updated in Table

Bindu Over a year ago

@SameerRanjanSahoo value should be enclosed in parenthesis. please give a try with this c.execute('''UPDATE user SET password = ? WHERE userid = ? ''', (username,reset_password))

Sameer Ranjan Sahoo Over a year ago

Ok, I have tried. Got same result as before. Table is not updated.

Collectives™ on Stack Overflow

Updating a Table by using Sqlite3 Module in Python

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related