Updating data in a database in python

Question

So i need to update data in a database but im getting an error i dont understand. What i have is this

def update_account_balance(db, number, account, change):

con =  sqlite3.connect(db)
cur = con.cursor()

cur.execute('UPDATE Accounts SET (?) = (?) WHERE Number == (?)', [account, change, number])

and what im getting is:

Traceback (most recent call last):
  Python Shell, prompt 2, line 1
  File "/Users/aharonsnyder1/Desktop/assignment 2/banking.py", line 168, in <module>
    cur.execute('UPDATE Accounts SET (?) = (?) WHERE Number == (?)', [account, change, number])
sqlite3.OperationalError: near "(": syntax error

I am not sure what it is not liking.

Parfait · Accepted Answer · 2015-12-04 04:05:33Z

3

Several things:

SQL syntax does not use the double equal sign
SQLite uses either quotes, backticks, or square brackets to denote keywords.
Only parameters usually in WHERE clauses are passed in the second argument not the structural component of the SQL statement like column name.

Consider revising where you format update statement string with column name (assuming column name is the value in account variable) and then pass parameters:

cur.execute('UPDATE Accounts \
                SET [{0}] = ? \
              WHERE Number = ?'.format(account), (change, number))

answered Dec 4, 2015 at 4:05

Parfait

108k19 gold badges102 silver badges138 bronze badges

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

Comments

GAVD · Accepted Answer · 2015-12-04 03:43:42Z

1

Maybe this works

cur.execute('UPDATE Accounts SET (?) = (?) WHERE Number == (?)', (account, change, number))

answered Dec 4, 2015 at 3:43

GAVD

2,1343 gold badges24 silver badges44 bronze badges

Collectives™ on Stack Overflow

Updating data in a database in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related