[sqlalchemy] Re: mysql 'timestamp default current_timestamp on update current_timestamp' doesn't reflect() properly

2010-10-08 Thread goo...@venix.com
On Oct 7, 9:21 pm, Taavi Burns taavi.bu...@gmail.com wrote: We use reflection to generate base declarative class definitions of our tables, and I'm working on porting from SQLAlchemy 0.5 to 0.6. TIMESTAMP column reflection was quite a bit fishy in 0.5, and is overall better in 0.6.  Still, I

[sqlalchemy] Re: mysql 'timestamp default current_timestamp on update current_timestamp' doesn't reflect() properly

2010-10-08 Thread goo...@venix.com
On Oct 8, 10:48 am, Taavi Burns taavi.bu...@gmail.com wrote: On Oct 8, 9:58 am, goo...@venix.com goo...@venix.com wrote: http://www.google.com/url?sa=Dq=http://groups.google.com/group/sqlal... I had grumbled that mapping tinyint(1) to bool was an issue for people who were simply trying

[sqlalchemy] Re: DB Redundancy

2009-05-09 Thread goo...@venix.com
On May 8, 7:53 am, Ants Aasma ants.aa...@gmail.com wrote: On May 7, 4:15 pm, goo...@venix.com goo...@venix.com wrote: MySQL has a mechanism for a database to read the log from a master database and replay the commands.  This provides a loose coupling with near real-time backup

[sqlalchemy] Re: DB Redundancy

2009-05-07 Thread goo...@venix.com
On May 6, 3:43 am, Ants Aasma ants.aa...@gmail.com wrote: On May 6, 9:07 am, Vic vctr...@gmail.com wrote: I'm looking for a way to have my DB replicated in REAL TIME to be used in case I lose my primary copy. I saw that the two phase commit exist but I'm not sure if that is the correct

[sqlalchemy] Re: Convert type from dbapi description

2009-01-01 Thread goo...@venix.com
On Dec 31 2008, 4:00 pm, Dusty Phillips buch...@gmail.com wrote: Hi there, I've been searching all over for a solution to this and have concluded that I must be doing it all wrong. I need to create a simple view of an arbitrary sql query result that includes the column names and types as