Python MssqlEngineSpec.convert_dttm Exemples

Exemple #1

    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)",
        )

Exemple #2

Fichier : test_mssql.py Projet : aliavni/incubator-superset

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

Exemple #3

Fichier : mssql_tests.py Projet : finecatmeow/superset

    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)