0
cur.execute(""" 
            CREATE TEMPORARY VIEW bobby_view AS
            SELECT heading1, heading2
            FROM bobby 
            WHERE heading2 = %s; """, (variable,))


            cur.execute("""
            SELECT d1.heading1
            FROM bobby_view d1
            WHERE d1.heading1 >= ALL (
                SELECT d2.heading1
                FROM bobby_view d2);
            """) 
            
            answer = cur.fetchone()[0]

This produces the error:

TypeError: 'NoneType' object is not subscriptable

This is the structure of my code. Variable was an integer entered as a parameter to a function and it has been casted as a string prior to the above code.

The second block of code finds the heading1 data that is the highest. I've tested this on its own and I am fairly confident it works. Because of this, I think the error comes from variable not being used in the view properly. Any help or advice would be greatly appreciated.

Ravi Makwana
  • 2,782
  • 1
  • 29
  • 41
stanleepippen
  • 1

2 Answers2

0

you can refer the documentation here

fetchone returns the next row of a query result set and returns a single sequence, or None if no more rows are available, so if you are fetching the last row the error will occur. Try something like this,

answer = cur.fetchone()
while answer is not None:
  print(answer)
  answer = cur.fetchone()
Marcus.Aurelianus
  • 1,520
  • 10
  • 22
0

Try:

cur.execute("""
        SELECT d1.heading1
        FROM bobby_view d1
        WHERE d1.heading1 >= ALL (
            SELECT d2.heading1
            FROM bobby_view d2);
        """) 
        
        answer = cur.fetchone()
        answer = answer[0] of answer else 'default'
BattleFox
  • 1
  • 2
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 07 '22 at 11:04