MySQL column types incorrect for MSLongText, MSMediumText etc

Certain special column types do not appear to be generated correctly with MySQL. The following program demonstrates this:

########################################################################
#
#    SQLAlchemy + MySQL - test of special column types
#
########################################################################

import sqlalchemy
import sqlalchemy.databases.mysql

# please substitute appropriate local user:password values
database_url = 'mysql://user:password@localhost:3306/test'

db = sqlalchemy.create_engine(database_url)
db.echo = True
metadata = sqlalchemy.BoundMetaData(db)

# acquire the MS* names from the sqlalchemy.databases.mysql module
msnames = [for name in dir(sqlalchemy.databases.mysql) if name.startswith('MS')](name)
msclasses = [name) for name in msnames](getattr(sqlalchemy.databases.mysql,)
msinstances = [for msclass in msclasses](msclass())

# report the expected column types]
for msinstance in msinstances :
    print 'For class', msinstance.__class__.__name__, 'expected SQL type is', msinstance.get_col_spec()

# generate the column arguments
arguments = [msinstance)
             for msinstance in msinstances](sqlalchemy.Column(msinstance.__class__.__name__,)

# create the table              
emails_table = \
        sqlalchemy.Table('emails', metadata,
                         sqlalchemy.Column('email_id', sqlalchemy.Integer, primary_key=True),
                         *arguments
    )

emails_table.drop(checkfirst = True)
emails_table.create(checkfirst = True)

# visually compare expected and actual column types
# discrepancies are detected for:
# MSBigInteger
# MSDecimal
# MSDouble
# MSEnum
# MSLongText
# MSMediumText
#-----------------------------------

Comments (7)