Added tests for new error message on bad date/time values from MSSQL; changed messages slightly to be more testable.pr/206

1 files changed, 24 insertions, 0 deletions

diff --git a/test/dialect/mssql/test_types.py b/test/dialect/mssql/test_types.py
index 1c5c22aee..7a908720a 100644
--- a/test/dialect/mssql/test_types.py
+++ b/test/dialect/mssql/test_types.py
@@ -33,6 +33,18 @@ class TimeTypeTest(fixtures.TestBase):
         result_processor = mssql_time_type.result_processor(None, None)
         eq_(expected, result_processor(value))
 
+    def test_result_processor_invalid(self):
+        mssql_time_type = TIME()
+        result_processor = mssql_time_type.result_processor(None, None)
+        ex = None
+        bogus_value = 'abc'
+        try:
+            result_processor(bogus_value)
+        except Exception as caught:
+            ex = str(caught)
+        expected = 'could not parse value ' + bogus_value + ' as a TIME'
+        eq_(expected, ex)
+
 
 class MSDateTypeTest(fixtures.TestBase):
 
@@ -45,6 +57,18 @@ class MSDateTypeTest(fixtures.TestBase):
         result_processor = mssql_date_type.result_processor(None, None)
         eq_(expected, result_processor(value))
 
+    def test_result_processor_invalid(self):
+        mssql_date_type = _MSDate()
+        result_processor = mssql_date_type.result_processor(None, None)
+        ex = None
+        bogus_value = 'abc'
+        try:
+            result_processor(bogus_value)
+        except Exception as caught:
+            ex = str(caught)
+        expected = 'could not parse value ' + bogus_value + ' as a _MSDate'
+        eq_(expected, ex)
+
 
 class TypeDDLTest(fixtures.TestBase):