CODEWITHSUNDEEP
pythonsqlpostgresql
nlr25
nlr25

Reputation: 1635

TypeError: 'int' object does not support indexing

I have this query:

some_id = 1

cursor.execute('
    SELECT "Indicator"."indicator" 
    FROM "Indicator" 
    WHERE "Indicator"."some_id" =   %s;', some_id)

I get the following error: 

TypeError: 'int' object does not support indexing

some_id is an int but I'd like to select indicators that have some_id = 1 (or whatever # I decide to put in the variable).

Upvotes: 60

Views: 71214

Answers (7)

Malayaj Laad
Malayaj Laad

Reputation: 1

Specify the vars= argument that might work:

cursor.execute("
          SELECT "Indicator"."indicator" 
          FROM "Indicator" 
          WHERE "Indicator"."some_id" = %s', vars=[id] )

Upvotes: -2

H.asadi
H.asadi

Reputation: 19

I had the same problem and it worked when I used normal formatting.

cursor.execute(f'
    SELECT "Indicator"."indicator" 
    FROM "Indicator" 
    WHERE "Indicator"."some_id" ={some_id};')

Upvotes: -1

Ankit Singh Gulia
Ankit Singh Gulia

Reputation: 1

Pass parameter into a list, which is indexable.

cur.execute("select * from tableA where id =%s",[parameter])

Upvotes: -2

jmunsch
jmunsch

Reputation: 24089

Slightly similar error when using Django:

TypeError: 'RelatedManager' object does not support indexing

This doesn't work

mystery_obj[0].id

This works:

mystery_obj.all()[0].id

Basically, the error reads Some type xyz doesn't have an __ iter __ or __next__ or next function, so it's not next(), or itsnot[indexable], or iter(itsnot), in this case the arguments to cursor.execute would need to implement iteration, most commonly a List, Tuple, or less commonly an Array, or some custom iterator implementation.

In this specific case the error happens when the classic string interpolation goes to fill the %s, %d, %b string formatters.

Related:

Upvotes: -1

pmcnamee
pmcnamee

Reputation: 477

Your id needs to be some sort of iterable for mogrify to understand the input, here's the relevant quote from the frequently asked questions documentation:

>>> cur.execute("INSERT INTO foo VALUES (%s)", "bar")    # WRONG
>>> cur.execute("INSERT INTO foo VALUES (%s)", ("bar"))  # WRONG
>>> cur.execute("INSERT INTO foo VALUES (%s)", ("bar",)) # correct
>>> cur.execute("INSERT INTO foo VALUES (%s)", ["bar"])  # correct

This should work:

some_id = 1

cursor.execute('
    SELECT "Indicator"."indicator" 
    FROM "Indicator" 
    WHERE "Indicator"."some_id" =   %s;', (some_id, ))

Upvotes: 15

Stephan
Stephan

Reputation: 17981

cursor.execute('
    SELECT "Indicator"."indicator" 
    FROM "Indicator" 
    WHERE "Indicator"."some_id" =   %s;', [some_id])

This turns the some_id parameter into a list, which is indexable. Assuming your method works like i think it does, this should work.

The error is happening because somewhere in that method, it is probably trying to iterate over that input, or index directly into it. Possibly like this: some_id[0]

By making it a list (or iterable), you allow it to index into the first element like that.

You could also make it into a tuple by doing this: (some_id,) which has the advantage of being immutable.

Upvotes: 81

alecxe
alecxe

Reputation: 473903

You should pass query parameters to execute() as a tuple (an iterable, strictly speaking), (some_id,) instead of some_id:

cursor.execute('
    SELECT "Indicator"."indicator" 
    FROM "Indicator" 
    WHERE "Indicator"."some_id" =   %s;', (some_id,))

Upvotes: 46

Related Questions