stacklevel for SAWarning about Unicode types

[Domen Kožar]

When passing strings to a Unicode type, sqlalchemy complains: lib/python2.7/site-packages/SQLAlchemy-0.8.0-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py:455: SAWarning: Unicode type received non-unicode bind param value.

Those warnings are hard to debug. Changing stacklevel to 17 reports the stack correctly, but I'm not sure if stacklevel is dynamic.

[Mike Bayer]

im not sure what the magic is for these stacklevels, we've had to change them a lot. Any suggestions ?

[Domen Kožar]

Since it's 17 stacks, it probably changes quickly and there might be multiple paths to get to that warning. No idea how to do that dynamically, Googling doesn't reveal much.

[jvanasco]

Adding this for Search Equity:

This seems to be a variation of this wontfix ticket from 2008:

• https://bitbucket.org/zzzeek/sqlalchemy/issue/1219/apply-notes-to-bind-parameters-or

Some relevant threads from the groups on this

• https://groups.google.com/forum/#!topic/sqlalchemy/YfEqLE8NGts
• https://groups.google.com/d/topic/sqlalchemy/SZEHGeiKWSk/discussion
• https://groups.google.com/d/topic/sqlalchemy/xdVbJur7K5o/discussion