[sqlalchemy] How do I patch SQLAlchemy declarative model dynamically with Columns of different type?

2012-05-12 Thread gostones
I am running mysql in production but would like to run a simple tests in a sqlite in memory db. The legacy mysql db has tables with columns that are mysql specific types, Which are declared in declarative models (subclassing declarative_base). I would like to run some simple tests without going

[sqlalchemy] Web-framework+db with the widest scalability?

2012-05-12 Thread Alec Taylor
Disclosure: I have posted this on stackoverflowhttp://stackoverflow.com/q/10562165and comp.lang.pythonhttps://groups.google.com/forum/#%21topic/comp.lang.python/gSAw5mLkUos . I am building a project requiring high performance and scalability, entailing: - Role-based

[sqlalchemy] Getting comparison TypeError when trying to commit aware datetime when previous value was naive datetime

2012-05-12 Thread Steve Zatz
When I try to commit a timezone aware datetime to replace a value that was previously timezone naive, I get a TypeError when I try to do the commit with the message: TypeError: can't compare offset-naive and offset-aware datetimes Now I am not trying to compare anything but just store the new