有的时候需要使用一些数据库特有的字段类型
比如在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