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;
+--------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| comp_type_id | int(11) | NO | | NULL | |
| active_status_code | varchar(1) | NO | | NULL | |
| title | varchar(255) | NO | | NULL | |
| duration | varchar(10) | NO | | NULL | |
| release_date | date | YES | | NULL | |
| seq_number | int(11) | NO | MUL | NULL | |
| amg_id | varchar(255) | NO | | | |
| isrc | varchar(12) | NO | | | |
| parental_advisory | tinyint(1) | NO | | 0 | |
| item_number | int(11) | NO | | 0 | |
| comp_code | varchar(255) | NO | | | |
| cover_art | tinyint(1) | NO | | 0 | |
| disk_number | int(11) | NO | | 0 | |
| label_id | int(11) | NO | | 0 | |
| muze_id | varchar(255) | NO | | | |
| upc | varchar(255) | NO | | | |
+--------------------+--------------+------+-----+---------+-------+
from sqlalchemy.schema import MetaData
credentials = {...}
url = "mysql://{user}:{password}@{host}/{database}".format(**credentials)
metadata = MetaData(url)
metadata.reflect()
for column in metadata.tables['component'].columns:
print "%s: %s %s" % (column.name, column.type, column.default)
prints:
id: INTEGER(11) None
comp_type_id: INTEGER(11) None
active_status_code: VARCHAR(1) None
title: VARCHAR(255) None
duration: VARCHAR(10) None
release_date: DATE None
seq_number: INTEGER(11) None
amg_id: VARCHAR(255) None
isrc: VARCHAR(12) None
parental_advisory: TINYINT(1) None
item_number: INTEGER(11) None
comp_code: VARCHAR(255) None
cover_art: TINYINT(1) None
disk_number: INTEGER(11) None
label_id: INTEGER(11) None
muze_id: VARCHAR(255) None
upc: VARCHAR(255) None
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
