def test_oracle_sqla_column_name_length_exceeded(self): col = column('This_Is_32_Character_Column_Name') label = OracleEngineSpec.make_label_compatible(col.name) self.assertEqual(label.quote, True) label_expected = '3b26974078683be078219674eeb8f5' self.assertEqual(label, label_expected)
def test_oracle_time_expression_reserved_keyword_1m_grain(self): col = column('decimal') expr = OracleEngineSpec.get_timestamp_expr(col, None, 'P1M') result = str(expr.compile(dialect=oracle.dialect())) self.assertEqual(result, "TRUNC(CAST(\"decimal\" as DATE), 'MONTH')")