Strange SQLAlchemy error message: TypeError: “dict” object does not support indexing

Michael Zippo

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I am using hand crafted SQL to fetch data from a PG database, using SqlAlchemy. I am trying a query which contains the SQL like operator "%" and that seems to throw SqlAlcjhemy through a loop:

sql = """
       SELECT DISTINCT u.name from user u
        INNER JOIN city c ON u.city_id = c.id
        WHERE c.designation=upper("fantasy") 
        AND c.id IN (select id from ref_geog where short_name LIKE "%opt")
      """

# The last line in the above statement throws the error mentioned in the title. 
# However if the last line is change to:
# AND c.id IN (select id from ref_geog where short_name = "helloopt")
# the script runs correctly.
#
# I also tried double escaping the "%" i.e. using "%%" instead - that generated the same error as previously.

connectDb()
res = executeSql(sql)
print res
closeDbConnection()

Any one knows what is causing this misleading error message and how I may fix it?

[[Edit]]

Before any one asks, there is nothing special or fancy about the functions included above. For example the function executeSql() simply invokes conn.execute(sql) and returns the results. The variable conn is simply the previously established connection to the database.

👻 Read also: what is the best laptop for engineering students?

We hope this article has helped you to resolve the problem. Apart from Strange SQLAlchemy error message: TypeError: “dict” object does not support indexing, check other ast Python module-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

Walter Schteiner

London | 2023-03-22

Thanks for explaining! I was stuck with Strange SQLAlchemy error message: TypeError: “dict” object does not support indexing for some hours, finally got it done 🤗. I just hope that will not emerge anymore

Dmitry Innsbruck

Berlin | 2023-03-22

I was preparing for my coding interview, thanks for clarifying this - Strange SQLAlchemy error message: TypeError: “dict” object does not support indexing in Python is not the simplest one. Will use it in my bachelor thesis

Julia Chamberlet

Milan | 2023-03-22

dis Python module is always a bit confusing 😭 Strange SQLAlchemy error message: TypeError: “dict” object does not support indexing is not the only problem I encountered. I just hope that will not emerge anymore