有的时候需要使用一些数据库特有的字段类型
比如在MySQL下,可以这样做
from sqlalchemy.databases import mysql
xxxxx_table = Table ('xxxxx', metaData,
Column('id', Integer, primary_key=True),
Column(colA, mysql.MSMediumText),
Column('colB', mysql.MSSet("'foo'", "'bar'", "'baz'")),
mysql_engine='InnoDB'
)
xxxxx_table = Table ('xxxxx', metaData,
Column('id', Integer, primary_key=True),
Column(colA, mysql.MSMediumText),
Column('colB', mysql.MSSet("'foo'", "'bar'", "'baz'")),
mysql_engine='InnoDB'
)
参看
http://www.sqlalchemy.org/docs/04/sqlalchemy_databases_mysql.html