nzpy and pyodbc dialects doesn't work properly with sqlalchemy version 1.4.x

[shabbir10july]

Some testcases fails with nzpy and pyodbc dialects when using sqlalchemy version 1.4.x

[ArVar]

More precisely:

import nzpy

def creator():
    return nzpy.connect(user="admin", password="password",host='localhost', port=5480, database="db1", securityLevel=0,logOptions=nzpy.LogOptions.Logfile, char_varchar_encoding='utf8')

engine = create_engine("netezza+nzpy://", creator=creator)

throws Can't load plugin: sqlalchemy.dialects:netezza.nzpy for SQLalchemy 1.4

[MAFiA303]

bump

[arebryne]

bump

[MAFiA303]

It's been a while since I used this, my suggestion is to use turnodbc instead of nzpy. The performance is at least 10 times faster