def test_convert_dttm(self): dttm = self.get_dttm() self.assertEqual(BigQueryEngineSpec.convert_dttm("DATE", dttm), "CAST('2019-01-02' AS DATE)") self.assertEqual( BigQueryEngineSpec.convert_dttm("DATETIME", dttm), "CAST('2019-01-02T03:04:05.678900' AS DATETIME)", ) self.assertEqual( BigQueryEngineSpec.convert_dttm("TIMESTAMP", dttm), "CAST('2019-01-02T03:04:05.678900' AS TIMESTAMP)", )
def test_convert_dttm(self): dttm = self.get_dttm() test_cases = { "DATE": "CAST('2019-01-02' AS DATE)", "DATETIME": "CAST('2019-01-02T03:04:05.678900' AS DATETIME)", "TIMESTAMP": "CAST('2019-01-02T03:04:05.678900' AS TIMESTAMP)", } for target_type, expected in test_cases.items(): actual = BigQueryEngineSpec.convert_dttm(target_type, dttm) self.assertEqual(actual, expected)
def test_convert_dttm(self): """ DB Eng Specs (bigquery): Test conversion to date time """ dttm = self.get_dttm() test_cases = { "DATE": "CAST('2019-01-02' AS DATE)", "DATETIME": "CAST('2019-01-02T03:04:05.678900' AS DATETIME)", "TIMESTAMP": "CAST('2019-01-02T03:04:05.678900' AS TIMESTAMP)", "TIME": "CAST('03:04:05.678900' AS TIME)", "UNKNOWNTYPE": None, } for target_type, expected in test_cases.items(): actual = BigQueryEngineSpec.convert_dttm(target_type, dttm) self.assertEqual(actual, expected)