def test_time_types(self):
specs = []
if testing.requires.mysql_fsp.enabled:
fsps = [None, 0, 5]
else:
fsps = [None]
for type_ in (mysql.TIMESTAMP, mysql.DATETIME, mysql.TIME):
# MySQL defaults fsp to 0, and if 0 does not report it.
# we don't actually render 0 right now in DDL but even if we do,
# it comes back blank
for fsp in fsps:
if fsp:
specs.append((type_(fsp=fsp), type_(fsp=fsp)))
else:
specs.append((type_(), type_()))
specs.extend([
(TIMESTAMP(), mysql.TIMESTAMP()),
(DateTime(), mysql.DATETIME()),
])
# note 'timezone' should always be None on both
self._run_test(specs, ['fsp', 'timezone'])
def test_datetime_fsp(self):
self.assert_compile(mysql.DATETIME(fsp=4), "DATETIME(4)")
def test_datetime_generic(self):
self.assert_compile(mysql.DATETIME(), "DATETIME")