Hi,
I have a BLOB column in a mysql table. If I reflect this table
sqlalchemy uses sqlalchemy.databases.mysql.MSBinary. All well and good,
except I'd like some way of coercing it to sqlalchemy.types.PickleType.
The model I was hoping to use was:
- offline tool specifies / manages the schema.
- runtime app *always* reflects and doesn't pull in the table definitions in any other way.
Because I don't necessarily want to manage the full schema description in sqlalchemy.
If I do this, and because the sqlalchemy bits of the schema are using
PickleType for BLOB columns in the offline tool, I fall victim of
"TypeError: array item must be char" when I bind parameters for the
BLOB collumns in the runtime. Reflection, of course, can't infer BLOB
means PickleType without some hint from me. Is there a clean way to
pass such a hint in ?
Simply pulling the table definitions into the run time and *not* reflecting works find but this is a little disatisfactory.
Cheers,
Robin
- [Sqlalchemy-users] is there a way to coerce the type of col... Robin Bryce
- Re: [Sqlalchemy-users] is there a way to coerce the ty... Michael Bayer
- Re: [Sqlalchemy-users] is there a way to coerce th... Jonathan Ellis
- Re: [Sqlalchemy-users] is there a way to coerc... Michael Bayer
- Re: [Sqlalchemy-users] is there a way to coerce th... Robin Bryce