diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2010-10-20 17:44:35 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2010-10-20 17:44:35 -0400 |
| commit | f3c9c87a24a5b3e6da9a33702ceee433b01f4905 (patch) | |
| tree | 9eb2b3052200a4b105cfc1b8fbe33d2d86d6efca /test/dialect/test_mysql.py | |
| parent | 60197fb0f4adc738a5f73a85d9c996b1259ea9e1 (diff) | |
| download | sqlalchemy-f3c9c87a24a5b3e6da9a33702ceee433b01f4905.tar.gz | |
- Fixed mysql bug involving reflection of CURRENT_TIMESTAMP
default used with ON UPDATE clause, thanks to
Taavi Burns [ticket:1940]
Diffstat (limited to 'test/dialect/test_mysql.py')
| -rw-r--r-- | test/dialect/test_mysql.py | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/test/dialect/test_mysql.py b/test/dialect/test_mysql.py index 7c4cc2309..78e1b9ab0 100644 --- a/test/dialect/test_mysql.py +++ b/test/dialect/test_mysql.py @@ -763,6 +763,9 @@ class ReflectionTest(TestBase, AssertsExecutionResults): Column('c4', TIMESTAMP, DefaultClause('2009-04-05 12:00:00' )), Column('c5', TIMESTAMP), + Column('c6', TIMESTAMP, + DefaultClause(sql.text("CURRENT_TIMESTAMP " + "ON UPDATE CURRENT_TIMESTAMP"))), ) def_table.create() try: @@ -780,6 +783,13 @@ class ReflectionTest(TestBase, AssertsExecutionResults): assert str(reflected.c.c3.server_default.arg) == "'abc'" assert str(reflected.c.c4.server_default.arg) \ == "'2009-04-05 12:00:00'" + assert reflected.c.c5.default is None + assert reflected.c.c5.server_default is None + assert reflected.c.c6.default is None + eq_( + str(reflected.c.c6.server_default.arg).upper(), + "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" + ) reflected.create() try: reflected2 = Table('mysql_def', MetaData(testing.db), @@ -791,6 +801,13 @@ class ReflectionTest(TestBase, AssertsExecutionResults): assert str(reflected2.c.c3.server_default.arg) == "'abc'" assert str(reflected2.c.c4.server_default.arg) \ == "'2009-04-05 12:00:00'" + assert reflected.c.c5.default is None + assert reflected.c.c5.server_default is None + assert reflected.c.c6.default is None + eq_( + str(reflected.c.c6.server_default.arg).upper(), + "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" + ) def test_reflection_with_table_options(self): comment = r"""Comment types type speedily ' " \ '' Fun!""" |