[sqlalchemy] Routing Session and query count problem

2014-10-15 Thread Jeff Oliver
I've got a problem with SQLAlchemy 0.9.8 with a Routing Session setup and using the query count method. I started from this post on Mike Bayer's blog: http://techspot.zzzeek.org/2012/01/11/django-style-database-routers-in-sqlalchemy/ I did some tweaks such that I could specify the database

[sqlalchemy] MutableDict.as_mutable(PickleType) blobs and mysqldump

2014-10-15 Thread YKdvd
I've got a SQLAlchemy model something like this: class MyUserl(AlchemyBase): ... webPrefs = Column(MutableDict.as_mutable(PickleType) ) which runs against a MySQL 5.5.31 (Debian) database table: CREATE TABLE myUserTable ( ... `webPrefs` blob DEFAULT NULL, ENGINE=`InnoDB` DEFAULT CHARACTER SET