Variable Placeholders: 'tuple' object has no attribute 'keys'

Question

I have read a similar issue (AttributeError: 'tuple' object has no attribute 'keys') and Psycopg's official documentation on placeholders for variables, but I am still getting stuck on what seems to be a most simple query. Sorry for asking this , but what's wrong with the various iterations I have tried?

    cur.execute('''
    UPDATE scrape_log 
    SET date_added=%s, result_count=%s 
    WHERE start_date=%s AND end_date=%s
    ''', date_scraped, result_count, start_date, end_date)

It returned AttributeError: 'tuple' object has no attribute 'keys'.

I also tried the following, but it returned the same error.

    cur.execute('''
    UPDATE scrape_log 
    SET VALUES (%s, %s)
    WHERE start_date=(%s) AND end_date=(%s)
    ''', (date_scraped, result_count), (start_date,), (end_date,))

What did I do wrong?

score 0 · Accepted Answer · edited Jan 13 '21 at 20:06

0

Try this:

   cur.execute('''
    UPDATE scrape_log 
    SET date_added=%s, result_count=%s 
    WHERE start_date=%s AND end_date=%s
    ''', (date_scraped, result_count, start_date, end_date))

edited Jan 13 '21 at 20:06

Enlico

23,259
6
48
102

answered Jun 22 '20 at 22:11

Bjarni Ragnarsson

1,731
1
6
8

Oh yes, this is one of the many I've tried. It returns the same error, for some reason. – Louis Jun 22 '20 at 22:47
Ah, I found an issue with one of the variables; fixed it and now it works. Thanks! – Louis Jun 22 '20 at 23:00

score 0 · Answer 2 · answered Jun 22 '20 at 22:12

0

Parameters should be enclosed in a tuple, so try this:

cur.execute('''
    UPDATE scrape_log 
    SET date_added=%s, result_count=%s 
    WHERE start_date=%s AND end_date=%s
    ''', (date_scraped, result_count, start_date, end_date))

answered Jun 22 '20 at 22:12

szrg

79
5

I thought it was the issue, but still doesn't work. – Louis Jun 22 '20 at 22:47
Ah, I found an issue with one of the variables; fixed it and now it works. Thanks! – Louis Jun 22 '20 at 23:00

score 0 · Answer 3 · answered Jun 22 '20 at 22:20

0

 query = """ UPDATE books
                SET title = %s
                WHERE id = %s """

    data = (title, book_id)

 cursor = conn.cursor()
        cursor.execute(query, data)

answered Jun 22 '20 at 22:20

Aldair Leon

21
1

This would be a better answer if you explained how the code you provided answers the question. – pppery Jun 23 '20 at 00:21

score 0 · Answer 4 · answered Jun 22 '20 at 22:24

0

Using your query is something lije this

query = "UPDATE scrape_log SET date_added=%s, result_count=%s 
    WHERE start_date=%s AND end_date=%s"

  cur.execute(query, (date_scraped, result_count, start_date, end_date,))

answered Jun 22 '20 at 22:24

Aldair Leon

21
1

Variable Placeholders: 'tuple' object has no attribute 'keys'

4 Answers4