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


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 from user u
        INNER JOIN city c ON u.city_id =
        WHERE c.designation=upper('fantasy') 
        AND 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 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.

res = executeSql(sql)
print res

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


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.

12/28/2011 3:18:16 PM

You have to give %% to use it as % because % in python is use as string formatting so when you write single % its assume that you are going to replace some value with this.

So when you want to place single % in string with query allways place double %.

12/29/2011 10:08:47 AM

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow