Esempi in Python per MssqlEngineSpec.get_timestamp_expr

Esempio n. 1

def test_time_exp_mixd_case_col_1y(app_context: AppContext) -> None:
    from superset.db_engine_specs.mssql import MssqlEngineSpec

    col = column("MixedCase")
    expr = MssqlEngineSpec.get_timestamp_expr(col, None, "P1Y")
    result = str(expr.compile(None, dialect=mssql.dialect()))
    assert result == "DATEADD(YEAR, DATEDIFF(YEAR, 0, [MixedCase]), 0)"

Esempio n. 2

File: mssql_tests.py Progetto: finecatmeow/superset

 def test_time_exp_mixd_case_col_1y(self):
     col = column("MixedCase")
     expr = MssqlEngineSpec.get_timestamp_expr(col, None, "P1Y")
     result = str(expr.compile(None, dialect=mssql.dialect()))
     self.assertEqual(result,
                      "DATEADD(year, DATEDIFF(year, 0, [MixedCase]), 0)")

Esempio n. 3

 def test_mssql_time_expression_mixed_case_column_1y_grain(self):
     col = column('MixedCase')
     expr = MssqlEngineSpec.get_timestamp_expr(col, None, 'P1Y')
     result = str(expr.compile(dialect=mssql.dialect()))
     self.assertEqual(result,
                      'DATEADD(year, DATEDIFF(year, 0, [MixedCase]), 0)')