Skip to content
This repository has been archived by the owner on Mar 24, 2022. It is now read-only.

% in query #8

Open
lukeorland opened this issue Apr 25, 2018 · 1 comment
Open

% in query #8

lukeorland opened this issue Apr 25, 2018 · 1 comment

Comments

@lukeorland
Copy link

lukeorland commented Apr 25, 2018

Would it be possible for sql_magic to automatically run the SQL string through sqlalchemy.text(), or do we need to replace any instance of % in a regular SQL statement with %%?

For reference:

https://stackoverflow.com/questions/8657508/strange-sqlalchemy-error-message-typeerror-dict-object-does-not-support-inde

@crawles
Copy link
Contributor

crawles commented May 18, 2018

are you using postgres? use psycopg2 instead - see #7 (comment) and you shouldn't have an issue. will look into sqlalchemy.text() - should be pretty straight forward

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants