[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 eng

Re: [sqlalchemy] Routing Session and query count problem

2014-10-15 Thread Michael Bayer
On Oct 15, 2014, at 5:17 PM, Jeff Oliver wrote: > 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/ >

[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 u

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

2014-10-15 Thread Michael Bayer
no clue. I'd try stack overflow, take out the SQLAlchemy details and just ask about the binary safety of MySQL dumps. On Oct 15, 2014, at 10:11 PM, YKdvd wrote: > I've got a SQLAlchemy model something like this: > > class MyUserl(AlchemyBase): > ... > webPrefs = Column(MutableDict.as_

[sqlalchemy] SQLAlchemy training

2014-10-15 Thread erikj
Hi, We're organizing a 1 day training on using databases with Python and using SQLAlchemy. The training will be on November 5, and will take place at our offices in Belgium. More info can be found here : http://www.conceptive.be/training.html If you or a colleague are interested, feel free to