Python SQL statement with variables, using psycopg2 library

Question

 cur.execute('UPDATE newslib SET (keyword1) = %s WHERE id= %s' % m_k1,row[0])

I use psycopg2 to execute this SQL statement. m_k1 and row[0] are two variables I want to pass into the statement.

This triggers the following error message:

TypeError: not enough arguments for format string

I’ve been looking for solutions online, but I can’t fix it.

Burhan Khalid · Accepted Answer · 2014-02-08 05:08:41Z

2

You need to pass the substitutions as arguments to execute. The way you have it written now you have specified two place holders, but did not provide their values, instead you are parsing them in the query itself.

cur.execute('UPDATE newslib SET (keyword1) = %s WHERE id= %s' , (m_k1,row[0],))

answered Feb 8, 2014 at 5:08

Burhan Khalid

175k20 gold badges254 silver badges291 bronze badges

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

Comments

falsetru · Accepted Answer · 2014-02-08 05:07:58Z

2

Pass the parameter as a sequence (instead of multiple individual values). And use parameters argument instead of formatting sql yourself.

cur.execute('UPDATE newslib SET (keyword1) = %s WHERE id= %s', [m_k1,row[0]])
#                                                            ^^^^^^^^^^^^^^^

See Cursor.execute

answered Feb 8, 2014 at 5:07

falsetru

371k69 gold badges769 silver badges659 bronze badges

Collectives™ on Stack Overflow

Python SQL statement with variables, using psycopg2 library

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related