[sqlalchemy] Geo query support in SqlAlchemy

2017-02-21 Thread Guy Zehavi
I am using Python 3.3 with sqlalchemy using a MySql 5.6.33 Database with SQLAlchemy 1.1.5. I know that mysql supports Geo data types, but I was unable to find the equivalent in sqlalchemy in the docs. I did see GeoAlchemy and GeoAlchemy2 but GeoAlchemy is not for Python 3 and I am not using a

[sqlalchemy] How to Assign Blob Field?

2019-06-18 Thread Guy Zehavi
When I use sqlalchemy using mysql-connector-python to read unicode from a blob I am getting: Error closing cursorUnicodeDecodeError: 'utf-8' codec can't decode byte 0x9a in position 3: invalid start byte Now, I can solve this by doing , connect_args={'use_pure': True} to the create_engine.

[sqlalchemy] Re: How to Assign Blob Field?

2019-06-18 Thread Guy Zehavi
Just as a note, the full stack trace is: Error closing cursorUnicodeDecodeError: 'utf-8' codec can't decode byte 0x9a in position 3: invalid start byte During handling of the above exception, another exception occurred: Traceback (most recent call last): File