def test_convert_dttm(self): dttm = self.get_dttm() self.assertEqual( MssqlEngineSpec.convert_dttm("DATE", dttm), "CONVERT(DATE, '2019-01-02', 23)", ) self.assertEqual( MssqlEngineSpec.convert_dttm("DATETIME", dttm), "CONVERT(DATETIME, '2019-01-02T03:04:05.678', 126)", ) self.assertEqual( MssqlEngineSpec.convert_dttm("SMALLDATETIME", dttm), "CONVERT(SMALLDATETIME, '2019-01-02 03:04:05', 20)", )
def test_convert_dttm( actual: str, expected: str, dttm: datetime, ) -> None: from superset.db_engine_specs.mssql import MssqlEngineSpec assert MssqlEngineSpec.convert_dttm(actual, dttm) == expected
def test_convert_dttm(self): dttm = self.get_dttm() test_cases = ( ( MssqlEngineSpec.convert_dttm("DATE", dttm), "CONVERT(DATE, '2019-01-02', 23)", ), ( MssqlEngineSpec.convert_dttm("DATETIME", dttm), "CONVERT(DATETIME, '2019-01-02T03:04:05.678', 126)", ), ( MssqlEngineSpec.convert_dttm("SMALLDATETIME", dttm), "CONVERT(SMALLDATETIME, '2019-01-02 03:04:05', 20)", ), ) for actual, expected in test_cases: self.assertEqual(actual, expected)