Issue executing SQL file with SQLAlchemy engine - using % in a like condition

Question

I'm using a simple Python function to run a SQL file (still using Python 2.7).

Relevant parts of the function used:

sql_query = read_file(file_path)
engine = sqlalchemy.create_engine(connection)
engine.execute(sql_query)

When running, I get this error

TypeError: 'dict' object does not support indexing

and in the SQL query, I am using a condition of LIKE '%abc%'. Is there any way to solve this without having to change my SQL query?

Thanks

Schwern · Accepted Answer · 2020-05-04 19:41:35Z

2

Use Textual SQL to tell SQLAlchemy to treat the string as raw SQL.

from sqlalchemy.sql import text

sql_query = read_file(file_path)
engine = sqlalchemy.create_engine(connection)
engine.execute(text(sql_query))

answered May 4, 2020 at 19:41

Schwern

167k28 gold badges226 silver badges371 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1