summaryrefslogtreecommitdiff
path: root/test/dialect/mysql.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2008-08-24 21:20:05 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2008-08-24 21:20:05 +0000
commitae573e047a696c3c80d11e56466c9f55b72e0461 (patch)
tree7da54e41f789fc5dea306894d94eca6acd851d37 /test/dialect/mysql.py
parent4c29ed71d0f6ff656da4a04437097c290122f75c (diff)
downloadsqlalchemy-ae573e047a696c3c80d11e56466c9f55b72e0461.tar.gz
- Added MSMediumInteger type [ticket:1146].
Diffstat (limited to 'test/dialect/mysql.py')
-rw-r--r--test/dialect/mysql.py15
1 files changed, 15 insertions, 0 deletions
diff --git a/test/dialect/mysql.py b/test/dialect/mysql.py
index 2c944fd3a..5a03ffa98 100644
--- a/test/dialect/mysql.py
+++ b/test/dialect/mysql.py
@@ -24,6 +24,7 @@ class TypesTest(TestBase, AssertsExecutionResults):
Column('num3', mysql.MSBigInteger()),
Column('num4', mysql.MSDouble),
Column('num5', mysql.MSDouble()),
+ Column('num6', mysql.MSMediumInteger),
Column('enum1', mysql.MSEnum("'black'", "'white'")),
Column('enum2', mysql.MSEnum("dog", "cat")),
)
@@ -40,6 +41,7 @@ class TypesTest(TestBase, AssertsExecutionResults):
assert isinstance(t2.c.num3.type, mysql.MSBigInteger)
assert isinstance(t2.c.num4.type, mysql.MSDouble)
assert isinstance(t2.c.num5.type, mysql.MSDouble)
+ assert isinstance(t2.c.num6.type, mysql.MSMediumInteger)
assert isinstance(t2.c.enum1.type, mysql.MSEnum)
assert isinstance(t2.c.enum2.type, mysql.MSEnum)
t2.drop()
@@ -136,6 +138,17 @@ class TypesTest(TestBase, AssertsExecutionResults):
(mysql.MSBigInteger, [4], {'zerofill':True, 'unsigned':True},
'BIGINT(4) UNSIGNED ZEROFILL'),
+ (mysql.MSMediumInteger, [], {},
+ 'MEDIUMINT'),
+ (mysql.MSMediumInteger, [4], {},
+ 'MEDIUMINT(4)'),
+ (mysql.MSMediumInteger, [4], {'unsigned':True},
+ 'MEDIUMINT(4) UNSIGNED'),
+ (mysql.MSMediumInteger, [4], {'zerofill':True},
+ 'MEDIUMINT(4) ZEROFILL'),
+ (mysql.MSMediumInteger, [4], {'zerofill':True, 'unsigned':True},
+ 'MEDIUMINT(4) UNSIGNED ZEROFILL'),
+
(mysql.MSTinyInteger, [], {},
'TINYINT'),
(mysql.MSTinyInteger, [1], {},
@@ -662,6 +675,8 @@ class TypesTest(TestBase, AssertsExecutionResults):
( SmallInteger(), mysql.MSSmallInteger(4), ),
( mysql.MSSmallInteger(), ),
( mysql.MSSmallInteger(4), mysql.MSSmallInteger(4), ),
+ ( mysql.MSMediumInteger(), mysql.MSMediumInteger(), ),
+ ( mysql.MSMediumInteger(8), mysql.MSMediumInteger(8), ),
( Binary(3), mysql.MSBlob(3), ),
( Binary(), mysql.MSBlob() ),
( mysql.MSBinary(3), mysql.MSBinary(3), ),