Python TypeError: not all arguments converted during string formatting, while passing parameter to a PostgreSQL query

Question

I know this question have been asked before but any of the answers was helpful for me, I am using Basic module(psycopg2) in python trying to pass an external parameter row[1] into a Postgres Query which is:

 print row[1], type(row[1])

630776863141535744 <type 'str'>

when I run the following code I face TypeError: not all arguments converted during string formatting

for row in rows:
   t=row[1]
   PSQL1="SELECT occorrenza.tag from occorrenza where tweet=%s and tag in ( select pk_tag from hashtag where isentity=FALSE);"
   c.execute(PSQL1,t)

also I have tried the following code and have the same error :

for row in rows:
    c.execute("SELECT occorrenza.tag from occorrenza where tweet=%s and tag in ( select pk_tag from hashtag where isentity=FALSE);",row[1])

I have changed many other parts like putting '%s'instead of %s but I still have error!

alecxe · Accepted Answer · 2016-01-17 19:37:28Z

2

The second parameter to execute() should be a tuple in your case:

for row in rows:
    c.execute("SELECT occorrenza.tag from occorrenza where tweet=%s and tag in ( select pk_tag from hashtag where isentity=FALSE);", (row[1], ))

answered Jan 17, 2016 at 19:37

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

2 Comments

Łukasz Rogalski Over a year ago

Also, query should be parametrised with ?, not with %s as in string firmatting.

alecxe Over a year ago

@Rogalski nope, %s is correct, proof: initd.org/psycopg/docs/…. Thanks.

Collectives™ on Stack Overflow

Python TypeError: not all arguments converted during string formatting, while passing parameter to a PostgreSQL query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related