[sqlalchemy] How to discover column defaults?

2013-03-25 Thread Roy Smith
Server version: 5.1.63-log MySQL Community Server (GPL) SQLAlchemy==0.8.0 I've got a table which has defaults on some columns. When I discover the table, I get the column names and types, but not the defaults. What am I doing wrong? mysql describe component;

Re: [sqlalchemy] How to discover column defaults?

2013-03-25 Thread Roy Smith
in set (0.01 sec) On Mar 25, 2013, at 12:57 PM, Roy Smith r...@panix.com wrote: Server

Re: [sqlalchemy] How to discover column defaults?

2013-03-25 Thread Roy Smith
if column.server_default else None) On Mar 25, 2013, at 1:57 PM, Roy Smith r...@panix.com wrote: On Mar 25, 2013, at 1:20 PM, Michael Bayer wrote: MySQL reflects from the SHOW CREATE TABLE output, what does that say in this case ? mysql show create table